Would be really cool if they were to add statistical functions too. I'd jump at the chance of getting to use this over pandas
Would be really cool if they were to add statistical functions too. I'd jump at the chance of getting to use this over pandas
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!
which statistical functions do you want? i’m curious because i love duckdb and use it for a variety of projects but always want to learn more about how to use tools better.
Basic regression and interpolation for starters; perhaps some classification and outlier detection too. Disclaimer: I self-studied applied DuckDB for my job, I don't know if these already exist.