
In this lecture, we'll learn about the course structure and the topics covered in the course. We'll also learn how to install the required packages.
In this lecture, we'll learn how to read data from different source formats into a Pandas DataFrame. We'll also learn how to read the data partially.
After completing this lecture, you'll be able to use functions and methods to explore a Pandas DataFrame in terms of shape, size, data types, and more.
Data types are very important as some functions and methods are only applicable to a particular data type. In this lecture, we'll learn how to manage data types properly.
In this lecture, we'll learn how to do column operations such as creating new columns, dropping existing ones, and more.
In this lecture, we'll learn how to work with dates and times with Pandas.
Textual data is everywhere! In this lecture, we'll learn how to clean, modify, and analyze textual data with Pandas.
In this lecture, we'll learn how to work with categorical data with Pandas.
In this lecture, we'll learn how to find missing values in a DataFrame and different ways of handling them.
In this lecture, we'll learn the loc and iloc methods and how to used them for filtering data.
In this lecture, we'll learn the functions and methods that can be used for filtering Pandas DataFrames.
This lecture explains how to combine and concatenate Pandas DataFrames.
In this lecture, we'll learn how to merge DataFrames, which involves combining data from different sources by using shared columns.
In this lecture, we'll learn different ways of changing the shape of Pandas DataFrames.
In this lecture, we'll learn several functions and methods that can be used for analyzing and extracting insights from data in Pandas DataFrames.
In this lecture, we'll learn how to create basic data visualization types with Pandas for exploratory data analysis.
In this lecture, we'll learn how to analyze and manipulate time series data with Pandas.
In this lecture, we'll take a raw dataset and convert it into a clean format that is ready-to-use for downstream processes and analytics.
In this lecture, we'll take a raw dataset and convert it into a clean format that is ready-to-use for downstream processes and analytics.
In this lecture, we'll learn how to use Python dictionaries to enhance the power of Pandas functions.
In this lecture, we'll learn how to create pipelines that involves multiple sequential steps of data cleaning and preprocessing.
In this lecture, we'll learn how to integrate visual components to Pandas DataFrames using the style property.
In this lecture, we'll learn Pandas functions that are not frequently used but come in handy for some tasks.
Who is this course for?
This course is for those who plan to take a step into the field of data science and beginner to intermediate level data analyst, data scientist, and data engineers.
Most of the exercises are based on my experience of working as a data scientist with real-life datasets so you can benefit from this course even if you are already using Pandas at your job. If you have never used Pandas before or have little experience, you can learn a lot because the exercises are created in a way that is simple and easy-to-understand. All you need is a basic level of Python knowledge.
What is needed to take this course?
Lectures are structured as me going over Jupyter notebooks explaining exercises. Notebooks can be found in the description of each lecture. If you want to download the notebooks and follow along, make sure you also download the relevant datasets available in the data folder in the course repository.
You also need to have Jupyter notebook installed on your computer. You can also Google Colab, which allows for running Jupyter notebooks in your browser for free.
Course structure
The course is divided into 6 chapters:
Introduction
Data exploration and manipulation
Data filtering
Combining DataFrames
Data analysis and visualization
Use cases
More learnings
Each chapter contains multiple lectures with each one focusing on a particular task such as how to filter a DataFrame, how to create pipelines with multiple steps, and how to use Python dictionaries to enhance the power of Pandas functions.
By the time you finish this course, you'll have solved at least 500 exercises and you'll be able to solve most of the tasks related to tabular data.