Plot average monthly flow from Jan-Dec for 'x' number of yrs on one plot using the provided data

Question

Harjas 2022-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1770650-plot-average-monthly-flow-from-jan-dec-for-x-number-of-yrs-on-one-plot-using-the-provided-data

回答： Cris LaPierre 2022-7-29

Hello MATLAB Community,

I want to plot the average monthly values from Jan-Dec for 'x' number of years on the same plot. I was able to calculate the average using groupsummary. How can I use the isbetween or any other function to separate out those years in varaible 'yr' from the Mean table and plot them in single plot. I have also attached the sample output which I am expecting to get.

clc

clear

close all

data = readtable('Test.xlsx');

Mean = groupsummary(data,'Date','month','mean');

yr=[1977,1988,1989,1991,2003]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2022-7-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1770650-plot-average-monthly-flow-from-jan-dec-for-x-number-of-yrs-on-one-plot-using-the-provided-data#answer_1017730

在 MATLAB Online 中打开

Group by year and monthofyear. Then you can use ismember and reshape to identify and organize the data in a manner that will allow you to generate the desired plot.

file = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1082210/TEST%20(1).xlsx';

data = readtable(file);

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

Mean = groupsummary(data,{'Date_Time','Date_Time'},{'year','monthofyear'},'mean','WaterLevel')

Mean = 456×4 table

year_Date_Time monthofyear_Date_Time GroupCount mean_WaterLevel ______________ _____________________ __________ _______________ 1977 1 31 870.48 1977 2 28 896.25 1977 3 31 843.29 1977 4 30 864.07 1977 5 31 829.68 1977 6 30 1251 1977 7 31 1425.2 1977 8 31 1345.5 1977 9 30 1124.3 1977 10 31 825.16 1977 11 30 794.27 1977 12 31 813.52 1978 1 31 876.52 1978 2 28 858.93 1978 3 31 806.65 1978 4 30 763.37

yrs = [1977,1988,1989,1991,2003];

yr=ismember(str2double(string(Mean.year_Date_Time)),yrs);

x = reshape(Mean.monthofyear_Date_Time(yr),12,[]);

y = reshape(Mean.mean_WaterLevel(yr),12,[]);

plot(x,y)