[R] Query about extracting subsets from a table

Chuck Cleland ccleland at optonline.net
Tue Jan 23 18:37:15 CET 2007


lalitha viswanath wrote:
> Hi
> I am trying to process tabular data as follows:
> 
> Data in the input file is of the form
> 
> genome1 genome2 tree-dist log10escore
> 
> Genome1 and genome2 are alphabetic.
> Tree-dist and log10escore are numeric.
> 
> I wish to extract only those  rows from this table
> where the log10escore is less than -3.
> 
> 
> data <-read.table(filename);
> data$log10escore = data$log10escore[ data$log10escore
> < -3];

> library(fortunes)
> fortune("dog")

Firstly, don't call your matrix 'matrix'. Would you call your dog 'dog'?
Anyway, it might clash with the function 'matrix'.
   -- Barry Rowlingson
      R-help (October 2004)

> I would like to use this pruned list of escores to get
> the corresponding genomenames and treedist.

?subset

df.sub <- subset(df, log10escore < -3)

summary(df.sub)

> I did not find anything useful in the FAQs and Notes
> on R for this part of the data extraction.
> 
> As I am just beginning programming in R, I would
> appreciate your input about this.
> 
> Thanks
> L
> 
> 
>  
> ____________________________________________________________________________________
> Food fight? Enjoy some healthy debate
> 
> ______________________________________________
> R-help at 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.

-- 
Chuck Cleland, Ph.D.
NDRI, Inc.
71 West 23rd Street, 8th floor
New York, NY 10010
tel: (212) 845-4495 (Tu, Th)
tel: (732) 512-0171 (M, W, F)
fax: (917) 438-0894



More information about the R-help mailing list