String "NA" converted to <NA>

Question

I have a file csv

with country names and their iso-codes. This is how it looks:

"Name","Code"
"Afghanistan","AF"
"Albania","AL"
"Algeria","DZ"
"Namibia","NA"

I read it in data.frame

using the following code:

cc = read.csv("countries.csv", header=TRUE, stringsAsFactors=FALSE, 
                                           colClasses = c("character"))

This is what the data looks like:

Name         Code
Afghanistan  AF
Albania      AL
Algeria      DZ
Namibia      <NA>

The string is "NA"

converted to <NA>

, although I am explicitly setting colClasses = c("character")

.

How do I get "NA"

to show how "NA"

in data.frame

?

+3

Armin June 29. 15 at 16:55

1 answer

Mike wise · Accepted Answer · 2015-06-29T16:58:34+0000

Try to set the parameter explicitly na.strings

- the default is "NA":

    cc = read.csv("countries.csv", header=TRUE, stringsAsFactors=FALSE,
                              colClasses = c("character"),  na.strings="" )