I posted a similar question, but feel it needs a bit more elaboration.

I have a data frame (read from a csv file) that may have missing rows.  Each
day has 7 time intervals associated with it, with a range from 17:00 hrs to
18:00 hrs in 10 minute bins.

What I am looking for is a script that will run through the data frame and
insert "NA"in the Volume column for any dates that are missing a time
interval.  For example:

          Date            Time             Camera
 Volume
57  2009-10-09 5:00:00 PM MANBRIN_RIVER_NB    210
58  2009-10-09 5:10:00 PM MANBRIN_RIVER_NB    207
59  2009-10-09 5:20:00 PM MANBRIN_RIVER_NB    250
60  2009-10-09 5:30:00 PM MANBRIN_RIVER_NB    193
61  2009-10-09 5:40:00 PM MANBRIN_RIVER_NB    205
62  2009-10-09 6:00:00 PM MANBRIN_RIVER_NB    185

Note that between row 61 and row 62, there is a missing time interval (5:50
PM).  I want the data frame to look like this:

     Date                 Time           Camera
 Volume
57  2009-10-09 5:00:00 PM MANBRIN_RIVER_NB    210
58  2009-10-09 5:10:00 PM MANBRIN_RIVER_NB    207
59  2009-10-09 5:20:00 PM MANBRIN_RIVER_NB    250
60  2009-10-09 5:30:00 PM MANBRIN_RIVER_NB    193
61  2009-10-09 5:40:00 PM MANBRIN_RIVER_NB    205
*62  2009-10-09 5:50:00 PM MANBRIN_RIVER_NB  NA*
62  2009-10-09 6:00:00 PM MANBRIN_RIVER_NB    185


Thanks in advance,
Kindra

	[[alternative HTML version deleted]]

