Join pandas DataFrames based on Particular Column in Python (Example) | merge Function & on Argument

Python code of this video:

import pandas as pd # Import pandas

data1 = pd.DataFrame({"col":range(11, 17), # Create first pandas DataFrame
"x1":range(12, 1, - 2),
"x2":["a", "b", "c", "d", "e", "f"],
"x3":range(17, 11, - 1)})
print(data1) # Print first pandas DataFrame

data2 = pd.DataFrame({"col":range(15, 19), # Create second pandas DataFrame
"y1":["l", "k", "j", "h"],
"y2":["x", "y", "y", "y"],
"y3":range(18, 10, - 2)})
print(data2) # Print second pandas DataFrame

data2,
on = "col")
print(data_join) # Print merged DataFrame

Follow me on Social Media: