How to get particulars from date?

pantangi_shekar
pantangi_shekar New Altair Community Member
edited November 2024 in Community Q&A

Hello all,

 

How can I extract details from the date format?

 

For example,

If I have the date as JAN 1 2017

 

I would like to generate 3 attributes like this

month    Date     Year

Jan         1           2017

 

Thanks in advance.

 

Best,

Raj.

Tagged:

Best Answer

  • Edin_Klapic
    Edin_Klapic New Altair Community Member
    Answer ✓

    Hi,

     

    RapidMiner has multiple ways to get your solution.

    I suggest using Generate Attributes but instead of date_get you could use date_str_custom which converts your date to a string.

    I would recommend this solution because it allows you to format the desired output in the way you want (e.g. language / abbreviations [Mon vs. Monday] / ...). This way you are also able to extract the weekday of this day!

    A help on the parameters / variables representing which portion of the date can be found in the Help of the Operator "Nominal to Date".

     

    Best,

    Edin

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    I would convert those to Nominal values first and then use the Split operator. 

  • MartinLiebig
    MartinLiebig
    Altair Employee

    I would go for date_get in GenerateAttributes.

     

    Best,

    Martin

  • Edin_Klapic
    Edin_Klapic New Altair Community Member
    Answer ✓

    Hi,

     

    RapidMiner has multiple ways to get your solution.

    I suggest using Generate Attributes but instead of date_get you could use date_str_custom which converts your date to a string.

    I would recommend this solution because it allows you to format the desired output in the way you want (e.g. language / abbreviations [Mon vs. Monday] / ...). This way you are also able to extract the weekday of this day!

    A help on the parameters / variables representing which portion of the date can be found in the Help of the Operator "Nominal to Date".

     

    Best,

    Edin

  • Telcontar120
    Telcontar120 New Altair Community Member

    Another option would be to use Date to Numerical, which allows you to extract any portion of the date relative to most other portions (e.g., day of the week, day of the month, month of the year, etc.) but the resulting data is numerical rather than nominal in format.  But you could then use Map to convert to whatever nominal values you want.