recipes_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "83c08e60-c45e-42df-9a6e-1f27baccde87",
   "metadata": {},
   "source": [
    "# Recipes Analysis\n",
    "\n",
    "This solves the functional problem of maximizing efficiency of systems, by deciding,\n",
    "the output rate of each recipe, after deciding that the preceding ingredients can be provided\n",
    "at exactly a certain rate.\n",
    "\n",
    "Post a recent update, the ingredients changed to having a multi-dimensional relation to a linear one, reportedly.\n",
    "\n",
    "The aim is use some basic 'facts' in order to derive the rest."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "350006ec-c58a-40b1-8e23-b7bd15a95c2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Facts\n",
    "\n",
    "# Assume all rates are in items/min\n",
    "\n",
    "conveyor_speeds = [60, 120, 270, 480, 780] # items/min\n",
    "# belts and lifts have the same semantics\n",
    "\n",
    "# All resources have a cap for miner mk3 at 250%\n",
    "# extraction rate from the miner is capped by conveyor belts\n",
    "# The minables.csv lists the cap\n",
    "# The manufacturables.csv lists the recipes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "1101a8cb-5273-401d-bd2b-89f27c0a4793",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import math\n",
    "import json\n",
    "import pandas\n",
    "manufacturables = pandas.read_csv('res/data/personal_collection/resources/manufacturables.csv')\n",
    "buildings = pandas.read_csv('res/data/personal_collection/buildings/production/production_buildings.csv')\n",
    "minables = pandas.read_csv('res/data/personal_collection/resources/minables.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a7dade3b-0ffa-4dac-9efd-ae973d3aebec",
   "metadata": {},
   "outputs": [],
   "source": [
    "def list_all_materials():\n",
    "    global manufacturables\n",
    "    df = manufacturables\n",
    "    arr = []\n",
    "    arr += df['prod_1'].dropna().tolist()\n",
    "    arr += df['prod_2'].dropna().tolist()\n",
    "    arr += df['ing_1'].dropna().tolist()\n",
    "    arr += df['ing_2'].dropna().tolist()\n",
    "    arr += df['ing_3'].dropna().tolist()\n",
    "    arr += df['ing_4'].dropna().tolist()\n",
    "    arr = set(arr)\n",
    "    return arr\n",
    "# list_all_materials()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "fe48f5a1-1084-4dce-b739-7f7c5c9e9fed",
   "metadata": {},
   "outputs": [],
   "source": [
    "def material_exists(material='adaptive-control-unit'):\n",
    "    if isinstance(file_or_arr, str):\n",
    "        materials_list = list_all_materials()\n",
    "    if material in materials_list:\n",
    "        return True\n",
    "    else:\n",
    "        res = []\n",
    "        for matter in materials_list:\n",
    "            if material in matter:\n",
    "                res.append(matter)\n",
    "        return res\n",
    "# material_exists('oil')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "19d709bd-bf73-4583-a2ab-4fd6123b8389",
   "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</th>\n",
       "      <th>building</th>\n",
       "      <th>prod_1</th>\n",
       "      <th>prod_rate_1</th>\n",
       "      <th>prod_unit_1</th>\n",
       "      <th>prod_2</th>\n",
       "      <th>prod_rate_2</th>\n",
       "      <th>prod_unit_2</th>\n",
       "      <th>ing_1</th>\n",
       "      <th>rate_1</th>\n",
       "      <th>unit_1</th>\n",
       "      <th>ing_2</th>\n",
       "      <th>rate_2</th>\n",
       "      <th>unit_2</th>\n",
       "      <th>ing_3</th>\n",
       "      <th>rate_3</th>\n",
       "      <th>unit_3</th>\n",
       "      <th>ing_4</th>\n",
       "      <th>rate_4</th>\n",
       "      <th>unit_4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>ai limiter</td>\n",
       "      <td>assembler</td>\n",
       "      <td>ai-limiter</td>\n",
       "      <td>5.0</td>\n",
       "      <td>items/min</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>copper-sheet</td>\n",
       "      <td>25.0</td>\n",
       "      <td>items/min</td>\n",
       "      <td>quickwire</td>\n",
       "      <td>100.0</td>\n",
       "      <td>items/min</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          name   building      prod_1  prod_rate_1 prod_unit_1 prod_2  \\\n",
       "41  ai limiter  assembler  ai-limiter          5.0   items/min    NaN   \n",
       "\n",
       "    prod_rate_2 prod_unit_2         ing_1  rate_1     unit_1      ing_2  \\\n",
       "41          NaN         NaN  copper-sheet    25.0  items/min  quickwire   \n",
       "\n",
       "    rate_2     unit_2 ing_3  rate_3 unit_3 ing_4  rate_4 unit_4  \n",
       "41   100.0  items/min   NaN     NaN    NaN   NaN     NaN    NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def query_ingredients(ingredient='ai-limiter'):\n",
    "    global manufacturables\n",
    "    df = manufacturables\n",
    "    arr = []\n",
    "    arr.append(df[df['ing_1'].str.contains(ingredient, na=False)])\n",
    "    arr.append(df[df['ing_2'].str.contains(ingredient, na=False)])\n",
    "    arr.append(df[df['ing_3'].str.contains(ingredient, na=False)])\n",
    "    arr.append(df[df['ing_4'].str.contains(ingredient, na=False)])\n",
    "    return pandas.concat(arr)\n",
    "    \n",
    "def query_products(df, product='ai-limiter'):\n",
    "    arr = []\n",
    "    arr.append(df[df['prod_1'].str.contains(product, na=False)])\n",
    "    arr.append(df[df['prod_2'].str.contains(product, na=False)])\n",
    "    return pandas.concat(arr)\n",
    "query_products(manufacturables, product='ai-limiter')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e6474cc5-a86a-49f2-9e56-4e207877ab28",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_mining_stat(item_name, rate):\n",
    "    global minables, buildings\n",
    "    resp = {\n",
    "        'item' : item_name,\n",
    "        'least_energy' : 1,\n",
    "        'rate' : rate,\n",
    "        'building' : 0,\n",
    "        'machine_count' : 0\n",
    "    }\n",
    "    transforms = {\n",
    "        'miner' : 'miner-mk3',\n",
    "        'resource-well' : 'resource-well-pressurizer'\n",
    "    }\n",
    "    # print(minables[minables['name'] == item_name].iloc[0][1])\n",
    "    minable = minables[(minables['name'] == item_name)]\n",
    "    # print(minable)\n",
    "    building = minable.iloc[0][1]\n",
    "    building = building if building not in transforms.keys() else transforms[building]\n",
    "    resp['building'] = building\n",
    "    single_node_rate = minable.iloc[0][3]\n",
    "    try:\n",
    "        test = minable.iloc[-1][5]\n",
    "        if not pandas.isna(test):\n",
    "            single_node_rate = test\n",
    "        else:\n",
    "            test = minable.iloc[-1][3]\n",
    "            if not pandas.isna(test):\n",
    "                single_node_rate = test\n",
    "    except:\n",
    "        pass\n",
    "    builds = math.ceil(rate / single_node_rate)\n",
    "    resp['machine_count'] = builds\n",
    "    # print(buildings[buildings['name'] == building])\n",
    "    building_df = buildings[buildings['name'] == building]\n",
    "    resp['least_energy'] = int(building_df.iloc[0][4]) * builds\n",
    "    return resp\n",
    "\n",
    "def get_recipe_stats(product, rate, max_ingredients = 4, max_products = 2, visited = [], depth = 5, best_only = True):\n",
    "    global buildings, minables, manufacturables\n",
    "    df = manufacturables\n",
    "    least_energy, best_recipe = 99999, None\n",
    "    recipe_arr = []\n",
    "    resp = {\n",
    "        'item' : product,\n",
    "        'least_energy' : least_energy,\n",
    "        'recipes' : recipe_arr\n",
    "    }\n",
    "    if depth < 0 :\n",
    "        return resp\n",
    "    recipes = query_products(df, product)\n",
    "    for _, row in recipes.iterrows():\n",
    "        if row['name'] in visited:\n",
    "            continue\n",
    "        visited_new = visited + [row['name']]\n",
    "        # print(visited_new)\n",
    "        res = {}\n",
    "        res['name'] = row['name']\n",
    "        res['building'] = row['building']\n",
    "        res['rate'] = float(rate)\n",
    "        prod_ctr = 1\n",
    "        for i in range(1, max_products + 1):\n",
    "            if row['prod_'+str(i)] == product:\n",
    "                prod_ctr = i\n",
    "        res['machine_count'] = math.ceil(rate / row['prod_rate_'+str(prod_ctr)])\n",
    "        building_energy = math.ceil(buildings[buildings['name'] == res['building']].iloc[0][4] * res['machine_count'])\n",
    "        ingredient_energy = 0\n",
    "        res['ingredients'] = []\n",
    "        for i in range(1, max_ingredients + 1):\n",
    "            ingredient = row['ing_'+str(i)]\n",
    "            if ingredient is None or pandas.isna(ingredient):\n",
    "                break\n",
    "            if ingredient in minables['name'].unique():\n",
    "                ingredient = get_mining_stat(ingredient, float(row['rate_'+str(i)]) * res['machine_count'])\n",
    "            else:\n",
    "                ingredient = get_recipe_stats(ingredient, float(row['rate_'+str(i)]) * res['machine_count'], max_ingredients = max_ingredients, max_products = max_products, visited=visited_new, depth=depth - 1, best_only=best_only)\n",
    "            ingredient_energy += ingredient['least_energy']\n",
    "            res['ingredients'].append(ingredient)\n",
    "        energy_cost = ingredient_energy + building_energy\n",
    "        if energy_cost < least_energy:\n",
    "            least_energy = energy_cost\n",
    "            if best_only:\n",
    "                best_recipe = res\n",
    "        if not best_only:\n",
    "            recipe_arr.append(res)\n",
    "    if best_only:\n",
    "        recipe_arr.append(best_recipe)\n",
    "    \n",
    "    if len(resp['recipes']) > 0 :\n",
    "        resp['least_energy'] = least_energy\n",
    "    else:\n",
    "        resp['least_energy'] = 0\n",
    "    return resp\n",
    "\n",
    "def generate_recipe_json(ingredient, rate=60, depth = 5, indent=None, best_only=True, output_dir = os.path.join('output', 'recipes')):\n",
    "    recipe = get_recipe_stats(ingredient, rate, depth=depth, best_only=best_only)\n",
    "    try:\n",
    "        os.makedirs(output_dir)\n",
    "    except:\n",
    "        pass\n",
    "    filepath = os.path.join(output_dir, ingredient+'.json')\n",
    "    fp = open(filepath, 'w')\n",
    "    json.dump(recipe, fp, indent=indent)\n",
    "    fp.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2e23e3ab-674b-43a9-94a1-3c55a0ae314c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# generate_recipe_json('pressure-conversion-cube', depth = 7, indent = 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6ab9b458-05f7-42ad-ba9f-15fa5c63b8c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_ingredient_buildings(ing_dict):\n",
    "    buildings = []\n",
    "    if 'recipes' in ing_dict.keys():\n",
    "        recipe = ing_dict['recipes'][0] # use only the first\n",
    "        current_building = [recipe['building'], recipe['machine_count'], recipe['name'], recipe['rate'] / recipe['machine_count']]\n",
    "        buildings.append(current_building)\n",
    "        if 'ingredients' in recipe.keys():\n",
    "            for ingredient in recipe['ingredients']:\n",
    "                buildings += get_ingredient_buildings(ingredient)\n",
    "    else:\n",
    "        current_building = [ing_dict['building'], ing_dict['machine_count'], ing_dict['item'], ing_dict['rate'] / ing_dict['machine_count']]\n",
    "        buildings.append(current_building)\n",
    "    return buildings\n",
    "        \n",
    "def generate_recipe_buildings_list(ingredient, recipes_loc = os.path.join('output', 'recipes'), output_path = os.path.join('output', 'recipes')):\n",
    "    filepath = os.path.join(recipes_loc, ingredient+'.json')\n",
    "    fp = open(filepath, 'r')\n",
    "    ing_details = json.load(fp)\n",
    "    fp.close()\n",
    "    summary = {'item' : ing_details['item'], 'energy' : ing_details['least_energy'], 'buildings' : get_ingredient_buildings(ing_details)}\n",
    "    filepath = os.path.join(output_path, ingredient+'_buildings.json')\n",
    "    fp = open(filepath, 'w')\n",
    "    json.dump(summary, fp, indent = 2)\n",
    "    fp.close()\n",
    "    return summary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b1b0c31c-8f5d-4c6c-9f3e-849e147db93a",
   "metadata": {},
   "outputs": [],
   "source": [
    "summary = generate_recipe_buildings_list('pressure-conversion-cube')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8257b6cd-d087-4c09-83f9-e08f5d26b189",
   "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>building</th>\n",
       "      <th>recipe</th>\n",
       "      <th>rate</th>\n",
       "      <th>building_count</th>\n",
       "      <th>energy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>assembler</td>\n",
       "      <td>ai limiter</td>\n",
       "      <td>4.583333</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>assembler</td>\n",
       "      <td>alt alternate: alclad casing</td>\n",
       "      <td>110.454545</td>\n",
       "      <td>-110.0</td>\n",
       "      <td>-1650.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>assembler</td>\n",
       "      <td>alt encased industrial pipe</td>\n",
       "      <td>3.966346</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>assembler</td>\n",
       "      <td>alt silicon circuit board</td>\n",
       "      <td>12.272727</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>assembler</td>\n",
       "      <td>alt steeled frame</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>assembler</td>\n",
       "      <td>alt stitched iron plate</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>assembler</td>\n",
       "      <td>pressure conversion cube</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>blender</td>\n",
       "      <td>alt heat-fused frame</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-225.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>blender</td>\n",
       "      <td>nitric acid</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>-30.0</td>\n",
       "      <td>-2250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>constructor</td>\n",
       "      <td>alt caterium wire</td>\n",
       "      <td>107.142857</td>\n",
       "      <td>-107.0</td>\n",
       "      <td>-428.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>constructor</td>\n",
       "      <td>concrete</td>\n",
       "      <td>29.494240</td>\n",
       "      <td>-29.0</td>\n",
       "      <td>-116.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>constructor</td>\n",
       "      <td>copper sheet</td>\n",
       "      <td>19.755136</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>-76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>constructor</td>\n",
       "      <td>iron plate</td>\n",
       "      <td>39.736842</td>\n",
       "      <td>-39.0</td>\n",
       "      <td>-156.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>constructor</td>\n",
       "      <td>quartz crystal</td>\n",
       "      <td>21.710526</td>\n",
       "      <td>-21.0</td>\n",
       "      <td>-84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>constructor</td>\n",
       "      <td>quickwire</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>-60.0</td>\n",
       "      <td>-240.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>constructor</td>\n",
       "      <td>silica</td>\n",
       "      <td>111.300000</td>\n",
       "      <td>-111.0</td>\n",
       "      <td>-444.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>constructor</td>\n",
       "      <td>steel pipe</td>\n",
       "      <td>59.127536</td>\n",
       "      <td>-59.0</td>\n",
       "      <td>-236.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>foundry</td>\n",
       "      <td>alt coke steel ingot</td>\n",
       "      <td>287.878788</td>\n",
       "      <td>3.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>foundry</td>\n",
       "      <td>aluminum ingot</td>\n",
       "      <td>120.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>manufacturer</td>\n",
       "      <td>alt heavy encased frame</td>\n",
       "      <td>2.727273</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>-110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>manufacturer</td>\n",
       "      <td>alt insulated crystal oscillator</td>\n",
       "      <td>1.840909</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-55.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>manufacturer</td>\n",
       "      <td>alt radio control system</td>\n",
       "      <td>4.444444</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>bauxite</td>\n",
       "      <td>913.333333</td>\n",
       "      <td>4.0</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>caterium-ore</td>\n",
       "      <td>585.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>copper-ore</td>\n",
       "      <td>1350.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>iron-ore</td>\n",
       "      <td>1725.000000</td>\n",
       "      <td>8.0</td>\n",
       "      <td>240.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>limestone</td>\n",
       "      <td>915.000000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>miner-mk3</td>\n",
       "      <td>raw-quartz</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>oil-extractor</td>\n",
       "      <td>crude-oil</td>\n",
       "      <td>864.375000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>refinery</td>\n",
       "      <td>alt electrode - aluminum scrap</td>\n",
       "      <td>591.176471</td>\n",
       "      <td>-591.0</td>\n",
       "      <td>-17730.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>refinery</td>\n",
       "      <td>alt heavy oil residue</td>\n",
       "      <td>200.000000</td>\n",
       "      <td>-200.0</td>\n",
       "      <td>-6000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>refinery</td>\n",
       "      <td>alt sloppy alumina</td>\n",
       "      <td>460.384615</td>\n",
       "      <td>-460.0</td>\n",
       "      <td>-13800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>refinery</td>\n",
       "      <td>fuel</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>-40.0</td>\n",
       "      <td>-1200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>refinery</td>\n",
       "      <td>petroleum coke</td>\n",
       "      <td>568.690476</td>\n",
       "      <td>-568.0</td>\n",
       "      <td>-17040.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>refinery</td>\n",
       "      <td>rubber</td>\n",
       "      <td>39.168033</td>\n",
       "      <td>-39.0</td>\n",
       "      <td>-1170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>resource-well-pressurizer</td>\n",
       "      <td>nitrogen-gas</td>\n",
       "      <td>120.000000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>resource-well-pressurizer</td>\n",
       "      <td>water</td>\n",
       "      <td>358.181818</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>smelter</td>\n",
       "      <td>caterium ingot</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>smelter</td>\n",
       "      <td>copper ingot</td>\n",
       "      <td>88.586066</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>smelter</td>\n",
       "      <td>iron ingot</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     building                            recipe         rate  \\\n",
       "0                   assembler                        ai limiter     4.583333   \n",
       "1                   assembler      alt alternate: alclad casing   110.454545   \n",
       "2                   assembler       alt encased industrial pipe     3.966346   \n",
       "3                   assembler         alt silicon circuit board    12.272727   \n",
       "4                   assembler                 alt steeled frame     3.000000   \n",
       "5                   assembler           alt stitched iron plate     5.500000   \n",
       "6                   assembler          pressure conversion cube     1.000000   \n",
       "7                     blender              alt heat-fused frame     3.000000   \n",
       "8                     blender                       nitric acid    30.000000   \n",
       "9                 constructor                 alt caterium wire   107.142857   \n",
       "10                constructor                          concrete    29.494240   \n",
       "11                constructor                      copper sheet    19.755136   \n",
       "12                constructor                        iron plate    39.736842   \n",
       "13                constructor                    quartz crystal    21.710526   \n",
       "14                constructor                         quickwire    60.000000   \n",
       "15                constructor                            silica   111.300000   \n",
       "16                constructor                        steel pipe    59.127536   \n",
       "17                    foundry              alt coke steel ingot   287.878788   \n",
       "18                    foundry                    aluminum ingot   120.000000   \n",
       "19               manufacturer           alt heavy encased frame     2.727273   \n",
       "20               manufacturer  alt insulated crystal oscillator     1.840909   \n",
       "21               manufacturer          alt radio control system     4.444444   \n",
       "22                  miner-mk3                           bauxite   913.333333   \n",
       "23                  miner-mk3                      caterium-ore   585.000000   \n",
       "24                  miner-mk3                        copper-ore  1350.000000   \n",
       "25                  miner-mk3                          iron-ore  1725.000000   \n",
       "26                  miner-mk3                         limestone   915.000000   \n",
       "27                  miner-mk3                        raw-quartz  1500.000000   \n",
       "28              oil-extractor                         crude-oil   864.375000   \n",
       "29                   refinery    alt electrode - aluminum scrap   591.176471   \n",
       "30                   refinery             alt heavy oil residue   200.000000   \n",
       "31                   refinery                alt sloppy alumina   460.384615   \n",
       "32                   refinery                              fuel    40.000000   \n",
       "33                   refinery                    petroleum coke   568.690476   \n",
       "34                   refinery                            rubber    39.168033   \n",
       "35  resource-well-pressurizer                      nitrogen-gas   120.000000   \n",
       "36  resource-well-pressurizer                             water   358.181818   \n",
       "37                    smelter                    caterium ingot    30.000000   \n",
       "38                    smelter                      copper ingot    88.586066   \n",
       "39                    smelter                        iron ingot    60.000000   \n",
       "\n",
       "    building_count   energy  \n",
       "0             -4.0    -60.0  \n",
       "1           -110.0  -1650.0  \n",
       "2             -3.0    -45.0  \n",
       "3            -12.0   -180.0  \n",
       "4             -3.0    -45.0  \n",
       "5             -5.0    -75.0  \n",
       "6             -1.0    -15.0  \n",
       "7             -3.0   -225.0  \n",
       "8            -30.0  -2250.0  \n",
       "9           -107.0   -428.0  \n",
       "10           -29.0   -116.0  \n",
       "11           -19.0    -76.0  \n",
       "12           -39.0   -156.0  \n",
       "13           -21.0    -84.0  \n",
       "14           -60.0   -240.0  \n",
       "15          -111.0   -444.0  \n",
       "16           -59.0   -236.0  \n",
       "17             3.0     48.0  \n",
       "18             1.0     16.0  \n",
       "19            -2.0   -110.0  \n",
       "20            -1.0    -55.0  \n",
       "21            -4.0   -220.0  \n",
       "22             4.0    120.0  \n",
       "23             3.0     90.0  \n",
       "24             6.0    180.0  \n",
       "25             8.0    240.0  \n",
       "26             4.0    120.0  \n",
       "27             7.0    210.0  \n",
       "28            15.0    600.0  \n",
       "29          -591.0 -17730.0  \n",
       "30          -200.0  -6000.0  \n",
       "31          -460.0 -13800.0  \n",
       "32           -40.0  -1200.0  \n",
       "33          -568.0 -17040.0  \n",
       "34           -39.0  -1170.0  \n",
       "35             4.0    600.0  \n",
       "36            12.0   1800.0  \n",
       "37             1.0      4.0  \n",
       "38             2.0      8.0  \n",
       "39             1.0      4.0  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pandas.DataFrame(summary['buildings'], columns=['building', 'count', 'recipe', 'rate'])\n",
    "# df = df[df['building'].isin(['miner-mk3', 'oil-extractor', 'water-extractor', 'resource-well-pressurizer'])]\n",
    "df = df.groupby(['building','recipe'], as_index=False)['rate'].sum()\n",
    "for idx, row in df.iterrows():\n",
    "    bname = row['building']\n",
    "    details = buildings[buildings['name'] == bname].iloc[0]\n",
    "    brate = details.iloc[3]\n",
    "    benergy = details.iloc[4]\n",
    "    if 'resource-well' in bname:\n",
    "        brate = buildings[buildings['name'] == 'resource-well-extractor'].iloc[0][3]\n",
    "        benergy = buildings[buildings['name'] == 'resource-well-pressurizer'].iloc[0][4]\n",
    "    \n",
    "    count = math.ceil(row['rate'] / brate)\n",
    "    df.loc[idx, 'building_count'] = count\n",
    "    df.loc[idx, 'energy'] = count * benergy\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "28c217fb-5855-4002-81c2-06aa93f171c8",
   "metadata": {},
   "source": [
    "## Plant Building\n",
    "\n",
    "The entire automated plant needs to accomodate the following : \n",
    "\n",
    "1. Energy for producing the energy itself\n",
    "2. By-Products of the recipe, and how to handle them\n",
    "\n",
    "This requires extremely expensive algorithms that works with calculating alternatives.\n",
    "Especially for handling the by-products.\n",
    "\n",
    "By-Product handling will require the system to understand what a good base material\n",
    "that can be derived from the by product would be like.\n",
    "\n",
    "It's going to be an exploratory work, which will again require the system to look for recipes for it to build.\n",
    "\n",
    "Only after that completes, can the plant be genuinely considered to be self sustaining."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4d5573f1-12b8-4530-8c49-976e56b87a03",
   "metadata": {},
   "outputs": [],
   "source": [
    "def build_plant_schematics(ingredient, buildings_dir=os.path.join('output', 'recipes'), output_path = os.path.join('output', 'plants')):\n",
    "    filepath = os.path.join(output_path, ingredient+'_buildings.json')\n",
    "    fp = open(filepath, 'r')\n",
    "    ing_details = json.load(fp)\n",
    "    buildings = []\n",
    "    buildings += get_energy_buildings(ing_details['energy'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b0da4b79-4e4a-4c3d-9c06-e77fe3eb32d0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}