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
Changing table structure through pivoting
Contributor II
I am a student new to Rapidminer may be missing something but I have the following simple data set
ID | DESCRIPTION
21033207| AMIGDALECTOMIA COM ADENOIDECTOMIA
21033207| MIRINGOTOMIA COM INSERCAO DE TUBO
21033209 | OPERACOES NO VITREO NCOP
21033209 | INJECCAO DE SUBSTITUTO DE VITREO
21033209 | REPARACAO DE DESCOLAMENTO DE RETINA COM DEPRESSAO ESCLERAL E IMP
21033209 | INSERCAO PROTESE INTRAOCULAR CRISTALINO SUCEDENDO A EXTRACCAO CA
21033209 | FACOEMULSIFICACAO E ASPIRACAO DE CATARATA
Each description corresponds to a surgical procedure, My original intention was to create a new column saying if it was performed (alway saying yes) and then pivot it and replace the missing values with No so I could have some thing like this.
ID | AMIGDALECTOMIA COM ADENOIDECTOMIA | MIRINGOTOMIA COM INSERCAO DE TUBO | INJECCAO DE SUBSTITUTO DE VITREO|etc...
21033207| Yes | Yes | No
If I do that I only get a single column with and ID and other just saying Yes, I can see the logic behind that result but then how would I obtain the column I suggested?
ID | DESCRIPTION
21033207| AMIGDALECTOMIA COM ADENOIDECTOMIA
21033207| MIRINGOTOMIA COM INSERCAO DE TUBO
21033209 | OPERACOES NO VITREO NCOP
21033209 | INJECCAO DE SUBSTITUTO DE VITREO
21033209 | REPARACAO DE DESCOLAMENTO DE RETINA COM DEPRESSAO ESCLERAL E IMP
21033209 | INSERCAO PROTESE INTRAOCULAR CRISTALINO SUCEDENDO A EXTRACCAO CA
21033209 | FACOEMULSIFICACAO E ASPIRACAO DE CATARATA
Each description corresponds to a surgical procedure, My original intention was to create a new column saying if it was performed (alway saying yes) and then pivot it and replace the missing values with No so I could have some thing like this.
ID | AMIGDALECTOMIA COM ADENOIDECTOMIA | MIRINGOTOMIA COM INSERCAO DE TUBO | INJECCAO DE SUBSTITUTO DE VITREO|etc...
21033207| Yes | Yes | No
If I do that I only get a single column with and ID and other just saying Yes, I can see the logic behind that result but then how would I obtain the column I suggested?
0
Answers