News for hackers. Stuff that matters.
Re:Ditching Excel for Python in a legacy industry by alexpetralia on Wednesday December 30, 2020 @07:55PM (#25588284)
You can F9 on "A1 + SomeOtherTab:B2" (just that selection) and it'll calculate for you. You can do this for all the dependencies under Trace Dependencies.

I admit it's not perfect but I have found it much easier historically to follow a calculation through Excel than through untested pandas code (people inner join and drop rows; they groupby and lose null groups plus related rows; they filter string data without case insensitive matching, etc.).

There are no comments on this comment yet.