我喜歡使用 sql 查詢查詢/過濾一些具有多個值的資料。但我一無所獲。這是我的代碼。
gd = cal.get_date()
dfd = datetime.strptime(gd, '%m/%d/%y').strftime('%Y-%m-%d')
slspath = ('C:\\shgcgr\\RMWIN b4 patch 12.22.21\\SLS' my '.DBF')
slsdbf = DBF(slspath)
slsframe = DataFrame(iter(slsdbf))
dinerc = '1,4,5,7,8,13,14'
lunchdi = ps.sqldf("SELECT SUM(slsframe.total) AS 'netsales_for_lunch' From slsframe Where open_time >= '12:00:00' And open_time < '13:59:59' And date = '" dfd "'" "And rev_center = '" dinerc "'")
lunchdidf = DataFrame(lunchdi)
print(lunchdidf)
提前致謝。
uj5u.com熱心網友回復：
dinerc 似乎是一個 rev_centers 串列，因此您可能需要使用 IN 而不是 = ，試試這個：
lunchdi = ps.sqldf("SELECT SUM(slsframe.total) AS 'netsales_for_lunch' From slsframe Where open_time >= '12:00:00' And open_time < '13:59:59' And date = '" dfd "'" "And rev_center IN (" dinerc ")")
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/391753.html
上一篇：sqlgroup按年齡范圍更新列