Fixing and extracting Datapoints

Hi.. I have a few bad datapoints in my timeseries. Is there any way to remove them? I guess I felt more comfortable with this when things were MYSQL. I really don't understand timestore all that well. 

How could I remove datapoints between two times? And is there a way to correct the data that results from those false inputs? For example when a temp sensor failed it started inserting -127 for a bit. Which of course messed up averages, etc. 

In another case for some strange reason, my KW/d feed suddenly went about 10x too large without showing any real increase in my hourly wattage use.. Anyway way I could remove or recalculate that? I kind of doubt this one since I'm guessing only aggregated data is stored.

Lastly, is their a way to export a time serious for further analysis. For example, could I export all the energy data points for a day to a csv to run through some other statistical models

Thanks for any pointers!

 

 

Marquis27's picture

Re: Fixing and extracting Datapoints

Does no one know how to remove a few data points? Is there no way to fix a data point once it has been saved?

 

aicanduit's picture

Re: Fixing and extracting Datapoints

Impossible to remove... At least, directly in emoncms.org. See this post : http://openenergymonitor.org/emon/node/2931

There are still some "bugs"...

Regards.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.