Issue converting multiple column classes in R data.table

Question

I would like to convert a list of variables in R data.table, however, this conversion lead to unexpected consequence. I'm running under R version 4.0.1 with library data.table_1.12.8. Here is a simplified example:

> dput(norw5)
structure(list(Born_before_2016 = c(1L, 1L, 1L, 1L, 1L), gender = c("2.Female", 
"1.Male", "2.Female", "1.Male", "1.Male"), payor = c("1:Private", 
"1:Private", "4:Other", "4:Other", "1:Private"), Age_in_day = c(0L, 
0L, 0L, 4L, 5L)), row.names = c(NA, -5L), class = c("data.table", 
"data.frame"), .internal.selfref = <pointer: 0x0000024ce5a41ef0>)

library(data.table)

fact <- c('Born_before_2016', 'gender', 'payor')

varls <- scan(text=fact, what = "", quiet = T)

factcols <- sapply(norw5[,..varls], is.numeric)

norw5new <- norw5[, names(norw5)[factcols] := lapply(.SD, as.character),
                  .SDcols = factcols]

> dput(norw5new)
structure(list(Born_before_2016 = c("1", "1", "1", "1", "1"), 
    gender = c("2.Female", "1.Male", "2.Female", "1.Male", "1.Male"
    ), payor = c("1:Private", "1:Private", "4:Other", "4:Other", 
    "1:Private"), Age_in_day = c("0", "0", "0", "4", "5")), row.names = c(NA, 
-5L), class = c("data.table", "data.frame"), .internal.selfref = <pointer: 0x0000024ce5a41ef0>)

As you shown above, finding numeric variables (Born_before_2016 in this example) and converting them to character is the goal. However, conversion is expanded to additional variable Age_in_day, which is not in the list at all. I couldn't figure this out, can R gurus here point me a right direction of fixing this? Thanks!

Peace Wang · Accepted Answer · 2022-02-19 01:41:22Z

3

factcols in .SDcols=factcols should be a length-4 logical vector or the vector of column name/position, e.g. .SDcols = c("Born_before_2016"),.SDcols = 1, but factcols <- sapply(norw5[,..varls], is.numeric) returns length-3 logical vector. It can be fixed as

fact <- c('Born_before_2016','gender','payor')
factcols <- sapply(norw5[,..fact], is.numeric)
cols <- names(norw5)[1:3][factcols]
norw5new <- norw5[,(cols) := lapply(.SD,as.character),.SDcols=cols]
norw5new 

#   Born_before_2016   gender     payor Age_in_day
#             <char>   <char>    <char>      <int>
#1:                1 2.Female 1:Private          0
#2:                1   1.Male 1:Private          0
#3:                1 2.Female   4:Other          0
#4:                1   1.Male   4:Other          4
#5:                1   1.Male 1:Private          5

edited Feb 19, 2022 at 1:41

answered Feb 19, 2022 at 1:27

Peace Wang

2,4291 gold badge10 silver badges16 bronze badges

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

2 Comments

ponyhd Over a year ago

This solves issue beautifully, Thanks so much!

Peace Wang Over a year ago

Aha, if you accept this answer, it would be better.

Collectives™ on Stack Overflow

Issue converting multiple column classes in R data.table

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