notebooks/01-Data-wrangling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "df770cca",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:49.791670Z",
     "iopub.status.busy": "2024-03-05T13:46:49.788710Z",
     "iopub.status.idle": "2024-03-05T13:46:50.378098Z",
     "shell.execute_reply": "2024-03-05T13:46:50.377193Z"
    }
   },
   "outputs": [],
   "source": [
    "# Carregando algumas bibliotecas importantes\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e56f2835",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.384217Z",
     "iopub.status.busy": "2024-03-05T13:46:50.383219Z",
     "iopub.status.idle": "2024-03-05T13:46:50.409361Z",
     "shell.execute_reply": "2024-03-05T13:46:50.408349Z"
    }
   },
   "outputs": [],
   "source": [
    "# Importando os arquivos\n",
    "jogos = pd.read_csv('../data/raw/matches_FLA2024.csv', parse_dates=['kick-off'])\n",
    "gols = pd.read_csv('../data/raw/goal_scorers_2024.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a4e17eca",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.414256Z",
     "iopub.status.busy": "2024-03-05T13:46:50.414256Z",
     "iopub.status.idle": "2024-03-05T13:46:50.440644Z",
     "shell.execute_reply": "2024-03-05T13:46:50.439251Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_match</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_score</th>\n",
       "      <th>away_score</th>\n",
       "      <th>tournament</th>\n",
       "      <th>kick-off</th>\n",
       "      <th>stadium</th>\n",
       "      <th>attendance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Audax-RJ</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 1</td>\n",
       "      <td>2024-01-17 21:30:00</td>\n",
       "      <td>Arena da Amazônia-AM</td>\n",
       "      <td>44068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AM1</td>\n",
       "      <td>Philadelphia Union-EUA</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>2024-01-21 16:00:00</td>\n",
       "      <td>AI Lang Stadium-EUA</td>\n",
       "      <td>7227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CA2</td>\n",
       "      <td>Nova Iguaçu-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Carioca - Round 2</td>\n",
       "      <td>2024-01-21 18:10:00</td>\n",
       "      <td>Estádio Almeidão-PB</td>\n",
       "      <td>16428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AM2</td>\n",
       "      <td>Orlando City</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>2024-01-27 16:00:00</td>\n",
       "      <td>Inter&amp;Co Stadium-EUA</td>\n",
       "      <td>22678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA3</td>\n",
       "      <td>Portuguesa-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 3</td>\n",
       "      <td>2024-01-27 18:10:00</td>\n",
       "      <td>Arena das Dunas-RN</td>\n",
       "      <td>25211</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  id_match               home_team away_team  home_score  away_score  \\\n",
       "0      CA1                Flamengo  Audax-RJ           4           0   \n",
       "1      AM1  Philadelphia Union-EUA  Flamengo           0           2   \n",
       "2      CA2          Nova Iguaçu-RJ  Flamengo           1           1   \n",
       "3      AM2            Orlando City  Flamengo           1           1   \n",
       "4      CA3           Portuguesa-RJ  Flamengo           0           0   \n",
       "\n",
       "                    tournament            kick-off               stadium  \\\n",
       "0            Carioca - Round 1 2024-01-17 21:30:00  Arena da Amazônia-AM   \n",
       "1  International Friendly Game 2024-01-21 16:00:00   AI Lang Stadium-EUA   \n",
       "2            Carioca - Round 2 2024-01-21 18:10:00   Estádio Almeidão-PB   \n",
       "3  International Friendly Game 2024-01-27 16:00:00  Inter&Co Stadium-EUA   \n",
       "4            Carioca - Round 3 2024-01-27 18:10:00    Arena das Dunas-RN   \n",
       "\n",
       "   attendance  \n",
       "0       44068  \n",
       "1        7227  \n",
       "2       16428  \n",
       "3       22678  \n",
       "4       25211  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mostrando as 5 primeiras linhas do dataframe jogos\n",
    "jogos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "262ac254",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.445626Z",
     "iopub.status.busy": "2024-03-05T13:46:50.444629Z",
     "iopub.status.idle": "2024-03-05T13:46:50.471337Z",
     "shell.execute_reply": "2024-03-05T13:46:50.470387Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_match</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_score</th>\n",
       "      <th>away_score</th>\n",
       "      <th>tournament</th>\n",
       "      <th>kick-off</th>\n",
       "      <th>stadium</th>\n",
       "      <th>attendance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BR5</td>\n",
       "      <td>Bragantino</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Campeonato Brasileiro - Round 5</td>\n",
       "      <td>2024-05-04 18:30:00</td>\n",
       "      <td>Nabi Abi Chedid-SP</td>\n",
       "      <td>9971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>LIB4</td>\n",
       "      <td>Palestino-CHI</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Libertadores - Round 4</td>\n",
       "      <td>2024-05-07 21:00:00</td>\n",
       "      <td>Francisco Sánchez Rumoroso-CHI</td>\n",
       "      <td>4217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BR6</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Corinthians</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Campeonato Brasileiro - Round 6</td>\n",
       "      <td>2024-05-11 16:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>56829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Bolívar-BOL</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Libertadores - Round 5</td>\n",
       "      <td>2024-05-15 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>63169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CB2</td>\n",
       "      <td>Amazonas-AM</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Copa do Brasil - Round 3 - Second leg</td>\n",
       "      <td>2024-05-22 21:30:00</td>\n",
       "      <td>Arena da Amazônia-AM</td>\n",
       "      <td>22948</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_match      home_team    away_team  home_score  away_score  \\\n",
       "25      BR5     Bragantino     Flamengo           1           1   \n",
       "26     LIB4  Palestino-CHI     Flamengo           1           0   \n",
       "27      BR6       Flamengo  Corinthians           2           0   \n",
       "28     LIB5       Flamengo  Bolívar-BOL           4           0   \n",
       "29      CB2    Amazonas-AM     Flamengo           0           1   \n",
       "\n",
       "                               tournament            kick-off  \\\n",
       "25        Campeonato Brasileiro - Round 5 2024-05-04 18:30:00   \n",
       "26                 Libertadores - Round 4 2024-05-07 21:00:00   \n",
       "27        Campeonato Brasileiro - Round 6 2024-05-11 16:00:00   \n",
       "28                 Libertadores - Round 5 2024-05-15 21:30:00   \n",
       "29  Copa do Brasil - Round 3 - Second leg 2024-05-22 21:30:00   \n",
       "\n",
       "                           stadium  attendance  \n",
       "25              Nabi Abi Chedid-SP        9971  \n",
       "26  Francisco Sánchez Rumoroso-CHI        4217  \n",
       "27                     Maracanã-RJ       56829  \n",
       "28                     Maracanã-RJ       63169  \n",
       "29            Arena da Amazônia-AM       22948  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mostrando as 5 ultimas linhas do dataframe jogos\n",
    "jogos.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d433589d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.476246Z",
     "iopub.status.busy": "2024-03-05T13:46:50.475249Z",
     "iopub.status.idle": "2024-03-05T13:46:50.487544Z",
     "shell.execute_reply": "2024-03-05T13:46:50.486356Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_match</th>\n",
       "      <th>gols</th>\n",
       "      <th>assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Léo Pereira</td>\n",
       "      <td>Arrascaeta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Gerson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Everton Cebolinha</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Varela</td>\n",
       "      <td>Luiz Araújo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AM1</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  id_match               gols       assist\n",
       "0      CA1        Léo Pereira   Arrascaeta\n",
       "1      CA1              Pedro       Gerson\n",
       "2      CA1  Everton Cebolinha          NaN\n",
       "3      CA1             Varela  Luiz Araújo\n",
       "4      AM1              Pedro          NaN"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mostrando as 5 primeiras linhas do dataframe jogos\n",
    "gols.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b7fdc7aa",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.493102Z",
     "iopub.status.busy": "2024-03-05T13:46:50.492104Z",
     "iopub.status.idle": "2024-03-05T13:46:50.503040Z",
     "shell.execute_reply": "2024-03-05T13:46:50.502132Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_match</th>\n",
       "      <th>gols</th>\n",
       "      <th>assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Gerson</td>\n",
       "      <td>Everton Cebolinha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Ayrton Lucas</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Everton Cebolinha</td>\n",
       "      <td>Pedro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>CB2</td>\n",
       "      <td>Pedro</td>\n",
       "      <td>Igor Jesus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_match               gols             assist\n",
       "44     LIB5             Gerson  Everton Cebolinha\n",
       "45     LIB5       Ayrton Lucas                NaN\n",
       "46     LIB5  Everton Cebolinha              Pedro\n",
       "47     LIB5              Pedro                NaN\n",
       "48      CB2              Pedro         Igor Jesus"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mostrando as 5 ultimas linhas do dataframe jogos\n",
    "gols.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "49577ba8",
   "metadata": {},
   "source": [
    "### Criando a coluna torneio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a5de1fed",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.508668Z",
     "iopub.status.busy": "2024-03-05T13:46:50.507676Z",
     "iopub.status.idle": "2024-03-05T13:46:50.518364Z",
     "shell.execute_reply": "2024-03-05T13:46:50.517363Z"
    }
   },
   "outputs": [],
   "source": [
    "# Split o nome do torneio e a rodada\n",
    "lista = [i.split(' -', 1)[0] for i in jogos[\"tournament\"].tolist()]\n",
    "\n",
    "# Transformando em uma nova coluna chamada torneio\n",
    "jogos['torneio'] = np.array(lista)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8d1f71e",
   "metadata": {},
   "source": [
    "### Criando a coluna local (casa/fora)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8d8e642b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.523303Z",
     "iopub.status.busy": "2024-03-05T13:46:50.523303Z",
     "iopub.status.idle": "2024-03-05T13:46:50.533520Z",
     "shell.execute_reply": "2024-03-05T13:46:50.532475Z"
    }
   },
   "outputs": [],
   "source": [
    "def obter_locale(row):\n",
    "    if row['torneio'] == 'Supercopa do Brasil' or row['torneio'] == 'Club World Championship':\n",
    "        return 'Neutro'\n",
    "    elif row['home_team'] == 'Flamengo':\n",
    "        return 'Casa'\n",
    "    else:\n",
    "        return 'Fora'\n",
    "\n",
    "    \n",
    "# Aplicar a função para criar a nova coluna\n",
    "jogos['locale'] = jogos.apply(obter_locale, axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16536591",
   "metadata": {},
   "source": [
    "### Criando a coluna resultado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ed10022e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.538848Z",
     "iopub.status.busy": "2024-03-05T13:46:50.537819Z",
     "iopub.status.idle": "2024-03-05T13:46:50.548792Z",
     "shell.execute_reply": "2024-03-05T13:46:50.547885Z"
    }
   },
   "outputs": [],
   "source": [
    "# Função para obter resultado\n",
    "def obter_resultado(row):\n",
    "    if row['home_team'] == 'Flamengo':\n",
    "        gols_marcados = row['home_score']\n",
    "        gols_sofridos = row['away_score']\n",
    "        \n",
    "        if gols_marcados < gols_sofridos:\n",
    "            return 'Derrota'\n",
    "        elif gols_marcados > gols_sofridos:\n",
    "            return 'Vitória'\n",
    "        else:\n",
    "            return 'Empate'\n",
    "    if row['away_team'] == 'Flamengo':\n",
    "        gols_marcados = row['away_score']\n",
    "        gols_sofridos = row['home_score']\n",
    "\n",
    "        if gols_marcados < gols_sofridos:\n",
    "            return 'Derrota'\n",
    "        elif gols_marcados > gols_sofridos:\n",
    "            return 'Vitória'\n",
    "        else:\n",
    "            return 'Empate'\n",
    "\n",
    "# Aplicar a função para criar a nova coluna\n",
    "jogos['resultado'] = jogos.apply(obter_resultado, axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "77920c65",
   "metadata": {},
   "source": [
    "### Criando mais algumas colunas "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b4483c97",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.555034Z",
     "iopub.status.busy": "2024-03-05T13:46:50.554037Z",
     "iopub.status.idle": "2024-03-05T13:46:50.579151Z",
     "shell.execute_reply": "2024-03-05T13:46:50.578154Z"
    }
   },
   "outputs": [],
   "source": [
    "def gerar_estatisticas_gols(row):\n",
    "    if row['home_team'] == 'Flamengo':\n",
    "        gols_feitos_casa = row['home_score']\n",
    "        gols_sofridos_casa = row['away_score']\n",
    "        gols_feitos_fora = 0\n",
    "        gols_sofridos_fora = 0\n",
    "        marcou_gol = 'Sim' if row['home_score'] > 0 else 'Não'\n",
    "        sofreu_gol = 'Sim' if row['away_score'] > 0 else 'Não'\n",
    "    elif row['away_team'] == 'Flamengo':\n",
    "        gols_feitos_casa = 0\n",
    "        gols_sofridos_casa = 0\n",
    "        gols_feitos_fora = row['away_score']\n",
    "        gols_sofridos_fora = row['home_score']\n",
    "        marcou_gol = 'Sim' if row['away_score'] > 0 else 'Não'\n",
    "        sofreu_gol = 'Sim' if row['home_score'] > 0 else 'Não'\n",
    "    else:\n",
    "        gols_feitos_casa = 0\n",
    "        gols_sofridos_casa = 0\n",
    "        gols_feitos_fora = 0\n",
    "        gols_sofridos_fora = 0\n",
    "        marcou_gol = 'Não'\n",
    "        sofreu_gol = 'Não'\n",
    "\n",
    "    return pd.Series([gols_feitos_casa, gols_sofridos_casa, gols_feitos_fora, gols_sofridos_fora, marcou_gol, sofreu_gol])\n",
    "\n",
    "jogos[['gols_casa', 'gols_sofridos_casa', 'gols_fora', 'gols_sofridos_fora', 'marcou_gol', 'sofreu_gol']] = jogos.apply(gerar_estatisticas_gols, axis=1)        \n",
    "\n",
    "jogos['jogos_cumulativos'] = range(1, len(jogos) + 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7b10e8e6",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.584736Z",
     "iopub.status.busy": "2024-03-05T13:46:50.584069Z",
     "iopub.status.idle": "2024-03-05T13:46:50.610761Z",
     "shell.execute_reply": "2024-03-05T13:46:50.609283Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_match</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_score</th>\n",
       "      <th>away_score</th>\n",
       "      <th>tournament</th>\n",
       "      <th>kick-off</th>\n",
       "      <th>stadium</th>\n",
       "      <th>attendance</th>\n",
       "      <th>torneio</th>\n",
       "      <th>locale</th>\n",
       "      <th>resultado</th>\n",
       "      <th>gols_casa</th>\n",
       "      <th>gols_sofridos_casa</th>\n",
       "      <th>gols_fora</th>\n",
       "      <th>gols_sofridos_fora</th>\n",
       "      <th>marcou_gol</th>\n",
       "      <th>sofreu_gol</th>\n",
       "      <th>jogos_cumulativos</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CA1</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Audax-RJ</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 1</td>\n",
       "      <td>2024-01-17 21:30:00</td>\n",
       "      <td>Arena da Amazônia-AM</td>\n",
       "      <td>44068</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AM1</td>\n",
       "      <td>Philadelphia Union-EUA</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>2024-01-21 16:00:00</td>\n",
       "      <td>AI Lang Stadium-EUA</td>\n",
       "      <td>7227</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CA2</td>\n",
       "      <td>Nova Iguaçu-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Carioca - Round 2</td>\n",
       "      <td>2024-01-21 18:10:00</td>\n",
       "      <td>Estádio Almeidão-PB</td>\n",
       "      <td>16428</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AM2</td>\n",
       "      <td>Orlando City</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>2024-01-27 16:00:00</td>\n",
       "      <td>Inter&amp;Co Stadium-EUA</td>\n",
       "      <td>22678</td>\n",
       "      <td>International Friendly Game</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA3</td>\n",
       "      <td>Portuguesa-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 3</td>\n",
       "      <td>2024-01-27 18:10:00</td>\n",
       "      <td>Arena das Dunas-RN</td>\n",
       "      <td>25211</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CA4</td>\n",
       "      <td>Sampaio Corrêa-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Carioca - Round 4</td>\n",
       "      <td>2024-01-31 21:30:00</td>\n",
       "      <td>Mangueirão-PA</td>\n",
       "      <td>47644</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CA5</td>\n",
       "      <td>Vasco</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 5</td>\n",
       "      <td>2024-02-04 19:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>56318</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CA6</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Botafogo</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 6</td>\n",
       "      <td>2024-02-07 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>46798</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CA7</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Volta Redonda</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 7</td>\n",
       "      <td>2024-02-10 16:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>42373</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CA8</td>\n",
       "      <td>Bangu-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Carioca - Round 8</td>\n",
       "      <td>2024-02-15 21:30:00</td>\n",
       "      <td>Arena Batistão-SE</td>\n",
       "      <td>15575</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CA9</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Boa Vista-RJ</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 9</td>\n",
       "      <td>2024-02-21 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>34220</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CA10</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Fluminense</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 10</td>\n",
       "      <td>2024-02-25 16:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>55401</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CA11</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Madureira-RJ</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Round 11</td>\n",
       "      <td>2024-03-02 16:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>63422</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CA12</td>\n",
       "      <td>Fluminense</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Carioca - Semifinal - First leg</td>\n",
       "      <td>2024-03-09 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>52169</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CA13</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Fluminense</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Semifinal - Second leg</td>\n",
       "      <td>2024-03-16 21:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>56261</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CA14</td>\n",
       "      <td>Nova Iguaçu-RJ</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Carioca - Final - First leg</td>\n",
       "      <td>2024-03-30 17:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>43778</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>LIB1</td>\n",
       "      <td>Millonarios-COL</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Libertadores - Round 1</td>\n",
       "      <td>2024-04-02 19:00:00</td>\n",
       "      <td>El Campin-COL</td>\n",
       "      <td>22205</td>\n",
       "      <td>Libertadores</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CA15</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Nova Iguaçu-RJ</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Carioca - Final - Second leg</td>\n",
       "      <td>2024-04-07 17:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>65757</td>\n",
       "      <td>Carioca</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>LIB2</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Palestino-CHI</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Libertadores - Round 2</td>\n",
       "      <td>2024-04-10 19:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>58597</td>\n",
       "      <td>Libertadores</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BR1</td>\n",
       "      <td>Atlético-GO</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Campeonato Brasileiro - Round 1</td>\n",
       "      <td>2024-04-14 16:00:00</td>\n",
       "      <td>Serra Dourada-GO</td>\n",
       "      <td>35195</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BR2</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Campeonato Brasileiro - Round 2</td>\n",
       "      <td>2024-04-17 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>48103</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BR3</td>\n",
       "      <td>Palmeiras</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Campeonato Brasileiro - Round 3</td>\n",
       "      <td>2024-04-21 16:00:00</td>\n",
       "      <td>Allianz Arena</td>\n",
       "      <td>29956</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Não</td>\n",
       "      <td>Não</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>LIB3</td>\n",
       "      <td>Bolívar-BOL</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Libertadores - Round 3</td>\n",
       "      <td>2024-04-24 21:30:00</td>\n",
       "      <td>Hernando Siles-BOL</td>\n",
       "      <td>22620</td>\n",
       "      <td>Libertadores</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Derrota</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BR4</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Botafogo</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Campeonato Brasileiro - Round 4</td>\n",
       "      <td>2024-04-28 11:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>46798</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Derrota</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Não</td>\n",
       "      <td>Sim</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CB1</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Amazonas-AM</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Copa do Brasil - Round 3 - First leg</td>\n",
       "      <td>2024-05-01 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>39015</td>\n",
       "      <td>Copa do Brasil</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BR5</td>\n",
       "      <td>Bragantino</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Campeonato Brasileiro - Round 5</td>\n",
       "      <td>2024-05-04 18:30:00</td>\n",
       "      <td>Nabi Abi Chedid-SP</td>\n",
       "      <td>9971</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Empate</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>LIB4</td>\n",
       "      <td>Palestino-CHI</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Libertadores - Round 4</td>\n",
       "      <td>2024-05-07 21:00:00</td>\n",
       "      <td>Francisco Sánchez Rumoroso-CHI</td>\n",
       "      <td>4217</td>\n",
       "      <td>Libertadores</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Derrota</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Não</td>\n",
       "      <td>Sim</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BR6</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Corinthians</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Campeonato Brasileiro - Round 6</td>\n",
       "      <td>2024-05-11 16:00:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>56829</td>\n",
       "      <td>Campeonato Brasileiro</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>LIB5</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>Bolívar-BOL</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Libertadores - Round 5</td>\n",
       "      <td>2024-05-15 21:30:00</td>\n",
       "      <td>Maracanã-RJ</td>\n",
       "      <td>63169</td>\n",
       "      <td>Libertadores</td>\n",
       "      <td>Casa</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CB2</td>\n",
       "      <td>Amazonas-AM</td>\n",
       "      <td>Flamengo</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Copa do Brasil - Round 3 - Second leg</td>\n",
       "      <td>2024-05-22 21:30:00</td>\n",
       "      <td>Arena da Amazônia-AM</td>\n",
       "      <td>22948</td>\n",
       "      <td>Copa do Brasil</td>\n",
       "      <td>Fora</td>\n",
       "      <td>Vitória</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Não</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_match               home_team       away_team  home_score  away_score  \\\n",
       "0       CA1                Flamengo        Audax-RJ           4           0   \n",
       "1       AM1  Philadelphia Union-EUA        Flamengo           0           2   \n",
       "2       CA2          Nova Iguaçu-RJ        Flamengo           1           1   \n",
       "3       AM2            Orlando City        Flamengo           1           1   \n",
       "4       CA3           Portuguesa-RJ        Flamengo           0           0   \n",
       "5       CA4       Sampaio Corrêa-RJ        Flamengo           0           2   \n",
       "6       CA5                   Vasco        Flamengo           0           0   \n",
       "7       CA6                Flamengo        Botafogo           1           0   \n",
       "8       CA7                Flamengo   Volta Redonda           3           0   \n",
       "9       CA8                Bangu-RJ        Flamengo           0           3   \n",
       "10      CA9                Flamengo    Boa Vista-RJ           4           0   \n",
       "11     CA10                Flamengo      Fluminense           2           0   \n",
       "12     CA11                Flamengo    Madureira-RJ           3           0   \n",
       "13     CA12              Fluminense        Flamengo           0           2   \n",
       "14     CA13                Flamengo      Fluminense           0           0   \n",
       "15     CA14          Nova Iguaçu-RJ        Flamengo           0           3   \n",
       "16     LIB1         Millonarios-COL        Flamengo           1           1   \n",
       "17     CA15                Flamengo  Nova Iguaçu-RJ           1           0   \n",
       "18     LIB2                Flamengo   Palestino-CHI           2           0   \n",
       "19      BR1             Atlético-GO        Flamengo           1           2   \n",
       "20      BR2                Flamengo       São Paulo           2           1   \n",
       "21      BR3               Palmeiras        Flamengo           0           0   \n",
       "22     LIB3             Bolívar-BOL        Flamengo           2           1   \n",
       "23      BR4                Flamengo        Botafogo           0           2   \n",
       "24      CB1                Flamengo     Amazonas-AM           1           0   \n",
       "25      BR5              Bragantino        Flamengo           1           1   \n",
       "26     LIB4           Palestino-CHI        Flamengo           1           0   \n",
       "27      BR6                Flamengo     Corinthians           2           0   \n",
       "28     LIB5                Flamengo     Bolívar-BOL           4           0   \n",
       "29      CB2             Amazonas-AM        Flamengo           0           1   \n",
       "\n",
       "                               tournament            kick-off  \\\n",
       "0                       Carioca - Round 1 2024-01-17 21:30:00   \n",
       "1             International Friendly Game 2024-01-21 16:00:00   \n",
       "2                       Carioca - Round 2 2024-01-21 18:10:00   \n",
       "3             International Friendly Game 2024-01-27 16:00:00   \n",
       "4                       Carioca - Round 3 2024-01-27 18:10:00   \n",
       "5                       Carioca - Round 4 2024-01-31 21:30:00   \n",
       "6                       Carioca - Round 5 2024-02-04 19:00:00   \n",
       "7                       Carioca - Round 6 2024-02-07 21:30:00   \n",
       "8                       Carioca - Round 7 2024-02-10 16:00:00   \n",
       "9                       Carioca - Round 8 2024-02-15 21:30:00   \n",
       "10                      Carioca - Round 9 2024-02-21 21:30:00   \n",
       "11                     Carioca - Round 10 2024-02-25 16:00:00   \n",
       "12                     Carioca - Round 11 2024-03-02 16:00:00   \n",
       "13        Carioca - Semifinal - First leg 2024-03-09 21:30:00   \n",
       "14       Carioca - Semifinal - Second leg 2024-03-16 21:00:00   \n",
       "15            Carioca - Final - First leg 2024-03-30 17:00:00   \n",
       "16                 Libertadores - Round 1 2024-04-02 19:00:00   \n",
       "17           Carioca - Final - Second leg 2024-04-07 17:00:00   \n",
       "18                 Libertadores - Round 2 2024-04-10 19:00:00   \n",
       "19        Campeonato Brasileiro - Round 1 2024-04-14 16:00:00   \n",
       "20        Campeonato Brasileiro - Round 2 2024-04-17 21:30:00   \n",
       "21        Campeonato Brasileiro - Round 3 2024-04-21 16:00:00   \n",
       "22                 Libertadores - Round 3 2024-04-24 21:30:00   \n",
       "23        Campeonato Brasileiro - Round 4 2024-04-28 11:00:00   \n",
       "24   Copa do Brasil - Round 3 - First leg 2024-05-01 21:30:00   \n",
       "25        Campeonato Brasileiro - Round 5 2024-05-04 18:30:00   \n",
       "26                 Libertadores - Round 4 2024-05-07 21:00:00   \n",
       "27        Campeonato Brasileiro - Round 6 2024-05-11 16:00:00   \n",
       "28                 Libertadores - Round 5 2024-05-15 21:30:00   \n",
       "29  Copa do Brasil - Round 3 - Second leg 2024-05-22 21:30:00   \n",
       "\n",
       "                           stadium  attendance                      torneio  \\\n",
       "0             Arena da Amazônia-AM       44068                      Carioca   \n",
       "1              AI Lang Stadium-EUA        7227  International Friendly Game   \n",
       "2              Estádio Almeidão-PB       16428                      Carioca   \n",
       "3             Inter&Co Stadium-EUA       22678  International Friendly Game   \n",
       "4               Arena das Dunas-RN       25211                      Carioca   \n",
       "5                    Mangueirão-PA       47644                      Carioca   \n",
       "6                      Maracanã-RJ       56318                      Carioca   \n",
       "7                      Maracanã-RJ       46798                      Carioca   \n",
       "8                      Maracanã-RJ       42373                      Carioca   \n",
       "9                Arena Batistão-SE       15575                      Carioca   \n",
       "10                     Maracanã-RJ       34220                      Carioca   \n",
       "11                     Maracanã-RJ       55401                      Carioca   \n",
       "12                     Maracanã-RJ       63422                      Carioca   \n",
       "13                     Maracanã-RJ       52169                      Carioca   \n",
       "14                     Maracanã-RJ       56261                      Carioca   \n",
       "15                     Maracanã-RJ       43778                      Carioca   \n",
       "16                   El Campin-COL       22205                 Libertadores   \n",
       "17                     Maracanã-RJ       65757                      Carioca   \n",
       "18                     Maracanã-RJ       58597                 Libertadores   \n",
       "19                Serra Dourada-GO       35195        Campeonato Brasileiro   \n",
       "20                     Maracanã-RJ       48103        Campeonato Brasileiro   \n",
       "21                   Allianz Arena       29956        Campeonato Brasileiro   \n",
       "22              Hernando Siles-BOL       22620                 Libertadores   \n",
       "23                     Maracanã-RJ       46798        Campeonato Brasileiro   \n",
       "24                     Maracanã-RJ       39015               Copa do Brasil   \n",
       "25              Nabi Abi Chedid-SP        9971        Campeonato Brasileiro   \n",
       "26  Francisco Sánchez Rumoroso-CHI        4217                 Libertadores   \n",
       "27                     Maracanã-RJ       56829        Campeonato Brasileiro   \n",
       "28                     Maracanã-RJ       63169                 Libertadores   \n",
       "29            Arena da Amazônia-AM       22948               Copa do Brasil   \n",
       "\n",
       "   locale resultado  gols_casa  gols_sofridos_casa  gols_fora  \\\n",
       "0    Casa   Vitória          4                   0          0   \n",
       "1    Fora   Vitória          0                   0          2   \n",
       "2    Fora    Empate          0                   0          1   \n",
       "3    Fora    Empate          0                   0          1   \n",
       "4    Fora    Empate          0                   0          0   \n",
       "5    Fora   Vitória          0                   0          2   \n",
       "6    Fora    Empate          0                   0          0   \n",
       "7    Casa   Vitória          1                   0          0   \n",
       "8    Casa   Vitória          3                   0          0   \n",
       "9    Fora   Vitória          0                   0          3   \n",
       "10   Casa   Vitória          4                   0          0   \n",
       "11   Casa   Vitória          2                   0          0   \n",
       "12   Casa   Vitória          3                   0          0   \n",
       "13   Fora   Vitória          0                   0          2   \n",
       "14   Casa    Empate          0                   0          0   \n",
       "15   Fora   Vitória          0                   0          3   \n",
       "16   Fora    Empate          0                   0          1   \n",
       "17   Casa   Vitória          1                   0          0   \n",
       "18   Casa   Vitória          2                   0          0   \n",
       "19   Fora   Vitória          0                   0          2   \n",
       "20   Casa   Vitória          2                   1          0   \n",
       "21   Fora    Empate          0                   0          0   \n",
       "22   Fora   Derrota          0                   0          1   \n",
       "23   Casa   Derrota          0                   2          0   \n",
       "24   Casa   Vitória          1                   0          0   \n",
       "25   Fora    Empate          0                   0          1   \n",
       "26   Fora   Derrota          0                   0          0   \n",
       "27   Casa   Vitória          2                   0          0   \n",
       "28   Casa   Vitória          4                   0          0   \n",
       "29   Fora   Vitória          0                   0          1   \n",
       "\n",
       "    gols_sofridos_fora marcou_gol sofreu_gol  jogos_cumulativos  \n",
       "0                    0        Sim        Não                  1  \n",
       "1                    0        Sim        Não                  2  \n",
       "2                    1        Sim        Sim                  3  \n",
       "3                    1        Sim        Sim                  4  \n",
       "4                    0        Não        Não                  5  \n",
       "5                    0        Sim        Não                  6  \n",
       "6                    0        Não        Não                  7  \n",
       "7                    0        Sim        Não                  8  \n",
       "8                    0        Sim        Não                  9  \n",
       "9                    0        Sim        Não                 10  \n",
       "10                   0        Sim        Não                 11  \n",
       "11                   0        Sim        Não                 12  \n",
       "12                   0        Sim        Não                 13  \n",
       "13                   0        Sim        Não                 14  \n",
       "14                   0        Não        Não                 15  \n",
       "15                   0        Sim        Não                 16  \n",
       "16                   1        Sim        Sim                 17  \n",
       "17                   0        Sim        Não                 18  \n",
       "18                   0        Sim        Não                 19  \n",
       "19                   1        Sim        Sim                 20  \n",
       "20                   0        Sim        Sim                 21  \n",
       "21                   0        Não        Não                 22  \n",
       "22                   2        Sim        Sim                 23  \n",
       "23                   0        Não        Sim                 24  \n",
       "24                   0        Sim        Não                 25  \n",
       "25                   1        Sim        Sim                 26  \n",
       "26                   1        Não        Sim                 27  \n",
       "27                   0        Sim        Não                 28  \n",
       "28                   0        Sim        Não                 29  \n",
       "29                   0        Sim        Não                 30  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jogos"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "992e9674",
   "metadata": {},
   "source": [
    "#### Salvando os dataframes "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1e787e91",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-03-05T13:46:50.615173Z",
     "iopub.status.busy": "2024-03-05T13:46:50.615173Z",
     "iopub.status.idle": "2024-03-05T13:46:50.625928Z",
     "shell.execute_reply": "2024-03-05T13:46:50.624927Z"
    }
   },
   "outputs": [],
   "source": [
    "jogos.to_csv('../data/processed/matches_FLA2024.csv', index=False)\n",
    "gols.to_csv('../data/processed/goal_scorers_2024.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5e37517a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.17"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}