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

2

u/frazorblade Apr 14 '22

Yes 100% Excel/PQ is much slower which is a major gripe of mine, but it works for smaller datasets which I’m used to dealing with.

I feel once you’re at the stage of large data (100k-1m+) is when you can afford to look into the most efficient method and I agree python/R is the way forward

1

u/Allmyownviews1 Apr 14 '22

I agree but there is also an aspect of quality control and quality assurance. Having scripted production does give some tracking and allow time saving with each time a similar project is performed. For my business, being able to repeat tasks can be a saving of a week or more per project and be more competitive as a result.

1

u/frazorblade Apr 14 '22

I use Excel as either the first step in some quick analysis or as a tool/dashboard that can easily shared.

I don’t need to know their IT setup or go through the harrowing process of building an online dashboard that needs a lengthy development cycle.