How can I count the frequency of a variable in R?

Question

I am currently trying to count the frequency of countries that appear in a dataframe object.

I tried using count commands as well as rle(sort(x)), which apparently is used to search for strings. But it does not seem to yield any results.

rle(sort(x))

I tried using this, but does not seem to work. I also tried to use

count(x, "COUNTRY")

but all it does is count how many entries are there.

How can I get a result such as:

      Country        Frequency
[1]   United States      3
[2]   Mexico             5
[3]   Germany            12

dplyr uses NSE, so you'll need to pass the column name unquoted i.e. `dplyr::count(x, COUNTRY)` — dave-edison, Jul 15 '19 at 21:19

score 1 · Answer 1 · answered Jul 15 '19 at 21:19

1

Here is a small example using dplyr and the built-in dataset mtcars:

library(dplyr)

mtcars %>% 
  group_by(cyl) %>% 
  count(cyl)

or

mtcars %>% 
  group_by(cyl) %>% 
  add_count(cyl)

answered Jul 15 '19 at 21:19

eastclintw00d

score 1 · Answer 2 · answered Jul 15 '19 at 21:20

1

other solution is: table(yourdataframe$x)

answered Jul 15 '19 at 21:20

Samuel Reuther

score 1 · Answer 3 · answered Jul 15 '19 at 21:25

1

count(x,Country,Frequency)

Have to include both to see a deeper breakdown then it'll count the countries and Frequency

or

X%>%group_by(Country)%>%summarise(sum = sum(Frequency), n = n())

answered Jul 15 '19 at 21:25

Salvador Santos

3 Answers3