How can I create table from matrix?

847 次查看（过去 30 天）
Jhon Gray
Jhon Gray 2018-3-29
评论： Walter Roberson 2023-9-26
I have a matrix like this and I want to create a table with a specific heading of each column.
It should be like this below image:
How can it be done?please help anyone

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

回答（2 个）

Navdha Agarwal
Navdha Agarwal 2019-6-20
Suppose A is the matrix. You can convert it to the table using the following lines of code:
T = array2table(A);
% Default heading for the columns will be A1, A2 and so on.
% You can assign the specific headings to your table in the following manner
T.Properties.VariableNames(1:4) = {'Q25_1','Q25_2','Q25_3','Q25_4'}
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2023-9-26
Ran in:
@Gabriela Garcia
A = randi([-1 99], 12, 7); %some sample data
today = dateshift(datetime('now','format', 'hh:mm a'), 'start', 'day');
rt = today + hours(9:20).';
cn = dateshift(today, 'start', 'week') + caldays(0:6);
cn.Format = 'eeee';
dn = string(cn);
T = array2timetable(A, 'rowtimes', rt, 'VariableNames', dn);
T
T = 12×7 timetable
Time Sunday Monday Tuesday Wednesday Thursday Friday Saturday ________ ______ ______ _______ _________ ________ ______ ________ 09:00 AM 9 52 74 56 42 21 66 10:00 AM 0 83 24 75 3 59 91 11:00 AM 31 53 80 14 53 66 4 12:00 PM 69 22 72 9 16 67 9 01:00 PM 23 99 89 66 19 46 91 02:00 PM 56 36 56 69 18 72 44 03:00 PM 20 62 60 1 20 35 4 04:00 PM 89 9 63 42 14 32 63 05:00 PM 8 78 69 65 70 12 4 06:00 PM 17 98 17 56 98 69 52 07:00 PM 17 22 36 63 97 4 58 08:00 PM 93 61 90 10 66 58 71
It was deliberate that I use datetime operations to calculate the names of the days of the week, so that the day names will appear in whatever language is suitable for your area.
Note however, that if your region's "first day of the week" is monday instead of Sunday, then I do not know what order the days will come out as -- and I do not know what order the array happens to have its days in. You might need to circshift(dn) or something like that.

请先登录，再进行评论。

Yao Lionel
Yao Lionel 2023-9-26
T.Properties.VariableNames={'Name1' , 'Name2', 'Name3', 'Name4'}

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by