[R] Replace <NA> with something else

[jim holtman]

use  na.strings = ''


> x <- read.table(text = "635     LA 201207  557329
+ 636     LA 201208  683771
+ 637     LA 201209  613851
+ 638     LA 201210  764217
+ 639     LA 201211  212897
+ 782   NA 200701  875634
+ 783   NA 200702  614856
+ 784   NA 200703  521520
+ 785   NA 200704 1406400", as.is = TRUE, na.strings = '')
> x
   V1 V2     V3      V4
1 635 LA 201207  557329
2 636 LA 201208  683771
3 637 LA 201209  613851
4 638 LA 201210  764217
5 639 LA 201211  212897
6 782 NA 200701  875634
7 783 NA 200702  614856
8 784 NA 200703  521520
9 785 NA 200704 1406400
> dput(x)
structure(list(V1 = c(635L, 636L, 637L, 638L, 639L, 782L, 783L,
784L, 785L), V2 = c("LA", "LA", "LA", "LA", "LA", "NA", "NA",
"NA", "NA"), V3 = c(201207L, 201208L, 201209L, 201210L, 201211L,
200701L, 200702L, 200703L, 200704L), V4 = c(557329L, 683771L,
613851L, 764217L, 212897L, 875634L, 614856L, 521520L, 1406400L
)), .Names = c("V1", "V2", "V3", "V4"), class = "data.frame", row.names = c(NA,
-9L))


On Sun, Nov 18, 2012 at 4:18 PM, eric <ericstrom at aol.com> wrote:
> I am reading some data into R from an Excel spreadsheet using read.csv. Some
> of the original data that comes into column 1 from the spreadsheet is text
> that says NA. The NA stands for north america. As it comes in, R converts
> the NA over to  <NA>.
>
> What is the cleanest way to change the <NA>  values to something else. In
> other words, get rid of the brackets ? Maybe convert <NA> to NAM.
>
> 635     LA 201207  557329
> 636     LA 201208  683771
> 637     LA 201209  613851
> 638     LA 201210  764217
> 639     LA 201211  212897
> 782   <NA> 200701  875634
> 783   <NA> 200702  614856
> 784   <NA> 200703  521520
> 785   <NA> 200704 1406400
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Replace-NA-with-something-else-tp4649974.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.