CODEWITHSUNDEEP
pythonpandasuser-interfacepyqtinteractive
rhaskett
rhaskett

Reputation: 1962

Semi-Interactive Pandas Dataframe in a GUI

There are a number of excellent answers to this question GUIs for displaying dataframes, but what I'm looking to do is a bit more advanced.

I'd like to display a dataframe, but have a couple of the columns be interactive where the user can manually overwrite values (and the rest be static). It would be useful to have "total" rows that change with the overwritten values and eventually have some interactive buttons around the dataframe for loading and clearing data.

QTPandas looks promising, but appears to be dead as it is build off of a really old version of Pandas (0.17.1). Can this be done in QT? Is something else better?

Upvotes: 1

Views: 3078

Answers (2)

Dr Nisha Arora
Dr Nisha Arora

Reputation: 738

I love Rstudio as my IDE as I can not only view all objects created but I can also edit data in the IDE itself. There are many other great features too. And you can use R Studio for Python coding too (using reticulate package).

Spyder too gives this feature of viewing or editing the data frame.

However, if you're looking for a dedicated GUI with drag & drop features, you can use Pandas GUI. Features of pandasgui are:

  • View DataFrames and Series (with MultiIndex support)
  • Interactive plotting
  • Filtering
  • Statistical summary
  • Data editing and copy / paste
  • Import CSV files with drag & drop Search toolbar

It's first version was released in Mar 2019 & still developing. As of date, you can't use it in Colab

Upvotes: 1

rhaskett
rhaskett

Reputation: 1962

While not a GUI in itself, XLWings leveraged Excel as a GUI and makes pandas dataframes interactive for users and was our library of choice.

Upvotes: 0

Related Questions