There’s many different styles of programming. Excel and Jupyter notebooks are a kind of “end user computing”. Programs developed in those environments often need a lot of refactoring to get turned into “software” (by some arbitrary definition). However these programs are incredibly useful for the business ideas they explore.
To put it another way, using Notebooks with pandas is a great way to wrote biology programs. Using Notebooks to write pandas is a terrible way to write software.
Yeah I found this out indeed, by transitioning from data science to software development, there was an interesting time in between where I couldn’t let go of the notebook concept but I now certainly have. That said, the notebooks got me started in programming and did so in a way that I experienced as very gentle and with a flattened learning curve. I guess that was my point.
To put it another way, using Notebooks with pandas is a great way to wrote biology programs. Using Notebooks to write pandas is a terrible way to write software.