dataiter
vaex
dataiter | vaex | |
---|---|---|
2 | 7 | |
23 | 8,170 | |
- | 0.1% | |
7.8 | 5.4 | |
24 days ago | 29 days ago | |
Python | Python | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dataiter
-
Modern Pandas (Part 2): Method Chaining
Here's another alternative. I wrote Dataiter specifically as I too was frustrated with Pandas. In my experience if you design a new API from scratch (and don't try to reimplement the Pandas API as many projects have done!) and have some vision and consistent principles, it's well possible to get a good intuitive API as a result. Two relevant issues remain: You're limited by NumPy's datatypes and their problems, such as memory-hogging strings and a lack of a proper missing value (NA), and secondly, limited by the Python language, so compared to e.g. dplyr's non-standard evaluation, you'll need to use lambda functions, which are unfortunately clumsy and verbose.
https://github.com/otsaloma/dataiter
Here's a comparison of dplyr vs. Dataiter vs. Pandas, which should give quick overview of the similarieties and differences.
https://dataiter.readthedocs.io/en/latest/_static/comparison...
-
Polars: Lightning-fast DataFrame library for Rust and Python
Agreed, dplyr is great.
I built my own data frame implementation on top of NumPy specifically trying to accomplish a better API, similar to dplyr. It's not exactly the same naming or operations, but should feel familiar and much simpler and consistent than Pandas. And no indexes or axes.
Having done this, a couple notes on what will unavoidably differ in Python
* It probably makes more sense in Python to use classes, so method chaining instead of function piping. I wish one could syntactically skip enclosing parantheses in Python though, method chains look a bit verbose.
* Python doesn't have R's "non-standard evaluation", so you end up needing lambda functions for arguments in method chains and group-wise aggregation etc. I'd be interested if someone has a better solution.
* NumPy (and Pandas) is still missing a proper missing value (NA). It's a big pain to try to work around that.
https://github.com/otsaloma/dataiter
vaex
-
preprocessing millions of records - how to speed up the processing
Try vaex, vaex, using lazy evaluation and parallel calculations, you should be fine.
-
High performance (for the consumer) time series storage?
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.
-
Python Pandas vs Dask for csv file reading
How about vaex?
- Polars: Lightning-fast DataFrame library for Rust and Python
-
For stocks, what historical data do you store and how do you store it?
You might find vaex (https://github.com/vaexio/vaex) interesting if you work with HDF5.
- I wrote one of the fastest DataFrame libraries
-
A Hybrid Apache Arrow/Numpy DataFrame with Vaex Version 4.0
My guess is that should be possible, feel free to hop onto https://github.com/vaexio/vaex/discussions !
What are some alternatives?
dtplyr - Data table backend for dplyr
polars - Dataframes powered by a multithreaded, vectorized query engine, written in Rust
explorer - Series (one-dimensional) and dataframes (two-dimensional) for fast and elegant data exploration in Elixir
data.table - R's data.table package extends data.frame:
dataframe-api - RFC document, tooling and other content related to the dataframe API standard
minimal-pandas-api-for-polars - pip install minimal-pandas-api-for-polars
chain-ops-python - Simple chaining of operations (a.k.a. pipe operator) in python
rust-dataframe - A Rust DataFrame implementation, built on Apache Arrow
data_algebra - Codd method-chained SQL generator and Pandas data processing in Python.
visidata - A terminal spreadsheet multitool for discovering and arranging data
mito - The mitosheet package, trymito.io, and other public Mito code.
umap - Uniform Manifold Approximation and Projection