{"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":"bd42916c-5b59-53cd-8aa2-aa182db62155","task_key":"default--test--41","task_revision_id":"2","upstream_id":"41","short_description":"I have a dataframe with numerous columns (≈30) from an external source (csv…","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI have a dataframe with numerous columns (≈30) from an external source (csv file) but several of them have no value or always the same. Thus, I would to see quickly the value_counts for each column. How can i do that?\\nFor example\\n  id, temp, name\\n1 34, null, mark\\n2 22, null, mark\\n3 34, null, mark\\n\\nPlease return a String like this:\\n\\n---- id ---\\n34    2\\n22    1\\nName: id, dtype: int64\\n---- temp ---\\nnull    3\\nName: temp, dtype: int64\\n---- name ---\\nmark    3\\nName: name, dtype: int64\\n\\nSo I would know that temp is irrelevant and name is not interesting (always the same)\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\ndf = pd.DataFrame(data=[[34, 'null', 'mark'], [22, 'null', 'mark'], [34, 'null', 'mark']], columns=['id', 'temp', 'name'], index=[1, 2, 3])\\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":[]}