Tables: Create new variables by modifying existing ones
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
roblocks
el 19 de Mayo de 2016
Comentada: roblocks
el 19 de Mayo de 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 comentarios
Respuesta aceptada
Guillaume
el 19 de Mayo de 2016
Editada: Guillaume
el 19 de Mayo de 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_]
Más respuestas (0)
Ver también
Categorías
Más información sobre Characters and Strings en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!