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 vote163 views2 answers
Python save input to text file
Python
3 votes198 views1 answer
Change figure size pandas
Python
5 votes194 views1 answer
Python iterate through date range
Python
36 votes156 views2 answers
Python3 iterate through indexes
Python
18 votes184 views3 answers
Django-admin startproject
Python
0 vote166 views1 answer
Django update field after save
Python
0 vote168 views1 answer
Python priority queue stack overflow
Python
0 vote194 views3 answers
Calling a function in python upon entry content changing tkinter
Python
1 vote171 views1 answer
Extract images from mp4 python
Python
3 votes164 views1 answer
Python list of random float numbers
Python