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

1 vote220 views2 answers
Why mentioning user agent in request library
Python
39 votes222 views2 answers
Python file from path
Python
0 vote206 views1 answer
Format number differences in python
Python
0 vote291 views1 answer
Make button bigger tkinter with grid
Python
9 votes208 views6 answers
Python dictionary
Python
3 votes216 views3 answers
Python pip not working
Python
0 vote211 views1 answer
Tkinter yes no dialogue box
Python
2 votes212 views1 answer
Auto datetime in django models
Python
4 votes211 views4 answers
Set python3.7 as default ubuntu
Python
7 votes199 views1 answer
Program to find even numbers in python
Python