I use Python for basic back end purposes, using numpy/pandas heavily. I’m now looking to build out a program that incorporates a GUI. For my program, I’m thinking about either using a Python related GUI such as Tkinter or Kivy, or learning JavaScript and building it out via html or using electron.
The program primarily revolves around a displayed data table. The cells (or boxes) of the data table should be editable by simply clicking on the box. The values in these cells will have conditional formatting applied (making the background change color for each cell).
A great bonus would be if the data could be easily inserted into a pandas dataframe in case I wanted to perform any further back end adjustments.
I’ve so far been dabbling in Kivy, but it doesn’t seem to handle dataframes and data table outputs very intuitively (I could be wrong about this and just need more experience with the program!).
What GUI solution might be best suited for my data table desires?
NOTE: Any solution I pick, I would like it to have minimal issues with licensing, etc. (I believe this is an issue with PyQT, but I could be wrong.)
Very baseline drawing of what the application could look like: