[R] read.table or read.csv without row index?

[jim holtman]

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?