πŸŽ‰ πŸŽ‰. RAPIDMINER 9.8 IS OUT!!! πŸŽ‰ πŸŽ‰

RapidMiner 9.8 continues to innovate in data science collaboration, connectivity and governance

CLICK HERE TO DOWNLOAD

[SOLVED] De-Pivot question

frangonvefrangonve Member Posts: 5 Contributor II
edited October 2019 in Help
Hello,

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

This is my input data:
Date/TimeSolMac 10MT3 (121)
SolMac 15MT3 (125)
SolMac 15MT3 (136)
01/07/2013
106.8
103.4
94.3
02/07/2013119.7
116.5
106.1
03/07/2013
122.6
119.3
108.7
And this is the result that I need:,
Date/TimeDeviceValue
01/07/2013SolMac 10MT3 (121)106.8
01/07/2013SolMac 15MT3 (125)103.4
01/07/2013SolMac 15MT3 (136)94.3
02/07/2013SolMac 10MT3 (121)119.7
02/07/2013SolMac 15MT3 (125)116.5
02/07/2013SolMac 15MT3 (136)106.1
03/07/2013SolMac 10MT3 (121)122.6
03/07/2013SolMac 15MT3 (125)119.3
03/07/2013SolMac 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

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869   Unicorn
    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
  • frangonvefrangonve Member Posts: 5 Contributor II
    Thanks a lot!

    Francisco
Sign In or Register to comment.