/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

-1 vote203 views1 answer
AttributeError: __enter__ in python cde
Python
-1 vote196 views1 answer
Python scatter size
Python
6 votes186 views2 answers
Python code for where to save the figures
Python
2 votes175 views1 answer
How to record the steps of mouse and play the steps using python
Python
0 vote201 views1 answer
Np.stack
Python
0 vote206 views1 answer
Add suffix to multiple file names python
Python
1 vote142 views1 answer
What is .new() is used in python
Python
0 vote207 views1 answer
Identify the common columns between two dataframes pandas python
Python
0 vote182 views1 answer
Invalid Python Environment: Python is unable to find Maya's Python modules
Python
0 vote191 views1 answer
How to show pandas last record
Python

Share