On Aug 15, 2012, at 22:11 , John Kane wrote: > I cannot duplicate this using LibreOffice Calc. It saves exactly as one > would expect. >
I can duplicate it with Excel on OSX. Each line of the CSV file ends with a comma! Corresponding thing happens if you save as .txt (TAB-delimited) and read with read.delim(). However, select all followed by read.delim from the clipboard works fine. Go figure... You can skip the empty column using read.csv("~/Downloads/cyu01_iqscores.csv",colClasses=list("numeric",NULL)) but deleting the extra column is just as expedient. > 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. -- Peter Dalgaard, Professor, Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Email: pd....@cbs.dk Priv: pda...@gmail.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.