[R] problem with read.table

2007-05-22 Thread Alex Tsoi
Dear all, I try to use read.table to get the data from a tab delimited file, and some of the data is shown below: 3185heterogeneous nuclear ribonucleoprotein F 3187heterogeneous nuclear ribonucleoprotein H1 (H) 3188heterogeneous nuclear ribonucleoprotein H2 (H') 3189

Re: [R] problem with read.table

2007-05-22 Thread Ben Bolker
use quote= to disable the effect of ' cheers Ben Bolker __ R-help@stat.math.ethz.ch 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,

Re: [R] problem with read.table

2007-05-22 Thread Charilaos Skiadas
On May 22, 2007, at 9:41 PM, Alex Tsoi wrote: Dear all, I try to use read.table to get the data from a tab delimited file, and some of the data is shown below: [snip] and it means that whenever read.table reads ' , it skips the next line, until it reads ' again Could

[R] problem with read.table( )

2007-05-10 Thread Alex Tsoi
Hi All, I would like to input a .txt file by using read.table() the file data.txt: NameID IMAGE:131suid=115221 IMAGE:100020851265 IMAGE:100033464770 IMAGE:1000365suid=99969 IMAGE:100050055421 IMAGE:100087564770 IMAGE:1000892399655 IMAGE:1000942suid=112379

Re: [R] problem with read.table( )

2007-05-10 Thread jim holtman
try: data - read.table(data.txt, sep=\t, header = TRUE, as.is=TRUE) On 5/10/07, Alex Tsoi [EMAIL PROTECTED] wrote: Hi All, I would like to input a .txt file by using read.table() the file data.txt: NameID IMAGE:131suid=115221 IMAGE:100020851265 IMAGE:100033464770

[R] problem with read.table

2005-08-25 Thread Krishna
Hi All recently i faced an unknown problem while reading the data. Can someone help me in understanding why this happened. I have .txt file containing X, Y, Z variables. I used the command a - read.table(filename, header=TRUE) after reading the file i am able to view it by tryping a. but i am

Re: [R] problem with read.table

2005-08-25 Thread TEMPL Matthias
Hi All recently i faced an unknown problem while reading the data. Can someone help me in understanding why this happened. I have .txt file containing X, Y, Z variables. I used the command Please show at least 2 lines of your data. a - read.table(filename, header=TRUE) Are you

Re: [R] problem with read.table

2005-08-25 Thread Krishna
Hi Mr. Pedro I tried names(a) and it displayed the names as X, Y and Z. rgds snvk On 8/25/05, Pedro J. Aphalo [EMAIL PROTECTED] wrote: Hi, Did you try names(a) so see what are the names of the columns in the dataframe? Hope this helps a little. Pedro. Krishna wrote: Hi All

Re: [R] problem with read.table

2005-08-25 Thread vincent
Krishna a écrit : unable to access the variables in a, by giving the command a$X. try a$V1 or a[1] or a[,1] or a$V2 etc hih __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide!

Re: [R] problem with read.table

2005-08-25 Thread Don MacQueen
Potential helpers need more information. Type: head(a) and str(a) and post the results. Compare with the output of the same commands on a dataframe that does have this problem. -Don At 5:01 PM +0530 8/25/05, Krishna wrote: Hi Mr. Pedro I tried names(a) and it displayed the

Re: [R] problem with read.table

2005-08-25 Thread Liaw, Andy
Could it be that there are spaces in the names that were read in? a - data.frame( X=1:2, Y=3:4, Z=5:6, check.names=FALSE) a X Y Z 1 1 3 5 2 2 4 6 names(a) [1] X Y Z a$X NULL Andy From: Krishna Hi Mr. Pedro I tried names(a) and it displayed the names as X, Y and Z.

[R] Problem with read.table()

2005-07-21 Thread Kristian Skrede Gleditsch
Dear all, I have encountered a strange problem with read.table(). When I try to read a tab delimited file I get an error message for line 260 not being equal to 14 (see below). Using count.fields() suggests that a number of lines have length not equal to 14, but not 260. Looking at the

Re: [R] Problem with read.table()

2005-07-21 Thread Prof Brian Ripley
On Thu, 21 Jul 2005, Kristian Skrede Gleditsch wrote: Dear all, I have encountered a strange problem with read.table(). Most `strange problems' are user error, so please try not to blame your tools. When I try to read a tab delimited file I get an error message for line 260 not being

Re: [R] Problem with read.table()

2005-07-21 Thread Rolf Turner
X-Essex-MailScanner-SpamCheck: not spam, SpamAssassin (score=-2.82, required 5, autolearn=disabled, ALL_TRUSTED -2.82) X-MailScanner-From: [EMAIL PROTECTED] X-Virus-Scanned: by amavisd-new at stat.math.ethz.ch Subject: [R] Problem with read.table() X-BeenThere: r-help

Re: [R] Problem with read.table()

2005-07-21 Thread Kristian Skrede Gleditsch
Thanks to all who responded to my earlier message. The problem lies in that apostrophes (i.e., ') in some of the text fields are read as quotes. The file can be read without problems setting quotes= in read.table. Incidently, read.delim() also works, even without setting quotes= explicitly.

[R] problem with read.table

2004-07-19 Thread Vincent MUTEAUD
Hello R-users, I apologize for my question but I'm a newbie. I want to read a file which columns separator is \t. At the end of each row there is a \n to go to the following line. The three first lines are remarks lines and the fourth contains columns titles ( variables names, ids, dates,

Re: [R] problem with read.table

2004-07-19 Thread asemeria
You should'nt see the escape character \n on myfile. Try deleting with a text editor \n A.S. Alessandro Semeria Models and Simulations Laboratory Montecatini Environmental Research Center (Edison Group), Via Ciro Menotti 48, 48023 Marina di Ravenna (RA), Italy Tel.

Re: [R] problem with read.table

2004-07-19 Thread Pedro Rodrigues
This is a strange result. I couldn't have a similar result, even with your exact call to read.table. Maybe there is a problem with the file (possibly some white space characters not cleaned). If you send the first 5 lines of your text file I could say something more. On Mon, 2004-07-19 at 09:05,

Re: [R] problem with read.table

2004-07-19 Thread Vincent MUTEAUD
Thanks for your quick answer but I don't see the escape character \n in myFile I see it on the result of my R command. This is an extract of myFile: # Capsis 4.1.3 generated file - Mon Jul 19 10:39:56 CEST 2004 varName weighting id datex y z calculated

Re: [R] problem with read.table

2004-07-19 Thread Pedro Rodrigues
The email has changed the file. Please send attached. On Mon, 2004-07-19 at 09:43, Vincent MUTEAUD wrote: Thanks for your quick answer but I don't see the escape character \n in myFile I see it on the result of my R command. This is an extract of myFile: # Capsis 4.1.3 generated file -

Re: [R] problem with read.table

2004-07-19 Thread Pedro Rodrigues
If your file looks like attached, you should call read.table(temp.txt, header=TRUE, sep=\t, skip=3, quote=) On Mon, 2004-07-19 at 09:43, Vincent MUTEAUD wrote: Thanks for your quick answer but I don't see the escape character \n in myFile I see it on the result of my R command. This is

Re: [R] problem with read.table

2004-07-19 Thread Vincent MUTEAUD
Sorry, I may have suspect that the format will be changed. A 10:00 19/07/2004 +0100, Pedro Rodrigues a écrit : The email has changed the file. Please send attached. On Mon, 2004-07-19 at 09:43, Vincent MUTEAUD wrote: Thanks for your quick answer but I don't see the escape character \n in myFile

Re: [R] problem with read.table

2004-07-19 Thread Vincent MUTEAUD
That's allright, thanks a lot. What is the signification of quote exactly? A 10:08 19/07/2004 +0100, Pedro Rodrigues a écrit : If your file looks like attached, you should call read.table(temp.txt, header=TRUE, sep=\t, skip=3, quote=) On Mon, 2004-07-19 at 09:43, Vincent MUTEAUD wrote: Thanks

Re: [R] problem with read.table

2004-07-19 Thread Pedro Rodrigues
The option quote states the character that encloses strings in your file. for instance if you had a file with Name Height Tree1 100.3 you should call read.table with quote=\. On Mon, 2004-07-19 at 10:25, Vincent MUTEAUD wrote: That's allright, thanks a lot. What is the signification of quote

Re: [R] problem with read.table

2004-07-19 Thread Vincent MUTEAUD
Thank you for your help and the quickness of your answers. A 10:27 19/07/2004 +0100, Pedro Rodrigues a écrit : The option quote states the character that encloses strings in your file. for instance if you had a file with Name Height Tree1 100.3 you should call read.table with quote=\. On Mon,

[R] problem with read.table

2004-02-03 Thread ryszard . czerminski
Any ideas why read.table complains about not correct number of elements in line while readLine/strsplit indicate that all lines have the same number of elements ? R tbl - read.table('tmp', header = T, sep = '\t') Error in scan(file = file, what = what, sep = sep, quote = quote, dec = dec,

Re: [R] problem with read.table

2004-02-03 Thread Douglas Bates
[EMAIL PROTECTED] writes: Any ideas why read.table complains about not correct number of elements in line while readLine/strsplit indicate that all lines have the same number of elements ? R tbl - read.table('tmp', header = T, sep = '\t') Error in scan(file = file, what = what,

Re: [R] problem with read.table

2004-02-03 Thread Prof Brian Ripley
On Tue, 3 Feb 2004 [EMAIL PROTECTED] wrote: Any ideas why read.table complains about not correct number of elements in line while readLine/strsplit indicate that all lines have the same number of elements ? That is what count.fields is for. Setting fill=TRUE in read.table can help

Re: [R] Problem with read.table

2003-03-21 Thread Ben Bolker
Should that be sep=\t ? On Fri, 21 Mar 2003, sabrina servanty wrote: Dear all, I was used to work on R1.6 and I have now passed on R1.6.2 but I can't read my file (and that is a big problem!!). I made a data sheet with some spreadsheet in Excell, and save it as separeted by tab .txt.

RE: [R] Problem with read.table

2003-03-21 Thread Marc Schwartz
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sabrina servanty Sent: Friday, March 21, 2003 1:22 PM To: [EMAIL PROTECTED] Subject: [R] Problem with read.table Dear all, I was used to work on R1.6 and I have now passed on R1.6.2 but I can't read my

Re: [R] Problem with read.table

2003-03-21 Thread Jerome Asselin
How about replacing /t by \t ? Jerome __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help