How to combine several rows to one rows?
Jennnnnny
Registered Posts: 9 ✭
Hello,
My data looks like this:
| Records | values |
| records_0_Name | Jimmy |
| records_0_Number | 1 |
| records_0_Status | Student |
| records_1_Names | Marie |
| records_1_Number | 2 |
| records_1_Status | Worker |
And i want it looks like this:
| Name | Number | Status |
| Jimmy | 1 | Student |
| Marie | 2 | Worker |
Any ideas?
Tagged:
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 DataikerHi,
What you aim to achieve here is a Pivot. This operation can be done in a dedicated Pivot, or Prepare recipes. Given we need first to clean the labels records, the latter recipe is the most straightforward option.
The following steps:
will provide the desired output:
