Power and flexibility

Pandas Joins for Spreadsheet Users

John Miller

Principal Data Scientist

Scalability

$$

  • No hard limits on data frame size
  • Built-in ways to "chunk" data
  • Use distributed/parallel computing

scaled data cartoon

Pandas Joins for Spreadsheet Users

Efficiency

$$

efficient panda cartoon

$$

  • Join on multiple columns
  • Preference for simple code
joined_df = left_df.merge(right_df)
Pandas Joins for Spreadsheet Users

Integration

$$

  • Improved speed and scale
  • Data visualization
  • Machine learning

python ecosystem

Pandas Joins for Spreadsheet Users

A word on advanced spreadsheet usage

$$

  • Data models and query tools
  • Programming languages
  • Advanced formulas
Pandas Joins for Spreadsheet Users

Let's practice!

Pandas Joins for Spreadsheet Users

Preparing Video For Download...