That sort of workflow sounds a lot like what you would get from a notebook like ...

That sort of workflow sounds a lot like what you would get from a notebook like Jupyter, albeit you would have explicit block of code ("cells") to be executed together.

It looks like Spyder now features Jupyter Notebook integration as well: https://github.com/spyder-ide/spyder-notebook