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.