Course wrap-up

Joining Data with pandas

Aaren Stubberfield

Instructor

You're this high performance race car now

High performance race car

1 Photo by jae park from Pexels
Joining Data with pandas

Data merging basics

  • Inner join using .merge()
  • One-to-one and one-to-many relationships
  • Merging multiple tables
Joining Data with pandas

Merging tables with different join types

  • Inner join using .merge()
  • One-to-one and one-to-one relationships
  • Merging multiple tables
  • Left, right, and outer joins
  • Merging a table to itself and merging on indexes
Joining Data with pandas

Advanced merging and concatenating

  • Inner join using .merge()
  • One-to-one and one-to-one relationships
  • Merging multiple tables
  • Left, right, and outer joins
  • Merging a table to itself and merging on indexes
  • Filtering joins

    • semi and anti joins
  • Combining data vertically with .concat()

  • Verify data integrity
Joining Data with pandas

Merging ordered and time-series data

  • Inner join using .merge()
  • One-to-one and one-to-one relationships
  • Merging multiple tables
  • Left, right, and outer joins
  • Merging a table to itself and merging on indexes
  • Filtering joins

    • semi and anti joins
  • Combining data vertically with .concat()

  • Verify data integrity
  • Ordered data
    • merge_ordered() and merge_asof()
  • Manipulating data with .melt()
Joining Data with pandas

Thank you!

Joining Data with pandas

Preparing Video For Download...