How to filter all data that is not divisible by n in pandas dataframe

Question

In this case n=100

Here's my dataset

id   amount
1    1000
2    2000
3    2300.7632
4    4560

What I want is

id   amount
3    2300.7632
4    4560

Answer 1

Use boolean indexing with modulo %:

df = df[df['amount'] % 100 != 0]
print (df)
   id     amount
2   3  2300.7632
3   4  4560.0000

Same as:

df = df[df['amount'].mod(100).ne(0)]
print (df)
   id     amount
2   3  2300.7632
3   4  4560.0000

Detail:

print (df['amount'].mod(100))
0     0.0000
1     0.0000
2     0.7632
3    60.0000
Name: amount, dtype: float64

It is practically implemented this answer in pandas.

Answer 2

Use

In [1787]: df[(df.amount % 100).astype(bool)]
Out[1787]:
   id     amount
2   3  2300.7632
3   4  4560.0000

Answer 3

In [79]: d[d.amount % 100 > 0]
Out[79]:
   id     amount
2   3  2300.7632
3   4  4560.0000