>x <- read.csv("transpose.csv",header=T,sep=",",dec=".");
>x <- t(x)

However, if you want to transpose the matrix as well as revise some elements, the above code can not do that. Following R code can read in a file into matrix, transpose it and then write to an output file. It do that by reading through each element, such that you may revise the elements as you like, e.g. substring or do some calculation during the process.


filematrix <- function(ver,outfile) { verC <- ncol(ver) verR <- nrow(ver) writ <- file(outfile,"w") for (i in 1:verR) { str="" for (j in 1:verC) { str=paste(str,ver[i,j],sep=",") } str = gsub("^,","",str); writeLines(str,con=writ,sep="\n") } close(writ) } matrx <- read.csv("transpose.csv", header=F, dec=".",sep=",") filematrix(t(matrx),"out_transpose.csv")

The result file is:

,line-1,line-2,line-3,line-4,line-5,line-6,line-7 header1,27,38,18,13,11,12,15 header2,0.38,0.38,0.38,0.38,0.38,0.38,0.38 header3,33,20,15,15,15,14,14 header4,54,35,27,26,25,25,25 header5,60,17,24,28,29,27,24

Download the csv file and the R source code:
Data File
R Source Code File
Output Data File