Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Re: Data averages by time of day

by blue_cowdawg (Monsignor)
on Feb 26, 2004 at 17:19 UTC ( #332049=note: print w/replies, xml ) Need Help??


in reply to Re: Data averages by time of day
in thread Data averages by time of day

      Something like this?

Something along those lines was one of the ideas I was playing around with but with finer blocks of time.

select hg from readings where time > "04:00" and time < "4:30"; . . . and so on
and then averaging the time slots. Where I have no values in a given time slot I could to linear interpolation. Abigail makes a very valid point that I am trying to wrap my head around to figure out how to implement it is the theory (fact?) that there may be a sinusoidal relationship to consider as well.

I beginning to think that I have a good basis for a posting to CUFP when I get this working.


Peter L. Berghold -- Unix Professional
Peter at Berghold dot Net
   Dog trainer, dog agility exhibitor, brewer of fine Belgian style ales. Happiness is a warm, tired, contented dog curled up at your side and a good Belgian ale in your chalice.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://332049]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (5)
As of 2022-11-30 11:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?