Is there an R function for transforming entire df into lower?

Question

I'm setting up a data table & expected to transform all data to be in lower-case, thought it would look neat. How can I do that ?

Please you need to provide more info, what you have tried or where are you stuck or what issue you are facing. thanks — Jithin Scaria, Apr 17 '19 at 12:40

akrun · Answer 1 · 2019-04-17T12:37:42.270

3

We can use

library(data.table)
setDT(TestData)[, lapply(.SD, tolower)]

Or using tidyverse

library(tidyverse)
TestData %>%
     mutate_if(is.character, tolower)

edited Apr 17 '19 at 12:37

answered Apr 17 '19 at 12:35

akrun

Thanks. Data table name is TestData. Is the code below is correct ? TestData[, lapply(.SD, tolower)] – Mr.KT Apr 17 '19 at 12:37
@Mr.KT Yes, assuming it is a data.table – akrun Apr 17 '19 at 12:38
1

I tried but throwing up an error Error in tolower(`Address Line 1`) : invalid input 'Dolní 3137/100' in 'utf8towcs' – Mr.KT Apr 17 '19 at 12:42
1

@Mr.KT I think that is a encoding issue, you may have to check the settings – akrun Apr 17 '19 at 12:44
Error msg: Cannot find symbol TestData – Mr.KT Apr 17 '19 at 15:44
1

@M You only said the dataset name is `TestData` – akrun Apr 17 '19 at 15:46
Thanks @akrun. I will give it a try & let you know – Mr.KT Apr 17 '19 at 16:44

NelsonGon · Answer 2 · 2019-04-17T14:02:31.590

1

Here is an alternative that can also be combined with mutate from dplyr:

purrr::map(Filter(is.character,my_data),~tolower(.x))

We can also achieve the same using a combination of dplyr and purrr as suggested by @Shinobi_Atobe

my_data %>% 
keep(is.character) %>% 
map(~tolower(.x))

edited Apr 17 '19 at 14:02

answered Apr 17 '19 at 13:46

NelsonGon

1

probably just semantics, but I'd have gone with `my_data %>% keep(is.character) %>% map(~tolower(.x))` – Shinobi_Atobe Apr 17 '19 at 14:00
@Shinobi_Atobe I'll add that to reflect integration with `dplyr`. Thanks! – NelsonGon Apr 17 '19 at 14:01
Error in loadNamespace(name) : there is no package called ‘purrr’ – Mr.KT Apr 17 '19 at 15:45
1

@Shinobi_Atobe Error in my_data %>% keep(is.character) %>% map(~tolower(.x)) : could not find function "%>%" – Mr.KT Apr 17 '19 at 15:46
@Mr.KT If you don't have these packages, please run `install.packages(c("purrr","dplyr"))`;`library(purrr)`;`library(dplyr)` first. – NelsonGon Apr 17 '19 at 15:47

2 Answers2