[R] Reading one column .csv file

John Kane jrkrideau at inbox.com
Wed Aug 15 22:11:12 CEST 2012


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!



More information about the R-help mailing list