Hello,
Try the following.
dat <- read.table(text = "
Name C1 C2 C3
1 A 3 3 5
2 B 2 7 4
3 C 4 3 3
4 C 4 4 6
5 D 5 5 3
", header = TRUE)
str(dat)
aggregate(dat[, -1], list(dat$Name), mean)
Hope this helps,
Rui Barradas
Em 27-05-2014 21:06, Verena Weinbir escreveu:
Hello,
I have a big dataframe, and want to average two specific cells of two
specific rows and then replace those two rows with one row which contains
the averaged cells. Example (row 3 and 4: Cells2 and Cells3 averaged and
replaced)
NameC1 C2 C3
1 A 3 3 5
2 B 2 7 4
3 C 4 3 3
4 C 4 4 6
5 D 5 5 3
NameC1 C2 C3
1 A 3 3 5
2 B 2 7 4
3 C 4 3.5 4.5 4 D 5 5 3
Many thanks in advance!
Best,
Verena
[[alternative HTML version deleted]]
______________________________________________
R-help@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@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.
