[SOLVED] De-Pivot question
Contributor II
Hello,
I'm a newcomer to RapidMiner And I have a question about the de-pivot operator:
This is my input data:
And this is the result that I need:,
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
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 |
| 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 |
attribute name (Edit List)
index atribute
create nominal index
keep missings
to transform data in this way.
Cheers
Francisco
Tagged:
0
Answers
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
Francisco