Help with changing text in a table
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
gurjeevan singh
le 14 Mai 2022
Modifié(e) : gurjeevan singh
le 14 Mai 2022
Dear Sir/Madam,
I am fairly new to matlab and im having a problem with converting text in my table to different names. I have a table called X and under the column 'StepID' I have repeated characters of 'a to h' (8000 rows). I would like to change 'a' to 'protein A' and 'b' to 'VI' and 'c' to a different a name and so and and so forth until h. How could I implement this in Matlab.
Any help is greatly is greatly appreciated (using R2020b)
Best Regards,
Jeevs S
0 commentaires
Réponse acceptée
dpb
le 14 Mai 2022
tSingh=readtable('singhData.xlsx');
catnames={'Protein A','VI','DI','AN', 'UF','CA','VRF','DF'};
tSingh.Step=categorical(tSingh.StepID,unique(tSingh.StepID),catnames);
results in
>> head(tSingh)
ans =
8×3 table
StepID M Step
______ _____ _________
{'a'} 0.00 Protein A
{'b'} 0.00 VI
{'c'} 0.00 DI
{'d'} 0.00 AN
{'e'} 0.00 UF
{'f'} 0.00 CA
{'g'} 10.00 VRF
{'h'} 5.71 DF
>>
You can, of course, replace 'StepID' in place if don't need the original any longer...
NB: the shorthand to get the valueset list instead of the constructed list...it's cleaner and is also sorted by unique()
0 commentaires
Plus de réponses (1)
dpb
le 14 Mai 2022
Modifié(e) : dpb
le 14 Mai 2022
It's always bestest to attach a short section of your file/variable that illustrates...but will take a stab at it from the description.
Sounds like a place for a categorical variable instead of just string substitution -- try
catnames={'Protein A','VI', ...}; % DEFINE THE display names for each category
tX.Step=categorical(cellstr(tX.Step),cellstr(['a':'h'].'),catnames);
You didn't provide the full list; you'll have to create it to match as desired...
3 commentaires
dpb
le 14 Mai 2022
Modifié(e) : dpb
le 14 Mai 2022
That's a fignewton of the cut' n paste from the command line I didn't see...the ">>" command prompt doesn't belong in there; not sure how it did get there, but..
catnames={'Protein A','VI', ...}; % DEFINE THE display names for each category
tX.Step=categorical(cellstr(tX.Step),cellstr(['a':'h'].'),catnames);
will have a much better chance....
Voir également
Catégories
En savoir plus sur Characters and Strings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!