Grouping series

DocMusher

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

MartinLiebig

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.