How do I merge datasets?


#1

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