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?

ceaperez

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

如果你不想使用python还可以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