how to create table Date/Value
显示 更早的评论
i have this data (pic1) and i want similar pic2
Do I have to create the table by entering the values manually or is there a function to do this?
1 个评论
Dyuman Joshi
2024-1-7
Unless you provide specific and necessary details, in written form, explaining what the expected output is, I will be closing the question.
采纳的回答
Try this —
LD = load('matlab_data.mat')
T1 = table(year(LD.dat),month(LD.dat,'shortname'),LD.prof)
ResultSum = unstack(T1, 'Var3', 'Var2');
ResultSum.Properties.VariableNames{1} = 'Year'
The unstack function sums the data by default for each month. Other options are available by defining the appropriate function.
Example —
ResultMean = unstack(T1, 'Var3', 'Var2', 'AggregationFunction',@mean);
ResultMean.Properties.VariableNames{1} = 'Year'
.
6 个评论
shamal
2024-1-7
Star Strider
2024-1-7
As always, my pleasure!
shamal
2024-1-7
I did not check on the month name orders. They are sorted alphabetically, not chronologically. (I do not see options for sorting them differently, so this requires a slightly indirect approach.)
To change that, it is necessary to initially use the month numbers, then over-write the variable names with the appropriate month names.
Try this —
LD = load('matlab_data.mat');
T1 = table(year(LD.dat),month(LD.dat),LD.prof)
ResultMean = unstack(T1, 'Var3', 'Var2', 'AggregationFunction',@mean)
ResultMean.Properties.VariableNames{1} = 'Year';
monthnames = month(datetime(2024,1,1)+calmonths(0:11), 'shortname');
ResultMean.Properties.VariableNames(2:end) = monthnames
Extracting the numbers after the ‘x’ values in ‘x1’...‘x12’ and then assigning the appropriate month names to them is possible, however it is just easier to initially let unstack sort them numerically and then create the month names separately and use those as the variable names. (I checked with the original alphabetically-sorted table, and the new version assigns evertyhing correctly.)
.
shamal
2024-1-7
Star Strider
2024-1-7
Thank you!
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Timetables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
