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

9 votes196 views4 answers
Display full dataframe pandas
Python
-1 vote196 views1 answer
Recursive class method python
Python
0 vote201 views1 answer
Python excel zelle schreiben
Python
0 vote213 views1 answer
Matplotlib bar chart from dictionary
Python
0 vote199 views1 answer
List all subdirectories up to a level
Python
47 votes205 views4 answers
Sorting a dictionary by value in python
Python
0 vote236 views1 answer
Windows 10 reset django migrations
Python
10 votes209 views1 answer
Create dataframe with column names pandas
Python
106 votes202 views5 answers
Sorting by column in pandas
Python
1 vote221 views1 answer
Read a function of excel in python
Python