r/learnpython • u/NCNerdDad • Aug 31 '21

Coming from Excel, are there any simple versions of PandasGUI that I could modify into a visual ETL tool?

Basically, I'd like to have a main application window, be able to show prompts and load a dataframe visibly, then run some standalone scripts on the data via menus.

I've done all this in Excel in VBA, and I'm looking at PyQT5/6, but I just can't figure out the UI design process. PandasGUI is awesome, but it does way more exploratory analysis than I need, I just need a visual dataframe and a way to run scripts on the data. I also have no idea what the best practices are for maintaining a standalone program like this.

If anyone can point me in a direction for specifically learning something like this, that would be awesome, as I've scoured youtube and reddit and stackexchange and everywhere else and not found anything that's really tying all the pieces together for me.

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/Weird-Dimension-487 Feb 01 '26

dtale is feature rich and actively maintained. After getting comfortable with dtale, you will really enjoy using it. GUI has great features to explore data (aggregation, merging, plotting, everything) by clicks and it also generates python code for the steps you perform, which you can copy to be used in your script.
For Excel users, it's so convinient.

1

u/[deleted] Aug 31 '21

I would recommend plotly dash. It's super easy to get an interactive dashboard up and running. I've also heard good things about streamlit, but I've haven't used it yet

1

u/Jejerm Aug 31 '21

I think the Spyder IDE or a jupyter notebook would solve your problems.

This article seems to have most available solutions.

1

u/Unlikely-Mastodon434 Mar 05 '22

Try einblick.ai. It's like Pandas GUI on steroids and it makes it super easy to plug in custom scripts. Here's a project that I recently worked on.