Python:Pandas 多条件自定义筛选query语法 复杂逻辑轻量化写法

import pandas as pdimport numpy as npnp.random.seed(88)df = pd.DataFrame({    "goods_id": range(1, 150),    "category": np.random.choice(["数码","家居","美妆"], 149),    "price": np.random.uniform(120, 6800, 149).round(2),    "stock": np.random.randint(0, 300, 149),    "monthly_sales": np.random.randint(0, 1200, 149),    "on_sale": np.random.choice([0, 1], 149)})df.to_excel("query_goods_data.xlsx", index=False)print("query多条件筛选商品测试数据生成完成")

import pandas as pddf = pd.read_excel("query_goods_data.xlsx")# 定义外部阈值变量，query通过@调用min_price = 1000max_price = 5000min_stock = 50min_sales = 100# 复杂多条件筛选，一行完成，可读性远优于布尔索引filter_df = df.query(    "category == '数码' "    "& (@min_price <= price <= @max_price) "    "& stock >= @min_stock "    "& monthly_sales >= @min_sales "    "& on_sale == 1")print("符合筛选条件商品总数：", len(filter_df))print("\n筛选结果前8行：")print(filter_df[["goods_id","category","price","stock","monthly_sales"]].head(8))