/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

12 votes279 views2 answers
Convert torch to numpy
Python
2 votes300 views1 answer
How to represent equation in Pytho
Python
0 vote285 views1 answer
Scipy version check
Python
6 votes340 views4 answers
Django change password command line
Python Django
0 vote280 views1 answer
How to add new column in django
Python
3 votes289 views1 answer
Json not readable python
Python
68 votes259 views6 answers
Python list files in directory
Python
0 vote285 views1 answer
How to change the type of a values in list from str to object python
Python
0 vote292 views2 answers
How to convert string labels to numpy array
Python
0 vote329 views1 answer
Compose functions python
Python