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

5.0 (5)

41 learners

What you'll learn

This course includes

5.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

python data analysis python for data analysis Wes McKinney ipython python functions numpy python numpy pandas python pandas

Full Transcript

📚 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: https://www.youtube.com/watch?v=cVSb6-yaYMc 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