read.table or read.csv without row index?
You need to convert to a matrix and remove names:
x <- read.table(textConnection("M1 M2 M3 M4 M5 M6 M7 M8 M9 M10
+ 1 9 11 14 15 18 20 20 20 20 20 + 2 3 4 8 9 11 12 14 15 15 15 + 3 4 5 8 8 9 9 9 9 9 9 + 4 4 5 7 8 8 8 8 8 8 9"), header=TRUE)
closeAllConnections() y <- as.matrix(x) x
M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 1 9 11 14 15 18 20 20 20 20 20 2 3 4 8 9 11 12 14 15 15 15 3 4 5 8 8 9 9 9 9 9 9 4 4 5 7 8 8 8 8 8 8 9
y
M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 1 9 11 14 15 18 20 20 20 20 20 2 3 4 8 9 11 12 14 15 15 15 3 4 5 8 8 9 9 9 9 9 9 4 4 5 7 8 8 8 8 8 8 9
dimnames(y) <- NULL y
[,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [1,] 9 11 14 15 18 20 20 20 20 20 [2,] 3 4 8 9 11 12 14 15 15 15 [3,] 4 5 8 8 9 9 9 9 9 9 [4,] 4 5 7 8 8 8 8 8 8 9
On Wed, Apr 22, 2009 at 10:00 AM, tsunhin wong <thjwong at gmail.com> wrote:
Hello all, Probably my concepts about the data.frame and matrix and array in R are not clear, I need some clarification to help me understand them better.
M <- read.table("test1.csv",sep=",",row.names=NULL,header=T)
gives me: M as ?M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 1 ?9 11 14 15 18 20 20 20 20 ?20 2 ?3 ?4 ?8 ?9 11 12 14 15 15 ?15 3 ?4 ?5 ?8 ?8 ?9 ?9 ?9 ?9 ?9 ? 9 4 ?4 ?5 ?7 ?8 ?8 ?8 ?8 ?8 ?8 ? 9 1. How can I read the csv file to: ?M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 [1,] ?9 11 14 15 18 20 20 20 20 ?20 [2,] ?3 ?4 ?8 ?9 11 12 14 15 15 ?15 [3,] ?4 ?5 ?8 ?8 ?9 ?9 ?9 ?9 ?9 ? 9 [4,] ?4 ?5 ?7 ?8 ?8 ?8 ?8 ?8 ?8 ? 9 2. or how can convert the above M to a format with [1,],[2,] etc instead of 1,2,etc? 3. How can I read a text file so that I can get: ?[,1] [,2] [,3] [,4] [,5] [1,] ?9 11 14 15 18 [2,] ?3 ?4 ?8 ?9 11 [3,] ?4 ?5 ?8 ?8 ?9 [4,] ?4 ?5 ?7 ?8 ?8 (instead of having the columns names V1 to V5?) Thank you for your help! Regards, ? ? ?John
______________________________________________ R-help at 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.
Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?