Visualize your Python code while you type it in PyCharm, Emacs, Sublime Text, or even your browser. Live coding tightens the feedback loop between making a change to your code and seeing the behaviour ...
When aggregating Excel or CSV data for work, I often use Jupyter Notebook because it allows me to check results in real-time while writing code. Previously, I used Anaconda to set up that environment.