Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-13 Thread Alex Brown
Hi George I'm running ubuntu dapper badger with 2.4.0. add the line deb http://cran.R-project.org/bin/linux/ubuntu dapper/ to your /etc/apt/sources.list -Alex Brown On 13 Dec 2006, at 02:20, George Nachman wrote: Thanks, everyone, for the help! Bill: This looks like a really

[R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread George Nachman
I have a data frame that looks like this: url time somethingirrelevant visits www.foo.com 1:00 xxx 100 www.foo.com 1:00 yyy 50 www.foo.com 2:00 xyz 25 www.bar.com 1:00 xxx 200 www.bar.com 1:00 zzz 200

Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread Simon Blomberg
You could look at the reshape package, using sum as the aggregate function. HTH, Simon. George Nachman wrote: I have a data frame that looks like this: url time somethingirrelevant visits www.foo.com 1:00 xxx 100 www.foo.com 1:00 yyy 50 www.foo.com

Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread Marc Schwartz
On Tue, 2006-12-12 at 15:34 -0800, George Nachman wrote: I have a data frame that looks like this: url time somethingirrelevant visits www.foo.com 1:00 xxx 100 www.foo.com 1:00 yyy 50 www.foo.com 2:00 xyz 25 www.bar.com 1:00 xxx

Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread jim holtman
x url time somethingirrelevant visits 1 www.foo.com 1:00 xxx100 2 www.foo.com 1:00 yyy 50 3 www.foo.com 2:00 xyz 25 4 www.bar.com 1:00 xxx200 5 www.bar.com 1:00 zzz200 6 www.foo.com 2:00

Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread Bill.Venables
Here is an elementary way of doing it: dat url time somethingirrelevant visits 1 www.foo.com 1:00 xxx100 2 www.foo.com 1:00 yyy 50 3 www.foo.com 2:00 xyz 25 4 www.bar.com 1:00 xxx200 5 www.bar.com 1:00

Re: [R] How to sum one column in a data frame keyed on other columns

2006-12-12 Thread George Nachman
Thanks, everyone, for the help! Bill: This looks like a really great general solution, but unfortunately I get an error when I call sumUp: Error in [.data.frame(dat, , key_list, drop = FALSE) : invalid subscript type I'm running 2.2.1 because that's the latest I can get on