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

How can we implement dropna() in the rapidminer?

Anusha
Anusha Member Posts: 19 image Maven
in Help
Hi All!

I have a dataset that has NAs, N/A, null, NULL, and multiple spaces in different cells. I just want to remove those particular rows.
Can anyone guide me.

Source Data:

C1                  C2                      C3                C4

12                ADNF                   NCJK               NA
34                HDDW                  CNJ                        -(single space ) 
38               CNJKD                  JIC                  N/A
78                NJDS                    NCSW            NULL
90                 CJNEK                 C JDSK          12NJDNC
08             DNCJS                      CSKJ               null
13                           -(tab space)  bdjf                ndf097

Desired Data:

C1                  C2                    C3                 C4

90                 CJNEK               C JDSK          12NJDNC

Thanks in Advance!

Best Answer

  • ceaperez
    ceaperez Member Posts: 541 image Unicorn
    Solution Accepted
    Hi @Anusha, 

    Into the Select Attributes operator you have many alternatives to carry out the filtration of your dataset, for example remove the missing values, or work with regular expressions. 

    Best

Answers

  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    Hi,
    First you use declare missing values to make it a missing, then you can use filter examples with 'is not missing' to remove it.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Categories