Skip to main content
3 of 3
replaced http://stats.stackexchange.com/ with https://stats.stackexchange.com/

How to calculate group statistics in R

Possible Duplicate:
R: compute correlation by group

I have a data set with a 6 or so data points for groups of data.

e.g.:

email_id   date_sent  number_sent  number_of_views  number_of_responses
1           5/4         600            25                6
1           5/5         500            22                8
1           5/6         450            23                4
1           5/7         700            34               12
2           5/5         900            30               10
2           5/6         750            28               11
...

(this is made up data that illustrates the point)

Assuming I have this in a data frame in R, I'd like to write something which will give me stats by group. I'm most interested in the correlation coefficient between some of the columns.

I know how to do this with a data frame that contains only one group:

cor(col1, col2)

but I'd like to learn a technique that will allow me to extract data that looks something like this:

email_id    cor(col3, col4)
1             .73
2             .85
3             .98

and so on.

Thanks,

Scott Wood
  • 121
  • 1
  • 2