reading csv file : blanks
Nattu wrote:
Hi,
I have a comma seperated data file which has blanks in it. I am trinying to
import it to R using
data1<-read.csv("oa_2006.csv", header = TRUE, sep = ",", quote="\"",
dec=".")
I want the missing values to be "NA". instead R reads them as "U". Any idea
why this happens ?
Hi Nataraju, You have to explicitly specify the strings that you want to be read as NA with the na.strings argument. na.strings="" if an empty string represents NA. Jim