{"kind":"task","effective_mode":"full","benchmark":{"kind":"benchmark","effective_mode":"full","slug":"ds-1000","formal_name":"DS-1000","introduction":"DS-1000 builds 1,000 data-science problems from real StackOverflow questions across seven libraries including NumPy, Pandas and Matplotlib. The problems are perturbed so that recalling the original answer does not solve them.","introduction_ja":"","introduction_en":"","category":"Category not supplied","task_count":null,"acquisition_status":"Acquisition status not supplied","official_url":"https://ds1000-code-gen.github.io/","indexing_mode":"noindex","profile":{"resources":[],"task_format":"","scoring":"","metric":"","size":"","answer_access":"","license":"","citation":"","maintainer":"","released":"","why_hard":"","related":[]}},"task_id":"03f572c6-afbb-56c0-bb3c-6e9323352ed3","task_key":"default--test--140","task_revision_id":"2","upstream_id":"140","short_description":"I am performing a query on a DataFrame:","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI am performing a query on a DataFrame:\\nIndex Category\\n1     Foo\\n2     Bar\\n3     Cho\\n4     Foo\\n\\n\\nI would like to return the rows where the category is not \\\"Foo\\\" or \\\"Bar\\\".\\nWhen I use the code:\\ndf.query(\\\"Catergory!=['Foo','Bar']\\\")\\n\\n\\nThis works fine and returns:\\nIndex Category\\n3     Cho\\n\\n\\nHowever in future I will want the filter to be changed dynamically so I wrote:\\nfilter_list=['Foo','Bar']\\ndf.query(\\\"Catergory!=filter_list\\\")\\n\\n\\nWhich threw out the error:\\nUndefinedVariableError: name 'filter_list' is not defined\\n\\n\\nOther variations I tried with no success were:\\ndf.query(\\\"Catergory\\\"!=filter_list)\\ndf.query(\\\"Catergory!=\\\"filter_list)\\n\\n\\nRespectively producing:\\nValueError: expr must be a string to be evaluated, <class 'bool'> given\\nSyntaxError: invalid syntax\\n\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\n\\ndf=pd.DataFrame({\\\"Category\\\":['Foo','Bar','Cho','Foo'],'Index':[1,2,3,4]})\\nfilter_list=['Foo','Bar']\\n</code>\\nresult = ... # put solution in this variable\\nBEGIN SOLUTION\\n<code>\\n\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://ds1000-code-gen.github.io/","history":"initial import","indexing_mode":"noindex","subproblems":[],"grids":[]}