How do you group by and count for character vectors in R

Asked Apr 02 '19 at 16:13

Active Apr 02 '19 at 16:19

Viewed 125 times

I cant seem to group by sex and count the frequency of preference over time

Tried this:

    PreferenceOverTimeByAge <- group_by(all7Wide$a_sex_dv)%>%
                               count(all7Wide$'preference_over_time')

but got an error :

Error in UseMethod("group_by_") : no applicable method for 'group_by_' applied to an object of class "character"

table looks like this

all7Wide

pidp .  a_sex_dv .  preference_over_time . 
1 .     male .      Conservative_Labour_Conservative
2 .     female .    Labour_Labour_Labour
3 .     male .      Labour_Labour_Labour
4 .     male .      Labour_Labour_Labour
5 .     female .    Conservative_Labour_Labour

I would like to produce a table liker this


a_sex_dv  preference_over_time .               frequency
male .    Conservative_Labour_Conservative .    1
female .  Conservative_Labour_Conservative      0
male .    Labour_Labour_Labour                  2 
female .  Labour_Labour_Labour                  1
male .    Conservative_Labour_Labour .          0
female .  Conservative_Labour_Labour .          1

edited Apr 02 '19 at 16:19

Norcino

3,271
4
16
31

asked Apr 02 '19 at 16:13

J1997

1

It's just `all7wide %>% group_by(a_sex_dv) %>% count(preference_over_time)`. You don't include the data frame name with `$`. – joran Apr 02 '19 at 16:15
@antoine-sac this is probably just a typo. – Roman Luštrik Apr 02 '19 at 16:26

How do you group by and count for character vectors in R

0 Answers0

Linked