Link to home
Start Free TrialLog in
Avatar of trcamp
trcampFlag for United States of America

asked on

need to remove selected rows from a dataset

Hi,

I need to do the following:

My dataset contains water levels from a well, measured hourly.  I need to average the hourly water levels for the 24 hour period and keep only the daily average value in the new dataset.   Two notes:   1.  If data are missing they should be treated as "null" values.  2.  Each date (day) should have a row, even if the water level value for that date is null.

Original:    date             time        water level 1S        water level 1D       etc  .....
                1/1/2007       1:00             5.2                          10.2                  6.4
                1/1/2007       2:00             5.3                          10.3                  6.5
                  etc
               1/1/2007       23:00           5.6                           10.5                6.7
               1/2/2007       0:00              5.8                          10.6                6.9
               1/2/2007        1:00              5.7                         10.5                6.6
                 etc

New:         date             water level 1S      water level 1D     etc  ........
               1/1/2007              5.4                    10.5                 6.7
                1/2/2007             5.5                     10.6                6.8
                 etc
                 

Thanks!

TC
expert-exchange----111412----WLS.xls
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of trcamp

ASKER

Excellent - thanks Faustulus!   It works great.