/Python/Pandas inner join on two columns

Pandas inner join on two columns

Pandas inner join on two 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

0 vote334 views1 answer
Switch case dictionary python
Python
0 vote331 views1 answer
Python get num chars
Python
0 vote342 views1 answer
Python except keyboardinterrupt
Python
0 vote298 views1 answer
Graph outlier detection
Python
0 vote350 views1 answer
Geopandas españa map
Python
4 votes329 views2 answers
Python get time milliseconds
Python
1 vote386 views1 answer
Flask send client to another web page
Python
6 votes398 views6 answers
Fibonacci python
Python
0 vote331 views1 answer
Argmin returns one value for 2d array
Python
0 vote347 views1 answer
Python if dataframe has at least one row
Python

Share