Concatenation

Pandas Joins for Spreadsheet Users

John Miller

Principal Data Scientist

Concatenation basics

$$

  • Similar to spreadsheet CONCATENATE
  • Mimics copy-paste of cells
  • pd.concat() along rows or columns

concat wood

Pandas Joins for Spreadsheet Users

Concatenating rows

$$

  • Useful when working with split data

$$

pd.concat([df1, df2, ...])
  • Uses unique key(s) as data frame index
  • Includes all rows by default

Concatenate rows with named index

Pandas Joins for Spreadsheet Users

Concatenating rows with overlapping indices

$$

  • Data frame indices may overlap

  • Don't worry!

pd.concat([df1, df2, ...],
    ignore_index=True)

Concatenate rows with generic index

Pandas Joins for Spreadsheet Users

Concatenating columns

$$

  • Like pasting tables side by side
  • Across columns: axis=1
pd.concat([df1, df2, ...], 
    axis=1)
  • Includes all columns by default

Concatenate columns

Pandas Joins for Spreadsheet Users

Let's practice!

Pandas Joins for Spreadsheet Users

Preparing Video For Download...