Update the number of columns needed for my times table

3 visualizaciones (últimos 30 días)
Norma
Norma el 12 de Sept. de 2024
Comentada: Star Strider el 12 de Sept. de 2024
Hello, when I convert my csv file to a timestable, it's saying there are 67 columns when there should be 65 columns. I want to update the Variable Names and its not allowing me to edit the headers in the table without editing all the variables. When I attempt it, i get this error: "Conversion to cell from char is not possible." How do I count the number of columns in a timestable to then be able to delete the excess columns left over at the end of the table so that I can update the variableNames? I'm still fairly new to MATLAB and dealing with an older version so I'm having trouble with this.
  1 comentario
Stephen23
Stephen23 el 12 de Sept. de 2024
"How do I count the number of columns in a timestable to then be able to delete the excess columns left over at the end of the table so that I can update the variableNames?"
I doubt that you need to count them:
N = 5; % number of required columns
T = array2table(randi(9,4,7)) % extra columns
T = 4x7 table
Var1 Var2 Var3 Var4 Var5 Var6 Var7 ____ ____ ____ ____ ____ ____ ____ 5 4 8 3 6 9 9 1 1 6 4 9 5 8 3 5 4 6 7 4 2 7 4 1 9 8 7 7
T(:,N+1:end) = []
T = 4x5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 5 4 8 3 6 1 1 6 4 9 3 5 4 6 7 7 4 1 9 8
Note that you might lose data.

Iniciar sesión para comentar.

Respuesta aceptada

Star Strider
Star Strider el 12 de Sept. de 2024
It would heelp to have your .csv file and a description of what you want to do. Also, it might be easiier to do this in a table and then use table2timetable to convert it to a timetable.
If you only want to edit one variable name, that is straightforward —
T1 = array2table(randi(50,5))
T1 = 5x5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 21 40 39 48 40 36 3 44 24 25 4 14 23 26 23 19 26 2 30 37 46 20 14 42 9
T1.Properties.VariableNames{3} = 'Column 3'
T1 = 5x5 table
Var1 Var2 Column 3 Var4 Var5 ____ ____ ________ ____ ____ 21 40 39 48 40 36 3 44 24 25 4 14 23 26 23 19 26 2 30 37 46 20 14 42 9
Just choose the one you want to change.
.
  2 comentarios
Norma
Norma el 12 de Sept. de 2024
Hello, thank you so much! I was using parentheses instead of curly braces.
Star Strider
Star Strider el 12 de Sept. de 2024
As always, my pleasure!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Structures en Help Center y File Exchange.

Productos


Versión

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by