Skip to content
Prev 312683 / 398506 Next

missed values

It's simpler, easier, and more correct to use zoo::na.approx.

R> library(zoo)
R> dat1<-read.table(text=
+ "   date     value
+ 80  2006-10 0.1577647
+ 81  2006-11       NaN
+ 82  2006-12       NaN
+ 83  2007-01       NaN
+ 84  2007-02       NaN
+ 85  2007-03 0.2956429",
+ header=TRUE,stringsAsFactors=FALSE)
R> dat1$valnew <- na.approx(dat1$value, as.yearmon(dat1$date))
R> dat1
      date     value    valnew
80 2006-10 0.1577647 0.1577647
81 2006-11       NaN 0.1853403
82 2006-12       NaN 0.2129160
83 2007-01       NaN 0.2404916
84 2007-02       NaN 0.2680673
85 2007-03 0.2956429 0.2956429

Best,
--
Joshua Ulrich  |  about.me/joshuaulrich
FOSS Trading  |  www.fosstrading.com
On Fri, Nov 30, 2012 at 11:28 AM, arun <smartpink111 at yahoo.com> wrote:
<snip>
<snip>
Message-ID: <CAPPM_gTjuxT00_HYR-J_o7dhQw4yQ7jeJv5dV1nTxF9HgtytkA@mail.gmail.com>
In-Reply-To: <1354296523.57959.YahooMailNeo@web142602.mail.bf1.yahoo.com>