[R] How to filter data in R based on first column ID

Rui Barradas ru|pb@rr@d@@ @end|ng |rom @@po@pt
Fri Jun 21 22:29:56 CEST 2019


Hello,

Please don't post in HTML like the posting guide asks you to, the data 
is unreadable.

Not tested:

i <- data[[1]] %in% ID.list
data[i, ]


That's it.

Hope this helps,

Rui Barradas

Às 21:09 de 21/06/19, Yogesh Gupta escreveu:
> Hi,
> 
> I do need to filter data based on first column could you please suggest ,
> How I can do it in R.
> 
> 
> 
> 
> 
> 
> 
> head(data)
> 
> 
> 
> Root-1.S35.L001 Root-10.S75.L001 Root-13.S5.L001 Root-14.S16.L001
> Root-17.S26.L001
> 719e20e1e3d19fbc5dd50844c6d29a8f 0.049304262 0 0 0 0.033765858
> bfffa74c0971b30ccf3b19f65911801f 0 0 0.017210717 0 0
> 80087a003188288a9b0e3990d72113e3 0 0 0 0.010248632 0
> aed34f36d535976c247278bec289fd12 0.580694642 0.113445793 0.56221674
> 0.06764097 0.525782644
> 42df8f30203380e9a604cb5c4000411b 0 0 0 0.004099453 0
> d47199c9d9c5417c7cb82ff4159cf497 0 0.019729703 0 0 0
> 6272cdc38bd517a77ba3887619c36b9f 0 0 0 0.016397811 0.019294776
> 62a5c6f5e0adda662739a7ac521ea790 0.076695519 0 0.271546861 0.254166069
> 0.463074623
> 3b5d8860f6a03668df80d364e9591bab 0.125999781 0.019729703 0.061193659
> 0.038944801 0.02411847
> 
> I need to extract data for the below IDs
> 
> head(ID.list)
> 
> 719e20e1e3d19fbc5dd50844c6d29a8f
> bfffa74c0971b30ccf3b19f65911801f
> 62a5c6f5e0adda662739a7ac521ea790
> 
> I will be tankful for your help.
> 
> Thanks
> Yogesh
> 
> *Yogesh Gupta*
> *Research Fellow*
> *Institute for Global Food Security*
> *Queen's University*
> *Belfast, UK*
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>



More information about the R-help mailing list