How do I merge datasets?

If you have two datasets with common column(s) you can merge the datasets by first loading them into their own pandas.DataFrame, then using the merge method.

import pandas as pd

dataset1 = pd.read_csv(d1_path)
dataset2 = pd.read_csv(d2_path)
merged_dataset = pd.merge(dataset1, dataset2, on='common_column')