[SOLVED] De-Pivot question

frangonve

Hello,

I'm a newcomer to RapidMiner And I have a question about the de-pivot operator:

This is my input data:

Date/Time	SolMac 10MT3 (121)	SolMac 15MT3 (125)	SolMac 15MT3 (136)
01/07/2013	106.8	103.4	94.3
02/07/2013	119.7	116.5	106.1
03/07/2013	122.6	119.3	108.7

And this is the result that I need:,

Date/Time	Device	Value
01/07/2013	SolMac 10MT3 (121)	106.8
01/07/2013	SolMac 15MT3 (125)	103.4
01/07/2013	SolMac 15MT3 (136)	94.3
02/07/2013	SolMac 10MT3 (121)	119.7
02/07/2013	SolMac 15MT3 (125)	116.5
02/07/2013	SolMac 15MT3 (136)	106.1
03/07/2013	SolMac 10MT3 (121)	122.6
03/07/2013	SolMac 15MT3 (125)	119.3
03/07/2013	SolMac 15MT3 (136)	108.7

How can I setup De-Pivot operator parameters:
attribute name (Edit List)
index atribute
create nominal index
keep missings

to transform data in this way.

Cheers

Francisco

MariusHelf

Hi Francisco,

for index_attribute specify an arbitrary name, e.g. idx - it will contain nothing more than a counter for each date in your case.
Create_nominal_index decides if you want a numerical counter (1, 2, 3) or a nominal counter (idx 1, idx 2, idx 3...)
Attribute name: the left column specifies the name of the attribute in the new data set, in your case that would be "Value". The right hand side specifies a regular expression that defines which attributes are used, in your case that is "SolMac.*".

Hope this helps!

Best regards,
Marius

frangonve

Thanks a lot!

Francisco