Advanced Pandas

Ends soon! Get $70+ in savings and build skills with Coursera Plus. Save 40% for 3 months.

Advanced Pandas

This course is part of Python for Business Data Science Specialization

Instructor: Madecraft

Included with Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Clean, convert, and prepare messy real-world data using pandas core DataFrame functions.
Combine and reshape multiple datasets through grouping, merging, and pivoting techniques.
Extend pandas with automated profiling, geospatial analysis, and big data frameworks like Dask.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Python for Business Data Science Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 6 modules in this course

Most Python users pick up just enough pandas to load a CSV and glance at a few rows, then stop there, leaving most of the library's real power untouched. Data scientist Brett Vanderblock built this course to close that gap and take you well past the basics of DataFrame handling. It moves from foundational setup into the cleaning, combining, and scaling techniques that real, messy datasets actually demand.

You'll set up and navigate DataFrames, clean and convert messy real-world values, combine and reshape data from multiple sources, and visualize and summarize what you find. You'll also work with tools that extend pandas beyond its core capabilities, including automated data profiling, geospatial analysis, and frameworks built for datasets too large for pandas alone. By the end of this course, you'll be able to take a messy, multi-source dataset and turn it into a clean, well-organized foundation ready for analysis, visualization, or a decision-maker's next move.

Before you can clean, transform, or analyze anything, you need a reliable way to load your data and see exactly what you're working with. In this module, you'll set up pandas, build and inspect DataFrames, and configure your workspace so you can navigate any dataset with confidence.

What's included

5 videos2 readings2 assignments

5 videosTotal 10 minutes

Take Pandas to the Next Level1 minute
Getting Started With Pandas1 minute
Intro to Dataframes Using Pandas3 minutes
Top Functions Using Pandas4 minutes
Configuring Options Using Pandas2 minutes

2 readingsTotal 20 minutes

Two Ways In: Choosing How You Set Up Pandas10 minutes
Label or Position: Picking the Right Way to Point at Your Data10 minutes

2 assignmentsTotal 22 minutes

Finding Your Way Around a New DataFrame7 minutes
Making Sense of a New Dataset15 minutes

Real data almost never shows up in the shape you need it. In this module, you'll convert data types, clean up strings and dates, handle missing values, and apply custom functions to get any dataset ready for reliable analysis.

What's included

5 videos3 readings2 assignments

5 videosTotal 16 minutes

Data Type Conversions Using Pandas3 minutes
Working With Strings Using Pandas2 minutes
Working With Dates Using Pandas3 minutes
Dealing With Missing Data Using Pandas4 minutes
Apply/Map/Applymap3 minutes

3 readingsTotal 30 minutes

The Type You Can't See Until Something Breaks10 minutes
Turning Text Into Time: Working with Dates You Can Actually Calculate With10 minutes
The Blank Spaces in Your Data Aren't Nothing10 minutes

2 assignmentsTotal 22 minutes

Making Sense of the Gaps in Your Data7 minutes
Turning Messy Data Into Usable Data15 minutes

A single dataset rarely tells the whole story on its own. In this module, you'll group and summarize data, reshape it into the layout your analysis actually needs, combine multiple dataframes together, and organize numerical values into meaningful categories.

What's included

4 videos2 readings2 assignments

4 videosTotal 18 minutes

Groupby and Aggregations Using Pandas3 minutes
Reshaping Dataframes (Pivot, Stack)6 minutes
Merging (Merge, Join) and Concatenating (Concat) Dataframes5 minutes
Mapping Variables Into Groups3 minutes

2 readingsTotal 20 minutes

Why "Summarize by Category" Beats Scrolling Through Every Row10 minutes
Same Data, Different Shape10 minutes

2 assignmentsTotal 22 minutes

Choosing the Right Join Every Time7 minutes
Bringing Multiple Datasets Together15 minutes

Numbers on their own are hard to reason about, but a chart or a well-chosen statistic can reveal a pattern instantly. In this module, you'll visualize your data directly in pandas and calculate the statistics that reveal how your variables actually behave and relate to one another.

What's included

2 videos2 assignments

Pandas has plenty of neighbors worth knowing. In this module, you'll accelerate your exploratory analysis with automated profiling, work with location-based data using a geospatial extension of pandas, and see how pandas' concepts translate to tools built for datasets too large for pandas alone.

What's included

3 videos1 reading2 assignments

You've covered a lot of ground with pandas, from setting up and navigating DataFrames through cleaning, combining, visualizing, and extending your work with tools beyond pandas itself. In this module, you'll complete a comprehensive final assessment and pick up pointers for where to go next.

What's included

1 video1 assignment

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Madecraft

133 Courses11,937 learners

Offered by

Madecraft

Explore more from Data Analysis

Madecraft
Python Functions for Data Science
Course
Madecraft
Using Python With Excel
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Break down barriers to learning with big savings
Get Coursera Plus
Start with easy savings for hard-working teams
Save 30% today

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.