Gaio DataOS
English
English
  • Welcome to the Gaio Platform documentation!
  • Documentação
    • General information
      • Functioning Structure
      • Login
      • Home page
    • Applications
    • Studio
      • Suit
      • Data Sources
      • Tasks
        • ETL
          • Builder
          • SQL
          • SQL External
          • Insert Table
          • Insert Row
          • Update
          • Delete
          • Create Table
          • Quick Table
          • pivot table
          • Unpivot Table
          • Run Process
          • Rest
          • Parameters to Table
          • Table to Parameters
          • Users
          • CSV Web
          • Google Planilhas
        • Analytics
          • Sample
          • AutoML
          • Scoring
          • Cluster
          • Main Components
          • Association Rules
          • Time Series
          • Python
        • Delivery
          • Report
          • Power Search
          • Content
          • Form
          • Exportar Output
          • Banner
          • Export CSV
          • Map
          • Insights
          • API
          • SMS
          • Whatsapp
          • Email
          • Network
      • Parameters
      • Forms
      • Files
      • Action Buttons
      • Top Menu
        • SQL
        • Edit Bucket Tables
        • Executions in Progress
        • Map Editor
        • Schedule
        • Models
        • Cognitive
        • Error log
        • Edit Dashboard
        • Chat - GPS
        • General Menu
    • Administration
      • Permissions
      • Users
      • Data Sources
      • Repositories
        • Creation
        • Data Management
      • Sharing
      • Schedules
      • Logs
    • Keyboard Shortcuts
  • Integrações
    • LDAP
  • HUB
    • Exemplos
      • Tarefa Conteúdo
        • Manual Form
  • FAQ
  • Gestão de Servidor
    • Gaio startup
  • What's New!
    • Release Notes
      • 2022
  • Import
    • Editor de Mapas
    • Parâmetros
    • Formulários
    • Processos
    • Editar Dashboard
    • Administração
      • Usuários
        • Permissões
      • Fontes de Dados
      • Repositórios
        • Criação
        • Gestão de Dados
      • Compartilhamento
      • Agendamento
      • Log
    • Consulta
Powered by GitBook
On this page
  • 1. Configuration
  • 2. Results
  1. Documentação
  2. Studio
  3. Tasks
  4. Analytics

Association Rules

PreviousMain ComponentsNextTime Series

Last updated 1 year ago

Very popular on ecommerce sites, Association Rules or Basket Analysis identify relationships between products. This type of technique makes it possible to offer products that other people have purchased when browsing a specific product page.

Many other applications are possible with this type of technique, such as identifying fraud in tenders (associations between participating companies), identifying affinities between people, among other applications.

Gaio uses to perform the calculations.

1. Configuration

  1. Set the task name.

  2. Define the name of the table to be generated with the rules.

  3. Minimum Support : amount of sales in which the two "products" were together divided by total sales.

  4. Minimum Confidence : Given that product A was sold, what is the probability that B will be sold?

  5. Transaction ID : This is the column that needs to be informed, containing the "sale code".

  6. Item ID : Here the column containing the “product” identification must be highlighted.

Having configured this information, the task can be run to search for associations.

2. Results

As a result of executing the technique, a table containing the associations is generated. Each line represents an association found based on two defined criteria (minimum support and minimum confidence).

  1. antecedents : In this column appear one or more "products" that, if "purchased", increase the probability of what is in the consequents being purchased.

  2. consequents: Here are presented the "products" that are enhanced if the antecedents are sold.

The columns with relationship statistics are:

Indicator

Formula

Variation

support(A->B)

support(A+B)

0 to 1

confidence(A->B)

support(A+B) / support(A)

0 to 1

lift(A->B)

confidence(A->B) / support(B)

0 to information

leverage(A->B)

support(A->B) – support(A)*support(B)

0 to 1

conviction

[1 – support(B)] / [1 – confidence(A->B)]

0 to information

To identify associations between your data, click on the table that contains at least two columns (Transaction and Item), access the and choose the Association Rules task.

Tasks menu
Pycaret