[R] read.table with numeric row names

arun smartpink111 at yahoo.com
Fri Jul 13 04:27:45 CEST 2012


Hello,

I saw your reply in nabble.  Sorry about that.  I thought the dataset had only few columns.

#You can read first line of a file using:
readLines("foo.txt",n=1)[1]


#The more generic colname substitution
dat1<-read.table(text=" 
 2.5  3.6  7.1  7.9 
 100  3      4      2    3 
 200  3.1  4      3      3 
 300  2.2  3.3  2    4 
 ",sep="",header=TRUE)  
#The code should remove the "X" from the column names (row names?)

colnames(dat1)<-gsub("^[X](.*)","\\1",colnames(dat1))
dat1
    2.5 3.6 7.1 7.9
100 3.0 4.0   2   3
200 3.1 4.0   3   3
300 2.2 3.3   2   4
plot(colMeans(dat1)~as.numeric(names(dat1)),xlab="Column_Name",ylab="Column_Mean")

A.K.




----- Original Message -----
From: kexinz <zhangchicool at gmail.com>
To: r-help at r-project.org
Cc: 
Sent: Thursday, July 12, 2012 2:50 PM
Subject: [R] read.table with numeric row names

I have a text file like this
         2.5  3.6  7.1  7.9
100   3      4       2     3
200   3.1   4      3      3
300   2.2   3.3   2     4

I used "r <- read.table("a.txt", header=T)"
The row names becomes X2.5, X3.6... What I need is the row names are
numeric, so I can use the row names as numbers on x-axis for plotting. e.g.
"plot(colMeans(r)~names(r))", something like this. How to do this?

Thanks.

--
View this message in context: http://r.789695.n4.nabble.com/read-table-with-numeric-row-names-tp4636342.html
Sent from the R help mailing list archive at Nabble.com.

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




More information about the R-help mailing list