Newbi - Append Examples to generate a new row
Actually I'm too new with RapidMiner but with quite some experience using Python.
The problem that I'm facing is that I have a file with data in this form:
UserLocation Southport, United Kingdom
What I need to do is to create a new file with each one of the "columns" and their corresponding value in one row for each group of columns. In this example I wrote 2 "groups" or new rows.
I have tried the PIVOT component but because the labels (text) of the Columns are the same (repeated in different rows) it throws an error of "Column name already exists". I also tried the Loop component but I don't know how to tell it "process the first 7 rows, pivot them, generate a new Example (row) and continue gropuing the rest of the file". I know is pretty simple but really can't find the way to do it.
I really appreciate all the help with this.
Thanks in advance!