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.
Only if you refuse to learn SQL and do everything in a fraction of the time with way more functionality.
That works when you have access to a SQL database instead of a bunch of massive CSV files.
cracks knuckles
import pandas as pdNow you’re speaking my language!
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.
Importing CSV into SQL is trivial and gives you far more control than Excel can.
Jupyter gang, any other data scientists here?