thank you all,it worked 

    On Tuesday, November 29, 2016 9:49 PM, "Dalthorp, Daniel" 
<ddalth...@usgs.gov> wrote:
 

 Try David's suggestion to spell the argument "stringsAsFactors" correctly. 
Then:

data <- read.table("your_file_location", sep ="\t", comment.char = "", 
stringsAsFactors = F, header = T)
transpose_data <- t(data)

-Dan
On Tue, Nov 29, 2016 at 9:56 AM, Elham - via R-help <r-help@r-project.org> 
wrote:

yes you have right about excel.by R,what should I do for transposing row and 
column?

    On Tuesday, November 29, 2016 9:13 PM, David Winsemius 
<dwinsem...@comcast.net> wrote:



> On Nov 29, 2016, at 9:22 AM, Elham - via R-help <r-help@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



        [[alternative HTML version deleted]]

______________________________ ________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.



-- 
Dan Dalthorp, PhDUSGS Forest and Rangeland Ecosystem Science Center
Forest Sciences Lab, Rm 189
3200 SW Jefferson Way 
Corvallis, OR 97331 
ph: 541-750-0953
ddalth...@usgs.gov



   
        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.

Reply via email to