[R] transpose rows and columns for large data

David Winsemius dwinsemius at comcast.net
Tue Nov 29 18:43:08 CET 2016


> On Nov 29, 2016, at 9:22 AM, Elham - via R-help <r-help at r-project.org> wrote:
> 
> Hi,
> 
> I am trying to transpose large datasets inexcel (44 columns and 57774 rows) but it keeps giving me the message we can'tpaste because copy area and paste area aren't the same size. Is there a way totranspose all the data at one time instead of piece by piece? One dataset has agreat amount of rows and columns. 
> 
> I tried this R function to transpose the datamatrix:
> 
> data <- read.table("your_file_location", sep ="\t", comment.char = "", stringAsFactors = F, header = T)
> 
> 
>  
> transpose_data <- t(data)
> 
> But I received tis error:
> 
> unused argument (stringAsFactors = F)
> 

You misspelled that argument's name. And do learn to use FALSE and TRUE.

>  
> Is there another way (I prefer a way with Excel)?

This is not a help list for Excel.


-- 

David Winsemius
Alameda, CA, USA



More information about the R-help mailing list