Converting to string all values in a data frame in R

Question

How can I make sure each single value contained in a dataframe is a string?

Moreover, is there a way I can add a prefix to each value contained in a dataframe? (for example, turning a 0.02 to "X0.02")

Possible duplicate of Convert type of multiple columns of a dataframe at once — NelsonGon
– NelsonGon, Commented Jun 7, 2019 at 16:04
Perhaps there's a better duplicate. The above is a bit too complex. — NelsonGon
– NelsonGon, Commented Jun 7, 2019 at 16:06

akrun · Accepted Answer · 2019-06-07 15:41:38Z

3

We can loop through the columns of the data.frame with lapply, convert to character and assign the output back to the dataset. The [] is used to preserve the attributes of the original data and not output as a list element

dat[] <- lapply(dat, as.character)

Or if there is at least one character element, conversion to matrix and then back to data.frame will also make sure the elements are character

as.data.frame(as.matrix(dat), stringsAsFactors = FALSE)

For the second case

dat[] <- lapply(dat,function(x) paste0("X", x))

Or in tidyverse

library(dplyr)
library(stringr)
dat %>%
   mutate_all(list(~ str_c("X", .)))

edited Jun 7, 2019 at 15:41

answered Jun 7, 2019 at 15:38

akrun

891k38 gold badges590 silver badges700 bronze badges

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

1 Comment

Rui Barradas Over a year ago

@iod To keep the shape (dimensions) of the dataset.

Collectives™ on Stack Overflow

Converting to string all values in a data frame in R

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related