Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Replicate excel function NETWORKDAYS in dataiku?

frankb
Level 1
Replicate excel function NETWORKDAYS in dataiku?

Hi,



Is it possible to replicate the excel function NETWORKDAYS, which excludes weekends when calculating the number of days between two dates, in any way within dataiku using prepare mode or sql, or python recipes?



Thanks!



Frank

0 Kudos
1 Reply
Alex_Combessie
Dataiker Alumni
Hi,

There is no built-in formula in a visual prepare recipe to replicate this Excel function. But this would be quite simple to do in a Python or R recipe. In Python there is one package which does that: https://pypi.org/project/workdays/. In R there is a similar one: https://cran.r-project.org/web/packages/bizdays/bizdays.pdf.

Hope it helps,

Alex
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku