Skip to content

A .csv question

4 messages · David Kaplan, Dan Putler, Roy Mendelssohn - NOAA Federal +1 more

#
Hi,

No doubt I'm writing to the wrong R list and some cranky person will 
flame me as a reminder, but I seem to have this problem just on the Mac 
version of R.  Here is the scenario.   I am using SPSS on the PC to save 
a file as a .csv.  I then bring this file into R and have it read the 
file as a .csv.  When I look at the file in Mac Excel, it looks like a 
regular spreadsheet without commas as I might expect.  When I run the 
model, I get the message

Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, 
na.strings,  :
  scan() expected 'a real', got '3196)'


The 3196 is the sample size used for this analysis and it is correct.  I 
can ask it to print the data and the correlation matrix, and everything 
seems fine.  There are no additional characters (such as a parentheses) 
in the file.  My students who are doing this analysis for a class 
assignment do not seem to have a problem on the PC, so I am wondering if 
anyone has encountered an incompatibility problems.

Thanks in advance, and I apologize if this is the wrong list.

David
#
Hi David,

I'll let others flame you on this.

The question I have is why use the intermediate step of converting the
file to *.csv format? The foreign library allows you to read SPSS *.tab
files directly. The plus to doing it directly is that it has a higher
probability of maintaining the correct variable types then does the use
of a pure text format such as CSV.

Dan
On Tue, 2008-04-08 at 13:11 -0500, David Kaplan wrote:
#
A guess, and only a guess, but a csv file at heart is a text file,  
and I would assume it has PC line-enders, which could cause problems.

-Roy M.
On Apr 8, 2008, at 11:11 AM, David Kaplan wrote:
**********************
"The contents of this message do not reflect any position of the U.S.  
Government or NOAA."
**********************
Roy Mendelssohn
Supervisory Operations Research Analyst
NOAA/NMFS
Environmental Research Division	
Southwest Fisheries Science Center
1352 Lighthouse Avenue
Pacific Grove, CA 93950-2097

e-mail: Roy.Mendelssohn at noaa.gov (Note new e-mail address)
voice: (831)-648-9029
fax: (831)-648-8440
www: http://www.pfeg.noaa.gov/

"Old age and treachery will overcome youth and skill."
#
On 4/8/2008 2:11 PM, David Kaplan wrote:
This is the same problem you had on Monday, in the "Error message "got a 
real'" thread.  That's not a .csv file.  Excel recognizes what it is 
despite what you named it, but R is trying to read it as a CSV file, and 
it isn't.

Look at it in a text editor, and you'll see that it's not really a .csv 
file.

Duncan Murdoch