Merge Two pandas DataFrames in Python (6 Examples) | Inner, Outer, Left & Right Join | Combine Data
How to join pandas DataFrames in the Python programming language. More details: https://statisticsglobe.com/merge-two...
Python code of this video:
import pandas as pd # Import pandas
data1 = pd.DataFrame({"ID":range(101, 106), # Create first pandas DataFrame
"x1":range(1, 6),
"x2":["a", "b", "c", "d", "e"],
"x3":range(16, 11, - 1)})
print(data1) # Print first pandas DataFrame
data2 = pd.DataFrame({"ID":range(104, 108), # Create second pandas DataFrame
"y1":["x", "y", "x", "y"],
"y2":range(8, 1, - 2)})
print(data2) # Print second pandas DataFrame
data_inner = pd.merge(data1, # Inner join
data2,
on = "ID",
how = "inner")
print(data_inner) # Print merged DataFrame
data_outer = pd.merge(data1, # Outer join
data2,
on = "ID",
how = "outer")
print(data_outer) # Print merged DataFrame
data_left = pd.merge(data1, # Left join
data2,
on = "ID",
how = "left")
print(data_left) # Print merged DataFrame
data_right = pd.merge(data1, # Right join
data2,
on = "ID",
how = "right")
print(data_right) # Print merged DataFrame
data3 = pd.DataFrame({"ID":range(102, 110), # Create third pandas DataFrame
"z1":range(10, 18),
"z2":["z", "b", "z", "z", "d", "z", "d", "a"],
"z3":range(18, 10, - 1)})
print(data3) # Print third pandas DataFrame
from functools import reduce
data_multi = reduce(lambda left, right: # Merge three pandas DataFrames
pd.merge(left , right,
on = ["ID"],
how = "outer"),
[data1, data2, data3])
print(data_multi) # Print merged DataFrame
data4 = pd.DataFrame({"a1":["yes", "no", "no", "yes", "yes"], # Create fourth pandas DataFrame
"a2":range(15, 20)},
index = list("abcde"))
print(data4) # Print fourth pandas DataFrame
data5 = pd.DataFrame({"b1":range(10, 5, - 1), # Create fifth pandas DataFrame
"b2":["b", "bb", "b", "bbb", "b"],
"b3":range(10, 1, - 2)},
index = list("cdefg"))
print(data5) # Print fifth pandas DataFrame
data_index = pd.merge(data4, # Merge DataFrames based on Index
data5,
left_index = True,
right_index = True,
how = "outer")
print(data_index) # Print merged DataFrame
Follow me on Social Media:
Facebook – Statistics Globe Page: / statisticsglobecom
Facebook – Group for Discussions & Questions: / statisticsglobe
LinkedIn – Statistics Globe Page: / statisticsglobe
LinkedIn – Group for Discussions & Questions: / 12555223
Twitter: / joachimschork
Music by bensound.com
On this page of the site you can watch the video online Merge Two pandas DataFrames in Python (6 Examples) | Inner, Outer, Left & Right Join | Combine Data with a duration of hours minute second in good quality, which was uploaded by the user Statistics Globe 08 April 2022, share the link with friends and acquaintances, this video has already been watched 1,370 times on youtube and it was liked by 33 viewers. Enjoy your viewing!
