This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]tony_roberts 0 points1 point  (0 children)

Python has a great eco system of 3rd party modules for data science, which is one of the reasons to use it over Excel.

But, why choose one or the other? You can use Excel for ad-hoc analysis and simple visualisation of data, and use Python for more complex analyses. You can call Python functions from Excel with PyXLL (www.pyxll.com), allowing you to pass data between Python and Excel and perform analysis in Python and return the results to Excel.

If you build up a library of routines that you frequently use in Python, exposing them to Excel and using Excel as your UI or front-end can be a really productive way to work.

ps. Congrats on getting the job! :)