Is Python really taking over the MS-Excel space?
Related Posts
Bowl Leader
Hi,
Is anyone facing same situation?
Hi, any idea about WFO,?
Additional Posts in Excel Genius
Still don't have xlookup. #fomo
Coach
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
No
Most likely not. VBA being common among all Office products has been one of its most unsung keys to success. If a new scripting language is adopted for one Office product, strategically there had better be a plan for it to be adopted across the board.
Interesting. I am an Excel user since the early 2000 and never felt the need for VBA, so never learned it
Python and Excel have both existed in substantially the same form for over 20 years so why do you expect the use cases for either to change only now?
Spreadsheets are good for calculations and modeling of lower complexity where someone with basic computer literacy can follow along and even modify the workbook, because the graphics make things much easier to understand.
Scripted programs are good for much more complex calculations and models, especially when performance is really important, and they have much more extensible functionality. But even Python is much less easy to learn than reading an Excel sheet.
They're different tools for different jobs.
They do different things well.
No way
If you’re comparing the two I’m guessing it’s a specific context. Python, generally using Pandas, can handle MUCH larger datasets than PowerQuery (and powerbi can use python in addition to PQ, not certain about excel). It’s also more flexible in the ETL portion. You’d take the output from Python and use that in your workbook or if the excel portion is just to manipulate data, can skip excel and pipe the Python to your target dataset.
You’d take the output from the Python
If the dataset isn’t massive and/or your ETL needs aren’t complex, Excel may be easier to work with instead of writing Python code for it all.
No, python is complementary
R is a pile of junk, only use it if you absolutely must.. most complex algorithms, decision training models etc can be created in Python, better to stick to learning languages with universal use-cases..
That brings us back to Excel, has far more general ways it can be used without the complexities of scripts, they all have their uses but Excel is generally more important.
Excel > Python > R
No but other things are like PowerBI reports/Dashboards etc. Are 100% taking over from Excel. Spreadsheets are archaic and they break and become outdated, complicated, security risks, not documented and lots should just be databases, programs/applications or reports using something that's not designed to just be a big calculator. We have much better tools now, such as the aforementioned power apps. Excel still has its place though for very simple applications (at least for now)