[R] Missing data
Rainer Schuermann
rainer.schuermann at gmx.net
Thu Apr 25 12:44:35 CEST 2013
I read your data into a dataframe
> x <- read.table( "clipboard" )
and renamed the only column
> colnames( x )[1] <- "orig"
With a loop, I created a 2nd column "miss" where in every 10th row the observation is set to NA:
for( i in 1 : length( x$orig ) )
{
if( as.integer( rownames( x )[ i ] ) %% 10 == 0 )
{
x$miss[i] <- NA
} else {
x$miss[i] <- x$orig[i]
}
}
This is probably the least elegant of all possible solutions but it works...
Rgds,
Rainer
On Wednesday 24 April 2013 23:41:21 Roslina Zakaria wrote:
> Dear r-users,
>
> I would like to investigate about how to fill in missing data. I started with a complete data and try to introduce missing data into the data series. Then I would use some method to fill in the missing data and then compare with the original data how good it is. My question is, how do I introduce missing data in my complete data systematically like for example every 10th data will be erased and assumed as missing. Here are some rainfall data:
>
> 125
> 130.3
> 327.2
> 252.2
> 33.8
> 6.1
> 5.1
> 0.5
> 0.5
> 0
> 2.3
> 0
> 0
> 0
> 0
> 0
> 0
> 0
> 0
> 0
> 0.8
> 5.1
> 0
> 0.3
> 0
> 0
> 0
> 0
> 0
> 0
> 45.7
> 43.4
> 0
> 0
> 0
> 0
> 0
>
> Thank you so much for any help given. I hope my question is clear.
> [[alternative HTML version deleted]]
>
More information about the R-help
mailing list