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

0 vote188 views1 answer
Replace character with na r
R
1 vote169 views1 answer
R dataframe filter endswith
R
1 vote163 views1 answer
R extract everything before character
R
0 vote171 views1 answer
How to remove all attributes from a variables in r
R
0 vote176 views1 answer
Ggplot: boxplot with trendline
R
0 vote173 views2 answers
Insert character into string
R
0 vote174 views1 answer
R change column value conditionally
R
1 vote160 views1 answer
How to fill na values in r
R
4 votes312 views6 answers
Read csv in r
R
0 vote151 views1 answer
R read.csv tab delimited
R