Recent Comments
Category Archives: Maths
Scipy Linalg functions stopped working
I recently noticed that the iterative linear algebra solvers in my pyLinAlgfuncs3.xlsb spreadsheet had stopped working. It turned out that the optional tolerance argument had been renamed ‘rtol’. Changing all the occurrences of the name in the Python code fixed … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Iterative solvers, linear algebra, linear equations solver, LU solvers, Numpy, PyPardiso, Python, PyXLL, SciPy, sparse matrices, UDFs.
Leave a comment
Scipy-statistics update
Links to the Scipy statistics functions were last presented here. The functions have since had extensive updates: The functions previously listed as “not yet implemented” have now been added. Each function now links to the Scipy on-line help page, and … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, Help function, Pandas, Python, PyXLL, SciPy, Scipy.Stats, statistics, UDF
1 Comment
Let, Lambda, and py_Eval
I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365 subscribers, so I have now looked at … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged evaluate text strings, Excel, Lambda Function, Let function, Python, PyXLL, py_Eval function, UDF
Leave a comment
Extracting and counting factors with Python and Numba
This post features code using the pyxll add-in to call Python code from Excel. See pyxll for more details and downlod. A recent issue of New Scientist had a series of puzzles finishing with: how many integers between 1 and … Continue reading
Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs
Tagged Code speed-up, Count Factors, Excel, Factors, Numba, Python, PyXLL, UDFs
Leave a comment
Scipy Functions with Excel and pyxll 8 – Statistics
This post looks at linking Excel to the Scipy and Pandas statistics functions using pyxll. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll package (including … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, Help function, Numpy, Pandas, Python, PyXLL, SciPy, statistics, UDFs.
1 Comment
