TUTORIAL / Ryan S McCoy / From Spreadsheets to DataFrames
Description:
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.