Do you know how to use Microsoft Excel and want to learn how to do data analysis with Python? You are in luck.

We just published a course on the YouTube channel that will teach you how to do Data Analysis with Python. This course will be especially helpful if you have experience with Excel, but that is not required.

Frank Andrade developed this course. Frank is a data scientist and excellent teacher.

In this course you will learn how to create pivot tables, work with data, and make visualizations using Python, Pandas, and Jupyter Notebook.

Here are all the topics you will learn about in this course:

  • 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

Watch the full course below or on the YouTube channel (4-hour watch).