Merge pandas DataFrames based on Index in Python (2 Examples) | Add & Combine | Inner & Outer Join

Python code of this video:

import pandas as pd # Load pandas library

data1 = pd.DataFrame({"x1":["q", "w", "e", "r", "t"], # Create first pandas DataFrame
"x2":range(15, 20)},
index = list("abcde"))
print(data1) # Print first pandas DataFrame

data2 = pd.DataFrame({"y1":range(10, 4, - 1), # Create second pandas DataFrame
"y2":["xx", "bb", "x", "xxx", "bb", "b"],
"y3":range(18, 1, - 3)},
index = list("cdefgh"))
print(data2) # Print second pandas DataFrame

data2,
left_index = True,
right_index = True)
print(data_merge1) # Print merged DataFrame

data2,
left_index = True,
right_index = True,
how = "outer")
print(data_merge2) # Print merged DataFrame

Follow me on Social Media: