Filtering Data in Pandas with Query

Filtering data in pandas is super simple using the query method!

#python #coding #datascience

––––––––––––––––––––––––––––––
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
––––––––––––––––––––––––––––––

[innovationscode]

Code is powerful. With the right codes, you can move the world. Thanks

[gardener_dad]

Thanks for the demo. Adapted for CSV...

import pandas as pd
import csv

df = pd.read_csv("file.csv")


df.head()



df.query('DATE == "2023-02-16"')



df.query('DATE == > 25')



df.query('DATE == "2023-02-16"')\
.query('QUANTITY > 6')\
[['PRODUCT']].value_counts()

[LorenzoBaiocco]

Nice! Thanks!
ps. Which font are you using for vscode?

[giantdutchviking]

2 questions if you don't mind:

1. Does it still load entire dataset in memory, then perform query and store query result in df? Or does this reduce loading times of large datasets as it only loads partial data?

2. I'm also using Jupyter Notebook but I don't see those loading times. How can one enable that? And are those estimated times before running or actual times after running?

[yashvisuals]

Hello, I see this similar to SQL queries. So what is the advantage?

[MrGreyfoxut]

I have been learning python and its great, but I still don't see the value of using pandas for data analysis as I can do everything in excel much easier?

[et.sachin]

how can i make the dataframe look tabular and slidable as shown in the video? when i print the dataframe it appears as normal text

[manelfb_]

What the difference between the query method and a pandas filter?

[subadevanc]

AttributeError: 'list' object has no attribute 'query'