Combine pandas DataFrames Vertically & Horizontally in Python (Example) | Join & Merge Side-by-Side

Python code of this video:

import pandas as pd # Load pandas library

data1a = pd.DataFrame({"ID":range(1, 5), # Create first pandas DataFrame
"x1":range(10, 6, - 1),
"x2":["a", "b", "c", "d"],
"x3":range(26, 22, - 1)})
print(data1a) # Print first pandas DataFrame

data2a = pd.DataFrame({"ID":range(2, 8), # Create second pandas DataFrame
"y1":["x", "y", "y", "x", "y", "y"],
"y2":range(12, 1, - 2)})
print(data2a) # Print second pandas DataFrame

data2a,
on = "ID",
how = "outer")
print(data_horizontal) # Print merged DataFrame

data1b = pd.DataFrame({"x1":range(11, 6, - 1),
"x2":["a", "b", "c", "d", "e"],
"x3":range(28, 23, - 1)})
print(data1b) # Print first pandas DataFrame

data2b = pd.DataFrame({"x1":range(1, 8), # Create second pandas DataFrame
"x2":["x", "y", "x", "y", "x", "y", "y"],
"x3":range(14, 1, - 2)})
print(data2b) # Print second pandas DataFrame

ignore_index = True,
sort = False)
print(data_vertical) # Print combined DataFrame

Follow me on Social Media: