I would specifically recommend basing your application on Pandas which will handle the vast majority of the work for you. You will be amazed at what you will be able to get done with only a few lines of code.

Pandas can load the data from either Excel xslx files or csv files (and a lot of other places)

If you structure your code well you can have a cross platform command line program, a GUI desktop program, a Jupyter Notebook and a web service all with the vast majority of the code in common.

A jupyter notebook is a great place to start developing your code and may be all that you need.

Some plug-ins & resources that can help: - pandas-summary (for a rapid overview of the data): https://github.com/mouradmourafiq/pandas-summary - pandasgui (for exploring what you would like to do): https://github.com/adamerose/pandasgui - Pandas-Bokeh (plotting): https://github.com/PatrikHlobil/Pandas-Bokeh - plot.ly (plotting): https://plotly.com/python/pandas-backend/ - wxPython (for a desktop GUI): https://wxpython.org/

PythonStack

More stacks from Steve Barnes