No, no. It *is* for transposing. But it is *what* you are transposing -- a data frame -- that may lead to the problems. You will have to read what I referred you to and perhaps spend time with an R tutorial or two (there are many good ones on the web) if your R learning is not yet sufficient to understand what they say.
-- Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Tue, Nov 29, 2016 at 11:01 AM, Elham - <[email protected]> wrote: > excuse me I did not understand,you mean this function is not for > transposing? what function do you suggest? > > > On Tuesday, November 29, 2016 10:24 PM, Bert Gunter <[email protected]> > wrote: > > > It is probably worth mentioning that this (i.e. transposing a data > frame) can be a potentially disastrous thing to do in R, though the > explanation is probably more than you want to know at this point (see > ?t and follow the 'as.matrix' link for details). But if you start > getting weird results and error/warning messages when working with > your transposed data, at least you'll know why. > > Cheers, > Bert > > > Bert Gunter > > "The trouble with having an open mind is that people keep coming along > and sticking things into it." > -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) > > > On Tue, Nov 29, 2016 at 10:37 AM, Elham - via R-help > <[email protected]> wrote: >> thank you all,it worked >> >> On Tuesday, November 29, 2016 9:49 PM, "Dalthorp, Daniel" >> <[email protected]> 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 <[email protected]> >> 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 >> <[email protected]> wrote: >> >> >> >>> On Nov 29, 2016, at 9:22 AM, Elham - via R-help <[email protected]> >>> 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]] >> >> ______________________________ ________________ >> [email protected] 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 > >> [email protected] >> >> >> >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> [email protected] 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. > > ______________________________________________ [email protected] 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.
