Example query and analysis using R


Andi Fugard M0INF
 

Greetings,

I just found this database and group - really wonderful. Thanks all for work making it possible.

Here's an example showing how to query the db using R:
https://inductivestep.github.io/WSPR-analysis/

73s,

Andi M0INF


Gwyn Griffiths
 

Hello Andi
I'm glad you have found this group and the WsprDaemon database. 

Thank you for sharing your R example, on how to access, and on how to generate plots.
I will include a link to your web page in our documentation. 

It would be nice to have your views on what visualisations one could program in R that would be useful but are not possible using our Grafana site.

73
Gwyn G3ZIL 


Andi Fugard M0INF
 

Hi Gwyn,

I haven't used Grafana, so I'm not sure.

R has a huge number of packages for pretty much every visualisation and statistical analysis in existence, so there's likely to be something. It's also fairly easy to get from a local analysis to a web app, e.g., here is a simple visualisation grabbing the last hour's worth of sent/receives to/from IO91: https://andif.shinyapps.io/wspr_app/

(It also happens to be software I can use!)

Anyway, shall have a think :)

73,

Andi M0INF


Andi Fugard M0INF
 

Hello again,

I have added more examples:
https://inductivestep.github.io/WSPR-analysis/

Best wishes,

Andi


Gwyn Griffiths
 

Excellent, many thanks Andy,

I will write a section for the TimescaleDB Guide this week.
When working, I had R on a Mac for many years but did not touch it. I found JMP was enough for my needs.
But as part of this write-up I'll reinstall R and run your examples for myself.

73
Gwyn G3ZIL