polars VS vaex

polars might click better. Once you learn the expression API, you'll see that googling is much less needed as you can extrapolate that logic.

The new data tools I've seen are complex under the hood, but offer elegant user experiences, giving the best of both worlds.

You referenced a 500 line Python script being refactored with Rust and make me think of the Polars project: https://github.com/pola-rs/polars

Polars uses Rust to make DataFrame operations lightning fast. But you don't need to use Rust to use Polars. Just use the Polars Python API and you have an elegant way to scale on a single machine and perform analyses way faster.

I'm working on Dask and our end goal is the same. We want to provide users with syntax they're familiar with to scale their analyses locally & to clusters in the cloud. We also want to provide flexibility so users can provide highly custom analyses. Highly custom analyses are complex by nature, so these aren't "easy codebases" by any means, but Dask Futures / Dask Delayed makes the distributed cluster multiprocessing part a lot easier.

Anyways, I've just seen the data industry moving towards better & better tools. Delta Lake abstracting all the complications of maintaining all the complications of plain vanilla Parquet lakes is another example of the amazing tooling. Now the analyses and models... those seem to be getting more complicated.

I'd recommend checking out polars as an alternative to pandas - https://github.com/pola-rs/polars

It has a rather different api, and is significantly faster. Highly recommend it.

Have you looked at Polars? It's a new dataframe library that has an api that makes a lot more sense than pandas, and on top of that is much, much faster.

Polars is almost at 500k downloads, this is great to see the Rust ecosystem connecting with Python.

Are there any articles about how the authors of polars used pyo3 to expose a python API?

I'd recommend QuestDB. Worked with it multiple times for different algorithmic trading needs and it didn't disappoint. If you want to load data fast, I'd recommend this Python library.

How about vaex?

You might find vaex (https://github.com/vaexio/vaex) interesting if you work with HDF5.

My guess is that should be possible, feel free to hop onto https://github.com/vaexio/vaex/discussions !