Number of rows by group in r

# 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()

Source: stackoverflow.com

Similar codes

1 vote229 views1 answer
Dplyr colnames r
R
0 vote223 views1 answer
How to bootstrap in r with resampling
R
0 vote241 views4 answers
If not na in r
R
0 vote216 views3 answers
Make the first row as header in r
R
2 votes214 views1 answer
Check type of column in r
R
1 vote207 views1 answer
For in r
R
0 vote233 views1 answer
How to substring in R from position
R
0 vote210 views1 answer
Calculating RMSE, MAE, MSE, Rsquared manually in R
R
0 vote206 views1 answer
Ggplot glm
R
0 vote240 views1 answer
R - remove NA from a coulm
R