Data Analysis with Python for Excel Users - Full Course

A full course that teaches Excel users to analyze data in Python, starting with installing Anaconda and working in Jupyter Notebook, then covering Python basics such as variables, lists, dictionaries, loops and functions. It then moves to pandas for creating and manipulating dataframes, building pivot tables, and producing line, bar and pie charts that can be saved and exported.

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.