Pandas with Python: Analyze, Transform & Export Data

This course is part of Data Analysis with NumPy and Pandas Specialization

Instructor: EDUCBA

Access provided by University of Nueva Caceres

4 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Filter, group, aggregate, and reshape datasets using Pandas.
Handle missing values, manage indexes, and analyze time series.
Create pivot tables, crosstabs, and export data to CSV/Excel.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

16 assignments

Taught in English

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 Data Analysis with NumPy and Pandas 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 4 modules in this course

Learners will gain the ability to manipulate, analyze, and visualize data effectively using Python’s Pandas library. By the end of this course, they will be able to filter and transform datasets, apply grouping and aggregation, handle missing values, manage indexes, and reshape data for advanced analytics. They will also master techniques for working with time series, pivot tables, crosstabs, and exporting data to CSV and Excel.

This course is designed for aspiring data analysts, Python enthusiasts, and professionals looking to strengthen their data manipulation skills. With hands-on lessons and quizzes, learners will build confidence in handling real-world datasets while applying best practices for efficiency and readability. What makes this course unique is its structured progression—from foundational Pandas operations to advanced techniques—combined with practical exercises and applied projects. Learners won’t just watch tutorials; they will actively practice data handling in Jupyter Notebooks, ensuring they are job-ready for data science and analytics roles.

This module introduces learners to the Pandas library, its installation, and the Jupyter environment for hands-on coding. It covers Pandas’ core data structures, including Series and DataFrames, and explores fundamental operations for working with rows and columns. Learners build a strong foundation for effective data handling.

What's included

9 videos4 assignments

9 videos Total 46 minutes

Introduction to Pandas with Python 5 minutes
Understanding Jupiter Environment 4 minutes
Reading the Data Set 9 minutes
Series and Data Frame 4 minutes
Operations in Data Set 4 minutes
More on Panda Functions 6 minutes
Column Names and Operation 9 minutes
Removing Columns and Rows 3 minutes
Sorting Data Frame 3 minutes

4 assignments Total 60 minutes

Graded-Getting Started with Pandas 30 minutes
Introduction and Setup 10 minutes
Core Data Structures 10 minutes
Working with Columns and Rows 10 minutes

This module focuses on advanced filtering, selection, and transformation of data. Learners explore indexing by labels and positions, handle data types, apply string methods, and group data for aggregation. It also emphasizes working with Series, plotting, and handling null values.

What's included

12 videos4 assignments

12 videos Total 50 minutes

Filtering Data 7 minutes
Filter Multiple Criteria 6 minutes
Selective Columns and Rows 3 minutes
Data Frame and Series 2 minutes
Axis Parameter 3 minutes
String Methods in Pandas 4 minutes
Changing the Data Types 4 minutes
Example of Data Type Change 4 minutes
Group by Functions 4 minutes
Functions on Series 4 minutes
Plotting series in Pandas 4 minutes
Dealing with Null Values 5 minutes

4 assignments Total 60 minutes

Graded-Data Selection and Transformation 30 minutes
Filtering and Selection Techniques 10 minutes
Data Types and Grouping 10 minutes
Working with Series and Null Values 10 minutes

This module introduces indexing concepts and parameters that enhance data manipulation. Learners explore memory management, sampling strategies, dummy coding, handling duplicates, working with date/time functions, and avoiding common pitfalls like copy warnings.

What's included

16 videos4 assignments

16 videos Total 106 minutes

Uses of Index 6 minutes
Column in Index 6 minutes
Output of Data 8 minutes
Functions of iX Method 9 minutes
InPlace Parameter 4 minutes
Inspecting the Space 5 minutes
Reducing the Space 10 minutes
Using in Country Series 4 minutes
Creating Manual Data Frame 7 minutes
Random Sampling with Pandas 4 minutes
Concept of Dummy Coding 12 minutes
Creating Dummified Values 4 minutes
Duplicates in Data Frame 9 minutes
Functions for Date and Time 9 minutes
Setting with Copy Warning 5 minutes
Example on Copy Warning 5 minutes

4 assignments Total 60 minutes

Graded-Indexing, Sampling, and Advanced Functions 30 minutes
Exploring Index and Parameters 10 minutes
Space, Sampling, and Dummy Coding 10 minutes
Handling Duplicates, Dates, and Warnings 10 minutes

This module covers advanced reshaping, merging, and exporting functionalities in Pandas. Learners gain expertise in display options, formatting, working with pivot tables, crosstab functions, and exporting data to external formats like CSV and Excel for practical applications.