Data Visualisation
Re: Data Visualisation
Same graph, just with the "histep" mode. More accurately represents the data, but not the actual water levels changing. Decided to use the smooth variant shown before.
Re: Data Visualisation
Philipp, this is good work, I like the way it's developing.
Re: Data Visualisation
ok, finally been able to plot multiple water levels on the same graph. I had to rename the files to suit the command I ran to make this possible. The command also requires all files to be in the same directory.
Re: Data Visualisation
Philipp,
Well done! That is exactly the sort of thing that we've been looking for. Can you publish your code please?
Next Step:
Referring to the Requirments that I posted when you started this:https://wmtprojectsforum.altervista.org ... %20v03.odt, can you now look into some of the other things that we were looking for:
Well done! That is exactly the sort of thing that we've been looking for. Can you publish your code please?
Next Step:
Referring to the Requirments that I posted when you started this:https://wmtprojectsforum.altervista.org ... %20v03.odt, can you now look into some of the other things that we were looking for:
Let us know if you have any queries.Stretch Targets
• Highlight datapoints that lie outside calculated standard deviation values on chart.
• Identify and chart long term trends.
• Devise a means to extract the data from a database.
• Devise a means to write the data into a suitable database.
Terry
Re: Data Visualisation
The code:
First, to set the time format correctly, run these commands:
This makes the program understand the time format given in the database. This will also label the axis as days/months, hours:minutes e.g. 03/8, 12:49.
The next command to run would be
Which plots all files in the directory. These have to be named in a certain way. I renamed the files for one week “data” followed by an integer, which the for loop uses to iterate through each file. The “data” could be anything, but the integer needs to be there for this command to work.
First, to set the time format correctly, run these commands:
Code: Select all
set xdata time
set timefmt "%Y-%m-%d %H:%M:%S"
set datafile separator comma
set format x "%d-%m"
set format x "%d/%m, %H:%M"
The next command to run would be
Code: Select all
plot for [i=0:14] ‘data’.i.’.csv’ using 1:4 smooth bezier title ‘data set’.i
Re: Data Visualisation
Hello,
just wanted to mention that the library used to make quick graphs in python is called "matplotlib".
just wanted to mention that the library used to make quick graphs in python is called "matplotlib".
Re: Data Visualisation
It wouldn't hurt, then we can decide whether to generate the plots on the NAS Box or on demand on the Webserver that provides the Staff and Visitor GUI.
Ian has the NAS Box at the moment and I expect that I'll be able to chat to him tomorrow morning when I go to WMT to install the Milk Shake Factory Train Controller.
Ian has the NAS Box at the moment and I expect that I'll be able to chat to him tomorrow morning when I go to WMT to install the Milk Shake Factory Train Controller.
Terry