4 ms·
Hardly. I can often do in Excel in 5 minutes what would take me an hour or two with Python. I've got some output from something or a table of data I can copy-p
by yuliyp 4y ago
Hardly. I can often do in Excel in 5 minutes what would take me an hour or two with Python.
I've got some output from something or a table of data I can copy-paste into Excel, quickly do some text-to-columns or string manipulation (tweaking it instantly if I see things don't look right) to get the data into a usable format, then go and build up some formulas, sorts, and plots to answer whatever question I had / get something I can share with others.
Each of those steps is doable with Python + SQLite, but takes more time: I have to write my own data parser (yes, Python's string utils are very good for this, but generally Excel is faster to use, despite using Python for years for my job. I have to then create a schema for the data, and then I have to iterate on my analysis functions, and then finally write my own output / futz around with a graphing library, rerunning whenever I want to tweak something (instead of just changing a cell or chart parameter and seeing it instantly reflected on screen.
There is a crossover point where the complexity of the analysis, amount of data, or otherwise makes Excel less practical, but it absolutely has a place as a super-helpful tool, even for those capable of using more powerful general purpose programming languages.
- simonw 4y ago"I have to then create a schema for the data" You might find my sqlite-utils Python library interesting - one of its key features is that it can create the right schema for you automatically to fit the data (as a Python dict or list of dicts) that you pass to it: https://sqlite-utils.datasette.io/en/stable/python-api.html#creating-tables https://sqlite-utils.datasette.io/en/stable/python-api.html#...
- HyperSane 4y agoI didn't say ALL uses. Just the ones where Excel is being used as a crappy combination of programming language and database.