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

Clarification needed with date_get function.

nn_herenn_here Member Posts: 31 Learner II
in Help
Hi,Iam trying to extract year,month and day from my date column which looks like Jul 1,2018 12:00:00 AM IST and omit time. So i tried with generate operator  by incorporating date_get function in it as ,date_get(Date, DATE_UNIT_MONTH, 'yyyy/MM/dd') and some more ways. but all in vein.  Can you please help me in solving this issue.
Thanks and regards,
nn_here

Best Answer

Answers

  • ceaperezceaperez Member Posts: 541 Unicorn
    Hi @nn_here,
    in this case you can use Date to numerical operator to extract parts of your data.

    Best, 
    Cesar

  • nn_herenn_here Member Posts: 31 Learner II
    Hi,
    Thankyou for the help provided.When i used this operator it's not giving me the result in required format.date field  Jul 1,2018  i would like it to split like july (col1),day(col2)2018(col3) as i need to group by on basis of 3 in different cases.i read about date_get(Date, DATE_UNIT_MONTH, 'yyyy/MM/dd')  that would satisfy my requirements.But the format is not matching.Can you please help me in this case..
    Thanks and regards,
    nn_here
  • nn_herenn_here Member Posts: 31 Learner II
    Hi, Kindly note  ,this is the expression i have added in generate attribute operator to segregate month from values in date column.
    date_get(Date, DATE_UNIT_MONTH, "yyyy-MM-dd")
But unable to get correct format after even after multiple attempts.
Kindly help me in getting the correct one.
Thanks and regards.
  • nn_herenn_here Member Posts: 31 Learner II
    Hi Cesar,
    Thankyou so much for taking out time and sharing the process !.It really helped...
    Motivates me to work on more rapidminer  operators .Thankyou. :) 
    Thanks and regards,
    nn_here
  • ceaperezceaperez Member Posts: 541 Unicorn
    You welcome, 
    We are here to share and help each other. Enjoy AI Studio (Rapidminer)

    best,

    Cesar
  • nn_herenn_here Member Posts: 31 Learner II
    Hi,
    Kindly help me in clarifying one doubt regarding missing values in 2 columns.2 columns having more than 2 lakh rows, have more than 1 lakh rows as missing values.Can you please let me know how should be deal with it.To remove the column as such or use replace missing value operator in rapid miner by replacing with sd or avg values..
    Also,as part of preprocessing i have used the following operators in rapidminer,
     Replace Missing Values -> Remove Correlated Attributes -> Normalize -> Remove Useless Attributes .Is there any more operators i need to verify before getting to actual data processing.
    Thanks and regards,
    nn_here.

Sign In or Register to comment.