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)
?
?
Is there another way (I prefer a way with Excel)?
[[alternative HTML version deleted]]
> 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
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 <dwinsemius at
comcast.net> wrote:
> 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
[[alternative HTML version deleted]]
It's 'stringsAsFactors' = FALSE (without my added quotes) with an 's' at the end of 'strings' . -- 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 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) > > > > > > Is there another way (I prefer a way with Excel)? > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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.
On Tue, 29 Nov 2016 17:22:47 +0000 (UTC) Elham - via R-help <r-help at r-project.org> wrote:> Is there another way (I prefer a way with Excel)?Search on "friends don't let friends use excel for statistics." Spreadsheets are an inherently perilous way to do statistics and Excel specifically is notoriously poor. In fact the reason I originally began using dedicated statistical packages (STATA first and now R) is that spreadsheets (Excel in my case) can throw subtle errors that can create problems. immediately, or even worse - later. I had Excel return a negative variance. Since variance is a squared value, unless you are dealing with some very exotic numbers including imaginary values, a negative variance is an absurd result. Further investigation revealed that other stat routines provided with Excel at the time were also throwing errors that could look reasonable and thus be missed. It was also simply using erroneously constructed methods and providing outright wrong results to things like Chi-square calculations. -- John