This is a test version of Biostars. For the public version, visit https://www.biostars.org.
change in the structure and the data types of the data frame after the transposition by R

Hi,

I have a large gene expression dataset in Excel/CSV file, I transposed it by R function (switched columns and rows):

a <- read.table(file.csv,sep="\t")

b <- t(a)

now how to change in the structure and the data types of the data frame after the transposition?

transpose data
• 2,859 views • link
updated by berge2015 berge2015 • written by Edalat • Edalat

What do you mean by change in the structure and the data types? What happens when you transpose and what would you like to change to?

• 0 views • link
written by berge2015 berge2015

I want rows become columns and columns become rows,but the output does not have the frame of table(I mean there is not rows and columns),it is only one long row after transposition.

• 0 views • link
written by Edalat • Edalat

1 answer

If it's a csv file, I think you are importing it wrong.

Try this:

a <- read.csv("file.csv", sep=",", header=T)
b <- as.data.frame(t(a))

a bit of cleanup after the steps above:

names(b) = as.character(unlist(b[1,]))
b = b[-1,]
• 0 views • link
written by berge2015 berge2015

Log in to answer this question.

More posts like this