I'm a big fan of Python for data analysis ... could be its "killer app," the thing you would want to use R and the Tidyverse ...
Overview PyCharm, DataSpell, and VS Code offer strong features for large projects.JupyterLab and Google Colab simplify data ...