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 vote113 views1 answer
Run a python script from another python script on a raspberry pi
Python
16 votes119 views3 answers
Python empty text file
Python
2 votes118 views1 answer
Check the os in python
Python
0 vote104 views1 answer
Python post request multi argument
Python
5 votes121 views3 answers
Write to file python 3
Python
0 vote107 views1 answer
How to use a function to find the total in spyder python
Python
0 vote139 views1 answer
How to get only one column from dataset in python
Python
1 vote117 views1 answer
Python function to do comparison between two numbers
Python
27 votes72 views2 answers
Get user from mention discord.py
Python
0 vote132 views1 answer
Server error 500 heroku django
Python Django