[R] Transforming data for nice output table

Rui Barradas ru|pb@rr@d@@ @end|ng |rom @@po@pt
Tue Aug 21 06:39:03 CEST 2018


Sorry, there is no need to subset the data frame,

reshape2::dcast(dta, etc)

will do the same.

Rui Barradas

On 21/08/2018 05:10, Rui Barradas wrote:
> Hello,
> 
> One of those would be with package reshape2.
> 
> 
> 
> dta <- read.csv( "http://doylesdartden.com/R/ExampleData.csv")
> 
> subdta <- dta[, c("Location", "Year", "GW_Elevation")]
> 
> res <- reshape2::dcast(subdta, Location ~ Year, value.var = "GW_Elevation")
> names(res)[-1] <- paste("GW_Elevation", names(res)[-1], sep = "_")
> head(res)
> 
> 
> Hope this helps,
> 
> Rui Barradas
> 
> On 20/08/2018 21:37, Rui Barradas wrote:
>> 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
>>
>> ______________________________________________
>> 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.
> 
> ______________________________________________
> 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.




More information about the R-help mailing list