Re: [R] data which has different size of elements in each row

From: yanniliu <yanniliu_at_cmu.edu>
Date: Wed, 12 Nov 2008 07:49:13 -0800 (PST)

I have the same problem. If the first row has more columns than later rows, the fill=TRUE works; however when the first row has LESS columns than later rows, R won't read in more columns than the length of the first row. Anyone has solutions?

Yanni

Marc Schwartz wrote:
>
> on 11/11/2008 03:39 PM phoebe kong wrote:

>> Hi all,
>> 
>> I have problem reading in a text file as follow.
>> 
>> The following data has not column header. I tried the following
>> command but failed,
>> 
>> temp<-read.table("data.txt",header=F)
>> 
>> An error message stated that line 3 did not have 4 elements.
>> 
>> 0.293290E-05       0.117772E-05     -0.645205     rs2282755
>>  0.307521E-05           0.000314      0.412997     rs1336838
>>  0.484017E-05           0.218311      0.188669     rs2660664        
>> rs967785
>>  0.977861E-05           0.070474      0.294653     rs2660664
>>  0.122767E-04       0.156325E-04      0.569826     rs6870519
>>  0.227205E-04           0.000189     -0.472862     rs10488345
>> 
>> Does anyone know how to solve it?
>> 
>> Thanks in advance for your help.
>> 
>> Sit
>> 

>
> See the 'fill' argument in ?read.table
>
>> read.table("clipboard", header = FALSE, fill = TRUE)

> V1 V2 V3 V4 V5
> 1 2.93290e-06 1.17772e-06 -0.645205 rs2282755
> 2 3.07521e-06 3.14000e-04 0.412997 rs1336838
> 3 4.84017e-06 2.18311e-01 0.188669 rs2660664 rs967785
> 4 9.77861e-06 7.04740e-02 0.294653 rs2660664
> 5 1.22767e-05 1.56325e-05 0.569826 rs6870519
> 6 2.27205e-05 1.89000e-04 -0.472862 rs10488345
>
>
> HTH,
>
> Marc Schwartz
>
> ______________________________________________
> R-help_at_r-project.org 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.
>
>
-- 
View this message in context: http://www.nabble.com/data-which-has-different-size-of-elements-in-each-row-tp20449102p20463006.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_r-project.org 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.
Received on Wed 12 Nov 2008 - 17:40:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 12 Nov 2008 - 18:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive