{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Aula 2 - Manipulação de Dados" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "1EU8zgBDTcli" }, "outputs": [], "source": [ "# Importar bibliotecas\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "plt.style.use(\"seaborn\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "4e4eCKNvb1Z-" }, "outputs": [], "source": [ "# Atribuir variável de referência ao banco de dados\n", "tips = pd.read_csv('tips.csv')" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "uYgg5ngfcUGA", "outputId": "1f203d35-998c-4f8d-8aba-e701c6ef12b4" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsexsmokerdaytimesize
016.991.01FemaleNoSunDinner2
110.341.66MaleNoSunDinner3
221.013.50MaleNoSunDinner3
323.683.31MaleNoSunDinner2
424.593.61FemaleNoSunDinner4
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip sex smoker day time size\n", "0 16.99 1.01 Female No Sun Dinner 2\n", "1 10.34 1.66 Male No Sun Dinner 3\n", "2 21.01 3.50 Male No Sun Dinner 3\n", "3 23.68 3.31 Male No Sun Dinner 2\n", "4 24.59 3.61 Female No Sun Dinner 4" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Visualização das 5 primeiras linhas\n", "tips.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "PDSPwRiNdyC9", "outputId": "6e2ca48e-37f8-4363-be5d-b2a46f3c0d61" }, "outputs": [ { "data": { "text/plain": [ "(244, 7)" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Quantidade de linhas e colunas\n", "tips.shape" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "PRbx_rL7dSTG", "outputId": "1d6ab422-29b9-465a-c6bc-fc6a2d056b78" }, "outputs": [ { "data": { "text/plain": [ "total_bill float64\n", "tip float64\n", "sex object\n", "smoker object\n", "day object\n", "time object\n", "size int64\n", "dtype: object" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Verificar tipos de dados\n", "tips.dtypes" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 300 }, "id": "PI5iqXy1z2zc", "outputId": "cbea6be3-cb5f-4989-cdd6-97111c88024b" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsize
count244.000000244.000000244.000000
mean19.7859432.9982792.569672
std8.9024121.3836380.951100
min3.0700001.0000001.000000
25%13.3475002.0000002.000000
50%17.7950002.9000002.000000
75%24.1275003.5625003.000000
max50.81000010.0000006.000000
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip size\n", "count 244.000000 244.000000 244.000000\n", "mean 19.785943 2.998279 2.569672\n", "std 8.902412 1.383638 0.951100\n", "min 3.070000 1.000000 1.000000\n", "25% 13.347500 2.000000 2.000000\n", "50% 17.795000 2.900000 2.000000\n", "75% 24.127500 3.562500 3.000000\n", "max 50.810000 10.000000 6.000000" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Estatísticas descritivas dos dados\n", "tips.describe()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "CHSutv-PeOEM", "outputId": "93579548-4f07-4af9-8249-2327d1c50565" }, "outputs": [ { "data": { "text/plain": [ "4827.77" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Qual a receita total das vendas do restaurante?\n", "tips['total_bill'].sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "WlMEnXmOfAtm", "outputId": "80a743f1-b1f1-4211-ef5c-488b9519c0b8" }, "outputs": [ { "data": { "text/plain": [ "731.5799999999999" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Qual o total de gorjetas recebidas?\n", "tips['tip'].sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "BPN0iGHIhn7T", "outputId": "07ad980a-c9f4-426d-aa6d-7a60cc609f48" }, "outputs": [ { "data": { "text/plain": [ "731.58" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Total de gorjetas recebidas com arredondamento em 2 casas decimais\n", "round(tips['tip'].sum(), 2)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "XEKTuqS1fXiL" }, "outputs": [], "source": [ "# Qual o custo de uma refeição por pessoa?\n", "tips['price_per_person'] = tips['total_bill'] / tips['size']" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "HohRvTVUfvNl", "outputId": "4c4863b6-538f-4271-d354-b55f0284237e" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsexsmokerdaytimesizeprice_per_person
016.991.01FemaleNoSunDinner28.495000
110.341.66MaleNoSunDinner33.446667
221.013.50MaleNoSunDinner37.003333
323.683.31MaleNoSunDinner211.840000
424.593.61FemaleNoSunDinner46.147500
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip sex smoker day time size price_per_person\n", "0 16.99 1.01 Female No Sun Dinner 2 8.495000\n", "1 10.34 1.66 Male No Sun Dinner 3 3.446667\n", "2 21.01 3.50 Male No Sun Dinner 3 7.003333\n", "3 23.68 3.31 Male No Sun Dinner 2 11.840000\n", "4 24.59 3.61 Female No Sun Dinner 4 6.147500" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tips.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "M38w8qk7hPfb" }, "outputs": [], "source": [ "# Qual a porcentagem da conta equivale a gorjeta?\n", "tips['bill_percentage'] = tips['tip'] / tips['total_bill']" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "aQZd0mzeiRu3", "outputId": "9c815e67-2312-4716-9791-82c3cce0fb1c" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsexsmokerdaytimesizeprice_per_personbill_percentage
016.991.01FemaleNoSunDinner28.4950000.059447
110.341.66MaleNoSunDinner33.4466670.160542
221.013.50MaleNoSunDinner37.0033330.166587
323.683.31MaleNoSunDinner211.8400000.139780
424.593.61FemaleNoSunDinner46.1475000.146808
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip sex smoker day time size price_per_person \\\n", "0 16.99 1.01 Female No Sun Dinner 2 8.495000 \n", "1 10.34 1.66 Male No Sun Dinner 3 3.446667 \n", "2 21.01 3.50 Male No Sun Dinner 3 7.003333 \n", "3 23.68 3.31 Male No Sun Dinner 2 11.840000 \n", "4 24.59 3.61 Female No Sun Dinner 4 6.147500 \n", "\n", " bill_percentage \n", "0 0.059447 \n", "1 0.160542 \n", "2 0.166587 \n", "3 0.139780 \n", "4 0.146808 " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tips.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 143 }, "id": "6QsyMfYQlOfE", "outputId": "33340d88-c905-4c2e-8437-810899cb621f" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsizeprice_per_personbill_percentage
sex
Female18.0568972.8334482.4597707.4639180.166491
Male20.7440763.0896182.6305738.1233580.157651
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip size price_per_person bill_percentage\n", "sex \n", "Female 18.056897 2.833448 2.459770 7.463918 0.166491\n", "Male 20.744076 3.089618 2.630573 8.123358 0.157651" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Média das gorjetas por sexo do garçom\n", "tips.groupby('sex').mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 143 }, "id": "z40MhqUIloYX", "outputId": "bc82fd86-a45f-4eda-ad22-c739b869f450" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsizeprice_per_personbill_percentage
time
Dinner20.7971593.1026702.6306828.1095600.159518
Lunch17.1686762.7280882.4117657.3153750.164128
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip size price_per_person bill_percentage\n", "time \n", "Dinner 20.797159 3.102670 2.630682 8.109560 0.159518\n", "Lunch 17.168676 2.728088 2.411765 7.315375 0.164128" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Média das gorjetas por tipo de refeição\n", "tips.groupby('time').mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "GHdyTx_LtM5n", "outputId": "5ba3794b-a5f7-4a42-8074-c0aea7049e85" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsizeprice_per_personbill_percentage
day
Fri17.1515792.7347372.1052638.1328510.169913
Sat20.4413792.9931032.5172418.1872320.153152
Sun21.4100003.2551322.8421057.8640240.166897
Thur17.6827422.7714522.4516137.4233680.161276
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip size price_per_person bill_percentage\n", "day \n", "Fri 17.151579 2.734737 2.105263 8.132851 0.169913\n", "Sat 20.441379 2.993103 2.517241 8.187232 0.153152\n", "Sun 21.410000 3.255132 2.842105 7.864024 0.166897\n", "Thur 17.682742 2.771452 2.451613 7.423368 0.161276" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Média das gorjetas por dia da semana\n", "tips.groupby('day').mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "YdRwEoMUtq-H", "outputId": "29e840bc-8d32-412f-c0b8-6d0ce7e59abc" }, "outputs": [ { "data": { "text/plain": [ "total_bill 0\n", "tip 0\n", "sex 0\n", "smoker 0\n", "day 0\n", "time 0\n", "size 0\n", "price_per_person 0\n", "bill_percentage 0\n", "dtype: int64" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Verificar dados ausentes na base de dados\n", "tips.isnull().sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "p4KUIVbSuLBv", "outputId": "c1b75c6c-9d9d-4f69-b11d-f67e865a62d6" }, "outputs": [ { "data": { "text/plain": [ "day sex \n", "Fri Female 127.31\n", " Male 198.57\n", "Sat Female 551.05\n", " Male 1227.35\n", "Sun Female 357.70\n", " Male 1269.46\n", "Thur Female 534.89\n", " Male 561.44\n", "Name: total_bill, dtype: float64" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Calcular receitas totais por dia de semana e sexo do garçom\n", "tips.groupby(['day', 'sex'])['total_bill'].sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 300 }, "id": "6fIExxpqv-mq", "outputId": "6b310380-276b-4b87-bc6b-80743783fb42" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
daysextotal_bill
0FriFemale127.31
1FriMale198.57
2SatFemale551.05
3SatMale1227.35
4SunFemale357.70
5SunMale1269.46
6ThurFemale534.89
7ThurMale561.44
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " day sex total_bill\n", "0 Fri Female 127.31\n", "1 Fri Male 198.57\n", "2 Sat Female 551.05\n", "3 Sat Male 1227.35\n", "4 Sun Female 357.70\n", "5 Sun Male 1269.46\n", "6 Thur Female 534.89\n", "7 Thur Male 561.44" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Resetar o index (permite salvar base em outro csv)\n", "tips.groupby(['day', 'sex'])['total_bill'].sum().reset_index()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 404 }, "id": "9n7Xqj4gw61g", "outputId": "64a31bed-ab37-4a63-8454-73d21f3b06da" }, "outputs": [ { "data": { "text/plain": [ "Text(0, 0.5, 'Receita')" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfgAAAFxCAYAAACfl7pvAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de3xM977/8fckk0GIypChtUu7HVpHKGqrUBshEtStQl0S163VhkqlCKcurT6a0KJVHKrbNW1dUm3VLlFF7bZpqHS79ZIqu1VFEpKIBIlk/f7w65xmhwiVTGZ5PR8Pj0fmO+u75rNmzXjP97vWrLEYhmEIAACYioerCwAAALceAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfBACe677z4FBQUpJCREISEhCgoK0tSpU5Wbm3vLH+vjjz/WlClTJElHjx7V3r17b/ljlJXFixcrOjpakjRs2DAdPnz4ptd16tQp3XfffbeqNOC2ZXV1AUBFt2bNGtWpU0eSlJeXp2eeeUZLly7VM888c0sfJygoSEFBQZKk7du36/Lly/rLX/5ySx+jPKxatcrVJQAQI3jghthsNrVv317ffvutpCuB/+KLLyo4OFiBgYFasmSJc9lDhw7p0UcfVXBwsMLCwnT8+HFJ0pEjRxQWFqbg4GD17NlTBw8elCRt3LhRw4cP144dO7R06VKtXr1asbGxkqRFixYpODhYXbp00RNPPKFz585JklJSUvTYY4+pR48e6tq1q+Li4orVnJSUpJ49eyo2NtZZ57/+9S9J0qVLlzR9+nQFBwerW7duio2NVUFBgSQpMDBQCxcuVHBwsH799dci67x48aIiIyPVqVMnhYWF6dSpU877AgMD9dVXX0mSNmzYoG7duqlr164aMmSITpw4cdXnNT4+Xp06dVLPnj21adMmZ3thYaGef/55Z90TJ05Ufn5+sf45OTmKiIhQt27d1LlzZz333HPO5datW6eQkBAFBgZqwoQJunjxoiQpOjpa8+fPV3h4uNq0aaN58+Zpw4YN6tmzpwIDA3XgwAFJUnp6ukaNGuVcx4oVK4ps69q1axUaGqqHH37Yub9uZNuBMmMAuKZGjRoZJ0+edN7OzMw0hgwZYixevNgwDMNYuHChMWzYMOPSpUtGTk6O0adPH2PHjh2GYRhGUFCQsWvXLsMwDGPFihXG6NGjjYKCAqNr167G+vXrDcMwjK+++sp4+OGHjfz8fOPdd981hg0bZhiGYUyePNlYtGiRYRiGcfDgQSMgIMDIzs42CgoKjOHDhzvvGzdunLFx40bDMAzjzJkzxpNPPmlcunSpyDZ8+eWXRuPGjY1//OMfhmEYxvr1643evXsbhmEYS5cuNUaPHm3k5+cbFy5cMPr162e8//77hmEYRqdOnYznnnvuqs9LXFycMWTIECM/P984e/as0alTJ2Py5MnOfnv37jXS09MNf39/5/MXHR1tTJ06tdi6MjMzjebNmxtHjhwxDMMwZs2aZTRq1MgwDMPYunWr8cgjjxh5eXnGxYsXjW7dujnr+896oqOjDcMwjPz8fGP69OnGN998Y+zdu9cICAgwTp06ZRiGYUybNs2IjY11Psd9+vQxcnJyjO+//95o3LixsWTJEsMwDCM2NtZ49tlnDcMwjBdeeMGYPn26YRiG8fPPPxtNmjQxfv31V+e2Tpgwwbh8+bJx6tQpo0mTJsbJkydLve1AWWIED1xHeHi4QkJC1LlzZ3Xu3Flt2rTR6NGjJUk7d+7U4MGDZbPZ5O3trd69e2vbtm06duyYMjIy1KFDB0lSWFiYXn/9dR09elRnzpxRaGioJOnBBx+U3W7X119/fc3H9/f3165du1StWjV5eHioRYsWztmAmjVrKiEhQYcPH5avr68WL14sm81WbB3e3t7q1q2bJKlr16769ttvdeHCBe3atUsDBgyQ1WpV5cqV1bNnT33++efOfh07drxqTV999ZWCgoJktVrl6+urTp06FVumZs2a2rdvn/PwRqtWrZx1/97+/ftVv359NWjQQJLUp08f533BwcF699135eXlpUqVKqlp06ZXXcdvz+Fnn33mHPU3btxYO3bsUPfu3VW7dm1J0qBBg7Rt2zZnv7Zt28rb21sNGzZUYWGhczsaNWqk1NRUSdJzzz2nadOmSZLuvvtu+fn56ZdffnGuo2fPnvL09FTt2rVVs2ZNnTx5stTbDpQljsED1/HbMfizZ88qJCRE3bt3l9V65a2TnZ2tmJgYzZs3T9KVKftmzZopIyNDPj4+znVYrVZZrVadO3dOFy9edIatJJ0/f16ZmZnXfPwLFy4oJiZGSUlJkqSsrCxn8D777LNaunSpIiMjdenSJT3xxBMaMmRIsXVUr15dFovF+bcknTt3TmfPntUdd9zhXO6OO+7QmTNnity+mqysrCLbV716deXk5BRZpqCgQAsWLNCOHTtUUFCgnJwc3Xvvvddd1+8f8+zZs5o1a5a++eYbWSwWpaena9iwYcXW0a1bN2VlZem1117T0aNH1atXL02ZMkXZ2dn6+OOP9dlnn0mSDMMoMsVftWpVSZLFYpGHh4e8vb0lSR4eHiosLJQkHTx4UHPnztXJkyfl4eGhtLQ0532SVK1aNeffnp6eKigoKPW2A2WJgAdKyW63Kzw8XC+//LL+93//V5LkcDg0cuTIYiPYY8eOKTMzU4WFhfLw8FB+fr5Onz4th8OhqlWrauvWrcXWv3Hjxqs+7qpVq/Tvf/9bGzduVNWqVTV//nydPn1a0pWAmjBhgiZMmKADBw5o9OjRatu2bbEw+f0HiKysLElSjRo1VKtWrSL3ZWZmqlatWtd9LqpXr67s7Gzn7bNnzxZb5qOPPtKOHTsUFxcnu92u9evX68MPP7yhdc2fP19Wq1UffvihbDaboqKirlnTwIEDNXDgQJ0+fVrjxo3T+++/L4fDob59+2ry5MnX3aZrmThxooYNG6ZBgwbJYrGoffv21+1T2m0HyhJT9MANGDFihL7++mvt2bNHktS5c2dt2LBBBQUFMgxDixcv1u7du3XPPfeoTp06zung+Ph4TZ8+XXXr1lWdOnWcAX/27FlNmDCh2NfurFarM/TOnDmjP//5z6patapOnDihTz/91Ln8mDFj9MMPP0i6Mq1crVo150j99y5evKjt27dLkhISEuTv769KlSqpY8eOio+PV0FBgXJzc/XBBx84DyuUpHnz5s7R6dmzZ7V79+5iy5w5c0Z169aV3W5XRkaGtmzZUmyUL0lNmzbVsWPH9O9//1uS9N577xVZR6NGjWSz2fTdd9/p66+/vupXFBctWqT4+HhJUu3atfWnP/1JFotFgYGB2rZtm/NDw/bt2/XGG29cd/v+czv8/f1lsVj03nvv6cKFC9f9mmRptx0oSwQ8cAOqVaumxx9/XLNnz5ZhGBo8eLDuuusu9ejRQyEhIfrxxx/14IMPymKx6LXXXtOSJUvUtWtXbd68WTNnzpTFYtG8efP01ltvKSQkRGFhYQoICHBODf+mU6dOWrt2rZ5++mkNHDhQe/fuVXBwsGbPnq3o6GglJiZq5cqVCgsLU1RUlLp166a+fftq8ODBuueee4rVXbduXe3bt0/BwcFaunSpZsyYIenK+QV16tRRjx491K9fP3Xs2LHI4YNrGTBggHx8fNSlSxeNGzdOXbp0KbbMI488oszMTAUFBSkqKkqRkZE6depUkTPNpSszI5MnT9aIESP0yCOPFJl9GDlypNauXatu3brprbfe0uTJk7VhwwZt2bKlyDp69+6tDz74QMHBwQoJCZGXl5d69+6tJk2aaMyYMQoPD1e3bt20cuVKde7c+brb93vjx49XRESEevbsqdzcXD322GOaNm2afv7552v2Ke22A2XJYhj8HjxgZklJSXruuef08ccfu7oUAOWIETwAACZEwAMAYEJM0QMAYEKM4AEAMCFTfQ8+LS37+gu5MV9fb2Vk3PpfMUPZY9+5N/af+zL7vvPz87nmfYzg3YjV6unqEnCT2Hfujf3nvm7nfUfAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQqb6uVigtEbG7nB1CWVqeXSgq0sA4GJlGvApKSl66qmnNHz4cIWFhenpp59WRkaGJCkzM1PNmzfXE088oZ49e8rf31+S5OvrqwULFig7O1tRUVHKzs6Wt7e35s6dqxo1apRluQAAmEaZBXxubq5mzZqlgIAAZ9uCBQucf0+ZMkX9+/eXJN17771as2ZNkf6rVq1S69at9be//U3r1q3TsmXLNHHixLIqFwAAUymzY/A2m03Lli2Tw+Eodt/Ro0eVnZ2tZs2aXbN/YmKigoKCJEmdOnVSYmJiWZUKAIDplNkI3mq1ymq9+upXr16tsLAw5+309HQ9/fTTSk1N1eDBg9WrVy+lp6fLbrdLkmrWrKnU1NTrPqavr7esVs9bswEVlJ+fj6tLgBvgdXLr8Zy6r9t135X7SXZ5eXnat2+fZs6cKUmqUaOGxo8fr169eik7O1v9+/dXmzZtivQxDKNU687IyL3V5VYofn4+SkvLdnUZcAO8Tm4t3nvuy+z7rqQPL+X+Nbm9e/cWmZqvVq2a+vXrJy8vL9ntdvn7++vo0aNyOBxKS0uTJJ0+ffqqU/0AAODqyj3gDx48qPvvv995+8svv1RMTIykKyfmfffdd7r33nvVrl07bd26VZK0bds2tW/fvrxLBQDAbZXZFP2hQ4c0e/ZsnThxQlarVQkJCXr99deVlpamevXqOZdr1aqV3n//fT322GMqKCjQ448/rtq1ays8PFwTJ07U4MGDVb16db388stlVSoAAKZjMUp7gNsNmPk4i2T+Y0nliQvd4Ebw3nNfZt93FeoYPAAAKHsEPAAAJkTAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJlRmvwcPAGWFn/sFro8RPAAAJkTAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQgQ8AAAmRMADAGBCZRrwKSkp6tKli+Li4iRJ0dHR6tmzp8LDwxUeHq5du3ZJkjZt2qR+/fqpf//+2rBhgyQpPz9fUVFRGjRokMLCwnT8+PGyLBUAAFOxltWKc3NzNWvWLAUEBBRpnzBhgjp16lRkuUWLFik+Pl5eXl4KDQ1VUFCQdu7cqerVq2vu3Ln67LPPNHfuXL366qtlVS4AAKZSZiN4m82mZcuWyeFwlLjc/v371bRpU/n4+Khy5cpq2bKlkpOTlZiYqKCgIElS27ZtlZycXFalAgBgOmU2grdarbJai68+Li5OK1asUM2aNTVt2jSlp6fLbrc777fb7UpLSyvS7uHhIYvFory8PNlstms+pq+vt6xWz1u/MRWIn5+Pq0uAG+B14t7Yf7fW7fp8llnAX03v3r1Vo0YNNW7cWG+88YYWLlyoFi1aFFnGMIyr9r1W++9lZOTekjorKj8/H6WlZbu6DLgBXifujf1365j9/82SPryU61n0AQEBaty4sSQpMDBQKSkpcjgcSk9Pdy6Tmpoqh8Mhh8OhtLQ0SVdOuDMMo8TROwAA+D/lGvDjxo1zng2flJSkhg0b6oEHHtDBgwd17tw55eTkKDk5Wa1atVK7du20detWSdLOnTv10EMPlWepAAC4tTKboj906JBmz56tEydOyGq1KiEhQWFhYYqMjFSVKlXk7e2tmJgYVa5cWVFRURo1apQsFosiIiLk4+Oj7t2764svvtCgQYNks9kUGxtbVqUCAGA6ZRbw/v7+WrNmTbH24ODgYm0hISEKCQkp0ubp6amYmJiyKg8AAFPjSnYAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJiQtSxXnpKSoqeeekrDhw9XWFiYTp48qSlTpujy5cuyWq16+eWX5efnpyZNmqhly5bOfitXrlRhYaGio6P166+/ytPTUzExMbr77rvLslwAAEyjzEbwubm5mjVrlgICApxtr776qgYMGKC4uDgFBQVpxYoVkqRq1appzZo1zn+enp7avHmzqlevrnfeeUdjxozR3Llzy6pUAABMp8wC3mazadmyZXI4HM62GTNmKDg4WJLk6+urzMzMa/ZPTExUUFCQJKlt27ZKTk4uq1IBADCdMpuit1qtslqLrt7b21uSVFBQoLffflsRERGSpLy8PEVFRenEiRMKDg7WiBEjlJ6eLrvdLkny8PCQxWJRXl6ebDbbNR/T19dbVqtnGW1RxeDn5+PqEuAGeJ24N/bfrXW7Pp9legz+agoKCjRp0iS1adPGOX0/adIk9erVSxaLRWFhYWrVqlWxfoZhXHfdGRm5t7zeisTPz0dpadmuLgNugNeJe2P/3Tpm/3+zpA8v5X4W/ZQpU1S/fn2NHTvW2TZo0CBVrVpV3t7eatOmjVJSUuRwOJSWliZJys/Pl2EYJY7eAQDA/ynXgN+0aZO8vLz09NNPO9uOHj2qqKgoGYahy5cvKzk5WQ0bNlS7du20detWSdLOnTv10EMPlWepAAC4tTKboj906JBmz56tEydOyGq1KiEhQWfOnFGlSpUUHh4uSWrQoIFmzpypOnXqKDQ0VB4eHgoMDFSzZs3UpEkTffHFFxo0aJBsNptiY2PLqlQAAEynzALe399fa9asKdWyEydOLNb223ffAQDAjeNKdgAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJgQAQ8AgAkR8AAAmJDV1QUAAG4fI2N3uLqEMrU8OtDVJTgxggcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATOimAz45OflW1gEAAG6hUl3J7vz58/rggw+UkZEhScrPz9e7776rzz77rEyLAwAAN6dUI/jIyEh9//332rhxo3JycrRz507NnDmzjEsDAAA3q1QBf+nSJb3wwguqW7euJk+erNWrV2vLli3X7ZeSkqIuXbooLi5OknTy5EmFh4dr8ODBGj9+vPLy8iRJmzZtUr9+/dS/f39t2LBB0pVZgqioKA0aNEhhYWE6fvz4zW4jAAC3nVIFfH5+vnJzc1VYWKiMjAzVqFHjuoGbm5urWbNmKSAgwNm2YMECDR48WG+//bbq16+v+Ph45ebmatGiRVq5cqXWrFmjVatWKTMzU5s3b1b16tX1zjvvaMyYMZo7d+4f21IAAG4jpQr43r17a/369erfv7+6d++uHj16qFatWiX2sdlsWrZsmRwOh7MtKSlJnTt3liR16tRJiYmJ2r9/v5o2bSofHx9VrlxZLVu2VHJyshITExUUFCRJatu2LSf1AQBwA0p1kl2PHj1UvXp1SVJAQIDOnDkjHx+fkldstcpqLbr6CxcuyGazSZJq1qyptLQ0paeny263O5ex2+3F2j08PGSxWJSXl+fsfzW+vt6yWj1Ls0luy8+v5OcdkHiduDv2n/uqSPvuugFfWFioiIgIrV69WoZhyM/PT76+vurXr58+/PDDm35gwzBuSfvvZWTk3nQ97sDPz0dpadmuLgNugNeJe2P/ua/y3nclfaAoMeA3b96s119/XT/99JMaN27sbPfw8NDDDz98w4V4e3vr4sWLqly5sk6fPi2HwyGHw6H09HTnMqmpqWrevLkcDofS0tJ0//33Kz8/X4ZhlDh6BwAA/6fEY/CPPPKIEhISFBERoe+++87575tvvtEbb7xxww/Wtm1bJSQkSJK2bdum9u3b64EHHtDBgwd17tw55eTkKDk5Wa1atVK7du20detWSdLOnTv10EMP3cTmAQBweypxBP/pp5+qQ4cOqlOnjuLj44vdHxoaes2+hw4d0uzZs3XixAlZrVYlJCTolVdeUXR0tNatW6e77rpLffr0kZeXl6KiojRq1ChZLBZFRETIx8dH3bt31xdffKFBgwbJZrMpNjb2j28tAAC3iRID/vvvv1eHDh2ueQZ7SQHv7++vNWvWFGtfsWJFsbaQkBCFhIQUafP09FRMTExJ5QEAgGsoMeAff/xxSVJMTIwKCwt15swZ+fn5lUthAADg5pXqe/CJiYnq0qWLwsPDJUkvvfSSdu3aVZZ1AQCAP6BUAT9//nytX7/eOXofM2aMFi9eXKaFAQCAm1eqgPf29i5y5Tq73S4vL68yKwoAAPwxpbqSXeXKlbVnzx5JUlZWlv7xj3+oUqVKZVoYAAC4eaUawc+YMUN///vfdfDgQXXt2lX//Oc/9cILL5R1bQAA4CaVagR/55136pVXXnFefz49Pf26PzYDAABcp1Qj+LfeekuTJ0923p4wYYLzN94BAEDFU6qA37RpkxYsWOC8vXz5cm3evLnMigIAAH9MqQK+oKCgyE+/WiyWUv26GwAAcI1SHYMPDAzUwIED9eCDD6qwsFBffvmlunbtWta1AQCAm1SqgH/qqafUunVrHThwQBaLRTNmzFDz5s3LujYAAHCTSjVFL0nnz5+XzWbTiBEjZLfbmaIHAKACK1XAv/zyy4qPj9fGjRslSR9++KFefPHFMi0MAADcvFIF/N69e7Vw4UJVrVpVkhQREaHDhw+XaWEAAODmlSrgf7ssrcVikXTlrPqCgoKyqwoAAPwhpTrJrmXLloqOjlZqaqpWrFihhIQEtW7duqxrAwAAN6lUAT98+HAlJSWpSpUqOnXqlEaOHKnGjRuXdW0AAOAmlRjwX331lZ555hnl5eXJ19dXS5cuVf369RUXF6cXX3xRu3fvLq86AQDADSgx4OfPn6+VK1eqQYMG+uSTTzR9+nQVFhbqjjvu0IYNG8qrRgAAcINKPMnOw8NDDRo0kCR17txZJ06c0NChQ7Vw4ULVrl27XAoEAAA3rsSA/+2s+d/ceeedCgoKKtOCAADAH1fqK9lJxQMfAABUTCUeg//666/VsWNH5+0zZ86oY8eOMgxDFotFu3btKuPyAADAzSgx4Ldu3VpedQAAgFuoxICvW7duedUBAABuoRs6Bg8AANwDAQ8AgAkR8AAAmBABDwCACRHwAACYUKl+Te5W2bBhgzZt2uS8fejQIfn7+ys3N1fe3t6SpMmTJ8vf319vvvmmtm7dKovForFjx6pDhw7lWSoAAG6tXAO+f//+6t+/vyRpz5492rJli44cOaKYmBg1atTIudzx48f10Ucfae3atTp//rwGDx6shx9+WJ6enuVZLgAAbstlU/SLFi3SU089ddX7kpKS1L59e9lsNtntdtWtW1dHjhwp5woBAHBf5TqC/82BAwd05513ys/PT5K0YMECZWRkqEGDBpo6darS09Nlt9udy9vtdqWlpem+++4rcb2+vt6yWs09yvfz83F1CXADvE7cG/vPfVWkfeeSgI+Pj1ffvn0lSUOHDtV9992nevXqacaMGXrrrbeKLW8YRqnWm5GRe0vrrGj8/HyUlpbt6jLgBniduDf2n/sq731X0gcKl0zRJyUlqUWLFpKkoKAg1atXT5IUGBiolJQUORwOpaenO5c/ffq0HA6HK0oFAMAtlXvAnz59WlWrVpXNZpNhGBo+fLjOnTsn6UrwN2zYUG3atNGuXbuUl5en06dPKzU1Vf/1X/9V3qUCAOC2yn2KPi0tzXl83WKxaMCAARo+fLiqVKmi2rVra9y4capSpYoGDBigsLAwWSwWzZw5Ux4efGUfAIDSKveA/+077r/p3r27unfvXmy58PBwhYeHl2dpAACYBsNiAABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMyFqeD5aUlKTx48erYcOGkqRGjRrpb3/7myZNmqSCggL5+fnp5Zdfls1m06ZNm7Rq1Sp5eHhowIAB6t+/f3mWCgCAWyvXgJek1q1ba8GCBc7bU6ZM0eDBg9WtWzfNmzdP8fHx6tOnjxYtWqT4+Hh5eXkpNDRUQUFBqlGjRnmXCwCAW3L5FH1SUpI6d+4sSerUqZMSExO1f/9+NW3aVD4+PqpcubJatmyp5ORkF1cKAID7KPcR/JEjRzRmzBhlZWVp7NixunDhgmw2mySpZs2aSktLU3p6uux2u7OP3W5XWlraddft6+stq9WzzGqvCPz8fFxdAtwArxP3xv5zXxVp35VrwN9zzz0aO3asunXrpuPHj2vo0KEqKChw3m8YxlX7Xav9P2Vk5N6SOisqPz8fpaVlu7oMuAFeJ+6N/ee+ynvflfSBolyn6GvXrq3u3bvLYrGoXr16qlWrlrKysnTx4kVJ0unTp+VwOORwOJSenu7sl5qaKofDUZ6lAgDg1so14Ddt2qS///3vkqS0tDSdOXNGjz76qBISEiRJ27ZtU/v27fXAAw/o4MGDOnfunHJycpScnKxWrVqVZ6kAALi1cp2iDwwM1LPPPqtPPvlE+fn5mjlzpho3bqzJkydr3bp1uuuuu9SnTx95eXkpKipKo0aNksViUUREhHx8Ks5xDQAAKrpyDfhq1appyZIlxdpXrFhRrC0kJEQhISHlURYAAKbj8q/JAQCAW4+ABwDAhAh4AABMiIAHAMCECHgAAEyIgFkusUwAAA5CSURBVAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCErK4uwJ2NjN3h6hLKzPLoQFeXAAD4AxjBAwBgQgQ8AAAmRMADAGBCBDwAACZEwAMAYEIEPAAAJkTAAwBgQgQ8AAAmVO4XupkzZ4727duny5cv64knntCOHTt0+PBh1ahRQ5I0atQodezYUZs2bdKqVavk4eGhAQMGqH///uVdKgAAbqtcA/7LL7/UDz/8oHXr1ikjI0N9+/ZVmzZtNGHCBHXq1Mm5XG5urhYtWqT4+Hh5eXkpNDRUQUFBzg8BAACgZOUa8H/5y1/UrFkzSVL16tV14cIFFRQUFFtu//79atq0qXx8fCRJLVu2VHJysgIDuXwqAAClUa4B7+npKW9vb0lSfHy8/vrXv8rT01NxcXFasWKFatasqWnTpik9PV12u93Zz263Ky0t7brr9/X1ltXqWWb13078/HxcXQL+APafe2P/ua+KtO9c8mMz27dvV3x8vJYvX65Dhw6pRo0aaty4sd544w0tXLhQLVq0KLK8YRilWm9GRm5ZlHtbSkvLdnUJ+APYf+6N/ee+ynvflfSBotzPov/nP/+pJUuWaNmyZfLx8VFAQIAaN24sSQoMDFRKSoocDofS09OdfVJTU+VwOMq7VAAA3Fa5Bnx2drbmzJmjpUuXOk+YGzdunI4fPy5JSkpKUsOGDfXAAw/o4MGDOnfunHJycpScnKxWrVqVZ6kAALi1cp2i/+ijj5SRkaHIyEhn26OPPqrIyEhVqVJF3t7eiomJUeXKlRUVFaVRo0bJYrEoIiLCecIdAAC4vnIN+Mcee0yPPfZYsfa+ffsWawsJCVFISEh5lAUAgOlwJTsAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEyIgAcAwIQIeAAATIiABwDAhAh4AABMiIAHAMCECHgAAEzI6uoCSvLSSy9p//79slgsmjp1qpo1a+bqkgAAcAsVNuD37Nmjn376SevWrdOPP/6oqVOnat26da4uCwAAt1Bhp+gTExPVpUsXSVKDBg2UlZWl8+fPu7gqAADcQ4Udwaenp6tJkybO23a7XWlpaapWrdo1+/j5+ZRHaU4fzu1dro+HW4d9597Yf+6LfVd+KuwI/j8ZhuHqEgAAcBsVNuAdDofS09Odt1NTU+Xn5+fCigAAcB8VNuDbtWunhIQESdLhw4flcDhKnJ4HAAD/p8Ieg2/ZsqWaNGmigQMHymKxaMaMGa4uCQAAt2ExOLgNAIDpVNgpegAAcPMIeAAATIiABwDAhAh4AABMiIAHysgLL7xQrC0yMtIFlQC3l08//dTVJVQIFfZrcreziIgILVq0SG3atJHFYnG2G4Yhi8WixMREF1aH60lISNCKFSv0ww8/6MCBA872y5cvKz8/34WVobQWLlyouLg45/uP9557iYuLU4sWLVS9enVXl+JSfE2uAjt8+HCR6/HDfeTl5Sk2NlajRo1ytnl4eMjDw0O1a9d2YWUojV69emnt2rXy9vZ2dSm4CYMGDdJ3332nevXqycvLy/kBLT4+3tWllSsCvgIbOnSoli9fLquViRZ3lJ+fr88//1yZmZnO20uXLtX27dtdXBmuJzIyUnPmzJHNZnN1KbgJJ06cuGp73bp1y7kS1yI5KjBvb2917dpV999/v7y8vJztr732mgurQmk988wzqlq1qvbs2aPAwEAlJSVp7Nixri4LpVBYWKiQkBD993//tzw9PZ0jQN577mHhwoVXbY+JiSnnSlyLgK+AYmJiNGXKFI0cOVKSlJycrJYtW7q4KtyorKwsLVy4UOHh4Zo2bZrOnTunGTNmqE+fPq4uDdcRFhbm6hLwBwQHBzv/vnz5svbt21dkkHS7IOAroG+//VaS1Lp1a0lXPo2OGTPGlSXhJuTn5+vEiRPy9PTUsWPHdOedd+rYsWOuLgulsGfPnqu2//aeRMXWsWPHIre7dOmi0aNHu6YYFyLgK6D/PC2C0yTc0/jx43Xo0CE9+eSTGj16tM6fP68hQ4a4uiyUgq+vr/Pv/Px8JScnc3KkG/nPr8mlpqbq+PHjLqrGdQj4Cuj3X4272m1UbImJiVq8eLHWrFmjgoICjRgxQp6envLx8VGzZs1cXR5K4T8/iA0fPpxZNDeydevWIrerVaumV155xUXVuA4BXwEdOnRIoaGhkq6M3o8dO6bQ0NDb9qse7mb+/PnO/0y2bdum3Nxcbd26VVlZWRo7dqw6dOjg4gpxPUeOHClyOzU1lcMrbiQmJkbnz59Xdnb2bT0DSsBXQB9++KGrS8AfUKlSJdWrV0+StHv3bvXq1UsWi0U1atSQp6eni6tDaTz//PPOvz08POTl5aWpU6e6sCLciOnTp2v37t2qVauWJN22gyMCvgK63b6raTZ5eXkqLCzUpUuX9OmnnxY5uSc3N9eFleF6rnZ45dSpUyosLHR1abgBhw4d0s6dO2/7w5sEPHCL9erVS48++qjy8vLUvn17/fnPf1ZeXp6mTZumVq1aubo8lIDDK+bwwAMPKCMjQ3a73dWluBQBD9xiQ4YMUceOHZWdna37779fkmSz2dSqVSv169fPxdWhJBxecW/9+vWTxWJRYWGhunTpovr16xe5UBFT9AD+sKsdZunfv78LKsGN4PCKe7vrrrsUHR3t6jIqDAIeAP4/Dq+4t6ysLM5h+h1+bAYAfufEiRNFDq9I0oYNG9SvXz95eHi4sDJcT8eOHdW9e/dr3j9p0qRyrMb1GMEDwO9weMV9ValSRQ0bNnR1GRUGAQ8AMIVatWqpb9++ri6jwmC+CQBgCv7+/q4uoULhGDwAACbECB4AABMi4AEAMCFOsgPcyC+//KKQkBC1aNFC0pXfKm/VqpUiIiJUpUoV7d69W4cPH9aTTz55w+v+6aefNGLECO3YsaPUfZYvX65t27bJy8tL2dnZ6tixo8aPH3/bXwMcqAgIeMDN2O12rVmzRpJ06dIlxcbGKioqSosXL9Zf//pX/fWvfy2XOvbt26fNmzdr/fr1slqtysvL05gxY5ScnKwHH3ywXGoAcG0EPODGKlWqpKlTpyo4OFhHjhzRgQMH9MUXX+iVV17Rxx9/rDfffFM2m00FBQWaM2eO/vSnPxXpn5ycrBkzZshut6tJkybO9h9//FEzZsyQp6enzp8/r8jISLVv375I36ysLOXn5ysvL09Wq1U2m03Lly933v/RRx8pLi5OhmHIbrfrxRdflK+vr1q0aKEnn3xSO3bsUH5+vsaMGaP169fr2LFjmjlzph5++GF99dVXeuWVV2Sz2XTx4kXNmDFDTZo0UXR0tBwOh1JSUnTs2DGFhoZq9OjRSk9P16RJk3T58mWdP39eQ4cOVZ8+fcr2yQcqOI7BA27Oy8tL/v7+SklJKdJ+7tw5zZ8/X2vWrFGHDh301ltvFes7Z84cPfvss1q1apX8/Pyc7enp6Ro/frxWrVql5557TvPnzy/Wt3379rr33nvVoUMHPf3003r77bd19uxZSdLJkye1ZMkSrVy5Uu+8845at26tpUuXSrpyTXd/f3+tXbtW3t7e2rFjh5YtW6annnpKb7/9tiQpMzNTM2fO1OrVqzV06FBnX0k6fvy4lixZouXLl2vJkiWSpNTUVA0ZMkSrV6/WkiVLFBMT8wefVcD9MYIHTCA7O7vYZVRr1aqlyZMnyzAMpaWlOY/b/97333/vnE5v06aNc+rfz89Pc+bM0fz585Wfn6/MzMxifb28vLRgwQL9/PPP+vzzz/X5559r3rx5Wr58uX755RelpaVp1KhRkq78iMvvZw9+e8zatWurZcuWkqQ6deooOzvbWfucOXN06dIlZWdn64477nD2bd26taQrV5w7f/68CgoK5HA49Oabb+rNN9+Up6fnVesFbjcEPODmLly4oG+//VZNmjTR3r17JV05+S4yMlLvvfee7rnnHsXFxenQoUNX7f/bB4OCggJn26xZs9SjRw+FhoYqJSVFY8aMKdavoKBABQUFqlevnurVq6dBgwZp/vz52rRpk9q0aaNmzZoVGXn/3u9/evVqP8M6adIkPf/88woICNDOnTuLTP1brUX/2zIMQ6+++qrq16+vefPmKScnx/mhAbidMUUPuLH8/Hy9+OKLateune6++25ne05Ojjw8PFS3bl1dunRJn3zyifLy8or1b9Cggf71r39Jkr744gtne3p6uvOa3h999NFV+7766qt6/vnnVVhYKOlK0P7yyy+qV6+emjZtqgMHDigtLU2StGXLFm3fvr3U2/Xb4xcUFGjr1q1XffyrLS9JmzdvloeHx3X7AGZHwANu5uzZswoPD9fgwYPVt29fVatWTS+99FKRZWrUqKFHHnlEoaGhioyM1KhRo/Tll19qy5YtRZabOHGiXnrpJY0ePVo5OTnO9pEjR2rSpEkaNWqUHnzwQd1xxx2KjY0t0jciIkKVKlVS//79FR4eroEDB6p27doaPHiwateurf/5n//RE088oSFDhig+Pl7Nmzcv9TaOHj1aw4YN05gxY9S3b1+dPHlSK1euvObyYWFheu211zRixAhVrVpVAQEBioqKKvXjAWbEpWoBADAhRvAAAJgQAQ8AgAkR8AAAmBABDwCACRHwAACYEAEPAIAJEfAAAJjQ/wMWlcdW4+nDHQAAAABJRU5ErkJggg==", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotar gráfico de receitas por dia da semana e sexo\n", "tips.groupby(['day'])['total_bill'].sum().plot.bar(title='Receitas por dia da semana')\n", "plt.xlabel(\"Dia da Semana\")\n", "plt.ylabel(\"Receita\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "1Uqj_VRJxxaH", "outputId": "52e1ee33-7a75-4cff-ca1d-cb4834ae3bb2" }, "outputs": [ { "data": { "text/plain": [ "day\n", "Fri 325.88\n", "Sat 1778.40\n", "Sun 1627.16\n", "Thur 1096.33\n", "Name: total_bill, dtype: float64" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tips.groupby(['day'])['total_bill'].sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 404 }, "id": "uYqjO-D5yL6l", "outputId": "8266e1b1-d368-41a5-ddbf-120e27fd192e" }, "outputs": [ { "data": { "text/plain": [ "Text(0, 0.5, 'Gorjeta')" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfIAAAFxCAYAAACItSqmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de0BUdcL/8Q8wEKIYcrO1slpXC8ELam60eUNNTNe8potaKd4vSdrj3dR0vZaWeU3zvj1paIk93jLLyhRTfCw1H63M0KcVUEAUhBHO7w8f5xeLAroNw1ffr7+YM+ec+cwc4DPne86ccbMsyxIAADCSu6sDAACA20eRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIgf9jWZZWr16tdu3aqXXr1mrZsqX69u2rI0eO3PK6zp07p7Zt2xY73+HDh3X8+PHbiesS48aN09tvvy1JioqKUmpq6m2v68CBA4qMjPy9ogF3LZurAwBlxdy5c5WQkKBly5YpODhYeXl5+uCDD9SrVy9t375d/v7+JV5X5cqV9fHHHxc734YNG1S/fn099thj/050l9i2bZurIwAQRQ5IktLT07Vq1Spt2rRJwcHBkiQPDw9169ZNbdu2VYUKFSRJ//u//6sJEybozJkz8vT0VJ8+fdS+fXudOXNG3bp10zPPPKNjx45pxowZevrpp3Xs2DFZlqUFCxZo8+bNys3NVfPmzTVmzBitX79emzZt0q5du3ThwgW98MILmjJlir7++mvZ7XbVr19f06ZNk6enp/bv36/p06crJydHlmXppZdeUuvWrQs8h40bN2rr1q3y8/PToUOH5O3trfnz5+vhhx9Wenq6Jk6cqOPHj8vDw0Pt27dXv379JEmPPvqohg8fro0bN2rLli3y8PBwrDMtLU0jRozQzz//rD/96U/y9vbWfffd51hu9+7duu+++7RgwQLFx8crLy9P1apV0+zZs1WxYsVCr/PChQu1bt06VapUqcDeeHZ2tsaMGaPvv/9edrtdrVq10qhRowotf+7cOY0cOVIpKSnKzc1VmzZt9PLLL9/0Nfbw8FDPnj3VqFEjffrppzp9+rSGDh2qjIwMxcfHy93dXUuWLNGDDz6on376SePGjVN6erquXr2qYcOGOUZVHn30Uc2cOVMrV65Uamqq+vTpoxdffFGSSvzcAaexAFiff/651apVq2Ln6927t7V48WLLsizrzJkzVv369a2kpCQrKSnJCg0NtTZu3GhZlmUlJSVZISEhlmVZ1ocffmi1adPGunjxomW3261+/fpZa9assSzLsnr06GF99NFHlmVZ1rZt26y2bdtaubm51pUrV6zWrVs77uvYsaOVkJBgWZZlnTp1yho+fHihbBs2bLBq1qxpHTp0yLIsy5ozZ441aNAgy7Isa8KECdaECRMsy7KstLQ0q2nTptY333xjWZZl1ahRw1q0aNENn+/MmTMdj5WUlGSFh4db8+bNcyz366+/Wt99950VERFhZWZmWnl5edaLL75oLViwoNC6Tp48aT3++ONWSkqKdfXqVWvQoEFWs2bNLMuyrHfffdfq06ePlZ+fb6Wnp1sNGzZ05PutGTNmWG+//bZlWZaVlZVlvfzyy9a5c+eKfY379Olj2e12a9euXVadOnWsDRs2WJZlWUOHDrXmzp1rWZZl9e/f31qyZIllWZa1f/9+q3bt2lZubq7juc6ePduyLMs6fPiwVatWLevq1aslfu6AM3GMHJCUkZFRYOj84sWLioqKUlRUlBo3bqylS5fKbrfr66+/VnR0tCTp/vvv15///Gft27dPkmS329WyZctC6/7ss8/UqVMn+fr6ymazqUuXLtqxY0eh+Vq1aqUNGzbI09NT99xzj2rVqqWkpCRJUkBAgD766CP9+OOPevjhh/XGG2/c8HlUq1ZNdevWdazv0KFDkqTdu3c7cvv5+ally5bas2ePY7mmTZvecH0HDhxw7Pk/8MADatiwYaF5wsLC9Pnnn6tChQpyd3dXeHi4I/dvffPNN3r88ccVGBgoDw8PtWvXznFf7969tXDhQrm5uenee+9V9erVdebMmULrCAgI0FdffaUDBw7Iy8tLc+bMUXBwcLGvcbNmzWSz2VSjRg1lZ2erVatWkqQaNWooOTlZ0rXRgpiYGElS/fr1lZOTo5SUFMc6nn32WUlSaGiocnJydP78+RI/d8CZGFoHJPn7+zv+oUtSxYoVHceAx40bpytXrig9PV2WZcnX17fAfBcuXJB0bSj++hD8b2VmZurdd9/VunXrJEl5eXk3PN5+4cIFTZkyRceOHZObm5tSU1P1wgsvSJKmTZumRYsWqVevXvL29tbw4cMVFRVVaB333ntvgWwXL150rPu3w70VK1Ys8Hz9/Pxu+LpkZGQUer7/Kjs7W9OnT1dCQoJjmRu9MShqXT///LNmzJihn376Se7u7vrnP/+pjh07FlrHiy++qPz8fE2ePFnJycnq3r27hg4dWuxrXL58eUlyHDa4ftvd3V35+fmSpC+//FKLFi1SWlqa3NzcZFmW4z5JjuzX15Gfn1/i5w44E0UOSKpbt67Onz+vY8eOqWbNmjecp1KlSnJ3d1dGRoajMNPT0xUQEFDkuoODgxUZGakePXoUOd/cuXNls9m0efNmeXl5acSIEY77AgMDNWHCBE2YMEFfffWVhg4dqkaNGjkK6br09HTHz7/NGRgYqPT0dFWpUsUxX2BgYJF5pGtlm5mZ6bh94cIFPfjggwXmWbVqlX7++Wdt3LhR5cuX19y5c3Xu3Lli15WWlub4+bXXXlNoaKgWLFjgODfhRmw2m/r166d+/frp1KlT6tu3r+rXr1/i1/hm7Ha7YmNj9eabb6pJkybKzc1V7dq1i12upM8dcCaG1gFJFSpU0KBBgzRy5EidPn1a0rU9rv/6r//S1q1bVbVqVdlsNj311FOOvb5ffvlFBw4c0JNPPlnkups3b65NmzYpOztbkvT+++/rww8/lHStmK6X2/nz51WjRg15eXnp+PHjOnTokLKysmS329WzZ0/HHnRoaKhsNpvc3Qv/+Z46dUrHjh2TJG3fvl3169eXdG3o/HruCxcu6JNPPinRnmPdunW1c+dOx/M9ePBgoXnOnz+vP/7xjypfvrzOnj2r3bt3Kysrq9B84eHhOnjwoC5cuKC8vDzFx8cXWEdISIg8PDy0Z88enT59+obrePXVVx2HBKpWrarAwEC5ubkV+RqXRHZ2trKyshQWFibpWkF7enreMMPtPHfAmdgjB/5P37595efnp5deekk5OTnKzc3VI488onnz5umpp56SJE2ePFnjx4/Xxo0b5enpqalTp+oPf/jDDY/nXteiRQudPHlSHTp0kHStgP7+97877ps9e7aSkpLUu3dvjRo1Shs3blSDBg00atQojRs3TrVr11bnzp0dZ0m7u7tr/PjxKleuXKHHCg8P18qVK3XgwAH5+Pho0aJFkqTY2FhNmjRJUVFRcnd3V79+/Uq0x9m/f3+9/PLLioyMVLVq1fT0008Xmqdbt2566aWX1KpVKz366KMaPXq0hg4dqpUrVzoyS1JISIi6deumDh06yM/PT23atNGJEyckSQMHDtT06dO1cOFCNW/eXEOGDNG8efMUEhLieDNy/bFeffVVTZkyRZZlKTIyUhEREZJ009e4JCpWrOj4BEJAQIAGDhyoFi1aaMCAAUV+jLCkzx1wJjfL4vvIgd/bmTNnHB8/Ky0bN25UfHy8Vq5cWWqPCcD1GFoHnCAzM1Pe3t6ujgHgLkCRA7+z48ePq0+fPurataurowC4CzC0DgCAwdgjBwDAYEaetZ6Skln8TAarVMlHaWl8hMVEbDuzsf3Mdidvv6Ag35vexx55GWSzeRQ/E8oktp3Z2H5mu1u3H0UOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGMzIrzEFbkXvGbtcHcFplo+OdHUEAC7GHjkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGMypnyOfNWuWDh48qKtXr6p///7atWuXjh49Kj8/P0lSTEyMmjZtqvj4eK1atUru7u567rnn1KVLF2fGAgDgjuG0It+3b59OnjypdevWKS0tTR06dNATTzyh4cOHq1mzZo75srKytGDBAsXFxcnT01OdO3dWy5YtHWUPAABuzmlF/vjjj6t27dqSpIoVKyo7O1t5eXmF5jt8+LBq1aolX19fSVK9evWUmJioyEiuWAUAQHGcVuQeHh7y8fGRJMXFxalx48by8PDQ2rVrtWLFCgUEBGjChAlKTU2Vv7+/Yzl/f3+lpKQUue5KlXxks3k4K3qZEBTk6+oIMAC/J78/XlOz3Y3bz+nXWt+5c6fi4uK0fPlyHTlyRH5+fgoJCdE777yj+fPnKzw8vMD8lmUVu860tCxnxS0TgoJ8lZKS6eoYMAC/J78v/vbMdidvv6LeoDj1rPUvv/xSixcv1tKlS+Xr66uIiAiFhIRIkiIjI3XixAkFBwcrNTXVsUxycrKCg4OdGQsAgDuG0/bIMzMzNWvWLK1cudJx4trQoUM1cuRIPfjgg0pISFD16tVVp04djR8/XhcvXpSHh4cSExM1duxYZ8UCYJA7+ZvrJL69Dr8PpxX5li1blJaWptjYWMe0jh07KjY2VuXKlZOPj4+mT58ub29vjRgxQjExMXJzc9PgwYMdJ74BAICiOa3Iu3btqq5duxaa3qFDh0LToqKiFBUV5awoAADcsbiyGwAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMJszVz5r1iwdPHhQV69eVf/+/VWrVi2NHDlSeXl5CgoK0uzZs+Xl5aX4+HitWrVK7u7ueu6559SlSxdnxgIA4I7htCLft2+fTp48qXXr1iktLU0dOnRQRESEoqOj1bp1a82ZM0dxcXFq3769FixYoLi4OHl6eqpz585q2bKl/Pz8nBUNAIA7htOG1h9//HG99dZbkqSKFSsqOztbCQkJat68uSSpWbNm2rt3rw4fPqxatWrJ19dX3t7eqlevnhITE50VCwCAO4rTitzDw0M+Pj6SpLi4ODVu3FjZ2dny8vKSJAUEBCglJUWpqany9/d3LOfv76+UlBRnxQIA4I7i1GPkkrRz507FxcVp+fLlevrppx3TLcu64fw3m/5blSr5yGbz+N0ylkVBQb6ujgAD8HtiNrbf7+9ufE2dWuRffvmlFi9erGXLlsnX11c+Pj66cuWKvL29de7cOQUHBys4OFipqamOZZKTk1W3bt0i15uWluXM2C4XFOSrlJRMV8eAAfg9MRvb7/d1J//vLOoNitOG1jMzMzVr1iwtWbLEceLak08+qe3bt0uSduzYoUaNGqlOnTr67rvvdPHiRV2+fFmJiYlq0KCBs2IBAHBHcdoe+ZYtW5SWlqbY2FjHtBkzZmj8+PFat26dqlSpovbt28vT01MjRoxQTEyM3NzcNHjwYPn63n1DIwAA3A6nFXnXrl3VtWvXQtNXrFhRaFpUVJSioqKcFQUAgDsWV3YDAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgNlcHAADcmXrP2OXqCE61fHSkqyNIYo8cAACjUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGc2qRnzhxQi1atNDatWslSaNHj9Zf//pX9ezZUz179tTnn38uSYqPj1enTp3UpUsXffDBB86MBADAHcXmrBVnZWVpypQpioiIKDB9+PDhatasWYH5FixYoLi4OHl6eqpz585q2bKl/Pz8nBUNAIA7xm3vkScmJhZ5v5eXl5YuXarg4OAi5zt8+LBq1aolX19feXt7q169esWuGwAAXFOiPfJLly5p06ZNSktLkyTZ7XZt2LBBX3311c1XbLPJZiu8+rVr12rFihUKCAjQhAkTlJqaKn9/f8f9/v7+SklJKTJPpUo+stk8ShLdWEFBvq6OAAPwe2I2tp/Zysr2K1GRx8bGqkqVKvrqq6/UqlUr7dmzR5MmTbrlB3v22Wfl5+enkJAQvfPOO5o/f77Cw8MLzGNZVrHrSUvLuuXHNklQkK9SUjJdHQMG4PfEbGw/s5Xm9ivqTUOJhtZzcnL02muv6f7779eoUaO0evVqbd269ZaDREREKCQkRJIUGRmpEydOKDg4WKmpqY55kpOTix2OBwAA15SoyO12u7KyspSfn6+0tDT5+fkpKSnplh9s6NChjuUSEhJUvXp11alTR999950uXryoy5cvKzExUQ0aNLjldQMAcDcq0dD6s88+q/Xr16tLly565pln5O/vr4ceeqjIZY4cOaKZM2fq7Nmzstls2r59u3r06KHY2FiVK1dOPj4+mj59ury9vTVixAjFxMTIzc1NgwcPlq9v2TjuAABAWVeiIm/Tpo0qVqwo6drw+Pnz54st27CwMK1Zs6bQ9FatWhWaFhUVpaioqJJEAQAAv1Hs0Hp+fr4GDx4sy7KUn5+voKAg/elPf9KgQYNKIx8AAChCkXvkH3/8sd5++22dPn3acZKaJLm7u+upp55yejgAAFC0Iou8bdu2atu2rd5++20NHTq0tDIBAIASKtFZ6/369dM//vEPvfHGG5KuXY0tJyfHqcEAAEDxSlTkkydP1i+//KJ9+/ZJko4eParRo0c7NRgAACheiYr8p59+0pgxY+Tt7S1Jio6OVnJyslODAQCA4pWoyK9fM93NzU3StW8su3LlivNSAQCAEinR58ijoqL0wgsv6MyZM5o6daq++OILRUdHOzsbAAAoRomKvEePHqpdu7b2798vLy8vzZkzR2FhYc7OBgAAilFkkR87dkw1a9bU3r17JUmhoaGSpMzMTO3du1c2m00hISGqUKGC85MCAIBCiizyTZs2qWbNmlq4cOEN77fb7bp8+bI2b97slHAAAKBoRRb5mDFjJEmjR4927I3/q6lTp/7+qQAAQImU6Kz1mTNn3vS+8ePH/25hAADArSnRyW5VqlRRz549VadOHXl6ejqmDxs2zGnBAABA8UpU5A888IAeeOABZ2cBAAC3qERFPmTIEGVlZenUqVNyc3PTI488onLlyjk7GwAAKEaJinznzp2aNGmS7rvvPuXn5ys1NVVTpkxRkyZNnJ0PAAAUoURFvmzZMsXHx8vf31+SdO7cOQ0bNowiBwDAxUp01rqnp6ejxCWpcuXKBU56AwAArlGiPfLy5ctr+fLlevLJJyVJX375pcqXL+/UYAAAoHglKvK///3veuutt7R582a5ubmpTp06mjZtmrOzAQCAYhQ7tP7JJ58oICBAr732mqpWrSpvb2/98ssvjq80BQAArlNkka9evVrz5s3T1atXJV07yS02NlZhYWFavHhxqQQEAAA3V+TQ+ocffqiVK1fKZrs2m6enpxo2bKjw8HB169atVAICAICbK3KP3MfHRwEBAY7bf/3rXyVdK3QfHx/nJgMAAMUqssizsrIK3H7uueccP2dmZjonEQAAKLEii/zRRx/V+vXrC01/55139Oc//9lpoQAAQMkUeYz8lVde0aBBg/TRRx8pLCxMeXl5OnTokCpVqqRFixaVVkYAAHATRRZ5YGCg1q9fr7179+rkyZPy8PBQ69at1aBBg9LKBwAAilCiC8JEREQoIiLC2VkAAMAtKtG11gEAQNlEkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMGcWuQnTpxQixYttHbtWknSr7/+qp49eyo6OlrDhg1Tbm6uJCk+Pl6dOnVSly5d9MEHHzgzEgAAdxSnFXlWVpamTJmiiIgIx7R58+YpOjpa7733nh566CHFxcUpKytLCxYs0MqVK7VmzRqtWrVK6enpzooFAMAdxWlF7uXlpaVLlyo4ONgxLSEhQc2bN5ckNWvWTHv37tXhw4dVq1Yt+fr6ytvbW/Xq1VNiYqKzYgEAcEexOW3FNptstoKrz87OlpeXlyQpICBAKSkpSk1Nlb+/v2Mef39/paSkFLnuSpV8ZLN5/P6hy5CgIF9XR4AB+D0xG9vPbGVl+zmtyItjWdYtTf+ttLSs3ztOmRIU5KuUlExXx4AB+D0xG9vPbKW5/Yp601CqZ637+PjoypUrkqRz584pODhYwcHBSk1NdcyTnJxcYDgeAADcXKkW+ZNPPqnt27dLknbs2KFGjRqpTp06+u6773Tx4kVdvnxZiYmJatCgQWnGAgDAWE4bWj9y5Ihmzpyps2fPymazafv27Xr99dc1evRorVu3TlWqVFH79u3l6empESNGKCYmRm5ubho8eLB8fcvGcQcAAMo6pxV5WFiY1qxZU2j6ihUrCk2LiopSVFSUs6IAAHDH4spuAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxmK80HS0hI0LBhw1S9enVJUo0aNdSnTx+NHDlSeXl5CgoK0uzZs+Xl5VWasYrVe8YuV0dwquWjI10dAQBwm0q1yCWpYcOGmjdvnuP2mDFjFB0drdatW2vOnDmKi4tTdHR0accCAMBILh9aT0hIUPPmzSVJzZo10969e12cCAAAc5T6HvkPP/ygAQMGKCMjQ0OGDFF2drZjKD0gIEApKSnFrqNSJR/ZbB7OjnrXCArydXUE3Ca2ndnYfmYrK9uvVIv84Ycf1pAhQ9S6dWslJSXp+eefV15enuN+y7JKtJ60tCxnRbwrpaRkujoCbhPbzmxsP7OV5vYr6k1DqQ6tV65cWc8884zc3NxUtWpVBQYGKiMjQ1euXJEknTt3TsHBwaUZCQAAo5VqkcfHx+vdd9+VJKWkpOj8+fPq2LGjtm/fLknasWOHGjVqVJqRAAAwWqkOrUdGRuqVV17Rp59+KrvdrkmTJikkJESjRo3SunXrVKVKFbVv3740IwEAYLRSLfIKFSpo8eLFhaavWLGiNGMAAHDHcPnHzwAAwO2jyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCKHAAAg1HkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGAwihwAAINR5AAAGIwiBwDAYBQ5AAAGo8gBADAYRQ4AgMEocgAADEaRAwBgMIocAACDUeQAABiMIgcAwGAUOQAABqPIAQAwGEUOAIDBKHIAAAxGkQMAYDCbqwNcN23aNB0+fFhubm4aO3asateu7epIAACUeWWiyPfv36/Tp09r3bp1+vHHHzV27FitW7fO1bEAACjzysTQ+t69e9WiRQtJUrVq1ZSRkaFLly65OBUAAGVfmdgjT01NVWhoqOO2v7+/UlJSVKFChRvOHxTkW1rRJEmb33i2VB8Pvy+2n7nYdmZj+5WOMrFH/q8sy3J1BAAAjFAmijw4OFipqamO28nJyQoKCnJhIgAAzFAmivwvf/mLtm/fLkk6evSogoODbzqsDgAA/r8ycYy8Xr16Cg0NVbdu3eTm5qaJEye6OhIAAEZwszggDQCAscrE0DoAALg9FDkAAAajyAEAMBhFDgCAwShy4N/02muvFZoWGxvrgiTA3WX37t2ujlAmlImPn93NBg8erAULFuiJJ56Qm5ubY7plWXJzc9PevXtdmA5F2b59u1asWKGTJ0/q22+/dUy/evWq7Ha7C5OhpObPn6+1a9c6/vb4uzPL2rVrFR4erooVK7o6ikvx8bMy4ujRowWuNw8z5ObmasaMGYqJiXFMc3d3l7u7uypXruzCZCiJdu3a6f3335ePj4+ro+A2/O1vf9Px48dVtWpVeXp6Ot6IxcXFuTpaqaLIy4jnn39ey5cvl83GIIlp7Ha79uzZo/T0dMftJUuWaOfOnS5OhuLExsZq1qxZ8vLycnUU3IazZ8/ecPr9999fyklci9YoI3x8fPT000/rsccek6enp2P6W2+95cJUKImXX35Z5cuX1/79+xUZGamEhAQNGTLE1bFQAvn5+YqKilLNmjXl4eHh2KPj784M8+fPv+H06dOnl3IS16LIXWz69OkaM2aMevfuLUlKTExUvXr1XJwKtyIjI0Pz589Xz549NWHCBF28eFETJ05U+/btXR0NxejRo4erI+Df0KpVK8fPV69e1Q9I/q4AAAgnSURBVMGDBwvsCN0tKHIX+/777yVJDRs2lHTtHeaAAQNcGQm3yG636+zZs/Lw8NCpU6f0hz/8QadOnXJ1LJTA/v37bzj9+t8jyramTZsWuN2iRQv17dvXNWFciCJ3sX89RYFTFswzbNgwHTlyRAMHDlTfvn116dIlde/e3dWxUAKVKlVy/Gy325WYmMhJigb514+fJScnKykpyUVpXIcid7HffuTsRrdRdu3du1cLFy7UmjVrlJeXp169esnDw0O+vr6qXbu2q+OhBP71DdeLL77IiJhBtm3bVuB2hQoV9Prrr7sojetQ5C525MgRde7cWdK1vfFTp06pc+fOd+3HKEwyd+5cxz+NHTt2KCsrS9u2bVNGRoaGDBmiJk2auDghivPDDz8UuJ2cnMxhEYNMnz5dly5dUmZm5l09mkmRu9jmzZtdHQG36Z577lHVqlUlSV988YXatWsnNzc3+fn5ycPDw8XpUBKTJ092/Ozu7i5PT0+NHTvWhYlwK1599VV98cUXCgwMlKS7dgeIInexu+3zjneS3Nxc5efnKycnR7t37y5wkk1WVpYLk6E4Nzos8s9//lP5+fmujoZbcOTIEX322Wd3/SFJihy4Te3atVPHjh2Vm5urRo0a6Y9//KNyc3M1YcIENWjQwNXxUAQOi9wZ6tSpo7S0NPn7+7s6iktR5MBt6t69u5o2barMzEw99thjkiQvLy81aNBAnTp1cnE6FIXDImbr1KmT3NzclJ+frxYtWuihhx4qcEEfhtYBlNiNDo106dLFBUlwKzgsYrYqVapo9OjRro5RZlDkAO46HBYxW0ZGBucX/QZfmgLgrnT27NkCh0Uk6YMPPlCnTp3k7u7uwmQoTtOmTfXMM8/c9P6RI0eWYhrXY48cwF2JwyLmKleunKpXr+7qGGUGRQ4AMEpgYKA6dOjg6hhlBuNHAACjhIWFuTpCmcIxcgAADMYeOQAABqPIAQAwGCe7AWXQmTNnFBUVpfDwcEnXviu7QYMGGjx4sMqVK6cvvvhCR48e1cCBA2953adPn1avXr20a9euEi+zfPly7dixQ56ensrMzFTTpk01bNiwu/4a10BZQJEDZZS/v7/WrFkjScrJydGMGTM0YsQILVy4UI0bN1bjxo1LJcfBgwf18ccfa/369bLZbMrNzdWAAQOUmJio+vXrl0oGADdHkQMGuOeeezR27Fi1atVKP/zwg7799lt9/fXXev311/XJJ59o2bJl8vLyUl5enmbNmqUHHnigwPKJiYmaOHGi/P39FRoa6pj+448/auLEifLw8NClS5cUGxurRo0aFVg2IyNDdrtdubm5stls8vLy0vLlyx33b9myRWvXrpVlWfL399fUqVNVqVIlhYeHa+DAgdq1a5fsdrsGDBig9evX69SpU5o0aZKeeuopHThwQK+//rq8vLx05coVTZw4UaGhoRo9erSCg4N14sQJnTp1Sp07d1bfvn2VmpqqkSNH6urVq7p06ZKef/55tW/f3rkvPlDGcYwcMISnp6fCwsJ04sSJAtMvXryouXPnas2aNWrSpIn+8Y9/FFp21qxZeuWVV7Rq1SoFBQU5pqempmrYsGFatWqVxo8fr7lz5xZatlGjRnrkkUfUpEkTvfTSS3rvvfd04cIFSdKvv/6qxYsXa+XKlfrP//xPNWzYUEuWLJF07ZrlYWFhev/99+Xj46Ndu3Zp6dKlGjRokN577z1JUnp6uiZNmqTVq1fr+eefdywrSUlJSVq8eLGWL1+uxYsXS5KSk5PVvXt3rV69WosXL9b06dP/zVcVMB975IBBMjMzC10+NDAwUKNGjZJlWUpJSXEcV/+t//mf/3EMgz/xxBOOIfugoCDNmjVLc+fOld1uV3p6eqFlPT09NW/ePP3yyy/as2eP9uzZozlz5mj58uU6c+aMUlJSFBMTI+nal5H8djTg+mNWrlxZ9erVkyTdd999yszMdGSfNWuWcnJylJmZqXvvvdexbMOGDSVduwLbpUuXlJeXp+DgYC1btkzLli2Th4fHDfMCdxuKHDBEdna2vv/+e4WGhuqbb76RdO0kuNjYWH344Yd6+OGHtXbtWh05cuSGy19/A5CXl+eYNmXKFLVp00adO3fWiRMnNGDAgELL5eXlKS8vT1WrVlXVqlX1t7/9TXPnzlV8fLyeeOIJ1a5du8Ce9G/99itBb/T1oCNHjtTkyZMVERGhzz77rMCQvc1W8N+TZVl688039dBDD2nOnDm6fPmy480BcDdjaB0wgN1u19SpU/WXv/xFDz74oGP65cuX5e7urvvvv185OTn69NNPlZubW2j5atWq6b//+78lSV9//bVjempqquOa1Vu2bLnhsm+++aYmT56s/Px8SdcK9cyZM6patapq1aqlb7/9VikpKZKkrVu3aufOnSV+XtcfPy8vT9u2bbvh499ofkn6+OOP5e7uXuwywJ2OIgfKqAsXLqhnz56Kjo5Whw4dVKFCBU2bNq3APH5+fmrbtq06d+6s2NhYxcTEaN++fdq6dWuB+f7jP/5D06ZNU9++fXX58mXH9N69e2vkyJGKiYlR/fr1de+992rGjBkFlh08eLDuuecedenSRT179lS3bt1UuXJlRUdHq3Llyho3bpz69++v7t27Ky4uTnXr1i3xc+zbt69eeOEFDRgwQB06dNCvv/6qlStX3nT+Hj166K233lKvXr1Uvnx5RUREaMSIESV+POBOxCVaAQAwGHvkAAAYjCIHAMBgFDkAAAajyAEAMBhFDgCAwShyAAAMRpEDAGCw/wfv9q8QV4aS2AAAAABJRU5ErkJggg==", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotar gráfico de gorjetas por dia da semana\n", "tips.groupby(['day'])['tip'].sum().plot.bar(title='Gorjetas por dia da semana')\n", "plt.xlabel(\"Dia da Semana\")\n", "plt.ylabel(\"Gorjeta\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "C9Ts-OalyUuF", "outputId": "d4c563e5-01fe-4433-da01-3d8d394edbf0" }, "outputs": [ { "data": { "text/plain": [ "day\n", "Fri 51.96\n", "Sat 260.40\n", "Sun 247.39\n", "Thur 171.83\n", "Name: tip, dtype: float64" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tips.groupby(['day'])['tip'].sum()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 390 }, "id": "VgfcupASynG3", "outputId": "2ce7c708-d114-4575-bcb2-e3ccdd3de605" }, "outputs": [ { "data": { "text/plain": [ "Text(0, 0.5, 'Receitas')" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfgAAAFjCAYAAADRiRn/AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de1zOd/8H8NfVVZdE6aA05jDmNHKoMIdQKQnTKMYqm2bMYQy3up1iDuVMZLjnNHYwOSxDsVVoaMhay2hzM2HopFKpq67P7w8P359E98W6uurr9Xw87sfD9T2+P5/ruve6Pp/v9/qmEEIIEBERkawY6LsAIiIiqnwMeCIiIhliwBMREckQA56IiEiGGPBEREQyxIAnIiKSIUN9F0D0pNatW6NJkyZQKpUAgNLSUnTp0gVz5syBiYlJpZ7r2LFjiImJQUhICP773/8iMzMTXbp0+cfHHTp0KAoKClBSUoK0tDS89tprAIAWLVogPDz8qfskJSWhVq1aaNOmTYXHnjlzJjw8PODi4vKP63wRwcHBSEhIAACkpaXBxsYGtWrVAgBERESgbt26VV6Ti4sLli1bBkdHx0o53rlz5zBz5kzExMRUyvHS09OxatUqJCYmQqFQQAiBPn36YOrUqZX+mSaSCKJqplWrVuLvv/+WXhcVFYkJEyaIVatW6fS8mzZtEuHh4ZV6zLS0NNG2bVuttp07d644cOBApZ5f15ydncXZs2f1XUal13H27Fnh7OxcKcfKz88X7u7uYv369aKkpEQIIURWVpb44IMPxLRp0yrlHERPwxE8VXsqlQpOTk7SaKq4uBjLli3DyZMnoVarMXz4cIwfPx4A8Ntvv2HevHnIz8+HtbU1QkJC0LhxY/z555+YP38+0tPToVKpsGTJEtjZ2WHfvn2IjIyEv78/Nm3aBCMjI+Tm5iIoKAjh4eGIjIxEaWkpWrRogeXLl8PMzAypqamYO3cu7t+/D7VaDX9/f/j6+mrVFo1Gg7Vr1yI6OhoA0KlTJ8ybNw/fffcdvvvuO8TExCArKwujR4/GwoULcerUKajVajg4OGDJkiUwMjKCn58fvL29MWTIEKxevRpRUVEAgAYNGmD58uVo0KBBmXP6+fmha9euOHnyJG7cuAEXFxcsWLAASqUSCQkJCA0NRWFhIUxNTTFv3jypX2JiYpCXl4d27dph5syZWrVvz5492Lp1K0pLS2FtbY1ly5ahUaNG2LdvH+Li4mBkZITz58/jtddew8SJE7FixQpcv34dU6ZMwYgRI6DRaJ7Z7qCgIDRs2BAXLlzAtWvX0KxZM2zYsAG1a9eW3vtly5bh1q1bGDhwIP79738DAI4cOYLw8HCUlJTAxsYGixYtQpMmTcrVvmHDBuzevRsWFhZlZkeKioqwePFiJCQkwMDAAH369MG//vUvKJVK7Nq1C19++SWEEKhbty5CQkLQsmXLMsfdv38/6tevj4kTJ0rLLCwssH79emmW6saNG3jnnXfg6emJixcvIjQ0FO7u7rh48aK0/tHrdevW4ebNm8jOzkZqaioaNGiA8PBwWFlZ4datW5g7dy5u3LgBIyMjfPDBB/Dy8kJJSQmCg4Nx7tw5aDQatG7dGqGhoXqZbaEqpO9vGERPenIEf+/ePfHuu++KDRs2CCGEWL9+vRg9erQoKioS+fn5wsvLS8TExAghhHBzcxNxcXFCCCG2bdsmxo4dK0pLS4W7u7v49ttvhRBCnDt3TvTq1Uuo1Wqxd+9eMXr0aCGEEIGBgdIIPjk5WXTv3l3k5eWJ0tJS8d5770nrJk+eLPbt2yeEECIzM1N89NFHoqio6KlteXIE//333wsvLy+Rn58vSkpKxEcffSQd19fXVxrBR0VFiUGDBoni4mLx4MEDMWDAAGndo+1SU1OFu7u7KC4uFkII8cUXX4j9+/eXq8HX11d4e3uLgoICUVBQINzd3cWxY8fE/fv3Rbdu3cS5c+ekc7q7u4vS0lKxd+9e0alTJ3H16tUK36vHR84ZGRmiffv20nsXFBQkZs2aJYQQ0vH++9//iqKiIuHk5CTGjRsnSkpKRExMjOjdu/f/bHdgYKAYMGCAyM7OFmq1Wrz11lviu+++k+qYPn26KCkpEbdv3xbt2rUTt27dEjdv3hQODg7i2rVrQgghtmzZIr3fj/vjjz9Ely5dRHp6uigpKRETJkyQRvCbNm0SY8eOFWq1WhQWFophw4aJAwcOiLy8POHo6Cjy8vKEEEIcPnxYbN68udyxP/74Y7Fp06YK+zEtLU20a9dO+lw9+bl5/HVYWJjo3LmzuH79uhBCiBkzZojFixcLIYQYM2aM2LhxoxBCiBs3bggHBweRlpYmYmNjhb+/v9BoNEKj0YjVq1eLEydOVFgT1Xy8yY6qJT8/P3h4eMDV1RWurq548803MXbsWABAbGwsRo0aBZVKBRMTEwwZMgRHjx7F1atXkZ2djT59+gAAfH19sW7dOunaure3NwDAwcEBlpaWuHDhwjPP3759e8TFxaFu3bowMDBA586dkZaWBgCwsrJCdHQ0UlJSYGFhgQ0bNkClUmnVrri4OHh5ecHExARKpRJDhw7FTz/9VG67/v37Y+/evTAyMkKtWrVgZ2cnnf8RMzMzZGVl4eDBg8jJyYGfnx+8vLyeet6BAweidu3aqF27NpycnHDhwgX8+uuvsLW1hYODg3TO7Oxs3Lx5EwDQrFkzNGvWTKt2PeqX8+fPw9bWFgDg6OhYpubXX38dr732GlQqFZo2bYpevXpBqVSiVatWuHv3rlbt7tOnD8zNzWFoaIhWrVrh77//ltYNHjwYSqUSDRo0gJWVFW7fvo2ffvoJ3bp1Q9OmTQEAPj4+SEhIQElJSZnaz549iy5duqB+/fpQKpV46623pHVxcXEYPnw4DA0NYWxsjMGDB+Onn35CrVq1oFAoEBERgYyMDAwYMED6jD4uNzcXFhYW0uu9e/fCw8MDHh4eePPNN6U2qNVquLm5adXX3bp1Q+PGjQEA7u7uuHDhAtRqNU6dOoVRo0YBABo1aoRu3brhzJkzsLS0xJUrV3Ds2DEUFhZi6tSpcHJy0upcVHNxip6qpZ07d8LW1hZZWVnw8PCAp6cnDA0fflzz8vIQEhKCVatWAXg4Zd+hQwdkZ2fD1NRUOoahoSEMDQ2Rm5uLBw8eYMCAAdK6+/fv4969e888f2FhIUJCQqSbyXJyctC3b18AwIwZM7Bp0yZMnToVRUVFGDduHN59912t2pWVlYV69epJr+vVq4fMzMynbrdw4UJcvHgRCoUCGRkZGD16dJltGjRogHXr1mHr1q1YuHAhunTpggULFuCVV14pd7wnz3n37l1kZWXBzMyszHampqZSPY/vo43S0lKEhYUhJiYGpaWlyM/Pl24uBIA6depI/1YqldLNZUqlEhqNRqt2P/7+KpVKlJaWPvP4paWlyM7OLtNGU1NTCCGQnZ0Na2traXlOTk6ZYz++z7PeMyMjI2zfvh0bN27EunXr0Lp1awQHB6N169Zl+sXS0lL6AgMAw4YNw7BhwwAAb7zxhtQGpVKp9ZS5ubl5mVpzc3Nx7949CCHKtSMrKwsdOnTAnDlzsHPnTgQGBsLFxQXBwcHl3n+SF47gqVqztLSEn58fli9fLi2zsbHBvHnzEBUVhaioKMTExGDNmjWwsLDAvXv3pLBQq9W4ceMGbGxsUKdOHWn7qKgoxMfHVzha2rFjB65du4Z9+/YhOjoaI0aMkNbVqVMH06ZNw7Fjx7B+/XqEhYXh6tWrWrWnfv36Zb5Y3Lt3D/Xr1y+33erVq2FoaIiDBw8iKipKmpV40ptvvonNmzfjp59+wiuvvIIVK1Y8dbvs7Gzp3zk5OahXrx6srKzK1CKEQE5ODqysrLRqy5MOHz6MmJgY7Nq1C9HR0fj444+f+xjatltbT7YxJycHBgYGZUbUwMMgzMvLk14/3l8VvWdvvPEGwsLCcPr0afTq1QvBwcHlaujevTuOHTsG8Rx/1+vRl55H++Tm5pZZ/7T308LCAgYGBsjJySlT66P308PDAzt37kRsbCwKCwuxZcsWreuhmokBT9Xe+++/jwsXLuDnn38GALi6umLPnj0oLS2FEAIbNmzAiRMn0KxZM9ja2uLo0aMAHv5ka968eWjUqBFsbW2lm9GysrIwbdo0FBQUlDmPoaGh9B/5zMxMNG/eHHXq1MHNmzdx/Phxafvx48fjjz/+AAC0atUKdevWhUKh0Kotffv2RWRkJAoLC1FSUoKIiAgpxJ48f6tWraBSqXDp0iVcuHChXL3x8fFYsGABNBoNTExM0KZNm2fWcezYMRQXF6OgoAAnTpyAo6MjOnTogIyMDOlSxaFDh2Bra4tXX31Vq7Y8KTMzE40aNYKlpSWys7Nx5MgR5OfnP/cx/le7n0fPnj1x7tw5aZr/m2++Qc+ePaXZoEc6d+6M8+fPIysrC6WlpYiMjJTW9e3bFxERESgtLUVBQQG+++479OnTB5cvX8bHH3+M4uJiqFQqtG/f/qn9/2i6f/HixSguLgbwMKDnzJkDc3PzMiPuRywsLKBUKnH58mUAwIEDB8qsP3/+vDS1Hx0dDQcHBxgaGqJXr17YvXs3AOD69es4d+4cevTogb1790o/zzQ3N0fz5s2fvzOpxuEUPVV7devWxYcffoilS5ciIiICo0aNwo0bNzBw4EAIIdC+fXuMHj0aCoUCa9euxb/+9S+sWrVKuoteoVBg1apVmD9/PtasWQMDAwO8//775X5/7OzsjBkzZuDmzZuYMmUKPv74Y/Tv3x+tW7dGUFAQJk+ejO3bt8PX1xfTp0+HWq0GAIwaNUrra9UeHh64fPkyhg4dCiEEunXrBn9/fwBAv379sHz5cqSlpWHMmDEIDAzEvn374OjoiMDAQMyePRsdOnSQjtWlSxccOnQI/fv3h0qlgqWlJZYsWfLU83bu3Bn+/v64du0a3Nzc0Lt3bxgYGGDNmjVYuHAhCgoKYGlpiVWrVmn9ZeVJgwYNwqFDh+Dm5obGjRtj6tSp+OijjxAaGopWrVppdQxt2v08bG1tsWjRIkyYMAFqtRqvvvoqFi5cWG67tm3b4p133sHbb78Nc3NzDBw4EKmpqQAe3g+SlpaGgQMHQqFQwMPDQ7rc8+qrr2LQoEEwMjJCnTp1MG/evHLHVqlU2L59O1atWoXBgwcDeHg5w8nJCfv370e9evXKzB4AgLGxMSZPnowPPvgANjY28PPzK7O+R48eWLBgAX7//Xc0bNgQs2fPBgAsWLAAc+bMwb59+2BkZIRFixbhlVdegaurK2bNmgV3d3colUo0bdoUoaGhL9SnVHMoxPPMGxFRjfP4z+qo5lu3bh1u376NxYsX67sUquY4RU9ERCRDDHgiIiIZ4hQ9ERGRDHEET0REJEMMeCIiIhmS1c/k0tPz/vdGVczCwgTZ2S/+O96XBftJe+wr7bCftMe+0k517Cdr6/LPUXiEI3gdMzRU6ruEGoH9pD32lXbYT9pjX2mnpvUTA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhliwBMREckQA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDMnqr8lR1RsTGqPvEsrZGuSi7xKIiPSOI3giIiIZYsATERHJEAOeiIhIhnR6DX7ZsmU4f/48SkpKMG7cOMTExCAlJQXm5uYAgICAAPTt2xeRkZHYsWMHDAwMMHz4cPj4+ECtViMoKAi3bt2CUqlESEgIGjdurMtyiYiIZENnAX/mzBn88ccf2L17N7Kzs/H222/jzTffxLRp0+Ds7CxtV1BQgPDwcERERMDIyAje3t5wc3NDbGwszMzMsHLlSsTHx2PlypVYs2aNrsolIiKSFZ1N0Xfp0gVr164FAJiZmaGwsBClpaXltktKSoKdnR1MTU1hbGwMe3t7JCYm4vTp03BzcwMA9OjRA4mJiboqlYiISHZ0FvBKpRImJiYAgIiICPTu3RtKpRK7du2Cv78/PvnkE2RlZSEjIwOWlpbSfpaWlkhPTy+z3MDAAAqFAsXFxboql4iISFZ0/jv4H374AREREdi6dSt+++03mJubo23btti8eTPWr1+Pzp07l9leCPHU4zxr+eMsLExgaKislLork7W1qb5LeKm8DP39MrSxMrCftMe+0k5N6iedBvzJkyexceNGfP755zA1NUX37t2ldS4uLpg/fz769++PjIwMafndu3fRqVMn2NjYID09HW3atIFarYYQAiqVqsLzZWcX6KwtL8ra2hTp6Xn6LuOlIvf+5mdKO+wn7bGvtFMd+6miLxw6m6LPy8vDsmXLsGnTJumu+cmTJyMtLQ0AkJCQgJYtW6Jjx45ITk5Gbm4u8vPzkZiYCEdHR/Ts2RNRUVEAgNjYWHTr1k1XpRIREcmOzkbwhw8fRnZ2NqZOnSotGzp0KKZOnYratWvDxMQEISEhMDY2xvTp0xEQEACFQoGJEyfC1NQUnp6eOHXqFEaOHAmVSoXQ0FBdlUpERCQ7CqHNxe0aorpNnQDVc0qnMvFZ9FVP7p+pysJ+0h77SjvVsZ/0MkVPRERE+sOAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZMtTlwZctW4bz58+jpKQE48aNg52dHWbOnInS0lJYW1tj+fLlUKlUiIyMxI4dO2BgYIDhw4fDx8cHarUaQUFBuHXrFpRKJUJCQtC4cWNdlktERCQbOgv4M2fO4I8//sDu3buRnZ2Nt99+G927d8eoUaMwYMAArFq1ChEREfDy8kJ4eDgiIiJgZGQEb29vuLm5ITY2FmZmZli5ciXi4+OxcuVKrFmzRlflEhERyYrOpui7dOmCtWvXAgDMzMxQWFiIhIQEuLq6AgCcnZ1x+vRpJCUlwc7ODqampjA2Noa9vT0SExNx+vRpuLm5AQB69OiBxMREXZVKREQkOzoLeKVSCRMTEwBAREQEevfujcLCQqhUKgCAlZUV0tPTkZGRAUtLS2k/S0vLcssNDAygUChQXFysq3KJiIhkRafX4AHghx9+QEREBLZu3Qp3d3dpuRDiqds/7/LHWViYwNBQ+WKF6pC1tam+S3ipvAz9/TK0sTKwn7THvtJOTeonnQb8yZMnsXHjRnz++ecwNTWFiYkJHjx4AGNjY9y5cwc2NjawsbFBRkaGtM/du3fRqVMn2NjYID09HW3atIFarYYQQhr9P0t2doEum/NCrK1NkZ6ep+8yXipy729+prTDftIe+0o71bGfKvrCobMp+ry8PCxbtgybNm2Cubk5gIfX0qOjowEAR48ehZOTEzp27Ijk5GTk5uYiPz8fiYmJcHR0RM+ePREVFQUAiI2NRbdu3XRVKhERkezobAR/+PBhZGdnY+rUqdKy0NBQzJkzB7t370bDhg3h5eUFIyMjTJ8+HQEBAVAoFJg4cSJMTU3h6emJU6dOYeTIkVCpVAgNDdVVqURERLKjENpc3K4hqtvUCVA9p3Qq05jQGH2XUM7WIBd9l6BTcv9MVRb2k/bYV9qpjv2klyl6IiIi0h8GPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhnQa8KmpqejXrx927doFAAgKCsLgwYPh5+cHPz8/xMXFAQAiIyMxbNgw+Pj4YM+ePQAAtVqN6dOnY+TIkfD19UVaWpouSyUiIpIVQ202UqvVyMzMhK2tLS5duoRLly6hf//+qF279jP3KSgowMKFC9G9e/cyy6dNmwZnZ+cy24WHhyMiIgJGRkbw9vaGm5sbYmNjYWZmhpUrVyI+Ph4rV67EmjVrXrCZRERELxetRvBBQUH45ZdfcOfOHUyePBmpqakICgqqcB+VSoX//Oc/sLGxqXC7pKQk2NnZwdTUFMbGxrC3t0diYiJOnz4NNzc3AECPHj2QmJioZZOIiIhIq4C/c+cOPDw8cPjwYYwaNQozZ85ETk5OhfsYGhrC2Ni43PJdu3bB398fn3zyCbKyspCRkQFLS0tpvaWlJdLT08ssNzAwgEKhQHFx8fO0jYiI6KWl1RR9cXExhBA4duwYFi9eDADIz89/7pMNGTIE5ubmaNu2LTZv3oz169ejc+fOZbYRQjx132ctf5yFhQkMDZXPXZeuWVub6ruEl8rL0N8vQxsrA/tJe+wr7dSkftIq4Lt27QoHBwc4OTnhtddew/bt29G8efPnPtnj1+NdXFwwf/589O/fHxkZGdLyu3fvolOnTrCxsUF6ejratGkDtVoNIQRUKlWFx8/OLnjumnTN2toU6el5+i7jpSL3/uZnSjvsJ+2xr7RTHfupoi8cWk3Rz5gxA3FxcVi7di0AwNXVFT4+Ps9dyOTJk6W74RMSEtCyZUt07NgRycnJyM3NRX5+PhITE+Ho6IiePXsiKioKABAbG4tu3bo99/mIiIheVlqN4O/fv4+DBw8iOzsbwMO76vfu3Yv4+Phn7vPbb79h6dKluHnzJgwNDREdHQ1fX19MnToVtWvXhomJCUJCQmBsbIzp06cjICAACoUCEydOhKmpKTw9PXHq1CmMHDkSKpUKoaGhldNiIiKil4BCaHFx+4MPPkDDhg0RHx+P/v3746effsLHH3+Mfv36VUWNWqtuUydA9ZzSqUxjQmP0XUI5W4Nc9F2CTsn9M1VZ2E/aY19ppzr20z+eoi8qKsKnn36KRo0aITAwEF988QWOHDlSaQUSERFR5dIq4NVqNQoKCqDRaJCdnQ1zc3M+WY6IiKga0+oa/JAhQ/Dtt9/Cx8cHnp6esLS0RNOmTXVdGxEREb0grQJ+4MCBMDMzA/Dwp26ZmZkwNa05vwUkIiJ62fzPKXqNRoOJEydCCAGNRgNra2u8/vrrmDBhQlXUR0RERC+gwhH8999/j3Xr1uGvv/5C27ZtpeUGBgbo1auXzosjIiKiF1NhwA8aNAiDBg3CunXrMHny5KqqiYiIiP6hCgP++PHj6NOnD2xtbREREVFuvbe3t84KIyIiohdXYcBfvnwZffr0eeafamXAExERVU8VBvyHH34IAAgJCYFGo0FmZiasra2rpDAiIiJ6cVo96Ob06dPo168f/Pz8AABLlixBXFycLusiIiKif0CrgF+9ejW+/fZbafQ+fvx4bNiwQaeFERER0YvTKuBNTExQv3596bWlpSWMjIx0VhQRERH9M1o9yc7Y2Bg///wzACAnJweHDh1CrVq1dFoYERERvTitRvDBwcHYsmULkpOT4e7ujpMnT+LTTz/VdW1ERET0grQawb/yyitYsWKF9Pz5jIyMMlP2REREVL1oNYL/8ssvERgYKL2eNm0adu3apbOiiIiI6J/RKuAjIyMRFhYmvd66dSu+//57nRVFRERE/4xWAV9aWgpDw/+fzVcoFBBC6KwoIiIi+me0ugbv4uKCd955Bw4ODtBoNDhz5gzc3d11XRsRERG9IK0CfsKECejatSt+/fVXKBQKBAcHo1OnTrqujYiIiF6QVlP0AHD//n2oVCq8//77sLS05BQ9ERFRNaZVwC9fvhwRERHYt28fAODgwYNYtGiRTgsjIiKiF6dVwJ89exbr169HnTp1AAATJ05ESkqKTgsjIiKiF6dVwD96LK1CoQDw8K760tJS3VVFRERE/4hWN9nZ29sjKCgId+/exbZt2xAdHY2uXbvqujYiIiJ6QVoF/HvvvYeEhATUrl0bt2/fxpgxY9C2bVtd10ZEREQvqMKAP3fuHD755BMUFxfDwsICmzZtQtOmTbFr1y4sWrQIJ06cqKo6iYiI6DlUGPCrV6/G9u3b0aJFC/z444+YN28eNBoN6tWrhz179lRVjURERPScKrzJzsDAAC1atAAAuLq64ubNm/D398f69evRoEGDKimQiIiInl+FAf/orvlHXnnlFbi5uem0ICIiIvrntH6SHVA+8ImIiKh6qvAa/IULF9C3b1/pdWZmJvr27QshBBQKBeLi4nRcHhEREb2ICgM+KiqqquogIiKiSlRhwDdq1Kiq6iAiIqJK9FzX4ImIiKhmYMATERHJEAOeiIhIhhjwREREMsSAJyIikiEGPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZqvBJdkREVW1MaIy+Syhna5CLvksgem4cwRMREcmQTgM+NTUV/fr1w65duwAAf//9N/z8/DBq1ChMmTIFxcXFAIDIyEgMGzYMPj4+2LNnDwBArVZj+vTpGDlyJHx9fZGWlqbLUomIiGRFZwFfUFCAhQsXonv37tKysLAwjBo1Cl999RWaNm2KiIgIFBQUIDw8HNu3b8fOnTuxY8cO3Lt3D99//z3MzMzw9ddfY/z48Vi5cqWuSiUiIpIdnQW8SqXCf/7zH9jY2EjLEhIS4OrqCgBwdnbG6dOnkZSUBDs7O5iamsLY2Bj29vZITEzE6dOn4TWU3tkAABabSURBVObmBgDo0aMHEhMTdVUqERGR7Ogs4A0NDWFsbFxmWWFhIVQqFQDAysoK6enpyMjIgKWlpbSNpaVlueUGBgZQKBTSlD4RERFVTG930QshKmX54ywsTGBoqPxHdemCtbWpvkt4qbwM/f0ytLE6eRn6+2VoY2WoSf1UpQFvYmKCBw8ewNjYGHfu3IGNjQ1sbGyQkZEhbXP37l106tQJNjY2SE9PR5s2baBWqyGEkEb/z5KdXaDrJjw3a2tTpKfn6buMl4rc+5ufqaon9/7mZ0o71bGfKvrCUaU/k+vRoweio6MBAEePHoWTkxM6duyI5ORk5ObmIj8/H4mJiXB0dETPnj0RFRUFAIiNjUW3bt2qslQiIqIaTWcj+N9++w1Lly7FzZs3YWhoiOjoaKxYsQJBQUHYvXs3GjZsCC8vLxgZGWH69OkICAiAQqHAxIkTYWpqCk9PT5w6dQojR46ESqVCaGiorkolIiKSHZ0FfPv27bFz585yy7dt21ZumYeHBzw8PMosUyqVCAkJ0VV5REREssYn2REREckQA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhnS2x+bIXqZjAmN0XcJ5WwNctF3CUSkQxzBExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkiAFPREQkQwx4IiIiGWLAExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkiAFPREQkQwx4IiIiGWLAExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkiAFPREQkQwx4IiIiGWLAExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkiAFPREQkQwx4IiIiGWLAExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkyLAqT5aQkIApU6agZcuWAIBWrVrhgw8+wMyZM1FaWgpra2ssX74cKpUKkZGR2LFjBwwMDDB8+HD4+PhUZalEREQ1WpUGPAB07doVYWFh0ut///vfGDVqFAYMGIBVq1YhIiICXl5eCA8PR0REBIyMjODt7Q03NzeYm5tXdblEREQ1kt6n6BMSEuDq6goAcHZ2xunTp5GUlAQ7OzuYmprC2NgY9vb2SExM1HOlRERENUeVj+D//PNPjB8/Hjk5OZg0aRIKCwuhUqkAAFZWVkhPT0dGRgYsLS2lfSwtLZGenl7VpRIREdVYVRrwzZo1w6RJkzBgwACkpaXB398fpaWl0nohxFP3e9byJ1lYmMDQUFkptVYma2tTfZfwUmF/a4f9pL2Xoa9ehjZWhprUT1Ua8A0aNICnpycAoEmTJqhfvz6Sk5Px4MEDGBsb486dO7CxsYGNjQ0yMjKk/e7evYtOnTr9z+NnZxforPYXZW1tivT0PH2X8VJhf2uH/aQ9ufcV/zulnerYTxV94ajSa/CRkZHYsmULACA9PR2ZmZkYOnQooqOjAQBHjx6Fk5MTOnbsiOTkZOTm5iI/Px+JiYlwdHSsylKJiIhqtCodwbu4uGDGjBn48ccfoVarMX/+fLRt2xaBgYHYvXs3GjZsCC8vLxgZGWH69OkICAiAQqHAxIkTYWpac6ZFiIiI9K1KA75u3brYuHFjueXbtm0rt8zDwwMeHh5VURYREZHs6P1nckRERFT5GPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhliwBMREckQA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhliwBMREckQA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhliwBMREckQA56IiEiGGPBEREQyxIAnIiKSIQY8ERGRDDHgiYiIZIgBT0REJEMMeCIiIhliwBMREckQA56IiEiGDPVdABERPb8xoTH6LqGcrUEu+i6BHsMRPBERkQxxBE9ERLL1Ms90cARPREQkQwx4IiIiGWLAExERyRADnoiISIYY8ERERDLEgCciIpIhBjwREZEMMeCJiIhkiAFPREQkQwx4IiIiGarWj6pdsmQJkpKSoFAoMGvWLHTo0EHfJREREdUI1Tbgf/75Z/z111/YvXs3rly5glmzZmH37t1Vcu7q+OxigH+piYiItFdtp+hPnz6Nfv36AQBatGiBnJwc3L9/X89VERER1QzVNuAzMjJgYWEhvba0tER6eroeKyIiIqo5FEIIoe8inmbu3Lno06ePNIofOXIklixZgtdee03PlREREVV/1XYEb2Njg4yMDOn13bt3YW1trceKiIiIao5qG/A9e/ZEdHQ0ACAlJQU2NjaoW7eunqsiIiKqGartXfT29vZo164d3nnnHSgUCgQHB+u7JCIiohqj2l6DJyIiohdXbafoiYiI6MUx4ImIiGSIAU9ERCRDDPgqkpubq+8Sqp2n3f5x+/ZtPVRSc2RlZem7hBrh9OnT+i6hRigpKcHNmzdRUlKi71KqvZr4/z0GfBWZNGmSvkuoNo4dOwZnZ2d0794dgYGBZR5BPHPmTD1WVr3ExcWhf//+eO+995Camoq33noLfn5+cHFxwfHjx/VdXrVx4MCBMv/bv38/goODpdf0/xYtWiT9+9SpU3Bzc8PUqVPh7u6OkydP6rGy6uX48eOYN28egIdfFp2dneHv7w8XFxfExcXpt7jnUG1/JlcTffnll89cd+fOnSqspHrbvHkz9u/fDzMzM+zZswcBAQH4/PPPYWpq+tRR/cvqs88+w7Zt23Dr1i2MHz8eGzZsQJs2bZCRkYHx48ejT58++i6xWggPD4e5uXmZ/igqKsKNGzf0WFX1dPnyZenf4eHh+OKLL9C4cWOkp6dj0qRJcHJy0mN11UdYWBg2bdoEoGw/ZWdnY9y4cejbt69+C9QSA74Sbd++Hd27d4eNjU25dZwC+39KpRLm5uYAgBEjRsDKygoBAQHYuHEjFAqFnqurPlQqFRo2bIiGDRvCxsYGbdq0AQDUr18ftWrV0nN11cf333+PDRs24PLlywgKCkKjRo1w8uRJzpo9xeP//6pXrx4aN24MALC2toahIePgkZKSEtSpUwcAYGpqildffRUAYG5uXqMGIXxHK1F4eDgWLVqEOXPmQKVSlVmXkJCgp6qqH3t7e4wbNw5r166FsbEx+vXrh1q1auG9997DvXv39F1etWFlZYUtW7YgICAA33zzDYCH9yhs3boVtra2eq6u+qhVqxY++eQT/Pe//8Wnn36Kzp07Q6PR6LusaumPP/7AlClTIITAX3/9hSNHjmDAgAHYunUrTE1N9V1etREQEAAvLy/07NkT5ubmmDBhAjp37oyEhAT4+Pjouzyt8UE3laywsBC1atWCgUHZ2xtSUlLQrl07PVVV/SQkJKBr165lRhT379/H4cOHMXz4cD1WVn08ePAAMTEx8PT0lJalpKTg7NmzGDlyJEfxz3DgwAEcP34cq1ev1ncp1c7PP/9c5nXTpk3RoEEDHDx4EC4uLtKolYB79+7h1KlTuHnzJoQQqF+/Pnr27IkGDRrouzStMeCJiIhkiHfRExERyRADnoiISIYY8FQtLVu2DH5+fhg+fDjat28PPz8/+Pn5Venvmm/cuIHevXtXyrFOnToFPz+/59onPj4evr6+8Pb2ho+PD0aPHo3k5ORKqaeq7du3D3Z2drh+/bq07MaNG+X65Ntvv8W8efOqza9OZsyYgX379mm9vYuLC3x8fODn5wdfX1/4+/sjNTVVhxUSPRvvoqdq6dEDb27cuIFRo0Zh586deq6oal26dAnz58/H5s2b0bx5cwDAjz/+iAkTJiA6OhomJiZ6rvD5vf7661iyZAk2btz41PUlJSWwtbWt8TdZrlixAk2bNgXw8GFFQUFBz/UlgaiyMOCpRjl37hxWrFgBlUqFBw8eIDg4GO3atUNQUBAsLCxw5coV/Pnnn5g+fTpiYmKQmpoKe3t7LFiwAAUFBQgMDMS9e/eQn58PDw8PfPjhh0hISMDmzZtha2uLP//8E4aGhvj888+lc65evRpnz55FQUEBNm3ahAYNGiAuLg7h4eEwNjZG7dq1sXDhwnJ31/7www9YvXo1bG1tpf/gA8DVq1cRHBwMIQRKSkowffp0ODo6ltn3888/x4cffiiFOwC4urrCyclJ+gmmvb09vL29odFo4ObmhjVr1uDrr78GAAQFBcHBwQHdu3fHe++9h969e+PSpUtSe7Rtw6VLl7B06VKUlJRArVZj3rx5eOONN+Dn5wdHR0f8+uuvuHbtGmbNmoUDBw4gNTUVXl5e+Oijj8q9dy4uLvjll19w/Pjxcg/peVTvo58gtW7dGikpKfjss8+Qnp6OjIwMXLp0CWPHjsXvv/+O3377DTY2Nvjss8+gUCiwc+dOHDlyBKWlpWjevDmCg4ORkZGBjz76CK1atULLli0xduxYLFmyBCkpKQCAN998E1OnTi1Th0ajwezZs3H58mU0atQIBQUF0rrDhw9j165dEELA0tISixYtgoWFRbl2Ps7R0RFXr14FAOTk5CA4OBhZWVm4f/8+3n//fQwePBhnzpzBypUrYWxsjOLiYsyePRtvvPEG5syZg6tXr0KhUKBt27YIDg5GQUEB5s6di9u3b6OkpARDhgzBqFGjnvnZvnPnDmbMmAHg4a8yRowYAW9v7wprJhkRRNVYWlqacHJykl4fO3ZM/P7770IIIQ4ePCgmT54shBAiMDBQzJgxQwghxN69e0XXrl1FTk6OKCwsFHZ2diInJ0dcv35d7N+/XwghRFFRkbC3txd5eXnizJkzwt7eXmRkZAghhPD19RVHjx4VaWlpom3btuLy5ctCCCFmzZoltmzZIgoKCkTPnj3F33//LYQQYufOnSIoKKhc7U5OTuLPP/8UQgixcOFC4evrK4QQYsyYMeLw4cNCCCEuXbokXFxcyu07ZMgQkZKSUmHftG7dWsTHxwshhDhz5ox45513pHWBgYHi22+/FWlpaaJVq1YiOTlZCCHE6tWrxZIlS7Ruw6BBg8Rff/0lhBDi999/F2+//bbUR6tXrxZCCBEWFiY8PDxEUVGRSEtLEw4ODuWOs3fvXhEWFiauXLkiPD09pW0f9cmjeh9p1aqVUKvVIiwsTLz77rtCo9GIM2fOiDfeeEP89ddfQqPRCGdnZ3Hx4kWRlJQk/Pz8hEajEUIIsXjxYvHFF19I79+VK1eEEA8/Lx9++KHQaDSipKREeHt7i4SEhDJ1njx5UgwfPlxoNBqpj/bu3Stu3bolBg8eLIqKioQQQmzfvl2EhISUa6ezs7O4du2a9HrPnj0iICBACCHE/PnzRUREhBBCiPz8fNGvXz+RmZkpxo8fLw4dOiSEEOLKlSvihx9+ECkpKcLDw0M6zu7du0Vubq7YuHGjmD9/vhBCiMLCQuHs7CyuX7/+zM/2tm3bxLx584QQQjx48EDs3LmzXM0kXxzBU41Sv359LFu2DEVFRcjLy0O9evWkdfb29gAAW1tbNG/eHGZmZgAePn0qLy8PVlZWOH/+PL755hsYGRmhqKhIerBOixYtYGVlBQBo1KiRtNzCwgKtWrWSjpubm4tr167ByspKethM165dpQfRPJKdnY2ioiK0aNECwMPR4qPHhCYlJUm/0W7dujXu37+PrKwsWFpaSvsbGBiUuQ49adIk5OTkIDs7GxMmTICnpyeEEFKbK2Jubo727dtLfbRjxw6t2pCZmYmrV69i9uzZ0rL79+9LD5F5vL/btWsHlUoFW1tb5OXlPbOW5s2bo0+fPti6dSsGDRr0P2sHgE6dOkGhUMDW1hZWVlZo0qQJAKBBgwbIy8tDUlISrl+/Dn9/fwBAQUGB9FS2evXqSbMgSUlJ6N69OxQKBZRKJRwdHZGcnIyuXbtK50pNTUXnzp2hUChQu3ZtdOjQAQBw4cIFpKenIyAgAABQXFwsPd3sSTNmzICxsTE0Gg0aNWqEJUuWAHj47Ifk5GTpPhJDQ0PcuHEDgwcPxqpVq/Drr7/C1dUVrq6uKCoqgoWFBcaOHQtnZ2cMGDAApqamSEpKwtChQwEAxsbGaN++PVJSUtC7d++nfradnJzw1VdfISgoCH369MGIESO06nOSBwY81SgzZ87EggUL0L17d8TGxmLr1q3SuscftfnkYzeFENixYweKi4vx9ddfQ6FQoFu3btJ6pVL51PM9uVwIUe5xutosKy0tlf79tMfxPrmsdevW+OWXX6SAWb9+PYCHU9n5+fnSdkZGRk/dX61Wl6nlybq0aYNKpYKRkdEz73+oqL8rMmHCBAwbNqzMZYnHz11cXFxm+8ffg6e9ryqVCi4uLtIfB3nkxo0bUv88eY5H+/6vZY++zKhUKnTo0EF6PnlFHr8G/ziVSoXg4GDY2dmVWd6hQwf06tUL8fHxCA8PR4cOHTBt2jR89dVXSElJQWxsLLy9vaXP7dPqfdZnu0WLFjh06BDOnj2LqKgo7Nixo9wXOZIv3kVPNUpGRgZatmyJ0tJSREVFlQuDimRmZqJFixZQKBT48ccf8eDBg+fa/5FmzZohMzMTt27dAvDwr0117NixzDYWFhZQKpW4du0agId30T/SsWNHxMfHAwAuXrwIc3Pzctdyx48fj+3bt+P333+Xlt2+fRuXLl166hPs6tatizt37kAIgcLCQiQlJUnrcnJycPHiRQBAYmIiWrdurVUbHj2D+9Ffrrt69ar0ReOfqFu3LiZOnIjly5dLy+rUqYO///5bquV5/iaBvb09Tpw4IX3x+fLLL3HhwoVy23Xq1AmnTp2S7n34+eefy7X59ddfR1JSEoQQuH//vtSPdnZ2+PXXX5Geng4AOHLkCH744YfnareDgwOOHDkC4OH18Pnz56OkpARhYWEoLS2Fp6cnZs+ejQsXLiA5ORn79+9Hu3btMGnSJLRr1w7Xrl1Dx44dpb/6VlBQID0h81mf7YMHDyI5ORk9evRAcHAw/v7772rzCwXSPY7gqUYZO3YsRo8ejYYNGyIgIAAzZ87E9u3btdp32LBhmDZtGuLj4+Hq6orBgwdjxowZCAwMfK4ajI2NsXjxYnzyySdQqVQwMTHB4sWLy2yjUCgwa9YsTJw4EY0bNy4zops7dy6Cg4Px9ddfo6SkBMuWLSt3jqZNm2Ljxo0ICQlBbm4uatWqBY1GA19fX7z11lvltm/Tpg1at26Nt99+G02aNEHnzp2ldQ0aNMC+ffsQGhoKIQRWrVqlVRsAYOnSpVi0aBE2b96MkpISBAUFPVdfPctbb71VZiTp7e2NKVOm4OzZs+jVq9dzPRfdzs4O7777Lvz8/FCrVi3Y2Nhg6NChyMzMLLOdh4cHEhMTMXLkSGg0GvTr1w8ODg5ltunVqxciIyPh4+ODhg0bolOnTgAe9uHs2bMxbtw41K5dG8bGxli6dOlztXnSpEmYM2cORo4cieLiYowYMQKGhoZo2rQpxowZAzMzM2g0GkyePBlNmjRBeHg4du/eDZVKhSZNmsDe3h52dnaYO3cu3n33XRQXF2PChAl49dVXn/nZXrx4MYKDg6FSqSCEwNixY/lHZV4ifFQtkYw9+pnhiRMn9F0KEVUxTtETERHJEEfwREREMsQRPBERkQwx4ImIiGSIAU9ERCRDDHgiIiIZYsATERHJEAOeiIhIhv4PxLkLUxgYNkwAAAAASUVORK5CYII=", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotar gráfico de receitas por tamanho dos grupos\n", "tips.groupby(['size'])['total_bill'].sum().plot.bar(title='Receitas Totais por Tamanho dos Grupos')\n", "plt.xlabel(\"Tamanho do Grupo em Número de Pessoas\")\n", "plt.ylabel(\"Receitas\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 390 }, "id": "CU4a9EmfzLwy", "outputId": "a106510c-7c89-45bd-a49d-c15069d8764d" }, "outputs": [ { "data": { "text/plain": [ "Text(0, 0.5, 'Receitas')" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAe0AAAFjCAYAAAAQDlNTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deVhU9d8+8HtgBERRFkHF1NLUUDQBI1ERAZXFfUsiMcXHDZfQTOcLCuSCW2bhbqaWVKK4PJmaZeauuOZCbvl1ARVkE0GQbT6/P/xxHieQRnNmOHi/rsvrYs6ccz7v82bknrPMGYUQQoCIiIgqPSNDF0BERETaYWgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtOmFtGjRAhMnTiwzPTw8HC1atCgzPSIiAgsXLoRarS53feHh4ViyZAkAwNfXF+np6S9c26lTp+Dl5fXCyz8tISEBjo6O8PX1ha+vL3x8fODj44M1a9a8lPX/3aJFi/DDDz8AAA4dOoS7d+/qZJx/a8uWLVJPXFxc0L59e+nxsWPHDFKTSqXC8uXLX+o6W7ZsieTk5JeyrqKiIixZsgQ9evSAn58funXrhokTJyIpKemlrJ9eDUpDF0DydeXKFeTm5qJmzZoAgMLCQly4cKHMfLdu3ULv3r3Rrl07rdb7888/v9Q6/6369etr1JSeno733nsPDg4O6Nix40sd6+OPP5Z+Xr9+PcaOHQt7e/uXOsbLMGDAAAwYMADAk7Bs1KgRQkJCDFxV5aZSqZCXl4eNGzfCwsIChYWFWL58OYYNG4bdu3fDxMTE0CWSDHBPm17Yu+++i19//VV6fPjwYbRu3Vpjnr1792L8+PGYNm0agoODkZmZCQDIyspCcHAwvLy8MGrUKOTk5EjLtGjRAikpKQCAZcuWwcfHB127dsXo0aPx8OHDcmtZvnw5PDw80LdvXxw9elSanp+fj9DQUPj4+MDLywvz58+Xntu9ezd69uwJPz8/9OrVCwkJCVptd506ddC2bVtcunQJAJCSkoIxY8ZIe+EHDhyQ5t2+fbs0/ZNPPkFhYaHUl169esHb21ujL6V7i1988QWOHz+OTz75BLt27frX27FkyRKoVCqMHj0anp6eCAgIQEZGBgDg7t27GDFiBHx8fNCzZ09s374dAJCcnIxOnTohOjoaQ4YM0ao3AHD27Fn0798fvr6+8Pf3l34fpev76quvpJ788ccfGDVqFNzd3fGf//xHWsfmzZvh5+eH7t2744MPPsCdO3cAAFu3bsXEiRMRFhYGHx8f+Pv749q1a9Jy2dnZGDlyJLp06YIRI0YgNzcXAHD58mUEBATA19cXffr0waFDh8qt/cCBA+jWrRv8/PzKHE359ttv4e/vD19fX4wdO1b6nZ04cQL9+vWDv78//Pz8sHv37jLrvXbtGvbv34/58+fDwsICAGBiYoLQ0FD8+OOPUmB7eXlh6dKl8PHxwd27d+Hl5YVTp05J6yl9nJCQgF69emHevHnSa+KPP/4AABQUFCAiIgI+Pj7w8/PDvHnzUFJSAgCIjY2Fn58ffH19MXDgQI3ekUwIohfQvHlzcfToUREcHCxNmzx5sjh48KBo3ry5EEKI27dvCycnJ3HlyhUhhBCrVq0SEyZMEEIIMX/+fDF58mQhhBBJSUnCyclJxMTESOu+d++euHDhgnBzcxM5OTmipKREDBs2TCxbtqxMLdeuXRPvvPOOSEtLE8XFxSIkJER4enoKIYT4+uuvxf/8z/8ItVotHjx4IFxdXcXJkyeFEEK8++67Ijk5WQghxMmTJ0V0dHSZdR8/flx07dpVY9pff/0l3NzcxKlTp4QQQgwdOlQsXrxYCCHEzZs3haurq8jMzBRJSUmiffv2IiUlRajVajFu3Djx1VdflenLypUrpb5MmzZN2kZPT0+p1n+7HTExMcLJyUncvn1bCCHElClTxJw5c4QQQgQHB4uVK1cKIYRITk4WLi4uIikpSSQlJYlWrVqJrVu3llnf056uWQghevbsKX766SchhBDbtm2T+peUlCRatmwptm3bJoQQYsKECaJLly4iIyNDZGZmCkdHR3Hr1i2Rnp4uHB0dxb1794QQQqhUKhEWFiaEEGLLli3i7bffFhcuXBBCCBEVFSXCw8OlOnr06CGysrJEUVGR6NOnj9i2bZsoKSkRfn5+YseOHUIIIc6fPy/eeecdkZOTo7EdxcXFomPHjuLQoUNSz5s3by6SkpLE2bNnRefOnUV6eroQQoiZM2dKNfXv318kJCQIIYS4ceOG9Lp+WmxsrMb/lWfx9PQU06dP13hc+nt++vHx48eFg4OD2LlzpxBCiE2bNok+ffoIIZ78Pxs5cqQoKioS+fn5YsCAAWL79u0iJydHtGvXTtruXbt2idWrV/9jTVS5cE+bXpirqyuuXbuGjIwM5Ofn4+zZs3Bzc5OeP3jwINq3b4/mzZsDAAIDA7Fv3z6UlJTg1KlT8PPzAwC89tprcHV1LbN+R0dH7N+/HzVr1oSRkRGcnJzKPf938uRJvPPOO6hTpw6MjY3Ru3dv6bng4GAsX74cCoUCtWvXRrNmzaRzlDY2Nti4cSPu3LmDdu3aaezpPe3evXvS+dpOnTph9OjRCA8Ph4uLC/Ly8pCQkIBhw4YBABo3bgwXFxccOHAAR44cgZOTE+rWrQuFQoFFixZh2LBhOHjwIFxdXaW+BAQESH15lpexHe+++y4aNmwIAOjevTvOnj2LoqIiHD16FIGBgQCABg0a4N1338Xx48cBPDkP261bt2fWVZ7t27dLv1sXFxeN31lxcTF8fX0BAM2bN0fr1q1hbW0NKysr2Nra4v79+7CxscHp06dRr149AEC7du001tG0aVM4OjoCeHLO+d69e9JznTt3hqWlJZRKJZo1a4bU1FQkJycjPT0dPXr0AAC0bt0a9vb2ZU7l3Lx5E4WFhejUqRMAoF+/ftJz+/fvh4+PD2xsbAAAgwYNwpEjRwA86f/27dtx/fp1vP7661i0aFGZnjx8+BDW1tbS42vXrmm8pnbu3Ck916VLF636bG5uLvW5e/fuuHTpEvLz87F//3689957UCqVMDMzQ69evXDkyBGYmppCoVAgPj4e6enp8PPzw8iRI7UaiyoPntOmF2ZsbIzu3btj9+7dsLa2RqdOnaBU/t9LKicnBydOnJD+SANAzZo18eDBA2RnZ0uHCQGgVq1aZdafn5+PuXPnSod7s7Ozy/2DVtG6bt68iXnz5uG///0vjIyMkJKSgv79+wMAVqxYgRUrVqB///6oX78+wsLCyn3z8PQ57UOHDmHmzJlSkOXk5EAIgYCAAGn+vLw8tG/fHnl5eRq1mJqaSsucOnWq3L48y8vYDktLS40ePXz4EA8ePIAQokz/Sg/9GhsbS9csaGvHjh349ttv8ejRI6jVaoinvt7A2NgYZmZmAAAjIyOYm5trPFdSUoKSkhLExMRIb2QePXqEN954Q5rv6VpLlyn1dK2lz2VmZsLCwgIKhaLcbSyVnZ2tsXzt2rWlnzMzM2FnZ6exfOnphejoaKxYsQLDhw+HmZkZJk+erPG7BQBra2vpjRAANGvWTHpNDRs2DAUFBeWOW5FatWpJ21T6Onv48CEyMzM11lG7dm1kZGSgWrVqWL9+PVauXIklS5agRYsWiIyMLPfCUaq8GNr0r/j7+2Px4sWwsrKS9tZK2dnZoUOHDoiJiSmzXK1atTTOY2dmZkp7gaW++eYb3Lx5E1u3bkWNGjWwePFipKam/uO6srKypJ9nzpyJVq1aYdmyZTA2NtYI10aNGmHu3LlQq9XYvn07Pv7442ee6yzl7u6OevXq4fvvv8ewYcNgY2MDY2NjbNmyBTVq1NCYNy4uDmfPnpUe5+bm4vHjxxX25VlexnY83Zfs7GzUrl0bVlZWMDIykh4DwIMHD6Q9yueVmpqK6dOnY/PmzXBwcMDNmzfh4+PzXOvYtWsX9u3bh9jYWFhbW2PTpk3YsWPHC9UDPNkTzs7OhhBCCrnytrF27drSOXAAGqFep04djTdVDx48QJ06daTnZsyYgRkzZuDw4cOYMGEC3N3dNV4Pbm5umDt3Lu7fv68R/v/EyMhI4xMX2dnZGjX8fbqlpWWFtbZs2RIxMTEoLCzEmjVrEBkZiY0bN2pdDxkeD4/Tv+Lk5IT79+/j2rVrZfbuOnXqhFOnTkmHNi9evIjZs2cDANq2bYu9e/cCAG7fvo3Tp0+XWXdGRgaaNGmCGjVq4M6dOzhw4ADy8vLKreH06dPIzMxESUkJfvzxR411ODg4wNjYGEeOHMGtW7eQl5eHzMxMDB8+HLm5uTAyMsLbb7+tsSdWkUmTJmHFihXIzs6GUqmEh4eH9IcvPz8f//nPf3Dv3j14eHjgzJkzSE5OhhACkZGRiI+PL9OX8+fPS315mlKplN6MvIztOH36tHQoec+ePXBxcYFSqUSnTp0QFxcn/S5OnTqFDh06aNWLv8vMzIS5uTmaNGmC4uJiab2PHj3Seh0ZGRlo0KABrK2tkZWVhd27dz/X8n/32muvoV69eti1axcA4MyZM0hPT0ebNm005mvUqBGMjY2lIztbt26VetmlSxf8+uuv0hufjRs3wsPDA0VFRQgKCsL9+/cBAK1atYJSqYSRkVGZdfft2xeTJk2SPs5YWFiI2NhYnDlzBq+99lq5tdva2uLy5csAnryZeXqP/PHjx9L/oT179sDR0RGmpqbo0qUL4uPjUVJSgry8PPzv//4vPDw8cOXKFUycOBGFhYUwMTGBo6Oj1q95qjy4p03/ikKhQLdu3ZCfn1/mD5WdnR1mzZqFcePGoaioCDVq1EBYWBgAYPTo0Zg0aRK8vLzQtGlTdO/evcy6AwICMHHiRPj4+KBFixZQqVSYMGEC1q9fL51DBgAHBwcEBASgX79+sLS0RI8ePXD16lUAwNixYzF37lwsX74c3t7eGD9+PGJiYuDg4AB3d3cMGDAAxsbGqFatGubMmaPVNjs7O8PJyQkrVqyASqVCVFQUIiMjsXnzZgBA7969Ub9+fQBP9pA//PBDGBsbo3Xr1hg+fDhMTU2f2Zen+fj4YPLkyZg4ceJL2Y4OHTrg008/xaVLl2Bvb4/w8HAAwKefforp06dj69atqFatGmbPno369eu/0OeT33rrLXTu3Fk6/6tSqXDmzBkEBQVpfWShZ8+e2LlzJ7p164aGDRsiNDQUY8eOxbx586TrAJ6HQqHA559/jsjISCxduhTVq1fHl19+qXFoHgCqVauGWbNmISwsDCYmJujfv780T5s2bTBq1Ch88MEHUKvVcHBwQFRUFKpVq4aBAwdKr0cjIyNMnz4d1atXL1NHREQE1qxZgw8//BAlJSUoLCxEy5YtERsbW+YNRKmQkBBERkZi06ZN8PHxwZtvvik916BBA5w+fRoLFy5EUVERvvjiCwBAUFAQkpKS0KNHDygUCvj6+mpcP9KzZ09Uq1YNNWrUQERExHP3kwxLIQS/T5uoqluyZAlSUlK0fmNClVtCQgKmT5+u8ZFLejXw8DgREZFMMLSJiIhkgofHiYiIZIJ72kRERDLB0CYiIpKJSv2Rr7S0nH+eyQCsrMyRlVX288KkiX3SDvukPfZKO+yT9ipjr2xtLZ75HPe0X4BSaWzoEmSBfdIO+6Q99ko77JP25NYrhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimWBoExERyQRDm4iISCYY2kRERDKhs5ur5OfnQ6VSISMjAwUFBQgJCcGePXuQmJgIS0tLAMCIESPQpUsXXZVARERUpegstH///Xc4Ojpi5MiRuHPnDoKDg+Hk5ITJkyfD09NTV8MSERFVWToLbX9/f+nne/fuoW7duroaioiI6JWg83PaAQEBmDJlCsLCwgAAsbGxGDp0KCZNmoTMzExdD09ERFRl6OX7tC9duoSpU6ciLCwMlpaWcHBwwOrVq5GSkoKIiIhnLldcXCK7+8ISERHpis4Oj1+8eBE2NjaoX78+HBwcUFJSgubNm8PGxgYA4OXlhaioqArXUdm+eaWUra1Fpf0GssqEfdIO+6Q99ko7Vb1PwfP2GbqEMtaqvF7augzyLV+nTp3C2rVrAQDp6enIy8tDREQEkpKSAAAJCQlo1qyZroYnIiKqcnS2px0QEIDw8HAEBgbi8ePHiIiIgLm5OUJDQ1G9enWYm5tj7ty5uhqeiIioytFZaJuZmWHRokVlpm/ZskVXQxIREVVpvCMaERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCYY2ERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCYY2ERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCYY2ERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCaWuVpyfnw+VSoWMjAwUFBQgJCQEb731FqZOnYqSkhLY2tpi4cKFMDEx0VUJREREVYrOQvv333+Ho6MjRo4ciTt37iA4OBjOzs4IDAyEn58fPv/8c8THxyMwMFBXJRAREVUpOjs87u/vj5EjRwIA7t27h7p16yIhIQHe3t4AAE9PTxw7dkxXwxMREVU5OtvTLhUQEICUlBSsXLkSw4cPlw6H29jYIC0tTdfDExHJRvC8fYYuoYy1Ki9Dl0BP0Xlob9y4EZcuXcInn3wCIYQ0/emfn8XKyhxKpbEuy3thtrYWhi5BFtgn7bBP2mOv9Iv91o6++qSz0L548SJsbGxQv359ODg4oKSkBDVq1MDjx49hZmaG1NRU2NnZVbiOrKw8XZX3r9jaWiAtLcfQZVR67JN22CftsVf6x35r52X2qaI3ADo7p33q1CmsXbsWAJCeno68vDx06NABe/bsAQD88ssvcHd319XwREREVY7O9rQDAgIQHh6OwMBAPH78GBEREXB0dMS0adMQFxcHe3t79O3bV1fDExERVTk6C20zMzMsWrSozPR169bpakgiIqIqjXdEIyIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJhM5vY0pErzbeT5vo5eGeNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwodbnyBQsW4PTp0yguLsbo0aOxb98+JCYmwtLSEgAwYsQIdOnSRZclEBERVRk6C+3jx4/j2rVriIuLQ1ZWFvr164f27dtj8uTJ8PT01NWwREREVZbOQvudd95BmzZtAAC1atVCfn4+SkpKdDUcERFRlaezc9rGxsYwNzcHAMTHx6Nz584wNjZGbGwshg4dikmTJiEzM1NXwxMREVU5Oj2nDQB79+5FfHw81q5di4sXL8LS0hIODg5YvXo1li5dioiIiGcua2VlDqXSWNclvhBbWwtDlyAL7JN22Cf9Yr+1x15pR1990mloHzp0CCtXrsSaNWtgYWEBNzc36TkvLy9ERUVVuHxWVp4uy3thtrYWSEvLMXQZlR77pB32Sf/Yb+2xV9p5mX2q6A2Azg6P5+TkYMGCBVi1apV0tfiECROQlJQEAEhISECzZs10NTwREVGVo7M97V27diErKwuhoaHStP79+yM0NBTVq1eHubk55s6dq6vhiYiIqhydhfbgwYMxePDgMtP79eunqyGJiIiqNN4RjYiISCYY2kRERDLB0CYiIpIJhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimWBoExERyQRDm4iISCZ0/i1fRFVV8Lx9hi6hjLUqL0OXQEQ6xD1tIiIimWBoExERyQRDm4iISCYY2kRERDLB0CYiIpIJhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimWBoExERyQRDm4iISCYY2kRERDLB0CYiIpIJhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimWBoExERyQRDm4iISCYY2kRERDKhVWgXFRUhJSUFAHD58mVs374d+fn5Oi2MiIiINGkV2iqVCn/88QdSU1MxYcIEXL16FSqVSte1ERER0VOU2syUmpoKX19frFu3DoGBgRg+fDiGDRv2j8stWLAAp0+fRnFxMUaPHo3WrVtj6tSpKCkpga2tLRYuXAgTE5N/uw1ERESvBK32tAsLCyGEwK+//oouXboAAB49elThMsePH8e1a9cQFxeHNWvWIDo6GjExMQgMDMT333+Pxo0bIz4+/l9vABER0atCq9B2dXWFi4sLbG1t8cYbb2D9+vVo0qRJhcu88847+PLLLwEAtWrVQn5+PhISEuDt7Q0A8PT0xLFjx/5l+URERK8OrQ6PT5kyBaNGjUKtWrUAAN7e3nB0dKxwGWNjY5ibmwMA4uPj0blzZxw+fFg6HG5jY4O0tLR/UzsREdErRavQzs3NxY4dO5CVlQXgydXkW7ZsweHDh/9x2b179yI+Ph5r165F9+7dpelCiH9c1srKHEqlsTYl6p2trYWhS5AF9km/2G/tsE/aY6+0o68+aRXaoaGhsLe3x+HDh+Hj44MjR44gKirqH5c7dOgQVq5ciTVr1sDCwgLm5uZ4/PgxzMzMkJqaCjs7uwqXz8rK02oj9M3W1gJpaTmGLqPSY5/0j/3WDvukPfZKOy+zTxW9AdDqnHZBQQFmzpyJBg0aYNq0afj222+xe/fuCpfJycnBggULsGrVKlhaWgIAOnTogD179gAAfvnlF7i7u2u7DURERK88rfa0i4qKkJeXB7VajaysLFhZWSEpKanCZXbt2oWsrCyEhoZK0+bNm4fp06cjLi4O9vb26Nu377+rnoiI6BWiVWj36dMHmzZtwqBBg+Dv7w9ra2s0bty4wmUGDx6MwYMHl5m+bt26F6uUiIjoFadVaPfo0UO6ctzNzQ0ZGRmwsODFCURERPr0j+e01Wo1xo0bByEE1Go1bG1t8eabbyIkJEQf9REREdH/V+Ge9k8//YQlS5bg1q1bcHBwkKYbGRmhU6dOOi+OiIiI/k+Fod2zZ0/07NkTS5YswYQJE/RVExEREZWjwtA+cOAAPDw8UK9evXLvEz5w4ECdFUZERESaKgztK1euwMPDA2fOnCn3eYY2ERGR/lQY2qNGjQIAzJ07F2q1GhkZGbC1tdVLYURERKRJqzuiHTt2DF27dkVQUBAAIDo6Gvv379dlXURERPQ3WoX24sWLsWnTJmkve8yYMVi+fLlOCyMiIiJNWoW2ubk56tSpIz22trZGtWrVdFYUERERlaXVHdHMzMxw4sQJAEB2djZ27twJU1NTnRZGREREmrTa046MjMTXX3+NCxcuoHv37jh06BBmzpyp69qIiIjoKVrtadevXx+fffaZdL/x9PR0jcPlREREpHta7Wl/9913mDZtmvR48uTJiI2N1VlRREREVJZWof3jjz8iJiZGerx27Vr89NNPOiuKiIiIytIqtEtKSqBU/t+RdIVCASGEzooiIiKisrQ6p+3l5YWAgAC4uLhArVbj+PHj6N69u65rIyIioqdoFdohISFwdXXF+fPnoVAoEBkZibZt2+q6NiIiInqKVofHASA3NxcmJiYYPnw4rK2teXiciIhIz7QK7YULFyI+Ph5bt24FAOzYsQOzZ8/WaWFERESkSavQPnnyJJYuXYoaNWoAAMaNG4fExESdFkZERESatArt0luWKhQKAE+uJi8pKdFdVURERFSGVheiOTs7Q6VS4f79+1i3bh327NkDV1dXXddGRERET9EqtIcNG4aEhARUr14dKSkpCA4OhoODg65rIyIioqdUGNqnTp3CpEmTUFhYCCsrK6xatQqNGzdGbGwsZs+ejYMHD+qrTtKT4Hn7DF1CudaqvAxdAhGRwVUY2osXL8b69evRtGlT/Pbbb4iIiIBarUbt2rWxefNmfdVIRERE+IcL0YyMjNC0aVMAgLe3N+7cuYOhQ4di6dKlqFu3rl4KJCIioicqDO3Sq8VL1a9fH926ddNpQURERFQ+re+IBpQNcSIiItKfCs9pnz17Fl26dJEeZ2RkoEuXLhBCQKFQYP/+/Touj4iIiEpVGNo///yzvuogIiKif1BhaDdo0EBfdRAREdE/eK5z2s/r6tWr6Nq1K2JjYwEAKpUKvXr1QlBQEIKCgnh4nYiI6DlodUe0F5GXl4dZs2bBzc1NY/rkyZPh6empq2GJiIiqLJ3taZuYmOCrr76CnZ2droYgIiJ6pegstJVKJczMzMpMj42NxdChQzFp0iRkZmbqangiIqIqR2eHx8vTp08fWFpawsHBAatXr8bSpUsRERHxzPmtrMyhVBrrsULt2dpaGLqEVwr7rR32STvsk/bYK+3oq096De2nz297eXkhKiqqwvmzsvJ0XNGLsbW1QFpajqHLeKWw39phn7TDPmmPvdLOy+xTRW8AdHr1+N9NmDABSUlJAICEhAQ0a9ZMn8MTERHJms72tC9evIj58+fjzp07UCqV2LNnD4YMGYLQ0FBUr14d5ubmmDt3rq6GJyIiqnJ0FtqOjo7YsGFDmek+Pj66GpKIiKhK0+vhcSIiInpxDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUzoNLSvXr2Krl27IjY2FgBw7949BAUFITAwEB999BEKCwt1OTwREVGVorPQzsvLw6xZs+Dm5iZNi4mJQWBgIL7//vErcrIAABQ0SURBVHs0btwY8fHxuhqeiIioytFZaJuYmOCrr76CnZ2dNC0hIQHe3t4AAE9PTxw7dkxXwxMREVU5Sp2tWKmEUqm5+vz8fJiYmAAAbGxskJaWpqvhiYiIqhydhfY/EUL84zxWVuZQKo31UM3zs7W1MHQJrxT2Wzvsk3bYJ+2xV9rRV5/0Gtrm5uZ4/PgxzMzMkJqaqnHovDxZWXl6quz52NpaIC0tx9BlvFLYb+2wT9phn7THXmnnZfapojcAev3IV4cOHbBnzx4AwC+//AJ3d3d9Dk9ERCRrOtvTvnjxIubPn487d+5AqVRiz549+Oyzz6BSqRAXFwd7e3v07dtXV8MTERFVOToLbUdHR2zYsKHM9HXr1ulqSCIioiqNd0QjIiKSCYY2ERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCYY2ERGRTDC0iYiIZIKhTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSCYY2ERGRTCgNXYC+BM/bZ+gSylir8jJ0CUREJCPc0yYiIpIJhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimWBoExERyQRDm4iISCYY2kRERDLB0CYiIpIJhjYREZFMMLSJiIhkgqFNREQkEwxtIiIimdDrt3wlJCTgo48+QrNmzQAAzZs3x4wZM/RZAhERkWzp/as5XV1dERMTo+9hiYiIZI+Hx4mIiGRC76H9119/YcyYMXj//fdx5MgRfQ9PREQkW3o9PP76669j/Pjx8PPzQ1JSEoYOHYpffvkFJiYm5c5vZWUOpdJYnyXqla2thaFLkA32Sjvsk3bYJ+2xV9rRV5/0Gtp169aFv78/AKBRo0aoU6cOUlNT0bBhw3Lnz8rK02d5epeWlmPoEmSDvdIO+6Qd9kl77JV2XmafKnoDoNfD4z/++CO+/vprAEBaWhoyMjJQt25dfZZAREQkW3rd0/by8sKUKVPw22+/oaioCFFRUc88NE5ERESa9BraNWvWxMqVK/U5JBERUZXBj3wRERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZYGgTERHJBEObiIhIJhjaREREMsHQJiIikgmGNhERkUwwtImIiGSCoU1ERCQTDG0iIiKZUOp7wOjoaJw7dw4KhQJhYWFo06aNvksgIiKSJb2G9okTJ3Dr1i3ExcXh+vXrCAsLQ1xcnD5LICIiki29Hh4/duwYunbtCgBo2rQpsrOzkZubq88SiIiIZEuvoZ2eng4rKyvpsbW1NdLS0vRZAhERkWwphBBCX4PNmDEDHh4e0t72+++/j+joaLzxxhv6KoGIiEi29LqnbWdnh/T0dOnx/fv3YWtrq88SiIiIZEuvod2xY0fs2bMHAJCYmAg7OzvUrFlTnyUQERHJll6vHnd2dkarVq0QEBAAhUKByMhIfQ5PREQka3o9p01EREQvjndEIyIikgmGNhERkUwwtImIiGSCof2CHj58aOgSKqXyLpFISUkxQCXykZmZaegSZOHYsWOGLkEWiouLcefOHRQXFxu6lEpPjv/3GNovaPz48YYuoVL59ddf4enpCTc3N0ybNk3j9rRTp041YGWVy/79++Hj44Nhw4bh6tWr6N27N4KCguDl5YUDBw4YurxKY/v27Rr/tm3bhsjISOkx/Z/Zs2dLPx89ehTdunVDaGgounfvjkOHDhmwssrlwIEDiIiIAPDkDaCnpyeGDh0KLy8v7N+/37DFPQe9f8uXnHz33XfPfC41NVWPlVR+q1evxrZt21CrVi1s3rwZI0aMwJo1a2BhYVHu3verasWKFVi3bh3u3r2LMWPGYPny5XjrrbeQnp6OMWPGwMPDw9AlVgrLli2DpaWlRj8KCgqQnJxswKoqpytXrkg/L1u2DN9++y0aNmyItLQ0jB8/Hu7u7gasrvKIiYnBqlWrAGj2KSsrC6NHj0aXLl0MW6CWGNoVWL9+Pdzc3GBnZ1fmOR560mRsbAxLS0sAwODBg2FjY4MRI0Zg5cqVUCgUBq6u8jAxMYG9vT3s7e1hZ2eHt956CwBQp04dmJqaGri6yuOnn37C8uXLceXKFahUKjRo0ACHDh3iEa5yPP3/q3bt2mjYsCEAwNbWFkol/8SXKi4uRo0aNQAAFhYWeO211wAAlpaWstqx4G+0AsuWLcPs2bMxffp0mJiYaDyXkJBgoKoqJ2dnZ4wePRpffvklzMzM0LVrV5iammLYsGF48OCBocurNGxsbPD1119jxIgR2LhxI4An5/zXrl2LevXqGbi6ysPU1BSTJk3Cf//7X8ycORNOTk5Qq9WGLqtSunbtGj766CMIIXDr1i3s3r0bfn5+WLt2LSwsLAxdXqUxYsQI9O3bFx07doSlpSVCQkLg5OSEhIQEDBo0yNDlaY03V/kH+fn5MDU1hZGR5un/xMREtGrVykBVVU4JCQlwdXXVeOefm5uLXbt24b333jNgZZXH48ePsW/fPvj7+0vTEhMTcfLkSbz//vvc236G7du348CBA1i8eLGhS6l0Tpw4ofG4cePGqFu3Lnbs2AEvLy9p75KABw8e4OjRo7hz5w6EEKhTpw46duyIunXrGro0rTG0iYiIZIJXjxMREckEQ5uIiEgmGNqkNwsWLEBQUBDee+89ODo6IigoCEFBQXr93G1ycjI6d+78UtZ19OhRBAUFPdcyhw8fxpAhQzBw4EAMGjQIH374IS5cuPBS6tG3rVu3onXr1rh9+7Y0LTk5uUxPNm3ahIiIiErziYspU6Zg69atWs/v5eWFQYMGISgoCEOGDMHQoUNx9epVHVZI9Gy8epz0pvQmK8nJyQgMDMSGDRsMXJF+Xb58GVFRUVi9ejWaNGkCAPjtt98QEhKCPXv2wNzc3MAVPr8333wT0dHRWLlyZbnPFxcXo169erK/EPGzzz5D48aNATy5QY5KpXqu4Cd6WRjaZHCnTp3CZ599BhMTEzx+/BiRkZFo1aoVVCoVrKyscP36dfz111/4+OOPsW/fPly9ehXOzs749NNPkZeXh2nTpuHBgwd49OgRfH19MWrUKCQkJGD16tWoV68e/vrrLyiVSqxZs0Yac/HixTh58iTy8vKwatUq1K1bF/v378eyZctgZmaG6tWrY9asWWWuKt27dy8WL16MevXqSX/EAeDGjRuIjIyEEALFxcX4+OOP0a5dO41l16xZg1GjRkmBDQDe3t5wd3eXPlLo7OyMgQMHQq1Wo1u3bvjiiy/www8/AABUKhVcXFzg5uaGYcOGoXPnzrh8+bK0Pdpuw+XLlzF//nwUFxejqKgIERERaNmyJYKCgtCuXTucP38eN2/eRFhYGLZv346rV6+ib9++GDt2bJnfnZeXF/744w8cOHCgzI1hSust/ThNixYtkJiYiBUrViAtLQ3p6em4fPkyRo4ciUuXLuHixYuws7PDihUroFAosGHDBuzevRslJSVo0qQJIiMjkZ6ejrFjx6J58+Zo1qwZRo4ciejoaCQmJgIA2rdvj9DQUI061Go1wsPDceXKFTRo0AB5eXnSc7t27UJsbCyEELC2tsbs2bNhZWVVZjuf1q5dO9y4cQMAkJ2djcjISGRmZiI3NxfDhw9Hr169cPz4cSxatAhmZmYoLCxEeHg4WrZsienTp+PGjRtQKBRwcHBAZGQk8vLyMGPGDKSkpKC4uBh9+vRBYGDgM1/bqampmDJlCoAnn0YYPHgwBg4cWGHNVIUIIj1LSkoS7u7u0uNff/1VXLp0SQghxI4dO8SECROEEEJMmzZNTJkyRQghxJYtW4Srq6vIzs4W+fn5onXr1iI7O1vcvn1bbNu2TQghREFBgXB2dhY5OTni+PHjwtnZWaSnpwshhBgyZIj45ZdfRFJSknBwcBBXrlwRQggRFhYmvv76a5GXlyc6duwo7t27J4QQYsOGDUKlUpWp3d3dXfz1119CCCFmzZolhgwZIoQQIjg4WOzatUsIIcTly5eFl5dXmWX79OkjEhMTK+xNixYtxOHDh4UQQhw/flwEBARIz02bNk1s2rRJJCUliebNm4sLFy4IIYRYvHixiI6O1nobevbsKW7duiWEEOLSpUuiX79+Uo8WL14shBAiJiZG+Pr6ioKCApGUlCRcXFzKrGfLli0iJiZGXL9+Xfj7+0vzlvaktN5SzZs3F0VFRSImJkZ88MEHQq1Wi+PHj4uWLVuKW7duCbVaLTw9PcWff/4pzp07J4KCgoRarRZCCDFnzhzx7bffSr+/69evCyGevF5GjRol1Gq1KC4uFgMHDhQJCQkadR46dEi89957Qq1WSz3asmWLuHv3rujVq5coKCgQQgixfv16MXfu3DLb6enpKW7evCk93rx5sxgxYoQQQoioqCgRHx8vhBDi0aNHomvXriIjI0OMGTNG7Ny5UwghxPXr18XevXtFYmKi8PX1ldYTFxcnHj58KFauXCmioqKEEELk5+cLT09Pcfv27We+ttetWyciIiKEEEI8fvxYbNiwoUzNVHVxT5sMrk6dOliwYAEKCgqQk5OD2rVrS885OzsDAOrVq4cmTZqgVq1aAJ7cxSgnJwc2NjY4ffo0Nm7ciGrVqqGgoEC6mUvTpk1hY2MDAGjQoIE03crKCs2bN5fW+/DhQ9y8eRM2NjbSDU5cXV2lm5+UysrKQkFBAZo2bQrgyV5d6S0kz507J32GuEWLFsjNzUVmZiasra2l5Y2MjDTO644fPx7Z2dnIyspCSEgI/P39IYSQtrkilpaWcHR0lHr0zTffaLUNGRkZuHHjBsLDw6Vpubm50o1Lnu53q1atYGJignr16iEnJ+eZtTRp0gQeHh5Yu3Ytevbs+Y+1A0Dbtm2hUChQr1492NjYoFGjRgCAunXrIicnB+fOncPt27cxdOhQAEBeXp50d6/atWtLRyvOnTsHNzc3KBQKGBsbo127drhw4QJcXV2lsa5evQonJycoFApUr14dbdq0AQCcPXsWaWlpGDFiBACgsLBQukvW302ZMgVmZmZQq9Vo0KABoqOjATy5N8GFCxek6zKUSiWSk5PRq1cvfP755zh//jy8vb3h7e2NgoICWFlZYeTIkfD09ISfnx8sLCxw7tw59O/fHwBgZmYGR0dHJCYmonPnzuW+tt3d3fH9999DpVLBw8MDgwcP1qrnVDUwtMngpk6dik8//RRubm74/fffsXbtWum5p2/D+PdbMgoh8M0336CwsBA//PADFAoF3n33Xel5Y2Pjcsf7+3QhRJlbrWozraSkRPq5vFu1/n1aixYt8Mcff0ihsXTpUgBPDiM/evRImq9atWrlLl9UVKRRy9/r0mYbTExMUK1atWdeT1BRvysSEhKCAQMGaJwSeHrswsJCjfmf/h2U93s1MTGBl5eX9AUPpZKTk6X+/H2M0mX/aVrpGxQTExO0adNGuh91RZ4+p/00ExMTREZGonXr1hrT27Rpg06dOuHw4cNYtmwZ2rRpg8mTJ+P7779HYmIifv/9dwwcOFB63ZZX77Ne202bNsXOnTtx8uRJ/Pzzz/jmm2/KvDmjqotXj5PBpaeno1mzZigpKcHPP/9c5g98RTIyMtC0aVMoFAr89ttvePz48XMtX+r1119HRkYG7t69C+DJtwC9/fbbGvNYWVnB2NgYN2/eBPDk6vFSb7/9Ng4fPgwA+PPPP2FpaVnm3OiYMWOwfv16XLp0SZqWkpKCy5cvl3sntJo1ayI1NRVCCOTn5+PcuXPSc9nZ2fjzzz8BAGfOnEGLFi202obSey6XfqPYjRs3pDcP/0bNmjUxbtw4LFy4UJpWo0YN3Lt3T6rlee5B7+zsjIMHD0pvZr777jucPXu2zHxt27bF0aNHpWsJTpw4UWab33zzTZw7dw5CCOTm5kp9bN26Nc6fP4+0tDQAwO7du7F3797n2m4XFxfs3r0bwJPzy1FRUSguLkZMTAxKSkrg7++P8PBwnD17FhcuXMC2bdvQqlUrjB8/Hq1atcLNmzfx9ttvS9/GlZeXJ91t8Vmv7R07duDChQvo0KEDIiMjce/evUpzZT7pHve0yeBGjhyJDz/8EPb29hgxYgSmTp2K9evXa7XsgAEDMHnyZBw+fBje3t7o1asXpkyZgmnTpj1XDWZmZpgzZw4mTZoEExMTmJubY86cORrzKBQKhIWFYdy4cWjYsKHGnteMGTMQGRmJH374AcXFxViwYEGZMRo3boyVK1di7ty5ePjwIUxNTaFWqzFkyBD07t27zPxvvfUWWrRogX79+qFRo0ZwcnKSnqtbty62bt2KefPmQQiBzz//XKttAID58+dj9uzZWL16NYqLi6FSqZ6rV8/Su3dvjT2+gQMH4qOPPsLJkyfRqVOn57oPduvWrfHBBx8gKCgIpqamsLOzQ//+/ZGRkaExn6+vL86cOYP3338farUaXbt2hYuLi8Y8nTp1wo8//ohBgwbB3t4ebdu2BfCkh+Hh4Rg9ejSqV68OMzMzzJ8//7m2efz48Zg+fTref/99FBYWYvDgwVAqlWjcuDGCg4NRq1YtqNVqTJgwAY0aNcKyZcsQFxcHExMTNGrUCM7OzmjdujVmzJiBDz74AIWFhQgJCcFrr732zNf2nDlzEBkZCRMTEwghMHLkSH4xyCuEtzElkpnSj8wdPHjQ0KUQkZ7x8DgREZFMcE+biIhIJrinTUREJBMMbSIiIplgaBMREckEQ5uIiEgmGNpEREQywdAmIiKSif8HE/8Hxb3F4REAAAAASUVORK5CYII=", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Plotar médias de receitas por tamanho dos grupos\n", "tips.groupby(['size'])['total_bill'].mean().plot.bar(title='Média das Receitas por Tamanho dos Grupos')\n", "plt.xlabel(\"Tamanho do Grupo em Número de Pessoas\")\n", "plt.ylabel(\"Receitas\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "_5qhzb4Vzl5j", "outputId": "b68fd23e-2a28-46bb-8f08-77703437a758" }, "outputs": [ { "data": { "text/plain": [ "size\n", "1 7.242500\n", "2 16.448013\n", "3 23.277632\n", "4 28.613514\n", "5 30.068000\n", "6 34.830000\n", "Name: total_bill, dtype: float64" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tips.groupby(['size'])['total_bill'].mean()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 347 }, "id": "9c3WTUEK0KCY", "outputId": "81e666f5-91d8-477e-83e5-16097c0eaf0e" }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAd8AAAFKCAYAAABcq1WoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARYUlEQVR4nO3dXWydV73n8Z/HjscySpqM8U4ICuWmbitAQkgQJTSmnkSVUlUieNSqNRN66FCBkCE+mjatUiodqWpDkk4a0nNRVKhArfpykmNFqOpRDDqENMhYBXFBmDJpuZkoysum4zRBsZMQeS6AHIqInRd7PWb787mqtr33/qtS9N17PetZbpqYmJgIAFDMf6p6AACYa8QXAAoTXwAoTHwBoDDxBYDCxBcACmsp8Sb1+ukSbwP8DYsWtWd09EzVY8Cc09k5/5I/880XGlxLS3PVIwB/RXwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8oUENDu5Kd/fyNDc3p7t7eQYHd1U9EvAnRY6XBMoaHNyVJ554LDt2/HPuuOO2vPrqUAYG+pMkvb13Vjwd0DQxMTEx02/ibGcoq7t7eZ54YltuuaU7nZ3zU6+fzoED+7Np04PZv3+k6vFgTpjsbGfxhQa0ZMnCHD5cz7x58y7G9/z581m2rDPHjp2sejyYEyaL75TLziMjI9mwYUNuuOGGJElXV1e+9KUvZePGjblw4UI6Ozuzbdu2tLa2Tt/EwDXp6roxIyPDueWW7ouPjYwMp6vrxgqnAv7ssjZcfepTn8rzzz+f559/Po8++mh27tyZvr6+vPjii7n++uuze/fumZ4TuAIDAw9kYKA/Bw7sz/nz53PgwP4MDPRnYOCBqkcDcpW7nUdGRrJ69eokSU9PT4aHh6d1KODa9PbemU2bHs2mTQ+mra0tmzY9mE2bHrXZCmaJy9rt/Pbbb+crX/lK3n333fT392dsbOziMnNHR0fq9fqMDglcud7eO9Pbe+fFa77A7DFlfD/84Q+nv78/a9euzeHDh/OFL3whFy5cuPjzy9mvtWhRuz/oDRWabOMHUN6U8V28eHFuv/32JMmHPvShvP/978+vfvWrjI+Pp62tLcePH0+tVpv0NUZHz0zPtMAV880XqjHZh94pr/n+4Ac/yHe/+90kSb1ezzvvvJPe3t7s3bs3STI0NJRVq1ZN06gA0PimvM/397//fR544IGcOnUq58+fT39/f26++eY89NBDOXv2bJYuXZrNmzdn3rx5l3wNn7qhOr75QjUcsgFzmPhCNa5p2RkAmF7iCwCFiS80qLvuWpfFi69LU1NTFi++Lnfdta7qkYA/EV9oQHfdtS779v177r33vpw8eTL33ntf9u37dwGGWcLf84UG9JOf/Dj/8A//I1u3PpXrrpufrVufSpJ8//vPVTwZkNjtDA2pVluQt946nOuuu+7ibud33303N9ywLCdOnKp6PJgT7HaGOaapqSmPP/5P73ns8cf/KU1NTdUMBLyHZWdoQJ/5TE++970/nky3Y8f/ysaN/zPf+953c+ut/7XiyYDEsjM0rLvuWpef/OTHmZiYSFNTUz7zmZ78y7/sqXosmDOccAVzmBOuoBqu+QLALCK+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvNKjBwV3p7l6e5ubmdHcvz+DgrqpHAv7E2c7QgAYHd+WJJx7Ljh3/nDvuuC2vvjqUgYH+JElv750VTwc4XhIaUHf38jzxxLbcckv3xeMlDxzYn02bHsz+/SNVjwdzgrOdYY5ZsmRhDh+uZ968eRfje/78+Sxb1pljx05WPR7MCc52hjmmq+vGjIwMv+exkZHhdHXdWNFEwF8SX2hAAwMPZGCgPwcO7M/58+dz4MD+DAz0Z2DggapHA2LDFTSk3t4788YbI7n77v+Wc+fOprX1P2f9+ntttoJZwjdfaECDg7vywx8O5eWX/zXnzp3Lyy//a374wyG3G8EsYcMVNCC7naF6djvDHGO3M1TPbmeYY+x2htlNfKEB2e0Ms5tlZ2hQg4O7smPHkzl06P+kq+vGDAw8YLczFGTZGQBmEff5QgPyhxVgdrPsDA3IrUZQPbcawRzjViOonmu+MMe41QhmN/GFBuRWI5jdLDtDg3KrEVTLNV+Yw/58zRcoyzVfAJhFxBcAChNfAChMfKFBDQ7uSnf38jQ3N6e7e3kGB3dVPRLwJ46XhAbkeEmY3ex2hgbkeEmonluNYI5xvCRUb7L4WnaGBtTVdWOefPKb+bd/e/XiIRtr197heEmYJWy4ggb06U+vys6dT+Wee9bn9OnTueee9dm586l8+tOrqh4NyGXGd3x8PGvWrMng4GCOHj2a9evXp6+vLxs2bMi5c+dmekbgCv30p6/n61//x7z00vOZP39+Xnrp+Xz96/+Yn/709apHA3KZ13yfeuqpHDhwIJ///OfzxhtvpLu7O2vXrs327duzZMmS9PX1Tfp813yhLNd8oXrXdLzkb3/727z99tu59dZbkyQjIyNZvXp1kqSnpyfDw8OTPBuogj8pCLPblBuutmzZkkcffTR79uxJkoyNjaW1tTVJ0tHRkXq9PrMTwhzW3b08v/nNm1f13N7eO/7m47Xagit6nZtuutntSTDNJo3vnj178vGPfzzLli37mz+/3LuUFi1qT0tL85VPB3Pcm2/+76t+7ksvvZTHH388v/71r/ORj3wkjzzySO65555pnA64WpPGd9++fTl8+HD27duXY8eOpbW1Ne3t7RkfH09bW1uOHz+eWq025ZuMjp6ZtoGBy7NmzR1Zs+aO1GoL8uMf/3EJ2v4LKOeq7/PdsWPHxf9++umn88EPfjC//OUvs3fv3nz2s5/N0NBQVq1y6wIAXIkrvs/3a1/7Wvbs2ZO+vr6cPHky69atm4m5AKBhOV4SGlyttiAnTpyqegyYc67pViMAYHqJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYS1T/cLY2FgefvjhvPPOOzl79my++tWv5qabbsrGjRtz4cKFdHZ2Ztu2bWltbS0xLwD83WuamJiYmOwXXnvttRw5ciT3339/jhw5kvvuuy+f+MQn0t3dnbVr12b79u1ZsmRJ+vr6Lvka9frpaR8cuDy12oKcOHGq6jFgzunsnH/Jn0257Hz77bfn/vvvT5IcPXo0ixcvzsjISFavXp0k6enpyfDw8DSNCgCNb8pl5z+7++67c+zYsTzzzDP54he/eHGZuaOjI/V6fcYGBIBGc9nxffnll/Pmm2/mwQcfzF+uVE+xap0kWbSoPS0tzVc3IXDNJlv+AsqbMr4HDx5MR0dHPvCBD+Tmm2/OhQsX8r73vS/j4+Npa2vL8ePHU6vVJn2N0dEz0zYwcOXsu4Dyruma789//vM899xzSZLf/e53OXPmTFauXJm9e/cmSYaGhrJq1appGhUAGt+Uu53Hx8fzyCOP5OjRoxkfH09/f38++tGP5qGHHsrZs2ezdOnSbN68OfPmzbvka/jUDdWx2xmqMdk33ynjOx3EF6ojvlCNa1p2BgCml/gCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFNZS9QDQqLq6PpSTJ09WPUaSpFZbUOn7L1y4MIcO/d9KZ4DZRHxhhpw8eTInTpyqeox0ds5PvX660hmqjj/MNpadAaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCWi7nl7Zu3Zpf/OIX+cMf/pAvf/nL+djHPpaNGzfmwoUL6ezszLZt29La2jrTswJAQ5gyvj/72c/y1ltv5ZVXXsno6Gg+97nPZcWKFenr68vatWuzffv27N69O319fSXmBYC/e1MuO3/yk5/Mt771rSTJggULMjY2lpGRkaxevTpJ0tPTk+Hh4ZmdEgAayJTxbW5uTnt7e5Jk9+7d6e7uztjY2MVl5o6OjtTr9ZmdEgAayGVd802SH/3oR9m9e3eee+653HbbbRcfn5iYmPK5ixa1p6Wl+eomhL9jnZ3zqx4hyeyYYzbMALPFZcX39ddfzzPPPJPvfOc7mT9/ftrb2zM+Pp62trYcP348tVpt0uePjp6ZlmHh7029frrqEdLZOX9WzDEbZoCSJvvAOeWy8+nTp7N169Z8+9vfzsKFC5MkK1euzN69e5MkQ0NDWbVq1TSNCgCNb8pvvq+99lpGR0czMDBw8bFvfvOb+cY3vpFXXnklS5cuzbp162Z0SABoJE0Tl3PR9hpZbmIuqtUW5MSJU1WPMSuWnWfL/wso6ZqWnQGA6SW+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh7vOFGfLfv/+lXLfsv1Q9xqzw7uH/lxfu/U7VY0BRk93nK74wQ2bLwRIO2YBqOGQDAGYR8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKKyl6gGgkdVqC6oeYVZYuHBh1SPArCK+MENOnDhV9QhJ/vgBYLbMAvyRZWcAKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKOyy4nvo0KGsWbMmL7zwQpLk6NGjWb9+ffr6+rJhw4acO3duRocEgEYyZXzPnDmTxx57LCtWrLj42M6dO9PX15cXX3wx119/fXbv3j2jQwJAI5kyvq2trXn22WdTq9UuPjYyMpLVq1cnSXp6ejI8PDxzEwJAg2mZ8hdaWtLS8t5fGxsbS2tra5Kko6Mj9Xp9ZqYDgAY0ZXynMjExMeXvLFrUnpaW5mt9K+AqdXbOr3oE4C9cVXzb29szPj6etra2HD9+/D1L0n/L6OiZqxoOmB71+umqR4A5Z7IPvVd1q9HKlSuzd+/eJMnQ0FBWrVp1dZMBwBzUNDHFuvHBgwezZcuWHDlyJC0tLVm8eHGefPLJPPzwwzl79myWLl2azZs3Z968eZd8DZ+6oTq12oKcOHGq6jFgzpnsm++U8Z0O4gvVEV+oxrQvOwMAV098AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgsJaqBwAurbt7eX7zmzev+XVqtQVX/dybbro5+/ePXPMMwH9ompiYmJjpN6nXT8/0WwCX0Nk5379BqEBn5/xL/syyMwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIUV+cMKAMB/8M0XAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfKGBHTp0KGvWrMkLL7xQ9SjAXxBfaFBnzpzJY489lhUrVlQ9CvBXxBcaVGtra5599tnUarWqRwH+SkvVAwAzo6WlJS0t/onDbOSbLwAUJr4AUJj4AkBh/qoRNKiDBw9my5YtOXLkSFpaWrJ48eI8/fTTWbhwYdWjwZwnvgBQmGVnAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAr7/x0gAKPP2QioAAAAAElFTkSuQmCC", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Boxplot das receitas\n", "plt.boxplot(tips['total_bill'])\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 347 }, "id": "8CJj0BP90mzk", "outputId": "48e87bfe-6a5a-4dc4-dbd8-12e71ec8d496" }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAd8AAAFKCAYAAABcq1WoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAUXUlEQVR4nO3db2jd9f338VevxlBSq6vxpFjRug3/lFXnBIV2xhkrjpaxVWGjC1M2sSilroNp29XqHILrHydaJ1as7Q2lM1s2Si/YSPBPQUaMKGNbh6D1xui6mh1L1EoT/8RcNy7I9fPa1tTm5JPk9PG4lXxP0u+777Y8+X5Pz8m04eHh4QAAxfyviR4AAE424gsAhYkvABQmvgBQmPgCQGHiCwCFNZQ4SbV6pMRp6tbs2U3p7z860WPUFTutPTutPTutvZI7rVRm/dfHXPlOAQ0N0yd6hLpjp7Vnp7Vnp7U3WXY66pXvb37zm+zZs2fk83379uVXv/pV7r333iTJhRdemJ/97GfjNiAA1Jtpn+Udrl5++eX84Q9/yP79+3PnnXfmkksuyY9//ON885vfzNe+9rX/+n1uO49NpTLLDmvMTmvPTmvPTmuv5E5rdtv50UcfzYoVK3Lw4MFccsklSZK2trb09PSMbUIAOIkcd3z/8pe/5Kyzzsr06dNz2mmnjRxvbm5OtVodl+EAoB4d9/927uzszPXXX/9vx4/nrvXs2U2T5knuqepYty84MXZae3Zae3Zae5Nhp8cd397e3mzYsCHTpk3LO++8M3K8r68vLS0tx/xe/1V+bDzvU3t2Wnt2Wnt2WntT6jnfvr6+zJw5M42NjTnllFPyhS98Ia+88kqSpLu7O62trbWZFABOAsd15VutVnPGGWeMfL5+/frcc889+eSTT/LlL385ixYtGrcBAaDefKaXGp0ot03Gxq2n2rPT2rPT2rPT2ptSt50BgNoRXwAoTHwBoLAiP9WIyenmjc9P9AjHtGPdNRM9AsC4cOULAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhTUczxft2bMn27dvT0NDQ374wx/mwgsvzJo1azI0NJRKpZItW7aksbFxvGcFgLow6pVvf39/Hn300ezatSvbtm3Lc889l61bt6a9vT27du3KvHnz0tnZWWJWAKgLo8a3p6cnCxcuzKmnnpqWlpbcd9996e3tzeLFi5MkbW1t6enpGfdBAaBejHrb+R//+EcGBwdz22235b333svtt9+egYGBkdvMzc3NqVar4z4oANSL43rO95133skvf/nL/POf/8xNN92U4eHhkcf+58f/zezZTWlomH7iU5JKZdZEj1DceP+eT8adjjc7rT07rb3JsNNR49vc3JyvfOUraWhoyLnnnpuZM2dm+vTpGRwczIwZM9LX15eWlpZj/hr9/UdrNvDJqFKZlWr1yESPUdx4/p5P1p2OJzutPTutvZI7PVbkR33O98orr8xLL72UTz75JP39/Tl69GgWLVqUrq6uJEl3d3daW1trNy0A1LlRr3znzJmTr3/96/nOd76TJNmwYUMuvvjirF27Nh0dHZk7d26WLVs27oMCQL04rud8ly9fnuXLl3/q2M6dO8dlIACod97hCgAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCGiZ6APhvbt74/ESPMKod666Z6BGAKWjU+Pb29mb16tU5//zzkyQXXHBBbrnllqxZsyZDQ0OpVCrZsmVLGhsbx31YAKgHx3Xle8UVV2Tr1q0jn//kJz9Je3t7lixZkgcffDCdnZ1pb28ftyEBoJ6c0HO+vb29Wbx4cZKkra0tPT09NR0KAOrZcV357t+/P7fddlvefffdrFq1KgMDAyO3mZubm1OtVo/5/bNnN6WhYfrYpz2JVSqzJnoE/gN/Lp9mH7Vnp7U3GXY6anzPO++8rFq1KkuWLMmBAwdy0003ZWhoaOTx4eHhUU/S3390bFOe5CqVWalWj0z0GPwH/lz+H39Pa89Oa6/kTo8V+VFvO8+ZMydLly7NtGnTcu655+bMM8/Mu+++m8HBwSRJX19fWlpaajctANS5UeO7Z8+ePPnkk0mSarWaw4cP54YbbkhXV1eSpLu7O62treM7JQDUkVFvO19zzTW544478txzz+Wjjz7Kvffem/nz52ft2rXp6OjI3Llzs2zZshKzAkBdGDW+p556arZt2/Zvx3fu3DkuAwFAvfP2kgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFCa+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFiS8AFNYw0QPUq5s3Pj/RIwAwSbnyBYDCxBcAChNfAChMfAGgsOOK7+DgYK699tr87ne/y6FDh3LjjTemvb09q1evzocffjjeMwJAXTmu+D722GM5/fTTkyRbt25Ne3t7du3alXnz5qWzs3NcBwSAejNqfN98883s378/V199dZKkt7c3ixcvTpK0tbWlp6dnXAcEgHoz6ut8N23alLvvvju7d+9OkgwMDKSxsTFJ0tzcnGq1OupJZs9uSkPD9DGOCpNPpTJrokeYVOyj9uy09ibDTo8Z3927d+fSSy/NOeec8x8fHx4ePq6T9Pcf/eyTwRRQrR6Z6BEmjUplln3UmJ3WXsmdHivyx4zv3r17c+DAgezduzdvvfVWGhsb09TUlMHBwcyYMSN9fX1paWmp+cAAUM+OGd+HHnpo5ONHHnkkZ599dv70pz+lq6sr3/rWt9Ld3Z3W1tZxHxIA6slnfp3v7bffnt27d6e9vT3vvPNOli1bNh5zAUDdOu4frHD77bePfLxz585xGQYATgbe4QoAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwhomegCYym7e+PxEjzCqHeuumegRgP/PqPEdGBjIunXrcvjw4XzwwQdZuXJlLrrooqxZsyZDQ0OpVCrZsmVLGhsbS8wLAFPeqPF94YUXsmDBgqxYsSIHDx7MzTffnMsuuyzt7e1ZsmRJHnzwwXR2dqa9vb3EvAAw5Y36nO/SpUuzYsWKJMmhQ4cyZ86c9Pb2ZvHixUmStra29PT0jO+UAFBHjvs53+XLl+ett97Ktm3b8oMf/GDkNnNzc3Oq1eoxv3f27KY0NEwf26TACalUZtXluU4Wdlp7k2Gnxx3fZ555Jq+99lruvPPODA8Pjxz/nx//N/39R09sOmDMqtUjRc5Tqcwqdq6ThZ3WXsmdHivyo9523rdvXw4dOpQkmT9/foaGhjJz5swMDg4mSfr6+tLS0lKjUQGg/o0a31deeSU7duxIkrz99ts5evRoFi1alK6uriRJd3d3Wltbx3dKAKgjo952Xr58ee666660t7dncHAw99xzTxYsWJC1a9emo6Mjc+fOzbJly0rMCgB1YdT4zpgxI7/4xS/+7fjOnTvHZSAAqHfeXhIAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwhqO54s2b96cV199NR9//HFuvfXWXHzxxVmzZk2GhoZSqVSyZcuWNDY2jvesAFAXRo3vSy+9lDfeeCMdHR3p7+/P9ddfn4ULF6a9vT1LlizJgw8+mM7OzrS3t5eYFwCmvFFvO19++eV5+OGHkySnnXZaBgYG0tvbm8WLFydJ2tra0tPTM75TAkAdGTW+06dPT1NTU5Kks7MzV111VQYGBkZuMzc3N6darY7vlABQR47rOd8kefbZZ9PZ2ZkdO3bkuuuuGzk+PDw86vfOnt2UhobpJzYhMCaVyqy6PNfJwk5rbzLs9Lji++KLL2bbtm3Zvn17Zs2alaampgwODmbGjBnp6+tLS0vLMb+/v/9oTYYFPrtq9UiR81Qqs4qd62Rhp7VXcqfHivyot52PHDmSzZs35/HHH8/nPve5JMmiRYvS1dWVJOnu7k5ra2uNRgWA+jfqle/vf//79Pf350c/+tHIsY0bN2bDhg3p6OjI3Llzs2zZsnEdEgDqybTh43nSdoxOxtsmN298fqJHgClhx7prJnqESctt59qbMredAYDaEl8AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKEx8AaAw8QWAwsQXAAprmOgBgJPbzRufn+gRRrVj3TUTPQJ1xpUvABQmvgBQmPgCQGHHFd/XX3891157bZ5++ukkyaFDh3LjjTemvb09q1evzocffjiuQwJAPRk1vkePHs19992XhQsXjhzbunVr2tvbs2vXrsybNy+dnZ3jOiQA1JNR49vY2JgnnngiLS0tI8d6e3uzePHiJElbW1t6enrGb0IAqDOjvtSooaEhDQ2f/rKBgYE0NjYmSZqbm1OtVsdnOgCoQ2N+ne/w8PCoXzN7dlMaGqaP9VQAE6JSmXVSnrteTYadnlB8m5qaMjg4mBkzZqSvr+9Tt6T/k/7+oyc0HMBkUK0emZDzViqzJuzc9arkTo8V+RN6qdGiRYvS1dWVJOnu7k5ra+uJTQYAJ6FRr3z37duXTZs25eDBg2loaEhXV1ceeOCBrFu3Lh0dHZk7d26WLVtWYlYAqAujxnfBggV56qmn/u34zp07x2UgAKh33uEKAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgsGnDx/PmzGM0Hm/ldfPG52v+awJMRTvWXTPRI0wZU/rtJQGAEye+AFCY+AJAYeILAIWJLwAUJr4AUJj4AkBh4gsAhYkvABQmvgBQmPgCQGHiCwCFNUz0AADUv6nww3BK/oAKV74AUJj4AkBh4gsAhXnOF2CKmwrPp/JprnwBoDDxBYDCxBcAChNfAChMfAGgMPEFgMLEFwAKE18AKOyE32Tj/vvvz5///OdMmzYt69evzyWXXFLLuQCgbp1QfF9++eX8/e9/T0dHR958882sX78+HR0dtZ4NAOrSCd127unpybXXXpsk+eIXv5h3330377//fk0HA4B6dULxffvttzN79uyRz88444xUq9WaDQUA9awmP1hheHj4mI9XKrNqcZpP+d+/+FbNf00AKOGErnxbWlry9ttvj3z+r3/9K5VKpWZDAUA9O6H4fvWrX01XV1eS5G9/+1taWlpy6qmn1nQwAKhXJ3Tb+bLLLsuXvvSlLF++PNOmTctPf/rTWs8FAHVr2vBoT9gCADXlHa4AoDDxBYDCavJSI2rr9ddfz8qVK/P9738/3/ve93Lo0KGsWbMmQ0NDqVQq2bJlSxobGyd6zCll8+bNefXVV/Pxxx/n1ltvzcUXX2ynJ2hgYCDr1q3L4cOH88EHH2TlypW56KKL7LMGBgcH841vfCMrV67MwoUL7XQMent7s3r16px//vlJkgsuuCC33HLLpNmpK99J5ujRo7nvvvuycOHCkWNbt25Ne3t7du3alXnz5qWzs3MCJ5x6Xnrppbzxxhvp6OjI9u3bc//999vpGLzwwgtZsGBBnn766Tz00EPZuHGjfdbIY489ltNPPz2Jf/e1cMUVV+Spp57KU089lbvvvntS7VR8J5nGxsY88cQTaWlpGTnW29ubxYsXJ0na2trS09MzUeNNSZdffnkefvjhJMlpp52WgYEBOx2DpUuXZsWKFUmSQ4cOZc6cOfZZA2+++Wb279+fq6++Ool/9+NhMu1UfCeZhoaGzJgx41PHBgYGRm6NNDc3eyvPz2j69OlpampKknR2duaqq66y0xpYvnx57rjjjqxfv94+a2DTpk1Zt27dyOd2Onb79+/Pbbfdlu9+97v54x//OKl26jnfKcYrw07cs88+m87OzuzYsSPXXXfdyHE7PTHPPPNMXnvttdx5552f2qF9fna7d+/OpZdemnPOOec/Pm6nn915552XVatWZcmSJTlw4EBuuummDA0NjTw+0TsV3ymgqakpg4ODmTFjRvr6+j51S5rj8+KLL2bbtm3Zvn17Zs2aZadjsG/fvjQ3N+ess87K/PnzMzQ0lJkzZ9rnGOzduzcHDhzI3r1789Zbb6WxsdHf0TGaM2dOli5dmiQ599xzc+aZZ+avf/3rpNmp285TwKJFi0bezrO7uzutra0TPNHUcuTIkWzevDmPP/54Pve5zyWx07F45ZVXsmPHjiT/9yecHT161D7H6KGHHspvf/vb/PrXv863v/3trFy50k7HaM+ePXnyySeTJNVqNYcPH84NN9wwaXbqHa4mmX379mXTpk05ePBgGhoaMmfOnDzwwANZt25dPvjgg8ydOzc///nPc8opp0z0qFNGR0dHHnnkkXz+858fObZx48Zs2LDBTk/A4OBg7rrrrhw6dCiDg4NZtWpVFixYkLVr19pnDTzyyCM5++yzc+WVV9rpGLz//vu544478t577+Wjjz7KqlWrMn/+/EmzU/EFgMLcdgaAwsQXAAoTXwAoTHwBoDDxBYDCxBcAChNfAChMfAGgsP8D7h+bpyXaDcgAAAAASUVORK5CYII=", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Histograma das receitas\n", "plt.hist(tips['total_bill'])\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 347 }, "id": "L-6pBR9_0eW5", "outputId": "01c97bfa-ea73-49b9-907c-9f0e6eed5c8f" }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAd8AAAFKCAYAAABcq1WoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAQdklEQVR4nO3db2jd9b3A8U+Xkzgiqc2Vk3Zx1bsnaQWR7cEIlXiYrOserDgWdA/kdj64F5xbRw+spRo37W0xUu2DuHbrxD9MJsJIOftDkU02VtJAzWCDgWDNNhi3f1YbZmq7xmis5z6Y61qxsZ4mn184eb0envM7+X0onL7P7/s75/dbUq/X6wEApPlY0QMAwGIjvgCQTHwBIJn4AkAy8QWAZOILAMlKGTuZmDiTsRvgA3R2tsfk5FTRY8CiUy53XPI5R77Q5EqllqJHAN5HfAEgmfgCQDLxBYBk4gsAycQXAJKJLwAkE18ASCa+AJDssuI7Pj4ea9eujeeeey4iIv72t7/Fhg0b4q677opNmzbF22+/Pa9DAh9drTYclUpvtLS0RKXSG7XacNEjAe/50PhOTU3Fjh07Ys2aNecf+973vhd33XVXPP/883HDDTfEvn375nVI4KOp1YZjcHBHDA4+FtPT0zE4+FgMDu4QYFggPjS+bW1t8eSTT0ZXV9f5x8bGxuLzn/98RETcdtttcejQofmbEPjIhoZ2xdDQnujrq0Rra2v09VViaGhPDA3tKno0IC7jxgqlUilKpYs3e/PNN6OtrS0iIq699tqYmJiY9W90dra7viwkGh9/NdavXxetra0R8c8LvK9fvy7uuOP2WS/2DuS44rsa1ev1D93GHVUgV0/Pqti//8Xo66tEudwRExNnYnR0JHp6VrnLGCSZ87satbe3x/T0dEREvPbaaxctSQPFq1Y3R7W6MUZHR2JmZiZGR0eiWt0Y1ermokcDosEj31tuuSV+9atfxZe//OV48cUX49Zbb53ruYAr0N9/Z0REDAxsiTvuuD16elbFwMB3zz8OFGtJ/UPWjV9++eXYuXNnHDt2LEqlUixfvjx27doV9913X7z11lvR3d0djzzyyPlzSx/EMhcU51/LzkCu2ZadPzS+c8EbH4ojvlCMOT/nCwA0TnwBIJn4AkAy8QWAZOILAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZOILAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZOILAMnEFwCSiS80qVptOCqV3mhpaYlKpTdqteGiRwLeUyp6AGDu1WrDMTi4I4aG9sT69eti//4Xo1rdGBER/f13FjwdsKRer9fneycTE2fmexfABSqV3hgcfCz6+ipRLnfExMSZGB0diYGBLTEyMlb0eLAolMsdl3xOfKEJrVixLI4cmYjW1tbz8Z2ZmYmVK8tx4sSposeDRWG2+DrnC02op2dVjI0duuixsbFD0dOzqqCJgAuJLzShanVzVKsbY3R0JGZmZmJ0dCSq1Y1RrW4uejQgLDtD06rVhmNoaFeMj78aPT2rolrd7MtWkMg5X1jE/nXOF8jlnC8ALCDiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIVmrkRWfPno2tW7fGG2+8ETMzM/HNb34zbr311rmeDQCaUkPx/elPfxqf+tSn4tvf/na89tprcffdd8cvf/nLuZ4NAJpSQ8vOnZ2dcerUqYiIOH36dHR2ds7pUADQzBo68v3Sl74UtVotvvCFL8Tp06fjiSeemOu5AKBpNRTfn//859Hd3R1PP/10HD58OAYGBqJWq11y+87O9iiVWhoeErgy5XJH0SMAF2govn/4wx+ir68vIiJWr14dJ0+ejHPnzkVLywcHdnJyqvEJgStSLnfExMSZoseARWe2D70NnfO94YYb4o9//GNERBw7diyuvvrqS4YXALjYknq9Xv+oLzp79mwMDAzE3//+93jnnXdi06ZNsWbNmktu71M3FMeRLxRjtiPfhuL7UXnjQ3HEF4ox58vOAEDjxBcAkokvACQTXwBIJr7QpGq14ahUeqOlpSUqld6o1YaLHgl4T0MX2QAWtlptOAYHd8TQ0J5Yv35d7N//YlSrGyMior//zoKnA/zUCJpQpdIbg4OPRV9f5fxPjUZHR2JgYEuMjIwVPR4sCn7nC4vMihXL4siRiWhtbT0f35mZmVi5shwnTpwqejxYFPzOFxaZnp5VMTZ26KLHxsYORU/PqoImAi4kvtCEqtXNUa1ujNHRkZiZmYnR0ZGoVjdGtbq56NGAsOwMTatWG46hoV0xPv5q9PSsimp1sy9bQSLnfGERc21nKIZzvgCwgIgvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTX2hStdpwVCq90dLSEpVKb9Rqw0WPBLynVPQAwNyr1YbjgQe2Rnt7e0REnD17Nh54YGtERPT331nkaEA48oWmtH37d6NUaonHH/9BTE9Px+OP/yBKpZbYvv27RY8GhPhCUzp+/Hjs3v1E9PVVorW1Nfr6KrF79xNx/PjxokcDQnwBIJ34QhPq7u6OjRvvidHRkZiZmYnR0ZHYuPGe6O7uLno0IMQXmtKDD+6Id989F5s2fSOuuuqq2LTpG/Huu+fiwQd3FD0aEOILTam//8646aab4+jRI1Gv1+Po0SNx0003+6YzLBDiC03o/vs3x8GDI7Ft28Nx9uzZ2Lbt4Th4cCTuv39z0aMBEbGkXq/X53snExNn5nsXwAU++clyPPDAQ3HvvRujXO6IiYkzsXfvnnj44f+No0cnih4PFoVyueOSz4kvNKGurqXx17+eiPb29vPxnZqaiv/8zxVx8uTposeDRWG2+Fp2hibU1nZVPPvsMxc99uyzz0Rb21UFTQRcSHyhCW3YcHds3/5g7N27J6ampmLv3j2xffuDsWHD3UWPBoRlZ2ha99+/OX7842fj7bffira2q2LDhrvjkUd2FT0WLBrO+cIi9q9zvkAu53wBYAERXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJGo7vL37xi7j99tujv78/Dhw4MIcjAXOhVhuOSqU3WlpaolLpjVptuOiRgPc0FN/Jycn4/ve/H88//3z88Ic/jN/85jdzPRdwBWq14Rgc3BGDg4/F9PR0DA4+FoODOwQYFoiGrnD1wgsvxO9+97vYtm3bZW3v6jqQq1LpjcHBx6Kvr3L+ClejoyMxMLAlRkbGih4PFoXZrnBVauQPHj16NKanp+PrX/96nD59Or71rW/FmjVrLrl9Z2d7lEotjewKaMD4+Kvxj3+8HrfdtiZeeeWVuPHGG2Pr1q0xPv7qrP8hADkaim9ExKlTp2LPnj1x/Pjx+NrXvha//e1vY8mSJR+47eTkVMMDAh/dihUrYsuWLbF379Oxfv262L//xbj33v+OFStWWImCJHN+bedrr702PvOZz0SpVIrrr78+rr766nj99dcbHhCYe+8/oTT/t1ABLldD8e3r64uXXnop3n333ZicnIypqano7Oyc69mABp04cSIeemh7DAxsiY9//OMxMLAlHnpoe5w4caLo0YBocNl5+fLl8cUvfjG++tWvRkTEd77znfjYx/xkGBaKnp5V8YlPXBcjI2MXfeGqp2dV0aMB4X6+sKBVKr1x+PArhc6wevWNviENDZjtnK/4QpOq1YZjaGhXHD78SqxefWNUq5ujv//OoseCRUN8YRHr6loaJ0+eLnoMWHTm/NvOAEDjxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJrii+09PTsXbt2qjVanM1DwA0vSuK7969e+Oaa66Zq1kAYFFoOL5/+ctf4s9//nN87nOfm8NxAKD5NRzfnTt3xn333TeXswDAolBq5EU/+9nP4tOf/nSsXLnysrbv7GyPUqmlkV0Bc6Bc7ih6BOACDcX3wIEDceTIkThw4ECcOHEi2traYsWKFXHLLbd84PaTk1NXNCRwZSYmzhQ9Aiw6s33oXVKv1+tX8sd3794d1113XfT3919yG298KE5X19I4efJ00WPAojNbfP3OFwCSXfGR7+Vw5AvFceQLxXDkCwALiPgCQDLxBYBk4gsAycQXAJKJLwAkE18ASCa+AJCsoWs7Ax+up+f6OHXqVNFjRMQ/L7RRpGXLlsX4+P8VOgMsJOIL8+TUqVML4spS5XJH4VeZKzr+sNBYdgaAZOILAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZOILAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZOILAMmW1Ov1+nzvZGLizHzvAhac/3r2f+Kalf9R9BgLwhtHXo/n7n6q6DEgVbncccnnxBfmSVfX0jh58nTRY0S53FH4e3Ch/FtAptnia9kZAJKJLwAkE18ASCa+AJBMfAEgmfgCQDLxBYBk4gsAycQXAJKJLwAkE18ASCa+AJBMfAEgmfgCQDLxBYBk4gsAycQXAJKJLwAkE18ASCa+AJBMfAEgWanRFz766KPx+9//Pt5555245557Yt26dXM5FwA0rYbi+9JLL8Wf/vSn+MlPfhKTk5Pxla98RXwB4DI1FN/PfvazcfPNN0dExNKlS+PNN9+Mc+fORUtLy5wOBwDNqKFzvi0tLdHe3h4REfv27YtKpSK8AHCZGj7nGxHx61//Ovbt2xfPPPPMrNt1drZHqSTOLD5dXUuLHmFB6OzsjHK5o+gxYMFYUq/X64288ODBg/H444/HU089FcuWLZt124mJMw0NB1y5rq6lcfLk6aLHgEVntg+cDR35njlzJh599NH40Y9+9KHhBQAu1lB8X3jhhZicnIxqtXr+sZ07d0Z3d/ecDQYAzarhZeePwrIzFMeyMxRjtmVnV7gCgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGTiCwDJxBcAkokvACQTXwBIJr4AkEx8ASCZ+AJAMvEFgGSlogcALq1S6Y3Dh1+54r/T1bW04deuXn1jjIyMXfEMwL8tqdfr9fneycTEmfneBXAJ5XKH9yAUoFzuuORzlp0BIJn4AkAy8QWAZOILAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZOILAMlSbqwAAPybI18ASCa+AJBMfAEgmfgCQDLxBYBk4gsAycQXmtj4+HisXbs2nnvuuaJHAS4gvtCkpqamYseOHbFmzZqiRwHeR3yhSbW1tcWTTz4ZXV1dRY8CvE+p6AGA+VEqlaJU8haHhciRLwAkE18ASCa+AJDMXY2gSb388suxc+fOOHbsWJRKpVi+fHns3r07li1bVvRosOiJLwAks+wMAMnEFwCSiS8AJBNfAEgmvgCQTHwBIJn4AkAy8QWAZP8P+aMcY6d8ymgAAAAASUVORK5CYII=", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Boxplot das gorjetas\n", "plt.boxplot(tips['tip'])\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "6YeKe5TJ1I_y", "outputId": "064e3b5d-f60b-41ae-8a65-3f3420cade53" }, "outputs": [ { "data": { "text/plain": [ "1.0" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Menor gorjeta\n", "tips['tip'].min()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "bRE49_BP1RDK", "outputId": "44ebf607-44df-4174-c126-3960578544a1" }, "outputs": [ { "data": { "text/plain": [ "10.0" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Maior gorjeta\n", "tips['tip'].max()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 81 }, "id": "Irtbbyr41XmF", "outputId": "f3e65047-7dfe-4417-b5c5-17d6001577b7" }, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_billtipsexsmokerdaytimesizeprice_per_personbill_percentage
17050.8110.0MaleYesSatDinner316.9366670.196812
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ], "text/plain": [ " total_bill tip sex smoker day time size price_per_person \\\n", "170 50.81 10.0 Male Yes Sat Dinner 3 16.936667 \n", "\n", " bill_percentage \n", "170 0.196812 " ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Identificar Outlier\n", "tips[tips['tip'] == 10.0]" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "nWzqQIMO2FkC" }, "outputs": [], "source": [ "# Salvar base de dados\n", "tips.to_csv('tips_new.csv', index=False)" ] } ], "metadata": { "colab": { "provenance": [] }, "kernelspec": { "display_name": "Python 3.10.6 64-bit", "language": "python", "name": "python3" }, "language_info": { "name": "python", "version": "3.10.6" }, "vscode": { "interpreter": { "hash": "916dbcbb3f70747c44a77c7bcd40155683ae19c65e1c03b4aa3499c5328201f1" } } }, "nbformat": 4, "nbformat_minor": 0 }