The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"split values of column into new column"
Learner III
Hi,
would I would like be able to split certain values in a column and put these values in a new column. I.e:
|"Cognome"|"Nome"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"
The "Via_completa"column is made out of the values 'VIA' and 'NAPOLI'. To normalize the address according to my data set I would like to split the values 'VIA' and 'NAPOLI' in the column "Via_completa" and create a new column called 'DUG' and place value 'VIA' in the new column.
Like this:
"Cognome"|"Nome"|"DUG"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA"|"NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"
In Excel there is a 'Split text among columns' function. Is there a similar operator in Rapid miner to execute this function?
Thanks,
Friso
would I would like be able to split certain values in a column and put these values in a new column. I.e:
|"Cognome"|"Nome"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"
The "Via_completa"column is made out of the values 'VIA' and 'NAPOLI'. To normalize the address according to my data set I would like to split the values 'VIA' and 'NAPOLI' in the column "Via_completa" and create a new column called 'DUG' and place value 'VIA' in the new column.
Like this:
"Cognome"|"Nome"|"DUG"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA"|"NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"
In Excel there is a 'Split text among columns' function. Is there a similar operator in Rapid miner to execute this function?
Thanks,
Friso
Tagged:
0
Answers
If you read this as .CSV you can directly do the split using a regular expression. Otherwise the split operator is the way to go.
Best,
Martin
Dortmund, Germany