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!