Master Data Analysis with Python

The most comprehensive course available to learn data analysis and visualization in Python. Get access to over 500 pages of text, 300 exercises, 13 hours of video, multiple projects, and detailed solutions.

Get Master Data Analysis with Python Now! ($99)

Become an Expert

Many other courses use poor practices to teach the data science libraries such as pandas, matplotlib, and seaborn. With Master Data Analysis with Python, you will be given the absolute best practices to use the libraries to help you rapidly transform into an expert.

Expert Instructor

Instructor Ted Petrou has taught more than 1,000 hours of live classes using this course. Each time he uses his experience to improve explanations and clarify results. Ted Petrou has become one of the foremost authorities on how to best use the python data science libraries.

Exercises and Projects

Reading texts or listening to lectures give the false impression of learning. To demonstrate learning, you must be able to complete tasks on your own. Master Data Analysis with Python comes with 300+ exercises and detailed solutions along with several longer and more complex projects.

Continuously Updated

The python data science libraries are in a state of flux with new additions added and other parts deprecated. Ted is very quick to update the course to reflect the newest changes to the libraries. This course will be continuously updated through at least 2020. You will have lifetime access to all the updates.

Master Data Analysis with Python contents

The course is divided into the following 10 parts. Each part can be considered its own mini-course with exercises and projects.

1. Environment Setup and Jupyter Notebooks

Before getting started analyzing data, you will learn how to setup a robust environment on your system to do data science. You will install the Miniconda distribution along with all the data science libraries used throughout the course.

You will also learn how to best use Jupyter Notebooks, our main tool for exploring data.

2. Intro to pandas

In Python, pandas is a popular and powerful library to explore, analyze, and visualize data. You will be introduced to the DataFrame and the Series, the two main containers of data within pandas. You will learn the components of these objects and a few basic operations. 

Intro to pandas is available to take for free and is bundled together with the next part, Selecting Subsets of Data.

Take Intro to pandas for free

3. Selecting Subsets of Data

One of the most common tasks during a data analysis is to select some subset of the data. In pandas, you can select data by row/column label or integer location as well as with conditional logic applied to the values. Although this is a rather simple task, pandas offers multiple ways to complete it, which causes confusion to the novice user.

In this part, you will be given very clear instruction on what are best practices for subset selection. You will also learn what methods of subset selection you should avoid.

Take Selecting Subsets of Data for free

4. Essential pandas Commands

This is a long part that covers the most essential pandas commands necessary to complete most data analyses. You'll begin by learning to how to operate on a single column of data, a pandas Series. You'll learn the difference between methods that aggregate (return a single value) and those that do not. Columns with strings or datetimes are processed differently than numeric columns. You'll learn how to access string-only and datetime-only operations to process those specific data types.

You'll then learn how to process multiple columns at the same time by calling methods on a DataFrame. You'll learn how to change the direction of the operations from vertical to horizontal. You'll learn the complete details of all the available data types.

Take Essential Pandas Commands ($15)

5. Grouping Data

Up to this point in the course, all operations were applied to the entire dataset. You will learn how to apply operations to independent groups within your data instead of the whole.

You will also learn how to display the results of grouping in a more human-readable way with pivot tables.

Grouping data can be tricky in pandas and has potential to be one of the slowest performing operations. You will learn best practices on how to optimize performance along with the newest syntax available.

6. Time Series

A time series is a sequence of data observed over a period of time. Each observation is labeled by a specific moment in time with the entire data. The entire set of observed data is ordered by its time component. You will learn how to sample time series data at evenly spaced intervals, operate over a rolling window of time, and group by any time period you desire.

7. Regular Expressions

Regular expressions are a miniature programming language on their own that help you match patterns within text. They can be extremely useful when combined with the pandas string-only methods to manipulate and analyze strings in almost any way.

8. Tidy Data

Tidy data is a structure of data that makes analysis easier. Often, it is necessary to rearrange, transform, and extract data so that it conforms to tidy data principles. You will learn how to tidy a variety of 'messy' data sets with the tools given to you by pandas.

9. Joining Data

In this part, you will learn how to work with multiple data sets together. You will learn how pandas implicitly uses automatic alignment of the index to combine datasets causing problems for the novice. You will also learn how to make SQL-like joins by interacting with a relational database.

10. Visualization

A good visualization can make for easier understanding and decision making. In this part, you will learn a straightforward approach to using the powerful, yet confusing library matplotlib. You will then learn how to plot data using pandas, before simplifying the process with the seaborn library.

This sounds amazing!

I am ready to begin my journey mastering data analysis with python!

About the Instructor

This course is taught by Ted Petrou, an expert at Python, data exploration and machine learning. Ted is the author of the highly rated text Pandas Cookbook. Ted has taught hundreds of students Python and data science during in-person classroom settings. He sees first hand exactly where students struggle and continually upgrades his material to minimize these struggles by providing simple and direct paths forward.

Ted is one of the foremost authorities on using the pandas library to do data analysis. His blog posts have totaled well over 1 million views. He is also a prolific contributor on Stack Overflow having answered over 400 questions.

Ted holds a master's degree in statistics from Rice University and is the author of Exercise Python and Master Machine Learning with Python.

Download the table of contents

Take a look at the titles of each chapter and section of Master Data Analysis with Python

Video Lessons

Video lessons for parts 2, 3, and 4 of Master Data Analysis have been produced. There are a total of 13 hours of video that cover nearly every section in the text. The following video is one of several dozen from the part Essential pandas Commands covering string Series methods.

 

Exercise Solution Videos

All exercises from the course are solved by Ted on video so that you can see exactly how he thinks through a problem. The following video shows exercise solutions from the second chapter of Essential pandas Commands.

 

What your purchase includes

You are purchasing a digital download along with access to all videos currently produced. The digital download includes the following:

  • 70+ Jupyter Notebook where you can read the text, complete exercises, and add notes.
  • 500+ page PDF of the text allowing you to search for specific content or read when not online.
  • Nearly 200 page PDF of the solutions to all exercises

"in my opinion what distinguishes you from everyone is your deep understanding of Python and Pandas. I follow lot of people on twitter, linkedin, Medium who share tips/tricks/codes on Python, Pandas, scikit-learn but no one comes close to you when writing efficient code and explaining the finer nuances"

Master Data Analysis with Python student

Prerequisites

Master Data Analysis assumes you already have a solid understanding of the fundamentals of Python. If you do not, you should master these fundamentals first. Exercise Python provides the necessary prerequisite knowledge.

This book assumes no knowledge of any of the Python data science libraries. Each part progresses slowly and thoroughly beginning with the basics. Advanced topics are covered towards the last chapters in each part.

Don't need the videos?

Purchase Master Data Analysis with Python without the videos.

Master Data Analysis with Python without videos ($49)
Close

50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.