[R] List of occuring values

[William Dunlap]

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.
>>
>
>

	[[alternative HTML version deleted]]