Spyder is a free and open source scientific environment for Python. It combines advanced editing, analysis, debugging, and profiling, with data exploration, interactive execution, deep inspection, and visualization capabilities. Spyder is sponsored by open source supporters QuanSight, and NumFOCUS, as well as individual donors.
Spyder is an open-source Python IDE designed for the movement of data science work. Spyder comes with an Anaconda package manager distribution, so depending on your setup you may have installed it on your machine.
Spyder includes most of the "standard IDE" features you can expect, such as a strong syntax code editor, Python code rendering, and an integrated text browser.
Spyder is used when we want to develop a code that is useful and able to explore proper documentation of the code that has been written. We use Spyder to perform data-related operations like filtration, cleaning, and enhancing the data qualities. There some cases where it is less appropriate like working in an environment, creating dashboards of data visualizations and plots.
I would recommend Vim in any scenario where text files have to be viewed, created, or edited on GNU/Linux computers. Regardless if you need to quickly change a few things in a configuration file, or you need to write up a full document, Vim is great. I wouldn't use Vim to view, edit, or create anything that requires "rich-text". In other words, if you need to format the text (bolding, font colours, word-art, etc), then Vim isn't the tool to use.
It is fairly straightforward to use. Pretty much good to go as soon as you install it. The IDE itself is very user friendly, and it is only limited by whatever limitations Python has as a language. Great for those who want to run their scripts quickly or do some Python programming without fussing.
I don't consider the steep learning curve to be a hinderance on the overall usability. I would rate this a ten, but to be honest a lot of people do get hung up at the beginning and just abandon it. However, for people who have made the moderate effort to get over the hump, nothing can be more usable.
Most of data scientists or data engineers are either using ec2 on the cloud or Atom or PyCharm locally. It is a bit hard to find people who are still using Spyder and have the sight of the IDE and can help you to answer your question.
There is no commercial support for Vim. Thus, it will not get a mark beyond 5. However, community support is very good. You can easily find solutions for most of the problems in the community.
I think Spyder doesn't stack up as well as other IDEs due to its many limitations. But it is available for free and that is one advantage it has over its competitors
Vim's keybindings are a lot more complex than Notepad++. With that, comes a whole bunch of capability that Notepad++ just can't match. Emacs is comparable, in terms of capabilities--because Vim is built into so many unix systems, I chose to learn it instead of Emacs. Knowing both probably isn't a bad idea, but there's enough to learn in either camp to keep you busy