Hello R-User
I have a table as tab-delimited textfile (291 rows, 83 columns).
The first row are labels and the first line the variable names.
I used the following code several times with different similar tables and it
always worked.
But now:
setClass("of")
setAs("character", "of", function(from) as.ordered(from))
Classe82<-cclasses <- c(rep("factor", 63),
rep("numeric",7), rep ("of",
12))
Table<-read.table("Table.txt",header=TRUE,row.names=1,
na.strings="NA"
,colClasses = Classe82)
I get this error-message:
Fehler in scan(file, what, nmax, sep, dec, quote, skip, nlines,
na.strings, :
scan() erwartete 'a real', bekam '8,5'
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings,
:
scan() expected 'a real', got '8,5'
It seems that the error is in the colClasses-argument. Without this argument
it reads the table.
I checked allready if there are empty cells or blanks in the header but
could not find.
Maybe that its just a simple thing and I know that I can change the classes
after reading in the table, but I really would like to know how to do this
right.
I would be very glad if somebody has an idea, or could tell me, how I could
find out, what`s going wrong.
Many thanks in advance
B.
-----
The art of living is more like wrestling than dancing.
(Marcus Aurelius)
--
View this message in context:
http://www.nabble.com/problem-with-read.table%28%29-tp18729348p18729348.html
Sent from the R help mailing list archive at Nabble.com.
> Table<-read.table("Table.txt",header=TRUE,row.names=1, na.strings="NA" > ,colClasses = Classe82) > > > Fehler in scan(file, what, nmax, sep, dec, quote, skip, nlines, > na.strings, : > scan() erwartete 'a real', bekam '8,5' > > Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, > : > scan() expected 'a real', got '8,5'It looks like your tab separated file uses ',' as a decimal point (german convention) while read.table expects '.'. Try giving the dec="," option to read.table. cu Philipp -- Dr. Philipp Pagel Lehrstuhl f?r Genomorientierte Bioinformatik Technische Universit?t M?nchen Wissenschaftszentrum Weihenstephan 85350 Freising, Germany http://mips.gsf.de/staff/pagel
I am sorry I just found the stupid mistake. I did not specify dec="," because I usually use . Anyway thanks for having the opportunity to get help in this list. B. Birgitle wrote:> > Hello R-User > > I have a table as tab-delimited textfile (291 rows, 83 columns). > The first row are labels and the first line the variable names. > > I used the following code several times with different similar tables and > it always worked. > But now: > > setClass("of") > setAs("character", "of", function(from) as.ordered(from)) > > Classe82<-cclasses <- c(rep("factor", 63), rep("numeric",7), rep ("of", > 12)) > Table<-read.table("Table.txt",header=TRUE,row.names=1, na.strings="NA" > ,colClasses = Classe82) > > I get this error-message: > > Fehler in scan(file, what, nmax, sep, dec, quote, skip, nlines, > na.strings, : > scan() erwartete 'a real', bekam '8,5' > > Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, > na.strings, : > scan() expected 'a real', got '8,5' > > It seems that the error is in the colClasses-argument. Without this > argument it reads the table. > I checked allready if there are empty cells or blanks in the header but > could not find. > Maybe that its just a simple thing and I know that I can change the > classes after reading in the table, but I really would like to know how to > do this right. > > I would be very glad if somebody has an idea, or could tell me, how I > could find out, what`s going wrong. > > Many thanks in advance > > B. >----- The art of living is more like wrestling than dancing. (Marcus Aurelius) -- View this message in context: http://www.nabble.com/problem-with-read.table%28%29-tp18729348p18729917.html Sent from the R help mailing list archive at Nabble.com.