Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

Data Analysis with Python for Excel Users - Full Course

via freeCodeCamp

Overview

Embark on a comprehensive 3-4 hour course designed to transition Excel users to Python-based data analysis. Master Python, Pandas, and Jupyter Notebook for creating pivot tables, manipulating data, and generating visualizations. Begin with Python basics, progress through Pandas fundamentals, and conclude with advanced pivot table techniques and data visualization. Gain hands-on experience using provided source code and datasets, while benefiting from a detailed syllabus covering everything from installation to exporting pivot tables. Enhance your data analysis skills with this practical, step-by-step guide tailored for Excel users looking to harness the power of Python.

Syllabus

) Intro.
) Install Python and Jupyter Notebook with Anaconda.
) Jupyter Notebook Interface.
) Cell Types and Cell Mode.
) Jupyter Notebook Shortcuts.
) Module 1 - Hello World.
) Data Type.
) Variables.
) Lists.
) Dictionaries.
) IF Statement.
) FOR Loop.
) Functions.
) Modules.
) Module 2 -Introduction to Pandas.
) How to create a dataframe.
) How to show a dataframe.
) Basic Attributes, Functions and Methods.
) Selecting One Column from a Dataframe.
) Selecting Two or More Columns from a Dataframe.
) Add New Column to a Dataframe (Simple Assignment).
) Operations in dataframes.
) The value_counts() method.
) Sort a DataFrame with the sort_values() method.
) Module 3: Introduction to Pivot Tables in Pandas.
) The pivot() method.
) The pivot_table() method.
) Data Visualization with Pandas (New Dataset + Pivot Table).
) Lineplot.
) Barplot.
) Piechart.
) Save Plot and Export Pivot Table.

Taught by

freeCodeCamp.org

Reviews

Start your review of Data Analysis with Python for Excel Users - Full Course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.