Does this do what you want: )> x <- read.csv(textConnection("home,sqr_footage,cost,color,exterior + 1,1500,150000,,Siding + 2,2000,200000,Red,Brick + 3,,300000,Grey,Brick + 4,3500,350000,Blue, + 5,4000,450000,Red,Brick"), na.strings='') > closeAllConnections() > > x home sqr_footage cost color exterior 1 1 1500 150000 <NA> Siding 2 2 2000 200000 Red Brick 3 3 NA 300000 Grey Brick 4 4 3500 350000 Blue <NA> 5 5 4000 450000 Red Brick >
On Tue, Oct 6, 2009 at 1:12 PM, Jason Rupert <jasonkrup...@yahoo.com> wrote: > Well, I guess I posted a poor example. > > This example is a little closer: > home,sqr_footage,cost,color,exterior > 1,1500,150000,,Siding > 2,2000,200000,Red,Brick > 3,,300000,Grey,Brick > 4,3500,350000,Blue, > 5,4000,450000,Red,Brick > > This one actually shows the presence of the null fields that are loaded. > > Sorry again for the poor 1st example. > > Thank you again for your time and insight. > > > > --- On Tue, 10/6/09, Erik Iverson <eiver...@nmdp.org> wrote: > >> From: Erik Iverson <eiver...@nmdp.org> >> Subject: RE: [R] Way of handling empty value when reading in CSV >> To: "Jason Rupert" <jasonkrup...@yahoo.com>, "R-help@r-project.org" >> <R-help@r-project.org> >> Date: Tuesday, October 6, 2009, 11:42 AM >> I saved your data as test.csv, and >> >> > read.csv("~/test.csv", header = TRUE) >> home sqr_footage cost >> 1 1 1500 150000 >> 2 2 2000 200000 >> 3 3 NA >> 300000 >> 4 4 3500 350000 >> 5 5 4000 450000 >> >> I am using R 2.8.1, old I know... but maybe something else >> is going on? Do you really get a blank when you read >> in your sample data? >> >> Erik >> >> > -----Original Message----- >> > From: r-help-boun...@r-project.org >> [mailto:r-help-boun...@r-project.org] >> > On Behalf Of Jason Rupert >> > Sent: Tuesday, October 06, 2009 11:39 AM >> > To: R-help@r-project.org >> > Subject: [R] Way of handling empty value when reading >> in CSV >> > >> > I believe I may be overlooking something simple in >> order address this, but >> > I have searched RSeek.org and using "?", but cannot >> seem to find anything >> > discussing this one. >> > >> > >> > I am using read.csv to read in a csv file. >> Evidently in places there is >> > nothing between the commas, so that when the data is >> read in the >> > data.frame produced has values that are empty. >> > >> > >> > Is there a way to fix this when reading the data via >> "read.csv"? I looked >> > at all the options mentioned in ?read.csv, but did not >> see anything to >> > address this case, e.g. >> > >> > >> > home,sqr_footage,cost >> > 1,1500,150000 >> > 2,2000,200000 >> > 3,,300000 >> > 4,3500,350000 >> > 5,4000,450000 >> > >> > >> > I would like for the empty cells to have a value of >> "NA" when they are >> > read in. >> > >> > >> > Thank you for any feedback and insights. >> > >> > ______________________________________________ >> > R-help@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. >> > > > > > ______________________________________________ > R-help@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 Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? ______________________________________________ R-help@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.