Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

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


  • Prev by Date: Re: what's in a name? (legal and conventional constructions of identifiers)
  • Next by Date: Stylesheet questions
  • Previous by thread: Re: NSolve...
  • Next by thread: Re: create/insert information for missing data points