11

Looking for a way of visualizing public power generation data. Typical data set has 1–5 years of hourly data, and anything up to 30 columns. Needing to pan and zoom, and perhaps select sections. Needs to run on Linux.

The sometimes recommended TimeSearcher 2 is very shaky under Mono, and has unusual data format requirements.

EDIT: I'm looking to compare years of hourly generation data against regional demand. Some of the data streams may not have corresponding frequencies. I'm not looking for much programming input, as most of the analysis will be visual, so zooming and panning are important. There's unlikely to be a pre-made importer for the XML format used by the particular ISO, so I'd likely be spending the programming time on that. Not sure if I need any stats capabilities, though rolling daily/weekly averages/minima/maxima could be helpful.

I'm potentially going up against a very polished but misguided speaker in a few days who is using an entrenched industry position to ensure that expensive, polluting energy remains the status quo.

3
  • If you could add more information, that would help narrow down the answers. For example: Are you only looking for desktop applications, or are web-based solutions fine? How much programming should be involved? Is your focus exploration or presentation? Apr 24, 2015 at 9:47
  • @scruss, what did you end up using? Jun 6, 2015 at 6:38
  • None, yet. Disappeared down a bit of an R rabbit hole. It looks like it could handle and graph the data (after a lot of cleanup) but it's a steep learning curve if you've never used it before.
    – scruss
    Jun 7, 2015 at 23:13

1 Answer 1

5

It's hard to suggest a good tool without knowing how deep into programming you want to go, or if the tool is for exploration or presentation.

But here is a sample of many good tools out there:

Javascript:

R:

Python:

Tableau

2
  • Thanks - dygraphs looks great. I was kind of looking for a pre-rolled tool, as I've already had to do a lot of fighting with the data just to get it in a place to analyse. It's Generation Output and Capability Data from Ontario.
    – scruss
    Apr 23, 2015 at 21:37
  • For exploration and hooking up with data sets, Tableau (Public) is pretty good, but doesn't work on Linux as far as I know.
    – philshem
    Apr 24, 2015 at 7:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.