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 <wdun...@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.leb...@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@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.
>>
>
>
[[alternative HTML version deleted]]
______________________________________________
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.
