How can we add the rank for each arranged dataframe ?
How can we add another column called rank which
describes the rank for that group.
e.g.
Species class value rank
1 setosa Petal.Width 0.1 1
2 setosa Petal.Width 0.1 2
3 setosa Petal.Width 0.1 3
Similarly however, this rank does not rank all 600 rows instead.
It should start and end within the group.
library(tidyr)
my_df =iris %>% pivot_longer(names_to = "class", cols = c(1:4))
op = my_df %>% group_by(Species, class) %>%
arrange(value)
my_df %>% group_by(Species, class) %>%
+ arrange(value)
# A tibble: 600 x 3
# Groups: Species, class [12]
Species class value
<fct> <chr> <dbl>
1 setosa Petal.Width 0.1
2 setosa Petal.Width 0.1
3 setosa Petal.Width 0.1
4 setosa Petal.Width 0.1
5 setosa Petal.Width 0.1
6 setosa Petal.Width 0.2
7 setosa Petal.Width 0.2
8 setosa Petal.Width 0.2
9 setosa Petal.Width 0.2
10 setosa Petal.Width 0.2
# … with 590 more rows