DuckDB vs dplyr vs base R

Reposted from https://blog.stephenturner.us/p/duckdb-vs-dplyr-vs-base-r.TL;DR: For a very simple analysis (means by group on 100M rows), duckdb was 125x faster than base R, and 28x faster than readr+dplyr, without having to read data from disk int…