/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 vote174 views1 answer
How to convert character to factor in python
Python
0 vote198 views1 answer
How to get values in each cluster
Python
10 votes196 views2 answers
Python get numbers after decimal point
Python
0 vote186 views1 answer
Paschat opposite sanskrit
Python
9 votes149 views3 answers
How to get list of files python
Python
0 vote179 views2 answers
Pandas drop a list of rows
Python
0 vote173 views1 answer
How to find a website ip address
Python
-1 vote151 views1 answer
How to make a python library
Python
4 votes234 views1 answer
Python 3.7 download for windows 7 32-bit
Python
0 vote196 views1 answer
Flash not defined python flask
Python

Share