Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Data analysts who work primarily in Excel often hit invisible walls: datasets too large to scroll through, analyses too repetitive to run manually, and charts that take more time to format than they took to build. Pandas, the Python package designed from the ground up for tabular data analysis, removes those walls. With a working knowledge of Pandas, you can filter a million-row dataset, join two data sources, and visualize results in the same script, reproducibly, in minutes. In this course, you'll write real code from the first lesson. You'll import data from Excel workbooks, profile DataFrames with summary statistics and charts, add calculated columns, filter and sort rows, aggregate with groupby, merge tables, handle missing values, reshape data with melt and pivot_table, build rolling window functions for time series, and apply all of those skills to a real dataset from start to finish. By the end of this course, you'll be able to build a complete, automated data analysis pipeline in Pandas that takes raw data from an Excel file to a clean, aggregated, and visualized output ready to share with stakeholders.

Syllabus

Loading and Exploring DataFrames

When you work with data in Python, that data almost always lives in an external file rather than your script, which means loading it correctly is the first critical step in any analysis. In this module, you'll import tabular data from Excel files and Python libraries into Pandas DataFrames, then apply core inspection methods to verify the structure and contents of what you loaded.

Profiling and Charting DataFrames

When a dataset has thousands of rows, scrolling through it won't help you make sense of it: you need a systematic approach to examining its structure, distribution, and visual patterns at once. In this module, you'll use Pandas summary methods to profile any DataFrame's dimensions, data types, and statistics, then build histograms, bar charts, and scatter plots to reveal what the numbers alone can't show.

Transforming and Filtering DataFrames

Clean column labels, derived metrics, and the ability to isolate exactly the rows you need are the foundation of almost every real analysis workflow. In this module, you'll add calculated columns using arithmetic and string operations, rename and drop columns to keep your DataFrame tidy, sort rows by single and multiple criteria, and filter rows using boolean conditions and the query() method.

Aggregating, Merging, and Reshaping DataFrames

Raw transactional data almost never arrives in the shape you need for analysis: it needs to be summarized by group, combined with data from other tables, cleaned of gaps, and sometimes restructured entirely before it yields useful answers. In this module, you'll aggregate DataFrames with groupby(), combine tables using joins and concatenation, handle missing values systematically, and reshape data between wide and long formats using melt() and pivot_table().

Resampling and Windowing Time Series Data

Time-stamped data only becomes useful for trend analysis when you can aggregate it by period and compare values across a moving window. In this module, you'll convert a date column to a DateTime index, resample transaction data by month, use shift() to create lag and lead columns, and build rolling averages that smooth short-term noise to reveal longer-term patterns.

Conducting an End-to-End Data Analysis

All of the techniques covered in this course — loading data, profiling DataFrames, transforming columns, merging tables, handling missing values, reshaping with melt(), aggregating with groupby(), sorting, and charting — are most valuable when they work together. In this module, you'll apply the full pipeline to an unfamiliar real-world dataset, moving from raw CSV to a clean, aggregated, and visualized result in a single notebook.

Conclusion

Becoming confident with Pandas is not the end of a learning path; it is the beginning of one. In this module, you'll take stock of the analytical skills you've built in this course, connect them to your current work, and identify where to go next in your Python journey.