The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Pivoting/grouping multiple attributes after time-series feature extraction
Hello,
I extracted features of multiple time series batches (IDx) with multiple signal columns (signalx) using the extract aggregates block on these multiple signals.
I receive data in the form of:
ID1 - "signal1" - feat1 - feat2 - ...
ID1 - "signal2" - feat1 - feat2 - ...
ID2 - "signal1" - feat1 - feat2 - ...
ID2 - "signal2" - feat1 - feat2 - ...
...
How can I perform a pivoting/grouping-like operation (with multiple attributes) that gives me somthing like this:
ID1 - signal1_feat1 - signal1_feat2 - signal2_feat1 - signal2_feat2 - ...
ID2 - signal1_feat1 - signal1_feat2 - signal2_feat1 - signal2_feat2 - ...
...
Thanks for your help!
I extracted features of multiple time series batches (IDx) with multiple signal columns (signalx) using the extract aggregates block on these multiple signals.
I receive data in the form of:
ID1 - "signal1" - feat1 - feat2 - ...
ID1 - "signal2" - feat1 - feat2 - ...
ID2 - "signal1" - feat1 - feat2 - ...
ID2 - "signal2" - feat1 - feat2 - ...
...
How can I perform a pivoting/grouping-like operation (with multiple attributes) that gives me somthing like this:
ID1 - signal1_feat1 - signal1_feat2 - signal2_feat1 - signal2_feat2 - ...
ID2 - signal1_feat1 - signal1_feat2 - signal2_feat1 - signal2_feat2 - ...
...
Thanks for your help!
0
Best Answer
-
MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data ScientistHi,there is a setting in the operator called "add time series name". If you check it you get the format you ask for.Best,Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany1