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

4 votes323 views1 answer
Correlation matrix in r
R
2 votes229 views1 answer
Mod in r
R
0 vote258 views1 answer
R most likely outcome
R
1 vote236 views1 answer
Create list in r
R
1 vote235 views1 answer
Name elements in vector r
R
0 vote225 views1 answer
Stat_poly_eq position
R
2 votes249 views3 answers
Rename columns based on a variable in r
R
0 vote231 views1 answer
Generate all possible combinations of a set of characters r
R
0 vote209 views1 answer
Split strings by space in r
R
0 vote221 views1 answer
Knn accuracy in r
R