Update the number of columns needed for my times table

5 次查看（过去 30 天）
Norma
Norma 2024-9-12
评论： Star Strider 2024-9-12
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 个评论
Stephen23
Stephen23 2024-9-12
Ran in:
"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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2024-9-12
Ran in:
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.
.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by