The Python language is best suited to your needs.

IDE: pycharm,Eric,PyScripter, etc.

DataAnalysis lib: NumPy,Pandas,Matplotlib,IPython, etc.

https://www.jetbrains.com/pycharm/

https://sourceforge.net/projects/eric-ide/