{"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":"302713a8-e18f-5a17-aa2c-5aef9c400edd","task_key":"default--test--67","task_revision_id":"2","upstream_id":"67","short_description":"I have a table like this.","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI have a table like this.\\nuser    01/12/15    02/12/15 someBool\\nu1      100         None      True\\nu2      200        -100      False\\nu3     None          200      True\\n\\n\\nI want to repartition the date columns into two columns date and value like this.\\nuser    date       value   someBool\\nu1      01/12/15   100     True\\nu2      01/12/15   200     False\\nu2      02/12/15  -100     False\\nu3      02/12/15   200     True\\n\\n\\nHow to do this in python ?\\nIs pivot_table in pandas helpful? \\nIf possible provide code/psuedo code & give details on python version. \\n\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\n\\ndf = pd.DataFrame({'user': ['u1', 'u2', 'u3'],\\n                   '01/12/15': [100, 200, None],\\n                   '02/12/15': [None, -100, 200],\\n                   'someBool': [True, False, True]})\\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":[]}