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!
Best Answer