merging rows and taking average of duplicate rows rstudio

Grieving Gentoo answered on July 23, 2020 Popularity 1/10 Helpfulness 1/10

answer merging rows and taking average of duplicate rows rstudio

merging rows and taking average of duplicate rows rstudio

Comment

library(data.table)
dat <- read.table(text='name    value   etc1    etc2
A       9       1       X
A       10      1       X
A       11      1       X
B       2       1       Y
C       40      1       Y
C       50      1       Y',header=TRUE)
keys <- colnames(dat)[!grepl('value',colnames(dat))]
X <- as.data.table(dat)
X[,list(mm= mean(value)),keys]
  name etc1 etc2 mm
1:    A    1    X 10
2:    B    1    Y  2
3:    C    1    Y 45

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: average rows rstudio whatever

Link to this answer
Share Copy Link

Contributed on Jul 23 2020

Grieving Gentoo

0 Answers Avg Quality 2/10

merging rows and taking average of duplicate rows rstudio

Contents

More Related Answers

merging rows and taking average of duplicate rows rstudio

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.