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-pandas-dataframes-python 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: https://www.facebook.com/statisticsglobecom/ Facebook – Group for Discussions & Questions: https://www.facebook.com/groups/statisticsglobe LinkedIn – Statistics Globe Page: https://www.linkedin.com/company/statisticsglobe/ LinkedIn – Group for Discussions & Questions: https://www.linkedin.com/groups/12555223/ Twitter: https://twitter.com/JoachimSchork Music by bensound.com