Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to pivot from column to rows
Added on April 30, 2024 3:21PM
Likes: 0
Replies: 3
abalo006
Registered Posts: 29 ✭
I have data that has a column with the days of the week, source and season. I'm trying to split my days column to rows.
I have picture of my current input and expected output. I tried to use the split function but that split the days into different columns not rows.
is there a way to get my desired output using dataiku?
Input
Output
Operating system used: windows
Operating system used: windows
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,315 NeuronThis is probably easier to do in Python but I am not sure if you are looking for a solution using visual recipes or code recipes. Also are the number of days in the Days column always 7 and always all the days of the week (ie Mon-Sun)? Are you using a SQL dataset?
-
so ideally, I was looking for a visual solution or via code in the prepare recipe. sometimes the number of days can be 1 or 2 Ex. WED,THU
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,315 Neuron
