Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
This 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