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

This course teaches learners how to use Python and Pandas for data analysis, focusing on creating pivot tables, working with data, and making visualizations using Python, Pandas, and Jupyter Notebook. The course covers topics such as Python basics, Pandas introduction, dataframe manipulation, pivot tables, and data visualization techniques. The intended audience for this course are individuals with experience in Excel looking to transition to using Python for data analysis.

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.