Our career paths help you become job ready faster
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to transition from spreadsheets to Python DataFrames in this comprehensive tutorial. Explore the limitations of spreadsheets and discover the power of Python as a versatile programming language for complex data tasks. Map spreadsheet concepts to Python equivalents, including cells to variables, rows and columns to lists and dictionaries, and formulas to functions. Perform interactive exercises to calculate using Python instead of Excel. Dive into advanced data manipulation techniques, including web scraping, data processing, analysis, and visualization using popular libraries like Requests, Pandas, Flask, and Matplotlib. Gain insights into essential data management concepts such as tidy data and building data pipelines. Explore strategies and packages for tackling various data problems, including a demonstration of Apache Airflow. Access additional resources and code examples on GitHub to support your learning journey from spreadsheets to DataFrames.
Syllabus
TUTORIAL / Ryan S McCoy / From Spreadsheets to DataFrames
Taught by
PyCon US