I can get R to calculate the distance that I want between my data points. However, I am stuck trying to get R to output the data so I can paste it into Excel. Instead, R outputs a matrix mess in the console. Below are the steps I am taking to calculate the distance between my data. Also, I have 42 different data points. # Calculate the Euclidean distance between each datapoint using # the function dist() PRdist = dist(my_data) ; PRdist I would greatly appreciate if someone can tell me how to output my matrix from the dist function into something I can paste into Excel. Mike [[alternative HTML version deleted]]
Hi Michael, Googling "export R data to Excel" gives LOTS of advice, including packages that can write your data directly to Excel spreadsheets. I don't use Excel, so I haven't tried any of those, but using write.csv() to export your data will create something that my colleagues who use Excel have no trouble opening. Printing to the console, as you did by typing the object name, is not intended to be an export method. Sarah On Wed, Mar 2, 2016 at 3:31 PM, Michael <elopomorph at hotmail.com> wrote:> I can get R to calculate the distance that I want between my data points. However, I am stuck trying to get R to output the data so I can paste it into Excel. Instead, R outputs a matrix mess in the console. > > Below are the steps I am taking to calculate the distance between my data. Also, I have 42 different data points. > > # Calculate the Euclidean distance between each datapoint using > # the function dist() > > PRdist = dist(my_data) ; PRdist > > I would greatly appreciate if someone can tell me how to output my matrix from the dist function into something I can paste into Excel. > > Mike > >--
Hi Michael,
If you are working in Windows:
# You can put the matrix directly into the clipboard
write.table(PRdist, file = 'clipboard', sep = '\t', row.names =
F,
col.names = F)
The "sep" argument tells what character to use for separating columns.
Default for Excel is tab (i.e. '\t')
Default for write.table on a matrix or 2-d array is to write column names
(as "V1", "V2", etc.) and row names ("1",
"2", etc.). If you don't want
those added to your matrix, tell R via row.names = FALSE, col.names = FALSE
-Dan
On Wed, Mar 2, 2016 at 12:31 PM, Michael <elopomorph at hotmail.com>
wrote:
> I can get R to calculate the distance that I want between my data points.
> However, I am stuck trying to get R to output the data so I can paste it
> into Excel. Instead, R outputs a matrix mess in the console.
>
> Below are the steps I am taking to calculate the distance between my
> data. Also, I have 42 different data points.
>
> # Calculate the Euclidean distance between each datapoint using
> # the function dist()
>
> PRdist = dist(my_data) ; PRdist
>
> I would greatly appreciate if someone can tell me how to output my matrix
> from the dist function into something I can paste into Excel.
>
> Mike
>
>
>
>
> [[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]]
Sorry, I was assuming your data was a matrix (as you indicated in your question). Try: write.table(as.matrix(PRdist), file = 'clipboard', sep = '\t', row.names F, col.names = F) -Dan On Wed, Mar 2, 2016 at 1:01 PM, Michael <elopomorph at hotmail.com> wrote:> I got an error message. > > > > write.table(PRdist, file = 'clipboard', sep = '\t', row.names = F, > col.names = F) > Error in as.data.frame.default(x[[i]], optional = TRUE) : > cannot coerce class ""dist"" to a data.frame > > I think because my PRdist is a value, not a data frame. However, I am not > sure. Any advice? > > > Thanks for your help. > > > Mike > > > ------------------------------ > *From:* Dalthorp, Daniel <ddalthorp at usgs.gov> > *Sent:* Wednesday, March 2, 2016 3:50 PM > *To:* Michael > *Cc:* r-help at r-project.org > *Subject:* Re: [R] output my results into Excel > > Hi Michael, > If you are working in Windows: > > # You can put the matrix directly into the clipboard > write.table(PRdist, file = 'clipboard', sep = '\t', row.names = F, > col.names = F) > > The "sep" argument tells what character to use for separating columns. > Default for Excel is tab (i.e. '\t') > > Default for write.table on a matrix or 2-d array is to write column names > (as "V1", "V2", etc.) and row names ("1", "2", etc.). If you don't want > those added to your matrix, tell R via row.names = FALSE, col.names = FALSE > > > > -Dan > > On Wed, Mar 2, 2016 at 12:31 PM, Michael <elopomorph at hotmail.com> wrote: > >> I can get R to calculate the distance that I want between my data >> points. However, I am stuck trying to get R to output the data so I can >> paste it into Excel. Instead, R outputs a matrix mess in the console. >> >> Below are the steps I am taking to calculate the distance between my >> data. Also, I have 42 different data points. >> >> # Calculate the Euclidean distance between each datapoint using >> # the function dist() >> >> PRdist = dist(my_data) ; PRdist >> >> I would greatly appreciate if someone can tell me how to output my matrix >> from the dist function into something I can paste into Excel. >> >> Mike >> >> >> >> >> [[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 > >-- 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]]