The py_Numpy spreadsheet, and the associated Python module have been updated. The new files are included in:

py_SciPy.zip

The download contains full open-source Python code and example spreadsheets for a wide range of Scipy functions, as well as the Numpy functions covered in this post. For more details, see the series of posts starting at: Scipy functions with Excel and pyxll.

The update was prompted by use of the norm function, which has versions in both Numpy and Scipy, which are very similar, but not identical. The Numpy version is now called from Excel with py_npNorm, with py_Norm calling the Scipy version.

Links to the Numpy on-line help have also been extended. When any of the py_Numpy functions are entered, from any spreadsheet, the on-line help can be displayed by clicking on “help on this function”, at the bottom-left of the Function Wizard:

This takes you directly to the on-line help for the selected function:

Alternatively, the Numpy help can be displayed on the spreadsheet using the get_docs function. In the py_Numpy spreadsheet this is linked to the list of available functions, so that entering the index number for any function will display the associated help text:

Note that the get_docs function can be used from any spreadsheet, and will return the help text from any available Python function. The screenshot below shows it used for the Numpy norm function and also the Scipy version: