MesoWest Import to WeatherCat Success

[rpmik]

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! 

Ryan

[elagache]

Dear Ryan and WeatherCat faithful,

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!

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

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

[Blicj11]

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

[rpmik]

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/