[R] test individual values in rows

Erik Iverson iverson at biostat.wisc.edu
Fri Mar 14 15:53:56 CET 2008


Of course, it might be clearer if instead of

!all(x < 100) I had put, any(x > 100)



Erik Iverson wrote:
> If your data.frame is completely numeric, this is easy.
> 
> If your data.frame is called df, then do
> 
> df[apply(df, 1, function(x) !all(x < 100)),]
> 
> Look at ?apply
> 
> Best,
> Erik Iverson
> 
> IAIN GALLAGHER wrote:
>> Hi list.
>>
>> I have a numerical dataset 22,000 rows deep and 43 columns wide. I would like to remove those rows which contain only values less than 100 (ie if any value in the row is greater than 100 the row stays in the dataset). I am unsure how to test each individual value across the rows and then identify the rows which meet my criteria. 
>>
>> Can anyone help?
>>
>> Thank you.
>>
>> Iain
>>
>> 	[[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.
> 
> ______________________________________________
> 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.



More information about the R-help mailing list