Python:Pandas 数值区间筛选 + 多条件组合过滤

import pandas as pdimport numpy as npdf = pd.DataFrame({    "goods_id": range(1, 101),    "price": np.random.randint(100, 6000, 100),    "stock": np.random.randint(5, 300, 100),    "sales": np.random.randint(20, 800, 100)})df.to_excel("range_filter.xlsx", index=False)print("商品区间筛选测试数据生成完成")

import pandas as pddf = pd.read_excel("range_filter.xlsx")# 多条件区间筛选cond = (df["price"] >= 1000) & (df["price"] <= 4000) & (df["stock"] >= 50)target_data = df[cond]# 统计结果print("符合条件商品数量：", len(target_data))print("\n筛选后前五条数据：")print(target_data[["goods_id","price","stock","sales"]].head())