I have some ideas on how to do what I want, but I thought I would pose this question as I know that some of the monks may come up with better ideas than mine.

The problem

I have collected some data (blood glucose levels) over about a 4 week period of time. The correlation I would like to do is an average of those readings by time of day. For instance if you look at a subset of the data that I have collected I have:
 

Blood Glucose by Date

Date
and
Time		 Blood Glucose
Hg/Ml
2004-02-01 07:0182
2004-02-01 11:38172
2004-02-01 22:48154
2004-02-02 05:38107
2004-02-02 13:20117
2004-02-02 23:48188
  
As you can see by the subset of data my sample times do not occur at exactly the same times every day depending on my schedule, when I get up, what dumb meetings interrupt my flow, etc.

What I want to do is average these readings by time of day such that I calculate averages for from 4:30AM (when I get up days I go to the gym) all the way through until midnight. Some interpolation is going to be called for since I do not test every hour and my samples are essentially 3 to 4 a day (more when I feel crappy).

Thoughts anyone?

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.

In reply to Data averages by time of day by blue_cowdawg

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.