Answers for "how to combine two dataframes based on two columns pandas"

6

merge two dataframes based on column

df_outer = pd.merge(df1, df2, on='id', how='outer') #here id is common column

df_outer
Posted by: Guest on July-27-2020
0

pandas join two columns

df['FullName'] = df[['First_Name', 'Last_Name']].agg('-'.join, axis=1)
Posted by: Guest on October-15-2021

Code answers related to "how to combine two dataframes based on two columns pandas"

Python Answers by Framework

Browse Popular Code Answers by Language