Filtering Data by multiple value SQL
i like to query/filter some data with multiple value using sql query. but i got nothing from it. here is my code. gd = cal.get_date() dfd = datetime.strptime(gd, ‘%m/%d/%y’).strftime(‘%Y-%m-%d’) slspath = (‘C:shgcgrRMWIN b4 patch 12.22.21SLS’ + 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 […]