How to do sales analysis to identify related products using Python?

Question

Python

Hello. I have data for a certain period of time in the form of an excel file.
Since I know a little bit of Python (at the course level on Coursera), I would like to use this language to analyze and find related products for each product.
How do I see it

• 1. This will be some kind of program with a gui interface that will be able to receive data from an excel file and select the data we need from it (invoice number, goods in this invoice, invoice date, product prices in the invoice, total invoice cost, cost price)
  
• 2. In the program, it will be possible to filter data by dates, by the number of goods in the invoice, the number of invoices by goods, and other sortings.
  
• 3. Data output to excel, or a table inside gui.
  
• 4. Data that I would like to see. Let's say I choose 1 product, and I want to see the top five products that were with this product in one invoice. What was the income from these goods for a certain date of time?
  

Approximately in this way.
Question:
What tools (modules) can be used for this? Where to store data? How would you conduct such an analysis?

Answer 1

IMHO, for the coursera level, the task is strong ...
for gui -- pyqt5
store in the database -- sqlite
for excel -- try www.python-excel.org
for finding related products, look for information in the book "Programming the Collective Mind"

Answer 2

Sobsno, why is python here? All these actions can be done immediately in Excel, you just need to study the Excel toolkit and you will be happy for analysis.