Update the number of columns needed for my times table

5 views (last 30 days)
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 Comment
Stephen23
Stephen23 on 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.

Sign in to comment.

Accepted Answer

Star Strider
Star Strider on 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.
.

More Answers (0)

Categories

Find more on Structures in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!