Reading one column .csv file
I cannot duplicate this using LibreOffice Calc. It saves exactly as one would expect. John Kane Kingston ON Canada
-----Original Message----- From: dwarnold45 at suddenlink.net Sent: Wed, 15 Aug 2012 10:27:54 -0700 (PDT) To: r-help at 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 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.
____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!