0

I have a variable with class "character", for example:

class(itc$`Mobile-cellular telephone subscriptions`)
[1] "character"

(itc$`Mobile-cellular telephone subscriptions`)
[1] "19'709'038"     "3'400'955"      "43'227'643"     "71'336"         "13'884'532"

When I use as.numeric all the values becomes NA.

zx8754
  • 46,390
  • 10
  • 104
  • 180
Zina Jg
  • 1
  • 3
  • either split them first or remove the delimiter completely...whichever you need – Sotos Jul 27 '17 at 11:24
  • Here is an example using the `stringr` library: `as.numeric(str_replace_all("19'709'038", "'", ""))` – roarkz Jul 27 '17 at 11:28
  • Or for the whole vector you could do: `cellphone – roarkz Jul 27 '17 at 11:33
  • The `destring()` function extracts only numeric values from a string. Might be useful. https://www.rdocumentation.org/packages/taRifx/versions/1.0.6/topics/destring – Andrew Brēza Jul 27 '17 at 11:35

1 Answers1

0

We can use str_extract

library(stringr)
sapply(str_extract_all(itc$`Mobile-cellular telephone subscriptions`, '[0-9.]+'), as.numeric)
akrun
  • 789,025
  • 32
  • 460
  • 575