List of occuring values
Note that this data.frame(table(...)) makes a column for each argument to table(...), plus a column for the frequencies so you can easily deal with multiway tabulations.
rawData <- data.frame(
+ sizes = c("Small", "Large", "Large", "Large"),
+ colors = c("Red", "Blue", "Blue", "Red"),
+ condition = c("Good", "Poor", "Poor", "Poor"))
data.frame(with(rawData, table(sizes, colors, condition)))
sizes colors condition Freq 1 Large Blue Good 0 2 Small Blue Good 0 3 Large Red Good 0 4 Small Red Good 1 5 Large Blue Poor 2 6 Small Blue Poor 0 7 Large Red Poor 1 8 Small Red Poor 0
subset(.Last.value, Freq>0)
sizes colors condition Freq 4 Small Red Good 1 5 Large Blue Poor 2 7 Large Red Poor 1 Bill Dunlap TIBCO Software wdunlap tibco.com
On Thu, Sep 21, 2017 at 7:38 AM, William Dunlap <wdunlap at tibco.com> wrote:
unique(x) will give you the distinct values in x. table(x) will give you the distrinct values and their frequencies as an array with dimnames. data.frame(table(x)) will give you a 2-column data.frame with the distinct values and their frequencies.
values <- c("Small", "Large", "Large", "Large")
unique(values)
[1] "Small" "Large"
tblValues <- table(values) tblValues
values
Large Small
3 1
tblValues[tblValues > 2, drop=FALSE]
values
Large
3
dfValues <- data.frame(tblValues) dfValues
values Freq 1 Large 3 2 Small 1
subset(dfValues, Freq > 2)
values Freq 1 Large 3
factorValues <- factor(values, levels=c("Small","Medium","
Large","XLarge"))
data.frame(table(factorValues))
factorValues Freq 1 Small 1 2 Medium 0 3 Large 3 4 XLarge 0 Bill Dunlap TIBCO Software wdunlap tibco.com On Thu, Sep 21, 2017 at 6:01 AM, Ferri Leberl <ferri.leberl at gmx.at> wrote:
Dear all, ftable produces a list of the frequencies of all occuring values. But how about the occuring values? How can I retrieve a list of occuring values? How can I retrieve a table with both the list of occuring values and their respective frequencies? Thank you in advance, Yours, Ferri
______________________________________________ R-help at 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/posti ng-guide.html and provide commented, minimal, self-contained, reproducible code.