Time Series Data
I have a large amount of time series data taken in 30 second increments over the course of 4-5 days. This gives 10,000 individual items needed to store in 12+ columns. I do not want to analyze the d...
Forum Discussion
Ah so, now we should talk!!!! We are an electrical consulting firm. If QB can do what we want, then we would be golden.
As Matthew Neil knows, I am not a programmer, hence the work with QB. Python is done by a coworker who is a wizard at Python.
I will look at D3 tonight, and look through your IEEE article also. (I am IEEE PES myself). We are doing event analysis on the time series data, graphing load to power factor, etc. to analyze what is happening electrically. Our client started by storing and analyzing these data points in Excel and it is not pretty. I am trying to see if QB will do this.
Will D3js import the data from QB, analyze and plot as we want, and then export the results back to QB? If so, Would you be willing to talk some off-line so I can pick your brain on methodology for using within QB?
Thanks for the help you have given so far on this question and the others you have answered!
Cheers.
As Matthew Neil knows, I am not a programmer, hence the work with QB. Python is done by a coworker who is a wizard at Python.
I will look at D3 tonight, and look through your IEEE article also. (I am IEEE PES myself). We are doing event analysis on the time series data, graphing load to power factor, etc. to analyze what is happening electrically. Our client started by storing and analyzing these data points in Excel and it is not pretty. I am trying to see if QB will do this.
Will D3js import the data from QB, analyze and plot as we want, and then export the results back to QB? If so, Would you be willing to talk some off-line so I can pick your brain on methodology for using within QB?
Thanks for the help you have given so far on this question and the others you have answered!
Cheers.
- D3 can be used within QuickBae as your charting package drawing data out of CSV file attachments as needed. D3 has an excellent CSV parser which can part CSV to an array of objects and back to CSV for storage back to a file attachment.
Best time to speak would be Friday as I am travelling this week.
