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!
Hello!
I have one dataset and I want to split all the columns values (Starting from the column "180 COOL", using || delimiter) and then rename it like attached example. Please let me know if anyone has python code to do this process.
In the provided example screenshot need to split 4 columns. the real dataset contains 7000 columns split and rename.
Hi @jasonsnare,
You can get the desired output without using Python code.
You can use a Prepare recipe with below steps:
- use split function and delimiter "||" in order to split the original column by delimiter and create two separate columns
- remove the original columns
- rename the columns name
โ