How to set a column as numeric when the numbers have 2 or more points in the value?

Asked Aug 03 '21 at 14:18

Active Aug 03 '21 at 14:39

Viewed 35 times

I have one large data frame in R in which some columns have numbers with 2 or more points. For example, 100.200.220 and NAs. When I try to convert this column that is set as character to numeric using as.numeric(), I got the warning "nas introduced by coercion" I tried to change the points to nothing gsub(".", "", column_of_interest), or to commas using gsub(), but this eliminate the values.

Thanks for your help

asked Aug 03 '21 at 14:18

Eduardo Herreros

1

Dot is special and matches any character. Use fixed=TRUE to turn that off. `gsub(".", "", column, fixed = TRUE)` – G. Grothendieck Aug 03 '21 at 14:32
Thanks G. Grothendieck – Eduardo Herreros Aug 03 '21 at 14:38

How to set a column as numeric when the numbers have 2 or more points in the value?

0 Answers0