Installing Other Open Source Modules

[Maelstrom6]

Hi there

I am aware that Python In Excel supports numpy, pandas and a few other libraries. However, there is no comprehensive list of libraries that are installed in the default Conda environment. Is there such a list and how do we install and use other packages such as duckdb?

Thanks.

[stonebig]

I miss duckdb a lot, too. I imagine it couldn't be in initial release, as duckdb was not even 1.0 at the time.
Now, it's a suffering not to have it.

[stonebig]

I must confess duckdb-1.0.0 was still a little rough around the edges on recursive CTE, but It would speed-up my target use per 2x minimum, maybe way more , by replacing SQLite.

No optimization tried, so 2x is the verifiable minimal guess based on wasm

[keyur32]

To get the list you can run %pip list from a python formula. This will show the full list in the diagnostics pane, or through the Python Editor output.

We don't yet allow additional libraries but is on our backlog to support custom compute.