Ditching Excel for Python in a legacy industry

Post by buryat » Mon, Jan 04, 2021, 2:59 AM UTC

gerdesj wrote: post #259

tomcam wrote: post #28

Earlier quoted context omitted.

All good anecdotes, but I’m still kind of stuck on the whole you got to work at a pie factory thing

(Sorry, misty eyed recollection alert) I should point out that "pies" in the UK is a rather generic term. MBOs (mince beef and onion), sausage rolls, pasties, pork pies and quiche was made in this south Devon based factory, near Plymouth. It was a good corp citizen thing to attend the 1100 "taste panel" which was part of the quality process. Obviously Product Dev, QA and the line crews could not mark their own work s…

Post by zentiggr » Mon, Jan 04, 2021, 6:12 PM UTC

pjmlp wrote: post #249

zentiggr wrote: post #244

Earlier quoted context omitted.

... and then you have two problems. I have never seen an environment converted to SharePoint that didn't suffer badly from the conversion. And the Excel vs source control issue isn't history, it's "go ahead and try to diff between two versions of an Excel sheet" vs "diff two versions of that source file". Unless I've never heard of the tool that can digest two Excel sheets and tell you what formulas differ, or cells.…

https://support.microsoft.com/en-us/office/overview-of-sprea...

Post by gerdesj » Tue, Jan 05, 2021, 12:41 AM UTC

tomcam wrote: post #266

gerdesj wrote: post #259

Earlier quoted context omitted.

(Sorry, misty eyed recollection alert) I should point out that "pies" in the UK is a rather generic term. MBOs (mince beef and onion), sausage rolls, pasties, pork pies and quiche was made in this south Devon based factory, near Plymouth. It was a good corp citizen thing to attend the 1100 "taste panel" which was part of the quality process. Obviously Product Dev, QA and the line crews could not mark their own work s…

That was far better than I could have hoped for. Thank you. I’m trying to understand what benighted people are not fond of pork pies and pastries. Let’s have a moment of silence for them and move on.

Post by disgruntledphd2 » Tue, Jan 05, 2021, 2:59 PM UTC

wodenokoto wrote: post #280

disgruntledphd2 wrote: post #257

Earlier quoted context omitted.

Ok fair enough, I only used notebooks when I can't avoid it. I'm pretty sure you don't get a repl by default though, is there an involved set up in jupyter?

jupyter console --existing should start ipython in your terminal and connect to the last started kernel (e.g., the one in the notebook you just started) https://stackoverflow.com/questions/22447572/connect-termina... For jupyter lab, you just choose to start a repl from the gui and choose an existing kernel.

Post by mch82 » Thu, Jan 07, 2021, 8:46 PM UTC

everling wrote: post #211

mch82 wrote: post #49

Earlier quoted context omitted.

> problem #1: Environment management Great observation. Python environment management is getting simpler, but is off putting for people without a software background. Unclear even CS majors get enough classroom exposure to package & dependency management to utilize Python efficiently. I’m more optimistic about an on-prem deployment of Jupyter Notebooks or Sage Math Cloud as a way to hide a lot of the setup complexity…

Quant here, at my firm we've deployed a JupyterHub server which provides users with a production docker image, so that analysts and portfolio managers can perform analyses without installing python, dependencies and sql drivers locally. It is working well and spurs interest in Python across the wider org - so we let everyone use it. Similar to in OP's case, I think the real selling point of Python over Excel is advan…