python - Dataframe not filtering correctly when choosing a specific value (Pandas)

Question

my df looks something like this:

URN	col1	col2	col3	TEMPPNUM
100279	24.0	75.8	0.1	99.9
100055	52.2	47.8	0.0	100.0
107782	12.3	86.2	1.5	100.0
112956	12.3	86.2	1.5	100.0
139957	19.9	79.9	0.2	100.0

Answer 1

One way of doing it

>>> df.query('TEMPPNUM != 100')

Another way would be with 'mask'

>>> df[df.TEMPPNUM!=100]

Both should produce this output

      URN  col1  col2  col3  TEMPPNUM
0  100279  24.0  75.8   0.1      99.9

EDIT:

If your TEMPPNUM is NOT float/int, then you'd can either convert it to such or simply do that

>>> df.query('TEMPPNUM != 100')

      URN  col1  col2  col3 TEMPPNUM
0  100279  24.0  75.8   0.1     99.9
5  123321  91.0  99.0   0.5      100

>>> mask=df['TEMPPNUM'].astype(int) == 100

>>> df[~mask]

      URN  col1  col2  col3 TEMPPNUM
0  100279  24.0  75.8   0.1     99.9