How to calculate no of day's present in month based on given date

sgnarkhede2016

I have the requirement of finding a total number of days in a month based on date. For e.g I have a date with me i.e. 15 April 2021 then a number of days must return 30 as April month consists of 30 days. If I have a date of 02 Feb 2020 then the number of days should return as 29 as it is a leap year.

Can we achieve this in RapidMiner using any in-built function or operator?

Caperez

Hi @sgnarkhede2016,

You can use the pandas.Period.days_in_month method in a python script. operator.

p = pd.Period('2021-4-21')

p.days_in_month

return 30. 

please find attached an example process 

Telcontar120

If you don't want to use python you can also extract the month from the date (using Generate Attributes) and then a lookup table to join the number of days based on the month.

MartinLiebig

well, isnt this just joining the days and taking care of february?

Best,

Martin

Caperez

Hi @sgnarkhede2016,

You can use the pandas.Period.days_in_month method in a python script. operator.

p = pd.Period('2021-4-21')

p.days_in_month

return 30. 

please find attached an example process 

Telcontar120

If you don't want to use python you can also extract the month from the date (using Generate Attributes) and then a lookup table to join the number of days based on the month.