[R] Transforming data for nice output table

[Rui Barradas]

Hello,

This is a very frequent question.
I could rewrite one or two answers taken from StackOverflow:

https://stackoverflow.com/questions/5890584/how-to-reshape-data-from-long-to-wide-format


But there you will have more options.


Hope this helps,

Rui Barradas

On 20/08/2018 20:17, David Doyle wrote:
> Hello everyone,
> 
> I'm trying to generate tables of my data out of R for my report.
> 
> My data is setup in the format as follows and the example can be found at:
> http://doylesdartden.com/R/ExampleData.csv
> 
> Location        Date        Year      GW_Elevation
> 127(I)        5/14/2006     2006       752.46
> 119(I)        5/14/2006     2006       774.67
> 127(I)        6/11/2007     2007       752.06
> 119(I)        6/11/2007     2007       775.57
> 
> I would like to generate a table that showed
> 
> Location    GW_Elevation 2006    GW_Elevation 2007    GW_Elevation xxx.....
> 
> 119(I)                    774.67                      775.57
>            xxxx
> 127(I)                    752.46                      752.06
>            xxxx
> XXXX                          XX                           XX
> 
>   Any thoughts on how to transform the data so it would be in this format??
> 
> Thank you for your time
> 
> David Doyle
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using 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.
> 

---
This email has been checked for viruses by AVG.
https://www.avg.com