JOIN 함수

Key Value를 기준으로 데이터 프레임을 병합하는 함수

import pandas as pd

d1 = {'Asset_Allocation':[1,2,3,4,5,6],
  'stock':['IDEXX','Zoetis','Freshpet','Chewy','Trupanion','WOOF']
     }
df1 = pd.DataFrame(d1)
 
d2 = {'Asset_Allocation':[2,3,6,8],
    'Analyze':['Buy','Hold','Sell', 'None']}
df2 = pd.DataFrame(d2)

df1

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

df2

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

Inner 조인 수행.

inner_join_result = pd.merge(df1, df2, on='Asset_Allocation', how='inner')
inner_join_result

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

inner_join_result = df1.merge(df2, on='Asset_Allocation', how='inner')
inner_join_result

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

Left Outer 조인 수행.

left_outer_join_result = df1.merge(df2, on='Asset_Allocation', how='left')
left_outer_join_result

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

Right Outer 조인 수행.

right_outer_join_result = df1.merge(df2, on='Asset_Allocation', how='right')
right_outer_join_result

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

left_outer_join_result_01 = df2.merge(df1, on='Asset_Allocation', how='left')
left_outer_join_result_01

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

Full outer join 수행.

full_outer_join_result = pd.merge(df1, df2, on='Asset_Allocation', how='outer')
full_outer_join_result

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}