12 ms·
Same here. Why re-invent SQL as a weird object system? I've also recently found that using the sqlite3 command line tool increases my productivity when doing d
by ab111111111 6y ago
Same here. Why re-invent SQL as a weird object system?
I've also recently found that using the sqlite3 command line tool increases my productivity when doing data sciency stuff a lot. It's a super fast, super simple way of making sense of CSV data, especially for the selecting an joining operations that are so unintuitive in pandas. Once that's done, I can dump the results into Jupyter or RStudio for transformation and/or visualization.
Another personal productivity win I've discovered is using two-line python scripts to write really long and repetitive SQL commands (select count a, b, c... from huge_table where d... and e... and f...; etc.) and then running them in SQLite.