Pandas: select rows if a specific column satisfies a certain condition

Question

Say I have this dataframe df:

    A   B   C
0   1   1   2
1   2   2   2
2   1   3   1
3   4   5   2

Say you want to select all rows which column C is >1. If I do this:

newdf=df['C']>1

I only obtain True or False in the resulting df. Instead, in the example given I want this result:

    A   B   C
0   1   1   2
1   2   2   2
3   4   5   2

What would you do? Do you suggest using iloc?

Answer 1

Use boolean indexing:

newdf=df[df['C']>1]

Answer 2

use query

df.query('C > 1')