Hi, I have a data frame Y with the following information, ORF spectra 1 YAL001C 2 2 YAL005C 21 3 YAL007C 2 4 YAL012W 8 5 YAL016W 24 6 YAL019W 3 7 YAL020C 2 8 YAL021C 7 9 YAL022C 3 10 YAL023C 6 11 YAL026C 2 12 YAL029C 1 13 YAL031C 1 14 YAL035W 48 15 YAL038W 173 16 YAL041W 4 17 YAL042W 4 18 YAL048C 1 19 YAL049C 1 20 YAL051W 1 In the other hand I have this object X with character elements as following "YAL026C" "YAL041W" "YAL048C" "YAL007C" "YAL012W" "YAL016W" and I want to generate a new data frame exclusively with the elements from the object X and its respective spectra value from the data frame Y. how to do it? I have tried to look into several functions, match, subset, command Y[ X, ], and I still can not get it thanks in advance Roberto [[alternative HTML version deleted]]
Hi, I have a data frame Y with the following information, ORF spectra 1 YAL001C 2 2 YAL005C 21 3 YAL007C 2 4 YAL012W 8 5 YAL016W 24 6 YAL019W 3 7 YAL020C 2 8 YAL021C 7 9 YAL022C 3 10 YAL023C 6 11 YAL026C 2 12 YAL029C 1 13 YAL031C 1 14 YAL035W 48 15 YAL038W 173 16 YAL041W 4 17 YAL042W 4 18 YAL048C 1 19 YAL049C 1 20 YAL051W 1 In the other hand I have this object X with character elements as following "YAL026C" "YAL041W" "YAL048C" "YAL007C" "YAL012W" "YAL016W" and I want to generate a new data frame exclusively with the elements from the object X and its respective spectra value from the data frame Y. how to do it? I have tried to look into several functions, match, subset, command Y[ X, ], and I still can not get it thanks in advance Roberto [[alternative HTML version deleted]]
Hi Roberto,
One of these ?
> Y[ Y$ORF %in% X , ]
ORF spectra
3 YAL007C 2
4 YAL012W 8
5 YAL016W 24
11 YAL026C 2
16 YAL041W 4
18 YAL048C 1
> subset( Y, ORF %in% X )
ORF spectra
3 YAL007C 2
4 YAL012W 8
5 YAL016W 24
11 YAL026C 2
16 YAL041W 4
18 YAL048C 1
Cheers,
Romain
--
Mango Solutions
data analysis that delivers
Introduction to R training course :: London :: 06-07 March 2008
http://www.mango-solutions.com/services/rtraining/r_intro.html
Roberto Olivares Hernandez wrote:> Hi,
> I have a data frame Y with the following information,
>
> ORF spectra
> 1 YAL001C 2
> 2 YAL005C 21
> 3 YAL007C 2
> 4 YAL012W 8
> 5 YAL016W 24
> 6 YAL019W 3
> 7 YAL020C 2
> 8 YAL021C 7
> 9 YAL022C 3
> 10 YAL023C 6
> 11 YAL026C 2
> 12 YAL029C 1
> 13 YAL031C 1
> 14 YAL035W 48
> 15 YAL038W 173
> 16 YAL041W 4
> 17 YAL042W 4
> 18 YAL048C 1
> 19 YAL049C 1
> 20 YAL051W 1
>
>
> In the other hand I have this object X with character elements as following
>
> "YAL026C"
> "YAL041W"
> "YAL048C"
> "YAL007C"
> "YAL012W"
> "YAL016W"
>
> and I want to generate a new data frame exclusively with the elements from
the object X and its respective spectra value from the data frame Y. how to do
it?
>
> I have tried to look into several functions, match, subset, command Y[ X,
], and I still can not get it
>
>
> thanks in advance
>
> Roberto
>
?merge
Let the data.frame be xx
yy <-
data.frame(ORFc("YAL026C","YAL041W","YAL048C","YAL007C","YAL012W",
"YAL016W" ))
merge(xx,yy, by="ORF")
should do it.
--- Roberto Olivares Hernandez <roh at bio.dtu.dk> wrote:
> Hi,
> I have a data frame Y with the following
> information,
>
> ORF spectra
> 1 YAL001C 2
> 2 YAL005C 21
> 3 YAL007C 2
> 4 YAL012W 8
> 5 YAL016W 24
> 6 YAL019W 3
> 7 YAL020C 2
> 8 YAL021C 7
> 9 YAL022C 3
> 10 YAL023C 6
> 11 YAL026C 2
> 12 YAL029C 1
> 13 YAL031C 1
> 14 YAL035W 48
> 15 YAL038W 173
> 16 YAL041W 4
> 17 YAL042W 4
> 18 YAL048C 1
> 19 YAL049C 1
> 20 YAL051W 1
>
>
> In the other hand I have this object X with
> character elements as following
>
> "YAL026C"
> "YAL041W"
> "YAL048C"
> "YAL007C"
> "YAL012W"
> "YAL016W"
>
> and I want to generate a new data frame exclusively
> with the elements from the object X and its
> respective spectra value from the data frame Y. how
> to do it?
>
> I have tried to look into several functions, match,
> subset, command Y[ X, ], and I still can not get it
>
>
> thanks in advance
>
> Roberto
>
>
>
>
>
>
>
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.
>