Articles → Pandas → Merge Function In Dataframe In Pandas
Merge Function In Dataframe In Pandas
Purpose
Example
import numpy as np
import pandas as pd
# Create a dictionary
dict1 = {
'company':['Google', 'Microsoft', 'Apple', 'Google', 'Microsoft', 'Apple'],
'year': [2017, 2017, 2017, 2018, 2018, 2018],
'Profit':[20000,40000,60000,80000,70000,50000]
}
dict2 = {
'company':['Disney', 'Walmart', 'AT&T', 'Disney', 'Walmart', 'AT&T'],
'year': [2017, 2017, 2017, 2018, 2018, 2018],
'Profit':[10000,20000,30000,40000,50000,60000]
}
# Create a dataframe
df1 = pd.DataFrame(dict1, index=[0,1,2,3,4,5])
df2 = pd.DataFrame(dict2, index=[6,7,8,9,10,11])
# Concat
pd.merge(df1, df2, how="inner", on = "year")
Output
Click to Enlarge