кр1.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Sinrez/PythonProjects/blob/main/%D0%BA%D1%801.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Jf1w_d_8cD6y"
      },
      "source": [
        "## Контрольная работа"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "WBuxEYzRcD60"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "U7BymRb6cD61"
      },
      "source": [
        "### Датафрейм с которым вы будете сегодня работать"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "metadata": {
        "id": "iy2Q5EsScD61"
      },
      "outputs": [],
      "source": [
        "data = [['Girev', 'Andrey', 'ВИП', 2815, 29, 58, 6358, 'Moscow', 'Xiaomi'],\n",
        "       ['Bykin', 'Stas', 'Все за 300', 3634, 37, 78, 602, 'Kazan',\n",
        "        'Samsung'],\n",
        "       ['Ivanov', 'Alex', 'Всё за 800', 410, 47, 81, 3582, 'Moscow',\n",
        "        'Huawei'],\n",
        "       ['Andreev', 'Sergey', 'Всё за 500', 1981, 75, 98, 5442, 'Kazan',\n",
        "        'Apple'],\n",
        "       ['Girev', 'Stas', 'Всё за 800', 4969, 43, 61, 8510, 'Moscow',\n",
        "        'Samsung'],\n",
        "       ['Bykin', 'Andrey', 'Всё за 500', 4308, 49, 39, 2525, 'Moscow',\n",
        "        'Xiaomi'],\n",
        "       ['Kozlov', 'Igor', 'Всё за 800', 300, 60, 31, 8543, 'Yakutsk',\n",
        "        'Samsung'],\n",
        "       ['Girev', 'Alex', 'Промо', 4199, 47, 90, 3925, 'Kazan', 'Apple'],\n",
        "       ['Petrov', 'Nikolay', 'ВИП', 4810, 72, 88, 7188, 'Moscow',\n",
        "        'Apple'],\n",
        "       ['Andreev', 'Sergey', 'Всё за 800', 4118, 52, 53, 419, 'Yakutsk',\n",
        "        'Apple'],\n",
        "       ['Smolov', 'Stas', 'Промо', 1991, 28, 67, 5016, 'Kazan', 'Xiaomi'],\n",
        "       ['Girev', 'Igor', 'Корпоративный', 1430, 69, 19, 9520, 'Yakutsk',\n",
        "        'Samsung'],\n",
        "       ['Kozlov', 'Andrey', 'Корпоративный', 113, 71, 82, 2785, 'Kazan',\n",
        "        'Apple'],\n",
        "       ['Ivanov', 'Sergey', 'Промо', 3394, 39, 12, 2718, 'Yakutsk',\n",
        "        'Xiaomi'],\n",
        "       ['Smolov', 'Sergey', 'Всё за 250 (архив)', 3493, 32, 6, 8959,\n",
        "        'Yakutsk', 'Huawei'],\n",
        "       ['Kozlov', 'Stas', 'Всё за 800', 4565, 59, 82, 3168, 'Moscow',\n",
        "        'Apple'],\n",
        "       ['Vlasov', 'Andrey', 'Всё за 800', 3192, 29, 74, 2852, 'Yakutsk',\n",
        "        'Xiaomi'],\n",
        "       ['Smolov', 'Alex', 'Корпоративный', 3764, 71, 22, 2768, 'Moscow',\n",
        "        'Huawei'],\n",
        "       ['Vlasov', 'Sergey', 'Всё за 800', 3816, 28, 35, 5734,\n",
        "        'Vladivostok', 'Apple'],\n",
        "       ['Bykin', 'Alex', 'Промо', 817, 65, 34, 2131, 'Vladivostok',\n",
        "        'Samsung'],\n",
        "       ['Andreev', 'Nikolay', 'Всё за 500', 385, 49, 62, 1815, 'Kazan',\n",
        "        'Xiaomi'],\n",
        "       ['Bykin', 'Igor', 'Всё за 500', 2642, 38, 11, 3787, 'Moscow',\n",
        "        'Xiaomi'],\n",
        "       ['Girev', 'Sergey', 'Все за 300', 4230, 62, 68, 5512,\n",
        "        'Vladivostok', 'Samsung'],\n",
        "       ['Bykin', 'Sergey', 'Всё за 800', 4100, 48, 39, 227, 'Moscow',\n",
        "        'Xiaomi'],\n",
        "       ['Girev', 'Stas', 'Все за 300', 3371, 53, 24, 7946, 'Kazan',\n",
        "        'Apple'],\n",
        "       ['Smolov', 'Sergey', 'Корпоративный', 3577, 70, 71, 8847,\n",
        "        'Yakutsk', 'Huawei'],\n",
        "       ['Mezov', 'Nikolay', 'Всё за 250 (архив)', 2742, 28, 19, 7115,\n",
        "        'Yakutsk', 'Huawei'],\n",
        "       ['Smolov', 'Stas', 'Всё за 500', 2644, 41, 33, 8341, 'Moscow',\n",
        "        'Xiaomi'],\n",
        "       ['Vlasov', 'Andrey', 'Всё за 500', 4725, 26, 93, 9441,\n",
        "        'Vladivostok', 'Xiaomi'],\n",
        "       ['Ivanov', 'Nikolay', 'Всё за 500', 2785, 41, 5, 2901, 'Moscow',\n",
        "        'Samsung']]\n",
        "\n",
        "df = pd.DataFrame(data, columns = ['surname', 'name', 'tarif', 'balance', 'age', 'sms', 'voice', 'city', 'phone'])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 23,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 990
        },
        "id": "VyZ1wuhacD62",
        "outputId": "bd6015a0-302f-4310-8435-42d8e07525b3"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name               tarif  balance  age  sms  voice  \\\n",
              "0     Girev   Andrey                 ВИП     2815   29   58   6358   \n",
              "1     Bykin     Stas          Все за 300     3634   37   78    602   \n",
              "2    Ivanov     Alex          Всё за 800      410   47   81   3582   \n",
              "3   Andreev   Sergey          Всё за 500     1981   75   98   5442   \n",
              "4     Girev     Stas          Всё за 800     4969   43   61   8510   \n",
              "5     Bykin   Andrey          Всё за 500     4308   49   39   2525   \n",
              "6    Kozlov     Igor          Всё за 800      300   60   31   8543   \n",
              "7     Girev     Alex               Промо     4199   47   90   3925   \n",
              "8    Petrov  Nikolay                 ВИП     4810   72   88   7188   \n",
              "9   Andreev   Sergey          Всё за 800     4118   52   53    419   \n",
              "10   Smolov     Stas               Промо     1991   28   67   5016   \n",
              "11    Girev     Igor       Корпоративный     1430   69   19   9520   \n",
              "12   Kozlov   Andrey       Корпоративный      113   71   82   2785   \n",
              "13   Ivanov   Sergey               Промо     3394   39   12   2718   \n",
              "14   Smolov   Sergey  Всё за 250 (архив)     3493   32    6   8959   \n",
              "15   Kozlov     Stas          Всё за 800     4565   59   82   3168   \n",
              "16   Vlasov   Andrey          Всё за 800     3192   29   74   2852   \n",
              "17   Smolov     Alex       Корпоративный     3764   71   22   2768   \n",
              "18   Vlasov   Sergey          Всё за 800     3816   28   35   5734   \n",
              "19    Bykin     Alex               Промо      817   65   34   2131   \n",
              "20  Andreev  Nikolay          Всё за 500      385   49   62   1815   \n",
              "21    Bykin     Igor          Всё за 500     2642   38   11   3787   \n",
              "22    Girev   Sergey          Все за 300     4230   62   68   5512   \n",
              "23    Bykin   Sergey          Всё за 800     4100   48   39    227   \n",
              "24    Girev     Stas          Все за 300     3371   53   24   7946   \n",
              "25   Smolov   Sergey       Корпоративный     3577   70   71   8847   \n",
              "26    Mezov  Nikolay  Всё за 250 (архив)     2742   28   19   7115   \n",
              "27   Smolov     Stas          Всё за 500     2644   41   33   8341   \n",
              "28   Vlasov   Andrey          Всё за 500     4725   26   93   9441   \n",
              "29   Ivanov  Nikolay          Всё за 500     2785   41    5   2901   \n",
              "\n",
              "           city    phone  \n",
              "0        Moscow   Xiaomi  \n",
              "1         Kazan  Samsung  \n",
              "2        Moscow   Huawei  \n",
              "3         Kazan    Apple  \n",
              "4        Moscow  Samsung  \n",
              "5        Moscow   Xiaomi  \n",
              "6       Yakutsk  Samsung  \n",
              "7         Kazan    Apple  \n",
              "8        Moscow    Apple  \n",
              "9       Yakutsk    Apple  \n",
              "10        Kazan   Xiaomi  \n",
              "11      Yakutsk  Samsung  \n",
              "12        Kazan    Apple  \n",
              "13      Yakutsk   Xiaomi  \n",
              "14      Yakutsk   Huawei  \n",
              "15       Moscow    Apple  \n",
              "16      Yakutsk   Xiaomi  \n",
              "17       Moscow   Huawei  \n",
              "18  Vladivostok    Apple  \n",
              "19  Vladivostok  Samsung  \n",
              "20        Kazan   Xiaomi  \n",
              "21       Moscow   Xiaomi  \n",
              "22  Vladivostok  Samsung  \n",
              "23       Moscow   Xiaomi  \n",
              "24        Kazan    Apple  \n",
              "25      Yakutsk   Huawei  \n",
              "26      Yakutsk   Huawei  \n",
              "27       Moscow   Xiaomi  \n",
              "28  Vladivostok   Xiaomi  \n",
              "29       Moscow  Samsung  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-96aec6b6-9477-4880-a65f-eaebaa4d7290\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>2815</td>\n",
              "      <td>29</td>\n",
              "      <td>58</td>\n",
              "      <td>6358</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3634</td>\n",
              "      <td>37</td>\n",
              "      <td>78</td>\n",
              "      <td>602</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>410</td>\n",
              "      <td>47</td>\n",
              "      <td>81</td>\n",
              "      <td>3582</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>1981</td>\n",
              "      <td>75</td>\n",
              "      <td>98</td>\n",
              "      <td>5442</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4969</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>300</td>\n",
              "      <td>60</td>\n",
              "      <td>31</td>\n",
              "      <td>8543</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4810</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Промо</td>\n",
              "      <td>1991</td>\n",
              "      <td>28</td>\n",
              "      <td>67</td>\n",
              "      <td>5016</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>1430</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>9520</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>113</td>\n",
              "      <td>71</td>\n",
              "      <td>82</td>\n",
              "      <td>2785</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Промо</td>\n",
              "      <td>3394</td>\n",
              "      <td>39</td>\n",
              "      <td>12</td>\n",
              "      <td>2718</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>3493</td>\n",
              "      <td>32</td>\n",
              "      <td>6</td>\n",
              "      <td>8959</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4565</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3192</td>\n",
              "      <td>29</td>\n",
              "      <td>74</td>\n",
              "      <td>2852</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3764</td>\n",
              "      <td>71</td>\n",
              "      <td>22</td>\n",
              "      <td>2768</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3816</td>\n",
              "      <td>28</td>\n",
              "      <td>35</td>\n",
              "      <td>5734</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>817</td>\n",
              "      <td>65</td>\n",
              "      <td>34</td>\n",
              "      <td>2131</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>385</td>\n",
              "      <td>49</td>\n",
              "      <td>62</td>\n",
              "      <td>1815</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2642</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4100</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3371</td>\n",
              "      <td>53</td>\n",
              "      <td>24</td>\n",
              "      <td>7946</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3577</td>\n",
              "      <td>70</td>\n",
              "      <td>71</td>\n",
              "      <td>8847</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Mezov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>2742</td>\n",
              "      <td>28</td>\n",
              "      <td>19</td>\n",
              "      <td>7115</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2644</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2785</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-96aec6b6-9477-4880-a65f-eaebaa4d7290')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-96aec6b6-9477-4880-a65f-eaebaa4d7290 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-96aec6b6-9477-4880-a65f-eaebaa4d7290');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ],
      "source": [
        "df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "sRNheVzVcD63"
      },
      "outputs": [],
      "source": [
        "#surname    - Фамилия клиента\n",
        "#name       - Имя клиента\n",
        "#tarif      - Тариф клиента\n",
        "#balance\t- Баланс клиента\n",
        "#age\t    - Возраст клиента\n",
        "#sms\t    - Количество отправленных СМС\n",
        "#voice\t    - Количество секунд разговора (звонки)\n",
        "#city\t    - Город клиента\n",
        "#phone      - Марка телефона клиента"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ozztuySqcD63"
      },
      "source": [
        "## Ответы на вопросы загрузите на степик"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "IP9-dtr9cD63"
      },
      "source": [
        "### Вопрос 1: определите средний возраст клиента"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "zN5AlNyYcD63",
        "outputId": "ab162cdf-3030-434a-e067-bf6f57cc50e9"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "48.6"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ],
      "source": [
        "df.age.mean()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-HdRl0ptcD64"
      },
      "source": [
        "### Вопрос 2: на каком тарифе средний возраст клиента наименьший"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 29,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "mXUPKM1pcD64",
        "outputId": "3631c243-4586-4ec2-fb1b-cb3aa716a224"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Всё за 250 (архив)'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 29
        }
      ],
      "source": [
        "df.groupby('tarif').age.mean().idxmin()\n",
        "# df.groupby('tarif').age.mean()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "68Sq4voGcD64"
      },
      "source": [
        "### Вопрос 3: с какого города больше всего клиентов?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "D1to04EwcD64",
        "outputId": "9ea0ccb8-774c-4e1b-d077-f37e4fb2ad14"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Moscow'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 6
        }
      ],
      "source": [
        "df.city.value_counts().idxmax()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8tpgRaLvcD64"
      },
      "source": [
        "### Вопрос 4: на каком тарифе отправили больше всего СМС?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "naKLfNYkcD64",
        "outputId": "1f9fb77b-2744-48c5-d03a-5229185023e5"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Всё за 800'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 7
        }
      ],
      "source": [
        "df.groupby('tarif').sms.sum().idxmax()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8jiOPuKHcD64"
      },
      "source": [
        "### Вопрос 5: определите самую популярную марку смартфона у пользователей до 40 (включительно)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "Srj8Bmf-cD64",
        "outputId": "0306bf1e-f9f6-4ecc-dcb0-a1d9613fbca6"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   surname     name               tarif  balance  age  sms  voice  \\\n",
              "0    Girev   Andrey                 ВИП     2815   29   58   6358   \n",
              "1    Bykin     Stas          Все за 300     3634   37   78    602   \n",
              "10  Smolov     Stas               Промо     1991   28   67   5016   \n",
              "13  Ivanov   Sergey               Промо     3394   39   12   2718   \n",
              "14  Smolov   Sergey  Всё за 250 (архив)     3493   32    6   8959   \n",
              "16  Vlasov   Andrey          Всё за 800     3192   29   74   2852   \n",
              "18  Vlasov   Sergey          Всё за 800     3816   28   35   5734   \n",
              "21   Bykin     Igor          Всё за 500     2642   38   11   3787   \n",
              "26   Mezov  Nikolay  Всё за 250 (архив)     2742   28   19   7115   \n",
              "28  Vlasov   Andrey          Всё за 500     4725   26   93   9441   \n",
              "\n",
              "           city    phone  \n",
              "0        Moscow   Xiaomi  \n",
              "1         Kazan  Samsung  \n",
              "10        Kazan   Xiaomi  \n",
              "13      Yakutsk   Xiaomi  \n",
              "14      Yakutsk   Huawei  \n",
              "16      Yakutsk   Xiaomi  \n",
              "18  Vladivostok    Apple  \n",
              "21       Moscow   Xiaomi  \n",
              "26      Yakutsk   Huawei  \n",
              "28  Vladivostok   Xiaomi  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9554d57b-3e4d-4439-aca8-a147a6a6b61f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>2815</td>\n",
              "      <td>29</td>\n",
              "      <td>58</td>\n",
              "      <td>6358</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3634</td>\n",
              "      <td>37</td>\n",
              "      <td>78</td>\n",
              "      <td>602</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Промо</td>\n",
              "      <td>1991</td>\n",
              "      <td>28</td>\n",
              "      <td>67</td>\n",
              "      <td>5016</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Промо</td>\n",
              "      <td>3394</td>\n",
              "      <td>39</td>\n",
              "      <td>12</td>\n",
              "      <td>2718</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>3493</td>\n",
              "      <td>32</td>\n",
              "      <td>6</td>\n",
              "      <td>8959</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3192</td>\n",
              "      <td>29</td>\n",
              "      <td>74</td>\n",
              "      <td>2852</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3816</td>\n",
              "      <td>28</td>\n",
              "      <td>35</td>\n",
              "      <td>5734</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2642</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Mezov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>2742</td>\n",
              "      <td>28</td>\n",
              "      <td>19</td>\n",
              "      <td>7115</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9554d57b-3e4d-4439-aca8-a147a6a6b61f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9554d57b-3e4d-4439-aca8-a147a6a6b61f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9554d57b-3e4d-4439-aca8-a147a6a6b61f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ],
      "source": [
        "df2 = df[df['age'] <= 40]\n",
        "df2"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df2.groupby('phone').phone.count().sort_values(ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xMQgTVRudonl",
        "outputId": "f89540c7-4555-43a1-9e2c-ec8e8b45e2ad"
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "phone\n",
              "Xiaomi     6\n",
              "Huawei     2\n",
              "Apple      1\n",
              "Samsung    1\n",
              "Name: phone, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yoMlVyWqcD64"
      },
      "source": [
        "### Вопрос 6: определите самую популярную марку смартфона у пользователей старше 40"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 677
        },
        "id": "AK6Vk8IOcD65",
        "outputId": "b0c2c82c-f6f5-4616-8a20-fb63d38f05f9"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name          tarif  balance  age  sms  voice         city  \\\n",
              "2    Ivanov     Alex     Всё за 800      410   47   81   3582       Moscow   \n",
              "3   Andreev   Sergey     Всё за 500     1981   75   98   5442        Kazan   \n",
              "4     Girev     Stas     Всё за 800     4969   43   61   8510       Moscow   \n",
              "5     Bykin   Andrey     Всё за 500     4308   49   39   2525       Moscow   \n",
              "6    Kozlov     Igor     Всё за 800      300   60   31   8543      Yakutsk   \n",
              "7     Girev     Alex          Промо     4199   47   90   3925        Kazan   \n",
              "8    Petrov  Nikolay            ВИП     4810   72   88   7188       Moscow   \n",
              "9   Andreev   Sergey     Всё за 800     4118   52   53    419      Yakutsk   \n",
              "11    Girev     Igor  Корпоративный     1430   69   19   9520      Yakutsk   \n",
              "12   Kozlov   Andrey  Корпоративный      113   71   82   2785        Kazan   \n",
              "15   Kozlov     Stas     Всё за 800     4565   59   82   3168       Moscow   \n",
              "17   Smolov     Alex  Корпоративный     3764   71   22   2768       Moscow   \n",
              "19    Bykin     Alex          Промо      817   65   34   2131  Vladivostok   \n",
              "20  Andreev  Nikolay     Всё за 500      385   49   62   1815        Kazan   \n",
              "22    Girev   Sergey     Все за 300     4230   62   68   5512  Vladivostok   \n",
              "23    Bykin   Sergey     Всё за 800     4100   48   39    227       Moscow   \n",
              "24    Girev     Stas     Все за 300     3371   53   24   7946        Kazan   \n",
              "25   Smolov   Sergey  Корпоративный     3577   70   71   8847      Yakutsk   \n",
              "27   Smolov     Stas     Всё за 500     2644   41   33   8341       Moscow   \n",
              "29   Ivanov  Nikolay     Всё за 500     2785   41    5   2901       Moscow   \n",
              "\n",
              "      phone  \n",
              "2    Huawei  \n",
              "3     Apple  \n",
              "4   Samsung  \n",
              "5    Xiaomi  \n",
              "6   Samsung  \n",
              "7     Apple  \n",
              "8     Apple  \n",
              "9     Apple  \n",
              "11  Samsung  \n",
              "12    Apple  \n",
              "15    Apple  \n",
              "17   Huawei  \n",
              "19  Samsung  \n",
              "20   Xiaomi  \n",
              "22  Samsung  \n",
              "23   Xiaomi  \n",
              "24    Apple  \n",
              "25   Huawei  \n",
              "27   Xiaomi  \n",
              "29  Samsung  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ddc13840-96f4-4bdc-b362-f62b9a3d804a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>410</td>\n",
              "      <td>47</td>\n",
              "      <td>81</td>\n",
              "      <td>3582</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>1981</td>\n",
              "      <td>75</td>\n",
              "      <td>98</td>\n",
              "      <td>5442</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4969</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>300</td>\n",
              "      <td>60</td>\n",
              "      <td>31</td>\n",
              "      <td>8543</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4810</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>1430</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>9520</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>113</td>\n",
              "      <td>71</td>\n",
              "      <td>82</td>\n",
              "      <td>2785</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4565</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3764</td>\n",
              "      <td>71</td>\n",
              "      <td>22</td>\n",
              "      <td>2768</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>817</td>\n",
              "      <td>65</td>\n",
              "      <td>34</td>\n",
              "      <td>2131</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>385</td>\n",
              "      <td>49</td>\n",
              "      <td>62</td>\n",
              "      <td>1815</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4100</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3371</td>\n",
              "      <td>53</td>\n",
              "      <td>24</td>\n",
              "      <td>7946</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3577</td>\n",
              "      <td>70</td>\n",
              "      <td>71</td>\n",
              "      <td>8847</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2644</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2785</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ddc13840-96f4-4bdc-b362-f62b9a3d804a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ddc13840-96f4-4bdc-b362-f62b9a3d804a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ddc13840-96f4-4bdc-b362-f62b9a3d804a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ],
      "source": [
        "df2 = df[df['age'] >= 40]\n",
        "df2"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df2.groupby('phone').phone.count().sort_values(ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "u8RRsxE_dzPL",
        "outputId": "71dbedb9-307c-45c2-c91d-cb1488412be7"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "phone\n",
              "Apple      7\n",
              "Samsung    6\n",
              "Xiaomi     4\n",
              "Huawei     3\n",
              "Name: phone, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QrfS7SEQcD65"
      },
      "source": [
        "### Вопрос 7: В каком городе клиенты меньше всего отправляют СМС"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "xGaim75XcD65",
        "outputId": "08bdda69-141a-4ce3-c4f1-ba38ff08b896"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Vladivostok'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 14
        }
      ],
      "source": [
        "df.groupby('city').sms.sum().idxmin()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# import pandas as pd\n",
        "\n",
        "# data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],\n",
        "#         'Age': [25, 30, 35, 40],\n",
        "#         'Salary': [50000, 60000, 70000, 80000]}\n",
        "\n",
        "# df = pd.DataFrame(data)\n",
        "\n",
        "# max_salary_index = df['Salary'].idxmax()\n",
        "# print(max_salary_index)\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7GVwni52eXCN",
        "outputId": "24963a20-f8a6-49a2-e045-788e3ec5c075"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "3\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "_KYyb9aHecAC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "IFLzLRVIcD65"
      },
      "source": [
        "### Вопрос 8: В каком городе клиенты больше всего говорят по телефону?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "NJW2w746cD65",
        "outputId": "3b0b491c-53da-4d77-9534-deb2e38975a3"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Moscow'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 17
        }
      ],
      "source": [
        "df2.groupby('city').voice.sum().idxmax()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tY31HxO4cD65"
      },
      "source": [
        "### Вопрос 9: Сколько заработала фирма на СМС сообщениях? Стоимость одного сообщения 3 рубля."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 24,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1hdupv1kcD65",
        "outputId": "454ece89-c7ad-49a3-ec16-1b9f3fbb8699"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "4605"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ],
      "source": [
        "df.sms.sum()*3"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 332
        },
        "id": "h7pSRj45cD66",
        "outputId": "9d4aed2a-c605-46c0-ded3-f300689ad79f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name       tarif  balance  age  sms  voice         city  \\\n",
              "4     Girev     Stas  Всё за 800     4969   43   61   8510       Moscow   \n",
              "5     Bykin   Andrey  Всё за 500     4308   49   39   2525       Moscow   \n",
              "7     Girev     Alex       Промо     4199   47   90   3925        Kazan   \n",
              "8    Petrov  Nikolay         ВИП     4810   72   88   7188       Moscow   \n",
              "9   Andreev   Sergey  Всё за 800     4118   52   53    419      Yakutsk   \n",
              "15   Kozlov     Stas  Всё за 800     4565   59   82   3168       Moscow   \n",
              "22    Girev   Sergey  Все за 300     4230   62   68   5512  Vladivostok   \n",
              "23    Bykin   Sergey  Всё за 800     4100   48   39    227       Moscow   \n",
              "28   Vlasov   Andrey  Всё за 500     4725   26   93   9441  Vladivostok   \n",
              "\n",
              "      phone  \n",
              "4   Samsung  \n",
              "5    Xiaomi  \n",
              "7     Apple  \n",
              "8     Apple  \n",
              "9     Apple  \n",
              "15    Apple  \n",
              "22  Samsung  \n",
              "23   Xiaomi  \n",
              "28   Xiaomi  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5fe529c9-328f-488b-83a2-3d73757382eb\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4969</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4810</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4565</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4100</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5fe529c9-328f-488b-83a2-3d73757382eb')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5fe529c9-328f-488b-83a2-3d73757382eb button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5fe529c9-328f-488b-83a2-3d73757382eb');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ],
      "source": [
        "df.loc[df['balance'] > 4000]"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df.loc[df['balance'] > 4000])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ppQXOnhFfQEv",
        "outputId": "2f394492-39e1-4e00-ced2-15763e61e420"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "9"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df.loc[df['balance'] > 4000]) / len(df) * 100"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ao8Oya42fT7j",
        "outputId": "27daaa13-813f-4605-f365-95c184eafda6"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "30.0"
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "pQg884gPcD66"
      },
      "outputs": [],
      "source": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ivqQ1xlkcD66"
      },
      "source": [
        "### Вопрос 12: Определите процент клиентов, у которых баланс выше 2000 и тариф 'Всё за 500'"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 30,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "yYEBvFdrcD66",
        "outputId": "0ded468d-d286-41d3-be81-4c9d61250def"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   surname     name       tarif  balance  age  sms  voice         city  \\\n",
              "5    Bykin   Andrey  Всё за 500     4308   49   39   2525       Moscow   \n",
              "21   Bykin     Igor  Всё за 500     2642   38   11   3787       Moscow   \n",
              "27  Smolov     Stas  Всё за 500     2644   41   33   8341       Moscow   \n",
              "28  Vlasov   Andrey  Всё за 500     4725   26   93   9441  Vladivostok   \n",
              "29  Ivanov  Nikolay  Всё за 500     2785   41    5   2901       Moscow   \n",
              "\n",
              "      phone  \n",
              "5    Xiaomi  \n",
              "21   Xiaomi  \n",
              "27   Xiaomi  \n",
              "28   Xiaomi  \n",
              "29  Samsung  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5a7da33e-6327-405e-be44-68aa15144bcd\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2642</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2644</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2785</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5a7da33e-6327-405e-be44-68aa15144bcd')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5a7da33e-6327-405e-be44-68aa15144bcd button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5a7da33e-6327-405e-be44-68aa15144bcd');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ],
      "source": [
        "cl = df.loc[(df['balance'] > 2000) & (df['tarif'] == 'Всё за 500')]\n",
        "cl"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "np.floor(len(cl) / len(df) * 100)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IKd0s3rgpGzT",
        "outputId": "d8de31d4-dd5f-45b5-a88d-0e44e4bcc8a0"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "16.0"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "59Fp4mb9cD66"
      },
      "source": [
        "### Вопрос 13: Сколько клиентов из Москвы, у которых баланс выше 1500 и марка телефона 'Apple'?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 33,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "C4iC8rnvcD66",
        "outputId": "31852ee5-b6c2-49fa-cfea-855a6c9bc3da"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ],
      "source": [
        "len(df.loc[(df['city'] == 'Moscow') & (df['balance'] > 1500) & (df['phone'] == 'Apple')])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "p31C1thycD67"
      },
      "source": [
        "### Вопрос 14: Самое распространённое имя среди наших клиентов?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 34,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "62bw7yl5cD67",
        "outputId": "2dde05c3-4b4b-4c5b-8f4e-f40d8f55ff2c"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'Sergey'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 34
        }
      ],
      "source": [
        "df.groupby('name').surname.count().idxmax()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "z8VZS5CbcD67"
      },
      "source": [
        "### Вопрос 15: Определите процент клиентов у которых телефон Apple и они из Владивостока"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 35,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Hrpc3rI4cD67",
        "outputId": "1d826486-e312-4523-cb8c-35d934834b12"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "3.0"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ],
      "source": [
        "np.floor(len(df[(df['phone']=='Apple') & (df['city'] == 'Vladivostok')]) / len(df)*100)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['client_name'] = df['surname'] +' '+ df['name']\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 990
        },
        "id": "DFx3ASmJsETh",
        "outputId": "3a44e5dc-b55b-4d88-9dd6-ffd9517b6e26"
      },
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name               tarif  balance  age  sms  voice  \\\n",
              "0     Girev   Andrey                 ВИП     2815   29   58   6358   \n",
              "1     Bykin     Stas          Все за 300     3634   37   78    602   \n",
              "2    Ivanov     Alex          Всё за 800      410   47   81   3582   \n",
              "3   Andreev   Sergey          Всё за 500     1981   75   98   5442   \n",
              "4     Girev     Stas          Всё за 800     4969   43   61   8510   \n",
              "5     Bykin   Andrey          Всё за 500     4308   49   39   2525   \n",
              "6    Kozlov     Igor          Всё за 800      300   60   31   8543   \n",
              "7     Girev     Alex               Промо     4199   47   90   3925   \n",
              "8    Petrov  Nikolay                 ВИП     4810   72   88   7188   \n",
              "9   Andreev   Sergey          Всё за 800     4118   52   53    419   \n",
              "10   Smolov     Stas               Промо     1991   28   67   5016   \n",
              "11    Girev     Igor       Корпоративный     1430   69   19   9520   \n",
              "12   Kozlov   Andrey       Корпоративный      113   71   82   2785   \n",
              "13   Ivanov   Sergey               Промо     3394   39   12   2718   \n",
              "14   Smolov   Sergey  Всё за 250 (архив)     3493   32    6   8959   \n",
              "15   Kozlov     Stas          Всё за 800     4565   59   82   3168   \n",
              "16   Vlasov   Andrey          Всё за 800     3192   29   74   2852   \n",
              "17   Smolov     Alex       Корпоративный     3764   71   22   2768   \n",
              "18   Vlasov   Sergey          Всё за 800     3816   28   35   5734   \n",
              "19    Bykin     Alex               Промо      817   65   34   2131   \n",
              "20  Andreev  Nikolay          Всё за 500      385   49   62   1815   \n",
              "21    Bykin     Igor          Всё за 500     2642   38   11   3787   \n",
              "22    Girev   Sergey          Все за 300     4230   62   68   5512   \n",
              "23    Bykin   Sergey          Всё за 800     4100   48   39    227   \n",
              "24    Girev     Stas          Все за 300     3371   53   24   7946   \n",
              "25   Smolov   Sergey       Корпоративный     3577   70   71   8847   \n",
              "26    Mezov  Nikolay  Всё за 250 (архив)     2742   28   19   7115   \n",
              "27   Smolov     Stas          Всё за 500     2644   41   33   8341   \n",
              "28   Vlasov   Andrey          Всё за 500     4725   26   93   9441   \n",
              "29   Ivanov  Nikolay          Всё за 500     2785   41    5   2901   \n",
              "\n",
              "           city    phone      client_name  \n",
              "0        Moscow   Xiaomi     Girev Andrey  \n",
              "1         Kazan  Samsung       Bykin Stas  \n",
              "2        Moscow   Huawei      Ivanov Alex  \n",
              "3         Kazan    Apple   Andreev Sergey  \n",
              "4        Moscow  Samsung       Girev Stas  \n",
              "5        Moscow   Xiaomi     Bykin Andrey  \n",
              "6       Yakutsk  Samsung      Kozlov Igor  \n",
              "7         Kazan    Apple       Girev Alex  \n",
              "8        Moscow    Apple   Petrov Nikolay  \n",
              "9       Yakutsk    Apple   Andreev Sergey  \n",
              "10        Kazan   Xiaomi      Smolov Stas  \n",
              "11      Yakutsk  Samsung       Girev Igor  \n",
              "12        Kazan    Apple    Kozlov Andrey  \n",
              "13      Yakutsk   Xiaomi    Ivanov Sergey  \n",
              "14      Yakutsk   Huawei    Smolov Sergey  \n",
              "15       Moscow    Apple      Kozlov Stas  \n",
              "16      Yakutsk   Xiaomi    Vlasov Andrey  \n",
              "17       Moscow   Huawei      Smolov Alex  \n",
              "18  Vladivostok    Apple    Vlasov Sergey  \n",
              "19  Vladivostok  Samsung       Bykin Alex  \n",
              "20        Kazan   Xiaomi  Andreev Nikolay  \n",
              "21       Moscow   Xiaomi       Bykin Igor  \n",
              "22  Vladivostok  Samsung     Girev Sergey  \n",
              "23       Moscow   Xiaomi     Bykin Sergey  \n",
              "24        Kazan    Apple       Girev Stas  \n",
              "25      Yakutsk   Huawei    Smolov Sergey  \n",
              "26      Yakutsk   Huawei    Mezov Nikolay  \n",
              "27       Moscow   Xiaomi      Smolov Stas  \n",
              "28  Vladivostok   Xiaomi    Vlasov Andrey  \n",
              "29       Moscow  Samsung   Ivanov Nikolay  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-38ae1f27-cfcd-4ee5-824e-7b83476b5447\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "      <th>client_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>2815</td>\n",
              "      <td>29</td>\n",
              "      <td>58</td>\n",
              "      <td>6358</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Girev Andrey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3634</td>\n",
              "      <td>37</td>\n",
              "      <td>78</td>\n",
              "      <td>602</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>410</td>\n",
              "      <td>47</td>\n",
              "      <td>81</td>\n",
              "      <td>3582</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Ivanov Alex</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>1981</td>\n",
              "      <td>75</td>\n",
              "      <td>98</td>\n",
              "      <td>5442</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4969</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Andrey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>300</td>\n",
              "      <td>60</td>\n",
              "      <td>31</td>\n",
              "      <td>8543</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Kozlov Igor</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Alex</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4810</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Petrov Nikolay</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Промо</td>\n",
              "      <td>1991</td>\n",
              "      <td>28</td>\n",
              "      <td>67</td>\n",
              "      <td>5016</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>1430</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>9520</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Igor</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>113</td>\n",
              "      <td>71</td>\n",
              "      <td>82</td>\n",
              "      <td>2785</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Andrey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Промо</td>\n",
              "      <td>3394</td>\n",
              "      <td>39</td>\n",
              "      <td>12</td>\n",
              "      <td>2718</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Ivanov Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>3493</td>\n",
              "      <td>32</td>\n",
              "      <td>6</td>\n",
              "      <td>8959</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4565</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3192</td>\n",
              "      <td>29</td>\n",
              "      <td>74</td>\n",
              "      <td>2852</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3764</td>\n",
              "      <td>71</td>\n",
              "      <td>22</td>\n",
              "      <td>2768</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Alex</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3816</td>\n",
              "      <td>28</td>\n",
              "      <td>35</td>\n",
              "      <td>5734</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Vlasov Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>817</td>\n",
              "      <td>65</td>\n",
              "      <td>34</td>\n",
              "      <td>2131</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Alex</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>385</td>\n",
              "      <td>49</td>\n",
              "      <td>62</td>\n",
              "      <td>1815</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Andreev Nikolay</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2642</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Igor</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4100</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3371</td>\n",
              "      <td>53</td>\n",
              "      <td>24</td>\n",
              "      <td>7946</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3577</td>\n",
              "      <td>70</td>\n",
              "      <td>71</td>\n",
              "      <td>8847</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Mezov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>2742</td>\n",
              "      <td>28</td>\n",
              "      <td>19</td>\n",
              "      <td>7115</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Mezov Nikolay</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2644</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2785</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Ivanov Nikolay</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-38ae1f27-cfcd-4ee5-824e-7b83476b5447')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-38ae1f27-cfcd-4ee5-824e-7b83476b5447 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-38ae1f27-cfcd-4ee5-824e-7b83476b5447');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['group'] = np.where(df['age'] <= 25, 'A',\n",
        "                       np.where(df['age'] > 40, 'C', 'B'))\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 990
        },
        "id": "C1Re-6sfsGFr",
        "outputId": "b8b77c29-0b37-4ee8-ec7e-351ff01ea4f2"
      },
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name               tarif  balance  age  sms  voice  \\\n",
              "0     Girev   Andrey                 ВИП     2815   29   58   6358   \n",
              "1     Bykin     Stas          Все за 300     3634   37   78    602   \n",
              "2    Ivanov     Alex          Всё за 800      410   47   81   3582   \n",
              "3   Andreev   Sergey          Всё за 500     1981   75   98   5442   \n",
              "4     Girev     Stas          Всё за 800     4969   43   61   8510   \n",
              "5     Bykin   Andrey          Всё за 500     4308   49   39   2525   \n",
              "6    Kozlov     Igor          Всё за 800      300   60   31   8543   \n",
              "7     Girev     Alex               Промо     4199   47   90   3925   \n",
              "8    Petrov  Nikolay                 ВИП     4810   72   88   7188   \n",
              "9   Andreev   Sergey          Всё за 800     4118   52   53    419   \n",
              "10   Smolov     Stas               Промо     1991   28   67   5016   \n",
              "11    Girev     Igor       Корпоративный     1430   69   19   9520   \n",
              "12   Kozlov   Andrey       Корпоративный      113   71   82   2785   \n",
              "13   Ivanov   Sergey               Промо     3394   39   12   2718   \n",
              "14   Smolov   Sergey  Всё за 250 (архив)     3493   32    6   8959   \n",
              "15   Kozlov     Stas          Всё за 800     4565   59   82   3168   \n",
              "16   Vlasov   Andrey          Всё за 800     3192   29   74   2852   \n",
              "17   Smolov     Alex       Корпоративный     3764   71   22   2768   \n",
              "18   Vlasov   Sergey          Всё за 800     3816   28   35   5734   \n",
              "19    Bykin     Alex               Промо      817   65   34   2131   \n",
              "20  Andreev  Nikolay          Всё за 500      385   49   62   1815   \n",
              "21    Bykin     Igor          Всё за 500     2642   38   11   3787   \n",
              "22    Girev   Sergey          Все за 300     4230   62   68   5512   \n",
              "23    Bykin   Sergey          Всё за 800     4100   48   39    227   \n",
              "24    Girev     Stas          Все за 300     3371   53   24   7946   \n",
              "25   Smolov   Sergey       Корпоративный     3577   70   71   8847   \n",
              "26    Mezov  Nikolay  Всё за 250 (архив)     2742   28   19   7115   \n",
              "27   Smolov     Stas          Всё за 500     2644   41   33   8341   \n",
              "28   Vlasov   Andrey          Всё за 500     4725   26   93   9441   \n",
              "29   Ivanov  Nikolay          Всё за 500     2785   41    5   2901   \n",
              "\n",
              "           city    phone      client_name group  \n",
              "0        Moscow   Xiaomi     Girev Andrey     B  \n",
              "1         Kazan  Samsung       Bykin Stas     B  \n",
              "2        Moscow   Huawei      Ivanov Alex     C  \n",
              "3         Kazan    Apple   Andreev Sergey     C  \n",
              "4        Moscow  Samsung       Girev Stas     C  \n",
              "5        Moscow   Xiaomi     Bykin Andrey     C  \n",
              "6       Yakutsk  Samsung      Kozlov Igor     C  \n",
              "7         Kazan    Apple       Girev Alex     C  \n",
              "8        Moscow    Apple   Petrov Nikolay     C  \n",
              "9       Yakutsk    Apple   Andreev Sergey     C  \n",
              "10        Kazan   Xiaomi      Smolov Stas     B  \n",
              "11      Yakutsk  Samsung       Girev Igor     C  \n",
              "12        Kazan    Apple    Kozlov Andrey     C  \n",
              "13      Yakutsk   Xiaomi    Ivanov Sergey     B  \n",
              "14      Yakutsk   Huawei    Smolov Sergey     B  \n",
              "15       Moscow    Apple      Kozlov Stas     C  \n",
              "16      Yakutsk   Xiaomi    Vlasov Andrey     B  \n",
              "17       Moscow   Huawei      Smolov Alex     C  \n",
              "18  Vladivostok    Apple    Vlasov Sergey     B  \n",
              "19  Vladivostok  Samsung       Bykin Alex     C  \n",
              "20        Kazan   Xiaomi  Andreev Nikolay     C  \n",
              "21       Moscow   Xiaomi       Bykin Igor     B  \n",
              "22  Vladivostok  Samsung     Girev Sergey     C  \n",
              "23       Moscow   Xiaomi     Bykin Sergey     C  \n",
              "24        Kazan    Apple       Girev Stas     C  \n",
              "25      Yakutsk   Huawei    Smolov Sergey     C  \n",
              "26      Yakutsk   Huawei    Mezov Nikolay     B  \n",
              "27       Moscow   Xiaomi      Smolov Stas     C  \n",
              "28  Vladivostok   Xiaomi    Vlasov Andrey     B  \n",
              "29       Moscow  Samsung   Ivanov Nikolay     C  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7cffc817-890d-4e25-9a53-36b87a366d05\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "      <th>client_name</th>\n",
              "      <th>group</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>2815</td>\n",
              "      <td>29</td>\n",
              "      <td>58</td>\n",
              "      <td>6358</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Girev Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3634</td>\n",
              "      <td>37</td>\n",
              "      <td>78</td>\n",
              "      <td>602</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Stas</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>410</td>\n",
              "      <td>47</td>\n",
              "      <td>81</td>\n",
              "      <td>3582</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Ivanov Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>1981</td>\n",
              "      <td>75</td>\n",
              "      <td>98</td>\n",
              "      <td>5442</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4969</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4308</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Andrey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>300</td>\n",
              "      <td>60</td>\n",
              "      <td>31</td>\n",
              "      <td>8543</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Kozlov Igor</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4810</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Petrov Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Промо</td>\n",
              "      <td>1991</td>\n",
              "      <td>28</td>\n",
              "      <td>67</td>\n",
              "      <td>5016</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>1430</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>9520</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Igor</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>113</td>\n",
              "      <td>71</td>\n",
              "      <td>82</td>\n",
              "      <td>2785</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Andrey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Промо</td>\n",
              "      <td>3394</td>\n",
              "      <td>39</td>\n",
              "      <td>12</td>\n",
              "      <td>2718</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Ivanov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>3493</td>\n",
              "      <td>32</td>\n",
              "      <td>6</td>\n",
              "      <td>8959</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4565</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3192</td>\n",
              "      <td>29</td>\n",
              "      <td>74</td>\n",
              "      <td>2852</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3764</td>\n",
              "      <td>71</td>\n",
              "      <td>22</td>\n",
              "      <td>2768</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3816</td>\n",
              "      <td>28</td>\n",
              "      <td>35</td>\n",
              "      <td>5734</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Vlasov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>817</td>\n",
              "      <td>65</td>\n",
              "      <td>34</td>\n",
              "      <td>2131</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>385</td>\n",
              "      <td>49</td>\n",
              "      <td>62</td>\n",
              "      <td>1815</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Andreev Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2642</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Igor</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4100</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3371</td>\n",
              "      <td>53</td>\n",
              "      <td>24</td>\n",
              "      <td>7946</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3577</td>\n",
              "      <td>70</td>\n",
              "      <td>71</td>\n",
              "      <td>8847</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Mezov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>2742</td>\n",
              "      <td>28</td>\n",
              "      <td>19</td>\n",
              "      <td>7115</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Mezov Nikolay</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2644</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2785</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Ivanov Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7cffc817-890d-4e25-9a53-36b87a366d05')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7cffc817-890d-4e25-9a53-36b87a366d05 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7cffc817-890d-4e25-9a53-36b87a366d05');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[df['city'] == 'Moscow', ['balance']]=df['balance'] - df['sms'] * 3\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 990
        },
        "id": "47_uf_wO16Ct",
        "outputId": "efea17c2-27c1-495a-9f28-fa151df530e9"
      },
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    surname     name               tarif  balance  age  sms  voice  \\\n",
              "0     Girev   Andrey                 ВИП     2641   29   58   6358   \n",
              "1     Bykin     Stas          Все за 300     3634   37   78    602   \n",
              "2    Ivanov     Alex          Всё за 800      167   47   81   3582   \n",
              "3   Andreev   Sergey          Всё за 500     1981   75   98   5442   \n",
              "4     Girev     Stas          Всё за 800     4786   43   61   8510   \n",
              "5     Bykin   Andrey          Всё за 500     4191   49   39   2525   \n",
              "6    Kozlov     Igor          Всё за 800      300   60   31   8543   \n",
              "7     Girev     Alex               Промо     4199   47   90   3925   \n",
              "8    Petrov  Nikolay                 ВИП     4546   72   88   7188   \n",
              "9   Andreev   Sergey          Всё за 800     4118   52   53    419   \n",
              "10   Smolov     Stas               Промо     1991   28   67   5016   \n",
              "11    Girev     Igor       Корпоративный     1430   69   19   9520   \n",
              "12   Kozlov   Andrey       Корпоративный      113   71   82   2785   \n",
              "13   Ivanov   Sergey               Промо     3394   39   12   2718   \n",
              "14   Smolov   Sergey  Всё за 250 (архив)     3493   32    6   8959   \n",
              "15   Kozlov     Stas          Всё за 800     4319   59   82   3168   \n",
              "16   Vlasov   Andrey          Всё за 800     3192   29   74   2852   \n",
              "17   Smolov     Alex       Корпоративный     3698   71   22   2768   \n",
              "18   Vlasov   Sergey          Всё за 800     3816   28   35   5734   \n",
              "19    Bykin     Alex               Промо      817   65   34   2131   \n",
              "20  Andreev  Nikolay          Всё за 500      385   49   62   1815   \n",
              "21    Bykin     Igor          Всё за 500     2609   38   11   3787   \n",
              "22    Girev   Sergey          Все за 300     4230   62   68   5512   \n",
              "23    Bykin   Sergey          Всё за 800     3983   48   39    227   \n",
              "24    Girev     Stas          Все за 300     3371   53   24   7946   \n",
              "25   Smolov   Sergey       Корпоративный     3577   70   71   8847   \n",
              "26    Mezov  Nikolay  Всё за 250 (архив)     2742   28   19   7115   \n",
              "27   Smolov     Stas          Всё за 500     2545   41   33   8341   \n",
              "28   Vlasov   Andrey          Всё за 500     4725   26   93   9441   \n",
              "29   Ivanov  Nikolay          Всё за 500     2770   41    5   2901   \n",
              "\n",
              "           city    phone      client_name group  \n",
              "0        Moscow   Xiaomi     Girev Andrey     B  \n",
              "1         Kazan  Samsung       Bykin Stas     B  \n",
              "2        Moscow   Huawei      Ivanov Alex     C  \n",
              "3         Kazan    Apple   Andreev Sergey     C  \n",
              "4        Moscow  Samsung       Girev Stas     C  \n",
              "5        Moscow   Xiaomi     Bykin Andrey     C  \n",
              "6       Yakutsk  Samsung      Kozlov Igor     C  \n",
              "7         Kazan    Apple       Girev Alex     C  \n",
              "8        Moscow    Apple   Petrov Nikolay     C  \n",
              "9       Yakutsk    Apple   Andreev Sergey     C  \n",
              "10        Kazan   Xiaomi      Smolov Stas     B  \n",
              "11      Yakutsk  Samsung       Girev Igor     C  \n",
              "12        Kazan    Apple    Kozlov Andrey     C  \n",
              "13      Yakutsk   Xiaomi    Ivanov Sergey     B  \n",
              "14      Yakutsk   Huawei    Smolov Sergey     B  \n",
              "15       Moscow    Apple      Kozlov Stas     C  \n",
              "16      Yakutsk   Xiaomi    Vlasov Andrey     B  \n",
              "17       Moscow   Huawei      Smolov Alex     C  \n",
              "18  Vladivostok    Apple    Vlasov Sergey     B  \n",
              "19  Vladivostok  Samsung       Bykin Alex     C  \n",
              "20        Kazan   Xiaomi  Andreev Nikolay     C  \n",
              "21       Moscow   Xiaomi       Bykin Igor     B  \n",
              "22  Vladivostok  Samsung     Girev Sergey     C  \n",
              "23       Moscow   Xiaomi     Bykin Sergey     C  \n",
              "24        Kazan    Apple       Girev Stas     C  \n",
              "25      Yakutsk   Huawei    Smolov Sergey     C  \n",
              "26      Yakutsk   Huawei    Mezov Nikolay     B  \n",
              "27       Moscow   Xiaomi      Smolov Stas     C  \n",
              "28  Vladivostok   Xiaomi    Vlasov Andrey     B  \n",
              "29       Moscow  Samsung   Ivanov Nikolay     C  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-864607d1-8ecb-4694-a8d5-e4d7ec9acd35\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>surname</th>\n",
              "      <th>name</th>\n",
              "      <th>tarif</th>\n",
              "      <th>balance</th>\n",
              "      <th>age</th>\n",
              "      <th>sms</th>\n",
              "      <th>voice</th>\n",
              "      <th>city</th>\n",
              "      <th>phone</th>\n",
              "      <th>client_name</th>\n",
              "      <th>group</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>2641</td>\n",
              "      <td>29</td>\n",
              "      <td>58</td>\n",
              "      <td>6358</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Girev Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3634</td>\n",
              "      <td>37</td>\n",
              "      <td>78</td>\n",
              "      <td>602</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Stas</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>167</td>\n",
              "      <td>47</td>\n",
              "      <td>81</td>\n",
              "      <td>3582</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Ivanov Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>1981</td>\n",
              "      <td>75</td>\n",
              "      <td>98</td>\n",
              "      <td>5442</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4786</td>\n",
              "      <td>43</td>\n",
              "      <td>61</td>\n",
              "      <td>8510</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4191</td>\n",
              "      <td>49</td>\n",
              "      <td>39</td>\n",
              "      <td>2525</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Andrey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>300</td>\n",
              "      <td>60</td>\n",
              "      <td>31</td>\n",
              "      <td>8543</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Kozlov Igor</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>4199</td>\n",
              "      <td>47</td>\n",
              "      <td>90</td>\n",
              "      <td>3925</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Petrov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>ВИП</td>\n",
              "      <td>4546</td>\n",
              "      <td>72</td>\n",
              "      <td>88</td>\n",
              "      <td>7188</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Petrov Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4118</td>\n",
              "      <td>52</td>\n",
              "      <td>53</td>\n",
              "      <td>419</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Andreev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Промо</td>\n",
              "      <td>1991</td>\n",
              "      <td>28</td>\n",
              "      <td>67</td>\n",
              "      <td>5016</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>1430</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>9520</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Igor</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>113</td>\n",
              "      <td>71</td>\n",
              "      <td>82</td>\n",
              "      <td>2785</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Andrey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Промо</td>\n",
              "      <td>3394</td>\n",
              "      <td>39</td>\n",
              "      <td>12</td>\n",
              "      <td>2718</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Ivanov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>3493</td>\n",
              "      <td>32</td>\n",
              "      <td>6</td>\n",
              "      <td>8959</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Kozlov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>4319</td>\n",
              "      <td>59</td>\n",
              "      <td>82</td>\n",
              "      <td>3168</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Kozlov Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3192</td>\n",
              "      <td>29</td>\n",
              "      <td>74</td>\n",
              "      <td>2852</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3698</td>\n",
              "      <td>71</td>\n",
              "      <td>22</td>\n",
              "      <td>2768</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3816</td>\n",
              "      <td>28</td>\n",
              "      <td>35</td>\n",
              "      <td>5734</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Vlasov Sergey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Alex</td>\n",
              "      <td>Промо</td>\n",
              "      <td>817</td>\n",
              "      <td>65</td>\n",
              "      <td>34</td>\n",
              "      <td>2131</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Bykin Alex</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Andreev</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>385</td>\n",
              "      <td>49</td>\n",
              "      <td>62</td>\n",
              "      <td>1815</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Andreev Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Igor</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2609</td>\n",
              "      <td>38</td>\n",
              "      <td>11</td>\n",
              "      <td>3787</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Igor</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>4230</td>\n",
              "      <td>62</td>\n",
              "      <td>68</td>\n",
              "      <td>5512</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Girev Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Bykin</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Всё за 800</td>\n",
              "      <td>3983</td>\n",
              "      <td>48</td>\n",
              "      <td>39</td>\n",
              "      <td>227</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Bykin Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Girev</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Все за 300</td>\n",
              "      <td>3371</td>\n",
              "      <td>53</td>\n",
              "      <td>24</td>\n",
              "      <td>7946</td>\n",
              "      <td>Kazan</td>\n",
              "      <td>Apple</td>\n",
              "      <td>Girev Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Sergey</td>\n",
              "      <td>Корпоративный</td>\n",
              "      <td>3577</td>\n",
              "      <td>70</td>\n",
              "      <td>71</td>\n",
              "      <td>8847</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Smolov Sergey</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Mezov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 250 (архив)</td>\n",
              "      <td>2742</td>\n",
              "      <td>28</td>\n",
              "      <td>19</td>\n",
              "      <td>7115</td>\n",
              "      <td>Yakutsk</td>\n",
              "      <td>Huawei</td>\n",
              "      <td>Mezov Nikolay</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Smolov</td>\n",
              "      <td>Stas</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2545</td>\n",
              "      <td>41</td>\n",
              "      <td>33</td>\n",
              "      <td>8341</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Smolov Stas</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Vlasov</td>\n",
              "      <td>Andrey</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>4725</td>\n",
              "      <td>26</td>\n",
              "      <td>93</td>\n",
              "      <td>9441</td>\n",
              "      <td>Vladivostok</td>\n",
              "      <td>Xiaomi</td>\n",
              "      <td>Vlasov Andrey</td>\n",
              "      <td>B</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Ivanov</td>\n",
              "      <td>Nikolay</td>\n",
              "      <td>Всё за 500</td>\n",
              "      <td>2770</td>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>2901</td>\n",
              "      <td>Moscow</td>\n",
              "      <td>Samsung</td>\n",
              "      <td>Ivanov Nikolay</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-864607d1-8ecb-4694-a8d5-e4d7ec9acd35')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-864607d1-8ecb-4694-a8d5-e4d7ec9acd35 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-864607d1-8ecb-4694-a8d5-e4d7ec9acd35');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.8.3"
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}