/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 vote247 views1 answer
Reversing Ints
Python
2 votes241 views1 answer
Average within group by pandas
Python
20 votes212 views5 answers
List directory in python
Python
0 vote234 views1 answer
How to load keras model from json
Python
0 vote241 views3 answers
Flask socketio with gevent
Python Flask
0 vote228 views1 answer
How to increase existing length with null python
Python
2 votes248 views3 answers
Convert csv to dictionary in Python
Python
0 vote166 views1 answer
How to convert user integer input to string in python
Python
0 vote231 views1 answer
Convert method to str python
Python
0 vote228 views1 answer
Concatenate strings of numpy array python
Python

Share