You might know this already, but you can query pandas/polars/arrow tables directly w/ duckdb and use whatever stats packages you feel like alongside it in the same python script. I feel like they do a decent job sticking to the simpler statistical fans that make sense in sql.

Sorry, I meant duckdb-cli, not duckdb in Python.

Oh, then you might like these DuckDB community extensions that provide stats functions!

https://duckdb.org/community_extensions/extensions/stats_duc...

https://duckdb.org/community_extensions/extensions/stochasti...

Will check them out, thanks!