Dear all,
I have a dataset
Exp name id x1 x2 x3 x4 x5
1 a 1 23 24 23 22 30
1 b 2 25 26 27 23 24
1 c 3 32 19 23 25 28
2 a 4 28 32 24 26 27
2 b 5 23 24 25 26 28
2 c 6 23 31 30 38 23
3 a 7 24 25 31 27 29
3 b 8 28 25 26 32 28
3 c 9 21 31 28 23 29
where each name a,b and c is repeated three times.
Now I want to calculate the the averages of a,b and c
over the three experiments for each x. For example for
x1 I want to calculate the average of a like
[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3
How can I do that ?
Thanks for your help,
Regards,
Antonia
R-help (AT) stat (DOT) math.ethz.ch mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

try something like the following:

sapply(split(dat[paste("x", 1:5, sep = "")], dat$name), mean)

Best,
Dimitris

Dimitris Rizopoulos
Ph.D. Student
Biostatistical Centre
School of Public Health
Catholic University of Leuven

Address: Kapucijnenvoer 35, Leuven, Belgium
Tel: +32/(0)16/336899
Fax: +32/(0)16/337015
Web:
~m0390867/dimitris.htm

Message
From: <antoniababe (AT) yahoo (DOT) se>
To: <r-help (AT) stat (DOT) math.ethz.ch>
Sent: Wednesday, 18, 2006 11:10 AM
Subject: [R] new R-user needs help

Dear all,

I have a dataset

Exp name id x1 x2 x3 x4 x5
1 a 1 23 24 23 22 30
1 b 2 25 26 27 23 24
1 c 3 32 19 23 25 28
2 a 4 28 32 24 26 27
2 b 5 23 24 25 26 28
2 c 6 23 31 30 38 23
3 a 7 24 25 31 27 29
3 b 8 28 25 26 32 28
3 c 9 21 31 28 23 29

where each name a,b and c is repeated three times.
Now I want to calculate the the averages of a,b and c
over the three experiments for each x. For example for
x1 I want to calculate the average of a like

[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3

How can I do that ?

Thanks for your help,
Regards,

Antonia

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide

and provide commented, minimal, self-contained, reproducible code.

Disclaimer:

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

try this,
if your data frame name is "tab"
mean.tab = data.frame (meanA = mean(tab[tab$name == 'a' ,4:8]), meanB
= mean(tab[tab$name == 'b',4:8]), meanC = mean(tab[tab$name ==
'c',4:8]))
mean.tab
good luck
Romain

Romain L

UMR 8079 Laboratoire Ecologie, S et Evolution

B 362

U Paris-Sud

91405 cedex

France

tel : 01 69 15 56 85

fax : 01 69 15 56 96

mobile : 06 81 70 90 70

email : romain.lorrilliere (AT) ese (DOT) u-psud.fr

[1]antoniababe (AT) yahoo (DOT) se a :

Dear all,

I have a dataset

Exp name id x1 x2 x3 x4 x5
1 a 1 23 24 23 22 30
1 b 2 25 26 27 23 24
1 c 3 32 19 23 25 28
2 a 4 28 32 24 26 27
2 b 5 23 24 25 26 28
2 c 6 23 31 30 38 23
3 a 7 24 25 31 27 29
3 b 8 28 25 26 32 28
3 c 9 21 31 28 23 29

where each name a,b and c is repeated three times.
Now I want to calculate the the averages of a,b and c
over the three experiments for each x. For example for
x1 I want to calculate the average of a like

[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3

How can I do that ?

Thanks for your help,
Regards,

Antonia

[2]R-help (AT) stat (DOT) math.ethz.ch mailing list
[3]
PLEASE do read the posting guide [4]
and provide commented, minimal, self-contained, reproducible code.

References

1. mailto:antoniababe (AT) yahoo (DOT) se
2. mailto:R-help (AT) stat (DOT) math.ethz.ch
3.
4.

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

Hi,

you can use aggregate.

aggregate(data[,c(3:8)],list(data$name),mean)

should give you what you want.

Ciao,
Stefano

Wed, 18, 2006 at 11:10:04AM +0200, antoniababe (AT) yahoo (DOT) se wrote:
<antoniababe>Dear all,
<antoniababe>
<antoniababe>I have a dataset
<antoniababe>
<antoniababe>Exp name id x1 x2 x3 x4 x5
<antoniababe>1 a 1 23 24 23 22 30
<antoniababe>1 b 2 25 26 27 23 24
<antoniababe>1 c 3 32 19 23 25 28
<antoniababe>2 a 4 28 32 24 26 27
<antoniababe>2 b 5 23 24 25 26 28
<antoniababe>2 c 6 23 31 30 38 23
<antoniababe>3 a 7 24 25 31 27 29
<antoniababe>3 b 8 28 25 26 32 28
<antoniababe>3 c 9 21 31 28 23 29
<antoniababe>
<antoniababe>where each name a,b and c is repeated three times.
<antoniababe>Now I want to calculate the the averages of a,b and c
<antoniababe>over the three experiments for each x. For example for
<antoniababe>x1 I want to calculate the average of a like
<antoniababe>
<antoniababe>[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3
<antoniababe>
<antoniababe>How can I do that ?
<antoniababe>
<antoniababe>Thanks for your help,
<antoniababe>Regards,
<antoniababe>
<antoniababe>Antonia
<antoniababe>
<antoniababe>
<antoniababe>R-help (AT) stat (DOT) math.ethz.ch mailing list
<antoniababe>
<antoniababe>PLEASE do read the posting guide
<antoniababe>and provide commented, minimal, self-contained, reproducible code.

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

antoniababe (AT) yahoo (DOT) se wrote:
Dear all,

I have a dataset

Exp name id x1 x2 x3 x4 x5
1 a 1 23 24 23 22 30
1 b 2 25 26 27 23 24
1 c 3 32 19 23 25 28
2 a 4 28 32 24 26 27
2 b 5 23 24 25 26 28
2 c 6 23 31 30 38 23
3 a 7 24 25 31 27 29
3 b 8 28 25 26 32 28
3 c 9 21 31 28 23 29

where each name a,b and c is repeated three times.
Now I want to calculate the the averages of a,b and c
over the three experiments for each x. For example for
x1 I want to calculate the average of a like

[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3

How can I do that ?

library(prettyR)
antonia.df<-read.csv("/antonia.dat")
brkdn(x1~name,antonia.df)

Jim

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

Hi,

use aggregate

aggregate(dataset[,-c(1:3)],list(dataset$name),mean)

should give you what you need

Ciao,
Sfetano

Wed, 18, 2006 at 11:10:04AM +0200, antoniababe (AT) yahoo (DOT) se wrote:
<antoniababe>Dear all,
<antoniababe>
<antoniababe>I have a dataset
<antoniababe>
<antoniababe>Exp name id x1 x2 x3 x4 x5
<antoniababe>1 a 1 23 24 23 22 30
<antoniababe>1 b 2 25 26 27 23 24
<antoniababe>1 c 3 32 19 23 25 28
<antoniababe>2 a 4 28 32 24 26 27
<antoniababe>2 b 5 23 24 25 26 28
<antoniababe>2 c 6 23 31 30 38 23
<antoniababe>3 a 7 24 25 31 27 29
<antoniababe>3 b 8 28 25 26 32 28
<antoniababe>3 c 9 21 31 28 23 29
<antoniababe>
<antoniababe>where each name a,b and c is repeated three times.
<antoniababe>Now I want to calculate the the averages of a,b and c
<antoniababe>over the three experiments for each x. For example for
<antoniababe>x1 I want to calculate the average of a like
<antoniababe>
<antoniababe>[a(from exp1) + a(exp2)+ a(exp3)]/3= (23+28+24)/3
<antoniababe>
<antoniababe>How can I do that ?
<antoniababe>
<antoniababe>Thanks for your help,
<antoniababe>Regards,
<antoniababe>
<antoniababe>Antonia
<antoniababe>
<antoniababe>
<antoniababe>R-help (AT) stat (DOT) math.ethz.ch mailing list
<antoniababe>
<antoniababe>PLEASE do read the posting guide
<antoniababe>and provide commented, minimal, self-contained, reproducible code.

R-help (AT) stat (DOT) math.ethz.ch mailing list

PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.