[R] Setting the Number of Columns

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Wed May 29 17:46:50 CEST 2002

"Matt Borkowski" <commnthght at hotmail.com> writes:

> I am trying to read in a data set with 17 columns into a data frame.
> The problem is, there are some lines in the data that occasionally pop
> up with less than 17 numbers in a row.  I was trying to use the command
> data <- read.table("dataset.dat", fill=TRUE, quote = "")
> There was no problem running this with an older version of R and the
> data was forced into a data frame with 17 columns with the missing
> data filled in as NA.  But after updating to the newest version
> something changed and now the data is being forced into a data frame
> with only 14 columns.
> With the newest version of R is it possible to force the data into a
> data frame with user specified dimensions and fill in any missing data
> in a row with NA?

The number of columns are determined from the first five lines in the
file (some older version had a bug that caused the entire file to be
read instead). However, if column names are given, then they are used.
So how about this?:

cn <- paste("V",1:17,sep="")
data <- read.table("dataset.dat", fill=TRUE, quote = "", col.names=cn)

   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list