News for hackers. Stuff that matters.
Re:Ditching Excel for Python in a legacy industry by jandrewrogers on Thursday December 31, 2020 @12:06AM (#25589785)
I use both Excel and Python, and like both. They solve different kinds of problems, even within the same context.

Excel is fantastic for what I would describe as linear modeling, building a graph of effects in single data models. I reach for Python when I need to fundamentally transform the data model at points to answer the desired question. That is difficult to the point of being impractical in Excel, especially if the data model is large or exploratory. Python is more programmable in this regard but also lacks the strong static typing that would be useful in such work.

I can’t imagine not using either.

There are no comments on this comment yet.