No, I'm not kidding. This is a huge red flag that the company you work flow is so bound by procedure that they cannot make changes quickly enough to react to changing market conditions.
Is there an easier platform than Excel that integrates GUI for viewing and modifying data, as well as a huge api for custom code in Python I'm not aware of?
For any sort of serious analysis Excel is the road to 'hit F9 and hope Excel doesn't crash' and directories full of files like: 'my_analysis_2017Dec12_2PM_finalfinalversion_forserious.xlsx'
It's already happening, but it really depends on your definition of data analysis. Given the amount of time I already spend helping people structure very simple spreadsheets using well established formulas included in excel, I shudder at the thought of teaching them pandas.
Python is a great beginner language, but you have to want to learn it. Most people can't even be bothered to learn the basics of a gui-driven numerical tool like excel, nevermind a far more abstract programming language.
I agree with many of the posts here, for straight forward cut and paste and sum and pivot table operations it's pretty hard to be faster than working in excel. The problem with excel is that the analysis is difficult to repeat, harder to automate, and impossible to ensure data integrity.
33
u/[deleted] Dec 14 '17
Better idea: use python instead of excel for all data analysis