5 ms·
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
by dartharva 1mo ago
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
- biophysboy 1mo agoYou 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.
- dartharva 1mo agoSorry, I meant duckdb-cli, not duckdb in Python.
- 1egg0myegg0 1mo agoOh, then you might like these DuckDB community extensions that provide stats functions! https://duckdb.org/community_extensions/extensions/stats_duck https://duckdb.org/community_extensions/extensions/stats_duc... https://duckdb.org/community_extensions/extensions/stochastic https://duckdb.org/community_extensions/extensions/stochasti...
- dartharva 1mo agoWill check them out, thanks!
- swasheck 1mo agowhich 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.
- dartharva 1mo agoBasic 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.