[R] Reorganize the data (dplyr or other packages?)

[Rasmus Liland]

Dear John,

Op ma 17 aug. 2020 om 09:52 schreef Eric Berger:
| On Mon, Aug 17, 2020 at 10:49 AM Thierry Onkelinx wrote:
| |
| | You are looking for tidyr::pivot_longer()
|
| Alternatively, melt() from the reshape2 package.
|
| library(reshape2)
| melt(x,id.vars="date",measure.vars=c("down","uc","up"),variable.name
| ="direction",value.name="percentage")

Also, stack is also possible to use:

	tab <- structure(list(
	date = c("2019M08", "2019M09", "2019M10"),
	down = c(0.01709827, 0.02094724, 0.01750911),
	uc = c(0.2653882, 0.2265797, 0.245003),
	up = c(0.7175136, 0.7524731, 0.7374879)),
	class = "data.frame", row.names = c(NA, -3L))
	
	out <- utils::stack(x=tab, select=-date)
	colnames(out) <- c("percentage", "direction")
	out$date <- tab$date
	out <- out[,sort(colnames(out))]
	
	out

yields

	     date direction percentage
	1 2019M08      down 0.01709827
	2 2019M09      down 0.02094724
	3 2019M10      down 0.01750911
	4 2019M08        uc 0.26538820
	5 2019M09        uc 0.22657970
	6 2019M10        uc 0.24500300
	7 2019M08        up 0.71751360
	8 2019M09        up 0.75247310
	9 2019M10        up 0.73748790

On 2020-08-17 07:46 -0500, Hadley Wickham wrote:
| On Mon, Aug 17, 2020 at 11:23 AM Thierry Onkelinx wrote:
| |
| | reshape2 is a retired package. The 
| | author recommends to use his new 
| | package tidyr.
| 
| We previously used the term retired to 
| suggest that the package is taking it 
| easy and relaxing, but isn't dead. 

Haha :)

| This causes a lot of confusion so we 
| now call this state "superseded" — 
| we'll continue to keep reshape2 (and 
| reshape!) on CRAN

Good!

| but they won't receive any new 
| features, and we believe that there 
| are now better approaches to solving 
| the same problem.

Is tidyr::pivot_longer this better 
solution?  It is an easier to understand 
version of the now retired and confusing 
(for me) tidyr::gather which at least 
reigned back in 2018 (was that any good 
compared to reshape?).

Best,
Rasmus

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20200817/5cd7435c/attachment.sig>