I cannot duplicate this using LibreOffice Calc. It saves exactly as one would expect.
John Kane Kingston ON Canada > -----Original Message----- > From: dwarnol...@suddenlink.net > Sent: Wed, 15 Aug 2012 10:27:54 -0700 (PDT) > To: r-help@r-project.org > Subject: [R] Reading one column .csv file > > My friend sent an Excel file: > > http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls > http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls > > I opened it in Excel, saved is as cyu01_iqscores.csv, then imported it > into > R with: > > iqscores=read.csv('cyu01_iqscores.csv',header=TRUE) > > The result was: > >> head(iqscores) > IQ.Scores X > 1 145 NA > 2 101 NA > 3 123 NA > 4 106 NA > 5 117 NA > 6 102 NA > > Now, I know I can cure this with: > > iqscores=iqscores[,1] > > But I am wondering about this weird behavior. > > Suggestions? > > David > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Reading-one-column-csv-file-tp4640396.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. ____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop! ______________________________________________ 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.
