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 vote168 views1 answer
Python mypy cast
Python
0 vote133 views1 answer
300 x 250 donut download
Python
0 vote138 views1 answer
Whitespace delimiter python
Python
0 vote120 views1 answer
Compute condition number python
Python
-1 vote130 views1 answer
Returns a new DataFrame containing the distinct rows in this DataFrame
Python
0 vote139 views1 answer
Python dict keys to string
Python
0 vote174 views1 answer
Type object 'SparkContext' has no attribute '_jsc'
Python
0 vote128 views1 answer
Creating new column with dictionary
Python
1 vote133 views1 answer
Datetime not defined python
Python
0 vote122 views1 answer
Python find oldest and newest date
Python