How to use Group by in R

Question

I have a dataFrame that looks like this:

 Name  |  Price   |  City
  ABC  | 10       | Chicago
  XYZ  | 12       | NJ
  ASD  | 43       | Chicago
  RTY  | 34       | Chicago

I want to count the number of occurrences of each City

City    | Count
Chicago | 3
NJ      | 1

How do I do this?

`df %>% group_by(City) %>% summarise(Count = n())` – alistaire Feb 17 '16 at 01:05 — alistaire, Feb 17 '16 at 01:05
Or `dplyr::count(dataFrame, City)` – Rich Scriven Feb 17 '16 at 01:16 — Rich Scriven, Feb 17 '16 at 01:16

score 1 · Answer 1 · answered Feb 17 '16 at 01:06

1

Try

aggregate(dataFrame, list(dataFrame$City), FUN=length)

answered Feb 17 '16 at 01:06

Charles Stangor

1 Answers1