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@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@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.