custom_upload_ to_SCAN.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Custom Upload to SCAN/Symbiota\n",
    "\n",
    "## Adding Specimen Records from the Laird-Hopkin's Seed Predation Study to the UOG Insect Collection Online Catalog (SCAN/Symbiota)\n",
    "\n",
    "This Jupyter notebook prepares a tab separated text file which can be uploaded to \n",
    "the University of Guam insect collection online catalog on the SCAN Symbiota portal.\n",
    "\n",
    "The original test file was a Microsoft Excel spreadsheet containing records for 11 insects collected by\n",
    "Benita Laird-Hopkins during her seed predation study. Prior to importing the data inot this workbook, a couple of minor errors were corrected. 'Drosophila' was changed to 'Drosophilidae', and 'Chryomelidae' was changed to 'Chrysomelidae'.\n",
    "\n",
    "Quite a few fields were not useful. However, to maintain a history of the original data, each record was converted to a JSON text string which was stored in a new field called **dynamicProperties**.\n",
    "\n",
    "In addition to **dynamicProperties**, two additional fields were added:\n",
    "* **catalogNumber**: a random catalog number in the form 'ESUG-Z2MHR5'\n",
    "* **recordedBy**: in this case, a constant, 'Benita Laird-Hopkins'\n",
    "\n",
    "The updated data were written to a tab delimited text file named **benita_test.tab**.  Note that this file can be opened as a spreadsheet by Microsoft Excel or LibreOffice Calc.\n",
    "\n",
    "## Uploading the Data Set to SCAN/Symbiota\n",
    "\n",
    "To add specimen records contained in **benita_test.tab** to the UOG online catalog you will require the totally awesome permissions of an **Administrator**. If you are a member of this caste, follow these steps:\n",
    "\n",
    "1. Open the **Administrative Control Panel**\n",
    "1. Select **Import/Update Specimen Records**\n",
    "1. Select **Full Text File Import**\n",
    "1. Set up field mapping thusly (note that we want to match on **othercatalognumbers**):\n",
    "![alt text](benita_field_map.png \"Title\")\n",
    "1. Click on the **Start Upload** button.\n",
    "\n",
    "## Downloading the Data Set from SCAN/Symbiota\n",
    "\n",
    "This URL will return a Darwin Core Archive (DwCA) for all specimens collected by Benita:\n",
    "http://scan-bugs.org/portal/webservices/dwc/dwcapubhandler.php?cond=recordedby:Benita%20Laird-Hopkins\n",
    "\n",
    "Unzip the DwCA and you will find the data in **occurrences.csv**."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "import string\n",
    "import random"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "infile = \"Database_test_Aubrey-am-edits.xlsx\"\n",
    "outfile = \"benita_test.tab\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(infile)\n",
    "#df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert each row into a JSON string and add this as an additional column 'dynamicProperites'\n",
    "# This column contains all original data fro the spreadsheet and these data\n",
    "# will be store in 'dynamicProperties' Symbiota field when the csv file is uploaded.\n",
    "\n",
    "def doit(row):\n",
    "    return row.to_json()  \n",
    "\n",
    "df['dynamicProperties'] = df.apply(doit, axis=1)\n",
    "#df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add random catalog number in the form 'ESUG-Z2MHR5'\n",
    "\n",
    "def id_generator(size=6, chars=string.ascii_uppercase + string.digits):\n",
    "    return ''.join(random.choice(chars) for _ in range(size))\n",
    "\n",
    "df['catalogNumber'] = df.apply(lambda x:'ESUG-' + id_generator(), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add constants\n",
    "df['recordedBy'] = 'Benita Laird-Hopkins' # = collector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X...Insect.code</th>\n",
       "      <th>Seed.code</th>\n",
       "      <th>Tree.code</th>\n",
       "      <th>Tree.species.code</th>\n",
       "      <th>Date.emerged..for.R.only..DD.MM.YY.</th>\n",
       "      <th>Insect.species.code</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Subfamily</th>\n",
       "      <th>Genus</th>\n",
       "      <th>...</th>\n",
       "      <th>Date.adult.from.soil</th>\n",
       "      <th>Insect.found.in.dissected.seed.after.3.months..Y.yes.N.no</th>\n",
       "      <th>Date.seed.dissected</th>\n",
       "      <th>No..of.fruits.with.signs.of.insect.predation.when.dissected</th>\n",
       "      <th>Comments</th>\n",
       "      <th>Date.entered..DD.MM.YYYY.</th>\n",
       "      <th>Entered.by</th>\n",
       "      <th>dynamicProperties</th>\n",
       "      <th>catalogNumber</th>\n",
       "      <th>recordedBy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>INSECTSAI_0195</td>\n",
       "      <td>SEEDSAI_0083</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-10-02</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0195\",\"Seed.code...</td>\n",
       "      <td>ESUG-DUZ6KW</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>INSECTSAI_0196</td>\n",
       "      <td>SEEDSAI_0083</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-10-02</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0196\",\"Seed.code...</td>\n",
       "      <td>ESUG-DUIRUA</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>INSECTSAI_0197</td>\n",
       "      <td>SEEDSAI_0087</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0197\",\"Seed.code...</td>\n",
       "      <td>ESUG-HNYSZU</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>INSECTSAI_0198</td>\n",
       "      <td>SEEDSAI_0087</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0198\",\"Seed.code...</td>\n",
       "      <td>ESUG-G85QRY</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>INSECTSAI_0199</td>\n",
       "      <td>SEEDSAI_0087</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0199\",\"Seed.code...</td>\n",
       "      <td>ESUG-4Z90KD</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>INSECTSAI_0200</td>\n",
       "      <td>SEEDSAI_0087</td>\n",
       "      <td>TREESAI_0045</td>\n",
       "      <td>FICUTI</td>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>DROSP3</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Drosophilidae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0200\",\"Seed.code...</td>\n",
       "      <td>ESUG-GEWXTH</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>INSECTSAI_0201</td>\n",
       "      <td>SEEDSAI_0180</td>\n",
       "      <td>TREESAI_0105</td>\n",
       "      <td>LEUCLE</td>\n",
       "      <td>2017-10-24</td>\n",
       "      <td>BRUSP1</td>\n",
       "      <td>Coleoptera</td>\n",
       "      <td>Chrysomelidae</td>\n",
       "      <td>Bruchinae</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THIS TREE AND TREES AROUND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0201\",\"Seed.code...</td>\n",
       "      <td>ESUG-H6HCLY</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>INSECTSAI_0202</td>\n",
       "      <td>SEEDSAI_0136</td>\n",
       "      <td>TREESAI_0076</td>\n",
       "      <td>OCHRMA</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>BACOC</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Tephritidae</td>\n",
       "      <td>Dacinae</td>\n",
       "      <td>Bactrocera</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0202\",\"Seed.code...</td>\n",
       "      <td>ESUG-ANZJ2W</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>INSECTSAI_0203</td>\n",
       "      <td>SEEDSAI_0136</td>\n",
       "      <td>TREESAI_0076</td>\n",
       "      <td>OCHRMA</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>BACOC</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Tephritidae</td>\n",
       "      <td>Dacinae</td>\n",
       "      <td>Bactrocera</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0203\",\"Seed.code...</td>\n",
       "      <td>ESUG-PE8UEJ</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>INSECTSAI_0204</td>\n",
       "      <td>SEEDSAI_0136</td>\n",
       "      <td>TREESAI_0076</td>\n",
       "      <td>OCHRMA</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>BACOC</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Tephritidae</td>\n",
       "      <td>Dacinae</td>\n",
       "      <td>Bactrocera</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0204\",\"Seed.code...</td>\n",
       "      <td>ESUG-R1U120</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>INSECTSAI_0205</td>\n",
       "      <td>SEEDSAI_0136</td>\n",
       "      <td>TREESAI_0076</td>\n",
       "      <td>OCHRMA</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>BACOC</td>\n",
       "      <td>Diptera</td>\n",
       "      <td>Tephritidae</td>\n",
       "      <td>Dacinae</td>\n",
       "      <td>Bactrocera</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{\"X...Insect.code\":\"INSECTSAI_0205\",\"Seed.code...</td>\n",
       "      <td>ESUG-WRT35N</td>\n",
       "      <td>Benita Laird-Hopkins</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   X...Insect.code     Seed.code     Tree.code Tree.species.code  \\\n",
       "0   INSECTSAI_0195  SEEDSAI_0083  TREESAI_0045            FICUTI   \n",
       "1   INSECTSAI_0196  SEEDSAI_0083  TREESAI_0045            FICUTI   \n",
       "2   INSECTSAI_0197  SEEDSAI_0087  TREESAI_0045            FICUTI   \n",
       "3   INSECTSAI_0198  SEEDSAI_0087  TREESAI_0045            FICUTI   \n",
       "4   INSECTSAI_0199  SEEDSAI_0087  TREESAI_0045            FICUTI   \n",
       "5   INSECTSAI_0200  SEEDSAI_0087  TREESAI_0045            FICUTI   \n",
       "6   INSECTSAI_0201  SEEDSAI_0180  TREESAI_0105            LEUCLE   \n",
       "7   INSECTSAI_0202  SEEDSAI_0136  TREESAI_0076            OCHRMA   \n",
       "8   INSECTSAI_0203  SEEDSAI_0136  TREESAI_0076            OCHRMA   \n",
       "9   INSECTSAI_0204  SEEDSAI_0136  TREESAI_0076            OCHRMA   \n",
       "10  INSECTSAI_0205  SEEDSAI_0136  TREESAI_0076            OCHRMA   \n",
       "\n",
       "   Date.emerged..for.R.only..DD.MM.YY. Insect.species.code       Order  \\\n",
       "0                           2017-10-02              DROSP3     Diptera   \n",
       "1                           2017-10-02              DROSP3     Diptera   \n",
       "2                           2017-09-27              DROSP3     Diptera   \n",
       "3                           2017-09-27              DROSP3     Diptera   \n",
       "4                           2017-09-27              DROSP3     Diptera   \n",
       "5                           2017-09-27              DROSP3     Diptera   \n",
       "6                           2017-10-24              BRUSP1  Coleoptera   \n",
       "7                           2017-10-10               BACOC     Diptera   \n",
       "8                           2017-10-10               BACOC     Diptera   \n",
       "9                           2017-10-10               BACOC     Diptera   \n",
       "10                          2017-10-10               BACOC     Diptera   \n",
       "\n",
       "           Family  Subfamily       Genus          ...           \\\n",
       "0   Drosophilidae    Unknown     Unknown          ...            \n",
       "1   Drosophilidae    Unknown     Unknown          ...            \n",
       "2   Drosophilidae    Unknown     Unknown          ...            \n",
       "3   Drosophilidae    Unknown     Unknown          ...            \n",
       "4   Drosophilidae    Unknown     Unknown          ...            \n",
       "5   Drosophilidae    Unknown     Unknown          ...            \n",
       "6   Chrysomelidae  Bruchinae     Unknown          ...            \n",
       "7     Tephritidae    Dacinae  Bactrocera          ...            \n",
       "8     Tephritidae    Dacinae  Bactrocera          ...            \n",
       "9     Tephritidae    Dacinae  Bactrocera          ...            \n",
       "10    Tephritidae    Dacinae  Bactrocera          ...            \n",
       "\n",
       "   Date.adult.from.soil  \\\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",
       "\n",
       "   Insect.found.in.dissected.seed.after.3.months..Y.yes.N.no  \\\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",
       "\n",
       "   Date.seed.dissected  \\\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",
       "\n",
       "   No..of.fruits.with.signs.of.insect.predation.when.dissected  \\\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",
       "\n",
       "                      Comments  Date.entered..DD.MM.YYYY.  Entered.by  \\\n",
       "0                          NaN                        NaN         NaN   \n",
       "1                          NaN                        NaN         NaN   \n",
       "2                          NaN                        NaN         NaN   \n",
       "3                          NaN                        NaN         NaN   \n",
       "4                          NaN                        NaN         NaN   \n",
       "5                          NaN                        NaN         NaN   \n",
       "6   THIS TREE AND TREES AROUND                        NaN         NaN   \n",
       "7                          NaN                        NaN         NaN   \n",
       "8                          NaN                        NaN         NaN   \n",
       "9                          NaN                        NaN         NaN   \n",
       "10                         NaN                        NaN         NaN   \n",
       "\n",
       "                                    dynamicProperties  catalogNumber  \\\n",
       "0   {\"X...Insect.code\":\"INSECTSAI_0195\",\"Seed.code...    ESUG-DUZ6KW   \n",
       "1   {\"X...Insect.code\":\"INSECTSAI_0196\",\"Seed.code...    ESUG-DUIRUA   \n",
       "2   {\"X...Insect.code\":\"INSECTSAI_0197\",\"Seed.code...    ESUG-HNYSZU   \n",
       "3   {\"X...Insect.code\":\"INSECTSAI_0198\",\"Seed.code...    ESUG-G85QRY   \n",
       "4   {\"X...Insect.code\":\"INSECTSAI_0199\",\"Seed.code...    ESUG-4Z90KD   \n",
       "5   {\"X...Insect.code\":\"INSECTSAI_0200\",\"Seed.code...    ESUG-GEWXTH   \n",
       "6   {\"X...Insect.code\":\"INSECTSAI_0201\",\"Seed.code...    ESUG-H6HCLY   \n",
       "7   {\"X...Insect.code\":\"INSECTSAI_0202\",\"Seed.code...    ESUG-ANZJ2W   \n",
       "8   {\"X...Insect.code\":\"INSECTSAI_0203\",\"Seed.code...    ESUG-PE8UEJ   \n",
       "9   {\"X...Insect.code\":\"INSECTSAI_0204\",\"Seed.code...    ESUG-R1U120   \n",
       "10  {\"X...Insect.code\":\"INSECTSAI_0205\",\"Seed.code...    ESUG-WRT35N   \n",
       "\n",
       "              recordedBy  \n",
       "0   Benita Laird-Hopkins  \n",
       "1   Benita Laird-Hopkins  \n",
       "2   Benita Laird-Hopkins  \n",
       "3   Benita Laird-Hopkins  \n",
       "4   Benita Laird-Hopkins  \n",
       "5   Benita Laird-Hopkins  \n",
       "6   Benita Laird-Hopkins  \n",
       "7   Benita Laird-Hopkins  \n",
       "8   Benita Laird-Hopkins  \n",
       "9   Benita Laird-Hopkins  \n",
       "10  Benita Laird-Hopkins  \n",
       "\n",
       "[11 rows x 42 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Save the dataframe as a tab delimited text file\n",
    "df.to_csv(outfile, sep='\\t', index=False)\n",
    "df"
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}