Groups > comp.soft-sys.math.mathematica > #3357

create/insert information for missing data points

From	lillydogy <lillydogy@yahoo.com>
Newsgroups	comp.soft-sys.math.mathematica
Subject	create/insert information for missing data points
Date	2011-06-29 21:31 +0000
Organization	Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID	<iug5j4$9f9$1@smc.vnet.net> (permalink)

Show all headers | View raw

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}}

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread

Thread

create/insert information for missing data points lillydogy <lillydogy@yahoo.com> - 2011-06-29 21:31 +0000

csiph-web