[R] read a table ignoring specific rows ?

[Sean O'Riordain]

Can you read in the entire file as a data.frame; and then construct a
new data.frame which excludes some rows?

perhaps something along the lines of...

> fred.file <- data.frame()
> fred.file <- edit(fred.file)
> fred.file
  colA colB colC
1    1    4    2
2    2    3    3
3    3    5    4
4    4    3    3
5    5    2   25
> fred.new <- fred.file[fred.file$colC <= 3,]
> fred.new
  colA colB colC
1    1    4    2
2    2    3    3
4    4    3    3

s/


On 22/08/05, vincent at 7d4.com <vincent at 7d4.com> wrote:
> Dear R users,
> First of all sorry for this question, surely quite naive.
> (I searched on the R site but was unable to find by myself).
> 
> I have a table, called infile :
> 1 2 3
> 4 5 6
> 7 8 9
> 
> I would like to read it and ignore the rows with 1st element > 3
> I do it now with a for loop, and it's ok,
> but I was expecting something simpler, like :
> 
> intable  = read.table(infile);
> newtable = intable[isgoodrow(intable)];
> 
> where :   isgoodrow = function(therow)
> {if (therow$V1 > 3) return(F) else return(T);};
> 
> (... but this don't work).
> 
> So, could somebody please tell me if there is a way to read
> a table ignoring specific rows, without using a for loop ?
> ... and if yes how ?
> 
> Thanks
> Vincent
> 
> ______________________________________________
> 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
>