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

[Marc Schwartz]

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