All geek questions in one place

Avoiding "Warning message: NA entered by duress" in as.numeric ()

I have a question on how to avoid NA when using the as.numeric function in R. As you can see below, I have a character variable (but its values ​​are numeric) cumulative_viewers , and I wanted to convert it to a numeric value via as.numeric but he did not work properly. The problem is that the number of digits of numeric values ​​exceeds four digits, the as.numeric function returns NA , even if the values ​​are numeric. For example, the as.numeric function as.numeric well with the value "999" or "997" BUT when the number of digits is more than four, such as "1000" or "1001" or "999999", then the as.numeric function returns NA =.=;;;;;;;;;;;; not its actual numerical value ....

Can someone help me solve the problem? I sent a day to handle this, but could not get a response TT> TT

 paste(data_without_duplicates$cumulative_viewers) [1] "12,983,336" "12,323,294" "11,375,954" "10,917,221" "10,667,700" [6] "10,292,386" "9,350,192" "9,135,520" "9,001,309" "8,653,415" [11] "7,784,755" "7,508,976" "7,362,790" "6,959,047" "6,706,543" ..... [1426] "1,026" "1,024" "1,023" "1,020" "1,017" [1431] "1,016" "1,013" "1,011" "1,001" "1,000" [1436] "1,000" "999" "997" "994" "990" [1441] "989" "988" "984" "982" "979" [1446] "974" "972" "971" "966" "961" as.numeric(data_without_duplicates$cumulative_viewers) [1] NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA [18] NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA [35] NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA ....... [1395] NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA [1412] NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA [1429] NA NA NA NA NA NA NA NA 999 997 994 990 989 988 984 982 979 [1446] 974 972 971 966 961 959 958 957 950 946 941 930 929 911 911 910 910 [1463] 910 907 907 902 898 897 895 892 890 890 889 885 885 883 872 871 868
+5
source share
2 answers

This is not a problem with the number of digits, but only the fact that your digits with four or more digits contain commas in them:

 N1 <- c("1000", "1,000", "10000", "10,000") as.numeric(N1) ## [1] 1000 NA 10000 NA Warning message: NAs introduced by coercion ## > N2 <- gsub(",","",N1) > as.numeric(N2) [1] 1000 1000 10000 10000
+11
source

It seems to me that the comma in your data is a problem. There are probably dozens of ways to handle this.

here alone

 x <- c("12,983,336", "12,323,294", "11,375,954", "10,917,221", "10,667,700", "10,292,386", "9,350,192", "9,135,520", "9,001,309", "8,653,415", "7,784,755", "7,508,976", "7,362,790", "6,959,047", "6,706,543", "1,026", "1,024", "1,023", "1,020", "1,017", "1,016", "1,013", "1,011", "1,001", "1,000", "1,000", "999", "997", "994", "990", "989", "988", "984", "982", "979", "974", "972", "971", "966", "961") as.numeric(gsub(",","",x,fixed=TRUE))
+3
source

Source: https://habr.com/ru/post/1201508/

More articles:


All Articles