Assigning row names iteratively
Show older comments
Hello, i have a [365, 24] table reporting values per hour for each day of the year.
How can I assign days names to all 365 rows ('Monday','Tuesday'...) without writing 365 names with 'RowNames'?
1 Comment
Stephen23
on 4 Dec 2023
There is only a small chance that some random year will start on a Monday.
To obtain the correct days of the week you should use DATETIME.
Accepted Answer
The row names of a table cannot be non-unique, so having the names of the 7 days of the week repeat 52 times would not generate legitimate input for RowNames. However, you can make a string column of the days of the week as below and prepend it to your table as an additional (but ordinary) table column.
names=repmat(["Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"],52,1);
names=[names;names(1)]
1 Comment
illiterate
on 4 Dec 2023
More Answers (0)
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
