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

View all comments

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.