[R] data which has different size of elements in each row
marc_schwartz at comcast.net
Tue Nov 11 23:02:16 CET 2008
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,
> 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.
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
More information about the R-help