Open In App

How to Filter Rows Based on Column Values with query function in Pandas?

Improve
Improve
Like Article
Like
Save
Share
Report

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.

Python3




df.query("Age>13")


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
Previous
Next
Share your thoughts in the comments
Similar Reads