/Python/Removing rows dataframe not in another dataframe using two columns

Removing rows dataframe not in another dataframe using two columns

df = pd.merge(df1, df2, how='left', indicator='Exist')
df['Exist'] = np.where(df.Exist == 'both', True, False)
df = df[df['Exist']==True].drop(['Exist','z'], axis=1)

Source: stackoverflow.com

Removing rows dataframe not in another dataframe using two columns

import pandas as pd

USERS = pd.DataFrame({'email':['a@g.com','b@g.com','b@g.com','c@g.com','d@g.com']})
print (USERS)
     email
0  a@g.com
1  b@g.com
2  b@g.com
3  c@g.com
4  d@g.com

EXCLUDE = pd.DataFrame({'email':['a@g.com','d@g.com']})
print (EXCLUDE)
     email
0  a@g.com
1  d@g.com

Source: stackoverflow.com

Similar codes

6 votes135 views2 answers
Python print version python
Python
0 vote161 views1 answer
Numpy randomly swap lines
Python
0 vote185 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python Django
1 vote151 views2 answers
Django make new application folder
Python
2 votes176 views3 answers
How to set indian timezone in django
Python Django
2 votes151 views2 answers
Dice rolling app in python
Python
91 votes139 views6 answers
Time.sleep
Python
4 votes144 views1 answer
Python make integer into a list
Python
40 votes133 views6 answers
How to print error in try except python
Python
0 vote145 views1 answer
Python remove all isntances from a list
Python