Comment on Comparing SQLite, DuckDB and Arrow with UN trade dataparentComments−phillc734yThere's an R package for that! Well, multiple really. The `sqldf`[1] package has been around for a while, there's `tidyquery`[2] and also one I wrote called `duckdf`[3]. All three support writing SQL queries to directly access dataframes.[1] https://github.com/ggrothendieck/sqldf[2] https://github.com/ianmcook/tidyquery[3] https://github.com/phillc73/duckdf−chrisjc4yNot exactly what I was asking, but still some pretty awesome links/projects. Thanks for the links.I'm pretty sure that I'll be getting my hands dirty with R eventually.
Comments
There's an R package for that! Well, multiple really. The `sqldf`[1] package has been around for a while, there's `tidyquery`[2] and also one I wrote called `duckdf`[3]. All three support writing SQL queries to directly access dataframes.
[1] https://github.com/ggrothendieck/sqldf
[2] https://github.com/ianmcook/tidyquery
[3] https://github.com/phillc73/duckdf
Not exactly what I was asking, but still some pretty awesome links/projects. Thanks for the links.
I'm pretty sure that I'll be getting my hands dirty with R eventually.