/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

0 vote307 views2 answers
How to close a flask web server with python
Python Flask
5 votes199 views3 answers
Urllib3 python
Python
0 vote207 views1 answer
Scikit learn library in python
Python
5 votes295 views1 answer
Add bearer token in python request
Python
0 vote247 views1 answer
Flask development mode
Python Flask
1 vote210 views1 answer
Np install python
Python
1 vote189 views1 answer
Pd combine series
Python
21 votes258 views1 answer
Python slice an array
Python
34 votes230 views3 answers
Python add command
Python
15 votes170 views2 answers
Python copy image to clipboard
Python