Data Analysis with Python for Excel Users - Full Course

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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.