{"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":"5d4918a5-28b1-5390-956e-b981202e2a3b","task_key":"default--test--81","task_revision_id":"2","upstream_id":"81","short_description":"I have a simple dataframe which I would like to bin for every 3 rows to get sum…","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI have a simple dataframe which I would like to bin for every 3 rows to get sum and 2 rows to get avg from end to head.That means for the last 3 rows get their sum, then 2 rows get their avg, then 3 rows get their sum, then 2 rows get their avg…\\n\\n\\nIt looks like this:\\n\\n\\n    col1\\n0      2\\n1      1\\n2      3\\n3      1\\n4      0\\n5      2\\n6      1\\n7      3\\n8      1\\nand I would like to turn it into this:\\n\\n\\n   col1\\n0     5\\n1     1\\n2     5\\n3     2\\nI have already posted a similar question here but I have no Idea how to port the solution to my current use case.\\n\\n\\nCan you help me out?\\n\\n\\nMany thanks!\\n\\n\\n\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\n\\ndf = pd.DataFrame({'col1':[2, 1, 3, 1, 0, 2, 1, 3, 1]})\\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":[]}