How to compare Date-Data? [SOLVED]

Kolodziej
Kolodziej New Altair Community Member
edited November 5 in Community Q&A
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!!!
Tagged:

Answers

  • MariusHelf
    MariusHelf New Altair Community Member
    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
  • Kolodziej
    Kolodziej New Altair Community Member
    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?
  • MariusHelf
    MariusHelf New Altair Community Member
    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

Categories