make_dfs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_unit(un_list):\n",
    "    \"\"\"\n",
    "    Функция формирования названия единиц измерения.\n",
    "        Args:\n",
    "            un_list(list): список слов, \n",
    "            начиная со второго в описании ингредиента\n",
    "            \n",
    "        Returns:\n",
    "            unit(str): название единицы измерения\n",
    "            в именительном падеже единственного числа\n",
    "        \"\"\"\n",
    "    # Словарь замены падежей для единиц измерения ингредиентов\n",
    "    subst={\n",
    "            'туки' : 'тука',\n",
    "            'ожек' : 'ожка',\n",
    "            'ожки' : 'ожка',\n",
    "            'штук' : 'штука',\n",
    "            'чика' : 'чик',\n",
    "            'уска' : 'усок',\n",
    "            'иков' : 'ик',\n",
    "            'кана' : 'кан',\n",
    "            'анки' : 'анка',\n",
    "            'сков' : 'сок',\n",
    "            'ебля' : 'ебель',\n",
    "            'овки' : 'овка',\n",
    "            'блей' : 'бель',\n",
    "            'чков' : 'чок',\n",
    "            'анов' : 'ан',\n",
    "            'овок' : 'овка',\n",
    "            'анок' : 'анка',\n",
    "            'учка' : 'учок',\n",
    "            'овых' : 'овая',\n",
    "            'овые' : 'овая',\n",
    "            'йных' : 'йная',\n",
    "            'йные' : 'йная',\n",
    "            'дэша' : 'дэш',\n",
    "            'очки' : 'очка',\n",
    "            'очек' : 'очка'\n",
    "             }\n",
    "    ul=[]\n",
    "    for word in un_list:\n",
    "        \n",
    "        if len(word)>3:\n",
    "            if word[-4:] in subst.keys():\n",
    "                subst_key = word[-4:]\n",
    "                word = word[:-4]+subst[subst_key]\n",
    "            \n",
    "        ul.append(word)\n",
    "    unit = (' ').join(ul)\n",
    "    return unit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(84144, 11)"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Считываем исходную таблицу рецептов из файла.\n",
    "connections = pd.read_csv('all_recipes.csv')\n",
    "connections.drop_duplicates(inplace=True)\n",
    "connections.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Формируем таблицу ingredient\n",
    "ingredient = pd.DataFrame(columns=['id_ingr', 'name_ingr'])\n",
    "ingredient['name_ingr'] = connections.ingr_name\n",
    "ingredient.drop_duplicates(inplace=True)\n",
    "ingredient.reset_index(inplace=True)\n",
    "ingredient['id_ingr']=ingredient.index\n",
    "ingredient.drop('index', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Заменяем ingr_name в таблице connections на id_ingr из таблицы ingredients\n",
    "mapper = dict(zip(ingredient.name_ingr, ingredient.id_ingr))\n",
    "connections['id_ingr'] = connections.ingr_name.apply(lambda x: mapper[x])\n",
    "connections.drop(['ingr_name'], axis=1, inplace=True)\n",
    "# Формируем столбец id_con в таблице connections из индекса, это будет PK всей db\n",
    "connections['id_con'] = connections.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Разбиваем описание ингредиента на список слов\n",
    "connections['list'] = connections.ingr_qty_unit.str.split(' ')\n",
    "# Формируем столбец begin из первых слов описания ингредиента\n",
    "connections['begin'] = connections.list.apply(lambda x: x[0])\n",
    "# Формируем столбец end из списка остальных слов описания ингредиента\n",
    "connections['end'] = connections.list.apply(lambda x: x[1:])\n",
    "# Заменяем символы дробей в столбце begin из первых слов описания ингредиента\n",
    "connections.begin = connections.begin.str.replace('½','0.5').replace('¼','0.25').replace(\n",
    "    '⅓','0.33').replace('⅔','0.67').replace('¾','0.75').replace(',','.', regex=True)\n",
    "# Формируем признак isalpha - первые слов описания ингредиента состоят из букв\n",
    "connections['isalpha'] = connections.begin.str.isalpha()\n",
    "# Формируем признак unit - названия единиц измерения\n",
    "connections['unit'] = connections['end'].apply(get_unit)\n",
    "# Формируем признак qty - количество ингредиента\n",
    "connections['ingr_qty'] = connections.apply(lambda row : float(row.begin) if row.isalpha==False else 0, axis = 1)\n",
    "# Уточняем признак unit: для текстовых названий единиц измерения используем всю исходную строку\n",
    "connections['unit'] = connections.apply(lambda row: row.ingr_qty_unit if row.ingr_qty==0 else row.unit, axis = 1)\n",
    "# Удаление временных признаков\n",
    "connections.drop(['list', 'begin', 'end', 'isalpha'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Создаем таблицу unit\n",
    "unit = pd.DataFrame(connections.unit.unique(), columns=['name_unit'])\n",
    "unit['id_unit'] = unit.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Заменяем названия ингредиентов в таблице connections на их id\n",
    "mapper = dict(zip(unit.name_unit,unit.id_unit))\n",
    "connections.unit = connections.unit.apply(lambda x: mapper[x])\n",
    "connections.rename(columns = {'unit':'id_unit'}, inplace = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Создаем таблицу recipe\n",
    "recipe = connections.copy(deep=True)\n",
    "recipe = recipe.groupby(by='name_recipe').first().reset_index()\n",
    "# Формируем столбец id_recipe в таблице recipe из индекса\n",
    "recipe['id_recipe'] = recipe.index\n",
    "# Заменяем name_recipe в таблице connections на id_recipe из таблицы recipe\n",
    "mapper = dict(zip(recipe.name_recipe, recipe.id_recipe))\n",
    "connections['id_recipe'] = connections.name_recipe.apply(lambda x: mapper[x])\n",
    "recipe['vegeterian'] = False\n",
    "recipe.drop(['ingr_qty_unit', 'id_unit', 'ingr_qty', 'id_con', 'id_ingr'], axis=1, inplace=True)\n",
    "recipe.rename(columns = {'meal_mode':'meal_type'}, inplace = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "# После создания таблицы recipes удаляем лишние признаки из таблицы set_ingredients\n",
    "connections.drop(['name_recipe', 'portions', 'calories', 'protein', \n",
    "                  'fat', 'carbo', 'text_recipe', 'cuisine', 'meal_mode'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Запись в файлы\n",
    "connections.to_csv('./connections.csv', index=False)\n",
    "recipe.to_csv('./recipe.csv', index=False)\n",
    "unit.to_csv('./unit.csv', index=False)\n",
    "ingredient.to_csv('./ingredient.csv', index=False)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Визуализация таблиц"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "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>ingr_qty_unit</th>\n",
       "      <th>id_ingr</th>\n",
       "      <th>id_con</th>\n",
       "      <th>id_unit</th>\n",
       "      <th>ingr_qty</th>\n",
       "      <th>id_recipe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15531</th>\n",
       "      <td>250 мл</td>\n",
       "      <td>204</td>\n",
       "      <td>15531</td>\n",
       "      <td>12</td>\n",
       "      <td>250.0</td>\n",
       "      <td>986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84033</th>\n",
       "      <td>1 штука</td>\n",
       "      <td>84</td>\n",
       "      <td>84033</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14389</th>\n",
       "      <td>2 зубчика</td>\n",
       "      <td>25</td>\n",
       "      <td>14389</td>\n",
       "      <td>10</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52283</th>\n",
       "      <td>2 чайные ложки</td>\n",
       "      <td>396</td>\n",
       "      <td>52283</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14870</th>\n",
       "      <td>140 мл</td>\n",
       "      <td>44</td>\n",
       "      <td>14870</td>\n",
       "      <td>12</td>\n",
       "      <td>140.0</td>\n",
       "      <td>6441</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ingr_qty_unit  id_ingr  id_con  id_unit  ingr_qty  id_recipe\n",
       "15531          250 мл      204   15531       12     250.0        986\n",
       "84033         1 штука       84   84033        1       1.0       5657\n",
       "14389       2 зубчика       25   14389       10       2.0       3120\n",
       "52283  2 чайные ложки      396   52283        6       2.0       5023\n",
       "14870          140 мл       44   14870       12     140.0       6441"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "connections.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "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>name_recipe</th>\n",
       "      <th>cuisine</th>\n",
       "      <th>meal_type</th>\n",
       "      <th>portions</th>\n",
       "      <th>calories</th>\n",
       "      <th>protein</th>\n",
       "      <th>fat</th>\n",
       "      <th>carbo</th>\n",
       "      <th>text_recipe</th>\n",
       "      <th>id_recipe</th>\n",
       "      <th>vegeterian</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>Китайские весенние роллы с грибами и рисом</td>\n",
       "      <td>Китайская кухня</td>\n",
       "      <td>Основные блюда</td>\n",
       "      <td>4.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Обжарить на оливковом масле чеснок, добавить м...</td>\n",
       "      <td>2601</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4288</th>\n",
       "      <td>Морской жюльен из креветок и мидий</td>\n",
       "      <td>Французская кухня</td>\n",
       "      <td>Закуски</td>\n",
       "      <td>2.0</td>\n",
       "      <td>605.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Перемешать на горячей сковороде сливочное масл...</td>\n",
       "      <td>4288</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3961</th>\n",
       "      <td>Малиновые пряники</td>\n",
       "      <td>Русская кухня</td>\n",
       "      <td>Выпечка и десерты</td>\n",
       "      <td>6.0</td>\n",
       "      <td>475.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Сушеную малину высыпать в блендер и, включив е...</td>\n",
       "      <td>3961</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>Глинтвейн на темном пиве</td>\n",
       "      <td>Европейская кухня</td>\n",
       "      <td>Напитки</td>\n",
       "      <td>4.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Залить в сотейник примерно полторы бутылки тем...</td>\n",
       "      <td>1084</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3728</th>\n",
       "      <td>Ленивые голубцы с томатным соусом</td>\n",
       "      <td>Русская кухня</td>\n",
       "      <td>Основные блюда</td>\n",
       "      <td>6.0</td>\n",
       "      <td>615.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Нарезать капусту тонкой соломкой, лук и морков...</td>\n",
       "      <td>3728</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     name_recipe            cuisine  \\\n",
       "2601  Китайские весенние роллы с грибами и рисом    Китайская кухня   \n",
       "4288          Морской жюльен из креветок и мидий  Французская кухня   \n",
       "3961                           Малиновые пряники      Русская кухня   \n",
       "1084                    Глинтвейн на темном пиве  Европейская кухня   \n",
       "3728           Ленивые голубцы с томатным соусом      Русская кухня   \n",
       "\n",
       "              meal_type  portions  calories  protein   fat  carbo  \\\n",
       "2601     Основные блюда       4.0     336.0     12.0  18.0   31.0   \n",
       "4288            Закуски       2.0     605.0     45.0  41.0   14.0   \n",
       "3961  Выпечка и десерты       6.0     475.0      8.0  19.0   70.0   \n",
       "1084            Напитки       4.0     141.0      2.0   0.0   23.0   \n",
       "3728     Основные блюда       6.0     615.0     21.0  50.0   20.0   \n",
       "\n",
       "                                            text_recipe  id_recipe  vegeterian  \n",
       "2601  Обжарить на оливковом масле чеснок, добавить м...       2601       False  \n",
       "4288  Перемешать на горячей сковороде сливочное масл...       4288       False  \n",
       "3961  Сушеную малину высыпать в блендер и, включив е...       3961       False  \n",
       "1084  Залить в сотейник примерно полторы бутылки тем...       1084       False  \n",
       "3728  Нарезать капусту тонкой соломкой, лук и морков...       3728       False  "
      ]
     },
     "execution_count": 240,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recipe.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "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>name_unit</th>\n",
       "      <th>id_unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>г</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>штука</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>пучок</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>кг</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>банка</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>столовая ложка</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>чайная ложка</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>по вкусу</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>на кончике ножа</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>головка</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>зубчик</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>л</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>мл</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>стакан</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>щепотка</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>стебель</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>веточка</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>кусок</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>дэш</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          name_unit  id_unit\n",
       "0                 г        0\n",
       "1             штука        1\n",
       "2             пучок        2\n",
       "3                кг        3\n",
       "4             банка        4\n",
       "5    столовая ложка        5\n",
       "6      чайная ложка        6\n",
       "7          по вкусу        7\n",
       "8   на кончике ножа        8\n",
       "9           головка        9\n",
       "10           зубчик       10\n",
       "11                л       11\n",
       "12               мл       12\n",
       "13           стакан       13\n",
       "14          щепотка       14\n",
       "15          стебель       15\n",
       "16          веточка       16\n",
       "17            кусок       17\n",
       "18              дэш       18"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "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_ingr</th>\n",
       "      <th>name_ingr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Майонез</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Куриное яйцо</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Зеленый лук</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Куриное филе</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Консервированные шампиньоны</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2597</th>\n",
       "      <td>2597</td>\n",
       "      <td>Хурма королек</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2598</th>\n",
       "      <td>2598</td>\n",
       "      <td>Икра креветки</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2599</th>\n",
       "      <td>2599</td>\n",
       "      <td>Креветочные панцири</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>2600</td>\n",
       "      <td>Говяжий край</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>2601</td>\n",
       "      <td>Маринованные помидоры</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2602 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id_ingr                    name_ingr\n",
       "0           0                      Майонез\n",
       "1           1                 Куриное яйцо\n",
       "2           2                  Зеленый лук\n",
       "3           3                 Куриное филе\n",
       "4           4  Консервированные шампиньоны\n",
       "...       ...                          ...\n",
       "2597     2597                Хурма королек\n",
       "2598     2598                Икра креветки\n",
       "2599     2599          Креветочные панцири\n",
       "2600     2600                 Говяжий край\n",
       "2601     2601        Маринованные помидоры\n",
       "\n",
       "[2602 rows x 2 columns]"
      ]
     },
     "execution_count": 242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ingredient"
   ]
  }
 ],
 "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.10.6"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}