Filtering Rows with the Query Function
Learn how to use the query function for filtering a DataFrame.
We'll cover the following
The query
function
The query
function is another way to filter values in a DataFrame
.
It differs from previous functions because it can write the conditions as text. It’s quite useful and is more practical in various cases.
Here’s how we can select products with a price higher than 100 by using the query
function:
sales_filtered = sales.query("price > 100")
We can apply multiple conditions with the query
function as well.
In the previous lesson, we created a condition based on the price
and stock quantity
columns. Let’s do the same using the query
function.
Get hands-on with 1200+ tech skills courses.