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


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.