Multiply number of days for each month to data column
3 views (last 30 days)
Show older comments
Hello, I have a 1 x 10 cell which includes 10 tables. In all tables I have the date column and precip column. Dates are in monthly format from 1989 to 2018. I want to multiply the number of each month to the corresponding precip value in the same row. I want also to consider leap years. Here is my try so far:
for i = 1:numel(test)
t = test{i};
t.precip = eomday(date)*precip
test{i} = t;
end
this code gives me an error:
Error using eomday (line 13)
Y must be an integer year number.
I don't know what to do. Any help is highly appreciated. I attached my file.
Thank you.
Best regards
0 Comments
Accepted Answer
Bhaskar R
on 13 Feb 2020
for i = 1:numel(test)
test{i}.precip = test{i}.precip.*eomday(year(test{i}.date),month(test{i}.date));
end
More Answers (0)
See Also
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!