Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Re: Data averages by time of day

by blue_cowdawg (Monsignor)
on Feb 26, 2004 at 17:19 UTC ( [id://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?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (8)
As of 2024-04-19 09:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found