'Unable to view dataframes in Spyder's variable explorer "Can't get attribute '_unpickle_block' on"

I'm using Python 3.8.13 and Pandas 1.4.1 on Spyder 4.1.5.

I have no problem reading the dataframe into memory, but when I try to open the dataframe for viewing in the variable explorer I get the following:

"Spyder was unable to retrieve the value of this variable from the console. The error message was: Can't get attribute '_unpickle_block' on".

This is regardless of size (e.g. if I create a variable containing just the head of the dataset, the issue persists). Not sure why this specific error is showing as I don't believe I'm using a pickled object at any point.

I've confirmed that I can open the dataframe when using a Python 3.9 env with Spyder 5.1.5, but I need to use the former specs given they're locked in on a virtual machine. Here's my code as of now (very straightforward):

import pandas as pd
import numpy as np

filepath = "../../../projects2/"

df = pd.read_parquet(filepath + "hmda/lar/parquet/hmda_lar_2017.parquet")


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source