10 points
That works when you have access to a SQL database instead of a bunch of massive CSV files.
14 points
*
6 points
Not saying there’s any reason to switch, but I believe you can load CSV’s into sqlite.
Datasette would be something that I would try for CSV’s as well, that seems like an interesting piece of technology I haven’t had reason to use yet.
Finally there’s always Jupiter Notebook and any respectable DataFrame-solution.
Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I’d probably reach for a tool I could combine with some form of VCS like Git at least.
3 points
