What you'll learn

Analysts spend much of their time stitching tables together and turning raw rows into totals that people can read, and doing it by hand in a spreadsheet does not scale or repeat. In this course, Combine and Summarize Data in Python, you’ll gain the ability to combine related datasets and turn them into clear, reliable summaries with pandas. First, you’ll explore how to append datasets with concatenation and merge them on common keys, choosing the right join type so that no row is silently lost or duplicated. Next, you’ll discover how to group records by one or more variables and calculate single, multiple, and named aggregations. Finally, you’ll learn how to build pivot tables and cross-tabulations and reshape data between wide and long formats. When you’re finished with this course, you’ll have the skills and knowledge of combining and summarizing data in Python needed to prepare analysis-ready summary tables from multiple data sources.