I feel like this question must have been answered by someone before, but I can't find an answer on stack overflow!
I have a dataframe result
that looks like this and I want to remove all the values less than or equal to 10
>>> result
Name Value Date
189 Sall 19.0 11/14/15
191 Sam 10.0 11/14/15
192 Richard 21.0 11/14/15
193 Ingrid 4.0 11/14/15
This command works and removes all the values that are 10:
df2 = result[result['Value'] != 10]
But when I try to add the <= qualifier I get the error message SyntaxError: invalid syntax
df3 = result[result['Value'] ! <= 10]
I feel like there is probably a really simple solution. Thanks in advance!
Instead of this
df3 = result[result['Value'] ! <= 10]
Use
df3 = result[~(result['Value'] <= 10)]
It will work. OR simply use
df3 = result[result['Value'] > 10]