R programming- how to rename/change values

[dabidxd]

new to R

i need to change the values for the variable location (basically anything truncated will be the full value)

data:

  location
   s. sj
  S. SJ @ Ashley Store
  S. SJ @ Ashley
  Pleasanton
  pleas
  Pleasanton @ Ranch 99

want:

 location
 S. SJ @ Ashley Store
 S. SJ @ Ashley Store
 S. SJ @ Ashley Store
 Pleasanton @ Ranch 99
 Pleasanton @ Ranch 99
 Pleasanton @ Ranch 99

thanks!

[williaml]

This works for these values:

library(tidyverse)

df <- tibble::tribble(
                ~location,
                  "s. sj",
   "S. SJ @ Ashley Store",
         "S. SJ @ Ashley",
             "Pleasanton",
                  "pleas",
  "Pleasanton @ Ranch 99"
  )

df %>% 
  mutate(location2 = case_when(
    location %in% c("s. sj", "S. SJ @ Ashley Store", "S. SJ @ Ashley") ~ "S. SJ @ Ashley Store",
    location %in% c("Pleasanton", "pleas", "Pleasanton @ Ranch 99") ~ "Pleasanton @ Ranch 99",
    TRUE ~ NA_character_
  ))

[dabidxd]

Thanks for the quick response.

But is there something more robust? because with a larger dataset there might be other truncated values that I am not aware and those will need full value.

For example anthing starting with a "S" or "s" will be "S. SJ @ Ashley Store"

[williaml]

df %>% 
  mutate(location2 = case_when(
    str_starts(location, c("s", "S", "S.")) ~ "S. SJ @ Ashley Store", # not sure why the dot is needed for the second s
    str_starts(location, c("p", "P")) ~ "Pleasanton @ Ranch 99",
    TRUE ~ NA_character_
  ))