[R] filter data set unique, duplicate..
Anders Bjørgesæter
anders.bjorgesater at bio.uio.no
Wed Aug 3 10:40:23 CEST 2005
Hello
First, thanks for the help for an earlier question about error handling!
I have problem filtering a dataset.
I'm trying to filter the data in the y columns based on the values in the x
column, e.g.:
x y1 y2 yn
1.0 1 NA 3
2.0 1 NA 11
2.0 2 NA NA
3.0 1 5 16
3.0 7 5 2
4.0 8 4 1
and want to keep the highest y if x is identical, like this:
x y1 y2 yn
1.0 1 NA 3
2.0 2 NA 11
3.0 7 5 16
4.0 8 4 1
or just as good:
x y1 y2 yn
1.0 1 NA 3
2.0 NA* NA NA
2.0 2 NA 11
3.0 NA* 5 16
3.0 7 NA* NA*
4.0 8 4 1
If any has any suggestions or pointers how to do this I would really
appreciate it.
/Anders
More information about the R-help
mailing list