data.table
R's data.table package extends data.frame: (by Rdatatable)
vaex
Out-of-Core hybrid Apache Arrow/NumPy DataFrame for Python, ML, visualization and exploration of big tabular data at a billion rows per second 🚀 (by vaexio)
Our great sponsors
| data.table | vaex | |
|---|---|---|
| 16 | 7 | |
| 3,478 | 8,171 | |
| 0.8% | 0.4% | |
| 9.6 | 5.4 | |
| about 21 hours ago | 22 days ago | |
| R | Python | |
| Mozilla Public License 2.0 | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
data.table
Posts with mentions or reviews of data.table.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-21.
- Data.table: R's data.table package extends data.frame
-
Discovering Copy-on-Write in R
The data.table package may also make a huge difference in performance, and often simplifies the code as well https://github.com/Rdatatable/data.table
- new governance being proposed for data.table
-
Local development environment for the data.table R project
After the partial success with the development environment for R-yaml we tried another R package called data.table as part of the Open Source Development Course. Eventually we managed to run the tests of this too.
-
Alternative to Pandas
There's datatable. I haven't used it much, but the R version (data.table) is phenomenal.
-
Do python packages have long form documentation? If so can someone provide me a sample?
data.table README.md
-
How to move “time” to a new column
That's an old bug in data.table v1.12.2. It's been fixed for a while now. If you update your data.table version (e.g., install.packages("data.table") ) and retry then it should work fine.
-
Hiring an R coder to improve efficiency of code?
Some suggestions: (1) https://github.com/Rdatatable/data.table Code based on the data.table will probably be fastest. There are a number of reasons for this. More here: https://cran.r-project.org/web/packages/data.table/vignettes/ and here: https://rdatatable.gitlab.io/data.table/library/data.table/html/datatable-optimize.html The GForce set of optimizations is well explained here: https://www.brodieg.com/2019/02/24/a-strategy-for-faster-group-statisitics/ (2) setDTthreads() is your friend in data.table (3) I have found (on Windows at least) Microsoft Open R use of parallel MKL faster than CRAN's latest release. See https://mran.microsoft.com/documents/rro/multithread Microsoft recommends using setMKLthreads() if it will help. (4) I think rfast ( https://github.com/RfastOfficial/Rfast ) is a library worth considering although I don't know if it will help you with brms and stan operations.
-
Piping in R is like baking!
Take a look at the 22nd new feature of v1.14.3 on development here.
- memory leak after data.table::fread()?
vaex
Posts with mentions or reviews of vaex.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-06-03.
-
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?
When comparing data.table and vaex you can also consider the following projects:
rust-dataframe - A Rust DataFrame implementation, built on Apache Arrow
polars - Dataframes powered by a multithreaded, vectorized query engine, written in Rust
siuba - Python library for using dplyr like syntax with pandas and SQL
minimal-pandas-api-for-polars - pip install minimal-pandas-api-for-polars
TypedTables.jl - Simple, fast, column-based storage for data analysis in Julia
gsir-te - Getting Started in R -- Tinyverse Edition
visidata - A terminal spreadsheet multitool for discovering and arranging data
ballista - Distributed compute platform implemented in Rust, and powered by Apache Arrow.
umap - Uniform Manifold Approximation and Projection
db-benchmark - reproducible benchmark of database-like ops