- Day 5: Combining and Pivoting Tables
-
Recap of Day 4 00:05:21
-
Joining Tables in Excel 00:11:17
-
Data Wrangling 00:02:48
-
Left Joins 00:23:10
-
Inner Joins 00:07:38
-
groupby() and agg() 00:23:51
-
pivot_table() 00:16:42
- Wrap-up
-
End of Learning Path Survey
Data Analysis with Python in Excel: Combining and Pivoting Tables (Day 5)
Leverage the power of Python to analyze data.
In this course, Dave covers combining and pivoting tables. You'll continue wrangling data, learn how to join tables in Excel, how to use the merge() function for "left" and "inner" joins, and also how to utilize the groupby(), agg(), and pivot_table() functions.
This course is Part 5 of the five-course series in the Data Analysis with Python in Excel learning path.