Recoding values in R

Question

I am trying to make the table below show a "Y" if the cell is populated. And if the cell is empty it is recoded as an "N"

Below I have provided a image along with the code I am using. In the image, the left column is what I am working with, and the right column is what I'm wanting it to be recoded as.

df <- df %>% 
  mutate(column1 = recode(column1,
                               " " = "N",
                               "If populated" = "Y"))

Any help is appreciated.

df %>% mutate(column1 = ifelse(column1 == " ", "N", "Y")) ? — Axeman
– Axeman, Commented Mar 21, 2023 at 22:26

Sam Talcott · Accepted Answer · 2023-03-23 01:11:59Z

0

You can use the if_else() function from dplyr to create the new column, though the exact syntax depends on what the blank values are actually represented by in your data frame.

# If the values are stored as NA:
df <- df |>
  mutate(recode = if_else(is.na(column1), 'n', 'y'))

# If the values are stored as empty strings:
df <- df |>
  mutate(recode = if_else(column1 == '', 'n', 'y'))

# If the values are stored as spaces:
df <- df |>
  mutate(recode = if_else(column1 == ' ', 'n', 'y'))

edited Mar 23, 2023 at 1:11

answered Mar 21, 2023 at 22:29

Sam Talcott

914 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

George Savva Over a year ago

ifelse is not part of dplyr

Sam Talcott Over a year ago

Whoops! Yes, I was thinking of if_else. Updating now

Collectives™ on Stack Overflow

Recoding values in R

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related