Recent Comments
Category Archives: Arrays
Transferring different data types to/from Python with pyxll
When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Alternative data types, Excel, Numpy, Python, PyXLL, pyxll get_type_converter, pyxll Union, SciPy, Scipy stats, UDFs
1 Comment
Scipy-statistics with distributions
The Scipy statistics functions last presented here have now been updated with the addition of links to the numerous distribution functions. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, and also minor updates to the pyNumpy.py code, … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Distribution functions, Excel, Help function, Pandas, Python, PyXLL, SciPy, Scipy.Stats, statistics, UDF
Leave a comment
More on TrimRange and the Drop Function
A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading
Posted in Arrays, Excel
Tagged array functions, Drop function, Excel, Selecting a trimmed range, TrimRange function
Leave a comment
The TrimRange Function
I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading
Posted in Arrays, Excel
Tagged array functions, Excel, Selecting a trimmed range, TrimRange function
2 Comments
Mandelbrot, Mojo, Numpy and Numba
I recently read an article about connecting Python to the new Mojo language: Python Can Now Call Mojo The article had some code examples, including code to plot the Mandelbrot set, comparing plain Python, Python with Numpy, and Mojo, and what … Continue reading
Posted in Arrays, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Mandelbrot, Numba, Numba Guvectorize, Numpy, Plot Python in Excel, Python, PyXLL
Leave a comment
