The 3-Second Test That Proves Excel's Dominance
A finance director asked me to show her last quarter's top-performing SKUs by region. I opened Jupyter, imported pandas, read the CSV, ran groupby().agg(), forgot I needed another column, scrolled back up, re-ran the cell, realized I wanted median not mean, edited the aggregation function, re-ran it again. Seven minutes later I had the answer.
She opened the same CSV in Excel, clicked Insert → PivotTable, dragged three fields, and had the result in 15 seconds. Then her boss walked in and asked to see it split by product category instead. She dragged one more field. Done.
That's the problem Python evangelists won't admit: for the vast majority of business data tasks, Excel's interactive GUI beats code for iteration speed.
Why This Matters (and Why I'm Writing This as a Python Developer)
Continue reading the full article on TildAlice
Top comments (0)