Writing a Windows program to replace several engineering excel spreadsheets
A good way to learn, maybe a less good way to solve the said problem.
GUI - ?
Matplotlib can be used for the graphs.
Exporting to excel can be done easily in pandas with df.to_excel()
weasyprint library can be used to export to pdf.
I want to write a program for Windows using python and python frameworks (pandas, numpy etc.), which I want to use to replace several engineering excel spreadsheets (which are repetitive). Please point me in the right direction regarding which python frameworks to use.
The program should contain and be able to do the following:
- Have a GUI to input variables
- Compute excel formulas using said variables
- Create graphs
- Export information to excel spreadsheets
- Create PDFs
I know I can set up a single excel spreadsheet to do the above, but I'm using this as a way to learn programming...