Make Polars DataFrame be able to open on Variable Explorer.

[arturdaraujo]

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

Make Polars dataframe variables able to open a window with the data like Pandas.
https://github.com/pola-rs/polars

What steps reproduce the problem?

When looking the in Variable Explorer, under the Type column the Polars object is a internals.dataframe.frame.DataFrame. The ideal it would be a DataFrame like Pandas.

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

Paste Traceback/Error Below (if applicable)

PASTE TRACEBACK HERE

Versions

• Spyder version:
• Python version:
• Qt version:
• PyQt version:
• Operating System name/version:

Dependencies

PASTE DEPENDENCIES HERE

[abudden]

+1

Some screenshots to show the difference between polars and pandas:

Double clicking on the polars dataframe shows this, which isn't especially useful:

Similarly, using the example code from the getting started guide, the console printing seems a bit corrupted to me:

[arturdaraujo]

@abudden The dataframe format is now fixed in newer versions. The format is also more condensed. If you want it to use in this version you can set pl.Config.set_ascii_tables(True) or try pl.Config.set_tbl_formatting(“UTF8_FULL_CONDENSED”) which is the new default.

Take a look at:
https://pola-rs.github.io/polars/py-polars/html/reference/api/polars.Config.set_tbl_formatting.html#polars.Config.set_tbl_formatting

https://pola-rs.github.io/polars/py-polars/html/reference/config.html

[abudden]

@arturdaraujo Great, thanks for letting me know - I'll upgrade.

[abudden]

With 0.15.14, it looks better but still a little distorted; I guess this is something to do with my font (Envy Code R):

I'll probably just put up with it as the condensed formatting gets rid of most of the annoying intermediate lines so the small amount of distortion isn't a big deal. If it annoys me, I'll switch to ascii, which works fine.

Thanks again, and here's hoping for a variable explorer upgrade!

[arturdaraujo]

You are probably using some different font like I do (Ubuntu). Some fonts need pl.Config.set_ascii_tables(True) for being completely fine and removing annoying defects. You can set condensed and and still call ascii True (which is my case). In spyder preferences you can write that to be called on startup, so you don't have to manually do that every time.

[ccordoba12]

Hey @arturdaraujo, thanks for reporting. This is an interesting idea but we're quite understaffed at the moment, so we won't be able to work on it, sorry.

[juliangilbey]

A longer-term wishlist along these lines would be to bundle Polars with Spyder: it is quite likely that Polars will overtake Pandas in popularity in the coming few years.

[ccordoba12]

That's a good idea but I think we should add it to our installers because it doesn't make much sense to have it as a direct dependency (Spyder can work perfectly fine without it).