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

[Thierry Onkelinx]

You are looking for tidyr::pivot_longer()

Best regards,

ir. Thierry Onkelinx
Statisticus / Statistician

Vlaamse Overheid / Government of Flanders
INSTITUUT VOOR NATUUR- EN BOSONDERZOEK / RESEARCH INSTITUTE FOR NATURE AND
FOREST
Team Biometrie & Kwaliteitszorg / Team Biometrics & Quality Assurance
thierry.onkelinx using inbo.be
Havenlaan 88 bus 73, 1000 Brussel
www.inbo.be

///////////////////////////////////////////////////////////////////////////////////////////
To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to say
what the experiment died of. ~ Sir Ronald Aylmer Fisher
The plural of anecdote is not data. ~ Roger Brinner
The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of data.
~ John Tukey
///////////////////////////////////////////////////////////////////////////////////////////

<https://www.inbo.be>


Op ma 17 aug. 2020 om 09:35 schreef John <miaojpm using gmail.com>:

> Is there any quick way (dplyr?) to arrange the data
>  date          down       uc       up
> 2019M08   0.01709827 0.2653882 0.7175136
> 2019M09   0.02094724 0.2265797 0.7524731
> 2019M10   0.01750911 0.2450030 0.7374879
>
> to
>  date          direction  percentage
> 2019M08   down 0.01709827
> 2019M09   down 0.02094724
> 2019M10   down 0.01750911
> 2019M08   uc 0.2653882
> 2019M09   uc 0.2265797
> 2019M10   uc 0.2450030
> 2019M08   up  0.7175136
> 2019M09   up 0.7524731
> 2019M10   up 0.7374879
>
>         [[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.
>

	[[alternative HTML version deleted]]