Spyder - Anaconda is terrible slow

[korosig]

I have installed Spyder 4.1.5 (behind Anaconda), and when I open a large CSV file, the Spyder IDE is working with terrible slow speed. For example for df.info(), df.describe() I have to wait minutes. While I search for the solution for this problem, I have installed the Sypder 5.0.3 which is works well, but It is not supported by Anaconda, and I have a problem with package access.

My questions are:

• Why Syder 4.1.5 (behind Anaconda) is superslow with DataFrames
• How can I setup Spyder 5.0.3 to use the same environment as Spyder 4.1.5 (behind Anaconda)

My machine has iCore 9, 64Gb mem, with 1T SSD and 2x3080GeFroce so the hardware is not the bottleneck.....

Python 3.8.5 (default, Sep 3 2020, 21:29:08) [MSC v.1916 64 bit (AMD64)] IPython 7.22.0 conda 4.10.1 Anaconda Navigator 1.10.1

[korosig]

Hi

I have installed Spyder 5 (behind Anaconda) and I got the same problem. I tested my script in Jupiter and it works fast.

I did the next things: I loaded a 1.3 Gb CSV with pandas, and then I use df.info(), df.columns, etc. It is often freezing or, I have to wait minutes to run. By comparison, in jupyterlab, this runs in seconds.

tested with (Python 3.8.8 , IPython 7.22.0 , Spyder 4.2.5, pandas 1.2.4) - very slow tested with (Python 3.9.5 , IPython 7.22.0 , Spyder 5.0.0, pandas 1.2.4) - very slow

tested with (Python 3.8.8 , Jupyter lab 3.0.14, pandas 1.2.4) - Fast

I reinstalled ANACONDA, SPYDER, PYTHON, and all packages....