Batch convert columns to numeric type

Question

I have a dataframe with a bunch of columns that I need to convert to the numeric type. I have written the following code to try to do this, however it is saying the replacement has 0 rows.

instanceconvert <- colnames(regmodel[7:262])  for (i in instanceconvert) {   regmodel$i <- as.numeric(regmodel$i) } 

Any help would be appreciated.

Answer 1

You can use sapply for this:

dat <- sapply( dat, as.numeric ) 

If not every column needs converting:

library( taRifx ) dat <- japply( dat, which(sapply(dat, class)=="character"), as.numeric ) 

Answer 2

Here is quick solution from other question:

df[] <- lapply(df, function(x) as.numeric(as.character(x)))

Reference: Change all columns from factor to numeric in R