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

[yanniliu]

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.