unmix_func

An example function to provide a list of lists

Args:

x:

a 1-dimensional list object

Returns:

a list of lists (suitable for PyXLL)

Raises:

“empty” if function fails
jupytext:

{"formats": "md:myst", "text_representation": {"extension": ".md", "format_name": "myst"}}

kernelspec:

{"display_name": "Python 3", "language": "python", "name": "python3"}

from random import random
@xl_func("object x: var")
def unmix_func(x):
    """Return a list of lists
    Args:
        x: a 1-dimensional list object
    Returns:
        a list of lists (suitable for PyXLL)
    Raises:
        "empty" if function fails
    """
    try:
        return [[e] for e in x]
    except:
        return 'empty'

This is an example of inline text featuring a sparkline wave, , emphasized text.

This is an example of inline text featuring a sparkline wave, , italics text.

Model Results

In the 50,000 experiments of 10 coin tosses each, exactly 5 heads occurred times.

https://khoitsmahq.firstcloudit.com/images/tabby_excerpt.png

  • 16

  • List
    0 0.192206
    1 0.197810
    2 0.283948
    3 0.611066
    4 0.512147
    5 0.786452
    6 0.874998
    7 0.292821
    8 0.637193
    9 0.552829

(1)\[\begin{split}\begin{gather*} a_1=b_1+c_1\\ a_2=b_2+c_2-d_2+e_2 \end{gather*}\end{split}\]
\[\begin{split}\begin{align} a_{11}& =b_{11}& a_{12}& =b_{12}\\ a_{21}& =b_{21}& a_{22}& =b_{22}+c_{22} \end{align}\end{split}\]

name

insert

item

exact number of tosses

1

table of result

2

a simple variable

16

3

an entire dataframe

List
0 0.192206
1 0.197810
2 0.283948
3 0.611066
4 0.512147
5 0.786452
6 0.874998
7 0.292821
8 0.637193
9 0.552829

4

Embedded .png image

My embedded plot