Join, Combine and Shape Data with Python for Data Analysis - Part 8

Published: 10 May 2023
on channel: Learning Python
562
14

📚 Get the book "Python for Data Analysis": https://amzn.to/3Kq9W3k
📖 Read online: https://wesmckinney.com/book
🔨 FREE Skillshare 30-day trial: https://skillshare.eqcm.net/5b4ddL

🎬 Playlist Python for Data Analysis:    • Best way to Learn Data Analysis with ...  

Link to book resources (GitHub): https://github.com/wesm/pydata-book

⏱ Timestamps
0:00 - Introduction
0:47 - Hierarchical Indexing
5:38 - Reordering and Sorting Levels
6:41 - Summary Statistics by Level
7:51 - Indexing with a Data Frame's columns
9:10 - Combining and Merging Datasets
9:42 - Database-Style DataFrame Joins
18:35 - Merging on Index
20:08 - Concatenating Along an Axis
23:36 - Combining Data with Overlap
26:16 - Reshaping and Pivoting
27:20 - Pivoting "Long" to "Wide" Format
30:50 - Pivoting "Wide" to "Long" Format
32:52 - Summary