how to convert table to matrix?

As an alternative, you can convert a table to an array by using the syntax “T{:,:}”, where “T” is the table. This syntax is the equivalent of “table2array”.

All variables in the table must have sizes and data types that allow them to be horizontally concatenated. For example, if all variables in “T” are numeric, then “table2array” returns a numeric array.

2 个评论
显示无隐藏无

Arsalan Aftab Sayed 2020-12-16

I tried both table2array and “T{:,:}” but it changes the values inside the table from 0.7 to 1. Is there a way I can keep the original values, I tried using double datatype but it doesn't work

Walter Roberson 2020-12-16

在 MATLAB Online 中打开

table2array() converting 0.7 to 1 could happen if the table is mixed data type including at least one integer data type such as uint8 . Please check

unique( varfun(@class, T, 'outputformat', 'cell') )

请先登录，再进行评论。

Answer 4

Sulaymon Eshkabilov 2021-8-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380821-how-to-convert-table-to-matrix#answer_760182

在 MATLAB Online 中打开

Another alternative to convert table to matrix is to use a syntax: M=T.Var, e.g.

T = table(magic(5))
T = 5×1 table
               Var1           
    __________________________

    17    24     1     8    15
    23     5     7    14    16
     4     6    13    20    22
    10    12    19    21     3
    11    18    25     2     9
M=T.Var1
M = 5×5
    17    24     1     8    15
    23     5     7    14    16
     4     6    13    20    22
    10    12    19    21     3
    11    18    25     2     9

6 个评论
显示 4更早的评论隐藏 4更早的评论

David Alejandro Ramirez Cajigas 2021-8-18

What can I do if I have N var, with random names, inside a table that imports from excel, this table can vary.

that is, the method of putting T. "name var" is not possible if I have N quantity of varials with N different names

Walter Roberson 2021-8-18

在 MATLAB Online 中打开

@David Alejandro Ramirez Cajigas

You can use variable indexes if the indexes are constant.

If the variable order is not constant, then you can take T.Properties.VariableNames and extract whatever subset of those you want and sort them in whatever you want. Then you can loop doing dynamic field names.

Example, selecting variables that start with "run"

names = T.Properties.VariableNames;
runvars = sort(names(startsWith(names, 'run')));
nrun = length(runvars);
for varidx = 1 : nrun
    thisvarname = runvars{varidx};
    thiscontent = T.(thisvarname);
    stuff here
end