LucerneValidation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3\n",
    "import datetime\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import statsmodels.api as sm\n",
    "from statsmodels.formula.api import ols\n",
    "import MathsUtilities as MUte\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "Colors = ['darkblue',           \n",
    "'darkcyan',           \n",
    "'darkgoldenrod',      \n",
    "'darkgray',           \n",
    "'darkgreen',          \n",
    "'darkkhaki',          \n",
    "'darkmagenta',        \n",
    "'darkolivegreen',     \n",
    "'darkorange',         \n",
    "'darkorchid',         \n",
    "'darkred',            \n",
    "'darkviolet',\n",
    "'blue',           \n",
    "'cyan',           \n",
    "'goldenrod',      \n",
    "'gray',           \n",
    "'green',\n",
    "'black']\n",
    "Markers = ['o','s','^']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "con = sqlite3.connect('C:\\GitHubRepos\\ApsimX\\Prototypes\\Lucerne/LucerneValidation.db')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "PredictedObserved = pd.read_sql(\"Select * from PredictedObserved\",\n",
    "                        con)\n",
    "#PredictedObserved.set_index(['SimulationID','Clock.Today'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "Report = pd.read_sql(\"Select * from Report\", con)\n",
    "Report.set_index(['SimulationID','Clock.Today'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['CheckpointID', 'Observed.CheckpointID', 'Predicted.CheckpointID',\n",
       "       'SimulationID', 'Clock.Today', 'Observed.SWC', 'Predicted.SWC',\n",
       "       'Observed.StemWt', 'Predicted.StemWt', 'Pred-Obs.StemWt',\n",
       "       'Observed.LeafWt', 'Predicted.LeafWt', 'Pred-Obs.LeafWt',\n",
       "       'Observed.RootWt', 'Predicted.RootWt', 'Pred-Obs.RootWt', 'Observed.ET',\n",
       "       'Predicted.ET', 'Pred-Obs.ET', 'LAI', 'Observed.Height',\n",
       "       'Predicted.Height', 'Pred-Obs.Height'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PredictedObserved.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "Factors = pd.read_sql(\"Select * from _Factors\",\n",
    "                        con)\n",
    "ValidationIndex = Factors.drop_duplicates(subset=['SimulationName']).loc[:,Factors.columns.isin(['SimulationID','ExperimentName','SimulatinName','FolderName'])]\n",
    "Experiments = ValidationIndex.ExperimentName.drop_duplicates().tolist()\n",
    "Folders = ValidationIndex.FolderName.drop_duplicates().tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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></th>\n",
       "      <th>CheckpointID</th>\n",
       "      <th>Defoliation</th>\n",
       "      <th>Zone</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumPlantN</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumMineralisation</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumDenit</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumFert</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumLeach</th>\n",
       "      <th>DiagnosticsVariables.Script.AccumDetach</th>\n",
       "      <th>DiagnosticsVariables.Script.DeltaSoilOMN</th>\n",
       "      <th>...</th>\n",
       "      <th>Lucerne.Leaf.SenLAI.Value()</th>\n",
       "      <th>Lucerne.Leaf.DeltaPotentialLAI.Value()</th>\n",
       "      <th>Lucerne.Shell.PodNumber.Value()</th>\n",
       "      <th>Soil.OutputLayers.SWmm</th>\n",
       "      <th>Soil.OutputLayers.SW</th>\n",
       "      <th>LL</th>\n",
       "      <th>SS</th>\n",
       "      <th>Cutting</th>\n",
       "      <th>Weather.DaysSinceWinterSolstice</th>\n",
       "      <th>Lucerne.Phenology.DaysAfterCutting</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SimulationID</th>\n",
       "      <th>Clock.Today</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">4</th>\n",
       "      <th>2000-11-14 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-15 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-16 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-17 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-18 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-19 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-20 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-21 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-22 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-23 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-24 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-25 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-26 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-27 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-28 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-29 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-11-30 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-01 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-02 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-03 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-04 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-05 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-06 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-07 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-08 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-09 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-10 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-11 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-12 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-13 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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 rowspan=\"30\" valign=\"top\">57</th>\n",
       "      <th>1999-12-02 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-03 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-04 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-05 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-06 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-07 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-08 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-09 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-10 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-11 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-12 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-13 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-14 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-15 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-16 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-17 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-18 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-19 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-20 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-21 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-22 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-23 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-24 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-25 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-26 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-27 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-28 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-29 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-30 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-31 12:00:00</th>\n",
       "      <td>1</td>\n",
       "      <td>Cutting</td>\n",
       "      <td>paddock</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115430 rows × 256 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  CheckpointID Defoliation     Zone  \\\n",
       "SimulationID Clock.Today                                              \n",
       "4            2000-11-14 12:00:00             1        None  paddock   \n",
       "             2000-11-15 12:00:00             1        None  paddock   \n",
       "             2000-11-16 12:00:00             1        None  paddock   \n",
       "             2000-11-17 12:00:00             1        None  paddock   \n",
       "             2000-11-18 12:00:00             1        None  paddock   \n",
       "             2000-11-19 12:00:00             1        None  paddock   \n",
       "             2000-11-20 12:00:00             1        None  paddock   \n",
       "             2000-11-21 12:00:00             1        None  paddock   \n",
       "             2000-11-22 12:00:00             1        None  paddock   \n",
       "             2000-11-23 12:00:00             1        None  paddock   \n",
       "             2000-11-24 12:00:00             1        None  paddock   \n",
       "             2000-11-25 12:00:00             1        None  paddock   \n",
       "             2000-11-26 12:00:00             1        None  paddock   \n",
       "             2000-11-27 12:00:00             1        None  paddock   \n",
       "             2000-11-28 12:00:00             1        None  paddock   \n",
       "             2000-11-29 12:00:00             1        None  paddock   \n",
       "             2000-11-30 12:00:00             1        None  paddock   \n",
       "             2000-12-01 12:00:00             1        None  paddock   \n",
       "             2000-12-02 12:00:00             1        None  paddock   \n",
       "             2000-12-03 12:00:00             1        None  paddock   \n",
       "             2000-12-04 12:00:00             1        None  paddock   \n",
       "             2000-12-05 12:00:00             1        None  paddock   \n",
       "             2000-12-06 12:00:00             1        None  paddock   \n",
       "             2000-12-07 12:00:00             1        None  paddock   \n",
       "             2000-12-08 12:00:00             1        None  paddock   \n",
       "             2000-12-09 12:00:00             1        None  paddock   \n",
       "             2000-12-10 12:00:00             1        None  paddock   \n",
       "             2000-12-11 12:00:00             1        None  paddock   \n",
       "             2000-12-12 12:00:00             1        None  paddock   \n",
       "             2000-12-13 12:00:00             1        None  paddock   \n",
       "...                                        ...         ...      ...   \n",
       "57           1999-12-02 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-03 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-04 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-05 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-06 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-07 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-08 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-09 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-10 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-11 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-12 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-13 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-14 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-15 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-16 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-17 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-18 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-19 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-20 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-21 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-22 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-23 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-24 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-25 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-26 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-27 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-28 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-29 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-30 12:00:00             1     Cutting  paddock   \n",
       "             1999-12-31 12:00:00             1     Cutting  paddock   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumPlantN  \\\n",
       "SimulationID Clock.Today                                                   \n",
       "4            2000-11-14 12:00:00                                    None   \n",
       "             2000-11-15 12:00:00                                    None   \n",
       "             2000-11-16 12:00:00                                    None   \n",
       "             2000-11-17 12:00:00                                    None   \n",
       "             2000-11-18 12:00:00                                    None   \n",
       "             2000-11-19 12:00:00                                    None   \n",
       "             2000-11-20 12:00:00                                    None   \n",
       "             2000-11-21 12:00:00                                    None   \n",
       "             2000-11-22 12:00:00                                    None   \n",
       "             2000-11-23 12:00:00                                    None   \n",
       "             2000-11-24 12:00:00                                    None   \n",
       "             2000-11-25 12:00:00                                    None   \n",
       "             2000-11-26 12:00:00                                    None   \n",
       "             2000-11-27 12:00:00                                    None   \n",
       "             2000-11-28 12:00:00                                    None   \n",
       "             2000-11-29 12:00:00                                    None   \n",
       "             2000-11-30 12:00:00                                    None   \n",
       "             2000-12-01 12:00:00                                    None   \n",
       "             2000-12-02 12:00:00                                    None   \n",
       "             2000-12-03 12:00:00                                    None   \n",
       "             2000-12-04 12:00:00                                    None   \n",
       "             2000-12-05 12:00:00                                    None   \n",
       "             2000-12-06 12:00:00                                    None   \n",
       "             2000-12-07 12:00:00                                    None   \n",
       "             2000-12-08 12:00:00                                    None   \n",
       "             2000-12-09 12:00:00                                    None   \n",
       "             2000-12-10 12:00:00                                    None   \n",
       "             2000-12-11 12:00:00                                    None   \n",
       "             2000-12-12 12:00:00                                    None   \n",
       "             2000-12-13 12:00:00                                    None   \n",
       "...                                                                  ...   \n",
       "57           1999-12-02 12:00:00                                    None   \n",
       "             1999-12-03 12:00:00                                    None   \n",
       "             1999-12-04 12:00:00                                    None   \n",
       "             1999-12-05 12:00:00                                    None   \n",
       "             1999-12-06 12:00:00                                    None   \n",
       "             1999-12-07 12:00:00                                    None   \n",
       "             1999-12-08 12:00:00                                    None   \n",
       "             1999-12-09 12:00:00                                    None   \n",
       "             1999-12-10 12:00:00                                    None   \n",
       "             1999-12-11 12:00:00                                    None   \n",
       "             1999-12-12 12:00:00                                    None   \n",
       "             1999-12-13 12:00:00                                    None   \n",
       "             1999-12-14 12:00:00                                    None   \n",
       "             1999-12-15 12:00:00                                    None   \n",
       "             1999-12-16 12:00:00                                    None   \n",
       "             1999-12-17 12:00:00                                    None   \n",
       "             1999-12-18 12:00:00                                    None   \n",
       "             1999-12-19 12:00:00                                    None   \n",
       "             1999-12-20 12:00:00                                    None   \n",
       "             1999-12-21 12:00:00                                    None   \n",
       "             1999-12-22 12:00:00                                    None   \n",
       "             1999-12-23 12:00:00                                    None   \n",
       "             1999-12-24 12:00:00                                    None   \n",
       "             1999-12-25 12:00:00                                    None   \n",
       "             1999-12-26 12:00:00                                    None   \n",
       "             1999-12-27 12:00:00                                    None   \n",
       "             1999-12-28 12:00:00                                    None   \n",
       "             1999-12-29 12:00:00                                    None   \n",
       "             1999-12-30 12:00:00                                    None   \n",
       "             1999-12-31 12:00:00                                    None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumMineralisation  \\\n",
       "SimulationID Clock.Today                                                           \n",
       "4            2000-11-14 12:00:00                                            None   \n",
       "             2000-11-15 12:00:00                                            None   \n",
       "             2000-11-16 12:00:00                                            None   \n",
       "             2000-11-17 12:00:00                                            None   \n",
       "             2000-11-18 12:00:00                                            None   \n",
       "             2000-11-19 12:00:00                                            None   \n",
       "             2000-11-20 12:00:00                                            None   \n",
       "             2000-11-21 12:00:00                                            None   \n",
       "             2000-11-22 12:00:00                                            None   \n",
       "             2000-11-23 12:00:00                                            None   \n",
       "             2000-11-24 12:00:00                                            None   \n",
       "             2000-11-25 12:00:00                                            None   \n",
       "             2000-11-26 12:00:00                                            None   \n",
       "             2000-11-27 12:00:00                                            None   \n",
       "             2000-11-28 12:00:00                                            None   \n",
       "             2000-11-29 12:00:00                                            None   \n",
       "             2000-11-30 12:00:00                                            None   \n",
       "             2000-12-01 12:00:00                                            None   \n",
       "             2000-12-02 12:00:00                                            None   \n",
       "             2000-12-03 12:00:00                                            None   \n",
       "             2000-12-04 12:00:00                                            None   \n",
       "             2000-12-05 12:00:00                                            None   \n",
       "             2000-12-06 12:00:00                                            None   \n",
       "             2000-12-07 12:00:00                                            None   \n",
       "             2000-12-08 12:00:00                                            None   \n",
       "             2000-12-09 12:00:00                                            None   \n",
       "             2000-12-10 12:00:00                                            None   \n",
       "             2000-12-11 12:00:00                                            None   \n",
       "             2000-12-12 12:00:00                                            None   \n",
       "             2000-12-13 12:00:00                                            None   \n",
       "...                                                                          ...   \n",
       "57           1999-12-02 12:00:00                                            None   \n",
       "             1999-12-03 12:00:00                                            None   \n",
       "             1999-12-04 12:00:00                                            None   \n",
       "             1999-12-05 12:00:00                                            None   \n",
       "             1999-12-06 12:00:00                                            None   \n",
       "             1999-12-07 12:00:00                                            None   \n",
       "             1999-12-08 12:00:00                                            None   \n",
       "             1999-12-09 12:00:00                                            None   \n",
       "             1999-12-10 12:00:00                                            None   \n",
       "             1999-12-11 12:00:00                                            None   \n",
       "             1999-12-12 12:00:00                                            None   \n",
       "             1999-12-13 12:00:00                                            None   \n",
       "             1999-12-14 12:00:00                                            None   \n",
       "             1999-12-15 12:00:00                                            None   \n",
       "             1999-12-16 12:00:00                                            None   \n",
       "             1999-12-17 12:00:00                                            None   \n",
       "             1999-12-18 12:00:00                                            None   \n",
       "             1999-12-19 12:00:00                                            None   \n",
       "             1999-12-20 12:00:00                                            None   \n",
       "             1999-12-21 12:00:00                                            None   \n",
       "             1999-12-22 12:00:00                                            None   \n",
       "             1999-12-23 12:00:00                                            None   \n",
       "             1999-12-24 12:00:00                                            None   \n",
       "             1999-12-25 12:00:00                                            None   \n",
       "             1999-12-26 12:00:00                                            None   \n",
       "             1999-12-27 12:00:00                                            None   \n",
       "             1999-12-28 12:00:00                                            None   \n",
       "             1999-12-29 12:00:00                                            None   \n",
       "             1999-12-30 12:00:00                                            None   \n",
       "             1999-12-31 12:00:00                                            None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumDenit  \\\n",
       "SimulationID Clock.Today                                                  \n",
       "4            2000-11-14 12:00:00                                   None   \n",
       "             2000-11-15 12:00:00                                   None   \n",
       "             2000-11-16 12:00:00                                   None   \n",
       "             2000-11-17 12:00:00                                   None   \n",
       "             2000-11-18 12:00:00                                   None   \n",
       "             2000-11-19 12:00:00                                   None   \n",
       "             2000-11-20 12:00:00                                   None   \n",
       "             2000-11-21 12:00:00                                   None   \n",
       "             2000-11-22 12:00:00                                   None   \n",
       "             2000-11-23 12:00:00                                   None   \n",
       "             2000-11-24 12:00:00                                   None   \n",
       "             2000-11-25 12:00:00                                   None   \n",
       "             2000-11-26 12:00:00                                   None   \n",
       "             2000-11-27 12:00:00                                   None   \n",
       "             2000-11-28 12:00:00                                   None   \n",
       "             2000-11-29 12:00:00                                   None   \n",
       "             2000-11-30 12:00:00                                   None   \n",
       "             2000-12-01 12:00:00                                   None   \n",
       "             2000-12-02 12:00:00                                   None   \n",
       "             2000-12-03 12:00:00                                   None   \n",
       "             2000-12-04 12:00:00                                   None   \n",
       "             2000-12-05 12:00:00                                   None   \n",
       "             2000-12-06 12:00:00                                   None   \n",
       "             2000-12-07 12:00:00                                   None   \n",
       "             2000-12-08 12:00:00                                   None   \n",
       "             2000-12-09 12:00:00                                   None   \n",
       "             2000-12-10 12:00:00                                   None   \n",
       "             2000-12-11 12:00:00                                   None   \n",
       "             2000-12-12 12:00:00                                   None   \n",
       "             2000-12-13 12:00:00                                   None   \n",
       "...                                                                 ...   \n",
       "57           1999-12-02 12:00:00                                   None   \n",
       "             1999-12-03 12:00:00                                   None   \n",
       "             1999-12-04 12:00:00                                   None   \n",
       "             1999-12-05 12:00:00                                   None   \n",
       "             1999-12-06 12:00:00                                   None   \n",
       "             1999-12-07 12:00:00                                   None   \n",
       "             1999-12-08 12:00:00                                   None   \n",
       "             1999-12-09 12:00:00                                   None   \n",
       "             1999-12-10 12:00:00                                   None   \n",
       "             1999-12-11 12:00:00                                   None   \n",
       "             1999-12-12 12:00:00                                   None   \n",
       "             1999-12-13 12:00:00                                   None   \n",
       "             1999-12-14 12:00:00                                   None   \n",
       "             1999-12-15 12:00:00                                   None   \n",
       "             1999-12-16 12:00:00                                   None   \n",
       "             1999-12-17 12:00:00                                   None   \n",
       "             1999-12-18 12:00:00                                   None   \n",
       "             1999-12-19 12:00:00                                   None   \n",
       "             1999-12-20 12:00:00                                   None   \n",
       "             1999-12-21 12:00:00                                   None   \n",
       "             1999-12-22 12:00:00                                   None   \n",
       "             1999-12-23 12:00:00                                   None   \n",
       "             1999-12-24 12:00:00                                   None   \n",
       "             1999-12-25 12:00:00                                   None   \n",
       "             1999-12-26 12:00:00                                   None   \n",
       "             1999-12-27 12:00:00                                   None   \n",
       "             1999-12-28 12:00:00                                   None   \n",
       "             1999-12-29 12:00:00                                   None   \n",
       "             1999-12-30 12:00:00                                   None   \n",
       "             1999-12-31 12:00:00                                   None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumFert  \\\n",
       "SimulationID Clock.Today                                                 \n",
       "4            2000-11-14 12:00:00                                  None   \n",
       "             2000-11-15 12:00:00                                  None   \n",
       "             2000-11-16 12:00:00                                  None   \n",
       "             2000-11-17 12:00:00                                  None   \n",
       "             2000-11-18 12:00:00                                  None   \n",
       "             2000-11-19 12:00:00                                  None   \n",
       "             2000-11-20 12:00:00                                  None   \n",
       "             2000-11-21 12:00:00                                  None   \n",
       "             2000-11-22 12:00:00                                  None   \n",
       "             2000-11-23 12:00:00                                  None   \n",
       "             2000-11-24 12:00:00                                  None   \n",
       "             2000-11-25 12:00:00                                  None   \n",
       "             2000-11-26 12:00:00                                  None   \n",
       "             2000-11-27 12:00:00                                  None   \n",
       "             2000-11-28 12:00:00                                  None   \n",
       "             2000-11-29 12:00:00                                  None   \n",
       "             2000-11-30 12:00:00                                  None   \n",
       "             2000-12-01 12:00:00                                  None   \n",
       "             2000-12-02 12:00:00                                  None   \n",
       "             2000-12-03 12:00:00                                  None   \n",
       "             2000-12-04 12:00:00                                  None   \n",
       "             2000-12-05 12:00:00                                  None   \n",
       "             2000-12-06 12:00:00                                  None   \n",
       "             2000-12-07 12:00:00                                  None   \n",
       "             2000-12-08 12:00:00                                  None   \n",
       "             2000-12-09 12:00:00                                  None   \n",
       "             2000-12-10 12:00:00                                  None   \n",
       "             2000-12-11 12:00:00                                  None   \n",
       "             2000-12-12 12:00:00                                  None   \n",
       "             2000-12-13 12:00:00                                  None   \n",
       "...                                                                ...   \n",
       "57           1999-12-02 12:00:00                                  None   \n",
       "             1999-12-03 12:00:00                                  None   \n",
       "             1999-12-04 12:00:00                                  None   \n",
       "             1999-12-05 12:00:00                                  None   \n",
       "             1999-12-06 12:00:00                                  None   \n",
       "             1999-12-07 12:00:00                                  None   \n",
       "             1999-12-08 12:00:00                                  None   \n",
       "             1999-12-09 12:00:00                                  None   \n",
       "             1999-12-10 12:00:00                                  None   \n",
       "             1999-12-11 12:00:00                                  None   \n",
       "             1999-12-12 12:00:00                                  None   \n",
       "             1999-12-13 12:00:00                                  None   \n",
       "             1999-12-14 12:00:00                                  None   \n",
       "             1999-12-15 12:00:00                                  None   \n",
       "             1999-12-16 12:00:00                                  None   \n",
       "             1999-12-17 12:00:00                                  None   \n",
       "             1999-12-18 12:00:00                                  None   \n",
       "             1999-12-19 12:00:00                                  None   \n",
       "             1999-12-20 12:00:00                                  None   \n",
       "             1999-12-21 12:00:00                                  None   \n",
       "             1999-12-22 12:00:00                                  None   \n",
       "             1999-12-23 12:00:00                                  None   \n",
       "             1999-12-24 12:00:00                                  None   \n",
       "             1999-12-25 12:00:00                                  None   \n",
       "             1999-12-26 12:00:00                                  None   \n",
       "             1999-12-27 12:00:00                                  None   \n",
       "             1999-12-28 12:00:00                                  None   \n",
       "             1999-12-29 12:00:00                                  None   \n",
       "             1999-12-30 12:00:00                                  None   \n",
       "             1999-12-31 12:00:00                                  None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumLeach  \\\n",
       "SimulationID Clock.Today                                                  \n",
       "4            2000-11-14 12:00:00                                   None   \n",
       "             2000-11-15 12:00:00                                   None   \n",
       "             2000-11-16 12:00:00                                   None   \n",
       "             2000-11-17 12:00:00                                   None   \n",
       "             2000-11-18 12:00:00                                   None   \n",
       "             2000-11-19 12:00:00                                   None   \n",
       "             2000-11-20 12:00:00                                   None   \n",
       "             2000-11-21 12:00:00                                   None   \n",
       "             2000-11-22 12:00:00                                   None   \n",
       "             2000-11-23 12:00:00                                   None   \n",
       "             2000-11-24 12:00:00                                   None   \n",
       "             2000-11-25 12:00:00                                   None   \n",
       "             2000-11-26 12:00:00                                   None   \n",
       "             2000-11-27 12:00:00                                   None   \n",
       "             2000-11-28 12:00:00                                   None   \n",
       "             2000-11-29 12:00:00                                   None   \n",
       "             2000-11-30 12:00:00                                   None   \n",
       "             2000-12-01 12:00:00                                   None   \n",
       "             2000-12-02 12:00:00                                   None   \n",
       "             2000-12-03 12:00:00                                   None   \n",
       "             2000-12-04 12:00:00                                   None   \n",
       "             2000-12-05 12:00:00                                   None   \n",
       "             2000-12-06 12:00:00                                   None   \n",
       "             2000-12-07 12:00:00                                   None   \n",
       "             2000-12-08 12:00:00                                   None   \n",
       "             2000-12-09 12:00:00                                   None   \n",
       "             2000-12-10 12:00:00                                   None   \n",
       "             2000-12-11 12:00:00                                   None   \n",
       "             2000-12-12 12:00:00                                   None   \n",
       "             2000-12-13 12:00:00                                   None   \n",
       "...                                                                 ...   \n",
       "57           1999-12-02 12:00:00                                   None   \n",
       "             1999-12-03 12:00:00                                   None   \n",
       "             1999-12-04 12:00:00                                   None   \n",
       "             1999-12-05 12:00:00                                   None   \n",
       "             1999-12-06 12:00:00                                   None   \n",
       "             1999-12-07 12:00:00                                   None   \n",
       "             1999-12-08 12:00:00                                   None   \n",
       "             1999-12-09 12:00:00                                   None   \n",
       "             1999-12-10 12:00:00                                   None   \n",
       "             1999-12-11 12:00:00                                   None   \n",
       "             1999-12-12 12:00:00                                   None   \n",
       "             1999-12-13 12:00:00                                   None   \n",
       "             1999-12-14 12:00:00                                   None   \n",
       "             1999-12-15 12:00:00                                   None   \n",
       "             1999-12-16 12:00:00                                   None   \n",
       "             1999-12-17 12:00:00                                   None   \n",
       "             1999-12-18 12:00:00                                   None   \n",
       "             1999-12-19 12:00:00                                   None   \n",
       "             1999-12-20 12:00:00                                   None   \n",
       "             1999-12-21 12:00:00                                   None   \n",
       "             1999-12-22 12:00:00                                   None   \n",
       "             1999-12-23 12:00:00                                   None   \n",
       "             1999-12-24 12:00:00                                   None   \n",
       "             1999-12-25 12:00:00                                   None   \n",
       "             1999-12-26 12:00:00                                   None   \n",
       "             1999-12-27 12:00:00                                   None   \n",
       "             1999-12-28 12:00:00                                   None   \n",
       "             1999-12-29 12:00:00                                   None   \n",
       "             1999-12-30 12:00:00                                   None   \n",
       "             1999-12-31 12:00:00                                   None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.AccumDetach  \\\n",
       "SimulationID Clock.Today                                                   \n",
       "4            2000-11-14 12:00:00                                    None   \n",
       "             2000-11-15 12:00:00                                    None   \n",
       "             2000-11-16 12:00:00                                    None   \n",
       "             2000-11-17 12:00:00                                    None   \n",
       "             2000-11-18 12:00:00                                    None   \n",
       "             2000-11-19 12:00:00                                    None   \n",
       "             2000-11-20 12:00:00                                    None   \n",
       "             2000-11-21 12:00:00                                    None   \n",
       "             2000-11-22 12:00:00                                    None   \n",
       "             2000-11-23 12:00:00                                    None   \n",
       "             2000-11-24 12:00:00                                    None   \n",
       "             2000-11-25 12:00:00                                    None   \n",
       "             2000-11-26 12:00:00                                    None   \n",
       "             2000-11-27 12:00:00                                    None   \n",
       "             2000-11-28 12:00:00                                    None   \n",
       "             2000-11-29 12:00:00                                    None   \n",
       "             2000-11-30 12:00:00                                    None   \n",
       "             2000-12-01 12:00:00                                    None   \n",
       "             2000-12-02 12:00:00                                    None   \n",
       "             2000-12-03 12:00:00                                    None   \n",
       "             2000-12-04 12:00:00                                    None   \n",
       "             2000-12-05 12:00:00                                    None   \n",
       "             2000-12-06 12:00:00                                    None   \n",
       "             2000-12-07 12:00:00                                    None   \n",
       "             2000-12-08 12:00:00                                    None   \n",
       "             2000-12-09 12:00:00                                    None   \n",
       "             2000-12-10 12:00:00                                    None   \n",
       "             2000-12-11 12:00:00                                    None   \n",
       "             2000-12-12 12:00:00                                    None   \n",
       "             2000-12-13 12:00:00                                    None   \n",
       "...                                                                  ...   \n",
       "57           1999-12-02 12:00:00                                    None   \n",
       "             1999-12-03 12:00:00                                    None   \n",
       "             1999-12-04 12:00:00                                    None   \n",
       "             1999-12-05 12:00:00                                    None   \n",
       "             1999-12-06 12:00:00                                    None   \n",
       "             1999-12-07 12:00:00                                    None   \n",
       "             1999-12-08 12:00:00                                    None   \n",
       "             1999-12-09 12:00:00                                    None   \n",
       "             1999-12-10 12:00:00                                    None   \n",
       "             1999-12-11 12:00:00                                    None   \n",
       "             1999-12-12 12:00:00                                    None   \n",
       "             1999-12-13 12:00:00                                    None   \n",
       "             1999-12-14 12:00:00                                    None   \n",
       "             1999-12-15 12:00:00                                    None   \n",
       "             1999-12-16 12:00:00                                    None   \n",
       "             1999-12-17 12:00:00                                    None   \n",
       "             1999-12-18 12:00:00                                    None   \n",
       "             1999-12-19 12:00:00                                    None   \n",
       "             1999-12-20 12:00:00                                    None   \n",
       "             1999-12-21 12:00:00                                    None   \n",
       "             1999-12-22 12:00:00                                    None   \n",
       "             1999-12-23 12:00:00                                    None   \n",
       "             1999-12-24 12:00:00                                    None   \n",
       "             1999-12-25 12:00:00                                    None   \n",
       "             1999-12-26 12:00:00                                    None   \n",
       "             1999-12-27 12:00:00                                    None   \n",
       "             1999-12-28 12:00:00                                    None   \n",
       "             1999-12-29 12:00:00                                    None   \n",
       "             1999-12-30 12:00:00                                    None   \n",
       "             1999-12-31 12:00:00                                    None   \n",
       "\n",
       "                                 DiagnosticsVariables.Script.DeltaSoilOMN  \\\n",
       "SimulationID Clock.Today                                                    \n",
       "4            2000-11-14 12:00:00                                     None   \n",
       "             2000-11-15 12:00:00                                     None   \n",
       "             2000-11-16 12:00:00                                     None   \n",
       "             2000-11-17 12:00:00                                     None   \n",
       "             2000-11-18 12:00:00                                     None   \n",
       "             2000-11-19 12:00:00                                     None   \n",
       "             2000-11-20 12:00:00                                     None   \n",
       "             2000-11-21 12:00:00                                     None   \n",
       "             2000-11-22 12:00:00                                     None   \n",
       "             2000-11-23 12:00:00                                     None   \n",
       "             2000-11-24 12:00:00                                     None   \n",
       "             2000-11-25 12:00:00                                     None   \n",
       "             2000-11-26 12:00:00                                     None   \n",
       "             2000-11-27 12:00:00                                     None   \n",
       "             2000-11-28 12:00:00                                     None   \n",
       "             2000-11-29 12:00:00                                     None   \n",
       "             2000-11-30 12:00:00                                     None   \n",
       "             2000-12-01 12:00:00                                     None   \n",
       "             2000-12-02 12:00:00                                     None   \n",
       "             2000-12-03 12:00:00                                     None   \n",
       "             2000-12-04 12:00:00                                     None   \n",
       "             2000-12-05 12:00:00                                     None   \n",
       "             2000-12-06 12:00:00                                     None   \n",
       "             2000-12-07 12:00:00                                     None   \n",
       "             2000-12-08 12:00:00                                     None   \n",
       "             2000-12-09 12:00:00                                     None   \n",
       "             2000-12-10 12:00:00                                     None   \n",
       "             2000-12-11 12:00:00                                     None   \n",
       "             2000-12-12 12:00:00                                     None   \n",
       "             2000-12-13 12:00:00                                     None   \n",
       "...                                                                   ...   \n",
       "57           1999-12-02 12:00:00                                     None   \n",
       "             1999-12-03 12:00:00                                     None   \n",
       "             1999-12-04 12:00:00                                     None   \n",
       "             1999-12-05 12:00:00                                     None   \n",
       "             1999-12-06 12:00:00                                     None   \n",
       "             1999-12-07 12:00:00                                     None   \n",
       "             1999-12-08 12:00:00                                     None   \n",
       "             1999-12-09 12:00:00                                     None   \n",
       "             1999-12-10 12:00:00                                     None   \n",
       "             1999-12-11 12:00:00                                     None   \n",
       "             1999-12-12 12:00:00                                     None   \n",
       "             1999-12-13 12:00:00                                     None   \n",
       "             1999-12-14 12:00:00                                     None   \n",
       "             1999-12-15 12:00:00                                     None   \n",
       "             1999-12-16 12:00:00                                     None   \n",
       "             1999-12-17 12:00:00                                     None   \n",
       "             1999-12-18 12:00:00                                     None   \n",
       "             1999-12-19 12:00:00                                     None   \n",
       "             1999-12-20 12:00:00                                     None   \n",
       "             1999-12-21 12:00:00                                     None   \n",
       "             1999-12-22 12:00:00                                     None   \n",
       "             1999-12-23 12:00:00                                     None   \n",
       "             1999-12-24 12:00:00                                     None   \n",
       "             1999-12-25 12:00:00                                     None   \n",
       "             1999-12-26 12:00:00                                     None   \n",
       "             1999-12-27 12:00:00                                     None   \n",
       "             1999-12-28 12:00:00                                     None   \n",
       "             1999-12-29 12:00:00                                     None   \n",
       "             1999-12-30 12:00:00                                     None   \n",
       "             1999-12-31 12:00:00                                     None   \n",
       "\n",
       "                                                ...                  \\\n",
       "SimulationID Clock.Today                        ...                   \n",
       "4            2000-11-14 12:00:00                ...                   \n",
       "             2000-11-15 12:00:00                ...                   \n",
       "             2000-11-16 12:00:00                ...                   \n",
       "             2000-11-17 12:00:00                ...                   \n",
       "             2000-11-18 12:00:00                ...                   \n",
       "             2000-11-19 12:00:00                ...                   \n",
       "             2000-11-20 12:00:00                ...                   \n",
       "             2000-11-21 12:00:00                ...                   \n",
       "             2000-11-22 12:00:00                ...                   \n",
       "             2000-11-23 12:00:00                ...                   \n",
       "             2000-11-24 12:00:00                ...                   \n",
       "             2000-11-25 12:00:00                ...                   \n",
       "             2000-11-26 12:00:00                ...                   \n",
       "             2000-11-27 12:00:00                ...                   \n",
       "             2000-11-28 12:00:00                ...                   \n",
       "             2000-11-29 12:00:00                ...                   \n",
       "             2000-11-30 12:00:00                ...                   \n",
       "             2000-12-01 12:00:00                ...                   \n",
       "             2000-12-02 12:00:00                ...                   \n",
       "             2000-12-03 12:00:00                ...                   \n",
       "             2000-12-04 12:00:00                ...                   \n",
       "             2000-12-05 12:00:00                ...                   \n",
       "             2000-12-06 12:00:00                ...                   \n",
       "             2000-12-07 12:00:00                ...                   \n",
       "             2000-12-08 12:00:00                ...                   \n",
       "             2000-12-09 12:00:00                ...                   \n",
       "             2000-12-10 12:00:00                ...                   \n",
       "             2000-12-11 12:00:00                ...                   \n",
       "             2000-12-12 12:00:00                ...                   \n",
       "             2000-12-13 12:00:00                ...                   \n",
       "...                                             ...                   \n",
       "57           1999-12-02 12:00:00                ...                   \n",
       "             1999-12-03 12:00:00                ...                   \n",
       "             1999-12-04 12:00:00                ...                   \n",
       "             1999-12-05 12:00:00                ...                   \n",
       "             1999-12-06 12:00:00                ...                   \n",
       "             1999-12-07 12:00:00                ...                   \n",
       "             1999-12-08 12:00:00                ...                   \n",
       "             1999-12-09 12:00:00                ...                   \n",
       "             1999-12-10 12:00:00                ...                   \n",
       "             1999-12-11 12:00:00                ...                   \n",
       "             1999-12-12 12:00:00                ...                   \n",
       "             1999-12-13 12:00:00                ...                   \n",
       "             1999-12-14 12:00:00                ...                   \n",
       "             1999-12-15 12:00:00                ...                   \n",
       "             1999-12-16 12:00:00                ...                   \n",
       "             1999-12-17 12:00:00                ...                   \n",
       "             1999-12-18 12:00:00                ...                   \n",
       "             1999-12-19 12:00:00                ...                   \n",
       "             1999-12-20 12:00:00                ...                   \n",
       "             1999-12-21 12:00:00                ...                   \n",
       "             1999-12-22 12:00:00                ...                   \n",
       "             1999-12-23 12:00:00                ...                   \n",
       "             1999-12-24 12:00:00                ...                   \n",
       "             1999-12-25 12:00:00                ...                   \n",
       "             1999-12-26 12:00:00                ...                   \n",
       "             1999-12-27 12:00:00                ...                   \n",
       "             1999-12-28 12:00:00                ...                   \n",
       "             1999-12-29 12:00:00                ...                   \n",
       "             1999-12-30 12:00:00                ...                   \n",
       "             1999-12-31 12:00:00                ...                   \n",
       "\n",
       "                                 Lucerne.Leaf.SenLAI.Value()  \\\n",
       "SimulationID Clock.Today                                       \n",
       "4            2000-11-14 12:00:00                        None   \n",
       "             2000-11-15 12:00:00                        None   \n",
       "             2000-11-16 12:00:00                        None   \n",
       "             2000-11-17 12:00:00                        None   \n",
       "             2000-11-18 12:00:00                        None   \n",
       "             2000-11-19 12:00:00                        None   \n",
       "             2000-11-20 12:00:00                        None   \n",
       "             2000-11-21 12:00:00                        None   \n",
       "             2000-11-22 12:00:00                        None   \n",
       "             2000-11-23 12:00:00                        None   \n",
       "             2000-11-24 12:00:00                        None   \n",
       "             2000-11-25 12:00:00                        None   \n",
       "             2000-11-26 12:00:00                        None   \n",
       "             2000-11-27 12:00:00                        None   \n",
       "             2000-11-28 12:00:00                        None   \n",
       "             2000-11-29 12:00:00                        None   \n",
       "             2000-11-30 12:00:00                        None   \n",
       "             2000-12-01 12:00:00                        None   \n",
       "             2000-12-02 12:00:00                        None   \n",
       "             2000-12-03 12:00:00                        None   \n",
       "             2000-12-04 12:00:00                        None   \n",
       "             2000-12-05 12:00:00                        None   \n",
       "             2000-12-06 12:00:00                        None   \n",
       "             2000-12-07 12:00:00                        None   \n",
       "             2000-12-08 12:00:00                        None   \n",
       "             2000-12-09 12:00:00                        None   \n",
       "             2000-12-10 12:00:00                        None   \n",
       "             2000-12-11 12:00:00                        None   \n",
       "             2000-12-12 12:00:00                        None   \n",
       "             2000-12-13 12:00:00                        None   \n",
       "...                                                      ...   \n",
       "57           1999-12-02 12:00:00                        None   \n",
       "             1999-12-03 12:00:00                        None   \n",
       "             1999-12-04 12:00:00                        None   \n",
       "             1999-12-05 12:00:00                        None   \n",
       "             1999-12-06 12:00:00                        None   \n",
       "             1999-12-07 12:00:00                        None   \n",
       "             1999-12-08 12:00:00                        None   \n",
       "             1999-12-09 12:00:00                        None   \n",
       "             1999-12-10 12:00:00                        None   \n",
       "             1999-12-11 12:00:00                        None   \n",
       "             1999-12-12 12:00:00                        None   \n",
       "             1999-12-13 12:00:00                        None   \n",
       "             1999-12-14 12:00:00                        None   \n",
       "             1999-12-15 12:00:00                        None   \n",
       "             1999-12-16 12:00:00                        None   \n",
       "             1999-12-17 12:00:00                        None   \n",
       "             1999-12-18 12:00:00                        None   \n",
       "             1999-12-19 12:00:00                        None   \n",
       "             1999-12-20 12:00:00                        None   \n",
       "             1999-12-21 12:00:00                        None   \n",
       "             1999-12-22 12:00:00                        None   \n",
       "             1999-12-23 12:00:00                        None   \n",
       "             1999-12-24 12:00:00                        None   \n",
       "             1999-12-25 12:00:00                        None   \n",
       "             1999-12-26 12:00:00                        None   \n",
       "             1999-12-27 12:00:00                        None   \n",
       "             1999-12-28 12:00:00                        None   \n",
       "             1999-12-29 12:00:00                        None   \n",
       "             1999-12-30 12:00:00                        None   \n",
       "             1999-12-31 12:00:00                        None   \n",
       "\n",
       "                                 Lucerne.Leaf.DeltaPotentialLAI.Value()  \\\n",
       "SimulationID Clock.Today                                                  \n",
       "4            2000-11-14 12:00:00                                   None   \n",
       "             2000-11-15 12:00:00                                   None   \n",
       "             2000-11-16 12:00:00                                   None   \n",
       "             2000-11-17 12:00:00                                   None   \n",
       "             2000-11-18 12:00:00                                   None   \n",
       "             2000-11-19 12:00:00                                   None   \n",
       "             2000-11-20 12:00:00                                   None   \n",
       "             2000-11-21 12:00:00                                   None   \n",
       "             2000-11-22 12:00:00                                   None   \n",
       "             2000-11-23 12:00:00                                   None   \n",
       "             2000-11-24 12:00:00                                   None   \n",
       "             2000-11-25 12:00:00                                   None   \n",
       "             2000-11-26 12:00:00                                   None   \n",
       "             2000-11-27 12:00:00                                   None   \n",
       "             2000-11-28 12:00:00                                   None   \n",
       "             2000-11-29 12:00:00                                   None   \n",
       "             2000-11-30 12:00:00                                   None   \n",
       "             2000-12-01 12:00:00                                   None   \n",
       "             2000-12-02 12:00:00                                   None   \n",
       "             2000-12-03 12:00:00                                   None   \n",
       "             2000-12-04 12:00:00                                   None   \n",
       "             2000-12-05 12:00:00                                   None   \n",
       "             2000-12-06 12:00:00                                   None   \n",
       "             2000-12-07 12:00:00                                   None   \n",
       "             2000-12-08 12:00:00                                   None   \n",
       "             2000-12-09 12:00:00                                   None   \n",
       "             2000-12-10 12:00:00                                   None   \n",
       "             2000-12-11 12:00:00                                   None   \n",
       "             2000-12-12 12:00:00                                   None   \n",
       "             2000-12-13 12:00:00                                   None   \n",
       "...                                                                 ...   \n",
       "57           1999-12-02 12:00:00                                   None   \n",
       "             1999-12-03 12:00:00                                   None   \n",
       "             1999-12-04 12:00:00                                   None   \n",
       "             1999-12-05 12:00:00                                   None   \n",
       "             1999-12-06 12:00:00                                   None   \n",
       "             1999-12-07 12:00:00                                   None   \n",
       "             1999-12-08 12:00:00                                   None   \n",
       "             1999-12-09 12:00:00                                   None   \n",
       "             1999-12-10 12:00:00                                   None   \n",
       "             1999-12-11 12:00:00                                   None   \n",
       "             1999-12-12 12:00:00                                   None   \n",
       "             1999-12-13 12:00:00                                   None   \n",
       "             1999-12-14 12:00:00                                   None   \n",
       "             1999-12-15 12:00:00                                   None   \n",
       "             1999-12-16 12:00:00                                   None   \n",
       "             1999-12-17 12:00:00                                   None   \n",
       "             1999-12-18 12:00:00                                   None   \n",
       "             1999-12-19 12:00:00                                   None   \n",
       "             1999-12-20 12:00:00                                   None   \n",
       "             1999-12-21 12:00:00                                   None   \n",
       "             1999-12-22 12:00:00                                   None   \n",
       "             1999-12-23 12:00:00                                   None   \n",
       "             1999-12-24 12:00:00                                   None   \n",
       "             1999-12-25 12:00:00                                   None   \n",
       "             1999-12-26 12:00:00                                   None   \n",
       "             1999-12-27 12:00:00                                   None   \n",
       "             1999-12-28 12:00:00                                   None   \n",
       "             1999-12-29 12:00:00                                   None   \n",
       "             1999-12-30 12:00:00                                   None   \n",
       "             1999-12-31 12:00:00                                   None   \n",
       "\n",
       "                                  Lucerne.Shell.PodNumber.Value()  \\\n",
       "SimulationID Clock.Today                                            \n",
       "4            2000-11-14 12:00:00                             None   \n",
       "             2000-11-15 12:00:00                             None   \n",
       "             2000-11-16 12:00:00                             None   \n",
       "             2000-11-17 12:00:00                             None   \n",
       "             2000-11-18 12:00:00                             None   \n",
       "             2000-11-19 12:00:00                             None   \n",
       "             2000-11-20 12:00:00                             None   \n",
       "             2000-11-21 12:00:00                             None   \n",
       "             2000-11-22 12:00:00                             None   \n",
       "             2000-11-23 12:00:00                             None   \n",
       "             2000-11-24 12:00:00                             None   \n",
       "             2000-11-25 12:00:00                             None   \n",
       "             2000-11-26 12:00:00                             None   \n",
       "             2000-11-27 12:00:00                             None   \n",
       "             2000-11-28 12:00:00                             None   \n",
       "             2000-11-29 12:00:00                             None   \n",
       "             2000-11-30 12:00:00                             None   \n",
       "             2000-12-01 12:00:00                             None   \n",
       "             2000-12-02 12:00:00                             None   \n",
       "             2000-12-03 12:00:00                             None   \n",
       "             2000-12-04 12:00:00                             None   \n",
       "             2000-12-05 12:00:00                             None   \n",
       "             2000-12-06 12:00:00                             None   \n",
       "             2000-12-07 12:00:00                             None   \n",
       "             2000-12-08 12:00:00                             None   \n",
       "             2000-12-09 12:00:00                             None   \n",
       "             2000-12-10 12:00:00                             None   \n",
       "             2000-12-11 12:00:00                             None   \n",
       "             2000-12-12 12:00:00                             None   \n",
       "             2000-12-13 12:00:00                             None   \n",
       "...                                                           ...   \n",
       "57           1999-12-02 12:00:00                             None   \n",
       "             1999-12-03 12:00:00                             None   \n",
       "             1999-12-04 12:00:00                             None   \n",
       "             1999-12-05 12:00:00                             None   \n",
       "             1999-12-06 12:00:00                             None   \n",
       "             1999-12-07 12:00:00                             None   \n",
       "             1999-12-08 12:00:00                             None   \n",
       "             1999-12-09 12:00:00                             None   \n",
       "             1999-12-10 12:00:00                             None   \n",
       "             1999-12-11 12:00:00                             None   \n",
       "             1999-12-12 12:00:00                             None   \n",
       "             1999-12-13 12:00:00                             None   \n",
       "             1999-12-14 12:00:00                             None   \n",
       "             1999-12-15 12:00:00                             None   \n",
       "             1999-12-16 12:00:00                             None   \n",
       "             1999-12-17 12:00:00                             None   \n",
       "             1999-12-18 12:00:00                             None   \n",
       "             1999-12-19 12:00:00                             None   \n",
       "             1999-12-20 12:00:00                             None   \n",
       "             1999-12-21 12:00:00                             None   \n",
       "             1999-12-22 12:00:00                             None   \n",
       "             1999-12-23 12:00:00                             None   \n",
       "             1999-12-24 12:00:00                             None   \n",
       "             1999-12-25 12:00:00                             None   \n",
       "             1999-12-26 12:00:00                             None   \n",
       "             1999-12-27 12:00:00                             None   \n",
       "             1999-12-28 12:00:00                             None   \n",
       "             1999-12-29 12:00:00                             None   \n",
       "             1999-12-30 12:00:00                             None   \n",
       "             1999-12-31 12:00:00                             None   \n",
       "\n",
       "                                  Soil.OutputLayers.SWmm  \\\n",
       "SimulationID Clock.Today                                   \n",
       "4            2000-11-14 12:00:00                    None   \n",
       "             2000-11-15 12:00:00                    None   \n",
       "             2000-11-16 12:00:00                    None   \n",
       "             2000-11-17 12:00:00                    None   \n",
       "             2000-11-18 12:00:00                    None   \n",
       "             2000-11-19 12:00:00                    None   \n",
       "             2000-11-20 12:00:00                    None   \n",
       "             2000-11-21 12:00:00                    None   \n",
       "             2000-11-22 12:00:00                    None   \n",
       "             2000-11-23 12:00:00                    None   \n",
       "             2000-11-24 12:00:00                    None   \n",
       "             2000-11-25 12:00:00                    None   \n",
       "             2000-11-26 12:00:00                    None   \n",
       "             2000-11-27 12:00:00                    None   \n",
       "             2000-11-28 12:00:00                    None   \n",
       "             2000-11-29 12:00:00                    None   \n",
       "             2000-11-30 12:00:00                    None   \n",
       "             2000-12-01 12:00:00                    None   \n",
       "             2000-12-02 12:00:00                    None   \n",
       "             2000-12-03 12:00:00                    None   \n",
       "             2000-12-04 12:00:00                    None   \n",
       "             2000-12-05 12:00:00                    None   \n",
       "             2000-12-06 12:00:00                    None   \n",
       "             2000-12-07 12:00:00                    None   \n",
       "             2000-12-08 12:00:00                    None   \n",
       "             2000-12-09 12:00:00                    None   \n",
       "             2000-12-10 12:00:00                    None   \n",
       "             2000-12-11 12:00:00                    None   \n",
       "             2000-12-12 12:00:00                    None   \n",
       "             2000-12-13 12:00:00                    None   \n",
       "...                                                  ...   \n",
       "57           1999-12-02 12:00:00                    None   \n",
       "             1999-12-03 12:00:00                    None   \n",
       "             1999-12-04 12:00:00                    None   \n",
       "             1999-12-05 12:00:00                    None   \n",
       "             1999-12-06 12:00:00                    None   \n",
       "             1999-12-07 12:00:00                    None   \n",
       "             1999-12-08 12:00:00                    None   \n",
       "             1999-12-09 12:00:00                    None   \n",
       "             1999-12-10 12:00:00                    None   \n",
       "             1999-12-11 12:00:00                    None   \n",
       "             1999-12-12 12:00:00                    None   \n",
       "             1999-12-13 12:00:00                    None   \n",
       "             1999-12-14 12:00:00                    None   \n",
       "             1999-12-15 12:00:00                    None   \n",
       "             1999-12-16 12:00:00                    None   \n",
       "             1999-12-17 12:00:00                    None   \n",
       "             1999-12-18 12:00:00                    None   \n",
       "             1999-12-19 12:00:00                    None   \n",
       "             1999-12-20 12:00:00                    None   \n",
       "             1999-12-21 12:00:00                    None   \n",
       "             1999-12-22 12:00:00                    None   \n",
       "             1999-12-23 12:00:00                    None   \n",
       "             1999-12-24 12:00:00                    None   \n",
       "             1999-12-25 12:00:00                    None   \n",
       "             1999-12-26 12:00:00                    None   \n",
       "             1999-12-27 12:00:00                    None   \n",
       "             1999-12-28 12:00:00                    None   \n",
       "             1999-12-29 12:00:00                    None   \n",
       "             1999-12-30 12:00:00                    None   \n",
       "             1999-12-31 12:00:00                    None   \n",
       "\n",
       "                                  Soil.OutputLayers.SW    LL    SS  Cutting  \\\n",
       "SimulationID Clock.Today                                                      \n",
       "4            2000-11-14 12:00:00                  None  None  None     None   \n",
       "             2000-11-15 12:00:00                  None  None  None     None   \n",
       "             2000-11-16 12:00:00                  None  None  None     None   \n",
       "             2000-11-17 12:00:00                  None  None  None     None   \n",
       "             2000-11-18 12:00:00                  None  None  None     None   \n",
       "             2000-11-19 12:00:00                  None  None  None     None   \n",
       "             2000-11-20 12:00:00                  None  None  None     None   \n",
       "             2000-11-21 12:00:00                  None  None  None     None   \n",
       "             2000-11-22 12:00:00                  None  None  None     None   \n",
       "             2000-11-23 12:00:00                  None  None  None     None   \n",
       "             2000-11-24 12:00:00                  None  None  None     None   \n",
       "             2000-11-25 12:00:00                  None  None  None     None   \n",
       "             2000-11-26 12:00:00                  None  None  None     None   \n",
       "             2000-11-27 12:00:00                  None  None  None     None   \n",
       "             2000-11-28 12:00:00                  None  None  None     None   \n",
       "             2000-11-29 12:00:00                  None  None  None     None   \n",
       "             2000-11-30 12:00:00                  None  None  None     None   \n",
       "             2000-12-01 12:00:00                  None  None  None     None   \n",
       "             2000-12-02 12:00:00                  None  None  None     None   \n",
       "             2000-12-03 12:00:00                  None  None  None     None   \n",
       "             2000-12-04 12:00:00                  None  None  None     None   \n",
       "             2000-12-05 12:00:00                  None  None  None     None   \n",
       "             2000-12-06 12:00:00                  None  None  None     None   \n",
       "             2000-12-07 12:00:00                  None  None  None     None   \n",
       "             2000-12-08 12:00:00                  None  None  None     None   \n",
       "             2000-12-09 12:00:00                  None  None  None     None   \n",
       "             2000-12-10 12:00:00                  None  None  None     None   \n",
       "             2000-12-11 12:00:00                  None  None  None     None   \n",
       "             2000-12-12 12:00:00                  None  None  None     None   \n",
       "             2000-12-13 12:00:00                  None  None  None     None   \n",
       "...                                                ...   ...   ...      ...   \n",
       "57           1999-12-02 12:00:00                  None  None  None     None   \n",
       "             1999-12-03 12:00:00                  None  None  None     None   \n",
       "             1999-12-04 12:00:00                  None  None  None     None   \n",
       "             1999-12-05 12:00:00                  None  None  None     None   \n",
       "             1999-12-06 12:00:00                  None  None  None     None   \n",
       "             1999-12-07 12:00:00                  None  None  None     None   \n",
       "             1999-12-08 12:00:00                  None  None  None     None   \n",
       "             1999-12-09 12:00:00                  None  None  None     None   \n",
       "             1999-12-10 12:00:00                  None  None  None     None   \n",
       "             1999-12-11 12:00:00                  None  None  None     None   \n",
       "             1999-12-12 12:00:00                  None  None  None     None   \n",
       "             1999-12-13 12:00:00                  None  None  None     None   \n",
       "             1999-12-14 12:00:00                  None  None  None     None   \n",
       "             1999-12-15 12:00:00                  None  None  None     None   \n",
       "             1999-12-16 12:00:00                  None  None  None     None   \n",
       "             1999-12-17 12:00:00                  None  None  None     None   \n",
       "             1999-12-18 12:00:00                  None  None  None     None   \n",
       "             1999-12-19 12:00:00                  None  None  None     None   \n",
       "             1999-12-20 12:00:00                  None  None  None     None   \n",
       "             1999-12-21 12:00:00                  None  None  None     None   \n",
       "             1999-12-22 12:00:00                  None  None  None     None   \n",
       "             1999-12-23 12:00:00                  None  None  None     None   \n",
       "             1999-12-24 12:00:00                  None  None  None     None   \n",
       "             1999-12-25 12:00:00                  None  None  None     None   \n",
       "             1999-12-26 12:00:00                  None  None  None     None   \n",
       "             1999-12-27 12:00:00                  None  None  None     None   \n",
       "             1999-12-28 12:00:00                  None  None  None     None   \n",
       "             1999-12-29 12:00:00                  None  None  None     None   \n",
       "             1999-12-30 12:00:00                  None  None  None     None   \n",
       "             1999-12-31 12:00:00                  None  None  None     None   \n",
       "\n",
       "                                  Weather.DaysSinceWinterSolstice  \\\n",
       "SimulationID Clock.Today                                            \n",
       "4            2000-11-14 12:00:00                             None   \n",
       "             2000-11-15 12:00:00                             None   \n",
       "             2000-11-16 12:00:00                             None   \n",
       "             2000-11-17 12:00:00                             None   \n",
       "             2000-11-18 12:00:00                             None   \n",
       "             2000-11-19 12:00:00                             None   \n",
       "             2000-11-20 12:00:00                             None   \n",
       "             2000-11-21 12:00:00                             None   \n",
       "             2000-11-22 12:00:00                             None   \n",
       "             2000-11-23 12:00:00                             None   \n",
       "             2000-11-24 12:00:00                             None   \n",
       "             2000-11-25 12:00:00                             None   \n",
       "             2000-11-26 12:00:00                             None   \n",
       "             2000-11-27 12:00:00                             None   \n",
       "             2000-11-28 12:00:00                             None   \n",
       "             2000-11-29 12:00:00                             None   \n",
       "             2000-11-30 12:00:00                             None   \n",
       "             2000-12-01 12:00:00                             None   \n",
       "             2000-12-02 12:00:00                             None   \n",
       "             2000-12-03 12:00:00                             None   \n",
       "             2000-12-04 12:00:00                             None   \n",
       "             2000-12-05 12:00:00                             None   \n",
       "             2000-12-06 12:00:00                             None   \n",
       "             2000-12-07 12:00:00                             None   \n",
       "             2000-12-08 12:00:00                             None   \n",
       "             2000-12-09 12:00:00                             None   \n",
       "             2000-12-10 12:00:00                             None   \n",
       "             2000-12-11 12:00:00                             None   \n",
       "             2000-12-12 12:00:00                             None   \n",
       "             2000-12-13 12:00:00                             None   \n",
       "...                                                           ...   \n",
       "57           1999-12-02 12:00:00                             None   \n",
       "             1999-12-03 12:00:00                             None   \n",
       "             1999-12-04 12:00:00                             None   \n",
       "             1999-12-05 12:00:00                             None   \n",
       "             1999-12-06 12:00:00                             None   \n",
       "             1999-12-07 12:00:00                             None   \n",
       "             1999-12-08 12:00:00                             None   \n",
       "             1999-12-09 12:00:00                             None   \n",
       "             1999-12-10 12:00:00                             None   \n",
       "             1999-12-11 12:00:00                             None   \n",
       "             1999-12-12 12:00:00                             None   \n",
       "             1999-12-13 12:00:00                             None   \n",
       "             1999-12-14 12:00:00                             None   \n",
       "             1999-12-15 12:00:00                             None   \n",
       "             1999-12-16 12:00:00                             None   \n",
       "             1999-12-17 12:00:00                             None   \n",
       "             1999-12-18 12:00:00                             None   \n",
       "             1999-12-19 12:00:00                             None   \n",
       "             1999-12-20 12:00:00                             None   \n",
       "             1999-12-21 12:00:00                             None   \n",
       "             1999-12-22 12:00:00                             None   \n",
       "             1999-12-23 12:00:00                             None   \n",
       "             1999-12-24 12:00:00                             None   \n",
       "             1999-12-25 12:00:00                             None   \n",
       "             1999-12-26 12:00:00                             None   \n",
       "             1999-12-27 12:00:00                             None   \n",
       "             1999-12-28 12:00:00                             None   \n",
       "             1999-12-29 12:00:00                             None   \n",
       "             1999-12-30 12:00:00                             None   \n",
       "             1999-12-31 12:00:00                             None   \n",
       "\n",
       "                                 Lucerne.Phenology.DaysAfterCutting  \n",
       "SimulationID Clock.Today                                             \n",
       "4            2000-11-14 12:00:00                               None  \n",
       "             2000-11-15 12:00:00                               None  \n",
       "             2000-11-16 12:00:00                               None  \n",
       "             2000-11-17 12:00:00                               None  \n",
       "             2000-11-18 12:00:00                               None  \n",
       "             2000-11-19 12:00:00                               None  \n",
       "             2000-11-20 12:00:00                               None  \n",
       "             2000-11-21 12:00:00                               None  \n",
       "             2000-11-22 12:00:00                               None  \n",
       "             2000-11-23 12:00:00                               None  \n",
       "             2000-11-24 12:00:00                               None  \n",
       "             2000-11-25 12:00:00                               None  \n",
       "             2000-11-26 12:00:00                               None  \n",
       "             2000-11-27 12:00:00                               None  \n",
       "             2000-11-28 12:00:00                               None  \n",
       "             2000-11-29 12:00:00                               None  \n",
       "             2000-11-30 12:00:00                               None  \n",
       "             2000-12-01 12:00:00                               None  \n",
       "             2000-12-02 12:00:00                               None  \n",
       "             2000-12-03 12:00:00                               None  \n",
       "             2000-12-04 12:00:00                               None  \n",
       "             2000-12-05 12:00:00                               None  \n",
       "             2000-12-06 12:00:00                               None  \n",
       "             2000-12-07 12:00:00                               None  \n",
       "             2000-12-08 12:00:00                               None  \n",
       "             2000-12-09 12:00:00                               None  \n",
       "             2000-12-10 12:00:00                               None  \n",
       "             2000-12-11 12:00:00                               None  \n",
       "             2000-12-12 12:00:00                               None  \n",
       "             2000-12-13 12:00:00                               None  \n",
       "...                                                             ...  \n",
       "57           1999-12-02 12:00:00                               None  \n",
       "             1999-12-03 12:00:00                               None  \n",
       "             1999-12-04 12:00:00                               None  \n",
       "             1999-12-05 12:00:00                               None  \n",
       "             1999-12-06 12:00:00                               None  \n",
       "             1999-12-07 12:00:00                               None  \n",
       "             1999-12-08 12:00:00                               None  \n",
       "             1999-12-09 12:00:00                               None  \n",
       "             1999-12-10 12:00:00                               None  \n",
       "             1999-12-11 12:00:00                               None  \n",
       "             1999-12-12 12:00:00                               None  \n",
       "             1999-12-13 12:00:00                               None  \n",
       "             1999-12-14 12:00:00                               None  \n",
       "             1999-12-15 12:00:00                               None  \n",
       "             1999-12-16 12:00:00                               None  \n",
       "             1999-12-17 12:00:00                               None  \n",
       "             1999-12-18 12:00:00                               None  \n",
       "             1999-12-19 12:00:00                               None  \n",
       "             1999-12-20 12:00:00                               None  \n",
       "             1999-12-21 12:00:00                               None  \n",
       "             1999-12-22 12:00:00                               None  \n",
       "             1999-12-23 12:00:00                               None  \n",
       "             1999-12-24 12:00:00                               None  \n",
       "             1999-12-25 12:00:00                               None  \n",
       "             1999-12-26 12:00:00                               None  \n",
       "             1999-12-27 12:00:00                               None  \n",
       "             1999-12-28 12:00:00                               None  \n",
       "             1999-12-29 12:00:00                               None  \n",
       "             1999-12-30 12:00:00                               None  \n",
       "             1999-12-31 12:00:00                               None  \n",
       "\n",
       "[115430 rows x 256 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Report"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def MakeLabel(RegStats):\n",
    "    #text = RegStats.Name + '  n = ' + str(RegStats.n)\n",
    "    text = '\\ny = ' + '%.2f'%RegStats.Intercept + '(se ' + '%.2f'%RegStats.SEintercept + ') + ' + '%.2f'%RegStats.Slope + '(se ' + '%.2f'%RegStats.SEslope + ') x' \n",
    "    text += '\\n$r^2$ =' + '%.2f'%RegStats.R2 + ' RMSE = ' + '%.2f'%RegStats.RMSE +' NSE = ' + '%.2f'%RegStats.NSE\n",
    "    text += '\\nME = ' + '%.2f'%RegStats.ME + ' MAE = ' + '%.2f'%RegStats.MAE\n",
    "    text += '\\nn = ' + str(RegStats.n)\n",
    "    return text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "ufunc 'isnan' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe''",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-18-dc348966fc6b>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      7\u001b[0m \u001b[0mPos\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      8\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mVar\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mVariables\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 9\u001b[1;33m     \u001b[0mNaNFilter\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0misnan\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mPredictedObserved\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'Predicted.'\u001b[0m\u001b[1;33m+\u001b[0m\u001b[0mVar\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m|\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0misnan\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mPredictedObserved\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'Observed.'\u001b[0m\u001b[1;33m+\u001b[0m\u001b[0mVar\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     10\u001b[0m     \u001b[0mIaNFilter\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m~\u001b[0m\u001b[0mNaNFilter\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     11\u001b[0m     \u001b[0mObs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mPredictedObserved\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'Observed.'\u001b[0m\u001b[1;33m+\u001b[0m\u001b[0mVar\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mIaNFilter\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mTypeError\u001b[0m: ufunc 'isnan' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe''"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<Figure size 1080x1080 with 0 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "Graph = plt.figure(figsize=(15,15))\n",
    "Variables = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Units = ['$g/m^3$','$/m^3$','$g/m^3$',\n",
    "        '$g/m^3$','$g/m^3$','$g/m^3$',\n",
    "        'days','days']\n",
    "Names = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Pos = 1\n",
    "for Var in Variables:\n",
    "    NaNFilter = np.isnan(PredictedObserved.loc[:,'Predicted.'+Var]) | np.isnan(PredictedObserved.loc[:,'Observed.'+Var])\n",
    "    IaNFilter = ~NaNFilter\n",
    "    Obs = PredictedObserved.loc[:,'Observed.'+Var].loc[IaNFilter].values\n",
    "    Pred = PredictedObserved.loc[:,'Predicted.'+Var].loc[IaNFilter].values\n",
    "    Graph.add_subplot(3,3,Pos)\n",
    "    plt.plot(Obs,Pred,Markers[MarPos],color = Colors[ColPos],label=Fol)\n",
    "    uplim = max(Obs.max(),Pred.max())*1.1\n",
    "    lowlim = min(Obs.min(),Pred.min())*0.95\n",
    "    plt.title(Names[Pos-1] + ' (' + Units[Pos-1] + ')')\n",
    "    plt.ylim(0,uplim)\n",
    "    plt.xlim(0,uplim)\n",
    "    plt.plot([lowlim,uplim*.95],[lowlim,uplim*.95],'-')\n",
    "    RegStats = MUte.MathUtilities.CalcRegressionStats(Var,Pred,Obs)\n",
    "    LabelText = MakeLabel(RegStats)\n",
    "    plt.text(uplim*0.05,uplim*.78,LabelText)\n",
    "    #Fit linear regression to current series and store slope and intercept in dataframe\n",
    "    ModFit = sm.regression.linear_model.OLS(Pred,  # Y variable\n",
    "                                        sm.add_constant(Obs), # X variable\n",
    "                                        missing='drop',                                     # ignor and data where one value is missing\n",
    "                                        hasconst=False) \n",
    "    RegFit = ModFit.fit();  # fit models parameters\n",
    "    Slope = RegFit.params[1] \n",
    "    Intercept = RegFit.params[0]\n",
    "    Xs = [lowlim,uplim*.95]\n",
    "    Ys = [Intercept + Xs[0]*Slope,Intercept + Xs[1]*Slope]\n",
    "    plt.plot(Xs,Ys,'--')\n",
    "    Pos +=1\n",
    "plt.text(700,-500,'Observed',fontsize=20)\n",
    "plt.text(-4400,3500,'Predicted',fontsize=20,rotation=90)\n",
    "plt.legend(loc = (1.2,0),ncol=1,numpoints=1,markerscale=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for pair in PredictedObserved.index:\n",
    "    SimID =  PredictedObserved.loc[pair,'SimulationID']\n",
    "    ObsDate = PredictedObserved.loc[pair,'Clock.Today']\n",
    "    PredictedObserved.loc[pair,'DSWS'] = Report.loc[(SimID,ObsDate),'Weather.DaysSinceWinterSolstice']\n",
    "    PredictedObserved.loc[pair,'DReg'] = Report.loc[(SimID,ObsDate),'Lucerne.Phenology.DaysAfterCutting']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "Graph = plt.figure(figsize=(15,15))\n",
    "Variables = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Units = ['$g/m^3$','$/m^3$','$g/m^3$',\n",
    "        '$g/m^3$','$g/m^3$','$g/m^3$',\n",
    "        'days','days']\n",
    "Names = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Pos = 1\n",
    "for Var in Variables:\n",
    "    NaNFilter = np.isnan(PredictedObserved.loc[:,'Predicted.'+Var]) | np.isnan(PredictedObserved.loc[:,'Observed.'+Var])\n",
    "    IaNFilter = ~NaNFilter\n",
    "    Obs = PredictedObserved.loc[:,'Observed.'+Var].loc[IaNFilter].values\n",
    "    Pred = PredictedObserved.loc[:,'Predicted.'+Var].loc[IaNFilter].values\n",
    "    residual = Pred - Obs\n",
    "    DSWS = PredictedObserved.loc[:,'DSWS'].loc[IaNFilter].values\n",
    "    ax = Graph.add_subplot(3,3,Pos)\n",
    "    plt.plot(DSWS,residual,Markers[MarPos],color = Colors[ColPos],label=Fol)\n",
    "    uplim = max(residual.max(),Pred.max())*1.1\n",
    "    lowlim = min(residual.min(),Pred.min())*0.95\n",
    "    plt.title(Names[Pos-1] + ' (' + Units[Pos-1] + ')')\n",
    "    plt.ylim(lowlim,uplim)\n",
    "    plt.xlim(0,365)\n",
    "    RegStats = MUte.MathUtilities.CalcRegressionStats(Var,Pred,Obs)\n",
    "    LabelText = MakeLabel(RegStats)\n",
    "    plt.text(0.05,0.78,LabelText,transform=ax.transAxes)\n",
    "    Pos +=1\n",
    "plt.text(70,-50,'Days since winter solstice',fontsize=20)\n",
    "plt.text(-40,30,'Residual',fontsize=20,rotation=90)\n",
    "plt.legend(loc = (1.2,0),ncol=1,numpoints=1,markerscale=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "Graph = plt.figure(figsize=(15,15))\n",
    "Variables = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Units = ['$g/m^3$','$/m^3$','$g/m^3$',\n",
    "        '$g/m^3$','$g/m^3$','$g/m^3$',\n",
    "        'days','days']\n",
    "Names = ['Height','LAI','RootWt','StemWt','LeafWt']\n",
    "Pos = 1\n",
    "for Var in Variables:\n",
    "    NaNFilter = np.isnan(PredictedObserved.loc[:,'Predicted.'+Var]) | np.isnan(PredictedObserved.loc[:,'Observed.'+Var])\n",
    "    IaNFilter = ~NaNFilter\n",
    "    Obs = PredictedObserved.loc[:,'Observed.'+Var].loc[IaNFilter].values\n",
    "    Pred = PredictedObserved.loc[:,'Predicted.'+Var].loc[IaNFilter].values\n",
    "    residual = Pred - Obs\n",
    "    DSWS = PredictedObserved.loc[:,'DReg'].loc[IaNFilter].values\n",
    "    ax = Graph.add_subplot(3,3,Pos)\n",
    "    plt.plot(DSWS,residual,Markers[MarPos],color = Colors[ColPos],label=Fol)\n",
    "    uplim = max(residual.max(),Pred.max())*1.1\n",
    "    lowlim = min(residual.min(),Pred.min())*0.95\n",
    "    plt.title(Names[Pos-1] + ' (' + Units[Pos-1] + ')')\n",
    "    plt.ylim(lowlim,uplim)\n",
    "    plt.xlim(0,150)\n",
    "    RegStats = MUte.MathUtilities.CalcRegressionStats(Var,Pred,Obs)\n",
    "    LabelText = MakeLabel(RegStats)\n",
    "    plt.text(0.05,0.78,LabelText,transform=ax.transAxes)\n",
    "    Pos +=1\n",
    "plt.text(70,-50,'Days since Cutting',fontsize=20)\n",
    "plt.text(-40,30,'Residual',fontsize=20,rotation=90)\n",
    "plt.legend(loc = (1.2,0),ncol=1,numpoints=1,markerscale=2)"
   ]
  }
 ],
 "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}