{"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":"d4573ca4-f8f0-56b8-a52a-fcd25e687514","task_key":"default--test--198","task_revision_id":"2","upstream_id":"198","short_description":"I am trying to get count of letter chars in column using Pandas.","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI am trying to get count of letter chars in column using Pandas.\\nBut not getting desired output.\\nMy .txt file is:\\nstr\\nAa\\nBb\\n?? ?\\nx;\\n###\\n\\n\\nMy Code is :\\nimport pandas as pd\\ndf=pd.read_csv('inn.txt',sep='\\\\t')\\ndef count_special_char(string):\\n    special_char = 0\\n    for i in range(len(string)):\\n        if(string[i].isalpha()):\\n            continue\\n        else:\\n            special_char = special_char + 1\\ndf[\\\"new\\\"]=df.apply(count_special_char, axis = 0)\\nprint(df)\\n\\n\\nAnd the output is:\\n    str  new\\n0    Aa  NaN\\n1    Bb  NaN\\n2  ?? ?  NaN\\n3   ###  NaN\\n4   x;      Nan\\n\\n\\nDesired output is:\\n      str  new\\n0      Aa    2\\n1      Bb    2\\n2    ?? ?    0\\n3     ###    0\\n4  {}xxa;    3\\n\\n\\n\\n\\nHow to go ahead on this ?\\n\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\n\\ndf = pd.DataFrame({'str': ['Aa', 'Bb', '?? ?', '###', '{}xxa;']})\\n</code>\\ndf = ... # 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":[]}