Tables: Create new variables by modifying existing ones
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
roblocks
am 19 Mai 2016
Kommentiert: roblocks
am 19 Mai 2016
Dear All,
I have a table and I would like to create new variables (columns) by modfying existing ones. I have seen examples where poeple apply functions, but these were typically restricted to numerical operations. Supoose I have the following table:
A B C
obs1 te:st X
obs2 test Y
I would like to create
A B C D
obs1 te:st X testX
obs2 test Y testY
So:
- Drop special characters (":")
- Append two string columns.
Can anyone help me out?
Thanks in advance!
0 Kommentare
Akzeptierte Antwort
Guillaume
am 19 Mai 2016
Bearbeitet: Guillaume
am 19 Mai 2016
Use regexprep to replace patterns (with empty strings in your case), and strcat to concatenate cell arrays of strings:
t = cell2table({'obs1', 'te:st', 'X'; 'obs2', 'test', 'Y'}, 'VariableNames', {'A', 'B', 'C'})
t.D = strcat(regexprep(t.B, '\W', ''), test.C)
The regular expresion I've used will drop any character other than [a-ZA-Z0-9_]
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!