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

multiple examples

RPattelaRPattela Member Posts: 8 Contributor II
edited November 2018 in Help

Hello

In one attribute i have few document numbers remaing all are nulls. So i am trying to replace null by above document number like below attachment.

 

Please help me out.

Answers

  • dangdang Member Posts: 11 Contributor II

    I have a work around using R, so you can easily integrate into your pipeline with Execute R scripting extension ;)

    use the na.locf() function from the zoo package to carry the last observation forward to replace your NA values.

    ~*~*~*sample R~*~*~*~*

    library(zoo)
    bz <- c(2,NA,NA,1,NA,1,4,5,NA,NA,NA,2)
    na.locf(bz)

    ~*~*~*END R~*~*~*~*

     

     

  • bhupendra_patilbhupendra_patil Employee-RapidMiner, Member Posts: 168 RM Data Scientist

    Another possible option, within Rapidminer

     

    In the time series extension, there is an operator for replacing missing values using various combination like previous value, next value, value(hardcoded) or linear interpolation.

    I tried a simple use case and seems to do what you are looking for 

    Attached is the example data set and the process

     

    You can download the extension from marketplace in your studio or from here

    https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_series

     

    Please note that the "generate copy" is just  for easier comparison if it is doing the right thing, you can ignore it in actual process

Sign In or Register to comment.