Convert type of multiple columns of a dataframe at once

by

Edit See this related question for some simplifications and extensions on this basic idea.

My comment to Brandon’s answer using switch:

convert.magic <- function(obj,types){
    for (i in 1:length(obj)){
        FUN <- switch(types[i],character = as.character, 
                                   numeric = as.numeric, 
                                   factor = as.factor)
        obj[,i] <- FUN(obj[,i])
    }
    obj
}

out <- convert.magic(foo,c('character','character','numeric'))
> str(out)
'data.frame':   10 obs. of  3 variables:
 $ x: chr  "1" "2" "3" "4" ...
 $ y: chr  "red" "red" "red" "blue" ...
 $ z: num  15254 15255 15256 15257 15258 ...

For truly large data frames you may want to use lapply instead of the for loop:

convert.magic1 <- function(obj,types){
    out <- lapply(1:length(obj),FUN = function(i){FUN1 <- switch(types[i],character = as.character,numeric = as.numeric,factor = as.factor); FUN1(obj[,i])})
    names(out) <- colnames(obj)
    as.data.frame(out,stringsAsFactors = FALSE)
}

When doing this, be aware of some of the intricacies of coercing data in R. For example, converting from factor to numeric often involves as.numeric(as.character(...)). Also, be aware of data.frame() and as.data.frame()s default behavior of converting character to factor.

More Related Contents:

  1. How to convert a data frame column to numeric type?
  2. Convert data.frame column to a vector?
  3. Convert Named Character Vector to data.frame
  4. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  5. Convert dataframe column to 1 or 0 for “true”/”false” values and assign to dataframe
  6. How to convert integer into categorical data in R?
  7. Convert hours:minutes:seconds to minutes
  8. Convert numeric to date
  9. Finding y-hat in R [closed]
  10. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  11. How can I match fuzzy match strings from two datasets?
  12. Remove parentheses and text within from strings in R
  13. How do you change library location in R? [duplicate]
  14. R Shiny key input binding
  15. Understanding dates and plotting a histogram with ggplot2 in R
  16. Legend placement, ggplot, relative to plotting region
  17. sample rows of subgroups from dataframe with dplyr
  18. Display exact value of a variable in R
  19. knitr gets tricked by data.table `:=` assignment
  20. How to index an element of a list object in R
  21. Group data and plot multiple lines
  22. One-Hot Encoding in [R] | Categorical to Dummy Variables [duplicate]
  23. Select last non-NA value in a row, by row
  24. Change the default colour palette in ggplot
  25. How to label a barplot bar with positive and negative bars with ggplot2
  26. Row-wise sort then concatenate across specific columns of data frame
  27. Numbers as column names of data frames
  28. Harnessing .f list names with purrr::pmap
  29. Add axis tick-marks on top and to the right to a ggplot?
  30. Recommended package for very large dataset processing and machine learning in R [closed]

Leave a Comment