Monthly RMSE of daily data taken during a whole year

Question

Victor Martinez 2022-4-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1705410-monthly-rmse-of-daily-data-taken-during-a-whole-year

回答： Ravi 2023-10-14

I have my data on a table in which the first column has all the daily dates of a year (1-Jan-2014, 2-Jan-2014 ... ) and the second and third column contains values of mean daily temperatures calculated by two methods. I would like to compare this two methods calculating the monthly RMSE of the temperatures given by this two methods. That means that for each month, I would like to calculate the squared difference between the temperatures of each day, then the mean of that difference and finally the square root. Is there any way to select only the daily values of each different month taking into account that they have different number of days ? At the end I would like to obtain the 12 values of RMSE for each month, obtained comparing the daily temperatures of the third column (the true daily mean) and the second column (an approximation of the mean calculated by another method).

Thanks for your time.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Anagha Mittal 2022-5-10

Hi!

Please share the table that contains the specified data.

请先登录，再进行评论。

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

Answer 1

Ravi 2023-10-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1705410-monthly-rmse-of-daily-data-taken-during-a-whole-year#answer_1333264

在 MATLAB Online 中打开

Hi Victor Martinez,

I understand that you are trying to find the RMSE of temperature over every month instead of computing it over the year.

Kindly follow the below steps,

Find the month to which a given date belongs to. For this, you can use the “month” function. But the function accepts a datetime object as an argument. Therefore, convert the table date entry into its corresponding datetime object.

month_function = @(dateStr) month(datetime(dateStr, "InputFormat", "dd-MM-yyyy")); 

Use a for loop to iterate over the month numbers starting from 1 to 12. For each month number, extract the data that corresponds to that month number.

%   target month is the current month in iteration 
condition = month_function(data.date) == targetMonth; 
monthData = data(condition, :); 

From the extracted data,
Compute the difference of second and third columns. The result will be a vector.
Square every entry of the vector and sum them up.
Apply square root to the result, which is the required RMSE.
Concatenate the result to a list containing RMSE values for every month.