Excel Functions in Python Library Updated

Added quite a few functions to my excel_in_python Python library yesterday. Purpose of the library is twofold: 1. For people familiar with Excel ways of working, you can read the code and understand how those functions might be implemented in Python. You can also use them as a bridge between your Excel expertise and your Python learning. 2. Some Excel functions have no direct simple equivalent in Python (looking at you YEARFRAC and DAYS360), so some of these may help you along your way when creating financial models in Python that use custom rules. Disclaimer: the tests do pass, but I haven't gone hand by hand verifying the output against equivalent function calls in Excel. That's a longer job which is ongoing and if you'd like to help and collaborate on this project, let me know! https://lnkd.in/gT6eJaKf #excel #python #data #analytics

  • No alternative text description for this image

Congratulations Owen, these look fascinating and many thanks for sharing. I have been meaning to dip my toes into Python waters for ages, now but still not done so. When I do, I will certainly import and use your functions. What source would you recommend for a “dyed in the wool” Excel VBA guy to have a gentle introduction?

Like
Reply

Brilliant work. I'm tempted to fork this. If only there weren't so many other tech things I wanted to explore.

See more comments

To view or add a comment, sign in

Explore content categories