Spyder can't open dataframes with Pandas 1.3.0

[mhdmyz]

Issue Report Checklist

• Searched the issues page for similar reports
• Read the relevant sections of the Spyder Troubleshooting Guide and followed its advice
• Reproduced the issue after updating with conda update spyder (or pip, if not using Anaconda)
• Could not reproduce inside jupyter qtconsole (if console-related)
• Tried basic troubleshooting (if a bug/error)
  • Restarted Spyder
  • Reset preferences with spyder --reset
  • Reinstalled the latest version of Anaconda
  • Tried the other applicable steps from the Troubleshooting Guide
• Completed the Problem Description, Steps to Reproduce and Version sections below

Problem Description

When I open a dataframe in the variables explorer, I get the following error:

Spyder was unable to retrieve the value of this variable from the console.

The error message was:
An error occured, see the console..

I think this happened after updating my pandas to 1.3.0

What steps reproduce the problem?

What is the expected output? What do you see instead?

Paste Traceback/Error Below (if applicable)

PASTE TRACEBACK HERE

Versions

• Spyder version: 5.0.5
• Python version: 3.9.5
• Qt version:
• PyQt version:
• Operating System name/version: macOS 11.4

Dependencies

PASTE DEPENDENCIES HERE

[steff456]

Hi @mhdmyz,

If you create a new environment with the previous version of Pandas it is working as expected?

Thanks for reporting!

[mhdmyz]

Yeah! In fact I downgraded my pandas version back to 1.2.5 and the problem was resolved. There should be some inconsistency with the latest release of pandas.

[steff456]

We'll look into this for one of our next releases.

[ccordoba12]

@mhdmyz, are you using our macOS installer? Or how did you install Spyder?

[mhdmyz]

@mhdmyz, are you using our macOS installer? Or how did you install Spyder?

Yeah, I installed Spyder using the dmg file.

[stonebig]

it seems to work on windows.

[stonebig]

there is a streamlit patch for pandas-1.3.0, but I don't find if the problem and solution applies to Spyder https://github.com/streamlit/streamlit/pull/3536/files