Tag Archives: Python

More Python Traps

Posted on 30/03/2020 by dougaj4

I recently posted on some Python Traps, focussing on code where changes in the values of sub-routine arguments were not reflected in the calling routines.  The reverse can also be a problem: if an array, a, is passed to a … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Microsoft Python Resources

Posted on 24/02/2020 by dougaj4

In addition to the documentation of their software products, Microsoft now have a huge amount of on-line resources of more general content, including: YouTube: Python for Beginners Probably the largest hurdle when learning any new programming language is simply knowing … Continue reading →

Posted in Computing - general, Excel, Link to Python | Tagged , , , | Leave a comment

Python Traps

Posted on 01/01/2020 by dougaj4

When converting existing VBA code to Python there are a number of obvious changes to the syntax that need to be made for the code to run at all, but there are also a number of not so obvious traps … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Multiple Integration with Scipy

Posted on 31/01/2019 by dougaj4

Scipy has 3 functions for multiple numerical integration in the scipy.integrate module: dblquad: Compute a double integral. tplquad: Compute a triple integral’ nquad: Integration over multiple variables. I have written six functions to call these functions from Excel, via Pyxll: Each … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 6 Comments

mpmath for Excel

Posted on 13/01/2019 by dougaj4

mpmath has been mentioned in passing here before, but not in any detail.  The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading →

Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings | Tagged , , , , , , , , | 7 Comments