/Personal_Proj_Consume_Analyzer

Primary LanguageJupyter Notebook

Personal_Proj_Consume_Analyzer - Groceries analyzer

Description

This algorithm aim to analyze groceries purchase, price and his variations.

The project is divided in 5 parts:

  1. Aquire data
  • PDF ( nota potiguar, Manual - Could web scrapping be a better option?)
  1. Load data in
  • Load PDF
    • Read table
    • Read store information
    • Read data/time information
  1. Store data
  • Store data in MySql
    • Install docker
    • Create container
    • Install MySqlWorkbench
      • Create table
    • Ipybn
      • Connect to main.ipynb
  1. Process data
  • Group stores
  • Group products by category ( categoryze by processment type )
  1. Show results
  • Show price variation ( Variation, man, seasonality )
  • Show costly categories
  • Rank products
  1. Posterior ideas
  • Suggest substitutes based on price seasonality
  • ML for actegorization?