No column suggestion in pandas methods

[ntluong95]

System details:

Positron and OS details:

Positron Version: 2024.12.0 (system setup) build 41
Code - OSS Version: 1.93.0
Commit: 39536c2
Date: 2024-11-21T02:47:00.983Z
Electron: 30.4.0
Chromium: 124.0.6367.243
Node.js: 20.15.1
V8: 12.4.254.20-electron.0
OS: Windows_NT x64 10.0.22621

Interpreter details:

R 4.4.2 or Python 3.12.6

Describe the issue:

A very important feature of an IDE is to suggest columns in a dataframe, so user don't need to type (slower, prone to typo). Currently Positron doesn't support it which I think we can improve the user experience. As an R user, I am very much looking for it. The feature has been implemented in DataSpell IDE

Steps to reproduce the issue:

1. Import any pandas dataframe
2. Try to filter, query on the dataframe

Expected or desired behavior:

In filter method

In query method

[lbeiby]

This feature is very much needed. In PyCharm/DataSpell, JetBrain they have implemented a runtime analysis, which allowing for column completion for a wide variety of dataframe like pandas, polars, pyspark

[seeM]

When implementing this, we might also be able to offer completing lists of columns via dict access e.g. df[[""]] (requested in #5413 (comment)).

[ntluong95]

When implementing this, we might also be able to offer completing lists of columns via dict access e.g. df[[""]] (requested in #5413 (comment)).

That would be great. Column completion through dict access in pandas, or through pl.col(), or in query() method of Pandas is very much needed I guess