Index-based joins

Pandas Joins for Spreadsheet Users

John Miller

Principal Data Scientist

Pandas indexing

$$

  • Generic numbered indexing

numeric index

$$

  • Tailored multi-level indexing

tailored index

Pandas Joins for Spreadsheet Users

Joining on index

$$

DataFrame.join(other, how='')

  • Similar to merge on columns
  • Joins on index by default
  • Can join multiple data frames

df.join([df2, df3], how='')

pandas hanging out

Pandas Joins for Spreadsheet Users

Let's practice!

Pandas Joins for Spreadsheet Users

Preparing Video For Download...