How to rename multiple observations?

Question

I have a tibble with three columns in r. One of the columns are "week_days". All the observations in this column are abbreviated like this: (mo,tu,we,th,fr,sa,su). Though I want to change them to (monday, tuesday... and so on).

any idea on how I can do this?

score 3 · Answer 1 · answered Nov 25 '21 at 17:49

3

We can create a named vector of key/value to match and replace the values in the original data column in base R

nm1 <- setNames(c("monday", 'tuesday', 'wednesday', 'thursday', 
       'friday', 'saturday', 'sunday'),
      c('mo', 'tu', 'we', 'th', 'fr', 'sa', 'sun')   )
df1$week_days <- nm1[df1$week_days]

answered Nov 25 '21 at 17:49

akrun

874,273
37
540
662

1

Wow, did not think of this. Thank you! – Chrisabe Nov 25 '21 at 17:55

score 2 · Accepted Answer · answered Nov 25 '21 at 21:56

with `plyr`

df1$week_days <- plyr::mapvalues(
  df1$week_days,
  c('mo', 'tu', 'we', 'th', 'fr', 'sa', 'sun'),
  c("monday", 'tuesday', 'wednesday', 'thursday','friday', 'saturday', 'sunday')
)

with dplyr `recode`:

df1 %>%
  mutate(week_days = recode(week_days,
                            mo = "monday",
                            tu = 'tuesday'
                            we = 'wednesday',
                            th = 'thursday',
                            fr = 'friday',
                            sa = 'saturday', 
                            sun = 'sunday'))

Greate! This works as well when using dplyr :-) – Chrisabe Nov 26 '21 at 08:15 — Chrisabe, Nov 26 '21 at 08:15

How to rename multiple observations?

2 Answers2

with plyr

with dplyr recode:

with `plyr`

with dplyr `recode`: