Grouping series

DocMusherDocMusher Member Posts: 333 Unicorn
edited June 2019 in Help
Hi,
dataset of X samples, each sample has features named YYYY_S1, ZZZZ_S1, YYYY_S2 and ZZZZ_S2
YYYY, ZZZZ is the feature-name, S1 and S2 are moments the feature was recorded moment 1 is S1
What is the best way to have both feature-name (YYYY, ZZZZ)  as the moment of recording (S1, S2) available for grouping?
Sven

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,231 RM Data Scientist
    So you have something like this

    x_t1 x_t2 y_t1 y_t2
    1 2 1 2
    and would like to transform this to this:

    t x y
    1 1 1
    2 2 2
    ?

    Sounds a bit like either De-Pivot or Transpose.
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.