/Python/How to join two dataframes by 2 columns so they have only the common rows?

How to join two dataframes by 2 columns so they have only the common rows?

Merge two dataframes with common columns

import pandas as pd
pd.merge(df1, df2, on="movie_title")

Source: stackoverflow.com

How to join two dataframes by 2 columns so they have only the common rows?

import pandas as pd 
import numpy as np

df1 = pd.DataFrame({'fruit': ['apple', 'banana', 'orange'] * 3,
                    'weight': ['high', 'medium', 'low'] * 3,
                    'price': np.random.randint(0, 15, 9)})

df2 = pd.DataFrame({'pazham': ['apple', 'orange', 'pine'] * 2,
                    'kilo': ['high', 'low'] * 3,
                    'price': np.random.randint(0, 15, 6)})
out = df1.merge(df2,left_on=('fruit','weight'),right_on=('pazham','kilo'),how='inner',suffixes=('_left','_right')).head(10)

Merge two dataframes with common columns

dfinal = df1.merge(df2, how='inner', left_on='movie_title', right_on='movie_name')

Source: stackoverflow.com

Similar codes

60 votes274 views6 answers
Python remove letters from string
Python
30 votes260 views2 answers
For loop example python 3
Python
0 vote259 views1 answer
How to read panda column
Python
0 vote272 views1 answer
Python all possible pairs
Python
34 votes267 views5 answers
Pandas max columns
Python
8 votes285 views6 answers
Django filters
Python Django
1 vote266 views1 answer
Creating an interface tkinter
Python
27 votes276 views6 answers
Install pandas
Python
23 votes375 views2 answers
Flask or django
Python Django
139 votes276 views6 answers
Open text file in python
Python