Finance Certifications Goldman Sachs & Amazon Teams Trust
Get 20% off all career paths from fullstack to AI
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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