Dear all, I have a question about how to get a matrix by combining a large number of columns from a data file. Suppose I read a file which have 1000 columns by: test = read.table("dat.txt", header=F) I know I could use "cbind()". It's easy to do when the number of columns is small (i.e. cbind(test$V1, test$V2)). But how about build a matrix "X" by combine the first 500 columns. Is there an easy way to write the expression? Thanks so much! Jeny
First 4 colums of builtin data frame anscombe as a matrix: as.matrix(anscombe[1:4]) On 8/19/06, jz7 at duke.edu <jz7 at duke.edu> wrote:> Dear all, > > I have a question about how to get a matrix by combining a large number of > columns from a data file. Suppose I read a file which have 1000 columns > by: > > test = read.table("dat.txt", header=F) > > I know I could use "cbind()". It's easy to do when the number of columns > is small (i.e. cbind(test$V1, test$V2)). But how about build a matrix "X" > by combine the first 500 columns. Is there an easy way to write the > expression? > > Thanks so much! > > Jeny > > ______________________________________________ > R-help at stat.math.ethz.ch 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. >
On Sat, 19 Aug 2006, jz7 at duke.edu wrote:> Dear all, > > I have a question about how to get a matrix by combining a large number of > columns from a data file. Suppose I read a file which have 1000 columns > by: > > test = read.table("dat.txt", header=F) > > I know I could use "cbind()". It's easy to do when the number of columns > is small (i.e. cbind(test$V1, test$V2)). But how about build a matrix "X" > by combine the first 500 columns. Is there an easy way to write the > expression?as.matrix(test[1:500]) Or read the data as a matrix in the first place, using scan (as recommended on the help page for read.table *and* the relevant manual). -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595