Replacing commas and dots in R
For things like these I like scan()
the most, because it is easy to understand. Just use
scan(text=var1, dec=",", sep=".")
Alas, it's not faster than gsub()
, which on the other hand seemes overpowered. Hence another, and fast, option is sub()
:
as.numeric(sub(",", ".", sub(".", "", var1, fixed=TRUE), fixed=TRUE))
And just in case: When you're reading var1
from a file directly, just read it in with a specified separator: read.table("file.txt", dec=",", sep=".")
You can use function "type_convert", from "readr" package. I am reading an ODS file (Locale Portuguese), and converting the numbers:
library('readODS')library('tidyverse')data <- read_ods('mod-preditivo.ods', sheet=1,col_names = TRUE,range='a1:b30',col_types=NA)df <- type_convert(data,trim_ws=TRUE,col_types = cols(Pesos=col_integer(),Alturas=col_double()),locale = locale(decimal_mark = ","))str(df)