Conditionally recode variable by using dplyr

Question

The question is as follows:

Create a new variable that assumes the value 1 when the house type is House, 2 if the type is Penthouse, 3 if the type is Flat / Apartment or Studio and 0 otherwise. Use the table() function on the new variable.

the variables House type consists of the following unique values: "House", "Flat/Apartment", "new development", "duplex", "Penthouse", "studio", "bungalow", "Mews".

Does anyone now which dplyr function I need to solve this question?

Does this answer your question? [dplyr mutate with conditional values](https://stackoverflow.com/questions/22337394/dplyr-mutate-with-conditional-values) — langtang, Jun 12 '22 at 14:35

score 0 · Answer 1 · answered Jun 12 '22 at 14:31

0

You can use case_when(), followed by count()

df %>%
  mutate(new_var = case_when(
    House=="House"~1,
    House=="Penthouse"~2,
    House %in% c("Flat/Apartment","Studio")~3,
    TRUE~0)) %>%
  count(new_var)

answered Jun 12 '22 at 14:31

langtang

22,248
1
12
27

score 0 · Answer 2 · edited Jun 12 '22 at 16:08

0

It may be easier with factor and levels specified

v1 <- with(df, as.integer(factor(House, levels = c("House", 
                "Penthouse", "Flat/Apartment", "Studio"))))
v1[is.na(v1)] <- 0
v1[v1 == 4] <- 3
table(v1)

edited Jun 12 '22 at 16:08

user438383

5,716
8
28
43

answered Jun 12 '22 at 16:06

akrun

874,273
37
540
662

Conditionally recode variable by using dplyr

2 Answers2