Icon

Ricavare le categorie merceologiche degli ordini di Amazon con un LLM locale

Vi siete mai chiesti quanto avete speso su amazon.it da quando siete iscritti e, soprattutto, cosa avete comprato?

Have you ever wondered how much you've spent on amazon.it since you signed up, and more importantly, what you’ve bought?

I believe that, for the second question, not everyone knows which categories of items have had the most impact on the total of their purchases, and it’s not easy to determine this just from the order list—simply because it’s not included.

Our favorite tool comes to the rescue, along with Ollama, an interface that allows the use of local LLM models. Specifically, we will use LLama 3.1, which will help us find the corresponding category based on the item descriptions.

This workflow enables precisely that, and it can be used with your order list by simply changing the file path in the CSV Reader node.

For more details on the process, you can read the article at the link below.

URL: Amazon: avete mai calcolato quanto spendete e cosa comprate? https://datasciencefacile.altervista.org/2024/09/07/amazon-avete-mai-calcolato-quanto-spendete-e-cosa-comprate/

Richiedere la lista dei propri ordini su amazon.it al link: https://www.amazon.it/hz/privacy-central/data-requests/preview.html Installare Ollama scaricando la versione per il proprio sistema operativo dal link: https://ollama.com/download al posto di Ollama si può utilizzare anche ChatGPT, inserendo le credenziali del servizio nel nodo Credential Configuration.
Selezionare la voce: Relative 100%
dummy credential
Credentials Configuration
Aggiusto discount
Column Expressions (legacy)
Importo ordini
CSV Reader
da stringa a date&time
String to Date&Time (deprecated)
ordini Closed
Row Filter
year monty
Date&Time Part Extractor
Preparo il Prompt
String Manipulation
Colonna categoria
Column Renamer
Sampling
Row Sampler
Top 10
Top k Row Filter
Pivot
Pivot
Grafico a torta
Pie Chart
Connect to Ollama Server
OpenAI LLM Selector
Authenticate to Ollama server
OpenAI Authenticator
Filtro Product Name
Column Filter
Ask questions and waiting responses
LLM Prompter

Nodes

Extensions

  • No modules found

Links