Hey everyone,
I am trying to transpose large datasets in excel but it keeps giving me the message we can't paste because copy area and paste area aren't the same size. Is there a way to transpose all the data at one time instead of piece by piece? One dataset has a great amount of rows and columns. Thanks.
2 answers
Excel is not for Bioinformatics.
Use R to transpose the data matrix.
data <- read.table("your_file_location", sep = "\t", comment.char = "", stringAsFactors = F, header = T)
transpose_data <- t(data)
•
written
by
Deepak Tanwar
You can do as:
transpose <- data.frame(t(data))
I am not sure what are you trying to convert (list to dataframe?)
•
written
by
Deepak Tanwar
Can you please paste your code and a snap of your output here?
Excuse me, can I have your email and sent you screenshot? I do not know how I can send it here the output. the R function is:
data <- read.table("coding.csv", sep ="\t", comment.char = "", stringsAsFactors = FALSE, header = TRUE)
transpose_data <- t(data)
Stack Overflow offers a solution that uses GNU awk and should run considerably faster than R (if you plan on doing a lot of transposing).
Also something to keep in mind is that Excel makes Microsoft-y text files. You may need a tool like dos2unix to convert them to something that works better with command-line tools.
•
written
by
Alex Reynolds
Log in to answer this question.
-
Help with complex Volcano Plot
written by jmannhei •
-
Why is DESeq2 normalization making my top feature have identical values across samples?
written by DNAngel
-
Running DESeq2 parallelized with pre-computed dispersions
written by ajay.g.nadig •
-
interpreting heatmap on metascape
written by fionajcunningham •
-
How to convert PLINK outputs into Parquet files?
written by telroyjatter
-
Heatmap with VST Normailzed Data
written by pthom010 •
-
Tutorial: Screen shots of text (please don't)!
written by Michael Dondrup
-
pbalign - SortService returned a non-zero exit status
written by mjp •
-
Make 2 boxplot from a data frame by plotting values in 1 row with different columns per box plot
written by bgraphit •
-
Mummer To Viewable Alignment Format (Fasta Or Aln...)
written by Yannick Wurm
Expect answers which recommend you not use Excel. They are correct :)
But if you must, the correct option is "Paste Special", then check "transpose". It sounds like you are trying to paste into the same area from which you copied, hence the error message. Try pasting to a new area or worksheet.
Thanks for your response. I was told to use excel to first organize all the data then once ready to analyze I would be using software such as R and banjo but I am just using excel to post data on a forum with one of my committee members for a group of our PhD cohort to see.