For the second point, I've had a lot of success doing this with a Jupiter notebook. It's not an IDE by any means but it's very productive for exploratory work,

For the second point, I've had a lot of success doing this with a Jupiter notebook. It's not an IDE by any means but it's very productive for exploratory work, and when you need horsepower you just spin up the kernel on a beefier cloud machine.