create/insert information for missing data points
- To: mathgroup at smc.vnet.net
- Subject: [mg119880] create/insert information for missing data points
- From: lillydogy <lillydogy at yahoo.com>
- Date: Mon, 27 Jun 2011 07:32:55 -0400 (EDT)
how do I create and insert information for missing data? have an experiment running in military time, and sometimes it has missing data points, sometimes three missing data points in a row or more. I want to take the average of the two adjacent (joining) data points and insert for the missing point/s. for example, these would be the missing points inserted for the example below. {305,38.5},{311,40.5},{312,40.5},{313,40.5}. before :( listmissing={{301,44},{302,46},{303,40},{304,30},{306,47},{307,37},{308,42},{309,40},{310,43},{314,38}} after :) listfull={{301,44},{302,46},{303,40},{304,30},{305,38.5},{306,47},{307,37},{308,42},{309,40},{310,43},{311,40.5},{312,40.5},{313,40.5}{314,38}} btw, these are millitary times, so it goes 959,1000....1059,1100... etc because there are only 60 minutes in an hour. there would be no such thing as 1392, because 1:92pm does not exist. this is another example of how the data looks {{957,6},{958,4},{959,5},{1000,5},{1001,4},{1002,2},{1003,3}}