Course Overview
** Newly recorded in 2026 for the release of Pandas 3 **
Student Testimonials:
The instructor knows the material, and has detailed explanation on every topic he discusses. Has clarity too, and warns students of potential pitfalls. He has a very logical explanation, and it is easy to follow him. I highly recommend this class, and would look into taking a new class from him. - Diana
This is excellent, and I cannot complement the instructor enough. Extremely clear, relevant, and high quality - with helpful practical tips and advice. Would recommend this to anyone wanting to learn pandas. Lessons are well constructed. I'm actually surprised at how well done this is. I don't give many 5 stars, but this has earned it so far. - Michael
This course is very thorough, clear, and well thought out. This is the best Udemy course I have taken thus far. (This is my third course.) The instruction is excellent! - James
Welcome to the most comprehensive Pandas course available on Udemy! An excellent choice for both beginners and experts looking to expand their knowledge on one of the most popular Python libraries in the world! This course has been re-recorded from scratch in 2026 for the release of Pandas 3.
Data Analysis with Pandas and Python offers 19+ hours of in-depth video tutorials on the most powerful data analysis toolkit available today. Lessons include:
installing
sorting
filtering
grouping
aggregating
de-duplicating
pivoting
munging
deleting
merging
visualizing
and more!
Why learn pandas?
If you've spent time in a spreadsheet software like Microsoft Excel, Apple Numbers, or Google Sheets and are eager to take your data analysis skills to the next level, this course is for you!
Data Analysis with Pandas and Python introduces you to the popular Pandas library built on top of the Python programming language.
Pandas is a powerhouse tool that allows you to do anything and everything with colossal data sets -- analyzing, organizing, sorting, filtering, pivoting, aggregating, munging, cleaning, calculating, and more!
I call it "Excel on steroids"!
Over the course of more than 19 hours, I'll take you step-by-step through Pandas, from installation to visualization! We'll cover hundreds of different methods, attributes, features, and functionalities packed away inside this awesome library. We'll dive into tons of different datasets, short and long, broken and pristine, to demonstrate the incredible versatility and efficiency of this package.
Data Analysis with Pandas and Python is bundled with dozens of datasets for you to use. Dive right in and follow along with my lessons to see how easy it is to get started with pandas!
Whether you're a new data analyst or have spent years (*cough* too long *cough*) in Excel, Data Analysis with pandas and Python offers you an incredible introduction to one of the most powerful data toolkits available today!
FAQ
FAQ area empty
Course curriculum
Chương 1 Installation and Setup 12 bài · 1 giờ 15 phút
- Introduction to the Course Học thử 11:10
- [macOS] Intro to the Terminal Học thử 8:19
- [macOS] Install uv, a Python package and project manager Học thử 4:11
-
[macOS] Download Course Materials and Setup Project 5:05
-
[Windows] Intro to PowerShell 7:56
- [Windows] Install uv, a Python package and project manager Học thử 5:08
- [Windows] Download Course Materials and Setup Project Học thử 5:41
-
Jupyter Lab Startup and Shutdown 9:25
-
Intro to Jupyter Lab 12:38
-
Setting Up Ruff Formatter in Jupyter Lab 2:16
- Import Libraries into Jupyter Lab Học thử 3:28
- Installation and Setup Học thử
Chương 2 Python Crash Course 23 bài · 2 giờ 46 phút
-
Comments 6:55
-
Data Types 10:19
-
Operators 12:28
-
Equality and Inequality Operators 8:52
-
Variables 7:01
-
Declare Variables
-
Built-In Functions 12:03
-
Built-in Functions
-
Custom Functions 15:27
-
Custom Functions
-
String Methods 18:23
-
String Methods
-
Lists 13:22
-
Creating Lists
-
Index Positions and Slicing 17:49
-
Index Positions and Slicing
-
Tuples 7:40
-
Dictionaries 13:37
-
Creating Dictionaries
-
Classes and Objects 6:32
-
Importing Modules 11:02
-
Importing Libraries 4:05
-
Python Crash Course
Chương 3 Series 34 bài · 2 giờ 38 phút
-
Create A Series Object from a List 8:17
-
Create A Series Object from a Dictionary 3:10
-
Create a Series Object
-
Intro to Series Methods 6:13
-
Intro to Series Attributes 7:20
-
Attributes and Methods on a Series
-
Parameters and Arguments 12:52
-
Parameters and Arguments
-
Import Series with the pd.read_csv Function 15:51
-
Import Series with the read_csv Function
-
The head and tail Methods 4:20
-
The head and tail Methods
-
Passing Series to Python Built-In Functions 7:50
-
Check for Inclusion with Python's in Keyword 5:03
-
The sort_values Method 3:58
-
The sort_values Method
-
The sort_index Method 6:46
-
The sort_index Method
-
Check for Inclusion with Python's in Keyword
-
Extract Series Values by Index Position 11:09
-
Extract Series Values by Index Label 7:49
-
Extract Series Values by Index Position or Index Label
-
The get Method 6:01
-
Overwrite a Series Value 5:34
-
Copy-on-Write and the copy Method 7:40
-
Math Methods on Series 11:50
-
Broadcasting 5:53
-
Math Methods on Series
-
Pandas Aligns by Index Labels 5:11
-
The value_counts method 3:19
-
The value_counts Method
-
The apply Method 6:17
-
The map Method 5:08
-
Series
Chương 4 DataFrames I: Introduction 26 bài · 2 giờ 3 phút
-
Methods and Attributes between Series and DataFrames 11:51
-
Differences between Shared Methods 7:42
-
Select One Column from a DataFrame 8:19
-
Select One Column from a DataFrame
-
Select Multiple Columns from a DataFrame 2:41
-
Select Multiple Columns from a DataFrame
-
Add New Column to DataFrame 8:43
-
Create Columns with the assign Method 2:55
-
Add Column to DataFrame
-
Drop Rows with Missing Values 6:29
-
Drop DataFrame Rows with Missing Values
-
Fill in Missing Values with the fillna Method 4:08
-
Fill Missing Values with a Forward Fill or Back Fill 4:57
-
Convert Data Types with the astype Method 10:56
-
Convert to Numbers with the to_numeric Function 4:38
-
Select Columns by Type with the select_dtypes Method 3:02
-
Convert Data Types with the astype Method II: Categories 6:21
-
Attribute Namespaces 5:35
-
The astype Method
-
Sort a DataFrame with the sort_values Method I 5:54
-
Sort a DataFrame with the sort_values Method II: Multiple Columns 8:19
-
Sort with Ordered Categories 6:02
-
Sort a DataFrame with the sort_values Method
-
Sort a DataFrame by its Index 4:28
-
Rank Values with the rank Method 9:31
-
DataFrames I
Chương 5 DataFrames II: Filtering Data 18 bài · 1 giờ 21 phút
-
This Module's Dataset + Memory Optimization 15:26
-
Filter a DataFrame Based on a Condition 12:36
-
Filter a DataFrame Based on a Condition
-
Filter with More than One Condition (AND - &) 5:41
-
Filter DataFrame with More than One Condition (AND - &)
-
Filter with More than One Condition (OR - |) 8:56
-
Filter DataFrame with More than One Condition (OR - |)
-
The isin Method 3:30
-
The isin Method
-
The isnull and notnull Methods 3:50
-
The between Method 5:19
-
The between Method
-
The duplicated Method 8:06
-
The drop_duplicates Method 6:25
-
The drop_duplicates Method
-
The where Method 3:40
-
The query Method 7:13
-
DataFrames II
Chương 6 DataFrames III: Data Extraction 11 bài · 1 giờ 1 phút
-
This Module's Dataset 1:29
-
The set_index and reset_index Methods 3:32
-
Retrieve Rows by Index Position and Index Label 11:38
-
Second Arguments to loc and iloc Accessors 8:51
-
Overwrite Value in a DataFrame 7:59
-
Rename Index Labels or Columns in a DataFrame 5:28
-
Delete Rows or Columns from a DataFrame 5:21
-
Create Random Sample with the sample Method 2:49
-
The nlargest and nsmallest Methods 3:22
-
The clip Method 2:00
-
The apply Method with DataFrames 8:04
Chương 7 Working with Text Data 8 bài · 43 phút
-
This Module's Dataset 4:45
-
Common String Methods 8:47
-
Common String Methods
-
Filtering with String Methods 7:34
-
String Methods on Index and Columns 3:11
-
The split Method 7:27
-
The expand and n Parameters of the split Method 7:19
-
The explode Method 3:32
Chương 8 MultiIndex 15 bài · 1 giờ 23 phút
-
Intro to the MultiIndex Module 10:08
-
Create a MultiIndex
-
Extract and Rename Index Level Values 6:56
-
Extract Index Level Values
-
Extract Rows from a MultiIndex DataFrame 12:26
-
Extract Rows from a MultiIndex DataFrame
-
The xs Method 4:29
-
The swaplevel Method 2:51
-
The transpose Method 4:09
-
The stack Method 5:11
-
The unstack Method 9:51
-
The pivot Method 7:01
-
The melt Method 7:06
-
The melt Method
-
The pivot_table Method 13:02
Chương 9 GroupBy 6 bài · 28 phút
-
The GroupBy Object 5:39
-
Retrieve Groups and Rows 3:26
-
Methods on the GroupBy Object 4:50
-
The agg Method 2:44
-
Grouping by Multiple Columns 3:05
-
Iterating over Groups 7:46
Chương 10 Merging DataFrames 10 bài · 59 phút
-
Intro to the Merging DataFrames Module 4:34
-
The pd.concat Function I 5:44
-
The pd.concat Function II 9:04
-
Left Joins 5:16
-
The left_on and right_on Parameters 4:57
-
Inner Joins 6:52
-
Matching across Multiple Columns 4:36
-
Full/Outer Joins 9:04
-
Merging by Indexes with the left_index and right_index Parameters 5:32
-
The join Method 2:56
Chương 11 Working with Dates and Times 8 bài · 1 giờ 6 phút
-
Intro to the Working with Dates and Times Module and Review of Python's datetime 8:08
-
The dt Attribute 7:46
-
The Timestamp Type 5:09
-
Extracting Datetime Rows from a DataFrame 14:35
-
The DateOffset Object 5:38
-
The date_range Function 7:53
-
Specialized Date Offsets 7:00
-
Timedeltas 10:03
Chương 12 Input and Output 5 bài · 37 phút
-
Intro to the Input and Output Module 11:19
-
Export DataFrame to CSV File 6:50
-
Export DataFrame to CSV File
-
Import Excel Workbook into pandas 8:42
-
Export Excel Workbook from pandas 9:46
Chương 13 Visualization 9 bài · 36 phút
-
The plot Method 7:26
-
Modifying Plot Aesthetics with Templates 4:54
-
Bar Charts 2:51
-
Stacked Bar Charts 3:24
-
Pie Charts 3:38
-
Area Charts 3:00
-
Histograms 3:19
-
Scatter Plots 4:21
-
Customizing Plots with Parameters 3:14
Chương 14 Table Styling 5 bài · 29 phút
-
The Styler Object 6:09
-
Hide Index or Column Labels 4:34
-
Highlighting Values 8:29
-
Using Color Gradients 6:50
-
In-Cell Bar Charts 2:42
Chương 15 Options and Settings 4 bài · 21 phút
-
Changing Options with Attributes 7:18
-
Changing Options with Functions 5:54
-
The precision Option 2:59
-
Temporary Options with option_context 4:34
Chương 16 Conclusion 2 bài · 1 phút
-
Congratulations! 0:38
-
Bonus
Requirment
-
Basic/intermediate experience with a spreadsheet software like Microsoft Excel/Google Sheets (common functions, vlookups, countif, pivot tables etc)
-
Basic experience with the Python programming language (we'll cover the basics if you're brand new!)
-
Strong knowledge of data types (strings, integers, floating points, booleans) etc
Outcomes
-
Perform a multitude of data operations in Python's popular pandas library including grouping, pivoting, joining and more!
-
Learn hundreds of methods and attributes across numerous pandas objects
-
Possess a strong understanding of manipulating 1D, 2D, and 3D data sets
-
Resolve common issues in broken or incomplete data sets
0 Student
2 Courses
0 review