dtplyr
polars
Our great sponsors
dtplyr | polars | |
---|---|---|
24 | 144 | |
654 | 26,218 | |
-0.2% | 6.7% | |
7.5 | 10.0 | |
2 months ago | 1 day ago | |
R | Rust | |
GNU General Public License v3.0 or later | 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.
dtplyr
-
Tidyverse 2.0.0
Can’t say I’ve used it, but isn’t that what dtplyr is supposed to provide?
https://dtplyr.tidyverse.org/
-
Error when trying to use dtplyr::lazy_dt, "invalid argument to unary operator"
# I am trying to follow the example at https://dtplyr.tidyverse.org/
-
Millions of rows
FYI the developer of tidytable has been developing dtplyr for the Tidyverse. You might like that too!
-
fuzzyjoin - "Error in which(m) : argument to 'which' is not logical"
If you need speed, you should consider using dtplyr (or tidytable), or even dbplyr with duckdb.
-
Best alternative to Pandas 2023?
https://dtplyr.tidyverse.org/ ?
-
R Dialects Broke Me
If you want data.table speed, but using dplyr/tidy then dtplyr is a good package to have handy. Personally I love R, and choose R + NodeJS as my gotos for everything I do, and use Python only when I have to.
-
Merging csv from environment.
Also, that dataset is quite big, and the "base" Tidyverse will be excessively slow. You should supplement the "base" Tidyverse packages (i.e. dplyr and tidyr) with either dtplyr or dbplyr (+ duckDB). I'd suggest starting with dtplyr, which should handle 10M+ rows fine.
-
mutate ( ) function is only working in code chunk I run it in. It does not change the column in my data frame other than in that one code chunk.
If you want, there's a "substitute" for dplyr called dtplyr (also part of the Tidyverse), which "translates" your dplyr/tidyr code into data.table behind the scenes, and allows you to make your modifications apply directly to the original dataset by default:
-
R process taking over 2 hours to run suddenly
Install the dtplyr package and change your code to:
-
DS student here: why use R over Python?
Get the best of both worlds (tidyverse + data.tables) with dtplyr, a data.table backend for dplyr.
polars
-
Why Python's Integer Division Floors (2010)
This is because 0.1 is in actuality the floating point value value 0.1000000000000000055511151231257827021181583404541015625, and thus 1 divided by it is ever so slightly smaller than 10. Nevertheless, fpround(1 / fpround(1 / 10)) = 10 exactly.
I found out about this recently because in Polars I defined a // b for floats to be (a / b).floor(), which does return 10 for this computation. Since Python's correctly-rounded division is rather expensive, I chose to stick to this (more context: https://github.com/pola-rs/polars/issues/14596#issuecomment-...).
-
Polars
https://github.com/pola-rs/polars/releases/tag/py-0.19.0
-
Stuff I Learned during Hanukkah of Data 2023
That turned out to be related to pola-rs/polars#11912, and this linked comment provided a deceptively simple solution - use PARSE_DECLTYPES when creating the connection:
- Polars 0.20 Released
- Segunda linguagem
- Polars: Dataframes powered by a multithreaded query engine, written in Rust
- Summing columns in remote Parquet files using DuckDB
- Polars 0.34 is released. (A query engine focussing on DataFrame front ends)
What are some alternatives?
tidytable - Tidy interface to 'data.table'
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 🚀
tidypolars - Tidy interface to polars
modin - Modin: Scale your Pandas workflows by changing a single line of code
datafusion - Apache DataFusion SQL Query Engine
Datamancer - A dataframe library with a dplyr like API
DataFrames.jl - In-memory tabular data in Julia
explorer - Series (one-dimensional) and dataframes (two-dimensional) for fast and elegant data exploration in Elixir
datatable - A Python package for manipulating 2-dimensional tabular data structures
dataiter - Python classes for data manipulation
Apache Arrow - Apache Arrow is a multi-language toolbox for accelerated data interchange and in-memory processing