Re: [R] Reading one column .csv file

2012-08-15 Thread darnold
Worked! Thanks. David. -- View this message in context: http://r.789695.n4.nabble.com/Reading-one-column-csv-file-tp4640396p4640462.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz

Re: [R] Reading one column .csv file

2012-08-15 Thread Berend Hasselman
On 16-08-2012, at 06:06, darnold wrote: > Tried that already. > > My clipboard: > > x > 2 > 3 > 4 > 5 > > My attempt: > >> a <- read.delim(pipe("pbpaste")) > Warning message: > In read.table(file = file, header = header, sep = sep, quote = quote, : > incomplete final line found by readTabl

Re: [R] Reading one column .csv file

2012-08-15 Thread darnold
Tried that already. My clipboard: x 2 3 4 5 My attempt: > a <- read.delim(pipe("pbpaste")) Warning message: In read.table(file = file, header = header, sep = sep, quote = quote, : incomplete final line found by readTableHeader on 'pbpaste' And again: > a <- read.delim(pipe("pbpaste"),head

Re: [R] Reading one column .csv file

2012-08-15 Thread Berend Hasselman
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->Co

Re: [R] Reading one column .csv file

2012-08-15 Thread David L Carlson
ect.org [mailto:r-help-bounces@r- > project.org] On Behalf Of darnold > Sent: Wednesday, August 15, 2012 4:11 PM > To: r-help@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

Re: [R] Reading one column .csv file

2012-08-15 Thread darnold
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 o

Re: [R] Reading one column .csv file

2012-08-15 Thread peter dalgaard
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 rea

Re: [R] Reading one column .csv file

2012-08-15 Thread jim holtman
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":

Re: [R] Reading one column .csv file

2012-08-15 Thread John Kane
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