period = '573'
SHYA= sqldf('select PPMONTH, REGION, WEARSEG, sum(uncal_value) as uncal_value \
from Ftable where region in ("Shanghai") and WEARSEG in ("Men","Women")\
and PPMONTH in (period) group by PPMONTH,WEARSEG')
在sql里面用 in (period') 为什么没用？
PandaSQLException: (sqlite3.OperationalError) no such column: period [SQL: 'select PPMONTH, REGION, WEARSEG, sum(uncal_value) as uncal_value### 题目描述
The source of the topic and my own ideas
// Please paste the code text below (do not use pictures instead of codes)
What are your expectations? What is the actual error message?