Re: [R] df manipulation

2007-07-19 Thread Uwe Ligges 


Nikola Markov wrote:
> I have multicolumn data.frames with the first comumn giving ordinal 
> observation index ( ex.: 1 4 7 9 11 13 etc). I would like to fill up the 
> missing observations (i.e. 2 3 5 6 8 etc) with "NA"s.

Please specify reproducible examples, they make it much easier to help!


If you have:

df <- data.frame(index = c(1, 4, 7), x1 = 1:3, x2 = 3:1)
df

Then you can say:

temp <- data.frame(index = 1:max(df$index))
df <- merge(temp, df, all.x = TRUE)
df

Uwe Ligges





> Thank you
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] df manipulation

2007-07-19 Thread Henrique Dallazuanna 
Hi, see below:

> df
  index value
1 1 1
2 4 6
3 7 4
4 9 5
511 3
613 2

> foo <- function(x){
+ index <- ifelse(x %in% df$index, df$value[which(df$index %in% x)], NA)
+ return(index)
+ }

> df_ok <- data.frame(index=1:13, value=sapply(1:13, foo))
> df_ok
   index value
1  1 1
2  2NA
3  3NA
4  4 6
5  5NA
6  6NA
7  7 4
8  8NA
9  9 5
1010NA
1111 3
1212NA
1313 2

-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O


On 19/07/07, Nikola Markov <[EMAIL PROTECTED]> wrote:
> I have multicolumn data.frames with the first comumn giving ordinal
> observation index ( ex.: 1 4 7 9 11 13 etc). I would like to fill up the
> missing observations (i.e. 2 3 5 6 8 etc) with "NA"s.
> Thank you
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] df manipulation

2007-07-19 Thread Nikola Markov 
I have multicolumn data.frames with the first comumn giving ordinal 
observation index ( ex.: 1 4 7 9 11 13 etc). I would like to fill up the 
missing observations (i.e. 2 3 5 6 8 etc) with "NA"s.
Thank you

__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.