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 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.