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.
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!
There is nothing weird about it if you look at the structure of the CSV file: IQ Scores, 145, 101, 123, 106, 117, 102, 139, 142, 94, Notice that there is an extra comma that EXCEL is inserting and therefore when you are reading it in to R, it assumes there is an unnamed column that it calls "X":> x <- read.csv('clipboard') > str(x)'data.frame': 60 obs. of 2 variables: $ IQ.Scores: int 145 101 123 106 117 102 139 142 94 124 ... $ X : logi NA NA NA NA NA NA ... So file a bug report with Microsoft on the way Excel writes CSV files; R is interpreting them correctly. On Wed, Aug 15, 2012 at 1:27 PM, darnold <dwarnold45 at suddenlink.net> wrote:> 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.-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.
On the Mac try pipe("pbpaste") instead of "clipboard."
----------------------------------------------
David L Carlson
Associate Professor of Anthropology
Texas A&M University
College Station, TX 77843-4352
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of darnold
> Sent: Wednesday, August 15, 2012 4:11 PM
> To: r-help at r-project.org
> Subject: Re: [R] Reading one column .csv file
>
> Peter,
>
> Interesting. Never heard of copying from the clipboard. I am also on a
> MacBook Pro, but I cannot get it to work.
>
> 1. I selected the column of data (including the header) in Excel.
>
> 2. Selected Edit->Copy.
>
> 3. In R, tried:
>
> > a <- read.delim("clipboard")
> Error in file(file, "rt") : cannot open the connection
> In addition: Warning message:
> In file(file, "rt") : clipboard cannot be opened or contains no
text
>
> 4. I checked the clipboard. The data is there.
>
> What am I missing?
>
> D.
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Reading-
> one-column-csv-file-tp4640396p4640429.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.
On 15-08-2012, at 23:11, darnold wrote:> Peter, > > Interesting. Never heard of copying from the clipboard. I am also on a > MacBook Pro, but I cannot get it to work. >So you are running Mac OS X?> 1. I selected the column of data (including the header) in Excel. > > 2. Selected Edit->Copy. > > 3. In R, tried: > >> a <- read.delim("clipboard") > Error in file(file, "rt") : cannot open the connection > In addition: Warning message: > In file(file, "rt") : clipboard cannot be opened or contains no text > > 4. I checked the clipboard. The data is there.See ? connections Section "Clipboard" a <- read.delim(pipe("pbpaste")) Berend