phoebe kong
2008-Nov-11 21:39 UTC
[R] data which has different size of elements in each row
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
Marc Schwartz
2008-Nov-11 22:02 UTC
[R] data which has different size of elements in each row
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