0 实验数据

仓库商品信息全表（表名=sku_all）

仓库	仓库ID	SKU	状态	批次	效期	批号	库存
备货仓	7	102001	1	YQ1HMC	43693	20190816	11
...	...	...	...	...	...	...	...
华东仓(原零售仓)	5	102116	1	YQ2FMA	43622	20190606	7
内部测试仓	0

import pandas as pd
sku_all = pd.DataFrame([['备货仓','7','102001','1','YQ1HMC','43693','20190816',11],['华东仓(原零售仓)','5','102001','1','YQ1HMC','43693','20190816',5],['备货仓','7','102001','3','YQ1HMC','43693','20190816',1],['华东仓(原零售仓)','5','102002','1','YQ1HMB','43692','20190815',6],['华东仓(原零售仓)','5','102005','1','YQ1HMB','43693','20190816',10],['备货仓','7','102101','3','CSQA002','43130','20180130',1],['华东仓(原零售仓)','5','102104','1','CSRF001','43651','20190705',6],['备货仓','7','102104','3','dfhg','43651','20190705',1],['华东仓(原零售仓)','5','102105','1','CSRE001','43609','20190524',2],['备货仓','7','102105','3','0411A','43609','20190524',1],['华东仓(原零售仓)','5','102111','1','CSRF001','43651','20190705',2],['华东仓(原零售仓)','5','102111','1','fh22','43651','20190705',1],['备货仓','7','102111','3','dg0h52','43587','20190502',1],['备货仓','7','102113','3','CSRF002','43651','20190705',1],['华东仓(原零售仓)','5','102114','1','A','43634','20190618',1],['备货仓','7','102114','3','fh02','43634','20190618',1],['华东仓(原零售仓)','5','102115','1','','43650','20190704',1],['备货仓','7','102116','1','YQ2FMA','43622','20190606',6],['华东仓(原零售仓)','5','102116','1','YQ2FMA','43622','20190606',7],['内部测试仓','0','','','','','',]],columns=['仓库','仓库编号','SKU','状态','批次','有效日期','批号','库存'])

1 数据筛选(等价于SQL中的where语句)

# 仅选取备货仓中，涉及SKU在'102001'和'102104'中，且要求单行库存数量高于10的数据
sku_all[(sku_all['仓库']=='备货仓') & (sku_all['SKU'].isin(['102001','102104'])) & (sku_all['库存']>=10)]

# SKU “不” 在'102001'和'102104'中，且要求单行库存数量高于10的数据
sku_all[-(sku_all['SKU'].isin(['102001','102104'])) & (sku_all['库存']>=10)]

# 仅选取仓库名称中不含“备货”两字，且要求单行库存数量高于10的数据
sku_all[-(sku_all['仓库'].str.contains('备货')) & (sku_all['库存']>=10)]

数据筛选