熊猫查询失败
熊猫查询失败
提问于 2022-10-27 12:09:49
鉴于以下CSV：
ID,Title,Created By,Created On,Estimate,Forecast,Priority,References,Section,Section Depth,Section Description,Suite,Suite ID,Type,Updated By,Updated On
C28045,test1,dsa,10/27/2022 1:56 AM,,,Highest,,primary,0,,Master,S378,Automated,test,10/27/2022 4:33 AM
C28060,test32,dsa,10/27/2022 4:34 AM,,,Medium,,primary,0,,Master,S378,Automated,test,10/27/2022 4:34 AM
C28062,test5,dsa,10/27/2022 4:34 AM,,,Medium,,primary,0,,Master,S378,Automated,test,10/27/2022 4:34 AM
C28059,test6,dsa,10/27/2022 4:06 AM,,,Medium,,sec,0,,Master,S378,Automated,test,10/27/2022 4:33 AM
C28061,test643,dsa,10/27/2022 4:34 AM,,,Medium,,sec,0,,Master,S378,Automated,test,10/27/2022 4:34 AM
C28063,tes4352,dsa,10/27/2022 4:34 AM,,,Medium,,sec,0,,Master,S378,Automated,test,10/27/2022 4:34 AM使用熊猫，我想返回ID，为给定的“部分”和“标题”
data = pd.read_csv(csvPath)
data.query('Section = primary and Title = test32', inplace=True)
print(data)提出：
File "<unknown>", line 1
Section =primary and Title =test32
^^^^^^^^^^^^^^^^
SyntaxError: Python keyword not valid identifier in numexpr query回答 2
Stack Overflow用户
回答已采纳
发布于 2022-10-27 12:18:25
看起来你少了几个引号，应该使用'==‘
# using query, filter for Section == 'primary' and Title == 'test32'
data.query("Section == 'primary' and Title == 'test32'", inplace=True)Stack Overflow用户
发布于 2022-10-27 12:20:58
这能解决你的问题吗？
data = pd.read_csv(csvPath)
data=data[(data['Section']=='primary' & data['Title']=='test32')]页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/74221803
复制相关文章
相似问题
腾讯云开发者
