r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

33

u/[deleted] Dec 14 '17

Better idea: use python instead of excel for all data analysis

50

u/[deleted] Dec 15 '17 edited Dec 15 '17

This isn't realistic in an office where lots of people:

  • are Excel-literate but not Python-literate

  • want tools they can tinker with

  • aren't gonna become Python-literate any time soon

7

u/Acurus_Cow Dec 15 '17

And where company policies prevent me from installing python packages.

4

u/LyndsySimon Dec 15 '17

You should find another job.

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.

5

u/ANEPICLIE Dec 15 '17

Any large corporation or government that isn't necessarily programming oriented will frequently have similar restrictions.

2

u/cyanydeez Dec 15 '17

you forgot the biggest impediment:

  • Existing, fully QA/QC Excel calcs from 20 years ago that have no reason to be revised or tinkered with because they mostly work

→ More replies (4)

13

u/Sean1708 Dec 14 '17

Have you had any luck getting people to switch? If so, can I hire you?

5

u/SpaceSteak Dec 15 '17

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?

8

u/[deleted] Dec 15 '17

easier ? maybe not

better? more reproducible?

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'

0

u/[deleted] Dec 15 '17

[deleted]

2

u/cyanydeez Dec 15 '17

like giving your boss control of the spreadsheet to tinker with cause he needs to show that he's providing value added feedback

→ More replies (1)

2

u/SpaceSteak Dec 15 '17

Bad file hygiene happens in any badly managed team. Since 2007 Excel hasn't crashed much in my experience, with huge workbooks and lots of macros.

→ More replies (1)

5

u/hoocoodanode Dec 15 '17

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.

→ More replies (4)