/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

3 votes114 views1 answer
Get_absolute_url in django template
Python
0 vote148 views1 answer
Print pattern a shape in python
Python
1 vote207 views1 answer
User defined functions python
Python
7 votes151 views2 answers
Make a condition statement on column pandas
Python
0 vote156 views1 answer
Fcn tensorflow
Python
0 vote149 views1 answer
Pandas check match string lowercase
Python
5 votes166 views3 answers
Strptime python
Python
0 vote157 views2 answers
How to avoid inserting duplicate records in orm django
Python
19 votes168 views1 answer
Error tokenizing data. c error
Python
0 vote165 views1 answer
Python queue not empty
Python