/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

1 vote312 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
5 votes345 views2 answers
How to get the terminal command's result in pyton
Python
1 vote327 views1 answer
Python requests.get pdf An appropriate representation of the requested resource could not be found
Python
0 vote370 views1 answer
Mongodb in python
Python
0 vote344 views1 answer
Django authenticate with email
Python
0 vote331 views5 answers
Convert dictionary keys/values to lowercase in python
Python
-1 vote346 views1 answer
How to convert one dimensional array into two dimensional array
Python
5 votes347 views4 answers
Turtle example in python
Python
38 votes388 views3 answers
Python sleep for 1 minute
Python
0 vote363 views1 answer
Python log10
Python