1010_topic_model.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# topic model\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Document Clustering with Python\n",
    "ref: http://brandonrose.org/clustering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[nltk_data] Downloading package punkt to /Users/zireael/nltk_data...\n",
      "[nltk_data]   Package punkt is already up-to-date!\n"
     ]
    },
    {
     "ename": "EmptyDataError",
     "evalue": "No columns to parse from file",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mEmptyDataError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-1-09f37a7c9c80>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     11\u001b[0m \u001b[0mnltk\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdownload\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'punkt'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     12\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 13\u001b[0;31m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'data/treated_data/TerrestrialReport_lc_ld_mammals.txt'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0msep\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"|\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'unicode'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/usr/local/lib/python3.7/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mparser_f\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)\u001b[0m\n\u001b[1;32m    700\u001b[0m                     skip_blank_lines=skip_blank_lines)\n\u001b[1;32m    701\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 702\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    703\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    704\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.7/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    427\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    428\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 429\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    430\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    431\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.7/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m    893\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'has_index_names'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'has_index_names'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    894\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 895\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    896\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    897\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.7/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, engine)\u001b[0m\n\u001b[1;32m   1120\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'c'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1121\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m'c'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1122\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mCParserWrapper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1123\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1124\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m'python'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.7/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, src, **kwds)\u001b[0m\n\u001b[1;32m   1851\u001b[0m         \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'usecols'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0musecols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1852\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1853\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparsers\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTextReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msrc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1854\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1855\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.__cinit__\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mEmptyDataError\u001b[0m: No columns to parse from file"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "# import nltk\n",
    "import re\n",
    "import os\n",
    "import codecs\n",
    "from sklearn import feature_extraction\n",
    "# import mpld3\n",
    "\n",
    "import nltk\n",
    "nltk.download('punkt')\n",
    "\n",
    "df = pd.read_csv('data/treated_data/TerrestrialReport_lc_ld_mammals.txt',sep=\"|\", dtype='unicode')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from nltk.stem.snowball import SnowballStemmer\n",
    "stemmer = SnowballStemmer(\"english\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CAS Number ',\n",
       " ' Chemical Name',\n",
       " 'Chemical Grade',\n",
       " ' Chemical Purity Mean Op ',\n",
       " ' Chemical Purity Mean(%) ',\n",
       " ' Chemical Purity Min Op ',\n",
       " ' Chemical Purity Min(%) ',\n",
       " ' Chemical Purity Max Op ',\n",
       " ' Chemical Purity Max(%)',\n",
       " 'Species Group',\n",
       " 'Species Scientific Name ',\n",
       " ' Species Common Name',\n",
       " 'Organism Lifestage',\n",
       " ' Organism Age Mean Op ',\n",
       " ' Organism Age Mean ',\n",
       " ' Organism Age Min Op ',\n",
       " ' Organism Age Min ',\n",
       " ' Organism Age Max Op ',\n",
       " ' Organism Age Max ',\n",
       " ' Organism Age Units',\n",
       " 'Media Type',\n",
       " 'Test Location',\n",
       " 'Exposure Type',\n",
       " 'Dose Number',\n",
       " 'Endpoint',\n",
       " 'Effect',\n",
       " 'Effect Measurement',\n",
       " 'Response Site',\n",
       " 'Chemical Analysis Method',\n",
       " 'Conc 1 Type (Author) ',\n",
       " ' Conc 1 Mean Op (Author) ',\n",
       " ' Conc 1 Mean (Author) ',\n",
       " ' Conc 1 Min Op (Author) ',\n",
       " ' Conc Min 1 (Author) ',\n",
       " ' Conc 1 Max Op (Author) ',\n",
       " ' Conc 1 Max (Author) ',\n",
       " ' Conc 1 Units (Author) ',\n",
       " ' Conc 2 Type (Author) ',\n",
       " ' Conc 2 Mean Op (Author) ',\n",
       " ' Conc 2 Mean (Author) ',\n",
       " ' Conc 2 Min Op (Author) ',\n",
       " ' Conc Min 2 (Author) ',\n",
       " ' Conc 2 Max Op (Author) ',\n",
       " ' Conc 2 Max (Author) ',\n",
       " ' Conc 2 Units (Author) ',\n",
       " ' Conc 3 Type (Author) ',\n",
       " ' Conc 3 Mean Op (Author) ',\n",
       " ' Conc 3 Mean (Author) ',\n",
       " ' Conc 3 Min Op (Author) ',\n",
       " ' Conc Min 3 (Author) ',\n",
       " ' Conc 3 Max Op (Author) ',\n",
       " ' Conc 3 Max (Author) ',\n",
       " ' Conc 3 Units (Author)',\n",
       " 'Observed Duration Op (Days) ',\n",
       " ' Observed Duration (Days) ',\n",
       " ' Observed Duration Min Op (Days) ',\n",
       " ' Observed Duration Min (Days) ',\n",
       " ' Observed Duration Max Op (Days) ',\n",
       " ' Observed Duration Max (Days) ',\n",
       " ' Observed Duration Units (Days)',\n",
       " 'Author ',\n",
       " ' Reference Number ',\n",
       " ' Title ',\n",
       " ' Source ',\n",
       " ' Publication Year',\n",
       " 'Unnamed: 65']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['LD05', 'LD50', 'LC50', 'LD0.1', 'LD01', 'LD16', 'LD10', 'LD20',\n",
       "       'LD80', 'LD90', 'LD0', 'LD100', 'LC100', 'LC80', 'LD50/', 'LD75/',\n",
       "       'LD90/', 'LD95/', 'LD99/', 'LD95', 'LD99', 'LD84'], dtype=object)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "endpoints = df.Endpoint.unique()\n",
    "endpoints"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# here I define a tokenizer and stemmer which returns the set of stems in the text that it is passed\n",
    "\n",
    "def tokenize_and_stem(text):\n",
    "    # first tokenize by sentence, then by word to ensure that punctuation is caught as it's own token\n",
    "    tokens = [word for sent in nltk.sent_tokenize(text) for word in nltk.word_tokenize(sent)]\n",
    "    filtered_tokens = []\n",
    "    # filter out any tokens not containing letters (e.g., numeric tokens, raw punctuation)\n",
    "    for token in tokens:\n",
    "        if re.search('[a-zA-Z]', token):\n",
    "            filtered_tokens.append(token)\n",
    "    stems = [stemmer.stem(t) for t in filtered_tokens]\n",
    "    return stems\n",
    "\n",
    "\n",
    "def tokenize_only(text):\n",
    "    # first tokenize by sentence, then by word to ensure that punctuation is caught as it's own token\n",
    "    tokens = [word.lower() for sent in nltk.sent_tokenize(text) for word in nltk.word_tokenize(sent)]\n",
    "    filtered_tokens = []\n",
    "    # filter out any tokens not containing letters (e.g., numeric tokens, raw punctuation)\n",
    "    for token in tokens:\n",
    "        if re.search('[a-zA-Z]', token):\n",
    "            filtered_tokens.append(token)\n",
    "    return filtered_tokens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "#not super pythonic, no, not at all.\n",
    "#use extend so it's a big flat list of vocab\n",
    "totalvocab_stemmed = []\n",
    "totalvocab_tokenized = []\n",
    "for i in df.Endpoint.unique():\n",
    "    allwords_stemmed = tokenize_and_stem(i) #for each item in 'synopses', tokenize/stem\n",
    "    totalvocab_stemmed.extend(allwords_stemmed) #extend the 'totalvocab_stemmed' list\n",
    "    \n",
    "    allwords_tokenized = tokenize_only(i)\n",
    "    totalvocab_tokenized.extend(allwords_tokenized)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "there are 1787 items in vocab_frame\n"
     ]
    }
   ],
   "source": [
    "vocab_frame = df\n",
    "print ('there are ' + str(vocab_frame.shape[0]) + ' items in vocab_frame')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 87.2 ms, sys: 2.31 ms, total: 89.5 ms\n",
      "Wall time: 92 ms\n",
      "(1787, 66)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "\n",
    "#define vectorizer parameters\n",
    "tfidf_vectorizer = TfidfVectorizer(max_df=0.8, max_features=200000,\n",
    "                                 min_df=0.045, stop_words='english',\n",
    "                                 use_idf=True, tokenizer=tokenize_and_stem, ngram_range=(1,3))\n",
    "\n",
    "%time tfidf_matrix = tfidf_vectorizer.fit_transform(endpoints) #fit the vectorizer to synopses\n",
    "\n",
    "print(df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['lc100',\n",
       " 'lc50',\n",
       " 'lc80',\n",
       " 'ld0',\n",
       " 'ld0.1',\n",
       " 'ld01',\n",
       " 'ld05',\n",
       " 'ld10',\n",
       " 'ld100',\n",
       " 'ld16',\n",
       " 'ld20',\n",
       " 'ld50',\n",
       " 'ld50/',\n",
       " 'ld75/',\n",
       " 'ld80',\n",
       " 'ld84',\n",
       " 'ld90',\n",
       " 'ld90/',\n",
       " 'ld95',\n",
       " 'ld95/',\n",
       " 'ld99',\n",
       " 'ld99/']"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "terms = tfidf_vectorizer.get_feature_names()\n",
    "terms"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0., 1.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 0.,\n",
       "        1., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        0., 1., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 0., 1., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 0., 1., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 0., 1., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 0., 1.],\n",
       "       [1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1., 1.,\n",
       "        1., 1., 1., 1., 1., 0.]])"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "dist = 1 - cosine_similarity(tfidf_matrix)\n",
    "dist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 81.3 ms, sys: 13.2 ms, total: 94.4 ms\n",
      "Wall time: 122 ms\n"
     ]
    }
   ],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "\n",
    "num_clusters = 5\n",
    "\n",
    "km = KMeans(n_clusters=num_clusters)\n",
    "\n",
    "%time km.fit(tfidf_matrix)\n",
    "\n",
    "clusters = km.labels_.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.externals import joblib\n",
    "\n",
    "#uncomment the below to save your model \n",
    "#since I've already run my model I am loading from the pickle\n",
    "\n",
    "doc_cluster = df.to_pickle(\"data/treated_data/TerrestrialReport_lc_ld_mammals.pkl\")\n",
    "\n",
    "joblib.dump(km, \"data/treated_data/TerrestrialReport_lc_ld_mammals.pkl\")\n",
    "\n",
    "km = joblib.load('data/treated_data/TerrestrialReport_lc_ld_mammals.pkl')\n",
    "clusters = km.labels_.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "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>CAS Number</th>\n",
       "      <th>Chemical Name</th>\n",
       "      <th>Chemical Grade</th>\n",
       "      <th>Chemical Purity Mean Op</th>\n",
       "      <th>Chemical Purity Mean(%)</th>\n",
       "      <th>Chemical Purity Min Op</th>\n",
       "      <th>Chemical Purity Min(%)</th>\n",
       "      <th>Chemical Purity Max Op</th>\n",
       "      <th>Chemical Purity Max(%)</th>\n",
       "      <th>Species Group</th>\n",
       "      <th>...</th>\n",
       "      <th>Observed Duration Min (Days)</th>\n",
       "      <th>Observed Duration Max Op (Days)</th>\n",
       "      <th>Observed Duration Max (Days)</th>\n",
       "      <th>Observed Duration Units (Days)</th>\n",
       "      <th>Author</th>\n",
       "      <th>Reference Number</th>\n",
       "      <th>Title</th>\n",
       "      <th>Source</th>\n",
       "      <th>Publication Year</th>\n",
       "      <th>Unnamed: 65</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>50000</td>\n",
       "      <td>Formalin</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu</td>\n",
       "      <td>104102</td>\n",
       "      <td>Pharmacokinetic Analysis of Increased Toxicity...</td>\n",
       "      <td>Fundam. Appl. Toxicol.4(5): 724-730</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50293</td>\n",
       "      <td>1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Ahdaya,S.M., P.V. Shah, and F.E. Guthrie</td>\n",
       "      <td>35005</td>\n",
       "      <td>Thermoregulation in Mice Treated with Parathio...</td>\n",
       "      <td>Toxicol. Appl. Pharmacol.35:575-580</td>\n",
       "      <td>1976</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50293</td>\n",
       "      <td>1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Ahdaya,S.M., P.V. Shah, and F.E. Guthrie</td>\n",
       "      <td>35005</td>\n",
       "      <td>Thermoregulation in Mice Treated with Parathio...</td>\n",
       "      <td>Toxicol. Appl. Pharmacol.35:575-580</td>\n",
       "      <td>1976</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>50293</td>\n",
       "      <td>1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Ahdaya,S.M., P.V. Shah, and F.E. Guthrie</td>\n",
       "      <td>35005</td>\n",
       "      <td>Thermoregulation in Mice Treated with Parathio...</td>\n",
       "      <td>Toxicol. Appl. Pharmacol.35:575-580</td>\n",
       "      <td>1976</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>50351</td>\n",
       "      <td>2-(2,6-Dioxo-3-piperidinyl)-1H-isoindole-1,3(2...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Fickentscher,K., A. Kirfel, G. Will, and F. Ko...</td>\n",
       "      <td>91811</td>\n",
       "      <td>Stereochemical Properties and Teratogenic Acti...</td>\n",
       "      <td>Mol. Pharmacol.13(1): 133-141</td>\n",
       "      <td>1977</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50657</td>\n",
       "      <td>5-Chloro-N-(2-chloro-4-nitrophenyl)-2-hydroxyb...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Brody,G., and T.E. Elward</td>\n",
       "      <td>101241</td>\n",
       "      <td>Comparative Activity of 29 Known Anthelmintics...</td>\n",
       "      <td>J. Parasitol.57(5): 1068-1077</td>\n",
       "      <td>1971</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Dzwonkowska,A., and H. Hubner</td>\n",
       "      <td>90770</td>\n",
       "      <td>Induction of Chromosmal Aberrations in the Syr...</td>\n",
       "      <td>Arch. Toxicol.58(3): 152-156</td>\n",
       "      <td>1986</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Brody,G., and T.E. Elward</td>\n",
       "      <td>101241</td>\n",
       "      <td>Comparative Activity of 29 Known Anthelmintics...</td>\n",
       "      <td>J. Parasitol.57(5): 1068-1077</td>\n",
       "      <td>1971</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Kobayashi,S.I.</td>\n",
       "      <td>6905</td>\n",
       "      <td>Synergism in Pesticide Toxicity (2)  Acute Ora...</td>\n",
       "      <td>J. Med. Soc. Toho Univ.25(4): 635-649</td>\n",
       "      <td>1978</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....</td>\n",
       "      <td>35203</td>\n",
       "      <td>Estimation of the LD1 and Extrapolation of the...</td>\n",
       "      <td>Arch. Toxicol.34:103-109</td>\n",
       "      <td>1975</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Kobayashi,S.I.</td>\n",
       "      <td>6905</td>\n",
       "      <td>Synergism in Pesticide Toxicity (2)  Acute Ora...</td>\n",
       "      <td>J. Med. Soc. Toho Univ.25(4): 635-649</td>\n",
       "      <td>1978</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Shtabsky,B.M., V.I. Fedorenko, S.V. Kandul, an...</td>\n",
       "      <td>103428</td>\n",
       "      <td>Combinatory Toxicity of Some Agrochemical and ...</td>\n",
       "      <td>Fresenius Environ. Bull.4(6): 364-368</td>\n",
       "      <td>1995</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>52686</td>\n",
       "      <td>P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Shtabsky,B.M., V.I. Fedorenko, S.V. Kandul, an...</td>\n",
       "      <td>103427</td>\n",
       "      <td>Combinatory Toxicity of Some Agrochemicals and...</td>\n",
       "      <td>Fresenius Environ. Bull.2(7): 375-379</td>\n",
       "      <td>1993</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>54115</td>\n",
       "      <td>3-[(2S)-1-Methyl-2-pyrrolidinyl]pyridine</td>\n",
       "      <td>Not coded</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Kimmel,E.C., and L. Diamond</td>\n",
       "      <td>84669</td>\n",
       "      <td>The Role of Nicotine in the Pathogenesis of Pu...</td>\n",
       "      <td>Am. J. Respir. Crit. Care Med.129(1): 112-117</td>\n",
       "      <td>1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>54717</td>\n",
       "      <td>(3S-cis)-3[Ethyldihydro-4-[(1-methyl-1H-imidaz...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Schafer,E.W.,Jr., and W.A.,Jr. Bowles</td>\n",
       "      <td>35426</td>\n",
       "      <td>Acute Oral Toxicity and Repellency of 933 Chem...</td>\n",
       "      <td>Arch. Environ. Contam. Toxicol.14(1): 111-129</td>\n",
       "      <td>1985</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>55378</td>\n",
       "      <td>Phosphorothioic acid O-[3,5-dimethyl-4-(methyl...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Schafer,E.W.,Jr., and W.A.,Jr. Bowles</td>\n",
       "      <td>35426</td>\n",
       "      <td>Acute Oral Toxicity and Repellency of 933 Chem...</td>\n",
       "      <td>Arch. Environ. Contam. Toxicol.14(1): 111-129</td>\n",
       "      <td>1985</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1757</th>\n",
       "      <td>69352905</td>\n",
       "      <td>2-(2,6-Dioxo-3-piperidinyl)-3a,4,7,7a-tetrahyd...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Fickentscher,K., A. Kirfel, G. Will, and F. Ko...</td>\n",
       "      <td>91811</td>\n",
       "      <td>Stereochemical Properties and Teratogenic Acti...</td>\n",
       "      <td>Mol. Pharmacol.13(1): 133-141</td>\n",
       "      <td>1977</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1758</th>\n",
       "      <td>69352905</td>\n",
       "      <td>2-(2,6-Dioxo-3-piperidinyl)-3a,4,7,7a-tetrahyd...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Fickentscher,K., A. Kirfel, G. Will, and F. Ko...</td>\n",
       "      <td>91811</td>\n",
       "      <td>Stereochemical Properties and Teratogenic Acti...</td>\n",
       "      <td>Mol. Pharmacol.13(1): 133-141</td>\n",
       "      <td>1977</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1759</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1760</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1761</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1762</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1763</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1765</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Bio-Medical Research Laboratories Co.Ltd.</td>\n",
       "      <td>75675</td>\n",
       "      <td>Initial Submission:  Acute Toxicity Study with...</td>\n",
       "      <td>EPA/OTS Doc.#88-920002976:53 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1766</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1767</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1768</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1769</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1770</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1771</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1772</th>\n",
       "      <td>74051802</td>\n",
       "      <td>2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>EPA/OTS</td>\n",
       "      <td>75728</td>\n",
       "      <td>Initial Submission:  Acute Toxicity of 2-(N-Et...</td>\n",
       "      <td>EPA/OTS Doc.#88-920003022:126 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1773</th>\n",
       "      <td>78308324</td>\n",
       "      <td>Hydrocarbon oils, Arom.</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Muralidhara,S., and M.K. Krishnakumari</td>\n",
       "      <td>35314</td>\n",
       "      <td>Mammalian Toxicity of Aromex and Xylene Used i...</td>\n",
       "      <td>Indian J. Exp. Biol.18:1148-1151</td>\n",
       "      <td>1980</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1774</th>\n",
       "      <td>78308324</td>\n",
       "      <td>Hydrocarbon oils, Arom.</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Muralidhara,S., and M.K. Krishnakumari</td>\n",
       "      <td>35314</td>\n",
       "      <td>Mammalian Toxicity of Aromex and Xylene Used i...</td>\n",
       "      <td>Indian J. Exp. Biol.18:1148-1151</td>\n",
       "      <td>1980</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1775</th>\n",
       "      <td>82510983</td>\n",
       "      <td>1-(Dichloromethyl)-4-(trifluoromethyl)benzene</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>&gt;</td>\n",
       "      <td>99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Tai,T., M. Yamashita, M. Takeda, and H. Naito</td>\n",
       "      <td>173998</td>\n",
       "      <td>The Toxicity and Structure of Various Aromatic...</td>\n",
       "      <td>Fluoride19(3): 117-121</td>\n",
       "      <td>1986</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1776</th>\n",
       "      <td>82558507</td>\n",
       "      <td>N-[3-(1-Ethyl-1-methylpropyl)-5-isoxazolyl]-2,...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Eli Lilly and Co.</td>\n",
       "      <td>100610</td>\n",
       "      <td>Initial Submission:  Letter from Eli Lilly &amp; C...</td>\n",
       "      <td>EPA/OTS Doc.#88-920006224:15 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1777</th>\n",
       "      <td>88671890</td>\n",
       "      <td>alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Rohm and Haas Co.</td>\n",
       "      <td>104756</td>\n",
       "      <td>Initial Submission: Acute Oral Study of 1H-1,2...</td>\n",
       "      <td>EPA/OTS Doc.#88-920008027:8 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1778</th>\n",
       "      <td>88671890</td>\n",
       "      <td>alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Rohm and Haas Co.</td>\n",
       "      <td>104752</td>\n",
       "      <td>Initial Submission:  Acute Oral LD50 in Rats o...</td>\n",
       "      <td>EPA/OTS Doc.#88-920008035:12 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1779</th>\n",
       "      <td>88671890</td>\n",
       "      <td>alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Rohm and Haas Co.</td>\n",
       "      <td>104754</td>\n",
       "      <td>Initial Submission:  Acute Oral LD50 Study in ...</td>\n",
       "      <td>EPA/OTS Doc.#88-920008071:12 p.</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1780</th>\n",
       "      <td>96182535</td>\n",
       "      <td>Phosphorothioc acid O-[2-(1,1-dimethylethyl)-5...</td>\n",
       "      <td>Not coded</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>U.S. Environmental Protection Agency</td>\n",
       "      <td>344</td>\n",
       "      <td>Pesticide Ecotoxicity Database (Formerly:  Env...</td>\n",
       "      <td>Environmental Fate and Effects Division, U.S.E...</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1781</th>\n",
       "      <td>104653341</td>\n",
       "      <td>3-[3-[4'-Bromo[1,1'-biphenyl]-4-yl)-1,2,3,4-te...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Moran,S.</td>\n",
       "      <td>75464</td>\n",
       "      <td>Toxicity of the Anticoagulant Rodenticide Dife...</td>\n",
       "      <td>Crop Prot.12(7): 501-504</td>\n",
       "      <td>1993</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1782</th>\n",
       "      <td>104653341</td>\n",
       "      <td>3-[3-[4'-Bromo[1,1'-biphenyl]-4-yl)-1,2,3,4-te...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>U.S. Environmental Protection Agency</td>\n",
       "      <td>344</td>\n",
       "      <td>Pesticide Ecotoxicity Database (Formerly:  Env...</td>\n",
       "      <td>Environmental Fate and Effects Division, U.S.E...</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1783</th>\n",
       "      <td>138261413</td>\n",
       "      <td>(2E)-1-[(6-Chloro-3-pyridinyl)methyl]-N-nitro-...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>El-Gendy,K.S., N.M. Aly, F.H. Mahmoud, A. Kena...</td>\n",
       "      <td>168947</td>\n",
       "      <td>The Role of Vitamin C as Antioxidant in Protec...</td>\n",
       "      <td>Food Chem. Toxicol.48(1): 215-221</td>\n",
       "      <td>2010</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1784</th>\n",
       "      <td>138261413</td>\n",
       "      <td>(2E)-1-[(6-Chloro-3-pyridinyl)methyl]-N-nitro-...</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Mohany,M., M. El-Feki, I. Refaat, O. Garraud, ...</td>\n",
       "      <td>168921</td>\n",
       "      <td>Thymoquinone Ameliorates the Immunological and...</td>\n",
       "      <td>J. Toxicol. Sci.37(1): 1-11</td>\n",
       "      <td>2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1785</th>\n",
       "      <td>308064826</td>\n",
       "      <td>Essential oils, Orange, Sweet</td>\n",
       "      <td>Not reported</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Mammals</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>Singh,P., R. Shukla, B. Prakash, A. Kumar, S. ...</td>\n",
       "      <td>160137</td>\n",
       "      <td>Chemical Profile, Antifungal, Antiaflatoxigeni...</td>\n",
       "      <td>Food Chem. Toxicol.48(6): 1734-1740</td>\n",
       "      <td>2010</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1786</th>\n",
       "      <td>317815831</td>\n",
       "      <td>4-[[[(4,5-Dihydro-3-methoxy-4-methyl-5-oxo-1H-...</td>\n",
       "      <td>Technical grade, technical product, technical ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NC</td>\n",
       "      <td>Mammals; Standard Test Species</td>\n",
       "      <td>...</td>\n",
       "      <td>NR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NR</td>\n",
       "      <td>Day(s)</td>\n",
       "      <td>U.S. Environmental Protection Agency</td>\n",
       "      <td>344</td>\n",
       "      <td>Pesticide Ecotoxicity Database (Formerly:  Env...</td>\n",
       "      <td>Environmental Fate and Effects Division, U.S.E...</td>\n",
       "      <td>1992</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1787 rows × 66 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     CAS Number                                       Chemical Name  \\\n",
       "0          50000                                           Formalin   \n",
       "1          50000                                           Formalin   \n",
       "2          50000                                           Formalin   \n",
       "3          50000                                           Formalin   \n",
       "4          50000                                           Formalin   \n",
       "5          50000                                           Formalin   \n",
       "6          50293  1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...   \n",
       "7          50293  1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...   \n",
       "8          50293  1,1'-(2,2,2-Trichloroethylidene)bis[4-chlorobe...   \n",
       "9          50351  2-(2,6-Dioxo-3-piperidinyl)-1H-isoindole-1,3(2...   \n",
       "10         50657  5-Chloro-N-(2-chloro-4-nitrophenyl)-2-hydroxyb...   \n",
       "11         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "12         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "13         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "14         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "15         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "16         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "17         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "18         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "19         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "20         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "21         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "22         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "23         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "24         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "25         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "26         52686  P-(2,2,2-Trichloro-1-hydroxyethyl)phosphonic a...   \n",
       "27         54115           3-[(2S)-1-Methyl-2-pyrrolidinyl]pyridine   \n",
       "28         54717  (3S-cis)-3[Ethyldihydro-4-[(1-methyl-1H-imidaz...   \n",
       "29         55378  Phosphorothioic acid O-[3,5-dimethyl-4-(methyl...   \n",
       "...          ...                                                ...   \n",
       "1757    69352905  2-(2,6-Dioxo-3-piperidinyl)-3a,4,7,7a-tetrahyd...   \n",
       "1758    69352905  2-(2,6-Dioxo-3-piperidinyl)-3a,4,7,7a-tetrahyd...   \n",
       "1759    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1760    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1761    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1762    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1763    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1764    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1765    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1766    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1767    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1768    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1769    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1770    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1771    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1772    74051802  2-[1-(Ethoxyimino)butyl]-5-[2-(ethylthio)propy...   \n",
       "1773    78308324                            Hydrocarbon oils, Arom.   \n",
       "1774    78308324                            Hydrocarbon oils, Arom.   \n",
       "1775    82510983      1-(Dichloromethyl)-4-(trifluoromethyl)benzene   \n",
       "1776    82558507  N-[3-(1-Ethyl-1-methylpropyl)-5-isoxazolyl]-2,...   \n",
       "1777    88671890  alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...   \n",
       "1778    88671890  alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...   \n",
       "1779    88671890  alpha-Butyl-alpha-(4-chlorophenyl)-1H-1,2,4-tr...   \n",
       "1780    96182535  Phosphorothioc acid O-[2-(1,1-dimethylethyl)-5...   \n",
       "1781   104653341  3-[3-[4'-Bromo[1,1'-biphenyl]-4-yl)-1,2,3,4-te...   \n",
       "1782   104653341  3-[3-[4'-Bromo[1,1'-biphenyl]-4-yl)-1,2,3,4-te...   \n",
       "1783   138261413  (2E)-1-[(6-Chloro-3-pyridinyl)methyl]-N-nitro-...   \n",
       "1784   138261413  (2E)-1-[(6-Chloro-3-pyridinyl)methyl]-N-nitro-...   \n",
       "1785   308064826                      Essential oils, Orange, Sweet   \n",
       "1786   317815831  4-[[[(4,5-Dihydro-3-methoxy-4-methyl-5-oxo-1H-...   \n",
       "\n",
       "                                         Chemical Grade  \\\n",
       "0     Technical grade, technical product, technical ...   \n",
       "1     Technical grade, technical product, technical ...   \n",
       "2     Technical grade, technical product, technical ...   \n",
       "3     Technical grade, technical product, technical ...   \n",
       "4     Technical grade, technical product, technical ...   \n",
       "5     Technical grade, technical product, technical ...   \n",
       "6                                          Not reported   \n",
       "7                                          Not reported   \n",
       "8                                          Not reported   \n",
       "9                                          Not reported   \n",
       "10                                         Not reported   \n",
       "11                                         Not reported   \n",
       "12                                         Not reported   \n",
       "13                                         Not reported   \n",
       "14                                         Not reported   \n",
       "15                                         Not reported   \n",
       "16                                         Not reported   \n",
       "17                                         Not reported   \n",
       "18                                         Not reported   \n",
       "19                                         Not reported   \n",
       "20                                         Not reported   \n",
       "21                                         Not reported   \n",
       "22                                         Not reported   \n",
       "23                                         Not reported   \n",
       "24                                         Not reported   \n",
       "25                                         Not reported   \n",
       "26                                         Not reported   \n",
       "27                                            Not coded   \n",
       "28    Technical grade, technical product, technical ...   \n",
       "29    Technical grade, technical product, technical ...   \n",
       "...                                                 ...   \n",
       "1757                                       Not reported   \n",
       "1758                                       Not reported   \n",
       "1759                                       Not reported   \n",
       "1760                                       Not reported   \n",
       "1761                                       Not reported   \n",
       "1762                                       Not reported   \n",
       "1763                                       Not reported   \n",
       "1764                                       Not reported   \n",
       "1765                                       Not reported   \n",
       "1766                                       Not reported   \n",
       "1767                                       Not reported   \n",
       "1768                                       Not reported   \n",
       "1769                                       Not reported   \n",
       "1770                                       Not reported   \n",
       "1771                                       Not reported   \n",
       "1772                                       Not reported   \n",
       "1773                                       Not reported   \n",
       "1774                                       Not reported   \n",
       "1775                                       Not reported   \n",
       "1776                                       Not reported   \n",
       "1777  Technical grade, technical product, technical ...   \n",
       "1778  Technical grade, technical product, technical ...   \n",
       "1779  Technical grade, technical product, technical ...   \n",
       "1780                                          Not coded   \n",
       "1781                                       Not reported   \n",
       "1782  Technical grade, technical product, technical ...   \n",
       "1783  Technical grade, technical product, technical ...   \n",
       "1784                                       Not reported   \n",
       "1785                                       Not reported   \n",
       "1786  Technical grade, technical product, technical ...   \n",
       "\n",
       "      Chemical Purity Mean Op   Chemical Purity Mean(%)   \\\n",
       "0                          NaN                      96.6   \n",
       "1                          NaN                      96.6   \n",
       "2                          NaN                      96.6   \n",
       "3                          NaN                      96.6   \n",
       "4                          NaN                      96.6   \n",
       "5                          NaN                      96.6   \n",
       "6                          NaN                        NR   \n",
       "7                          NaN                        NR   \n",
       "8                          NaN                        NR   \n",
       "9                          NaN                        NR   \n",
       "10                         NaN                        NR   \n",
       "11                         NaN                        25   \n",
       "12                         NaN                        NR   \n",
       "13                         NaN                        99   \n",
       "14                         NaN                        99   \n",
       "15                         NaN                        99   \n",
       "16                         NaN                        99   \n",
       "17                         NaN                        99   \n",
       "18                         NaN                        99   \n",
       "19                         NaN                        99   \n",
       "20                         NaN                        99   \n",
       "21                         NaN                        50   \n",
       "22                         NaN                        99   \n",
       "23                         NaN                        99   \n",
       "24                         NaN                        50   \n",
       "25                         NaN                        NR   \n",
       "26                         NaN                        NR   \n",
       "27                         NaN                        NR   \n",
       "28                         NaN                        NR   \n",
       "29                         NaN                        NR   \n",
       "...                        ...                       ...   \n",
       "1757                       NaN                        NR   \n",
       "1758                       NaN                        NR   \n",
       "1759                       NaN                      95.9   \n",
       "1760                       NaN                      95.9   \n",
       "1761                       NaN                      95.9   \n",
       "1762                       NaN                      95.9   \n",
       "1763                       NaN                      95.9   \n",
       "1764                       NaN                      95.9   \n",
       "1765                       NaN                      95.9   \n",
       "1766                       NaN                      95.9   \n",
       "1767                       NaN                      95.9   \n",
       "1768                       NaN                      95.9   \n",
       "1769                       NaN                      95.9   \n",
       "1770                       NaN                      95.9   \n",
       "1771                       NaN                      95.9   \n",
       "1772                       NaN                      95.9   \n",
       "1773                       NaN                        NR   \n",
       "1774                       NaN                        NR   \n",
       "1775                         >                        99   \n",
       "1776                       NaN                        NR   \n",
       "1777                       NaN                      81.1   \n",
       "1778                       NaN                        92   \n",
       "1779                       NaN                      91.9   \n",
       "1780                       NaN                      90.2   \n",
       "1781                       NaN                        NR   \n",
       "1782                       NaN                        NC   \n",
       "1783                       NaN                        95   \n",
       "1784                       NaN                        20   \n",
       "1785                       NaN                        NR   \n",
       "1786                       NaN                        NC   \n",
       "\n",
       "      Chemical Purity Min Op   Chemical Purity Min(%)   \\\n",
       "0                         NaN                       NR   \n",
       "1                         NaN                       NR   \n",
       "2                         NaN                       NR   \n",
       "3                         NaN                       NR   \n",
       "4                         NaN                       NR   \n",
       "5                         NaN                       NR   \n",
       "6                         NaN                       NR   \n",
       "7                         NaN                       NR   \n",
       "8                         NaN                       NR   \n",
       "9                         NaN                       NR   \n",
       "10                        NaN                       NR   \n",
       "11                        NaN                       NR   \n",
       "12                        NaN                       NR   \n",
       "13                        NaN                       NR   \n",
       "14                        NaN                       NR   \n",
       "15                        NaN                       NR   \n",
       "16                        NaN                       NR   \n",
       "17                        NaN                       NR   \n",
       "18                        NaN                       NR   \n",
       "19                        NaN                       NR   \n",
       "20                        NaN                       NR   \n",
       "21                        NaN                       NR   \n",
       "22                        NaN                       NR   \n",
       "23                        NaN                       NR   \n",
       "24                        NaN                       NR   \n",
       "25                        NaN                       NR   \n",
       "26                        NaN                       NR   \n",
       "27                        NaN                       NR   \n",
       "28                        NaN                       NR   \n",
       "29                        NaN                       NR   \n",
       "...                       ...                      ...   \n",
       "1757                      NaN                       NR   \n",
       "1758                      NaN                       NR   \n",
       "1759                      NaN                       NR   \n",
       "1760                      NaN                       NR   \n",
       "1761                      NaN                       NR   \n",
       "1762                      NaN                       NR   \n",
       "1763                      NaN                       NR   \n",
       "1764                      NaN                       NR   \n",
       "1765                      NaN                       NR   \n",
       "1766                      NaN                       NR   \n",
       "1767                      NaN                       NR   \n",
       "1768                      NaN                       NR   \n",
       "1769                      NaN                       NR   \n",
       "1770                      NaN                       NR   \n",
       "1771                      NaN                       NR   \n",
       "1772                      NaN                       NR   \n",
       "1773                      NaN                       NR   \n",
       "1774                      NaN                       NR   \n",
       "1775                      NaN                       NR   \n",
       "1776                      NaN                       NR   \n",
       "1777                      NaN                       NR   \n",
       "1778                      NaN                       NR   \n",
       "1779                      NaN                       NR   \n",
       "1780                      NaN                       NR   \n",
       "1781                      NaN                       NR   \n",
       "1782                      NaN                       NC   \n",
       "1783                      NaN                       NR   \n",
       "1784                      NaN                       NR   \n",
       "1785                      NaN                       NR   \n",
       "1786                      NaN                       NC   \n",
       "\n",
       "      Chemical Purity Max Op   Chemical Purity Max(%)  \\\n",
       "0                         NaN                      NR   \n",
       "1                         NaN                      NR   \n",
       "2                         NaN                      NR   \n",
       "3                         NaN                      NR   \n",
       "4                         NaN                      NR   \n",
       "5                         NaN                      NR   \n",
       "6                         NaN                      NR   \n",
       "7                         NaN                      NR   \n",
       "8                         NaN                      NR   \n",
       "9                         NaN                      NR   \n",
       "10                        NaN                      NR   \n",
       "11                        NaN                      NR   \n",
       "12                        NaN                      NR   \n",
       "13                        NaN                      NR   \n",
       "14                        NaN                      NR   \n",
       "15                        NaN                      NR   \n",
       "16                        NaN                      NR   \n",
       "17                        NaN                      NR   \n",
       "18                        NaN                      NR   \n",
       "19                        NaN                      NR   \n",
       "20                        NaN                      NR   \n",
       "21                        NaN                      NR   \n",
       "22                        NaN                      NR   \n",
       "23                        NaN                      NR   \n",
       "24                        NaN                      NR   \n",
       "25                        NaN                      NR   \n",
       "26                        NaN                      NR   \n",
       "27                        NaN                      NR   \n",
       "28                        NaN                      NR   \n",
       "29                        NaN                      NR   \n",
       "...                       ...                     ...   \n",
       "1757                      NaN                      NR   \n",
       "1758                      NaN                      NR   \n",
       "1759                      NaN                      NR   \n",
       "1760                      NaN                      NR   \n",
       "1761                      NaN                      NR   \n",
       "1762                      NaN                      NR   \n",
       "1763                      NaN                      NR   \n",
       "1764                      NaN                      NR   \n",
       "1765                      NaN                      NR   \n",
       "1766                      NaN                      NR   \n",
       "1767                      NaN                      NR   \n",
       "1768                      NaN                      NR   \n",
       "1769                      NaN                      NR   \n",
       "1770                      NaN                      NR   \n",
       "1771                      NaN                      NR   \n",
       "1772                      NaN                      NR   \n",
       "1773                      NaN                      NR   \n",
       "1774                      NaN                      NR   \n",
       "1775                      NaN                      NR   \n",
       "1776                      NaN                      NR   \n",
       "1777                      NaN                      NR   \n",
       "1778                      NaN                      NR   \n",
       "1779                      NaN                      NR   \n",
       "1780                      NaN                      NR   \n",
       "1781                      NaN                      NR   \n",
       "1782                      NaN                      NC   \n",
       "1783                      NaN                      NR   \n",
       "1784                      NaN                      NR   \n",
       "1785                      NaN                      NR   \n",
       "1786                      NaN                      NC   \n",
       "\n",
       "                       Species Group  ...  Observed Duration Min (Days)   \\\n",
       "0                            Mammals  ...                             NR   \n",
       "1                            Mammals  ...                             NR   \n",
       "2                            Mammals  ...                             NR   \n",
       "3                            Mammals  ...                             NR   \n",
       "4                            Mammals  ...                             NR   \n",
       "5                            Mammals  ...                             NR   \n",
       "6                            Mammals  ...                             NR   \n",
       "7                            Mammals  ...                             NR   \n",
       "8                            Mammals  ...                             NR   \n",
       "9                            Mammals  ...                             NR   \n",
       "10                           Mammals  ...                             NR   \n",
       "11                           Mammals  ...                             NR   \n",
       "12                           Mammals  ...                             NR   \n",
       "13                           Mammals  ...                             NR   \n",
       "14                           Mammals  ...                             NR   \n",
       "15                           Mammals  ...                             NR   \n",
       "16                           Mammals  ...                             NR   \n",
       "17                           Mammals  ...                             NR   \n",
       "18                           Mammals  ...                             NR   \n",
       "19                           Mammals  ...                             NR   \n",
       "20                           Mammals  ...                             NR   \n",
       "21                           Mammals  ...                             NR   \n",
       "22                           Mammals  ...                             NR   \n",
       "23                           Mammals  ...                             NR   \n",
       "24                           Mammals  ...                             NR   \n",
       "25    Mammals; Standard Test Species  ...                             NR   \n",
       "26    Mammals; Standard Test Species  ...                             NR   \n",
       "27    Mammals; Standard Test Species  ...                             NR   \n",
       "28                           Mammals  ...                             NR   \n",
       "29                           Mammals  ...                             NR   \n",
       "...                              ...  ...                            ...   \n",
       "1757                         Mammals  ...                             NR   \n",
       "1758                         Mammals  ...                             NR   \n",
       "1759                         Mammals  ...                             NR   \n",
       "1760                         Mammals  ...                             NR   \n",
       "1761                         Mammals  ...                             NR   \n",
       "1762                         Mammals  ...                             NR   \n",
       "1763                         Mammals  ...                             NR   \n",
       "1764                         Mammals  ...                             NR   \n",
       "1765                         Mammals  ...                             NR   \n",
       "1766  Mammals; Standard Test Species  ...                             NR   \n",
       "1767  Mammals; Standard Test Species  ...                             NR   \n",
       "1768  Mammals; Standard Test Species  ...                             NR   \n",
       "1769  Mammals; Standard Test Species  ...                             NR   \n",
       "1770  Mammals; Standard Test Species  ...                             NR   \n",
       "1771  Mammals; Standard Test Species  ...                             NR   \n",
       "1772  Mammals; Standard Test Species  ...                             NR   \n",
       "1773  Mammals; Standard Test Species  ...                             NR   \n",
       "1774  Mammals; Standard Test Species  ...                             NR   \n",
       "1775  Mammals; Standard Test Species  ...                             NR   \n",
       "1776  Mammals; Standard Test Species  ...                             NR   \n",
       "1777                         Mammals  ...                             NR   \n",
       "1778  Mammals; Standard Test Species  ...                             NR   \n",
       "1779  Mammals; Standard Test Species  ...                             NR   \n",
       "1780                         Mammals  ...                             NR   \n",
       "1781                         Mammals  ...                             NR   \n",
       "1782                         Mammals  ...                             NR   \n",
       "1783                         Mammals  ...                             NR   \n",
       "1784  Mammals; Standard Test Species  ...                             NR   \n",
       "1785                         Mammals  ...                             NR   \n",
       "1786  Mammals; Standard Test Species  ...                             NR   \n",
       "\n",
       "      Observed Duration Max Op (Days)   Observed Duration Max (Days)   \\\n",
       "0                                  NaN                             NR   \n",
       "1                                  NaN                             NR   \n",
       "2                                  NaN                             NR   \n",
       "3                                  NaN                             NR   \n",
       "4                                  NaN                             NR   \n",
       "5                                  NaN                             NR   \n",
       "6                                  NaN                             NR   \n",
       "7                                  NaN                             NR   \n",
       "8                                  NaN                             NR   \n",
       "9                                  NaN                             NR   \n",
       "10                                 NaN                             NR   \n",
       "11                                 NaN                             NR   \n",
       "12                                 NaN                             NR   \n",
       "13                                 NaN                             NR   \n",
       "14                                 NaN                             NR   \n",
       "15                                 NaN                             NR   \n",
       "16                                 NaN                             NR   \n",
       "17                                 NaN                             NR   \n",
       "18                                 NaN                             NR   \n",
       "19                                 NaN                             NR   \n",
       "20                                 NaN                             NR   \n",
       "21                                 NaN                             NR   \n",
       "22                                 NaN                             NR   \n",
       "23                                 NaN                             NR   \n",
       "24                                 NaN                             NR   \n",
       "25                                 NaN                             NR   \n",
       "26                                 NaN                             NR   \n",
       "27                                 NaN                             NR   \n",
       "28                                 NaN                             NR   \n",
       "29                                 NaN                             NR   \n",
       "...                                ...                            ...   \n",
       "1757                               NaN                             NR   \n",
       "1758                               NaN                             NR   \n",
       "1759                               NaN                             NR   \n",
       "1760                               NaN                             NR   \n",
       "1761                               NaN                             NR   \n",
       "1762                               NaN                             NR   \n",
       "1763                               NaN                             NR   \n",
       "1764                               NaN                             NR   \n",
       "1765                               NaN                             NR   \n",
       "1766                               NaN                             NR   \n",
       "1767                               NaN                             NR   \n",
       "1768                               NaN                             NR   \n",
       "1769                               NaN                             NR   \n",
       "1770                               NaN                             NR   \n",
       "1771                               NaN                             NR   \n",
       "1772                               NaN                             NR   \n",
       "1773                               NaN                             NR   \n",
       "1774                               NaN                             NR   \n",
       "1775                               NaN                             NR   \n",
       "1776                               NaN                             NR   \n",
       "1777                               NaN                             NR   \n",
       "1778                               NaN                             NR   \n",
       "1779                               NaN                             NR   \n",
       "1780                               NaN                             NR   \n",
       "1781                               NaN                             NR   \n",
       "1782                               NaN                             NR   \n",
       "1783                               NaN                             NR   \n",
       "1784                               NaN                             NR   \n",
       "1785                               NaN                             NR   \n",
       "1786                               NaN                             NR   \n",
       "\n",
       "      Observed Duration Units (Days)  \\\n",
       "0                             Day(s)   \n",
       "1                             Day(s)   \n",
       "2                             Day(s)   \n",
       "3                             Day(s)   \n",
       "4                             Day(s)   \n",
       "5                             Day(s)   \n",
       "6                             Day(s)   \n",
       "7                             Day(s)   \n",
       "8                             Day(s)   \n",
       "9                             Day(s)   \n",
       "10                            Day(s)   \n",
       "11                            Day(s)   \n",
       "12                            Day(s)   \n",
       "13                            Day(s)   \n",
       "14                            Day(s)   \n",
       "15                            Day(s)   \n",
       "16                            Day(s)   \n",
       "17                            Day(s)   \n",
       "18                            Day(s)   \n",
       "19                            Day(s)   \n",
       "20                            Day(s)   \n",
       "21                            Day(s)   \n",
       "22                            Day(s)   \n",
       "23                            Day(s)   \n",
       "24                            Day(s)   \n",
       "25                            Day(s)   \n",
       "26                            Day(s)   \n",
       "27                            Day(s)   \n",
       "28                            Day(s)   \n",
       "29                            Day(s)   \n",
       "...                              ...   \n",
       "1757                          Day(s)   \n",
       "1758                          Day(s)   \n",
       "1759                          Day(s)   \n",
       "1760                          Day(s)   \n",
       "1761                          Day(s)   \n",
       "1762                          Day(s)   \n",
       "1763                          Day(s)   \n",
       "1764                          Day(s)   \n",
       "1765                          Day(s)   \n",
       "1766                          Day(s)   \n",
       "1767                          Day(s)   \n",
       "1768                          Day(s)   \n",
       "1769                          Day(s)   \n",
       "1770                          Day(s)   \n",
       "1771                          Day(s)   \n",
       "1772                          Day(s)   \n",
       "1773                          Day(s)   \n",
       "1774                          Day(s)   \n",
       "1775                          Day(s)   \n",
       "1776                          Day(s)   \n",
       "1777                          Day(s)   \n",
       "1778                          Day(s)   \n",
       "1779                          Day(s)   \n",
       "1780                          Day(s)   \n",
       "1781                          Day(s)   \n",
       "1782                          Day(s)   \n",
       "1783                          Day(s)   \n",
       "1784                          Day(s)   \n",
       "1785                          Day(s)   \n",
       "1786                          Day(s)   \n",
       "\n",
       "                                                Author   Reference Number   \\\n",
       "0      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "1      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "2      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "3      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "4      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "5      Tsuda,S., T. Miyaoka, M. Iwasaki, and Y. Shirasu             104102   \n",
       "6              Ahdaya,S.M., P.V. Shah, and F.E. Guthrie              35005   \n",
       "7              Ahdaya,S.M., P.V. Shah, and F.E. Guthrie              35005   \n",
       "8              Ahdaya,S.M., P.V. Shah, and F.E. Guthrie              35005   \n",
       "9     Fickentscher,K., A. Kirfel, G. Will, and F. Ko...              91811   \n",
       "10                            Brody,G., and T.E. Elward             101241   \n",
       "11                        Dzwonkowska,A., and H. Hubner              90770   \n",
       "12                            Brody,G., and T.E. Elward             101241   \n",
       "13    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "14    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "15    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "16    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "17    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "18    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "19    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "20    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "21                                       Kobayashi,S.I.               6905   \n",
       "22    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "23    Haley,T.J., J.H. Farmer, J.R. Harmon, and K.L....              35203   \n",
       "24                                       Kobayashi,S.I.               6905   \n",
       "25    Shtabsky,B.M., V.I. Fedorenko, S.V. Kandul, an...             103428   \n",
       "26    Shtabsky,B.M., V.I. Fedorenko, S.V. Kandul, an...             103427   \n",
       "27                          Kimmel,E.C., and L. Diamond              84669   \n",
       "28                Schafer,E.W.,Jr., and W.A.,Jr. Bowles              35426   \n",
       "29                Schafer,E.W.,Jr., and W.A.,Jr. Bowles              35426   \n",
       "...                                                 ...                ...   \n",
       "1757  Fickentscher,K., A. Kirfel, G. Will, and F. Ko...              91811   \n",
       "1758  Fickentscher,K., A. Kirfel, G. Will, and F. Ko...              91811   \n",
       "1759          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1760          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1761          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1762          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1763          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1764          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1765          Bio-Medical Research Laboratories Co.Ltd.              75675   \n",
       "1766                                            EPA/OTS              75728   \n",
       "1767                                            EPA/OTS              75728   \n",
       "1768                                            EPA/OTS              75728   \n",
       "1769                                            EPA/OTS              75728   \n",
       "1770                                            EPA/OTS              75728   \n",
       "1771                                            EPA/OTS              75728   \n",
       "1772                                            EPA/OTS              75728   \n",
       "1773             Muralidhara,S., and M.K. Krishnakumari              35314   \n",
       "1774             Muralidhara,S., and M.K. Krishnakumari              35314   \n",
       "1775      Tai,T., M. Yamashita, M. Takeda, and H. Naito             173998   \n",
       "1776                                  Eli Lilly and Co.             100610   \n",
       "1777                                  Rohm and Haas Co.             104756   \n",
       "1778                                  Rohm and Haas Co.             104752   \n",
       "1779                                  Rohm and Haas Co.             104754   \n",
       "1780               U.S. Environmental Protection Agency                344   \n",
       "1781                                           Moran,S.              75464   \n",
       "1782               U.S. Environmental Protection Agency                344   \n",
       "1783  El-Gendy,K.S., N.M. Aly, F.H. Mahmoud, A. Kena...             168947   \n",
       "1784  Mohany,M., M. El-Feki, I. Refaat, O. Garraud, ...             168921   \n",
       "1785  Singh,P., R. Shukla, B. Prakash, A. Kumar, S. ...             160137   \n",
       "1786               U.S. Environmental Protection Agency                344   \n",
       "\n",
       "                                                 Title   \\\n",
       "0     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "1     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "2     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "3     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "4     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "5     Pharmacokinetic Analysis of Increased Toxicity...   \n",
       "6     Thermoregulation in Mice Treated with Parathio...   \n",
       "7     Thermoregulation in Mice Treated with Parathio...   \n",
       "8     Thermoregulation in Mice Treated with Parathio...   \n",
       "9     Stereochemical Properties and Teratogenic Acti...   \n",
       "10    Comparative Activity of 29 Known Anthelmintics...   \n",
       "11    Induction of Chromosmal Aberrations in the Syr...   \n",
       "12    Comparative Activity of 29 Known Anthelmintics...   \n",
       "13    Estimation of the LD1 and Extrapolation of the...   \n",
       "14    Estimation of the LD1 and Extrapolation of the...   \n",
       "15    Estimation of the LD1 and Extrapolation of the...   \n",
       "16    Estimation of the LD1 and Extrapolation of the...   \n",
       "17    Estimation of the LD1 and Extrapolation of the...   \n",
       "18    Estimation of the LD1 and Extrapolation of the...   \n",
       "19    Estimation of the LD1 and Extrapolation of the...   \n",
       "20    Estimation of the LD1 and Extrapolation of the...   \n",
       "21    Synergism in Pesticide Toxicity (2)  Acute Ora...   \n",
       "22    Estimation of the LD1 and Extrapolation of the...   \n",
       "23    Estimation of the LD1 and Extrapolation of the...   \n",
       "24    Synergism in Pesticide Toxicity (2)  Acute Ora...   \n",
       "25    Combinatory Toxicity of Some Agrochemical and ...   \n",
       "26    Combinatory Toxicity of Some Agrochemicals and...   \n",
       "27    The Role of Nicotine in the Pathogenesis of Pu...   \n",
       "28    Acute Oral Toxicity and Repellency of 933 Chem...   \n",
       "29    Acute Oral Toxicity and Repellency of 933 Chem...   \n",
       "...                                                 ...   \n",
       "1757  Stereochemical Properties and Teratogenic Acti...   \n",
       "1758  Stereochemical Properties and Teratogenic Acti...   \n",
       "1759  Initial Submission:  Acute Toxicity Study with...   \n",
       "1760  Initial Submission:  Acute Toxicity Study with...   \n",
       "1761  Initial Submission:  Acute Toxicity Study with...   \n",
       "1762  Initial Submission:  Acute Toxicity Study with...   \n",
       "1763  Initial Submission:  Acute Toxicity Study with...   \n",
       "1764  Initial Submission:  Acute Toxicity Study with...   \n",
       "1765  Initial Submission:  Acute Toxicity Study with...   \n",
       "1766  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1767  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1768  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1769  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1770  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1771  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1772  Initial Submission:  Acute Toxicity of 2-(N-Et...   \n",
       "1773  Mammalian Toxicity of Aromex and Xylene Used i...   \n",
       "1774  Mammalian Toxicity of Aromex and Xylene Used i...   \n",
       "1775  The Toxicity and Structure of Various Aromatic...   \n",
       "1776  Initial Submission:  Letter from Eli Lilly & C...   \n",
       "1777  Initial Submission: Acute Oral Study of 1H-1,2...   \n",
       "1778  Initial Submission:  Acute Oral LD50 in Rats o...   \n",
       "1779  Initial Submission:  Acute Oral LD50 Study in ...   \n",
       "1780  Pesticide Ecotoxicity Database (Formerly:  Env...   \n",
       "1781  Toxicity of the Anticoagulant Rodenticide Dife...   \n",
       "1782  Pesticide Ecotoxicity Database (Formerly:  Env...   \n",
       "1783  The Role of Vitamin C as Antioxidant in Protec...   \n",
       "1784  Thymoquinone Ameliorates the Immunological and...   \n",
       "1785  Chemical Profile, Antifungal, Antiaflatoxigeni...   \n",
       "1786  Pesticide Ecotoxicity Database (Formerly:  Env...   \n",
       "\n",
       "                                                Source   Publication Year  \\\n",
       "0                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "1                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "2                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "3                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "4                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "5                   Fundam. Appl. Toxicol.4(5): 724-730              1984   \n",
       "6                   Toxicol. Appl. Pharmacol.35:575-580              1976   \n",
       "7                   Toxicol. Appl. Pharmacol.35:575-580              1976   \n",
       "8                   Toxicol. Appl. Pharmacol.35:575-580              1976   \n",
       "9                         Mol. Pharmacol.13(1): 133-141              1977   \n",
       "10                        J. Parasitol.57(5): 1068-1077              1971   \n",
       "11                         Arch. Toxicol.58(3): 152-156              1986   \n",
       "12                        J. Parasitol.57(5): 1068-1077              1971   \n",
       "13                             Arch. Toxicol.34:103-109              1975   \n",
       "14                             Arch. Toxicol.34:103-109              1975   \n",
       "15                             Arch. Toxicol.34:103-109              1975   \n",
       "16                             Arch. Toxicol.34:103-109              1975   \n",
       "17                             Arch. Toxicol.34:103-109              1975   \n",
       "18                             Arch. Toxicol.34:103-109              1975   \n",
       "19                             Arch. Toxicol.34:103-109              1975   \n",
       "20                             Arch. Toxicol.34:103-109              1975   \n",
       "21                J. Med. Soc. Toho Univ.25(4): 635-649              1978   \n",
       "22                             Arch. Toxicol.34:103-109              1975   \n",
       "23                             Arch. Toxicol.34:103-109              1975   \n",
       "24                J. Med. Soc. Toho Univ.25(4): 635-649              1978   \n",
       "25                Fresenius Environ. Bull.4(6): 364-368              1995   \n",
       "26                Fresenius Environ. Bull.2(7): 375-379              1993   \n",
       "27        Am. J. Respir. Crit. Care Med.129(1): 112-117              1984   \n",
       "28        Arch. Environ. Contam. Toxicol.14(1): 111-129              1985   \n",
       "29        Arch. Environ. Contam. Toxicol.14(1): 111-129              1985   \n",
       "...                                                 ...               ...   \n",
       "1757                      Mol. Pharmacol.13(1): 133-141              1977   \n",
       "1758                      Mol. Pharmacol.13(1): 133-141              1977   \n",
       "1759                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1760                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1761                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1762                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1763                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1764                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1765                    EPA/OTS Doc.#88-920002976:53 p.              1992   \n",
       "1766                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1767                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1768                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1769                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1770                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1771                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1772                   EPA/OTS Doc.#88-920003022:126 p.              1992   \n",
       "1773                   Indian J. Exp. Biol.18:1148-1151              1980   \n",
       "1774                   Indian J. Exp. Biol.18:1148-1151              1980   \n",
       "1775                             Fluoride19(3): 117-121              1986   \n",
       "1776                    EPA/OTS Doc.#88-920006224:15 p.              1992   \n",
       "1777                     EPA/OTS Doc.#88-920008027:8 p.              1992   \n",
       "1778                    EPA/OTS Doc.#88-920008035:12 p.              1992   \n",
       "1779                    EPA/OTS Doc.#88-920008071:12 p.              1992   \n",
       "1780  Environmental Fate and Effects Division, U.S.E...              1992   \n",
       "1781                           Crop Prot.12(7): 501-504              1993   \n",
       "1782  Environmental Fate and Effects Division, U.S.E...              1992   \n",
       "1783                  Food Chem. Toxicol.48(1): 215-221              2010   \n",
       "1784                        J. Toxicol. Sci.37(1): 1-11              2012   \n",
       "1785                Food Chem. Toxicol.48(6): 1734-1740              2010   \n",
       "1786  Environmental Fate and Effects Division, U.S.E...              1992   \n",
       "\n",
       "     Unnamed: 65  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  \n",
       "5            NaN  \n",
       "6            NaN  \n",
       "7            NaN  \n",
       "8            NaN  \n",
       "9            NaN  \n",
       "10           NaN  \n",
       "11           NaN  \n",
       "12           NaN  \n",
       "13           NaN  \n",
       "14           NaN  \n",
       "15           NaN  \n",
       "16           NaN  \n",
       "17           NaN  \n",
       "18           NaN  \n",
       "19           NaN  \n",
       "20           NaN  \n",
       "21           NaN  \n",
       "22           NaN  \n",
       "23           NaN  \n",
       "24           NaN  \n",
       "25           NaN  \n",
       "26           NaN  \n",
       "27           NaN  \n",
       "28           NaN  \n",
       "29           NaN  \n",
       "...          ...  \n",
       "1757         NaN  \n",
       "1758         NaN  \n",
       "1759         NaN  \n",
       "1760         NaN  \n",
       "1761         NaN  \n",
       "1762         NaN  \n",
       "1763         NaN  \n",
       "1764         NaN  \n",
       "1765         NaN  \n",
       "1766         NaN  \n",
       "1767         NaN  \n",
       "1768         NaN  \n",
       "1769         NaN  \n",
       "1770         NaN  \n",
       "1771         NaN  \n",
       "1772         NaN  \n",
       "1773         NaN  \n",
       "1774         NaN  \n",
       "1775         NaN  \n",
       "1776         NaN  \n",
       "1777         NaN  \n",
       "1778         NaN  \n",
       "1779         NaN  \n",
       "1780         NaN  \n",
       "1781         NaN  \n",
       "1782         NaN  \n",
       "1783         NaN  \n",
       "1784         NaN  \n",
       "1785         NaN  \n",
       "1786         NaN  \n",
       "\n",
       "[1787 rows x 66 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# frame = pd.DataFrame(df, index = [clusters])\n",
    "# frame['cluster'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}