It's not the built in functions they're trying to replace, it's using python instead of VBA to make macros.
While Excel functions are relatively robust, doing more complex operations that impact more than one cell typically require macros. I was attempting to process 50,000 cells and I tried making a function, but it was a pain in the ass given how complex it was. Since, I didn't know VBA, but did know Python, I used Ironspread to use write a script to do the job. I was impressed, it's pretty smooth to use.
While Excel functions are relatively robust, doing more complex operations that impact more than one cell typically require macros. I was attempting to process 50,000 cells and I tried making a function, but it was a pain in the ass given how complex it was. Since, I didn't know VBA, but did know Python, I used Ironspread to use write a script to do the job. I was impressed, it's pretty smooth to use.