{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b7917d5a",
   "metadata": {},
   "source": [
    "### Read Multiple Result Map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1065d162",
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ed95e253",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">Connecting engine server -&gt; <span style=\"color: #0000ff; text-decoration-color: #0000ff; text-decoration: underline\">https://absbox.org/api/dev</span>\n",
       "</pre>\n"
      ],
      "text/plain": [
       "Connecting engine server -> \u001b[4;94mhttps://absbox.org/api/dev\u001b[0m\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">✅Connected, local li<span style=\"color: #00ff00; text-decoration-color: #00ff00; font-weight: bold\">b:0</span>.<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">46.5</span>, server:<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">0.50</span>.<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">1</span>\n",
       "</pre>\n"
      ],
      "text/plain": [
       "✅Connected, local li\u001b[1;92mb:0\u001b[0m.\u001b[1;36m46.5\u001b[0m, server:\u001b[1;36m0.50\u001b[0m.\u001b[1;36m1\u001b[0m\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from absbox import API,EnginePath\n",
    "localAPI = API(EnginePath.DEV,check=False)\n",
    "\n",
    "\n",
    "from absbox.examples import test01,test02"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "574f0989",
   "metadata": {},
   "source": [
    "#### What is MultiResult ?\n",
    "\n",
    "`Multi Result` is just a map result return either by `runByScenarios()` or `runStructs()`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "55fde6c1",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "rs1 = localAPI.runStructs({\"deal1\":test01,\"deal2\":test02}\n",
    "                         ,read=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "12f7a5bc",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "p1 = (\"Pool\",(\"Mortgage\",None,{\"CPR\":0.01},None,None)\n",
    "                                ,None\n",
    "                                ,None)\n",
    "\n",
    "p2 = (\"Pool\",(\"Mortgage\",None,{\"CPR\":0.02},None,None)\n",
    "                                ,None\n",
    "                                ,None)\n",
    "\n",
    "\n",
    "rs2 = localAPI.runByScenarios(test01\n",
    "                             ,{\"CPR=1%\":p1,\"CPR=2%\":p2}\n",
    "                             ,runAssump = [\n",
    "                                 (\"pricing\"\n",
    "                                  ,{\"date\":\"2021-08-22\"\n",
    "                                    ,\"curve\":[[\"2021-01-01\",0.025]\n",
    "                                             ,[\"2024-08-01\",0.025]]})\n",
    "                             ]\n",
    "                             ,read=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "75845521",
   "metadata": {},
   "source": [
    "User need to import candy functions and `lens` to build paths which points to the data field of interest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "15868ad0",
   "metadata": {},
   "outputs": [],
   "source": [
    "from absbox import readFlowsByScenarios,readMultiFlowsByScenarios,readFieldsByScenarios\n",
    "\n",
    "from lenses import lens"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4fed59e3",
   "metadata": {},
   "source": [
    "#### readFlowsByScenarios()\n",
    "\n",
    "The read single cashflow from multiple scenarios and build a dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7f87818a",
   "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>deal1:balance</th>\n",
       "      <th>deal2:balance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-06-20</th>\n",
       "      <td>543.90</td>\n",
       "      <td>340.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>429.17</td>\n",
       "      <td>224.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>313.86</td>\n",
       "      <td>108.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>197.87</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <td>81.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            deal1:balance  deal2:balance\n",
       "date                                    \n",
       "2021-06-20         543.90         340.83\n",
       "2021-07-20         429.17         224.94\n",
       "2021-08-20         313.86         108.41\n",
       "2021-09-20         197.87           0.00\n",
       "2021-10-20          81.15            NaN"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFlowsByScenarios(rs1, lens['bonds']['A1']['balance']).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c1354bd6",
   "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>balance</th>\n",
       "      <th>balance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-06-20</th>\n",
       "      <td>543.90</td>\n",
       "      <td>340.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>429.17</td>\n",
       "      <td>224.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>313.86</td>\n",
       "      <td>108.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>197.87</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <td>81.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            balance  balance\n",
       "date                        \n",
       "2021-06-20   543.90   340.83\n",
       "2021-07-20   429.17   224.94\n",
       "2021-08-20   313.86   108.41\n",
       "2021-09-20   197.87     0.00\n",
       "2021-10-20    81.15      NaN"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFlowsByScenarios(rs1, lens['bonds']['A1']['balance'], fullName=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "aa1303fa",
   "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>CPR=1%:Prepayment</th>\n",
       "      <th>CPR=2%:Prepayment</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>3.47</td>\n",
       "      <td>6.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <td>1.64</td>\n",
       "      <td>3.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-01</th>\n",
       "      <td>1.60</td>\n",
       "      <td>3.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-01</th>\n",
       "      <td>1.46</td>\n",
       "      <td>2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>1.42</td>\n",
       "      <td>2.85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CPR=1%:Prepayment  CPR=2%:Prepayment\n",
       "Date                                            \n",
       "2021-04-01               3.47               6.98\n",
       "2021-05-01               1.64               3.29\n",
       "2021-06-01               1.60               3.22\n",
       "2021-07-01               1.46               2.93\n",
       "2021-08-01               1.42               2.85"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFlowsByScenarios(rs2, lens['pool']['flow']['PoolConsol']['Prepayment']).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ffecb9d",
   "metadata": {},
   "source": [
    "#### readMultiFlowsByScenarios\n",
    "\n",
    "User can have option to view `multiple columns` from a multi result and merge them into a multi-index dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f338d3b5",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>Scenario</th>\n",
       "      <th colspan=\"2\" halign=\"left\">CPR=1%</th>\n",
       "      <th colspan=\"2\" halign=\"left\">CPR=2%</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Field</th>\n",
       "      <th>Balance</th>\n",
       "      <th>Prepayment</th>\n",
       "      <th>Balance</th>\n",
       "      <th>Prepayment</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>1989.69</td>\n",
       "      <td>3.47</td>\n",
       "      <td>1986.45</td>\n",
       "      <td>6.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <td>1883.73</td>\n",
       "      <td>1.64</td>\n",
       "      <td>1879.09</td>\n",
       "      <td>3.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-01</th>\n",
       "      <td>1777.20</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1771.29</td>\n",
       "      <td>3.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-01</th>\n",
       "      <td>1670.20</td>\n",
       "      <td>1.46</td>\n",
       "      <td>1663.26</td>\n",
       "      <td>2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>1562.63</td>\n",
       "      <td>1.42</td>\n",
       "      <td>1554.79</td>\n",
       "      <td>2.85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Scenario     CPR=1%              CPR=2%           \n",
       "Field       Balance Prepayment  Balance Prepayment\n",
       "Date                                              \n",
       "2021-04-01  1989.69       3.47  1986.45       6.98\n",
       "2021-05-01  1883.73       1.64  1879.09       3.29\n",
       "2021-06-01  1777.20       1.60  1771.29       3.22\n",
       "2021-07-01  1670.20       1.46  1663.26       2.93\n",
       "2021-08-01  1562.63       1.42  1554.79       2.85"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readMultiFlowsByScenarios(rs2\n",
    "                          , (lens['pool']['flow']['PoolConsol'],[\"Balance\",'Prepayment'])).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "006ac4cc",
   "metadata": {},
   "source": [
    "#### readFieldsByScenarios"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3c125936",
   "metadata": {},
   "source": [
    "| since `0.28.15`\n",
    "\n",
    "`readFieldsByScenarios` is more flexible candy function to view the fields from multiple results\n",
    "\n",
    "Here is the dataframe to be view"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6da78f21",
   "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>pricing</th>\n",
       "      <th>face</th>\n",
       "      <th>WAL</th>\n",
       "      <th>duration</th>\n",
       "      <th>convexity</th>\n",
       "      <th>accure interest</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A1</th>\n",
       "      <td>308.40</td>\n",
       "      <td>30.840</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.150048</td>\n",
       "      <td>0.031304</td>\n",
       "      <td>0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>1308.17</td>\n",
       "      <td>130.817</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.724602</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    pricing     face   WAL  duration  convexity  accure interest\n",
       "A1   308.40   30.840  0.15  0.150048   0.031304             0.11\n",
       "B   1308.17  130.817  0.60  0.724602   0.000000             0.00"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rs2['CPR=1%']['pricing']['summary']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21dea712",
   "metadata": {},
   "source": [
    "view by `Index`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2f40a3dc",
   "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>CPR=1%</th>\n",
       "      <th>CPR=2%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>pricing</th>\n",
       "      <td>308.400000</td>\n",
       "      <td>300.610000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>face</th>\n",
       "      <td>30.840000</td>\n",
       "      <td>30.061000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAL</th>\n",
       "      <td>0.150000</td>\n",
       "      <td>0.140000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>duration</th>\n",
       "      <td>0.150048</td>\n",
       "      <td>0.147078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>convexity</th>\n",
       "      <td>0.031304</td>\n",
       "      <td>0.032289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>accure interest</th>\n",
       "      <td>0.110000</td>\n",
       "      <td>0.110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     CPR=1%      CPR=2%\n",
       "pricing          308.400000  300.610000\n",
       "face              30.840000   30.061000\n",
       "WAL                0.150000    0.140000\n",
       "duration           0.150048    0.147078\n",
       "convexity          0.031304    0.032289\n",
       "accure interest    0.110000    0.110000"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFieldsByScenarios(rs2, lens['pricing']['summary'], \"A1\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "592643c2",
   "metadata": {},
   "source": [
    "view by `Column`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ce9a50a3",
   "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>CPR=1%</th>\n",
       "      <th>CPR=2%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A1</th>\n",
       "      <td>308.40</td>\n",
       "      <td>300.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>1308.17</td>\n",
       "      <td>1307.59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     CPR=1%   CPR=2%\n",
       "A1   308.40   300.61\n",
       "B   1308.17  1307.59"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFieldsByScenarios(rs2, lens['pricing']['summary'], \"pricing\", flip=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c37dee5b",
   "metadata": {},
   "source": [
    "view by `Column` ,which is a flow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6be36411",
   "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>CPR=1%</th>\n",
       "      <th>CPR=2%</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>3.47</td>\n",
       "      <td>6.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <td>1.64</td>\n",
       "      <td>3.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-01</th>\n",
       "      <td>1.6</td>\n",
       "      <td>3.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-01</th>\n",
       "      <td>1.46</td>\n",
       "      <td>2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>1.42</td>\n",
       "      <td>2.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-01</th>\n",
       "      <td>1.33</td>\n",
       "      <td>2.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-01</th>\n",
       "      <td>1.2</td>\n",
       "      <td>2.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-01</th>\n",
       "      <td>1.14</td>\n",
       "      <td>2.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-01</th>\n",
       "      <td>1.02</td>\n",
       "      <td>2.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-01</th>\n",
       "      <td>0.96</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-01</th>\n",
       "      <td>0.86</td>\n",
       "      <td>1.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-01</th>\n",
       "      <td>0.69</td>\n",
       "      <td>1.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-01</th>\n",
       "      <td>0.67</td>\n",
       "      <td>1.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-01</th>\n",
       "      <td>0.56</td>\n",
       "      <td>1.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-01</th>\n",
       "      <td>0.48</td>\n",
       "      <td>0.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>0.37</td>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-01</th>\n",
       "      <td>0.29</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-01</th>\n",
       "      <td>0.19</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-01</th>\n",
       "      <td>0.09</td>\n",
       "      <td>0.18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           CPR=1% CPR=2%\n",
       "Date                    \n",
       "2021-04-01   3.47   6.98\n",
       "2021-05-01   1.64   3.29\n",
       "2021-06-01    1.6   3.22\n",
       "2021-07-01   1.46   2.93\n",
       "2021-08-01   1.42   2.85\n",
       "2021-09-01   1.33   2.66\n",
       "2021-10-01    1.2   2.39\n",
       "2021-11-01   1.14   2.29\n",
       "2021-12-01   1.02   2.03\n",
       "2022-01-01   0.96   1.91\n",
       "2022-02-01   0.86   1.72\n",
       "2022-03-01   0.69   1.38\n",
       "2022-04-01   0.67   1.34\n",
       "2022-05-01   0.56   1.11\n",
       "2022-06-01   0.48   0.96\n",
       "2022-07-01   0.37   0.74\n",
       "2022-08-01   0.29   0.58\n",
       "2022-09-01   0.19   0.38\n",
       "2022-10-01   0.09   0.18"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFieldsByScenarios(rs2, lens['pool']['flow']['PoolConsol'], 'Prepayment', flip=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c8ddc995",
   "metadata": {},
   "source": [
    "view by `Index` which is a flow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "64149e19",
   "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>CPR=1%</th>\n",
       "      <th>CPR=2%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Balance</th>\n",
       "      <td>1345.93</td>\n",
       "      <td>1336.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Principal</th>\n",
       "      <td>107.4</td>\n",
       "      <td>106.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Interest</th>\n",
       "      <td>9.68</td>\n",
       "      <td>9.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prepayment</th>\n",
       "      <td>1.2</td>\n",
       "      <td>2.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Default</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Recovery</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Loss</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAC</th>\n",
       "      <td>0.08</td>\n",
       "      <td>0.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BorrowerNum</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PrepayPenalty</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumPrincipal</th>\n",
       "      <td>841.95</td>\n",
       "      <td>838.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumPrepay</th>\n",
       "      <td>12.12</td>\n",
       "      <td>24.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumDelinq</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumDefault</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumRecovery</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CumLoss</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                CPR=1%   CPR=2%\n",
       "Balance        1345.93  1336.93\n",
       "Principal        107.4   106.67\n",
       "Interest          9.68     9.62\n",
       "Prepayment         1.2     2.39\n",
       "Default              0        0\n",
       "Recovery             0        0\n",
       "Loss                 0        0\n",
       "WAC               0.08     0.08\n",
       "BorrowerNum       None     None\n",
       "PrepayPenalty     None     None\n",
       "CumPrincipal    841.95   838.75\n",
       "CumPrepay        12.12    24.32\n",
       "CumDelinq            0        0\n",
       "CumDefault           0        0\n",
       "CumRecovery          0        0\n",
       "CumLoss              0        0"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFieldsByScenarios(rs2, lens['pool']['flow']['PoolConsol'], '2021-10-01')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "18c45f53-d5e3-4e8b-a55f-923410ccc40c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.13.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}