Breaking News: Grepper is joining You.com. Read the official announcement!

group by and count number of rows in r

Happy Sushi answered on July 12, 2021 Popularity 7/10 Helpfulness 7/10

answer group by and count number of rows in r

related number of rows by group in r

group by and count number of rows in r

Comment

# Count the number of each category in df
df %>% 
  group_by(category) %>%
  summarise(number = n())

# For each category, count the number of val in df
df %>%
  group_by(category) %>%
  summarize(count = sum(var == 'val'))

Popularity 7/10 Helpfulness 7/10 Language r

Source: Grepper

Tags: count group-by r

Link to this answer
Share Copy Link

Contributed on Jul 28 2023

Happy Sushi

0 Answers Avg Quality 2/10

Closely Related Answers

number of rows by group in r

Comment

# dplyr package does this with count/tally commands, or the n() function:
# First, some data:

df <- data.frame(x = rep(1:6, rep(c(1, 2, 3), 2)), year = 1993:2004, month = c(1, 1:11))

# Now the count:
library(dplyr)
count(df, year, month)

# piping
df %>% count(year, month)

# We can also use a slightly longer version with piping and the n() function:
df %>% 
  group_by(year, month) %>%
  summarise(number = n())
  
 dplyr package does this with count/tally commands, or the n() function:

# First, some data:
df <- data.frame(x = rep(1:6, rep(c(1, 2, 3), 2)), year = 1993:2004, month = c(1, 1:11))

# Now the count:
library(dplyr)
count(df, year, month)
# piping
df %>% count(year, month)

# We can also use a slightly longer version with piping and the n() function:

df %>% 
  group_by(year, month) %>%
  summarise(number = n())

# or the tally function:
df %>% 
  group_by(year, month) %>%
  tally()

Popularity 9/10 Helpfulness 7/10 Language r

Source: stackoverflow.com

Tags: rows r group gr

Link to this answer
Share Copy Link

Contributed on Jul 12 2021

Trustworthy Whale

0 Answers Avg Quality 2/10

group by and count number of rows in r

Contents

More Related Answers

group by and count number of rows in r

Closely Related Answers

number of rows by group in r

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.