02_adjacency_matrix.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "pd.options.display.max_rows = 100\n",
    "pd.options.display.max_columns = 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "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>Category</th>\n",
       "      <th>Scientific name</th>\n",
       "      <th>Helps</th>\n",
       "      <th>Helped by</th>\n",
       "      <th>Attracts</th>\n",
       "      <th>-Repels/+distracts</th>\n",
       "      <th>Avoid</th>\n",
       "      <th>Comments</th>\n",
       "      <th>combined_name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Common name</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>allium</th>\n",
       "      <td>vegetable</td>\n",
       "      <td>allium</td>\n",
       "      <td>fruit tree,  nightshade,tomato,  capsicum pepp...</td>\n",
       "      <td>carrots,  tomato,  carrots,african spider plan...</td>\n",
       "      <td>thrips</td>\n",
       "      <td>rabbit,  slug,see garlic,  aphid,  carrot fly,...</td>\n",
       "      <td>bean,  pea</td>\n",
       "      <td>allium be a family of plant which include onio...</td>\n",
       "      <td>allium | allium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>asparagus</th>\n",
       "      <td>vegetable</td>\n",
       "      <td>asparagus officinalis</td>\n",
       "      <td>tomato,  parsley</td>\n",
       "      <td>aster family flower,  dill,  coriander,  tomat...</td>\n",
       "      <td>couple with basil seem to encourage lady bug</td>\n",
       "      <td></td>\n",
       "      <td>onion,  garlic,  potato,  gladiolus</td>\n",
       "      <td></td>\n",
       "      <td>asparagus officinalis | asparagus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Category        Scientific name  \\\n",
       "Common name                                     \n",
       "allium       vegetable                 allium   \n",
       "asparagus    vegetable  asparagus officinalis   \n",
       "\n",
       "                                                         Helps  \\\n",
       "Common name                                                      \n",
       "allium       fruit tree,  nightshade,tomato,  capsicum pepp...   \n",
       "asparagus                                     tomato,  parsley   \n",
       "\n",
       "                                                     Helped by  \\\n",
       "Common name                                                      \n",
       "allium       carrots,  tomato,  carrots,african spider plan...   \n",
       "asparagus    aster family flower,  dill,  coriander,  tomat...   \n",
       "\n",
       "                                                 Attracts  \\\n",
       "Common name                                                 \n",
       "allium                                             thrips   \n",
       "asparagus    couple with basil seem to encourage lady bug   \n",
       "\n",
       "                                            -Repels/+distracts  \\\n",
       "Common name                                                      \n",
       "allium       rabbit,  slug,see garlic,  aphid,  carrot fly,...   \n",
       "asparagus                                                        \n",
       "\n",
       "                                           Avoid  \\\n",
       "Common name                                        \n",
       "allium                                bean,  pea   \n",
       "asparagus    onion,  garlic,  potato,  gladiolus   \n",
       "\n",
       "                                                      Comments  \\\n",
       "Common name                                                      \n",
       "allium       allium be a family of plant which include onio...   \n",
       "asparagus                                                        \n",
       "\n",
       "                                 combined_name  \n",
       "Common name                                     \n",
       "allium                         allium | allium  \n",
       "asparagus    asparagus officinalis | asparagus  "
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_data = pd.read_pickle('./01_base_data.pkl')\n",
    "base_data[0:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [],
   "source": [
    "# get pest names\n",
    "nested = [x.split(',') for x in base_data['-Repels/+distracts']]\n",
    "flattened_list = [y.strip() for x in nested for y in x if y != '']\n",
    "pest_names = list(set(flattened_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "am_len = len(base_data) + len(pest_names)\n",
    "index = list(base_data.index) + pest_names\n",
    "index.sort()\n",
    "am = pd.DataFrame(np.zeros(shape=(am_len, am_len)),\n",
    "                  columns=index,\n",
    "                  index=index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in base_data.iterrows():\n",
    "    helps = [x.rstrip().lstrip() for x in row['Helps'].split(',') if x != '']\n",
    "    helped_by = [x.rstrip().lstrip() for x in row['Helped by'].split(',') if x != '']\n",
    "    hurt_by = [x.rstrip().lstrip() for x in row['Avoid'].split(',') if x != '']\n",
    "    \n",
    "    attracts = [x.rstrip().lstrip() for x in row['Attracts'].split(',') if x != '']\n",
    "\n",
    "    repels_and_distracts = [x.rstrip().lstrip() for x in row['-Repels/+distracts'].split(',') if x != '']    \n",
    "    \n",
    "    for x in helps:\n",
    "        if x in am.index:\n",
    "            am.at[index, x] += 1\n",
    "    \n",
    "    for x in helped_by:\n",
    "        if x in am.index:\n",
    "            am.at[x, index] += 1\n",
    "    \n",
    "    for x in hurt_by:\n",
    "        if x in am.index:\n",
    "            am.at[x, index]  -= 1\n",
    "    \n",
    "    for x in repels_and_distracts:\n",
    "        if x in am.index:\n",
    "            am.at[index, x] -= 1\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(156, 156)"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "am.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['alfalfa', 'allium', 'alyssum', 'anise', 'ant', 'aphid', 'apple',\n",
       "       'apricot', 'asparagus', 'asparagus beetle',\n",
       "       ...\n",
       "       'tomato worm', 'turnip', 'various pest', 'walnut tree', 'white fly',\n",
       "       'whitefly', 'wireworm', 'wormwood', 'yarrow', 'zinnia'],\n",
       "      dtype='object', length=156)"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "am.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "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>alfalfa</th>\n",
       "      <th>allium</th>\n",
       "      <th>alyssum</th>\n",
       "      <th>anise</th>\n",
       "      <th>ant</th>\n",
       "      <th>aphid</th>\n",
       "      <th>apple</th>\n",
       "      <th>apricot</th>\n",
       "      <th>asparagus</th>\n",
       "      <th>asparagus beetle</th>\n",
       "      <th>baby 's breath</th>\n",
       "      <th>basil</th>\n",
       "      <th>bean beetle</th>\n",
       "      <th>bean,  bush</th>\n",
       "      <th>bean,  fava</th>\n",
       "      <th>bean,  pole</th>\n",
       "      <th>bee</th>\n",
       "      <th>bee balm</th>\n",
       "      <th>beet</th>\n",
       "      <th>beet leaf hopper</th>\n",
       "      <th>black flea beetle</th>\n",
       "      <th>blueberry</th>\n",
       "      <th>borage</th>\n",
       "      <th>brassicas</th>\n",
       "      <th>broccoli</th>\n",
       "      <th>brussels sprout</th>\n",
       "      <th>butterfly</th>\n",
       "      <th>cabbage</th>\n",
       "      <th>cabbage butterfly</th>\n",
       "      <th>cabbage fly</th>\n",
       "      <th>cabbage looper</th>\n",
       "      <th>cabbage maggot</th>\n",
       "      <th>cabbage moth larvae</th>\n",
       "      <th>cabbage root fly</th>\n",
       "      <th>cabbage weevil</th>\n",
       "      <th>cabbage worm</th>\n",
       "      <th>californian poppy</th>\n",
       "      <th>caraway</th>\n",
       "      <th>carrot fly</th>\n",
       "      <th>carrots</th>\n",
       "      <th>catnip</th>\n",
       "      <th>cauliflower</th>\n",
       "      <th>celery</th>\n",
       "      <th>chamomile</th>\n",
       "      <th>chard</th>\n",
       "      <th>chervil</th>\n",
       "      <th>chive</th>\n",
       "      <th>cilantro / coriander</th>\n",
       "      <th>colorado potato beetle</th>\n",
       "      <th>corn / maize</th>\n",
       "      <th>...</th>\n",
       "      <th>pepper</th>\n",
       "      <th>peppermint</th>\n",
       "      <th>petunia</th>\n",
       "      <th>phacelia</th>\n",
       "      <th>potato</th>\n",
       "      <th>potato beetle</th>\n",
       "      <th>pumpkin</th>\n",
       "      <th>rabbit</th>\n",
       "      <th>raccoon</th>\n",
       "      <th>radish</th>\n",
       "      <th>red spider mite</th>\n",
       "      <th>repel many bean parasite</th>\n",
       "      <th>rise</th>\n",
       "      <th>root - knot nematode</th>\n",
       "      <th>rosemary</th>\n",
       "      <th>rutabegas</th>\n",
       "      <th>sage</th>\n",
       "      <th>see garlic</th>\n",
       "      <th>slug</th>\n",
       "      <th>southernwood</th>\n",
       "      <th>soybean</th>\n",
       "      <th>spearmint</th>\n",
       "      <th>spider mite</th>\n",
       "      <th>spinach</th>\n",
       "      <th>squash</th>\n",
       "      <th>squash bug</th>\n",
       "      <th>sting nettle</th>\n",
       "      <th>strawberry</th>\n",
       "      <th>stripe cucumber beetle</th>\n",
       "      <th>stripe pumpkin beetle</th>\n",
       "      <th>summer savoury</th>\n",
       "      <th>sunflow</th>\n",
       "      <th>swan plant</th>\n",
       "      <th>sweet pea</th>\n",
       "      <th>sweet potato</th>\n",
       "      <th>tansy</th>\n",
       "      <th>tarragon</th>\n",
       "      <th>thrip</th>\n",
       "      <th>thyme</th>\n",
       "      <th>tomato</th>\n",
       "      <th>tomato worm</th>\n",
       "      <th>turnip</th>\n",
       "      <th>various pest</th>\n",
       "      <th>walnut tree</th>\n",
       "      <th>white fly</th>\n",
       "      <th>whitefly</th>\n",
       "      <th>wireworm</th>\n",
       "      <th>wormwood</th>\n",
       "      <th>yarrow</th>\n",
       "      <th>zinnia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>alfalfa</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>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",
       "      <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>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>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>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",
       "      <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>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>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>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>allium</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>-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>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>2.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>-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>-1.0</td>\n",
       "      <td>2.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>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>1.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",
       "      <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>-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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.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>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>alyssum</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>-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>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>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>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>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",
       "      <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>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>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>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>anise</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>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>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>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>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>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",
       "      <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>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>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>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>ant</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>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>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>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>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",
       "      <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>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>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>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",
       "      <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",
       "      <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",
       "      <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",
       "      <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>whitefly</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>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>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>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>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",
       "      <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>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>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>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>wireworm</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>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>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>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>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",
       "      <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>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>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>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>wormwood</th>\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",
       "      <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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.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>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>2.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>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",
       "      <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>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>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>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>yarrow</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>-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>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>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>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>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",
       "      <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>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>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>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>zinnia</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>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>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>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>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>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>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>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>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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>156 rows × 156 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          alfalfa  allium  alyssum  anise  ant  aphid  apple  apricot  \\\n",
       "alfalfa       0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "allium        0.0     0.0      0.0    0.0  0.0   -1.0    0.0      0.0   \n",
       "alyssum       0.0     0.0      0.0    0.0  0.0   -1.0    0.0      0.0   \n",
       "anise         0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "ant           0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "...           ...     ...      ...    ...  ...    ...    ...      ...   \n",
       "whitefly      0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "wireworm      0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "wormwood      0.0     0.0      0.0    0.0 -1.0    0.0    0.0      0.0   \n",
       "yarrow        0.0     0.0      0.0    0.0  0.0   -1.0    0.0      0.0   \n",
       "zinnia        0.0     0.0      0.0    0.0  0.0    0.0    0.0      0.0   \n",
       "\n",
       "          asparagus  asparagus beetle  baby 's breath  basil  bean beetle  \\\n",
       "alfalfa         0.0               0.0             0.0    0.0          0.0   \n",
       "allium          0.0               0.0             0.0    0.0          0.0   \n",
       "alyssum         0.0               0.0             0.0    0.0          0.0   \n",
       "anise           0.0               0.0             0.0    1.0          0.0   \n",
       "ant             0.0               0.0             0.0    0.0          0.0   \n",
       "...             ...               ...             ...    ...          ...   \n",
       "whitefly        0.0               0.0             0.0    0.0          0.0   \n",
       "wireworm        0.0               0.0             0.0    0.0          0.0   \n",
       "wormwood        0.0               0.0             0.0    0.0          0.0   \n",
       "yarrow          0.0               0.0             0.0    0.0          0.0   \n",
       "zinnia          0.0               0.0             0.0    0.0          0.0   \n",
       "\n",
       "          bean,  bush  bean,  fava  bean,  pole  bee  bee balm  beet  \\\n",
       "alfalfa          -1.0          0.0          0.0  0.0       0.0   0.0   \n",
       "allium            0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "alyssum           0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "anise             0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "ant               0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "...               ...          ...          ...  ...       ...   ...   \n",
       "whitefly          0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "wireworm          0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "wormwood          0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "yarrow            0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "zinnia            0.0          0.0          0.0  0.0       0.0   0.0   \n",
       "\n",
       "          beet leaf hopper  black flea beetle  blueberry  borage  brassicas  \\\n",
       "alfalfa                0.0                0.0        0.0     0.0        0.0   \n",
       "allium                 0.0                0.0        0.0     0.0        2.0   \n",
       "alyssum                0.0                0.0        0.0     0.0        0.0   \n",
       "anise                  0.0                0.0        0.0     0.0        0.0   \n",
       "ant                    0.0                0.0        0.0     0.0        0.0   \n",
       "...                    ...                ...        ...     ...        ...   \n",
       "whitefly               0.0                0.0        0.0     0.0        0.0   \n",
       "wireworm               0.0                0.0        0.0     0.0        0.0   \n",
       "wormwood               0.0                0.0        0.0     0.0        2.0   \n",
       "yarrow                 0.0                0.0        1.0     0.0        0.0   \n",
       "zinnia                 0.0                0.0        0.0     0.0        0.0   \n",
       "\n",
       "          broccoli  brussels sprout  butterfly  cabbage  cabbage butterfly  \\\n",
       "alfalfa        0.0              0.0        0.0      0.0                0.0   \n",
       "allium         0.0              0.0        0.0      0.0                0.0   \n",
       "alyssum        0.0              0.0        0.0      0.0                0.0   \n",
       "anise          0.0              0.0        0.0      0.0                0.0   \n",
       "ant            0.0              0.0        0.0      0.0                0.0   \n",
       "...            ...              ...        ...      ...                ...   \n",
       "whitefly       0.0              0.0        0.0      0.0                0.0   \n",
       "wireworm       0.0              0.0        0.0      0.0                0.0   \n",
       "wormwood       0.0              0.0        0.0      0.0                0.0   \n",
       "yarrow         0.0              0.0        0.0      0.0                0.0   \n",
       "zinnia         0.0              0.0        0.0      0.0                0.0   \n",
       "\n",
       "          cabbage fly  cabbage looper  cabbage maggot  cabbage moth larvae  \\\n",
       "alfalfa           0.0             0.0             0.0                  0.0   \n",
       "allium            0.0            -1.0            -1.0                  0.0   \n",
       "alyssum           0.0             0.0             0.0                  0.0   \n",
       "anise             0.0             0.0             0.0                  0.0   \n",
       "ant               0.0             0.0             0.0                  0.0   \n",
       "...               ...             ...             ...                  ...   \n",
       "whitefly          0.0             0.0             0.0                  0.0   \n",
       "wireworm          0.0             0.0             0.0                  0.0   \n",
       "wormwood          0.0             0.0             0.0                  0.0   \n",
       "yarrow            0.0             0.0             0.0                  0.0   \n",
       "zinnia            0.0             0.0             0.0                  0.0   \n",
       "\n",
       "          cabbage root fly  cabbage weevil  cabbage worm  californian poppy  \\\n",
       "alfalfa                0.0             0.0           0.0                0.0   \n",
       "allium                 0.0             0.0          -1.0                0.0   \n",
       "alyssum                0.0             0.0           0.0                0.0   \n",
       "anise                  0.0             0.0           0.0                0.0   \n",
       "ant                    0.0             0.0           0.0                0.0   \n",
       "...                    ...             ...           ...                ...   \n",
       "whitefly               0.0             0.0           0.0                0.0   \n",
       "wireworm               0.0             0.0           0.0                0.0   \n",
       "wormwood               0.0             0.0           0.0                0.0   \n",
       "yarrow                 0.0             0.0           0.0                0.0   \n",
       "zinnia                 0.0             0.0           0.0                0.0   \n",
       "\n",
       "          caraway  carrot fly  carrots  catnip  cauliflower  celery  \\\n",
       "alfalfa       0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "allium        0.0        -1.0      2.0     0.0          0.0     0.0   \n",
       "alyssum       0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "anise         0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "ant           0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "...           ...         ...      ...     ...          ...     ...   \n",
       "whitefly      0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "wireworm      0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "wormwood      0.0         0.0      2.0     0.0          0.0     0.0   \n",
       "yarrow        0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "zinnia        0.0         0.0      0.0     0.0          0.0     0.0   \n",
       "\n",
       "          chamomile  chard  chervil  chive  cilantro / coriander  \\\n",
       "alfalfa         0.0    0.0      0.0    0.0                   0.0   \n",
       "allium          0.0    0.0      0.0    0.0                   0.0   \n",
       "alyssum         0.0    0.0      0.0    0.0                   0.0   \n",
       "anise           0.0    0.0      0.0    0.0                   0.0   \n",
       "ant             0.0    0.0      0.0    0.0                   0.0   \n",
       "...             ...    ...      ...    ...                   ...   \n",
       "whitefly        0.0    0.0      0.0    0.0                   0.0   \n",
       "wireworm        0.0    0.0      0.0    0.0                   0.0   \n",
       "wormwood        0.0    0.0      0.0    0.0                   0.0   \n",
       "yarrow          0.0    0.0      0.0    0.0                   0.0   \n",
       "zinnia          0.0    0.0      0.0    0.0                   0.0   \n",
       "\n",
       "          colorado potato beetle  corn / maize  ...  pepper  peppermint  \\\n",
       "alfalfa                      0.0           0.0  ...     0.0         0.0   \n",
       "allium                       0.0           0.0  ...     0.0         0.0   \n",
       "alyssum                      0.0           0.0  ...     0.0         0.0   \n",
       "anise                        0.0           0.0  ...     0.0         0.0   \n",
       "ant                          0.0           0.0  ...     0.0         0.0   \n",
       "...                          ...           ...  ...     ...         ...   \n",
       "whitefly                     0.0           0.0  ...     0.0         0.0   \n",
       "wireworm                     0.0           0.0  ...     0.0         0.0   \n",
       "wormwood                     0.0           0.0  ...     0.0         0.0   \n",
       "yarrow                       0.0           0.0  ...     0.0         0.0   \n",
       "zinnia                       0.0           0.0  ...     1.0         0.0   \n",
       "\n",
       "          petunia  phacelia  potato  potato beetle  pumpkin  rabbit  raccoon  \\\n",
       "alfalfa       0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "allium        0.0       0.0     1.0            0.0      0.0    -1.0      0.0   \n",
       "alyssum       0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "anise         0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "ant           0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "...           ...       ...     ...            ...      ...     ...      ...   \n",
       "whitefly      0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "wireworm      0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "wormwood      0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "yarrow        0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "zinnia        0.0       0.0     0.0            0.0      0.0     0.0      0.0   \n",
       "\n",
       "          radish  red spider mite  repel many bean parasite  rise  \\\n",
       "alfalfa      0.0              0.0                       0.0   0.0   \n",
       "allium       0.0              0.0                       0.0   0.0   \n",
       "alyssum      0.0              0.0                       0.0   0.0   \n",
       "anise        0.0              0.0                       0.0   0.0   \n",
       "ant          0.0              0.0                       0.0   0.0   \n",
       "...          ...              ...                       ...   ...   \n",
       "whitefly     0.0              0.0                       0.0   0.0   \n",
       "wireworm     0.0              0.0                       0.0   0.0   \n",
       "wormwood     0.0              0.0                       0.0   0.0   \n",
       "yarrow       0.0              0.0                       0.0   0.0   \n",
       "zinnia       0.0              0.0                       0.0   0.0   \n",
       "\n",
       "          root - knot nematode  rosemary  rutabegas  sage  see garlic  slug  \\\n",
       "alfalfa                    0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "allium                     0.0       0.0        0.0   0.0        -1.0  -1.0   \n",
       "alyssum                    0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "anise                      0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "ant                        0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "...                        ...       ...        ...   ...         ...   ...   \n",
       "whitefly                   0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "wireworm                   0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "wormwood                   0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "yarrow                     0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "zinnia                     0.0       0.0        0.0   0.0         0.0   0.0   \n",
       "\n",
       "          southernwood  soybean  spearmint  spider mite  spinach  squash  \\\n",
       "alfalfa            0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "allium             0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "alyssum            0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "anise              0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "ant                0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "...                ...      ...        ...          ...      ...     ...   \n",
       "whitefly           0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "wireworm           0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "wormwood           0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "yarrow             0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "zinnia             0.0      0.0        0.0          0.0      0.0     0.0   \n",
       "\n",
       "          squash bug  sting nettle  strawberry  stripe cucumber beetle  \\\n",
       "alfalfa          0.0           0.0         0.0                     0.0   \n",
       "allium           0.0           0.0         0.0                     0.0   \n",
       "alyssum          0.0           0.0         0.0                     0.0   \n",
       "anise            0.0           0.0         0.0                     0.0   \n",
       "ant              0.0           0.0         0.0                     0.0   \n",
       "...              ...           ...         ...                     ...   \n",
       "whitefly         0.0           0.0         0.0                     0.0   \n",
       "wireworm         0.0           0.0         0.0                     0.0   \n",
       "wormwood         0.0           0.0         0.0                     0.0   \n",
       "yarrow           0.0           0.0         0.0                     0.0   \n",
       "zinnia           0.0           0.0         0.0                     0.0   \n",
       "\n",
       "          stripe pumpkin beetle  summer savoury  sunflow  swan plant  \\\n",
       "alfalfa                     0.0             0.0      0.0         0.0   \n",
       "allium                      0.0             0.0      0.0         0.0   \n",
       "alyssum                     0.0             0.0      0.0         0.0   \n",
       "anise                       0.0             0.0      0.0         0.0   \n",
       "ant                         0.0             0.0      0.0         0.0   \n",
       "...                         ...             ...      ...         ...   \n",
       "whitefly                    0.0             0.0      0.0         0.0   \n",
       "wireworm                    0.0             0.0      0.0         0.0   \n",
       "wormwood                    0.0             0.0      0.0         0.0   \n",
       "yarrow                      0.0             0.0      0.0         0.0   \n",
       "zinnia                      0.0             0.0      0.0         0.0   \n",
       "\n",
       "          sweet pea  sweet potato  tansy  tarragon  thrip  thyme  tomato  \\\n",
       "alfalfa         0.0           0.0    0.0       0.0    0.0    0.0    -1.0   \n",
       "allium          0.0           0.0    0.0       0.0    0.0    0.0     2.0   \n",
       "alyssum         0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "anise           0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "ant             0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "...             ...           ...    ...       ...    ...    ...     ...   \n",
       "whitefly        0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "wireworm        0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "wormwood        0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "yarrow          0.0           0.0    0.0       0.0    0.0    0.0     0.0   \n",
       "zinnia          0.0           0.0    0.0       0.0    0.0    0.0     1.0   \n",
       "\n",
       "          tomato worm  turnip  various pest  walnut tree  white fly  whitefly  \\\n",
       "alfalfa           0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "allium            0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "alyssum           0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "anise             0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "ant               0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "...               ...     ...           ...          ...        ...       ...   \n",
       "whitefly          0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "wireworm          0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "wormwood          0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "yarrow            0.0     0.0           0.0          0.0        0.0       0.0   \n",
       "zinnia            0.0     0.0           0.0          0.0        0.0      -1.0   \n",
       "\n",
       "          wireworm  wormwood  yarrow  zinnia  \n",
       "alfalfa        0.0       0.0     0.0     0.0  \n",
       "allium         0.0       0.0     0.0     0.0  \n",
       "alyssum        0.0       0.0     0.0     0.0  \n",
       "anise          0.0       0.0     0.0     0.0  \n",
       "ant            0.0       0.0     0.0     0.0  \n",
       "...            ...       ...     ...     ...  \n",
       "whitefly       0.0       0.0     0.0     0.0  \n",
       "wireworm       0.0       0.0     0.0     0.0  \n",
       "wormwood       0.0       0.0     0.0     0.0  \n",
       "yarrow         0.0       0.0     0.0     0.0  \n",
       "zinnia         0.0       0.0     0.0     0.0  \n",
       "\n",
       "[156 rows x 156 columns]"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "am"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "def affects_growth(common_plant_name):\n",
    "    return am[common_plant_name][am[common_plant_name]!=0.0]\n",
    "\n",
    "def growth_affected_by(common_plant_name):\n",
    "    return am.loc[common_plant_name][am.loc[common_plant_name] != 0.0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'carrots': 3.0,\n",
       " 'marigold': 2.0,\n",
       " 'pansy': 1.0,\n",
       " 'pea': -1.0,\n",
       " 'peppermint': 1.0,\n",
       " 'spearmint': 1.0,\n",
       " 'tomato': 1.0}"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "affects_growth('allium').to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'aphid': -1.0,\n",
       " 'brassicas': 2.0,\n",
       " 'cabbage looper': -1.0,\n",
       " 'cabbage maggot': -1.0,\n",
       " 'cabbage worm': -1.0,\n",
       " 'carrot fly': -1.0,\n",
       " 'carrots': 2.0,\n",
       " 'fruit tree': 2.0,\n",
       " 'japanese beetle': -1.0,\n",
       " 'legumes': -1.0,\n",
       " 'nightshade': 2.0,\n",
       " 'parsley': -1.0,\n",
       " 'potato': 1.0,\n",
       " 'rabbit': -1.0,\n",
       " 'see garlic': -1.0,\n",
       " 'slug': -1.0,\n",
       " 'tomato': 2.0}"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "growth_affected_by('allium').to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ant': -1.0,\n",
       " 'kohlrabi': 2.0,\n",
       " 'legumes': 1.0,\n",
       " 'lettuce': 2.0,\n",
       " 'potato': -1.0,\n",
       " 'raccoon': -1.0}"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "growth_affected_by('cucumber').to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "am.to_pickle('./02_adjacency_matrix.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "plant-guilds",
   "language": "python",
   "name": "plant-guilds"
  },
  "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.0"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}