Join pandas DataFrames based on Particular Column in Python (Example) | merge Function & on Argument
How to join two DataFrames based on a shared column in the Python programming language. More details: https://statisticsglobe.com/merge-pan...
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
data_join = pd.merge(data1, # Inner join
data2,
on = "col")
print(data_join) # 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
