Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Split cell data into rows
thiago_caixeta
Member Posts: 3 Learner III
in Help
Hello,
Is there a way to split data in a cell to rows, instead columns?
Example:
What I really need now is the results one below the other, instead of columns....
Thank you!
Is there a way to split data in a cell to rows, instead columns?
Example:
What I really need now is the results one below the other, instead of columns....
Thank you!
Tagged:
0
Best Answer
-
BalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 UnicornHi,
you first split to columns, then use De-Pivot to transform these to rows.
Usually it's good to only work on a subset of your attributes (the column you want to split and some kind of Id column to join back later) because de-pivot makes working with all columns harder.
Regards,
Balázs8
Answers
Dortmund, Germany
Yes, is there a way to do it?
I propose an alternative method using a Python script (Pandas library) to perform what you want to do :
To execute this process, you will need :
- to install Python on your computer.
- to install the Python Scripting extension from the Marketplace.
The process :
Hope this helps,
Regards,
Lionel
Thank you very much for your help!!