How would I filter a dataframe using 'and' ? In other words, if I have a dataframe named m and it has columns a,b,c,d,e, how would i return all rows where the values in column b are greater than 120 and the vales in column c = 7.3 ?
I tried this but I'm getting an error:
print(m[m['b'] >120, m['c'] ==7.3])
To expand on GoBrewers14's answer, you need to wrap around parenthesis to overcome the order of evaluation of the operators in python.
For example, the next statement fails:
In [3]: 1 > 0 & 'a' < 'b'
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-3-5d58a7b0bade> in <module>()
----> 1 1 > 0 & 'a' < 'b'
TypeError: unsupported operand type(s) for &: 'int' and 'str'
because python evaluates first 0 & 'a'. That's why you need to wrap the statements with parenthesis to make sense:
In [4]: (1 > 0) & ('a' < 'b')
Out[4]: True
In short, you are looking for:
m[(m['b'] > 120) & (m['c'] == 7.3)]
>>> mask = (m.b > 120) & (m.c == 7.3)
>>> m[mask]
orcommand.