Pandas > Select data using query

Name
Code
Output
dataframe = pandas.DataFrame(numpy.random.randint(0,10,size=(5, 3)), columns=['C1','C2','C3'])
print ("dataframe")
print (dataframe)
dataframe2 = dataframe.query('C1 > C2')
print ("dataframe selected items")
print (dataframe2)
dataframe
   C1  C2  C3
0   7   3   2
1   1   6   8
2   9   7   3
3   3   2   7
4   4   6   0
dataframe selected items
   C1  C2  C3
0   7   3   2
2   9   7   3
3   3   2   7