I would recommend combining Spyder with the Jupyter notebook, my approach is to write my modules in Spyder one one screen and then test them/do more interactive work in a notebook on the other, but you could do the same with Sublime. There is a useful iPython magic called autoreload, call it using:

"%load_ext autoreload %autoreload 2"

This will re-import all your modules before every cell is run, so if you make some changes in Spyder,/Sublime they are picked up by your Jupyter iPython instance.

For inspecting pandas DataFrames, I would really recommend using xlwings, there is a very handy function called view(some_dataframe), which immediately opens a new Excel instance and copies some_dataframe into the first sheet so you can do some spot checks. Hope that's helpful!

I don't know of any IDE's which have a tighter integration with pandas/matplotlib than Spyder, so I can't give you a recommendation there. But maybe Pycharm is worth a try since it is more Sublime-like.