Skip to content
Back to formatted view

Raw Message

Message-ID: <p05200f00bae8001643f9@[128.40.218.142]>
Date: 2003-05-14T14:25:57Z
From: Frank
Subject: building mean/median over subgroups

Dear all,

I'm trying to solve the following problem, and hoping to get some 
advise here from the group

I have a dataframe in which the same sample was measured more than 
once on the same day. I would reorganize the dataframe to get a 
single value (mean /median) for one day

Patient	Day	Sample	Test
A	1	A	23
A	1	A	36
A	5	B	44
A	5	B	23
B	2	C	10
B	2	C	5


mean

Patient	Day	Sample	Test.mean
A	1	A	29.5
A	5	A	33.5
B	2	C	7.5


it would be great to get some help form the list.

Yours
Frank
-- 
Frank Mattes, MD			e-mail:	f.mattes at ucl.ac.uk