How to Filter Rows Based on Column Values with query function in Pandas?
In this article, let’s see how to filter rows based on column values. Query function can be used to filter rows based on column values.
Consider below Dataframe:
Python3
import pandas as pd
data = [[ 'A' , 10 ], [ 'B' , 15 ], [ 'C' , 14 ], [ 'D' , 12 ]]
df = pd.DataFrame(data, columns = [ 'Name' , 'Age' ])
df
|
Output:
Our DataFrame
Now, Suppose You want to get only persons that have Age >13. We can use Query function of Pandas.
Output:
Using Query with only 1 Column
Now, If you want multiple columns. For example, you want to have Age >13 and Name = C. Then,
Python3
df.query( "Age>13 and Name=='C'" )
|
Output:
Using multiple cols filter
Last Updated :
11 Dec, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...