I would like to name each row in this data frame based on name:
x <- data.frame(
name = c('a', 'a', 'b', 'c', 'c', 'c'),
id = c(2324545, 343245, 35435, 546565, 67432, 87865)
)
Final result should be:
name id new_name
1 a 2324545 a_01
2 a 343245 a_02
3 b 35435 b_01
4 c 546565 c_01
5 c 67432 c_02
6 c 87865 c_03
How is this possible? Thanks