cant open a small dataframe

[surachitsarkar-kly]

cursor.execute(query1) rows = cursor.fetchall() column_names = [desc[0] for desc in cursor.description] #column_names[3]="payload" df = pd.DataFrame(rows, columns=column_names) col=df.columns

[jitseniesen]

Hi @surachitsarkar-kly , I am afraid that we need more information before we can help you. That is why we provide a long template when you open a new issue. In particular, we need to know what happens when you open the dataframe. Do you get an error, and if so, what is it? We also need to know what version of Spyder you have and probably what version of Pandas. It would also really help to have a reproducible example, or at least to know what cursor in your code is and what the dataframe df looks like.

In absence of any further information, the only advice that I can give you is to upgrade Spyder. In particular Spyder version 5.4.2 and earlier have a problem with Pandas version 2, which leads to an error message mentioning iteritems. Upgrading Spyder solves that.

[jitseniesen]

Closing due to lack of followup.