24.5 Filter SQL मध्ये vs pandas मध्ये

उदाहरण A — Same answer, two places.

import sqlite3
import pandas as pd

con = sqlite3.connect("data/blinkit_lab.db")

sql_filtered = """
SELECT city, amount_inr
FROM orders
WHERE status = 'Delivered' AND city IN ('Pune', 'Nashik')
"""
df_sql = pd.read_sql_query(sql_filtered, con)

df_all = pd.read_sql_query(
    "SELECT city, status, amount_inr FROM orders",
    con,
)
con.close()

df_pd = df_all.loc[
    (df_all["status"] == "Delivered")
    & (df_all["city"].isin(["Pune", "Nashik"])),
    ["city", "amount_inr"],
]

print("SQL filter GMV", df_sql["amount_inr"].sum())
print("pandas filter GMV", df_pd["amount_inr"].sum())

उदाहरण B — Heavy table habit.

Zoya’s orders table has millions of rows. She never read_sql_table("orders"). She asks SQL for one festival week and six Maharashtra cities, then plots in seaborn.

उदाहरण C — Decision card.