Update the number of columns needed for my times table

5 vues (au cours des 30 derniers jours)
Norma
Norma le 12 Sep 2024
Commenté : Star Strider le 12 Sep 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 commentaire
Stephen23
Stephen23 le 12 Sep 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.

Connectez-vous pour commenter.

Réponse acceptée

Star Strider
Star Strider le 12 Sep 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 commentaires
Norma
Norma le 12 Sep 2024
Hello, thank you so much! I was using parentheses instead of curly braces.
Star Strider
Star Strider le 12 Sep 2024
As always, my pleasure!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Structures dans Help Center et File Exchange

Produits


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by