Thanks a lot. Its really helpful
Regards
Saba
On Saturday, 23 April 2016, 6:50, Giorgio Garziano
wrote:
Since the aggregate S3 method for class formula already has got na.action =
na.omit,
## S3 method for class 'formula'
aggregate(formula, data, FUN, ...,
subset, na.action = na.o
Since the aggregate S3 method for class formula already has got na.action =
na.omit,
## S3 method for class 'formula'
aggregate(formula, data, FUN, ...,
subset, na.action = na.omit)
I think that to deal with NA's, it is enough:
aggregate(Value~ID, dta, max)
Moreover, passing na.r
y
College Station, TX 77840-4352
-Original Message-
From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Tom Wright
Sent: Friday, April 22, 2016 9:13 AM
To: Saba Sehrish
Cc: R-help Mailing List
Subject: Re: [R] Finding Highest value in groups
Assuming your dataframe is in a variable
idvalues <- data.frame (ID = c(1, 1, 2, 2, 3, 4, 4, 4, 5, 5),
Value = c(0.69, 0.31, 0.01, 0.99, 1.00, NA, 0,1, 0.5,
0.5))
aggregate(Value~ID, data=idvalues, max)
ID Value
1 1 0.69
2 2 0.99
3 3 1.00
4 4 1.00
5 5 0.50
--
Best,
GG
[[alternative HTML
Assuming your dataframe is in a variable x:
> require(dplyr)
> x %>% group_by(ID) %>% summarise(maxVal = max(Value,na.rm=TRUE))
On Fri, 2016-04-22 at 13:51 +, Saba Sehrish via R-help wrote:
> Hi
>
>
> I have two columns in data frame. First column is based on "ID" assigned to
> each grou
Hi
I have two columns in data frame. First column is based on "ID" assigned to
each group of my data (similar ID depicts one group). From second column, I
want to identify highest value among each group and want to assign the same ID
to that highest value.
Right now the data looks like:
ID
6 matches
Mail list logo