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]]
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 at
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 <
> 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]]
>
> ______________________________________________
> 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.
--
Dan Dalthorp, PhD
USGS Forest and Rangeland Ecosystem Science Center
Forest Sciences Lab, Rm 189
3200 SW Jefferson Way
Corvallis, OR 97331
ph: 541-750-0953
ddalthorp at usgs.gov
[[alternative HTML version deleted]]
thank you all,it worked
On Tuesday, November 29, 2016 9:49 PM, "Dalthorp, Daniel"
<ddalthorp at 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 at
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 <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]]
______________________________ ________________
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.
--
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
ddalthorp at usgs.gov
[[alternative HTML version deleted]]