dplyr change many data types

by

Edit (as of 2021-03)

As also pointed out in Eric’s answer, mutate_[at|if|all] has been superseded by a combination of mutate() and across(). For reference, I will add the respective pendants to the examples in the original answer (see below):

# convert all factor to character
dat %>% mutate(across(where(is.factor), as.character))

# apply function (change encoding) to all character columns 
dat %>% mutate(across(where(is.character), 
               function(x){iconv(x, to = "ASCII//TRANSLIT")}))

# subsitute all NA in numeric columns
dat %>% mutate(across(where(is.numeric), function(x) tidyr::replace_na(x, 0)))

Original answer

Since Nick’s answer is deprecated by now and Rafael’s comment is really useful, I want to add this as an Answer. If you want to change all factor columns to character use mutate_if:

dat %>% mutate_if(is.factor, as.character)

Also other functions are allowed. I for instance used iconv to change the encoding of all character columns:

dat %>% mutate_if(is.character, function(x){iconv(x, to = "ASCII//TRANSLIT")})

or to substitute all NA by 0 in numeric columns:

dat %>% mutate_if(is.numeric, function(x){ifelse(is.na(x), 0, x)})

More Related Contents:

  1. R spreading multiple columns with tidyr [duplicate]
  2. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  3. dplyr filter with condition on multiple columns
  4. How to add a cumulative column to an R dataframe using dplyr?
  5. Get last row of each group in R [duplicate]
  6. R – add column that counts sequentially within groups but repeats for duplicates
  7. Change value of variable with dplyr
  8. dplyr – filter by group size
  9. Merge rows in a dataframe where the rows are disjoint and contain NAs
  10. Calculate group mean while excluding current observation using dplyr
  11. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  12. finding close match from data frame 1 in data fame 2
  13. Join two data frames in R based on closest timestamp
  14. How to dplyr rename a column, by column index?
  15. How to add only missing Dates in Dataframe
  16. Override column types when importing data using readr::read_csv() when there are many columns
  17. Adding column if it does not exist
  18. Replace values greater than zero with 1 in r
  19. How does one access the piped data.frame in dplyr::funs?
  20. Extract row corresponding to minimum value of a variable by group
  21. How to select the rows with maximum values in each group with dplyr? [duplicate]
  22. Remove columns from dataframe where ALL values are NA
  23. Detect at least one match between each data frame row and values in vector
  24. Cartesian product data frame
  25. Merge Two Lists in R
  26. dplyr issues when using group_by(multiple variables)
  27. Replace values in data frame based on other data frame in R
  28. Add an image to a table-like output in R
  29. Convert a data frame to a data.table without copy
  30. What is the first column in R’s mtcars dataset?

Leave a Comment