Hi, As Sarah noted, there are a variety of ways in R to accomplish this, such as:
DF <- data.frame(var1 = c(0, 0, 1, 1), var2 = c(0, 1, 0, 1), freq = c(11, 12, 13, 14)) > xtabs(freq ~ var1 + var2, data = DF) var2 var1 0 1 0 11 12 1 13 14 See ?xtabs Regards, Marc Schwartz > On Aug 13, 2015, at 8:39 AM, Sarah Goslee <sarah.gos...@gmail.com> wrote: > > Hi, > > There are lots of ways to do it in base R, but a long time ago I got > frustrated and wrote a crosstab function that did exactly what I > wanted: > > library(ecodist) > mydata <- data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) > crosstab(var1, var2, freq, data=mydata) > > 0 1 > 0 11 12 > 1 13 14 > > Sarah > > On Thu, Aug 13, 2015 at 5:30 AM, Dean1 <web13s...@yahoo.co.uk> wrote: >> Hi all, >> >> I've had a few years experience with R, which is why this is so frustrating, >> my problem seems so simple but I can't find a solution. >> >> I have a data frame in the following form: >> >> data.frame(var1=c(0,0,1,1),var2=c(0,1,0,1),freq=c(11,12,13,14)) >> >> How do I create a crosstab with frequencies? >> 0 1 >> 0: 11 12 >> 1: 13 14 >> >> > > -- > Sarah Goslee > http://www.functionaldiversity.org ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.