Tarefa13DanielGonzaga.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPAnMJbrkilFWGwl7J08XKn",
      "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/github/Daniellucasgonzaga/BCC19-DanielGonzaga/blob/main/Tarefa13DanielGonzaga.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Daniel Lucas de Oliveira Gonzaga"
      ],
      "metadata": {
        "id": "Tma_az4xrSZT"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "**1)** Para este item você deverá usar o arquivo [com todos os resultados do campeonato Brasileiro de futebol de 2018 (tabelaBrasileirao2018.csv encontrado na pasta aula7/dados)](dados/tabelaBrasileirao2018.csv) (dados obtidos [desta](<https://pt.wikipedia.org/wiki/Resultados_do_Campeonato_Brasileiro_de_Futebol_de_2018_-_S%C3%A9rie_A_(primeiro_turno)>) e [desta](<https://pt.wikipedia.org/wiki/Resultados_do_Campeonato_Brasileiro_de_Futebol_de_2018_-_S%C3%A9rie_A_(segundo_turno)>) página da Wikipedia).\n",
        "\n",
        "\n",
        "- Escolha um time e faça o histograma da distribuição do público nos jogos em que este time foi o mandante.\n",
        "\n",
        "- Calcule qual foi o público médio nos jogos em que o time escolhido foi o mandante."
      ],
      "metadata": {
        "id": "ClkQpvcyrXJE"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 32,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        },
        "id": "n_atlQT1rOMs",
        "outputId": "80c1e5df-0098-4fc8-b456-4ab658b33ddf"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEWCAYAAABrDZDcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deZxcdbnn8c+XLBBIkNUmEkjAIA6bSBpwnel2ubJE0NdFQQUBrzdujKhwDaiDoJcRnAEB8Yp6QXaDuE2MoBeQsKgs3QgJq0mESMJqWBtDFnjmj/NrUilqOb2c6uV8369Xvfqsv3rq6VP11Fnq/BQRmJlZeW0w1AGYmdnQciEwMys5FwIzs5JzITAzKzkXAjOzknMhMDMrORcCW4+kTSUtkrRnxbSjJN3cYJ35kj6Zhj8m6b9aEetASLpa0pEDWD8kTa8zb0TkYLBIOlnSpUMdh/WfC0GJSHpI0kpJPZIel3ShpIlVi30LOCMi7uzPc0TEZRHxTwOPdn2SJks6X9Kjkp6XdL+kUyRt0s8494+Ii3I+9yuFLmfbheSgDBoVWCuOC0H5vD8iJgJ7Ae3A13pnSJoA3B0R5w1VcLVI2gL4EzABeGtETALeC2wGvL6PbUmSt3uzCn5DlFRELAeuBnaTNE1SAGsi4vtQ81uwJJ0r6dn0bfzdtdqtPowkaVdJ10h6Ku2FfCVN31DSWZIeSY+zJG1YJ9wvAc8Dh0fEQyn+hyPi2IhYkNp7m6TbU3y3S3pbRQzzJZ0q6Q/AP4Adqw5nHSXpZkn/V9LTkh6UtH+adyrwTuDctCd1bkVc70mH0Z6R9D1JqpODsyU9LOk5Sd2S3lkx72RJP5V0cdrTuUdSe8X82ZKWp3kPNMj7hZL+Ix3y6pH0B0nbpLw+nf5nb65Y/gRJS1K790r6YPX/sFY+0vwdJN2Q1r0G2KoqlislPZb+FzdK2rUqzu9J+k1a/1ZJr0/zbkyL3ZVew6Fp+kxJd6Y8/1HSHrVyYP3nQlBSkrYDDgD+nHOVfYElZG/6rwO/SN/UGz3HJOBa4LfA64DpwHVp9leBtwB7Am8C9qFi76TKe4BfRMTLdZ5nC+A3wDnAlsCZwG8kbVmx2BHALGASsLTO63sgvb5vA+dLUkR8FbgJOCYiJkbEMRXrzAT2BvYAPgy8r078t6fXuQVwOXClpI0q5h8EzCHbw5kLnJte187AMcDeaS/ofcBDdZ6DFMPX0mtYRbYXdUca/1nKS68lZAXuNcApwKWSJjfLR5p3OdCd5n0TqD7XcjWwE/Da9PyXVc0/LD3n5sBi4FSAiPjvaf6bUq6vSMXrAuBTZP/bHwBzG3xpsH5wISifX0l6BrgZuAH43znXewI4KyLWRMQVZB8SBzZZZybwWEScEREvRsTzEXFrmvcx4BsR8UREPEn2wXBEnXa2BB5t8DwHAosi4pKIWBsRPwHuB95fscyFEXFPmr+mRhtLI+JHEfEScBEwGWhr8vpOi4hnIuJvwPVkH/avEhGXRsSK9NxnABsCO1cscnNEXJWe+xKywgjwUlp2F0njIuKhiFjSIJ5fRkR3RLwI/BJ4MSIuTu1eAbyyRxARV0bEIxHxcvp/LiIrxg3zIWl7suL3vyJiVUTcCPy66vVekP7Xq4CTgTdJek1VnLdFxFqyIlEzb8ks4AcRcWtEvJTO66wi+xJhg8SFoHw+EBGbRcTUiPhsRKzMud7yWP8OhUvJvuU3sh3ZN89aXsf638wbtbeC7IOonuq2etvbtmL84QbrAzzWOxAR/0iD1SfS665Ddsip5vKSjpd0XzpU8gzZt/DKwynV7WwkaWxELAa+QPZh+oSkOZIa5fzxiuGVNcZfiU/SxysOtzwD7FYvpqp8vA54OiJeqFj2ldxLGiPptHTY6TnW7cE0er2N8jwVOK43zhTrdjTf9qwPXAgMoPdNvXHFtG2qltm24tAAwPbAI03afRjYsc68R8je5Hnauxb4oOqf5K1uq7e95RXjA7nNbr/XTecDvkx22GbziNgMeBZQwxV7nzji8oh4B9nrC+D0/sZSEdNU4Edkh522TDHdnTOmR4HNtf7VWttXDH8UOJjscN5rgGm9T9vPcB8GTk1fXnofG6e9PhskLgRGOjSzHDg8faP7BK++Gue1wOcljZP0IeC/AVc1aXoeMFnSF5SdHJ4kad807yfA1yRtLWkr4CSg3rXoZwKbAhelDzEkbSvpzHTi8CrgDZI+KmlsOsm4S3r+wfA49QtaM5OAtcCTwFhJJ5G9lqYk7SzpXel4+Itk3+prnifpo03IisqT6XmOJtsjaCoilgJdwCmSxkt6B+sfgptEduhmBdkXi7yHHntV5/pHwKcl7avMJpIOTOefbJC4EFivfwX+jewNvCvwx6r5t5KdAPw72cm9QyJiRaMGI+J5sss83092OGAR0Jlm/zvZB8oCYCHZScV/r9POU8DbgDXArZKeJzvp/CywOMUxEzguxf9lYGZE/D3na2/mbOCQdAXNOX1c93dkJ8v/QnYI5UWaH6bqtSFwGlnOHyMrxif28flfJSLuBc4gO5n8OLA78Ic+NPFRspPJT5FdOHBxxbyLyV7ncuBe4JY+hncyWcF/RtKHI6KLbNs8F3ia7OTyUX1s05qQO6YxMys37xGYmZWcC4GZWcm5EJiZlZwLgZlZyY0d6gD6Y6uttopp06YNqI0XXniBTTbp140rRxXnIeM8rONcZEZjHrq7u/8eEVtXTx+RhWDatGl0dXUNqI358+fT0dExOAGNYM5DxnlYx7nIjMY8SKp1ny0fGjIzKzsXAjOzknMhMDMrORcCM7OScyEwMys5FwIzs5IrtBBI2kjSbZLuUtYX6yk1ltlQ0hWSFqf+S6cVGZOZma2v6D2CVcC7IuJNZN3R7Sepuou5fyHr8Wg68B0GoeMNMzPLr9BCEJmeNDouParve30wWZ+okHWw/e6qnrDMzKxAhfdHIGkM0A1MB74XEbOr5t8N7BcRy9L4EmDf6k5FJM0i68iatra2GXPmzBlQXD09PUyc2KxL2tFvOORhwYKFrFmzOtey48aNZ489dh/0GIZDHoYL5yIzGvPQ2dnZHRHt1dNb1jGNpM2AXwL/MyLurpieqxBUam9vD99iYnAMhzxIYursfL1KLj19JkVss8MhD8OFc5EZjXmQVLMQtOyqoYh4Brge2K9q1nJgOwBJY8k6vG7YBaKZmQ2eoq8a2jrtCSBpAln/tfdXLTYXODINHwL8Ptx/pplZyxR999HJZB1RjyErOj+NiHmSvgF0RcRc4HzgEkmLyTrDPqzgmMzMrEKhhSAiFgBvrjH9pIrhF4EPFRmHmZnV518Wm5mVnAuBmVnJuRCYmZWcC4GZWcm5EJiZlZwLgZlZybkQmJmVnAuBmVnJuRCYmZWcC4GZWcm5EJiZlZwLgZlZybkQmJmVnAuBmVnJuRCYmZWcC4GZWcm5EJiZlZwLgZlZybkQmJmVnAuBmVnJuRCYmZWcC4GZWcm5EJiZlZwLgZlZybkQmJmVXGGFQNJ2kq6XdK+keyQdW2OZDknPSrozPU4qKh4zM6ttbIFtrwWOi4g7JE0CuiVdExH3Vi13U0TMLDAOMzNroLA9goh4NCLuSMPPA/cB2xb1fGZm1j+KiOKfRJoG3AjsFhHPVUzvAH4OLAMeAY6PiHvqtDELmAXQ1tY2Y86cOQOKqaenh4kTJw6ojdFgOOShu7ub8dtMz7Xs6scWM2PGjEGPYTjkYbhwLjKjMQ+dnZ3dEdFePb3wQiBpInADcGpE/KJq3qbAyxHRI+kA4OyI2KlZm+3t7dHV1TWguObPn09HR8eA2hgNhkMeJDF19rxcyy49fSZFbLPDIQ/DhXORGY15kFSzEBR61ZCkcWTf+C+rLgIAEfFcRPSk4auAcZK2KjImMzNbX5FXDQk4H7gvIs6ss8w2aTkk7ZPiWVFUTGZm9mpFXjX0duAIYKGkO9O0rwDbA0TEecAhwGckrQVWAodFK05amJnZKworBBFxM6Amy5wLnFtUDGZm1px/WWxmVnIuBGZmJedCYGZWci4EZmYl50JgZlZyLgRmZiXnQmBmVnIuBGZmJedCYGZWci4EZmYll+sWE5J2Ar4F7AJs1Ds9InYsKC4zM2uRvHsEPwa+T9b9ZCdwMXBpUUGZmVnr5C0EEyLiOrKObJZGxMnAgcWFZWZmrZL37qOrJG0ALJJ0DLAcGF19uJmZlVTePYJjgY2BzwMzgMOBjxcVlJmZtU7eQjAtInoiYllEHB0R/0zqYMbMzEa2vIXgxJzTzMxshGl4jkDS/sABwLaSzqmYtSnZFURmZjbCNTtZ/AjQBRwEdFdMfx74YlFBmZlZ6zQsBBFxF3CXpMsiwnsAZmajUN7LRxdJiuqJ/mWxmdnIl7cQtFcMbwR8CNhi8MMxM7NWy3XVUESsqHgsj4iz8C+LzcxGhbw3ndurYnQDsj2EvHsTZmY2jOX9MD+jYngt8BDw4UGPxszMWi5XIYiIzqIDMTOzodHsB2VfajQ/Is5ssv52ZLesbgMC+GFEnF21jICzyX649g/gqIi4o3noZmY2GJrtEUwaYPtrgeMi4g5Jk4BuSddExL0Vy+wP7JQe+5L1e7DvAJ/XzMxyavaDslMG0nhEPAo8moafl3QfsC1QWQgOBi6OiABukbSZpMlpXTMzK5iyz98mC0lTgO8Cb0+TbgKOjYhluZ9ImgbcCOwWEc9VTJ8HnBYRN6fx64DZEdFVtf4sYBZAW1vbjDlz5uR96pp6enqYOLF+lwoLFixkzZrVTdsZN248e+yx+4BiGUrN8tAK3d3djN9meq5lVz+2hOwoY2N9/b8Mhzy0SrNte8qUKSxbtgwkyPH5MNLfA/WMxm2is7OzOyLaq6fnLQTXAJcDl6RJhwMfi4j35nlySROBG4BTI+IXVfNyFYJK7e3t0dVVd3Yu8+fPp6Ojo1HMTJ09r2k7S0+fSZ4cDlfN8tAKeXMNWb6L+L8Mhzy0SrN8H7f7Ws5YOLawXI8Uo3GbkFSzEOS9DfXWEfHjiFibHhcCW+d84nHAz4HLqotAshzYrmJ8SppmZmYtkLcQrJB0uKQx6XE4sKLZSumKoPOB+xpcYTQX+LgybwGe9fkBM7PWyfuDsk+QnSP4Thr/A3B0jvXeDhwBLJR0Z5r2FVLvZhFxHnAV2aWji8kuH83TrpmZDZK8PyhbStYnQZ+k4/5qskwAn+tr22ZmNjhyHRqS9G1Jm0oaJ+k6SU+mw0NmZjbC5T1H8E/pks+ZZPcZmg78W1FBmZlZ6+QtBL2HkA4EroyIZwuKx8zMWizvyeJ5ku4HVgKfkbQ18GJxYZmZWavk7ZjmBOBtQHtErAFeILs1hJmZjXB5O6bZCDgKeEfqu/hmspvDmZnZCJf30NDFwPNkvyUA+CjZ7SY+VERQZmbWOnkLwW4RsUvF+PWS7q27tJmZjRh5rxq6I93+AQBJ+wIDu+ubmZkNC816KFtIds/fccAfJf0tjU8F7i8+PDMzK1qzQ0MzWxKFmZkNmWY9lC2tHJf0WmCjQiMyM7OWynuvoYMkLQIeJOtg5iHg6gLjMjOzFsl7svibwFuAv0TEDsC7gVsKi8rMzFombyFYExErgA0kbRAR1wOv6u7MzMxGnry/I3gm9Tt8I3CZpCfIbjNhZmYjXN49goPJeg/7IvBbYAnw/qKCMjOz1snbQ1nvt/+XgYuKC8fMzFot7x6BmZmNUi4EZmYl50JgZlZyefsj2An4FrALFb8sjogdC4rLzMxaJO8ewY/JOqJZC3SS9U9waVFBmZlZ6+QtBBMi4jpAEbE0Ik4m68jezMxGuLw/KFslaQNgkaRjgOXAxOLCMjOzVsm7R3AssDHweWAGcARwZLOVJF0g6QlJd9eZ3yHpWUl3psdJeQM3M7PBkfcHZbenwR7g6D60fyFwLtk5hXpuigj3e2BmNkSa9VB2VkR8QdKvyXomW09EHNRo/Yi4UdK0AUVoZmaFUsSrPt/XzZRmRES3pP9Ra35E3ND0CbJCMC8idqsxrwP4ObAMeAQ4PiLuqdPOLGAWQFtb24w5c+Y0e+qGenp6mDix/mmO7u5uxm8zvWk7qx9bzIwZMwYUy1BqlodWyJtryPJdxP9lOOShVZrlu20CPL6yuFyPFKNxm+js7OyOiFfdObphIXhlIWkTYGVEvJzGxwAbRsQ/cqw7jfqFYFPg5YjokXQAcHZE7NSszfb29ujq6moadyPz58+no6Oj7nxJTJ09r2k7S0+fSZ4cDlfN8tAKeXMNWb6L+L8Mhzy0SrN8H7f7Ws5YOLawXI8Uo3GbkFSzEOQ9WXwd2cniXhOAawcaVEQ8FxE9afgqYJykrQbarpmZ5Ze3EGzU+4ENkIY3brB8LpK2kaQ0vE+KZ8VA2zUzs/zy/o7gBUl7RcQdkJ07AFY2W0nST4AOYCtJy4CvA+MAIuI84BDgM5LWpvYOi9G4j2lmNozlLQRfAK6U9AggYBvg0GYrRcRHmsw/l+zyUjMzGyK5f0cg6Y3AzmnSAxGxpriwzMysVfLuEQDsDUxL6+wliYho9EMxMzMbAfLehvoS4PXAncBLaXLQ+BfDZmY2AuTdI2gHdvGJXDOz0Sfv5aN3k50gNjOzUSbvHsFWwL2SbgNW9U5sdq8hMzMb/vIWgpOLDMLMzIZO3stHb5A0FdgpIq6VtDEwptjQzMysFRqeI5D02vT3X4GfAT9Is7YFflVsaGZm1gp1C4GkvYBvptHPAW8HngOIiEXAawuPzszMCtdoj+CNwF1peHVErO6dIWksNTqqMTOzkaduIYiIy8k6qQeYL+krwARJ7wWuBH7dgvjMzKxgDc8RRMT/S4MnAE8CC4FPAVcBXys2NDMza4W8Vw29DPwoPczMbBTJe6+hB6ndef2Ogx6RmZm1VF/uNdRrI+BDwBaDH46ZmbVarnsNRcSKisfyiDgLOLDg2MzMrAXyHhraq2J0A7I9hL70ZWBmZsNU3g/zMyqG1wIPAR8e9GjMzKzl8l411Fl0IGZmNjTyHhr6UqP5EXHm4IRjZmat1perhvYG5qbx9wO3AYuKCMrMzFonbyGYAuwVEc8DSDoZ+E1EHF5UYGZm1hp5u6psA1ZXjK9O08zMbITLu0dwMXCbpF+m8Q8AFxUTkpmZtVLeq4ZOlXQ18M406eiI+HNxYZmZWavkPTQEsDHwXEScDSyTtEOzFSRdIOkJSXfXmS9J50haLGlB1Q/XzMysBXIVAklfB2YDJ6ZJ44BLc6x6IbBfg/n7Azulxyzg+3niMTOzwZN3j+CDwEHACwAR8QgwqdlKEXEj8FSDRQ4GLo7MLcBmkibnjMnMzAaBIpr3OCnptojYR9IdEbGXpE2AP0XEHjnWnQbMi4jdasybB5wWETen8euA2RHRVWPZWWR7DbS1tc2YM2dO07hrWbBgIWvWrGbKlCksW7as4bLjt5netL3Vjy1mxowZ/YplOOjp6WHixImFtN2b6zzy5BqyfOf7vywhT2+q48aNZ489di80D7XkzU1vfIOpu7u7YQ7bJsDjK/uS66F5D/Rl+8qbx8o2G31G9Ke9hiTI8Vk80O2hs7OzOyLaq6fnLQTHkx2+eS/wLeATwOUR8d0c605jEApBpfb29ujqarhIo3iYOnsex+2+ljMW1j9XvvT0mUydPa9pe0tPn0meHA5X8+fPp6Ojo5C2e3PdTN5c92XZvv7/isxDLX3JzWBvX82eu/e9MdzfA3lzCPljrGyz0WdEf9prFl8rci2pZiFoetWQJAFXkHVm/xywM3BSRFzT72jWWQ5sVzE+hXX9JJuZWQs0LQQREZKuiojdgcH48K80FzhG0hxgX+DZiHh0kJ/DzMwayPuDsjsk7R0Rt/elcUk/ATqArSQtA75OdsUREXEecBVwALAY+AdwdF/aNzOzgctbCPYFDpf0ENmVQyLbWWh4sjgiPtJkfgCfyxmDmZkVoGEhkLR9RPwNeF+L4jEzsxZrtkfwK7K7ji6V9POI+OdWBGVmZq3T7AdlqhjeschAzMxsaDQrBFFn2MzMRolmh4beJOk5sj2DCWkY1p0s3rTQ6MzMrHANC0FEjGlVIGZmNjT6chtqMzMbhVwIzMxKzoXAzKzkXAjMzErOhcDMrORcCMzMSs6FwMys5FwIzMxKzoXAzKzkXAjMzErOhcDMrORcCMzMSs6FwMys5FwIzMxKzoXAzKzkXAjMzErOhcDMrORcCMzMSs6FwMys5AotBJL2k/SApMWSTqgx/yhJT0q6Mz0+WWQ8Zmb2ag07rx8ISWOA7wHvBZYBt0uaGxH3Vi16RUQcU1QcZmbWWJF7BPsAiyPirxGxGpgDHFzg85mZWT8oIoppWDoE2C8iPpnGjwD2rfz2L+ko4FvAk8BfgC9GxMN12psFzAJoa2ubMWfOnH7F1d3dzfhtptM2AR5fWX+51Y8tZvw205u2t/qxxcyYMaNfsQwHPT09TJw4sZC2e3PdTN5c92XZvv7/isxDLX3JzWBvX82eu/e9MdzfA3lzCPljrGyz0WdEf9prFl8rct3Z2dkdEe3V04e6EGwJ9ETEKkmfAg6NiHc1a7u9vT26urr6GxdTZ8/juN3XcsbC+kfGlp4+k6mz5zVtb+npMykqh60wf/58Ojo6Cmm7N9fN5M11X5bt6/+vyDzU0pfcDPb21ey5e98bw/09kDeHkD/GyjYbfUb0p71m8bUi15JqFoIiDw0tB7arGJ+Spr0iIlZExKo0+p/AyP1qbWY2QhVZCG4HdpK0g6TxwGHA3MoFJE2uGD0IuK/AeMzMrIbCrhqKiLWSjgF+B4wBLoiIeyR9A+iKiLnA5yUdBKwFngKOKioeMzOrrbBCABARVwFXVU07qWL4RODEImMwM7PG/MtiM7OScyEwMys5FwIzs5JzITAzKzkXAjOzknMhMDMrORcCM7OScyEwMys5FwIzs5JzITAzKzkXAjOzknMhMDMrORcCM7OScyEwMys5FwIzs5JzITAzKzkXAjOzknMhMDMrORcCM7OScyEwMys5FwIzs5JzITAzKzkXAjOzknMhMDMrORcCM7OScyEwMyu5wguBpP0kPSBpsaQTaszfUNIVaf6tkqYVHZOZma1TaCGQNAb4HrA/sAvwEUm7VC32L8DTETEd+A5wepExmZnZ+oreI9gHWBwRf42I1cAc4OCqZQ4GLkrDPwPeLUkFx2VmZokiorjGpUOA/SLik2n8CGDfiDimYpm70zLL0viStMzfq9qaBcxKozsDDwwwvK2AvzddavRzHjLOwzrORWY05mFqRGxdPXHsUETSHxHxQ+CHg9WepK6IaB+s9kYq5yHjPKzjXGTKlIeiDw0tB7arGJ+SptVcRtJY4DXAioLjMjOzpOhCcDuwk6QdJI0HDgPmVi0zFzgyDR8C/D6KPF5lZmbrKfTQUESslXQM8DtgDHBBRNwj6RtAV0TMBc4HLpG0GHiKrFi0wqAdZhrhnIeM87COc5EpTR4KPVlsZmbDn39ZbGZWci4EZmYlN6ILgaTtJF0v6V5J90g6Nk3fQtI1khalv5un6ZJ0TrqdxQJJe1W0dWRafpGkIyumz5C0MK1zznD8sVuDPJwsabmkO9PjgIp1Tkyv6QFJ76uYXvOWIOmE/61p+hXp5P+wI2kjSbdJuivl4pQ0vWb8jW5x0tccDScN8nChpAcrtok90/RR+d6A7A4Hkv4saV4aL9W2kEtEjNgHMBnYKw1PAv5CdiuLbwMnpOknAKen4QOAqwEBbwFuTdO3AP6a/m6ehjdP825Lyyqtu/9Qv+4+5OFk4Pgay+8C3AVsCOwALCE7mT8mDe8IjE/L7JLW+SlwWBo+D/jMUL/uOrkQMDENjwNuTf+/mvEDnwXOS8OHAVf0N0fD6dEgDxcCh9RYflS+N1KcXwIuB+Y12pZH67aQ5zGi9wgi4tGIuCMNPw/cB2zL+retuAj4QBo+GLg4MrcAm0maDLwPuCYinoqIp4FrgP3SvE0j4pbItoiLK9oaNhrkoZ6DgTkRsSoiHgQWk90OpOYtQdI3vXeR3QIE1s/psJL+tz1pdFx6BPXjr3eLkz7lqOCX1WcN8lDPqHxvSJoCHAj8ZxpvtC2Pym0hjxFdCCql3bg3k33zaYuIR9Osx4C2NLwt8HDFasvStEbTl9WYPmxV5QHgmLSrf4HSITL6noctgWciYm3V9GEpHQq4E3iC7INrCfXjf+U1p/nPkr3evuZo2KnOQ0T0bhOnpm3iO5I2TNNG63vjLODLwMtpvNG2PGq3hWZGRSGQNBH4OfCFiHiucl76tlKKa2Rr5OH7wOuBPYFHgTOGMLyWiYiXImJPsl+y7wO8cYhDGhLVeZC0G3AiWT72JjvcM3sIQyyUpJnAExHRPdSxDHcjvhBIGkf24XdZRPwiTX487bqS/j6Rpte75UWj6VNqTB92auUhIh5PHwYvAz8i+1CEvudhBdmhgrFV04e1iHgGuB54K/Xjr3eLk77maNiqyMN+6TBiRMQq4Mf0f5sYCe+NtwMHSXqI7LDNu4CzKfG2UNdQn6QYyIPsJNXFwFlV0/8P658s/nYaPpD1T4jdlqZvATxIdjJs8zS8RZpXfULsgKF+3X3Iw+SK4S+SHecE2JX1T379lezE19g0vAPrTn7tmta5kvVPsH12qF93nVxsDWyWhicANwEz68UPfI71TxD+tL85Gk6PBnmYXLHNnAWcNprfGxX56GDdyeJSbQu58jPUAQzwn/sOssM+C4A70+MAsuN61wGLgGsrNlyRdZSzBFgItFe09Qmyk0CLgaMrprcDd6d1ziX9Gns4PRrk4ZL0OheQ3dOpsjB8Nb2mB6i42iOt95c076sV03dMb/zF6Y204VC/7jq52AP4c3rNdwMnNYof2CiNL07zd+xvjobTo0Eefp+2ibuBS1l3ZdGofG9UxNrBukJQqm0hz8O3mDAzK7kRf47AzMwGxoXAzKzkXAjMzErOhcDMrORcCMxykvROSW8b6jjMBpsLgVki6aV0R867JV0paeOKeVsCJ5FdK9477SFJW9Vo52RJx6fhb0h6TyviN+svFwKzdVZGxJ4RsRuwGvh0xbxdgU9HxAt9aTAiToqIawczSLPB5kJgVttNwHRJHZLmRcSNEbFE0pzLFXMAAAFZSURBVLmSjqpY7svpnvy3SZpe3Ui6//8haXhvSX9MfQTcJmlS6jfgx6mNP0vqbNHrM3tFoZ3Xm41E6T4z+wO/zbH4sxGxu6SPk92yYWadNscDVwCHRsTtkjYFVgLHkt0bcXdJbwT+S9IbIuLFQXkxZjl4j8BsnQnpts1dwN+A83Os85OKv29tsNzOwKMRcTtARDwX2a2O30F2qwci4n5gKfCG/oVv1j/eIzBbZ2Vkt21+haS1rP+FaaOqdaLOsNmI4T0Cs8aWAruk/mw3A95dNf/Qir9/atDOA8BkSXsDpPMDY8nORXwsTXsDsH1a1qxlvEdg1kBEPCzpp2R32XyQ7I6elTaXtABYBXykQTurJR0KfFfSBLLzA+8B/gP4vqSFwFrgqMj6CjBrGd991Mys5HxoyMys5FwIzMxKzoXAzKzkXAjMzErOhcDMrORcCMzMSs6FwMys5P4/t2E4PZo0GzoAAAAASUVORK5CYII=\n"
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ],
      "source": [
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "tabela = pd.read_csv('https://raw.githubusercontent.com/Daniellucasgonzaga/BasesComputacionais/master/dados/tabelaBrasileirao2018.csv')\n",
        "# cria uma nova tabela com o corinthians como mandante\n",
        "cr = tabela.query(\"Mandante == 'Corinthians'\")\n",
        "# cria um histograma da coluna público, com 30 barras e borda preta\n",
        "cr.hist(column = 'Público', bins = 30, edgecolor='black')\n",
        "plt.title('Público Corinthians mandante') # edita título\n",
        "plt.xlabel('Público') # título no eixo x\n",
        "plt.ylabel('Frequência absoluta') # título no eixo y\n",
        "plt.show()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "media = cr['Público'].mean() # calcula a média de público\n",
        "print(f\"O público médio quando o Corinthians foi o mandante foi de: {round(media,3)} pessoas\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KPLkJLBvuKcy",
        "outputId": "e096e471-b859-4893-95ba-147f3471a3f5"
      },
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "O público médio quando o Corinthians foi o mandante foi de: 31367.421 pessoas\n"
          ]
        }
      ]
    }
  ]
}