Selecting with complex criteria using query method in Pandas
Filter data using query method:
import pandas as pd df = pd.DataFrame([[10, 20, 30, 40], [7, 14, 21, 28], [55, 15, 8, 12]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3']) print(df) print("\n ----------- Filter data using query method ------------- \n") df1 = df.ix[df.query('Apple > 50 & Orange <= 15 & Banana < 15 & Pear == 12').index] print(df1)
C:\pandas>python example.py Apple Orange Banana Pear Basket1 10 20 30 40 Basket2 7 14 21 28 Basket3 55 15 8 12 ----------- Filter data using query method ------------- Apple Orange Banana Pear Basket3 55 15 8 12 C:\pandas>
2018-10-18T13:38:05+05:30
2018-10-18T13:38:05+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution