/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

6 votes177 views2 answers
Python change working directory to file directory
Python
0 vote181 views1 answer
Renpy hide textbox
Python
0 vote169 views1 answer
Spark.read.load
Python
1 vote173 views1 answer
Get first element of tuple python
Python
0 vote183 views1 answer
Pandas where
Python
0 vote179 views2 answers
Python default dictonary
Python
0 vote188 views1 answer
Iterating over tuples in python
Python
1 vote180 views1 answer
Pydotprint
Python
0 vote192 views1 answer
Applies the f function to all Row of this DataFrame
Python
0 vote162 views1 answer
The dropping of sediment by water wind and ice or gravity is known as
Python

Share