/Python/Values missing comparing datasets

Values missing comparing datasets

In [119]:

common = df1.merge(df2,on=['col1','col2'])
print(common)
df1[(~df1.col1.isin(common.col1))&(~df1.col2.isin(common.col2))]
   col1  col2
0     1    10
1     2    11
2     3    12
Out[119]:
   col1  col2
3     4    13
4     5    14

Source: stackoverflow.com

Similar codes

12 votes104 views3 answers
Write list to text file python
Python
0 vote146 views2 answers
Install cairo python
Python
0 vote143 views1 answer
The module in NAME could not be imported: django.contrib.user_auth.password_validation.UserAttributeSimilarityValidator. Check your AUTH_PASSWORD_VALI
Python
0 vote141 views1 answer
What is the use of extend in python
Python
1 vote185 views1 answer
Query with condition django
Python Django
0 vote136 views1 answer
Check if digit or alphabet
Python
2 votes138 views1 answer
Sqlalchemy query bilter by current month
Python
204 votes297 views6 answers
Random python
Python
8 votes151 views4 answers
Remove nan from list python
Python
65 votes150 views4 answers
Python csv dict reader
Python