Course wrap-up

Joining Data with pandas

Aaren Stubberfield

Instructor

You're this high performance race car now

High performance race car

¹ Photo by jae park from Pexels

Data merging basics

Inner join using .merge()
One-to-one and one-to-many relationships
Merging multiple tables

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

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

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()

Thank you!

Joining Data with pandas

Preparing Video For Download...