RapidMiner 9.8 Beta is now available

Be one of the first to get your hands on the new features. More details and downloads here:

GET RAPIDMINER 9.8 BETA

How to compare Date-Data? [SOLVED]

KolodziejKolodziej Member Posts: 18 Contributor II
edited November 2018 in Help
Hello,
i have a problem and i hope you can help me.

I have a csv.data with some date fields. I need to compare these fields and to point out how often they match.

Regards Martin!!!

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869   Unicorn
    Hi Martin,

    you can create a new attribute with Generate Attribute with something like "date_attr1 = date_attr2". Filter on that new attribute with Filter Examples, then count the examples.
    If you have any further questions or problems implementing the process described above, please post again.

    Best,
    Marius
  • KolodziejKolodziej Member Posts: 18 Contributor II
    Thanks for the quick responce!

    I have to show how much percent of all date fields are match. is there an operator to calculate this?
  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869   Unicorn
    Yes, try the Aggregate operator. Not sure, however, if the count(fraction) method is already part of the public release. If it is in the list of aggregation functions, use it. Otherwise, you have to be creative with Aggregate (normal count function), Extract Macro (number of examples) and Generate Attributes (divide count for matching/non-matching by the number of examples).

    Happy Mining!
    ~Marius
Sign In or Register to comment.