Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Introduction to Python for Data Science

Introduction
Missing values
Duplicate rows
Outliers
Joining datasets
14. Merging two DataFrames – different columns, step 1
Summary

Instruction

Excellent! The example with employee data was nice and easy because both datasets had the same join column name, and all data could match. As you may guess, reality is sometimes different.

We will now work with a slightly more complicated example. There will be two datasets, each containing the number of items sold in a single store over years. We will try to compare sales figures in both stores in each year. The problem is twofold:

  1. Dataset 1 uses column year, but Dataset 2 uses column period.
  2. Dataset 1 contains data for the years 2013-2018, whereas Dataset 2 contains data for the years 2010-2015.

Exercise

Import store_a.csv into variable store_a, and store_b.csv into variable store_b.