A reproducible example would be really helpful here, but I think what you want is: table(NumberOfActionsByUser, NumberOfBidOffer)
On Wed, Jan 18, 2012 at 3:49 PM, caam <shawn.akh...@gmail.com> wrote: > I am trying to create a frequency distribution and I am a bit confused. > > Here are the commands I have entered: > >> data <- read.csv(file="40609_sortedfinal.csv",head=TRUE,sep=",") >> NumberOfActionsByStatus = data$STATUS >> NumberOfActionsByUser = data$ETS_LOGIN >> NumberOfBidOffer = data$BID_OFFER >> NumberOfActionsByUser.freq = table(NumberOfActionsByUser) >> NumberOfBidOffer.freq = table(NumberOfBidOffer) >> NumberOfActionsByStatus.freq = table(NumberOfActionsByStatus) > > > After doing that above, I was able to see the freq. distribution of contents > in each. > >> cbind(NumberOfBidOffer.freq) > NumberOfBidOffer.freq > Bid 178074 > Offer 179540 > >> cbind(NumberOfActionsByUser.freq) > NumberOfActionsByUser.freq > A 22 > B 2 > C 29028 > D 328054 > E 187 > F 7 > G 2 > H 4 > I 308 > > ............................ > > Now, what I am having a problem with is, I want to then output a freq > distribution that shows out of the 22 actions by A.. how many of those > actions were BID and how many of those were OFFER. > > I would like to do that for each user; ie. A->F > > What is the best command to do this? > > Any help would be appreciated, > > Best, > > SA > > -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.