s-news
[Top] [All Lists]

group by

To: s-news@wubios.wustl.edu
Subject: group by
From: "Neung-Hwan Oh" <ultisol@gmail.com>
Date: Wed, 14 Mar 2007 16:48:56 -0400
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=jgBTSUEUaJA5CnCQPly5PAI1RB5DlEbnJOa8kKmndgGrWgyHuiBgI/EeeEcC5zlZ4+U2B9ToKYKR64yDcbDBzF1Il2Ub3gEOOu6WEkUoF0GUI1QhOZpO8prwj3jqSCVqrm/5BjbslUEDc0vhB0xvColK3k4QrwUIpwAp1y6ttbg=
Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=iIPwLxB6xa4ZEe4XceXkwltKGvwfWWoCYVLnesWLpu1Iw3XtnpjUmSLjt39JAXNAl0lxOZMI9wYN+Ck6YshpoOpsk2gBvKT9HeZ0jCFcFMeTlVdm/wyukdqmd2/j2VfSI91yU2ewX8o7sCqXJzi4bAj+OQbuGVHXZygWrbF4ITI=
Hello,
 
How can you calculate the following example in s-plus?   In Access, it is relatively easy with "Group By" and I am wondering whether there is a similar function that I missed in S-Plus.
 

"From this table"

site.no date time value

1 1989/04/27 12:00   1.0

2 1975/10/01 19:00   2.0

2 1975/10/01 20:00   4.0

3 1993/04/10 09:00   3.0

3 1993/04/10 12:00   6.0

3 1993/04/10 15:00   9.0

 

"To this (averages per date per site)" + (count column?)

1 1989/04/27 12:00 1.0  (1.0)

2 1975/10/01 19:30 3.0  (2.0)

3 1993/04/10 12:00 6.0  (3.0)

 

Many thanks!

NH

<Prev in Thread] Current Thread [Next in Thread>