在Python中使用multilinestring中的变量

Question

我正试图使用从AI的GPT-3中提取的pandasql将sql查询放在字符串中。SELECT * FROM netflix WHERE release_year = 2020 AND type = 'Movie' AND listd_in LIKE '%Horror '我现在有的是:

sql_query = "* FROM netflix WHERE release_year = 2020 AND type = 'Movie' AND listed_in LIKE '%Horror%"
q = "SELECT" + sql_query
print(pysqldf(q)) 

但是它一直弹出错误无法识别的标记:"'%Horror%">

我真的不知道如何绕过这个?

Answer 1

您的查询字符串中有几个打字错误。下面是一个工作查询:

sql_query = "* FROM netflix WHERE release_year = 2020 AND type = 'Movie' AND listed_in LIKE '%Horror%'"
q = "SELECT " + sql_query

您需要在SELECT关键字后面加空格，并且LIKE后面的内容必须在单引号中。

Answer 2

您在%Horror%末尾缺少'

sql_query = "* FROM netflix WHERE release_year = 2020 AND type = 'Movie' AND listed_in LIKE '%Horror%'"
q = "SELECT" + sql_query
print(pysqldf(q))