Skip to content
Back to formatted view

Raw Message

Message-ID: <47DA9184.7030405@biostat.wisc.edu>
Date: 2008-03-14T14:53:56Z
From: Erik Iverson
Subject: test individual values in rows
In-Reply-To: <47DA90DF.40105@biostat.wisc.edu>

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.