how to build a summary variable using multiple col info

Question

I have a data that looks like this:

it can be build using codes:

df<-structure(list(`Hobby 1` = c("Drawing", NA, "Singing", "drawing"
), `Hobby 2` = c(NA, NA, "reading", "singing"), `Hobby 3` = c(NA, 
NA, NA, "reading")), row.names = c(NA, -4L), class = c("tbl_df", 
"tbl", "data.frame"))

Is it a way I can build a summary varaible for it that will looks like this:

Please paste the actual tables here instead of images. (Yes, Stack Overflow has support for tables now!) — Konrad Rudolph
– Konrad Rudolph, Commented Dec 15, 2020 at 14:46

Konrad Rudolph · Accepted Answer · 2020-12-15 14:50:43Z

2

unite from ‘tidyr’ does this almost out of the box:

〉df %>% unite(Hobby, `Hobby 1` : `Hobby 3`, sep = ', ', na.rm = TRUE)
# A tibble: 4 x 1
  Hobby
  <chr>
1 "Drawing"
2 ""
3 "Singing, reading"
4 "drawing, singing, reading"

So, with minimal post-processing:

df %>%
    unite(
        Hobby, `Hobby 1` : `Hobby 3`,
        sep = ', ',
        na.rm = TRUE,
        remove = FALSE
    ) %>%
    mutate(Hobby = ifelse(nzchar(Hobby), paste('Hobby:', Hobby), 'No Hobby'))

answered Dec 15, 2020 at 14:50

Konrad Rudolph

549k142 gold badges967 silver badges1.3k bronze badges

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

Comments

Allan Cameron · Accepted Answer · 2020-12-15 14:53:50Z

1

Or, in base R:

df$Hobby <- paste("Hobby:", sub("NA", "None", gsub(", NA", "", 
            apply(df, 1, paste, collapse = ", "))))

df
#>   Hobby 1 Hobby 2 Hobby 3                            Hobby
#> 1 Drawing    <NA>    <NA>                   Hobby: Drawing
#> 2    <NA>    <NA>    <NA>                      Hobby: None
#> 3 Singing reading    <NA>          Hobby: Singing, reading
#> 4 drawing singing reading Hobby: drawing, singing, reading

answered Dec 15, 2020 at 14:53

Allan Cameron

178k7 gold badges71 silver badges118 bronze badges

Collectives™ on Stack Overflow

how to build a summary variable using multiple col info

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related