2 ms·
Reminds me of the sqldf project for R [0] which allowed you to work with R data frames and SQL databases with SQL queries. [0] https://cran.r-project.org/web/p
by hatmatrix 4y ago
Reminds me of the sqldf project for R [0] which allowed you to work with R data frames and SQL databases with SQL queries.
[0] https://cran.r-project.org/web/packages/sqldf/index.html https://cran.r-project.org/web/packages/sqldf/index.html
- jmount 4y agoSQLDF is a great project, thanks for bringing it up. We use it in our book ( https://win-vector.com/practical-data-science-with-r/ https://win-vector.com/practical-data-science-with-r/ ). Inspired by it I have a feature to the data algebra that treats a captive database connection as a pool of data frames. A test showing the idea is here: https://github.com/WinVector/data_algebra/blob/main/tests/test_data_space.py https://github.com/WinVector/data_algebra/blob/main/tests/te...