How to calculate no of day's present in month based on given date
New Altair Community Member
Updated by Jocelyn
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?
Find more posts tagged with
Sort by:
1 - 3 of
31
MartinLiebig
Altair Employeewell, isnt this just joining the days and taking care of february?
Best,
Martin
Altair Community Member
Accepted Answer
Hi @sgnarkhede2016,
You can use the pandas.Period.days_in_month method in a python script. operator.
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
New Altair Community Member
Accepted Answer
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.
Sort by:
1 - 2 of
21
Altair Community Member
Accepted Answer
Hi @sgnarkhede2016,
You can use the pandas.Period.days_in_month method in a python script. operator.
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
New Altair Community Member
Accepted Answer
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.