How can I get the averages of each day of multiple years?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello,
I have a table with 3 collums: the first collum are dates over 4 years. The second and third collum are vallues of temperature and flowrate of a river for te corresponding date. The Temperature has some NaN's in the data. Nan's have to be ignored
I want to calculate the average temperature and flowrate on each day over this years. So I get a new table (365x3) with each date of the year with these avarage values.
Can someone help me to achive this please?
Thank you!
10 Kommentare
Mathieu NOE
am 2 Dez. 2020
ok ok just worrying about several sections of the final data that looked strange to me
- we can have a valid date and some data (or one data is NaN or both are NaN)
- we have sometimes both data with an invalid date ; NaT (not a time value)
so what do we do in this case ?
extract :
NaT 13.76 3
NaT 14.23 3
NaT 13.63 2.5
NaT 13.22 2.5
NaT 12.08 2.5
NaT 11.18 3
1/05/2006 10.42 3.5
2/05/2006 11.43 3
3/05/2006 13.66 3
4/05/2006 15.49 2.5
5/05/2006 15.77 2.5
6/05/2006 16.17 4
7/05/2006 15.44 2.5
8/05/2006 14.79 2.5
9/05/2006 14.69 3.5
10/05/2006 15.23 3.5
11/05/2006 15.43 3
12/05/2006 16.17 2.5
13/05/2006 16.14 3.5
14/05/2006 15.38 3.5
15/05/2006 14.91 3
16/05/2006 15.57 3
17/05/2006 15.97 3
18/05/2006 NaN 4
19/05/2006 15.5 3.5
20/05/2006 14.1 4.5
21/05/2006 13.84 4.5
22/05/2006 14.8 6
23/05/2006 14.5 4
24/05/2006 13.56 3.5
25/05/2006 13.1 5
26/05/2006 13.17 5.5
27/05/2006 14.01 7
28/05/2006 14.47 7.5
29/05/2006 13.95 5.5
30/05/2006 12.86 5.5
31/05/2006 12.08 4.5
NaT 11.76 4
NaT 11.96 4.5
NaT 13.27 3.5
NaT 14.1 3.5
NaT 14.68 3.5
Antworten (1)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!