Any thoughts on why the NAs are popping up, and how to get rid of them?Īs Anando pointed out, the problem is somewhere in your data, and we can't really help you much without a reproducible example.
to look at the observations to see if there are any characters that I missed in the observations, but there weren't any. I've also used table(dd_2006$SumOfCases) etc. #changing sumofcases, cost, and units to numericĭd_2006_1 sum(is.na(dd_2006_1$SumOfCost))
#R convert character to numeric code#
So I tried the above code in my script, but still came up with NAs (without a warning message about coercion). Transform(d, fake_char = as.numeric(fake_char),Ĭhar_fac = as.numeric(char_fac)) char fake_char fac char_fac num In eval(expr, envir, enclos) : NAs introduced by coercionīut if you do same thing on fake_char and char_fac, you'll be lucky, and get away with no NA's: If you utilize transform function, you can convert the fake_char into numeric, but not the char variable itself. 3rd and 4th column are factor, and the last one is "purely" numeric. It's actually a numerical vector converted to character. Spot the similarity of this character variable with one that Dirk created in his reply. I've deliberately called 2nd one fake_char. Here goes: first two columns are character. Now you probably ask yourself "Where's an anomaly?" Well, I've bumped into quite peculiar things in R, and this is not the most confounding thing, but it can confuse you, especially if you read this before rolling into bed.
"character" "character" "factor" "factor" "integer" "character" "character" "numeric" "numeric" "numeric" In the str(dd_2006) output, I deleted some of the variables for the sake of space, so the column #s in the str_replace_all code below don't match the output I've posted here (but they do in the original code): library("stringr") Here is my code from after the import, beginning with removing the $ from the vector. So I used as.numeric(var) to convert the vectors to numeric, but NAs were introduced, even though when I ran the code below BEFORE I ran the as.numeric code, there were no NAs in the vectors. However, once I used str_replace_all, the vectors were converted to characters. When I first imported the data, I needed to remove $'s, decimal points, and some blank spaces from 3 of my variables: SumOfCost, SumOfCases, and SumOfUnits. I'm working in R and have a dataframe, dd_2006, with numeric vectors.
0 kommentar(er)
