Data Wrangling: Hierarchical Indexing, Join, & Combine

Ha Khanh Nguyen (hknguyen)


1. Hierarchical Indexing

1.1 Series

1.2 DataFrame

1.2 Summary Statistics by Level


2. Combining and Merging Datasets

2.1 Database-style DataFrame Joins

b. A crash course in SQL (relational database) joins

Source: https://www.codespot.org/sql-join/

c. Many-to-many join

2.2 Concatenating Along an Axis

2.3 Combining Data with Overlap


This lecture notes reference materials from Chapter 8 of Wes McKinney's Python for Data Analysis 2nd Ed.