Extract hourly data from minute data over a year
Show older comments
Hi, I have raw weather data (titled 'weather_data_2019') from 2019 that is documented by every minute. The txt file is formatted so it gives the data and time such as:
2019-01-01 hh:mm:ss, recno, wind speed, par, wsdv, wddv, temp, rain delta, rh, wind dir.
For example this is the first line of data:
2019-01-01 00:00:00,81598,0.0,0.0,0.0,0.0,32.86,0.0,96.8,0.0
I also have attached a txt file for the first day (the file is too large to allow me to upload the whole year). I have been trying to have my code so that it opens the file and only extracts all the data every day at every hour on the dot, so that my code can cut down on the amount of data it needs to go through. So far I'm not having any luck with this, any ideas as to how this can be achieved? Thank you!
Accepted Answer
More Answers (0)
Categories
Find more on Text Files 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!