Averaging different text files according to there month and year
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Michael Lauria
am 21 Nov. 2018
Kommentiert: Michael Lauria
am 21 Nov. 2018
I have serveral text files (around 100) contating data from different months of different years.
Example File
Year-Month-Data
1992 9 353.07
1992 10 359.88
1992 11 361.09
1992 12 360.35
Not every file matches the start and end date of the other (ie. some files start in 1969 and other in 2000...etc). But I still want to average the data of each corresponding month of the matching year.
~If 1992 (year) 9 (month) then average coresponding data value.
If the file has no matching month or year then the loop simply skips over it.
Would anyone know where to start here?
Many Thanks
0 Kommentare
Akzeptierte Antwort
Cris LaPierre
am 21 Nov. 2018
Bearbeitet: Cris LaPierre
am 21 Nov. 2018
The datetime data type "understands" the concept of year, month, etc., which should simplify selecting a month's worth of data to average. You even have the potential to do it in just a couple lines of code using findgroups and splitapply functions.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu String Parsing 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!