Re: [R] reading text file not table
Sorry just one more question, Patrick Burns wrote: as part of your alternative plan. But I don't think you would need to write a file and read it back in again. Yea So I tried to use the connection but that doesn't work. How can I read the object back in with read.csv, or at very least get it into a matrix seperated by comma? Thanks PB __ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
Is this what you want to do? x - 1,2,3,4 + 5,6,7,8 + 9,0,1,2 + 3,4,5,6 read.csv(textConnection(x), header=FALSE) V1 V2 V3 V4 1 1 2 3 4 2 5 6 7 8 3 9 0 1 2 4 3 4 5 6 On 3/2/07, H. Paul Benton [EMAIL PROTECTED] wrote: Sorry just one more question, Patrick Burns wrote: as part of your alternative plan. But I don't think you would need to write a file and read it back in again. Yea So I tried to use the connection but that doesn't work. How can I read the object back in with read.csv, or at very least get it into a matrix seperated by comma? Thanks PB __ 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, minimal, self-contained, reproducible code. -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve? [[alternative HTML version deleted]] __ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
__ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
Hi, You can read a CSV file using the following way MyData-read.csv(file.choose()) Regards, Pratap [EMAIL PROTECTED] wrote: On 17-Feb-07 H. Paul Benton wrote: Hello all, I'm looking for a way to be able to read a text file into R. It's a csv file but when I do txt -read.table(F00.csv, header=T, sep=,) It doesn't read the file properly, and I only get 2 columns. If I open it up in OOc or Excel it open right with 7 columns. What I would really like to do is read the file as text and then split it and read the bottom section where the 7 columns are. Then I would re-read the table with read.table. Thank you for any help, Paul What's wrong with using read.csv? (Or have I misunderstood your query?) Ted. E-Mail: (Ted Harding) Fax-to-email: +44 (0)870 094 0861 Date: 17-Feb-07 Time: 00:39:37 -- XFMail -- __ 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, minimal, self-contained, reproducible code. - Heres a new way to find what you're looking for - Yahoo! Answers [[alternative HTML version deleted]] __ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
'count.fields' is often useful in such situations to see how R's view of the file differs from your own. (It isn't such a rare occurrence for differences to happen when the file comes from Excel.) If I understand properly, you can use sep='\n' as part of your alternative plan. But I don't think you would need to write a file and read it back in again. Patrick Burns [EMAIL PROTECTED] +44 (0)20 8525 0696 http://www.burns-stat.com (home of S Poetry and A Guide for the Unwilling S User) H. Paul Benton wrote: Hello all, I'm looking for a way to be able to read a text file into R. It's a csv file but when I do txt -read.table(F00.csv, header=T, sep=,) It doesn't read the file properly, and I only get 2 columns. If I open it up in OOc or Excel it open right with 7 columns. What I would really like to do is read the file as text and then split it and read the bottom section where the 7 columns are. Then I would re-read the table with read.table. Thank you for any help, Paul __ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
I think he is missing fill=TRUE, which is the default for read.csv but not read.table. (As Ted Harding implied but as I recall did not spell out.) If you want to read a file as text, used readLines. You can then extract the lines you want and use read.table on a textConnection from just those lines. On Sat, 17 Feb 2007, Patrick Burns wrote: 'count.fields' is often useful in such situations to see how R's view of the file differs from your own. (It isn't such a rare occurrence for differences to happen when the file comes from Excel.) If I understand properly, you can use sep='\n' as part of your alternative plan. But I don't think you would need to write a file and read it back in again. Patrick Burns [EMAIL PROTECTED] +44 (0)20 8525 0696 http://www.burns-stat.com (home of S Poetry and A Guide for the Unwilling S User) H. Paul Benton wrote: Hello all, I'm looking for a way to be able to read a text file into R. It's a csv file but when I do txt -read.table(F00.csv, header=T, sep=,) It doesn't read the file properly, and I only get 2 columns. If I open it up in OOc or Excel it open right with 7 columns. What I would really like to do is read the file as text and then split it and read the bottom section where the 7 columns are. Then I would re-read the table with read.table. Thank you for any help, Paul __ 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, minimal, self-contained, reproducible code. -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ 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, minimal, self-contained, reproducible code.
[R] reading text file not table
Hello all, I'm looking for a way to be able to read a text file into R. It's a csv file but when I do txt -read.table(F00.csv, header=T, sep=,) It doesn't read the file properly, and I only get 2 columns. If I open it up in OOc or Excel it open right with 7 columns. What I would really like to do is read the file as text and then split it and read the bottom section where the 7 columns are. Then I would re-read the table with read.table. Thank you for any help, Paul -- Research Technician Mass Spectrometry o The / o Scripps \ o Research / o Institute __ 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, minimal, self-contained, reproducible code.
Re: [R] reading text file not table
On 17-Feb-07 H. Paul Benton wrote: Hello all, I'm looking for a way to be able to read a text file into R. It's a csv file but when I do txt -read.table(F00.csv, header=T, sep=,) It doesn't read the file properly, and I only get 2 columns. If I open it up in OOc or Excel it open right with 7 columns. What I would really like to do is read the file as text and then split it and read the bottom section where the 7 columns are. Then I would re-read the table with read.table. Thank you for any help, Paul What's wrong with using read.csv? (Or have I misunderstood your query?) Ted. E-Mail: (Ted Harding) [EMAIL PROTECTED] Fax-to-email: +44 (0)870 094 0861 Date: 17-Feb-07 Time: 00:39:37 -- XFMail -- __ 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, minimal, self-contained, reproducible code.