Skip to content

Instantly share code, notes, and snippets.

@gilberto-009199

gilberto-009199/phopreta_numeros_que_mais_aparecem.ipynb

Created November 9, 2023 02:23
Show Gist options
  • Save gilberto-009199/3531218a1fdc3d144ff71297cde86bb1 to your computer and use it in GitHub Desktop.
Save gilberto-009199/3531218a1fdc3d144ff71297cde86bb1 to your computer and use it in GitHub Desktop.
Download ZIP
phopreta_numeros_que_mais_aparecem.ipynb
Display the source blob
Display the rendered blob
Raw
phopreta_numeros_que_mais_aparecem.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"provenance": [],
"authorship_tag": "ABX9TyOUAgWSHXoBGSfws3pu+54j",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/gilberto-009199/3531218a1fdc3d144ff71297cde86bb1/phopreta_numeros_que_mais_aparecem.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"source": [
"# Phopreta Tests"
],
"metadata": {
"id": "boGchH5TugtB"
}
},
{
"cell_type": "code",
"source": [
"import os\n",
"import pandas as pd\n",
"from IPython.display import display, HTML"
],
"metadata": {
"id": "JkfIPOS819i8"
},
"execution_count": 6,
"outputs": []
},
{
"cell_type": "markdown",
"source": [
"## Como Testar:\n",
"\n",
" Suba o seu **dataset** no **Gist** e cole a url **Abaixo**:\n",
"\n",
"+ **Passo** 1(Copiar a tabela, Ctrl + A, Ctrl + C):\n",
" ![Copiar a Tabela](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE01.png)\n",
"\n",
"+ **Passo** 2(Criar um gist):\n",
" </br> visite o site [gist github](https://gist.github.com/)\n",
" ![Copiar a Tabela](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE02.png)\n",
" Talves seja necessario **criar** uma **conta**\n",
"\n",
"+ **Passo** 3(Criar um arquivo .txt):\n",
" </br> Escreva no campo data.txt,\n",
" ![Copiar a Tabela](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE03.gif)\n",
"\n",
"+ **Passo** 4(Criar):\n",
" </br> Crie um gist **publico**\n",
" ![Copiar a Tabela](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE04.gif)\n",
"\n",
"+ **Passo** 5(Copie a URL):\n",
" ![Copiar a Tabela](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE06.gif)\n",
"\n",
"+ **Passo** 6(Copie a URL):\n",
" ![Postar URL](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/EXAMPLE07.gif)\n"
],
"metadata": {
"id": "DgGONZXU51ES"
}
},
{
"cell_type": "markdown",
"source": [
"## Regra Numeros que mais aparecem(16,17,18,19)\n",
"Distribuição em ordem do mais comum ao menos comum:\n",
"+ 20 - 1836\n",
"+ 10 - 1827\n",
"+ 11 - 1809\n",
"+ 25 - 1803\n",
"+ 13 - 1788\n",
"+ 24 - 1786\n",
"+ 14 - 1782\n",
"+ 3 - 1768\n",
"+ 5 - 1765\n",
"+ 4 - 1761\n",
"+ 9 - 1760\n",
"+ 22 - 1757\n",
"+ 12 - 1756\n",
"+ 1 - 1754\n",
"+ 2 - 1753\n",
"+ 18 - 1750\n",
"+ 19 - 1747\n",
"+ 21 - 1742\n",
"+ 15 - 1738\n",
"+ 17 - 1733\n",
"+ 7 - 1726\n",
"+ 23 - 1720\n",
"+ 6 - 1711\n",
"+ 8 - 1689\n",
"+ 16 - 1689\n",
"\n",
"**Regra 16 ATUAL.** Regra dos cinco números que mais saem até concurso 1763.\n",
"Do conjunto {02 10 11 13 24} devem estar obrigatoriamente presentes de dois a quatro\n",
"números nas combinações fornecidas. Resultados com nenhum, um ou todos números\n",
"desse conjunto devem ser descartados. ELIMINAR ESSA REGRA\n",
"\n",
"**Regra 16 NOVA** - INTRODUZIR. Regra dos cinco números que mais saem. A\n",
"partir da base de dados, o programa calculará os cinco números que mais se repetem\n",
"e, dentre eles, devem estar obrigatoriamente presentes de dois a quatro números nas\n",
"combinações fornecidas. Resultados com nenhum, um ou todos números desse\n",
"conjunto devem ser descartados.\n",
"\n",
"**Regra 17 ATUAL.** Regra dos dez números que mais saem até concurso 1763.\n",
"Do conjunto {01 02 03 04 10 11 13 20 22 24} devem estar obrigatoriamente presentes\n",
"de cinco a oito números nas combinações fornecidas. Resultados com nenhum,\n",
"apenas um, dois, três, quatro, nove ou todos números desse conjunto devem ser\n",
"descartados. ELIMINAR ESSA REGRA.\n",
"\n",
"**Regra 17 NOVA** - INTRODUZIR. Regra dos dez números que mais saem. A\n",
"partir da base de dados, o programa calculará os dez números que mais se repetem e,\n",
"dentre eles, devem estar obrigatoriamente presentes de cinco a oito números nas\n",
"combinações fornecidas. Resultados com nenhum, apenas um, dois, três, quatro, nove\n",
"ou todos números desse conjunto devem ser descartados.\n",
"\n",
"**Regra 18 ATUAL.** Regra dos quinze números que mais saem até concurso\n",
"1763 Do conjunto {01 02 03 04 05 10 11 13 14 17 18 20 22 24 25 } devem estar\n",
"obrigatoriamente presentes de oito a onze números nas combinações fornecidas.\n",
"Resultados com menos de oito ou mais de onze números desse conjunto devem ser\n",
"descartados. ELIMINAR ESSA REGRA.\"\n",
"\n",
"**Regra 18 NOVA** - INTRODUZIR. Regra dos quinze números que mais saem. A\n",
"partir da base de dados, o programa calculará os quinze números que mais se repetem\n",
"e, dentre eles, devem estar obrigatoriamente presentes de oito a onze números nas\n",
"combinações fornecidas. Resultados com menos de oito ou mais de onze números\n",
"desse conjunto devem ser descartados.\n",
"\n",
"**Regra 19 ATUAL.** Regra dos vinte números que mais saem até concurso 1763.\n",
"Do conjunto {01 02 03 04 05 10 11 12 13 14 15 17 18 19 20 21 22 23 24 25} devem\n",
"estar obrigatoriamente presentes de onze a treze números nas combinações\n",
"fornecidas. Resultados com menos de onze ou mais de treze números desse conjunto\n",
"devem ser descartados. ELIMINAR ESSA REGRA.\n",
"\n",
"**Regra 19 NOVA** - INTRODUZIR. Regra dos vinte números que mais saem. A\n",
"partir da base de dados, o programa calculará os vinte números que mais se repetem\n",
"e, dentre eles, devem estar obrigatoriamente presentes de onze a treze números nas\n",
"combinações fornecidas. Resultados com menos de onze ou mais de treze números\n",
"desse conjunto devem ser descartados.\n",
"\n",
"![form](https://filedn.com/l3HMwWFeFPE7q4xHdixbsqH/phopreta/CONCURSOSREPETIDOS.gif)"
],
"metadata": {
"id": "EN6kuHKLum_k"
}
},
{
"cell_type": "code",
"source": [
"mostCommonNumbers5 = [10, 11, 13, 20, 25]\n",
"mostCommonNumbers10 = [3, 4, 5, 10, 11, 13, 14, 20, 24, 25]\n",
"mostCommonNumbers15 = [1, 2, 3, 4, 5, 9, 10, 11, 12, 13, 14, 20, 22, 24, 25]\n",
"mostCommonNumbers20 = [1, 2, 3, 4, 5, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 24, 25]"
],
"metadata": {
"id": "NoIcsyzGXTbQ"
},
"execution_count": 7,
"outputs": []
},
{
"cell_type": "code",
"source": [
"# @markdown ## **REGRA 16**\n",
"URL_DAS_COMBINAÇÕES=\"https://gist.github.com/gilberto-009199/04a8e07673a424000091f0b169b3354a/raw/64f8be38d055c0243f506ea8fcb5bc264aba7c6f/data_not_duplicate_old_result.txt\" # @param {type:\"string\"}\n",
"df = pd.read_csv(URL_DAS_COMBINAÇÕES, delimiter= '\\t',header= None ,names = ['combinação', '1°', '2°', '3°', '4°', '5°', '6°', '7°', '8°', '9°', '10°', '11°', '12°', '13°', '14°', '15°'])\n",
"# @markdown Regra 16 ATUAL. Regra dos cinco números que mais saem até concurso 1763. Do conjunto {02 10 11 13 24} devem estar obrigatoriamente presentes de dois a quatro números nas combinações fornecidas. Resultados com nenhum, um ou todos números desse conjunto devem ser descartados. ELIMINAR ESSA REGRA\n",
"# @markdown\n",
"# @markdown Regra 16 NOVA - INTRODUZIR. Regra dos cinco números que mais saem. A partir da base de dados, o programa calculará os cinco números que mais se repetem e, dentre eles, devem estar obrigatoriamente presentes de dois a quatro números nas combinações fornecidas. Resultados com nenhum, um ou todos números desse conjunto devem ser descartados.\n",
"\n",
"# Lista de conjuntos a serem verificados\n",
"listPrimos = [];\n",
"\n",
"for reg in df.values:\n",
" count = 0\n",
" for number in reg[1:]:\n",
" if number in mostCommonNumbers5:\n",
" count += 1\n",
" listPrimos.append(count)\n",
"\n",
"df['QUANT. Conjunto'] = listPrimos;\n",
"\n",
"filtered_df = df[(df['QUANT. Conjunto'] < 2 ) | (df['QUANT. Conjunto'] > 4 )]\n",
"\n",
"if len(filtered_df) > 0:\n",
" print(\"\\t Linhas com menos de 2 ou mais de 4 do conjunto:\")\n",
" display(HTML(filtered_df.head().to_html()));\n",
"else:\n",
" print(\"\\t Nenhuma Linhas com menos de 2 ou mais de 4 do conjunto:\")\n",
" display(HTML(df.head().to_html()));\n",
"\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 225
},
"id": "zhOQNYRxz0Ay",
"outputId": "39ea1988-8c58-4674-f676-43eece400d19"
},
"execution_count": 8,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"\t Nenhuma Linhas com menos de 2 ou mais de 4 do conjunto:\n"
]
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<IPython.core.display.HTML object>"
],
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>combinação</th>\n",
" <th>1°</th>\n",
" <th>2°</th>\n",
" <th>3°</th>\n",
" <th>4°</th>\n",
" <th>5°</th>\n",
" <th>6°</th>\n",
" <th>7°</th>\n",
" <th>8°</th>\n",
" <th>9°</th>\n",
" <th>10°</th>\n",
" <th>11°</th>\n",
" <th>12°</th>\n",
" <th>13°</th>\n",
" <th>14°</th>\n",
" <th>15°</th>\n",
" <th>QUANT. Conjunto</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>23</td>\n",
" <td>25</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3ª</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>14</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>21</td>\n",
" <td>22</td>\n",
" <td>23</td>\n",
" <td>24</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>11</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5ª</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>13</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>25</td>\n",
" <td>4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
]
},
"metadata": {}
}
]
},
{
"cell_type": "code",
"source": [
"# @markdown ## **REGRA 17**\n",
"URL_DAS_COMBINAÇÕES=\"https://gist.github.com/gilberto-009199/04a8e07673a424000091f0b169b3354a/raw/64f8be38d055c0243f506ea8fcb5bc264aba7c6f/data_not_duplicate_old_result.txt\" # @param {type:\"string\"}\n",
"df = pd.read_csv(URL_DAS_COMBINAÇÕES, delimiter= '\\t',header= None ,names = ['combinação', '1°', '2°', '3°', '4°', '5°', '6°', '7°', '8°', '9°', '10°', '11°', '12°', '13°', '14°', '15°'])\n",
"# @markdown Regra 17 ATUAL. Regra dos dez números que mais saem até concurso 1763. Do conjunto {01 02 03 04 10 11 13 20 22 24} devem estar obrigatoriamente presentes de cinco a oito números nas combinações fornecidas. Resultados com nenhum, apenas um, dois, três, quatro, nove ou todos números desse conjunto devem ser descartados. ELIMINAR ESSA REGRA.\n",
"# @markdown\n",
"# @markdown Regra 17 NOVA - INTRODUZIR. Regra dos dez números que mais saem. A partir da base de dados, o programa calculará os dez números que mais se repetem e, dentre eles, devem estar obrigatoriamente presentes de cinco a oito números nas combinações fornecidas. Resultados com nenhum, apenas um, dois, três, quatro, nove ou todos números desse conjunto devem ser descartados.\n",
"\n",
"# Lista de conjuntos a serem verificados\n",
"listPrimos = [];\n",
"\n",
"for reg in df.values:\n",
" count = 0\n",
" for number in reg[1:]:\n",
" if number in mostCommonNumbers10:\n",
" count += 1\n",
" listPrimos.append(count)\n",
"\n",
"df['QUANT. Conjunto'] = listPrimos;\n",
"\n",
"filtered_df = df[(df['QUANT. Conjunto'] < 5 ) | (df['QUANT. Conjunto'] > 8 )]\n",
"\n",
"if len(filtered_df) > 0:\n",
" print(\"\\t Linhas com menos de 5 ou mais de 8 do conjunto:\")\n",
" display(HTML(filtered_df.head().to_html()));\n",
"else:\n",
" print(\"\\t Nenhuma Linhas com menos de 5 ou mais de 8 do conjunto:\")\n",
" display(HTML(df.head().to_html()));\n",
"\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 225
},
"id": "vUAs1PTR3oKY",
"outputId": "9b7e5f09-0e24-46aa-9a98-c3bacf23ff71"
},
"execution_count": 9,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"\t Nenhuma Linhas com menos de 5 ou mais de 8 do conjunto:\n"
]
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<IPython.core.display.HTML object>"
],
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>combinação</th>\n",
" <th>1°</th>\n",
" <th>2°</th>\n",
" <th>3°</th>\n",
" <th>4°</th>\n",
" <th>5°</th>\n",
" <th>6°</th>\n",
" <th>7°</th>\n",
" <th>8°</th>\n",
" <th>9°</th>\n",
" <th>10°</th>\n",
" <th>11°</th>\n",
" <th>12°</th>\n",
" <th>13°</th>\n",
" <th>14°</th>\n",
" <th>15°</th>\n",
" <th>QUANT. Conjunto</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>23</td>\n",
" <td>25</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3ª</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>14</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>21</td>\n",
" <td>22</td>\n",
" <td>23</td>\n",
" <td>24</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>11</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5ª</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>13</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>25</td>\n",
" <td>7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
]
},
"metadata": {}
}
]
},
{
"cell_type": "code",
"source": [
"# @markdown ## **REGRA 18**\n",
"URL_DAS_COMBINAÇÕES=\"https://gist.github.com/gilberto-009199/04a8e07673a424000091f0b169b3354a/raw/64f8be38d055c0243f506ea8fcb5bc264aba7c6f/data_not_duplicate_old_result.txt\" # @param {type:\"string\"}\n",
"df = pd.read_csv(URL_DAS_COMBINAÇÕES, delimiter= '\\t',header= None ,names = ['combinação', '1°', '2°', '3°', '4°', '5°', '6°', '7°', '8°', '9°', '10°', '11°', '12°', '13°', '14°', '15°'])\n",
"# @markdown Regra 18 ATUAL. Regra dos quinze números que mais saem até concurso 1763 Do conjunto {01 02 03 04 05 10 11 13 14 17 18 20 22 24 25 } devem estar obrigatoriamente presentes de oito a onze números nas combinações fornecidas. Resultados com menos de oito ou mais de onze números desse conjunto devem ser descartados. ELIMINAR ESSA REGRA.\"\n",
"# @markdown\n",
"# @markdown Regra 18 NOVA - INTRODUZIR. Regra dos quinze números que mais saem. A partir da base de dados, o programa calculará os quinze números que mais se repetem e, dentre eles, devem estar obrigatoriamente presentes de oito a onze números nas combinações fornecidas. Resultados com menos de oito ou mais de onze números desse conjunto devem ser descartados.\n",
"\n",
"# Lista de conjuntos a serem verificados\n",
"listPrimos = [];\n",
"\n",
"for reg in df.values:\n",
" count = 0\n",
" for number in reg[1:]:\n",
" if number in mostCommonNumbers15:\n",
" count += 1\n",
" listPrimos.append(count)\n",
"\n",
"df['QUANT. Conjunto'] = listPrimos;\n",
"\n",
"filtered_df = df[(df['QUANT. Conjunto'] < 8 ) | (df['QUANT. Conjunto'] > 11 )]\n",
"\n",
"if len(filtered_df) > 0:\n",
" print(\"\\t Linhas com menos de 8 ou mais de 11 do conjunto:\")\n",
" display(HTML(filtered_df.head().to_html()));\n",
"else:\n",
" print(\"\\t Nenhuma Linhas com menos de 8 ou mais de 11 do conjunto:\")\n",
" display(HTML(df.head().to_html()));\n",
"\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 225
},
"id": "00OMWV0_4Cbo",
"outputId": "216f8c8b-53e1-4a21-af62-d274c6dcd231"
},
"execution_count": 10,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"\t Nenhuma Linhas com menos de 8 ou mais de 11 do conjunto:\n"
]
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<IPython.core.display.HTML object>"
],
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>combinação</th>\n",
" <th>1°</th>\n",
" <th>2°</th>\n",
" <th>3°</th>\n",
" <th>4°</th>\n",
" <th>5°</th>\n",
" <th>6°</th>\n",
" <th>7°</th>\n",
" <th>8°</th>\n",
" <th>9°</th>\n",
" <th>10°</th>\n",
" <th>11°</th>\n",
" <th>12°</th>\n",
" <th>13°</th>\n",
" <th>14°</th>\n",
" <th>15°</th>\n",
" <th>QUANT. Conjunto</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>23</td>\n",
" <td>25</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3ª</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>14</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>21</td>\n",
" <td>22</td>\n",
" <td>23</td>\n",
" <td>24</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>11</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5ª</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>13</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>25</td>\n",
" <td>9</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
]
},
"metadata": {}
}
]
},
{
"cell_type": "code",
"source": [
"# @markdown ## **REGRA 19**\n",
"URL_DAS_COMBINAÇÕES=\"https://gist.github.com/gilberto-009199/04a8e07673a424000091f0b169b3354a/raw/64f8be38d055c0243f506ea8fcb5bc264aba7c6f/data_not_duplicate_old_result.txt\" # @param {type:\"string\"}\n",
"df = pd.read_csv(URL_DAS_COMBINAÇÕES, delimiter= '\\t',header= None ,names = ['combinação', '1°', '2°', '3°', '4°', '5°', '6°', '7°', '8°', '9°', '10°', '11°', '12°', '13°', '14°', '15°'])\n",
"# @markdown Regra 19 ATUAL. Regra dos vinte números que mais saem até concurso 1763. Do conjunto {01 02 03 04 05 10 11 12 13 14 15 17 18 19 20 21 22 23 24 25} devem estar obrigatoriamente presentes de onze a treze números nas combinações fornecidas. Resultados com menos de onze ou mais de treze números desse conjunto devem ser descartados. ELIMINAR ESSA REGRA.\n",
"# @markdown\n",
"# @markdown Regra 19 NOVA - INTRODUZIR. Regra dos vinte números que mais saem. A partir da base de dados, o programa calculará os vinte números que mais se repetem e, dentre eles, devem estar obrigatoriamente presentes de onze a treze números nas combinações fornecidas. Resultados com menos de onze ou mais de treze números desse conjunto devem ser descartados.\n",
"\n",
"# Lista de conjuntos a serem verificados\n",
"listPrimos = [];\n",
"\n",
"for reg in df.values:\n",
" count = 0\n",
" for number in reg[1:]:\n",
" if number in mostCommonNumbers20:\n",
" count += 1\n",
" listPrimos.append(count)\n",
"\n",
"df['QUANT. Conjunto'] = listPrimos;\n",
"\n",
"filtered_df = df[(df['QUANT. Conjunto'] < 11 ) | (df['QUANT. Conjunto'] > 13 )]\n",
"\n",
"if len(filtered_df) > 0:\n",
" print(\"\\t Linhas com menos de 11 ou mais de 13 do conjunto:\")\n",
" display(HTML(filtered_df.head().to_html()));\n",
"else:\n",
" print(\"\\t Nenhuma Linhas com menos de 11 ou mais de 13 do conjunto:\")\n",
" display(HTML(df.head().to_html()));\n",
"\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 225
},
"id": "mwRKG_xY4fGJ",
"outputId": "5e21d343-7ed5-45df-9791-c9c98c089244"
},
"execution_count": 11,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"\t Nenhuma Linhas com menos de 11 ou mais de 13 do conjunto:\n"
]
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<IPython.core.display.HTML object>"
],
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>combinação</th>\n",
" <th>1°</th>\n",
" <th>2°</th>\n",
" <th>3°</th>\n",
" <th>4°</th>\n",
" <th>5°</th>\n",
" <th>6°</th>\n",
" <th>7°</th>\n",
" <th>8°</th>\n",
" <th>9°</th>\n",
" <th>10°</th>\n",
" <th>11°</th>\n",
" <th>12°</th>\n",
" <th>13°</th>\n",
" <th>14°</th>\n",
" <th>15°</th>\n",
" <th>QUANT. Conjunto</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>14</td>\n",
" <td>15</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>23</td>\n",
" <td>25</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3ª</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>10</td>\n",
" <td>11</td>\n",
" <td>14</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>21</td>\n",
" <td>22</td>\n",
" <td>23</td>\n",
" <td>24</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4ª</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>9</td>\n",
" <td>11</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5ª</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" <td>7</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>13</td>\n",
" <td>15</td>\n",
" <td>16</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>22</td>\n",
" <td>24</td>\n",
" <td>25</td>\n",
" <td>11</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
]
},
"metadata": {}
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment