Topic: Analysing weather data

[sleepy67]

Hi,
I'm wondering how people analyse their weather data.  My station uploads to ecowitt and wunderground and scrape this data on Ubuntu into a csv.

So I have just under half million rows of data, which is nice, but information overload.

I've tried Power BI, but it's a bit restrictive using it from a home account, so I'm now trying Tableau.

Has anyone else used any data analysis tools?  I'm keen to share and learn.

Thanks
Tony

[R.Sidetrack]

Its not clear to me exactly what kind of data analysis you want to do, but perhaps CumulusMX might be useful?
https://cumuluswiki.org/a/Software

CumulusMX can pull data directly from your local Ecowitt gateway, so data collection is not dependent on your internet connection.

As you mentioned Ubuntu, I'll point out that there is a Raspberry Pi image with CumulusMX which may be of interest.

[weatherdoc]

As @R.Sidetrack said, it depends what kind of analysis you want to do. I use Weather Display and have multiple ways of displaying the data:

https://wxdoc.info/tabular.php
https://wxdoc.info/wxhistory.php
https://wxdoc.info/wxwuhistory.php
https://wxdoc.info/202502-daily-charts.php
https://wxdoc.info/climaterecordfeb2025.php
https://wxdoc.info/wxrecords.php

For any specific weather events in which I wanted to dig deeper or customize the data I just use Excel. Tableau graphs look nicer than Excel, IMHO.

[DesertRatR]

Brand new to this forum, here goes. My Ambient Weather station downloads csv data in 5 min increments. It provides pretty much anything the backyard hobbyist cares about. Plenty for me to work with in a spreadsheet. I prefer xy plots, rather than color contours, so it works.

[sleepy67]

I have been getting used to Tableau, the lite public version which is free to use and have found it gives me easy access to year on year graphs.  Now I am only a beginner here but the graphs are quite easy to generate for any of the fields imported in the excel.
 [ You are not allowed to view attachments ]
 [ You are not allowed to view attachments ]

[sleepy67]

Hi.  Bit of an update on using Tableau to graphically represent weather data.  Fig1 focuses on temperatures with the upper graph grouped by year and month and the lower graph performing a count when day temp > 20 degrees.  Fig2 is quite basic and shows, for each day, pressure vs rain accumulation.  Fig3 is a weekly bar graph for rain accumulation.  There is a filter top right to select date ranges and each bar is a weeks worth of rain with the blocks showing when it rained continuously.
Hope this is helpful and I'd be interested if anyone else uses Tableau.
Thanks
Tony