reading csv file : blanks

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090429/40428fa3/attachment-0001.pl>
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
When you read in a .csv file with some empty cells using read.csv,
there is no need to specify anything - empty cells will be recorded as
NAs automatically:

try:

data1<-read.csv("oa_2006.csv")

Dimitri
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

______________________________________________
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.

Dimitri Liakhovitski
MarketTools, Inc.
Dimitri.Liakhovitski at markettools.com