The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.
Options

How to fill in Gaps?

eldenosoeldenoso Member Posts: 65 Contributor I
edited November 2018 in Help

Hello everybody,

The following is a simplified version of my example set:

ID     Name               Costs        Time

1       Example1         1.40          00:30
2       Example2         1,50          01:00

How can I fill in quarterly times. In this case RM should fill in the Time 00:00, 00:15 and replace the missing values (that obviously Missing value operator) with the previous values. And he should fill in the times 01:15, 01:30, 01:45,...,23:45. How can I achieve this? My solution was not as elegant as I just put the values into an excel sheet and joined it with the example set (righter join), so that all examples of the continous times are taken and joined with the table above. BUT if the example set contains more than 1Mio examples this method doesn't work (due to excel limitations). Is there a way to do this just with rapidminer?

Best regards

*Sorry for any mistakes, I am not a native speaker :-)*

Answers

  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    I think I did something like this once using the Series extension but I can't remember what operator did that. Check out the Series Extension, I think there are some operators about interval transformation.

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,525 RM Data Scientist

    Hey,

     

    i guess you first need to create the corresponding examples. Proapbly with an self-append, sort, and round or something. Then you can use Fill Data Gaps from Time Series.

     

    Best,

    Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.