Trixology

WeatherCat => WeatherCat General Discussion => Topic started by: rpmik on August 25, 2023, 03:07:38 AM

Title: MesoWest Import to WeatherCat Success
Post by: rpmik on August 25, 2023, 03:07:38 AM

Hi all,
It took a few weeks but I finally came up with a really ugly Python script to convert my weather station's CWOP historical data in MesoWest's CSV format into WeatherCat data files. I used the Synoptic bulk download and that worked out real well. Converting MesoWest's precipitation data from accumulations since UTC midnight to a running year total for the local time zone was a nice puzzle to solve.

So should anyone need help importing their station CWOP data from MesoWest/Synoptic, please contact me and I'll be willing to share the script along with guidance for use.

So now I've got locally accessible historical weather data dating back to 2018 in WeatherCat!  The software's stats are great!  ThU5:-)

Ryan

Title: Thank you! (Re: MesoWest Import to WeatherCat Success)
Post by: elagache on August 25, 2023, 11:10:38 PM

Dear Ryan and WeatherCat faithful,

Quote from: rpmik on August 25, 2023, 03:07:38 AM

It took a few weeks but I finally came up with a really ugly Python script to convert my weather station's CWOP historical data in MesoWest's CSV format into WeatherCat data files. I used the Synoptic bulk download and that worked out real well. Converting MesoWest's precipitation data from accumulations since UTC midnight to a running year total for the local time zone was a nice puzzle to solve.

So should anyone need help importing their station CWOP data from MesoWest/Synoptic, please contact me and I'll be willing to share the script along with guidance for use.

Thank you Ryan for announcing your success and your willingness to share your script with others!

Quote from: rpmik on August 25, 2023, 03:07:38 AM

So now I've got locally accessible historical weather data dating back to 2018 in WeatherCat!  The software's stats are great!  ThU5:-)

I'm glad that you are enjoying the powerful features of WeatherCat.  I think you are starting to understand why the folks on this forum are hooked!

Cheers, Edouard

Title: Re: MesoWest Import to WeatherCat Success
Post by: Blicj11 on August 26, 2023, 12:01:37 AM

I love it when a WeatherCatter figures out a solution and shares it with the rest of us. Thanks Ryan.

Title: Re: MesoWest Import to WeatherCat Success
Post by: rpmik on August 26, 2023, 03:13:01 PM

Thanks everyone for the kind words!

I decided to put the script up on git so you can see how bad I am at Python, or at least, how bad at code hygiene ;-)

This script needs a fair amount of initial human intervention and the one last step to remove a bizarre end of line character that I can't figure out how to prevent. You need to be pretty comfortable with Python and somewhat with how WeatherCat data files work.

https://github.com/rpmik/MesoWestToWeatherCat/ (https://github.com/rpmik/MesoWestToWeatherCat/)