Apostas na Lotofácil [ETL & Automação].ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "fec9bc09",
   "metadata": {},
   "source": [
    "# Carmilla\n",
    "\n",
    "### Projeto que gera números da Lotofacil da Caixa Econômica Federal\n",
    "###### O projeto é para fins de estudos.\n",
    "\n",
    "- História:\n",
    "    - Porque não criar uma plataforma de *geração de números livres* para *possíveis jogos* e usar as *estatística para direcionar os casos*.\n",
    "\n",
    "- Pré-requisitos:\n",
    "    - Anaconda;\n",
    "    - Jupyter;\n",
    "    - Python 3.6 ou superior;\n",
    "    - Bibliotecas iteration_utilities e pandas;\n",
    "\n",
    "- Sistemas implementados:\n",
    "    - Contador de ciclos\n",
    "    - Verificação de pares e ímpares\n",
    "    - Otimização de geração de números\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "38fac27f",
   "metadata": {},
   "source": [
    "### Bibliotecas do Projeto"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "490323be",
   "metadata": {},
   "outputs": [],
   "source": [
    "#!pip install iteration_utilities pandas selenium\n",
    "from pandas import pandas as pd                         #-> Biblioteca para manipular o *.xlsx.\n",
    "import random                               #-> Biblioteca para gerar sequências de números.\n",
    "from iteration_utilities import duplicates  #-> Biblioteca para remover as duplicatas.\n",
    "from selenium import webdriver as wb        #-> Biblioteca para baixar a planilha.\n",
    "from selenium.webdriver.common.by import By #-> Biblioteca para passar como chave de procura o XPATH."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7cdc7a5d",
   "metadata": {},
   "outputs": [],
   "source": [
    "navegador = wb.Chrome() #Abre o navegador\n",
    "navegador.get(\"https://asloterias.com.br/download-todos-resultados-lotofacil\") #Acessa o link\n",
    "navegador.find_element(By.XPATH, '/html/body/main/div[2]/div/div/div[1]/div[5]/a').click() # Localizador do botão para \n",
    "#baixar a planilha loto_facil_asloterias_ate_concurso_2741_sorteio.xlsx -> loto_facil_asloterias_ate_concurso_*_sorteio.xlsx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0d54b68d",
   "metadata": {},
   "outputs": [],
   "source": [
    "planilha = 'loto_facil_asloterias_ate_concurso_2743_sorteio.xlsx' #Ultima planilha atualizada.\n",
    "\n",
    "df = pd.read_excel(planilha, header=6)#Saber em qual concurso está para atualizar o número no nome da planilha.\n",
    "\n",
    "def transformacao(df: pd)  -> list[list]:\n",
    "    aux = [\"bola 1\", \"bola 2\",\"bola 3\",\"bola 4\",\"bola 5\",\"bola 6\",\"bola 7\",\"bola 8\",\"bola 9\",\"bola 10\",\"bola 11\",\"bola 12\",\"bola 13\",\"bola 14\",\"bola 15\"]\n",
    "\n",
    "    lista, sorteio = [], []\n",
    "    \n",
    "    for j in range(0,len(df[0:])):\n",
    "        for i in aux: lista.append(df[i][j])\n",
    "\n",
    "        lista = sorted(lista)\n",
    "        sorteio.append(lista)\n",
    "        lista = []\n",
    "    return sorteio\n",
    "\n",
    " # valores\n",
    "#[[1, 2, 3, 4, 8, 9, 10, 11, 13, 15, 19, 20, 23, 24, 25], [2, 3, 4, 7, 8, 10, 11, 12, 13, 19, 20, 21, 22, 23, 24], [3, 6, 7, 8, 9, 11, 12, 13, 15, 16, 18, 19, 20, 21, 25], [1, 4, 5, 6, 7, 8, 9, 10, 11, 12, 17, 18, 23, 24, 25]...]\n",
    "\n",
    "\n",
    "def equi_par_impar(lista:list) -> bool:\n",
    "    p, i = 0, 0\n",
    "    for j in lista:\n",
    "        if(j % 2 == 0): p += 1 \n",
    "        else: i += 1\n",
    "    if((p == 8 and i == 7) or (p == 6 and i == 9) or (p == 7 and i == 8)): return True\n",
    "    else: return False\n",
    "\n",
    "#quantidade de impares e pares\n",
    "    #40% tiveram 8 pares e 7 ímpares.\n",
    "    #40% tiveram 6 pares e 9 ímpares.\n",
    "    #20% tiveram 7 pares e 8 ímpares.\n",
    "\n",
    "\n",
    "def sort_num_apost(valores: list, transf: list[bool,list]) -> list:\n",
    "    #inicio das variaveis\n",
    "    response = []\n",
    "    num_sort = range(1,26)\n",
    "    \n",
    "    while(True):\n",
    "        #tecnica de otimizacao, se eu sei quais numeros falta, vou inserilos. isso se a lista não for vazia\n",
    "        if(not(transf[0])): \n",
    "            response = random.sample(num_sort,15)\n",
    "            return(response)\n",
    "        \n",
    "        numDeNumerosQueVaiSerAdicionado = random.randint(1, len(transf[1]))\n",
    "        response = random.sample(transf[1], numDeNumerosQueVaiSerAdicionado)# min 1, max len(transf[1])(lista que falta para sortear)\n",
    "        \n",
    "        #adicione o restante dos numeros para formar 15 dezenas\n",
    "        for i in random.sample(num_sort,(15 - len(response))):\n",
    "            response.append(i)\n",
    "        \n",
    "        #precisamos verificar se não veio repetido\n",
    "        aux = len(list(duplicates(response)))\n",
    "        while(aux != 0):\n",
    "            response = list(duplicates(response))\n",
    "            \n",
    "            for i in random.sample(num_sort, aux):#a nova quantidade a ser inserida é o resultado do aux(\"auxiliar\")\n",
    "                response.append(i)\n",
    "            aux = len(list(duplicates(response)))\n",
    "        \n",
    "        if(not(response in valores)):# se os números gerados já foi sortiado as chances de ser sorteado novamente são muito baixas então descartamos.\n",
    "            if(equi_par_impar(response)):# se os números gerados não bater com a estatística é melhor descartar.\n",
    "                break\n",
    "    response = sorted(response)\n",
    "    return(response)\n",
    "#valores = transformacao(df)\n",
    "#teste = sort_num_apost(valores)\n",
    "#teste\n",
    "#[22, 1, 16, 5, 15, 19, 24, 13, 6, 2, 8, 10, 21, 4, 9]\n",
    "\n",
    "def transformacaoComConcursos(df: pd) -> list[dict]:\n",
    "    aux = [\"Concurso\", \"bola 1\", \"bola 2\",\"bola 3\",\"bola 4\",\"bola 5\",\"bola 6\",\"bola 7\",\"bola 8\",\"bola 9\",\"bola 10\",\"bola 11\",\"bola 12\",\"bola 13\",\"bola 14\",\"bola 15\"]\n",
    "    lista, sorteio = [], []\n",
    "    dicio = {}\n",
    "    \n",
    "    for j in range(0,len(df[0:])):\n",
    "        for i in aux: \n",
    "            lista.append(df[i][j])\n",
    "        dicio = {\"Concurso\" : lista[0], \"sorteio\" : sorted(lista[1:])}\n",
    "        sorteio.append(dicio)\n",
    "        lista = []\n",
    "        dicio = {}\n",
    "\n",
    "    return sorteio\n",
    "#[{'Concurso': 2703,\n",
    "#  'sorteio': [1, 2, 5, 7, 9, 10, 12, 13, 14, 17, 19, 20, 21, 23, 24]},\n",
    "# {'Concurso': 2702,\n",
    "#  'sorteio': [1, 2, 4, 6, 7, 10, 14, 15, 16, 17, 18, 19, 21, 23, 25]},\n",
    "# {'Concurso': 2701,\n",
    "#  'sorteio': [1, 3, 4, 5, 7, 9, 12, 14, 16, 18, 19, 21, 22, 23, 25]},...]\n",
    "\n",
    "def calculoDeCiclo(df: pd) -> list[bool,list]:\n",
    "    trans = transformacaoComConcursos(df)\n",
    "    ciclo = [i for i in range(1, 26)]\n",
    "    control = False # imagine que o ciclo seja vazio([]), significa que não há elementos que podem ser os \"favoritos\" para os próximos concursos, ou seja o ciclo voltou a ser renovado. Então seto Falso para que seja falso a ideia de que tenha números que sejam favoritos.\n",
    "\n",
    "    for i in trans[::-1]:\n",
    "        if (ciclo == []): \n",
    "            ciclo = [i for i in range(1, 26)] # se o ciclo for vazio é porque precisa ser sorteado tudo novamente\n",
    "            control = False\n",
    "        else: control = True\n",
    "\n",
    "        for j in i[\"sorteio\"]:\n",
    "            if(j in ciclo):\n",
    "                ciclo.remove(j)\n",
    "\n",
    "    return [control, ciclo]\n",
    "\n",
    "#[3, 8, 11, 22]\n",
    "#True\n",
    "# A ideia é que se for verdade, os jogos gerados tem que conter esses números\n",
    "\n",
    "def main():\n",
    "    valores = transformacao(df)\n",
    "    transf = calculoDeCiclo(df)\n",
    "    a = 0\n",
    "    aux = []\n",
    "    while(True):\n",
    "        a = int(input(\"Quantas apostas quer fazer?\\n\"))\n",
    "        print(\"\\n\")\n",
    "        for i in range(a):\n",
    "            aux = sort_num_apost(valores, transf)\n",
    "            \n",
    "            print(sorted(aux))\n",
    "            print(\"\\n\")\n",
    "        break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7a998886",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantas apostas quer fazer?\n",
      "10\n",
      "\n",
      "\n",
      "[2, 3, 4, 5, 6, 8, 9, 13, 14, 16, 17, 19, 20, 21, 22]\n",
      "\n",
      "\n",
      "[2, 3, 5, 6, 8, 9, 11, 12, 13, 15, 17, 19, 20, 21, 22]\n",
      "\n",
      "\n",
      "[2, 3, 4, 6, 7, 9, 10, 11, 16, 17, 19, 21, 23, 24, 25]\n",
      "\n",
      "\n",
      "[1, 3, 6, 8, 9, 11, 14, 15, 16, 19, 20, 21, 22, 24, 25]\n",
      "\n",
      "\n",
      "[3, 4, 5, 8, 9, 11, 12, 14, 15, 17, 19, 20, 21, 22, 24]\n",
      "\n",
      "\n",
      "[4, 7, 9, 11, 12, 14, 16, 17, 18, 19, 20, 21, 23, 24, 25]\n",
      "\n",
      "\n",
      "[1, 2, 4, 9, 10, 11, 12, 13, 15, 16, 20, 21, 22, 23, 24]\n",
      "\n",
      "\n",
      "[3, 4, 6, 8, 9, 10, 11, 13, 14, 16, 17, 18, 21, 23, 25]\n",
      "\n",
      "\n",
      "[3, 4, 8, 9, 10, 11, 13, 14, 15, 17, 18, 21, 22, 24, 25]\n",
      "\n",
      "\n",
      "[2, 3, 4, 6, 7, 8, 9, 11, 13, 16, 17, 18, 21, 23, 25]\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "if __name__ == \"__main__\":\n",
    "    main()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  },
  "vscode": {
   "interpreter": {
    "hash": "52a0e7b4f4c9b93c7568b039447b72228aa9ad72b6466ebee46731f7fd73c837"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}