final_2_1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Финальный проект karpov.courses: вариант 2\n",
    "#### Задание 1\n",
    "\n",
    "В [файле](https://stepik.org/media/attachments/lesson/409319/test1_completed.csv) содержится информация о покупках людей.\n",
    "\n",
    "\n",
    "- id – означает покупку (в одну покупку входят все товары, купленные пользователем во время 1 похода в магазин)\n",
    "- Товар – наименование товара\n",
    "- Количество – число единиц купленного товара\n",
    "\n",
    "Воспользуйтесь этими данными и выясните, какие пары товаров пользователи чаще всего покупают вместе. По сути, вам необходимо найти паттерны покупок, что позволит оптимизировать размещение продуктов в магазине, для удобства пользователей и увеличения выручки.\n",
    "\n",
    "1_Товар | 2_Товар | Встречаемость\n",
    "--- | --- | ---\n",
    "Чай | Арбуз | 3\n",
    "Арбуз | Сгущёнка | 2\n",
    "Чай | Сгущёнка | 1\n",
    "\n",
    "\n",
    "- 1_Товар – наименование первого товара\n",
    "- 2_Товар – наименование второго товара\n",
    "- Встречаемость – число раз, когда такая пара была встречена\n",
    "\n",
    "Другими словами: 2 раза люди покупали одновременно чай и арбуз, 1 раз одновременно покупали арбуз и сгущёнку и 1 раз одновременно были куплены чай со сгущёнкой.\n",
    "\n",
    "Напишите код на python для получения нужной таблицы и укажите 5 наиболее распространённых паттернов.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "sns.set(style=\"whitegrid\", rc={'figure.figsize':(14,7)})\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>Товар</th>\n",
       "      <th>Количество</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лимон</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лимон оранжевый</td>\n",
       "      <td>0.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лук-порей</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лук репчатый</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17119</td>\n",
       "      <td>Малина свежая</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>17119</td>\n",
       "      <td>Морковь немытая</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17119</td>\n",
       "      <td>Черешня сушеная</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17530</td>\n",
       "      <td>Лимон оранжевый</td>\n",
       "      <td>0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17530</td>\n",
       "      <td>Изюм Султана</td>\n",
       "      <td>0.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17530</td>\n",
       "      <td>Капуста цветная</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id            Товар  Количество\n",
       "0  17119            Лимон        1.10\n",
       "1  17119  Лимон оранжевый        0.70\n",
       "2  17119        Лук-порей       10.00\n",
       "3  17119     Лук репчатый        2.50\n",
       "4  17119    Малина свежая        1.00\n",
       "5  17119  Морковь немытая        1.40\n",
       "6  17119  Черешня сушеная        1.80\n",
       "7  17530  Лимон оранжевый        0.25\n",
       "8  17530     Изюм Султана        0.50\n",
       "9  17530  Капуста цветная        2.00"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# читаем данные\n",
    "df = pd.read_csv('https://stepik.org/media/attachments/lesson/409319/test1_completed.csv')\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-- Shape:\n",
      "(43514, 3)\n",
      "\n",
      "-- Null values:\n",
      "id            0\n",
      "Товар         0\n",
      "Количество    0\n",
      "dtype: int64\n",
      "\n",
      "-- dtypes:\n",
      "id              int64\n",
      "Товар          object\n",
      "Количество    float64\n",
      "dtype: object\n",
      "\n",
      "-- nuinque:\n",
      "id            3273\n",
      "Товар          199\n",
      "Количество     101\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# смотрим размерность, проверяем полноту и типы данных\n",
    "print(\"-- Shape:\")\n",
    "print(df.shape)\n",
    "print(\"\\n-- Null values:\")\n",
    "print(df.isnull().sum())\n",
    "print(\"\\n-- dtypes:\")\n",
    "print(df.dtypes)\n",
    "print(\"\\n-- nuinque:\")\n",
    "print(df.nunique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>Товар</th>\n",
       "      <th>Количество</th>\n",
       "      <th>in_basket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лимон</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лимон оранжевый</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лук-порей</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17119</td>\n",
       "      <td>Лук репчатый</td>\n",
       "      <td>2.5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17119</td>\n",
       "      <td>Малина свежая</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id            Товар  Количество  in_basket\n",
       "0  17119            Лимон         1.1          1\n",
       "1  17119  Лимон оранжевый         0.7          1\n",
       "2  17119        Лук-порей        10.0          1\n",
       "3  17119     Лук репчатый         2.5          1\n",
       "4  17119    Малина свежая         1.0          1"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# для подсчета встречаемости (частотности) нам важен сам факт присутствия товара в корзине\n",
    "# поэтому добавим колонку in_basket по которой и будем считать показтель встречаемости\n",
    "df['in_basket'] = np.where(df['Количество'] > 0 ,1,0) \n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Товар</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <th>Ананас Gold</th>\n",
       "      <th>Ананасовые кольца</th>\n",
       "      <th>Апельсины столовые</th>\n",
       "      <th>Арбуз</th>\n",
       "      <th>Арбуз овальный</th>\n",
       "      <th>...</th>\n",
       "      <th>Яблоки Гала</th>\n",
       "      <th>Яблоки Голден</th>\n",
       "      <th>Яблоки Джонаголд</th>\n",
       "      <th>Яблоки Мутсу</th>\n",
       "      <th>Яблоки Симиренко</th>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <th>Ягоды Годжи</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17119</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17530</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17618</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17724</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17814</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119062</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119110</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119206</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119393</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119396</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3273 rows × 199 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Товар   Абрикос вяленый  Абрикосы молдавские  Авокадо ХАСС  Авокадо стандарт  \\\n",
       "id                                                                             \n",
       "17119               0.0                  0.0           0.0               0.0   \n",
       "17530               0.0                  0.0           0.0               0.0   \n",
       "17618               0.0                  1.0           0.0               0.0   \n",
       "17724               0.0                  1.0           0.0               0.0   \n",
       "17814               0.0                  0.0           0.0               0.0   \n",
       "...                 ...                  ...           ...               ...   \n",
       "119062              0.0                  0.0           0.0               0.0   \n",
       "119110              0.0                  0.0           1.0               0.0   \n",
       "119206              0.0                  0.0           0.0               0.0   \n",
       "119393              0.0                  0.0           0.0               0.0   \n",
       "119396              0.0                  0.0           0.0               0.0   \n",
       "\n",
       "Товар   Алыча вяленая  Ананас Gold  Ананасовые кольца  Апельсины столовые  \\\n",
       "id                                                                          \n",
       "17119             0.0          0.0                0.0                 0.0   \n",
       "17530             0.0          0.0                0.0                 0.0   \n",
       "17618             0.0          0.0                0.0                 1.0   \n",
       "17724             0.0          0.0                0.0                 0.0   \n",
       "17814             0.0          0.0                0.0                 0.0   \n",
       "...               ...          ...                ...                 ...   \n",
       "119062            0.0          0.0                0.0                 0.0   \n",
       "119110            0.0          0.0                0.0                 1.0   \n",
       "119206            0.0          0.0                0.0                 0.0   \n",
       "119393            0.0          0.0                0.0                 0.0   \n",
       "119396            0.0          0.0                0.0                 0.0   \n",
       "\n",
       "Товар   Арбуз  Арбуз овальный  ...  Яблоки Гала  Яблоки Голден  \\\n",
       "id                             ...                               \n",
       "17119     0.0             0.0  ...          0.0            0.0   \n",
       "17530     0.0             0.0  ...          0.0            0.0   \n",
       "17618     0.0             0.0  ...          0.0            0.0   \n",
       "17724     1.0             0.0  ...          1.0            0.0   \n",
       "17814     1.0             0.0  ...          0.0            0.0   \n",
       "...       ...             ...  ...          ...            ...   \n",
       "119062    0.0             0.0  ...          0.0            0.0   \n",
       "119110    0.0             0.0  ...          0.0            0.0   \n",
       "119206    0.0             1.0  ...          0.0            0.0   \n",
       "119393    0.0             0.0  ...          0.0            0.0   \n",
       "119396    0.0             0.0  ...          0.0            0.0   \n",
       "\n",
       "Товар   Яблоки Джонаголд  Яблоки Мутсу  Яблоки Симиренко  Яблоки Фуджи  \\\n",
       "id                                                                       \n",
       "17119                0.0           0.0               0.0           0.0   \n",
       "17530                0.0           0.0               0.0           0.0   \n",
       "17618                0.0           0.0               0.0           0.0   \n",
       "17724                0.0           0.0               1.0           0.0   \n",
       "17814                0.0           0.0               0.0           0.0   \n",
       "...                  ...           ...               ...           ...   \n",
       "119062               0.0           0.0               0.0           0.0   \n",
       "119110               0.0           0.0               0.0           0.0   \n",
       "119206               0.0           0.0               0.0           0.0   \n",
       "119393               0.0           0.0               0.0           1.0   \n",
       "119396               1.0           0.0               0.0           0.0   \n",
       "\n",
       "Товар   Яблоки Чемпион  Яблоки сезонные  Яблоки сушеные  Ягоды Годжи  \n",
       "id                                                                    \n",
       "17119              0.0              0.0             0.0          0.0  \n",
       "17530              0.0              0.0             0.0          0.0  \n",
       "17618              0.0              0.0             0.0          1.0  \n",
       "17724              0.0              0.0             0.0          0.0  \n",
       "17814              0.0              0.0             0.0          0.0  \n",
       "...                ...              ...             ...          ...  \n",
       "119062             0.0              0.0             0.0          0.0  \n",
       "119110             1.0              0.0             0.0          1.0  \n",
       "119206             0.0              0.0             0.0          0.0  \n",
       "119393             0.0              0.0             0.0          0.0  \n",
       "119396             0.0              0.0             0.0          0.0  \n",
       "\n",
       "[3273 rows x 199 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# интуитивно хочется \"повернуть\" таблицу, т.е. сделать pivot\n",
    "# причем можно повернуть так, чтобы строки были товарами, а колонки покупками\n",
    "# или наоборот, строки будет покупками, а колонки товарами\n",
    "df_pivot1 = df.pivot(index='id', columns='Товар', values='in_basket').fillna(0)\n",
    "df_pivot1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>id</th>\n",
       "      <th>17119</th>\n",
       "      <th>17530</th>\n",
       "      <th>17618</th>\n",
       "      <th>17724</th>\n",
       "      <th>17814</th>\n",
       "      <th>17893</th>\n",
       "      <th>17948</th>\n",
       "      <th>17982</th>\n",
       "      <th>18001</th>\n",
       "      <th>18102</th>\n",
       "      <th>...</th>\n",
       "      <th>118398</th>\n",
       "      <th>118403</th>\n",
       "      <th>118737</th>\n",
       "      <th>118849</th>\n",
       "      <th>118918</th>\n",
       "      <th>119062</th>\n",
       "      <th>119110</th>\n",
       "      <th>119206</th>\n",
       "      <th>119393</th>\n",
       "      <th>119396</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Товар</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ягоды Годжи</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199 rows × 3273 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "id                   17119   17530   17618   17724   17814   17893   17948   \\\n",
       "Товар                                                                         \n",
       "Абрикос вяленый         0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Абрикосы молдавские     0.0     0.0     1.0     1.0     0.0     0.0     0.0   \n",
       "Авокадо ХАСС            0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Авокадо стандарт        0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Алыча вяленая           0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "...                     ...     ...     ...     ...     ...     ...     ...   \n",
       "Яблоки Фуджи            0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Яблоки Чемпион          0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Яблоки сезонные         0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Яблоки сушеные          0.0     0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "Ягоды Годжи             0.0     0.0     1.0     0.0     0.0     0.0     0.0   \n",
       "\n",
       "id                   17982   18001   18102   ...  118398  118403  118737  \\\n",
       "Товар                                        ...                           \n",
       "Абрикос вяленый         0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Абрикосы молдавские     0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Авокадо ХАСС            0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Авокадо стандарт        0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Алыча вяленая           0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "...                     ...     ...     ...  ...     ...     ...     ...   \n",
       "Яблоки Фуджи            0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Яблоки Чемпион          0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Яблоки сезонные         0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Яблоки сушеные          0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "Ягоды Годжи             0.0     0.0     0.0  ...     0.0     0.0     0.0   \n",
       "\n",
       "id                   118849  118918  119062  119110  119206  119393  119396  \n",
       "Товар                                                                        \n",
       "Абрикос вяленый         0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "Абрикосы молдавские     0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "Авокадо ХАСС            0.0     0.0     0.0     1.0     0.0     0.0     0.0  \n",
       "Авокадо стандарт        0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "Алыча вяленая           0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "...                     ...     ...     ...     ...     ...     ...     ...  \n",
       "Яблоки Фуджи            0.0     0.0     0.0     0.0     0.0     1.0     0.0  \n",
       "Яблоки Чемпион          0.0     0.0     0.0     1.0     0.0     0.0     0.0  \n",
       "Яблоки сезонные         0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "Яблоки сушеные          0.0     0.0     0.0     0.0     0.0     0.0     0.0  \n",
       "Ягоды Годжи             0.0     0.0     0.0     1.0     0.0     0.0     0.0  \n",
       "\n",
       "[199 rows x 3273 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pivot2 = df.pivot(index='Товар', columns='id', values='in_basket').fillna(0)\n",
    "df_pivot2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Поиск в интернете информации о \"парных покупках\" находит много статей и много алгоритмов\n",
    "\n",
    "Например на Хабре целый обзор алгоритмов с примерами: https://habr.com/ru/company/ods/blog/353502/\n",
    "\n",
    "Чаще других упоминается Алгоритм Apriori. Как я понимаю, для больших объемов данных именно такие оптимизированные алгоритмы и стоило бы рассматривать. \n",
    "\n",
    "Так же попадается статья: https://studme.org/63625/marketing/analiz_svyazi_odnovremenno_priobretaemymi_tovarami\n",
    "В которой показана матрица частот совместных покупок. И это прям очень похоже на две мои таблицы выше. Только надо правильно посчитать пересечения строк и колонок товаров в них."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Товар</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <th>Ананас Gold</th>\n",
       "      <th>Ананасовые кольца</th>\n",
       "      <th>Апельсины столовые</th>\n",
       "      <th>Арбуз</th>\n",
       "      <th>Арбуз овальный</th>\n",
       "      <th>...</th>\n",
       "      <th>Яблоки Гала</th>\n",
       "      <th>Яблоки Голден</th>\n",
       "      <th>Яблоки Джонаголд</th>\n",
       "      <th>Яблоки Мутсу</th>\n",
       "      <th>Яблоки Симиренко</th>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <th>Ягоды Годжи</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Товар</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>111.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <td>20.0</td>\n",
       "      <td>471.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>...</td>\n",
       "      <td>30.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <td>10.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <td>14.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <td>5.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <td>5.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <td>5.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <td>7.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ягоды Годжи</th>\n",
       "      <td>7.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199 rows × 199 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Товар                Абрикос вяленый  Абрикосы молдавские  Авокадо ХАСС  \\\n",
       "Товар                                                                     \n",
       "Абрикос вяленый                111.0                 20.0          10.0   \n",
       "Абрикосы молдавские             20.0                471.0          37.0   \n",
       "Авокадо ХАСС                    10.0                 37.0         227.0   \n",
       "Авокадо стандарт                14.0                 46.0          25.0   \n",
       "Алыча вяленая                    6.0                 23.0           7.0   \n",
       "...                              ...                  ...           ...   \n",
       "Яблоки Фуджи                     5.0                 26.0          19.0   \n",
       "Яблоки Чемпион                   5.0                 27.0          17.0   \n",
       "Яблоки сезонные                  5.0                 23.0          13.0   \n",
       "Яблоки сушеные                   7.0                 18.0          14.0   \n",
       "Ягоды Годжи                      7.0                 29.0          16.0   \n",
       "\n",
       "Товар                Авокадо стандарт  Алыча вяленая  Ананас Gold  \\\n",
       "Товар                                                               \n",
       "Абрикос вяленый                  14.0            6.0          5.0   \n",
       "Абрикосы молдавские              46.0           23.0         23.0   \n",
       "Авокадо ХАСС                     25.0            7.0         15.0   \n",
       "Авокадо стандарт                238.0           14.0         18.0   \n",
       "Алыча вяленая                    14.0          142.0          9.0   \n",
       "...                               ...            ...          ...   \n",
       "Яблоки Фуджи                     17.0            9.0          6.0   \n",
       "Яблоки Чемпион                   18.0            9.0          9.0   \n",
       "Яблоки сезонные                  15.0            9.0         10.0   \n",
       "Яблоки сушеные                    9.0           13.0          5.0   \n",
       "Ягоды Годжи                      18.0            8.0          6.0   \n",
       "\n",
       "Товар                Ананасовые кольца  Апельсины столовые  Арбуз  \\\n",
       "Товар                                                               \n",
       "Абрикос вяленый                    7.0                14.0   42.0   \n",
       "Абрикосы молдавские               19.0                48.0  141.0   \n",
       "Авокадо ХАСС                      18.0                32.0   80.0   \n",
       "Авокадо стандарт                  15.0                31.0   86.0   \n",
       "Алыча вяленая                      9.0                23.0   41.0   \n",
       "...                                ...                 ...    ...   \n",
       "Яблоки Фуджи                       9.0                15.0   48.0   \n",
       "Яблоки Чемпион                     9.0                18.0   41.0   \n",
       "Яблоки сезонные                   12.0                22.0   52.0   \n",
       "Яблоки сушеные                     3.0                 7.0   31.0   \n",
       "Ягоды Годжи                        6.0                15.0   47.0   \n",
       "\n",
       "Товар                Арбуз овальный  ...  Яблоки Гала  Яблоки Голден  \\\n",
       "Товар                                ...                               \n",
       "Абрикос вяленый                 7.0  ...         12.0            4.0   \n",
       "Абрикосы молдавские            37.0  ...         30.0           26.0   \n",
       "Авокадо ХАСС                   16.0  ...         14.0           16.0   \n",
       "Авокадо стандарт               14.0  ...         16.0           20.0   \n",
       "Алыча вяленая                   9.0  ...          9.0            6.0   \n",
       "...                             ...  ...          ...            ...   \n",
       "Яблоки Фуджи                   14.0  ...         11.0           11.0   \n",
       "Яблоки Чемпион                 14.0  ...         13.0           11.0   \n",
       "Яблоки сезонные                10.0  ...         16.0            8.0   \n",
       "Яблоки сушеные                  6.0  ...          5.0            6.0   \n",
       "Ягоды Годжи                     9.0  ...          7.0            8.0   \n",
       "\n",
       "Товар                Яблоки Джонаголд  Яблоки Мутсу  Яблоки Симиренко  \\\n",
       "Товар                                                                   \n",
       "Абрикос вяленый                   9.0           3.0               9.0   \n",
       "Абрикосы молдавские              29.0          23.0              35.0   \n",
       "Авокадо ХАСС                     15.0          14.0              19.0   \n",
       "Авокадо стандарт                 11.0          18.0              16.0   \n",
       "Алыча вяленая                    11.0          10.0               5.0   \n",
       "...                               ...           ...               ...   \n",
       "Яблоки Фуджи                     13.0          13.0              22.0   \n",
       "Яблоки Чемпион                   11.0           7.0              11.0   \n",
       "Яблоки сезонные                   3.0           7.0              10.0   \n",
       "Яблоки сушеные                   10.0           9.0               6.0   \n",
       "Ягоды Годжи                      13.0           6.0              12.0   \n",
       "\n",
       "Товар                Яблоки Фуджи  Яблоки Чемпион  Яблоки сезонные  \\\n",
       "Товар                                                                \n",
       "Абрикос вяленый               5.0             5.0              5.0   \n",
       "Абрикосы молдавские          26.0            27.0             23.0   \n",
       "Авокадо ХАСС                 19.0            17.0             13.0   \n",
       "Авокадо стандарт             17.0            18.0             15.0   \n",
       "Алыча вяленая                 9.0             9.0              9.0   \n",
       "...                           ...             ...              ...   \n",
       "Яблоки Фуджи                156.0            10.0              5.0   \n",
       "Яблоки Чемпион               10.0           144.0             10.0   \n",
       "Яблоки сезонные               5.0            10.0            144.0   \n",
       "Яблоки сушеные               10.0             7.0              8.0   \n",
       "Ягоды Годжи                   8.0            11.0             11.0   \n",
       "\n",
       "Товар                Яблоки сушеные  Ягоды Годжи  \n",
       "Товар                                             \n",
       "Абрикос вяленый                 7.0          7.0  \n",
       "Абрикосы молдавские            18.0         29.0  \n",
       "Авокадо ХАСС                   14.0         16.0  \n",
       "Авокадо стандарт                9.0         18.0  \n",
       "Алыча вяленая                  13.0          8.0  \n",
       "...                             ...          ...  \n",
       "Яблоки Фуджи                   10.0          8.0  \n",
       "Яблоки Чемпион                  7.0         11.0  \n",
       "Яблоки сезонные                 8.0         11.0  \n",
       "Яблоки сушеные                119.0          7.0  \n",
       "Ягоды Годжи                     7.0        160.0  \n",
       "\n",
       "[199 rows x 199 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Начинаю гуглить способ построить матрицу частот по всем колонкам, нахожу такой вариант:\n",
    "# https://stackoverflow.com/questions/56836996/how-can-i-create-frequency-matrix-using-all-columns\n",
    "df_pairs = df_pivot1.T.dot(df_pivot1)\n",
    "df_pairs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Уже по цифрам в таблице вижу что \"это то что надо\", но пока как магия )\n",
    "\n",
    "Начинаю разбираться с транспонированием и перемножением матриц. Нахожу еще хорошую ссылку:\n",
    "https://stackoverflow.com/questions/43374625/finding-pairwise-overlap-in-columns-in-pandas-dataframe\n",
    "Понимаю, что ранспонирование вращает мою таблицу, но как перемножение транспонированых таблиц дает мне суммы пересечений, я так до конца и не понимаю.\n",
    "\n",
    "Другой способ получить матрицу частот:\n",
    "```\n",
    "s=df.reset_index().melt('index').loc[lambda x : x.value==1]\n",
    "s.merge(s,on='index').query('variable_x!=variable_y').groupby(['variable_x','variable_y'])['value_x'].sum().unstack(fill_value=0)\n",
    "```\n",
    "Тоже понимания не добавляет ("
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>Товар</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17119</td>\n",
       "      <td>['Лимон', 'Лимон оранжевый', 'Лук-порей', 'Лук...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17530</td>\n",
       "      <td>['Лимон оранжевый', 'Изюм Султана', 'Капуста ц...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17618</td>\n",
       "      <td>['Абрикосы молдавские', 'Кукуруза мини', 'Гриб...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17724</td>\n",
       "      <td>['Абрикосы молдавские', 'Арбуз', 'Салат Айсбер...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17814</td>\n",
       "      <td>['Арбуз', 'Кабачки', 'Кинза', 'Малина свежая',...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                                              Товар\n",
       "0  17119  ['Лимон', 'Лимон оранжевый', 'Лук-порей', 'Лук...\n",
       "1  17530  ['Лимон оранжевый', 'Изюм Султана', 'Капуста ц...\n",
       "2  17618  ['Абрикосы молдавские', 'Кукуруза мини', 'Гриб...\n",
       "3  17724  ['Абрикосы молдавские', 'Арбуз', 'Салат Айсбер...\n",
       "4  17814  ['Арбуз', 'Кабачки', 'Кинза', 'Малина свежая',..."
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Цифры встречаемости в таблице выше хоть и похожи на нужные, но для уверенности их нужно перепроверить.\n",
    "# Исходную табличку сгруппируем по покупкам и список товаров в каждой покупке преобразуем в строку.\n",
    "# Так проверить \"встречаемость\" будет проще.\n",
    "df_check = df[['id','Товар']] \\\n",
    "    .groupby('id', as_index=False) \\\n",
    "    .agg(lambda x: x.tolist())\n",
    "df_check['Товар'] = df_check['Товар'].astype(str)\n",
    "df_check.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Абрикос вяленый и Алыча вяленая = 6\n",
      "Абрикос вяленый и Ягоды Годжи = 7\n"
     ]
    }
   ],
   "source": [
    "# Теперь проверим пару примеров\n",
    "# \"Абрикос вяленый\" и \"Алыча вяленая\" = должно быть 6 раз\n",
    "# \"Абрикос вяленый\" и \"Ягоды Годжи\" = должно быть 7 раз\n",
    "сheck1 = len(df_check.query('Товар.str.contains(\"Абрикос вяленый\") and Товар.str.contains(\"Алыча вяленая\")'))\n",
    "сheck2 = len(df_check.query('Товар.str.contains(\"Абрикос вяленый\") and Товар.str.contains(\"Ягоды Годжи\")'))\n",
    "print(\"Абрикос вяленый и Алыча вяленая =\", сheck1)\n",
    "print(\"Абрикос вяленый и Ягоды Годжи =\", сheck2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Товар</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <th>Ананас Gold</th>\n",
       "      <th>Ананасовые кольца</th>\n",
       "      <th>Апельсины столовые</th>\n",
       "      <th>Арбуз</th>\n",
       "      <th>Арбуз овальный</th>\n",
       "      <th>...</th>\n",
       "      <th>Яблоки Гала</th>\n",
       "      <th>Яблоки Голден</th>\n",
       "      <th>Яблоки Джонаголд</th>\n",
       "      <th>Яблоки Мутсу</th>\n",
       "      <th>Яблоки Симиренко</th>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <th>Ягоды Годжи</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Товар</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>...</td>\n",
       "      <td>30.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо ХАСС</th>\n",
       "      <td>10.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Авокадо стандарт</th>\n",
       "      <td>14.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Алыча вяленая</th>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <td>5.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <td>5.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <td>5.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <td>7.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ягоды Годжи</th>\n",
       "      <td>7.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199 rows × 199 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Товар                Абрикос вяленый  Абрикосы молдавские  Авокадо ХАСС  \\\n",
       "Товар                                                                     \n",
       "Абрикос вяленый                  0.0                 20.0          10.0   \n",
       "Абрикосы молдавские             20.0                  0.0          37.0   \n",
       "Авокадо ХАСС                    10.0                 37.0           0.0   \n",
       "Авокадо стандарт                14.0                 46.0          25.0   \n",
       "Алыча вяленая                    6.0                 23.0           7.0   \n",
       "...                              ...                  ...           ...   \n",
       "Яблоки Фуджи                     5.0                 26.0          19.0   \n",
       "Яблоки Чемпион                   5.0                 27.0          17.0   \n",
       "Яблоки сезонные                  5.0                 23.0          13.0   \n",
       "Яблоки сушеные                   7.0                 18.0          14.0   \n",
       "Ягоды Годжи                      7.0                 29.0          16.0   \n",
       "\n",
       "Товар                Авокадо стандарт  Алыча вяленая  Ананас Gold  \\\n",
       "Товар                                                               \n",
       "Абрикос вяленый                  14.0            6.0          5.0   \n",
       "Абрикосы молдавские              46.0           23.0         23.0   \n",
       "Авокадо ХАСС                     25.0            7.0         15.0   \n",
       "Авокадо стандарт                  0.0           14.0         18.0   \n",
       "Алыча вяленая                    14.0            0.0          9.0   \n",
       "...                               ...            ...          ...   \n",
       "Яблоки Фуджи                     17.0            9.0          6.0   \n",
       "Яблоки Чемпион                   18.0            9.0          9.0   \n",
       "Яблоки сезонные                  15.0            9.0         10.0   \n",
       "Яблоки сушеные                    9.0           13.0          5.0   \n",
       "Ягоды Годжи                      18.0            8.0          6.0   \n",
       "\n",
       "Товар                Ананасовые кольца  Апельсины столовые  Арбуз  \\\n",
       "Товар                                                               \n",
       "Абрикос вяленый                    7.0                14.0   42.0   \n",
       "Абрикосы молдавские               19.0                48.0  141.0   \n",
       "Авокадо ХАСС                      18.0                32.0   80.0   \n",
       "Авокадо стандарт                  15.0                31.0   86.0   \n",
       "Алыча вяленая                      9.0                23.0   41.0   \n",
       "...                                ...                 ...    ...   \n",
       "Яблоки Фуджи                       9.0                15.0   48.0   \n",
       "Яблоки Чемпион                     9.0                18.0   41.0   \n",
       "Яблоки сезонные                   12.0                22.0   52.0   \n",
       "Яблоки сушеные                     3.0                 7.0   31.0   \n",
       "Ягоды Годжи                        6.0                15.0   47.0   \n",
       "\n",
       "Товар                Арбуз овальный  ...  Яблоки Гала  Яблоки Голден  \\\n",
       "Товар                                ...                               \n",
       "Абрикос вяленый                 7.0  ...         12.0            4.0   \n",
       "Абрикосы молдавские            37.0  ...         30.0           26.0   \n",
       "Авокадо ХАСС                   16.0  ...         14.0           16.0   \n",
       "Авокадо стандарт               14.0  ...         16.0           20.0   \n",
       "Алыча вяленая                   9.0  ...          9.0            6.0   \n",
       "...                             ...  ...          ...            ...   \n",
       "Яблоки Фуджи                   14.0  ...         11.0           11.0   \n",
       "Яблоки Чемпион                 14.0  ...         13.0           11.0   \n",
       "Яблоки сезонные                10.0  ...         16.0            8.0   \n",
       "Яблоки сушеные                  6.0  ...          5.0            6.0   \n",
       "Ягоды Годжи                     9.0  ...          7.0            8.0   \n",
       "\n",
       "Товар                Яблоки Джонаголд  Яблоки Мутсу  Яблоки Симиренко  \\\n",
       "Товар                                                                   \n",
       "Абрикос вяленый                   9.0           3.0               9.0   \n",
       "Абрикосы молдавские              29.0          23.0              35.0   \n",
       "Авокадо ХАСС                     15.0          14.0              19.0   \n",
       "Авокадо стандарт                 11.0          18.0              16.0   \n",
       "Алыча вяленая                    11.0          10.0               5.0   \n",
       "...                               ...           ...               ...   \n",
       "Яблоки Фуджи                     13.0          13.0              22.0   \n",
       "Яблоки Чемпион                   11.0           7.0              11.0   \n",
       "Яблоки сезонные                   3.0           7.0              10.0   \n",
       "Яблоки сушеные                   10.0           9.0               6.0   \n",
       "Ягоды Годжи                      13.0           6.0              12.0   \n",
       "\n",
       "Товар                Яблоки Фуджи  Яблоки Чемпион  Яблоки сезонные  \\\n",
       "Товар                                                                \n",
       "Абрикос вяленый               5.0             5.0              5.0   \n",
       "Абрикосы молдавские          26.0            27.0             23.0   \n",
       "Авокадо ХАСС                 19.0            17.0             13.0   \n",
       "Авокадо стандарт             17.0            18.0             15.0   \n",
       "Алыча вяленая                 9.0             9.0              9.0   \n",
       "...                           ...             ...              ...   \n",
       "Яблоки Фуджи                  0.0            10.0              5.0   \n",
       "Яблоки Чемпион               10.0             0.0             10.0   \n",
       "Яблоки сезонные               5.0            10.0              0.0   \n",
       "Яблоки сушеные               10.0             7.0              8.0   \n",
       "Ягоды Годжи                   8.0            11.0             11.0   \n",
       "\n",
       "Товар                Яблоки сушеные  Ягоды Годжи  \n",
       "Товар                                             \n",
       "Абрикос вяленый                 7.0          7.0  \n",
       "Абрикосы молдавские            18.0         29.0  \n",
       "Авокадо ХАСС                   14.0         16.0  \n",
       "Авокадо стандарт                9.0         18.0  \n",
       "Алыча вяленая                  13.0          8.0  \n",
       "...                             ...          ...  \n",
       "Яблоки Фуджи                   10.0          8.0  \n",
       "Яблоки Чемпион                  7.0         11.0  \n",
       "Яблоки сезонные                 8.0         11.0  \n",
       "Яблоки сушеные                  0.0          7.0  \n",
       "Ягоды Годжи                     7.0          0.0  \n",
       "\n",
       "[199 rows x 199 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# пересечение одинаковых товаров нам не интересны, они наоборот только мешают\n",
    "# поэтому диагональ заполним нулями\n",
    "np.fill_diagonal(df_pairs.to_numpy(), 0)\n",
    "df_pairs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Товар</th>\n",
       "      <th>Товар</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Авокадо ХАСС</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Авокадо стандарт</th>\n",
       "      <th>Абрикос вяленый</th>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Абрикосы молдавские</th>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Ягоды Годжи</th>\n",
       "      <th>Яблоки Симиренко</th>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Фуджи</th>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки Чемпион</th>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сезонные</th>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Яблоки сушеные</th>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19701 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            0\n",
       "Товар               Товар                    \n",
       "Абрикосы молдавские Абрикос вяленый      20.0\n",
       "Авокадо ХАСС        Абрикос вяленый      10.0\n",
       "                    Абрикосы молдавские  37.0\n",
       "Авокадо стандарт    Абрикос вяленый      14.0\n",
       "                    Абрикосы молдавские  46.0\n",
       "...                                       ...\n",
       "Ягоды Годжи         Яблоки Симиренко     12.0\n",
       "                    Яблоки Фуджи          8.0\n",
       "                    Яблоки Чемпион       11.0\n",
       "                    Яблоки сезонные      11.0\n",
       "                    Яблоки сушеные        7.0\n",
       "\n",
       "[19701 rows x 1 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Теперь от этой матрицы частот, нам нужно взять или левую нижнюю часть относительно диагонали или верхнюю правую,\n",
    "# потому что они по сути друг друга дублируют\n",
    "df_final = pd.DataFrame(df_pairs.mask(np.triu(np.ones(df_pairs.shape)).astype(bool)).stack())\n",
    "df_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1_Товар</th>\n",
       "      <th>2_Товар</th>\n",
       "      <th>Встречаемость</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13643</th>\n",
       "      <td>Укроп</td>\n",
       "      <td>Огурцы Луховицкие</td>\n",
       "      <td>431.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13657</th>\n",
       "      <td>Укроп</td>\n",
       "      <td>Петрушка</td>\n",
       "      <td>408.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6336</th>\n",
       "      <td>Огурцы Луховицкие</td>\n",
       "      <td>Арбуз</td>\n",
       "      <td>345.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6383</th>\n",
       "      <td>Огурцы Луховицкие</td>\n",
       "      <td>Кабачки</td>\n",
       "      <td>326.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13597</th>\n",
       "      <td>Укроп</td>\n",
       "      <td>Кинза</td>\n",
       "      <td>303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13618</th>\n",
       "      <td>Укроп</td>\n",
       "      <td>Лук зеленый</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8114</th>\n",
       "      <td>Петрушка</td>\n",
       "      <td>Огурцы Луховицкие</td>\n",
       "      <td>286.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6417</th>\n",
       "      <td>Огурцы Луховицкие</td>\n",
       "      <td>Лук репчатый</td>\n",
       "      <td>285.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>Кабачки</td>\n",
       "      <td>Баклажаны грунтовые</td>\n",
       "      <td>284.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13585</th>\n",
       "      <td>Укроп</td>\n",
       "      <td>Кабачки</td>\n",
       "      <td>281.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 1_Товар              2_Товар  Встречаемость\n",
       "13643              Укроп    Огурцы Луховицкие          431.0\n",
       "13657              Укроп             Петрушка          408.0\n",
       "6336   Огурцы Луховицкие                Арбуз          345.0\n",
       "6383   Огурцы Луховицкие              Кабачки          326.0\n",
       "13597              Укроп                Кинза          303.0\n",
       "13618              Укроп          Лук зеленый          300.0\n",
       "8114            Петрушка    Огурцы Луховицкие          286.0\n",
       "6417   Огурцы Луховицкие         Лук репчатый          285.0\n",
       "1498             Кабачки  Баклажаны грунтовые          284.0\n",
       "13585              Укроп              Кабачки          281.0"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# сбрасываем индексы, переименовываем колонки, сортируем по встречаемости (по убыванию)\n",
    "df_final.reset_index(1) \\\n",
    "    .rename(columns={'Товар':'2_Товар'}) \\\n",
    "    .reset_index() \\\n",
    "    .rename(columns={'Товар':'1_Товар'}) \\\n",
    "    .rename(columns={0:'Встречаемость'}) \\\n",
    "    .sort_values(by='Встречаемость', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Результат вполне логичный:\n",
    "\n",
    "Укроп и Петрушку очень часто покупают совместно.\n",
    "\n",
    "Укроп и огруцы, тоже наверно покупают часто вместе, наприме, для засолки )\n",
    "\n",
    "Немного неожиданно Арбуз в топ 5 паттернов."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}