Split and rename columns

[jasonsnare]

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.

[CatalinaS]

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