r/learnpython • • Apr 13 '22

What is difficult in excel but easy in Python?

If you were to introduce an established excel user [non VBA] to Python, what would you suggest?

What would amaze them? In as few a lines as possible?

404 Upvotes

241 comments sorted by

View all comments

Show parent comments

9

u/cinemabaroque Apr 13 '22

Python is way more powerful than Excel, not better. For 90% of use cases you can do things faster and more clearly in Excel with knowing just a handful of formulas and inserting charts.

1

u/TigreWulph Apr 13 '22

I don't like excel, so I don't think we'll come to an agreement there. I have no problem with a less powerful tool that's simple to use, I don't think excel is that tool.

6

u/cinemabaroque Apr 13 '22

I don't like running. That must mean biking is the better form of exercise.

2

u/TigreWulph Apr 14 '22

I mean yeah for your purposes. But since we can't just let it go and apparently need to have a semantic dick measuring contest. I've never had python freeze up on me when doing a data churn and completely lock up my machine. When I finish a python run it closes and terminates completely, excel often leaves processes running in the background with the only indication being a task manager window, one drive doesn't try to insert itself in my python runs and arbitrarily decide that I am no longer signed into the necessary account to do the job. And an ongoing and growing list of gripes I have from my daily interaction with the software.

I conceded that the niche it fills, is a valid niche, I think Google's product is better. And for the metrics of reliability and no fuckery from the creator Python IS better.