In such instances, all I have to do is select the data in Excel and write Python scripts inside the Jupyter Notebook to perform the relevant function.

Jupyter Notebook is not a full-blown development environment for Python. Many of the features you would expect to find in an IDE—e.g., interactive debugging, code completion, and module ...