"Out of many, one"

Pandas Joins for Spreadsheet Users

John Miller

Principal Data Scientist

One-to-many joins

$$

  • One row matches to many rows
  • Resulting structure mirrors the lower level

one to many example

Pandas Joins for Spreadsheet Users

Revisiting the framework

$$

After viewing and understanding the data:

  • Determine the relationship

squares

Pandas Joins for Spreadsheet Users

Relationship examples

  • Time relationships

    • Month and days
    • Hour and minutes

  • Hierarchy relationships

    • Company and departments
    • Nations and cities

  • Different entities

    • Customer and purchase orders
    • Department descriptions and expense breakdowns

blocks

Pandas Joins for Spreadsheet Users

Let's practice!

Pandas Joins for Spreadsheet Users

Preparing Video For Download...