Pd merge on multiple columns

new_df = pd.merge(A_df, B_df,  how='left', left_on=['A_c1','c2'], right_on = ['B_c1','c2'])

Source: stackoverflow.com

Pandas merge two columns from different dataframes

#suppose you have two dataframes df1 and df2, and 
#you need to merge them along the column id
df_merge_col = pd.merge(df1, df2, on='id')

Take union of two dataframes pandas

m = {'left_only': 'df1', 'right_only': 'df2', 'both': 'df1, df2'}

result = df1.merge(df2, on=['A'], how='outer', indicator='B')
result['B'] = result['B'].map(m)

result

Source: stackoverflow.com

Similar codes

0 vote111 views1 answer
Numpy symmetrize array
Python
0 vote114 views1 answer
Dateien mit modul requests herunterladen python
Python
0 vote122 views1 answer
Return a sorted copy of the list. Does not modify original list.
Python
0 vote189 views1 answer
Dicionario python
Python
45 votes116 views6 answers
Python check if list contains
Python
0 vote128 views1 answer
Equivalent of setInterval python
Python
15 votes123 views3 answers
Python - gropuby based on 2 variabels
Python
2 votes89 views2 answers
Iterate in pandas dataframe
Python
2 votes119 views3 answers
Delete outliers in pandas
Python
0 vote134 views1 answer
Docker python heelo world doesnt print anything
Python