Thanks. It works very good.
Chi
On Thu, Jul 12, 2012 at 7:27 PM, arun <[email protected]> wrote:
> 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 <[email protected]>
> To: [email protected]
> 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.
>
>
>
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
