/Python/Python inner join based on two columns

Python inner join based on two columns

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'])

7

Source: stackoverflow.com

Python inner join based on two columns

df  = pd.merge(left=df1, right=df2, on=['var_1', 'var_2'], how='inner']

1

Source: stackoverflow.com

Similar codes

1 vote164 views1 answer
Draw spiral in matplotlib
Python
0 vote120 views1 answer
Python compare bytes
Python
0 vote171 views1 answer
Installing yfinance using pip
Python
0 vote205 views1 answer
Couchbase python
Python
0 vote219 views1 answer
Python word cloud
Python
0 vote172 views1 answer
Access nested set with array params python
Python
0 vote377 views1 answer
Compute confusion matrix using python
Python
0 vote178 views1 answer
Convert file to base64 python
Python
0 vote170 views1 answer
How to specify variable type in python
Python
0 vote172 views1 answer
Jupyter notebook play audio
Python

Share