/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

40 votes192 views6 answers
Pandas replace null with 0
Python
0 vote168 views1 answer
How to import the whall library in python
Python
0 vote176 views1 answer
Why tensorflow not working in .py file
Python
5 votes166 views1 answer
Is javascript easier than python
Python
0 vote164 views1 answer
Django content type for model
Python
62 votes191 views6 answers
Class python
Python
10 votes166 views3 answers
Pygame.key.get_pressed()
Python
11 votes188 views3 answers
Pandas count values by column
Python
3 votes172 views1 answer
Restore index after concatenate
Python
8 votes167 views1 answer
Input stdin python
Python

Share