/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 vote393 views2 answers
Fetch api flask url redirect
Python Flask
0 vote325 views1 answer
How to display printed values without scientific notation python
Python
0 vote335 views1 answer
Python open all files of type csv
Python
14 votes320 views4 answers
Pandas get index of max value in column
Python
13 votes344 views6 answers
Django orm
Python
1 vote376 views1 answer
Python list .remove() in for loop breaks
Python
1 vote339 views1 answer
Django manger
Python
0 vote347 views1 answer
Numpy.empty sorce code
Python
2 votes335 views2 answers
How to convert string to byte without encoding python
Python
3 votes346 views2 answers
List vs tuple python
Python