algothon2021_examples.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"algothon2021_examples.ipynb","provenance":[],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3.8.6 64-bit ('env')","metadata":{"interpreter":{"hash":"e8dfffbc3f4484ba96f50b5109ac2ff9138f292d51b68cfa709d34521f434c38"}}}},"cells":[{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Nf4hpcLQbAk0","executionInfo":{"status":"ok","timestamp":1616849329564,"user_tz":0,"elapsed":10900,"user":{"displayName":"thomas","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ghlf6Pz9w7HtpuCZpDO0azd-mD4P2ALY-jNUKMOqw=s64","userId":"06101255495478084616"}},"outputId":"8a6f4197-e337-4165-d8e3-a083d0f7e4df"},"source":["pip install --index-url https://test.pypi.org/simple/ --no-deps --upgrade  --force-reinstall algothon2021 "],"execution_count":2,"outputs":[{"output_type":"stream","text":["Looking in indexes: https://test.pypi.org/simple/\n","Collecting algothon2021\n","\u001b[?25l  Downloading https://test-files.pythonhosted.org/packages/c9/4a/040719980a609c107b3b4fc0bc431600559e68f8f83b5629efb81b6afe63/algothon2021-0.0.6-py3-none-any.whl (74.5MB)\n","\u001b[K     |████████████████████████████████| 74.6MB 52kB/s \n","\u001b[?25hInstalling collected packages: algothon2021\n","Successfully installed algothon2021-0.0.6\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"whHLuira4VnS"},"source":[],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"_9iB86PG4Wcf"},"source":["## Prediction challenge "]},{"cell_type":"code","metadata":{"id":"b8W0S7h6bEQC"},"source":["from algothon2021prediction import Prediction\n","import numpy as np"],"execution_count":3,"outputs":[]},{"cell_type":"code","metadata":{"id":"N9BoBBojbEZR"},"source":["class MyPrediction(Prediction):\n","    def __init__(self,**parms):\n","        super(MyPrediction, self).__init__(**parms)\n","    \n","    def predict(self,data):\n","        return np.random.random()"],"execution_count":17,"outputs":[]},{"cell_type":"code","metadata":{"id":"pEOI35QebV4T"},"source":["Model = MyPrediction()"],"execution_count":13,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"fyr0o-6fbeFj","outputId":"b2f4c483-7cf9-4909-c9f3-a4c850b071ac"},"source":["Model.run_test()"],"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       prediction\n","0        0.201227\n","1        0.748726\n","2        0.975932\n","3        0.888833\n","4        0.367692\n","...           ...\n","27876    0.123522\n","27877    0.278963\n","27878    0.744994\n","27879    0.614484\n","27880    0.368264\n","\n","[27881 rows x 1 columns]"],"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>prediction</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0.201227</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0.748726</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0.975932</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0.888833</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0.367692</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>27876</th>\n      <td>0.123522</td>\n    </tr>\n    <tr>\n      <th>27877</th>\n      <td>0.278963</td>\n    </tr>\n    <tr>\n      <th>27878</th>\n      <td>0.744994</td>\n    </tr>\n    <tr>\n      <th>27879</th>\n      <td>0.614484</td>\n    </tr>\n    <tr>\n      <th>27880</th>\n      <td>0.368264</td>\n    </tr>\n  </tbody>\n</table>\n<p>27881 rows × 1 columns</p>\n</div>"},"metadata":{},"execution_count":14}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"USf83J4WbY8a","outputId":"78ae748f-d2bc-4a59-a358-0e9a83da6d0e"},"source":["Model.run_validate()"],"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       prediction\n","0        0.896560\n","1        0.337314\n","2        0.913970\n","3        0.095970\n","4        0.785892\n","...           ...\n","21247    0.740389\n","21248    0.429032\n","21249    0.944130\n","21250    0.750963\n","21251    0.165739\n","\n","[21252 rows x 1 columns]"],"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>prediction</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0.896560</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0.337314</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0.913970</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0.095970</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0.785892</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>21247</th>\n      <td>0.740389</td>\n    </tr>\n    <tr>\n      <th>21248</th>\n      <td>0.429032</td>\n    </tr>\n    <tr>\n      <th>21249</th>\n      <td>0.944130</td>\n    </tr>\n    <tr>\n      <th>21250</th>\n      <td>0.750963</td>\n    </tr>\n    <tr>\n      <th>21251</th>\n      <td>0.165739</td>\n    </tr>\n  </tbody>\n</table>\n<p>21252 rows × 1 columns</p>\n</div>"},"metadata":{},"execution_count":15}]},{"cell_type":"markdown","metadata":{"id":"v_C7jCalbdBp"},"source":["## ML challenge"]},{"cell_type":"code","metadata":{"id":"apoJ-eK74Z8n"},"source":["from algothon2021ml import ML\n","import pandas as pd\n","import numpy as np "],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"c19hrkgG5JfR"},"source":["class MyPrediction(ML):\n","    def __init__(self,**parms):\n","        super(MyPrediction, self).__init__(**parms)\n","    \n","    def predict(self,data):\n","        return 1"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"tpbO2PbV5gUB"},"source":["Model = MyPrediction()"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"-8OGA87g5g57","outputId":"73a007c4-5c24-4073-cf7c-c08013921af9"},"source":["Model.run_test()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Trade_date</th>\n","      <th>Market</th>\n","      <th>prediction</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2018-01-02</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2018-01-11</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2018-01-25</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2018-01-26</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2018-01-29</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2181</th>\n","      <td>2021-03-01</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2182</th>\n","      <td>2021-03-04</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2183</th>\n","      <td>2021-03-05</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2184</th>\n","      <td>2021-03-09</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2185</th>\n","      <td>2021-03-11</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>2186 rows × 3 columns</p>\n","</div>"],"text/plain":["      Trade_date   Market  prediction\n","0     2018-01-02   bond_1           1\n","1     2018-01-11   bond_1           1\n","2     2018-01-25   bond_1           1\n","3     2018-01-26   bond_1           1\n","4     2018-01-29   bond_1           1\n","...          ...      ...         ...\n","2181  2021-03-01  stock_2           1\n","2182  2021-03-04  stock_2           1\n","2183  2021-03-05  stock_2           1\n","2184  2021-03-09  stock_2           1\n","2185  2021-03-11  stock_2           1\n","\n","[2186 rows x 3 columns]"]},"metadata":{"tags":[]},"execution_count":11}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"dlFw_q8r5jdf","outputId":"28ad8c9a-8edc-409a-b440-4dbbc8a32401"},"source":["Model.run_validate()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Trade_date</th>\n","      <th>Market</th>\n","      <th>prediction</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2016-01-04</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2016-01-05</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2016-01-06</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2016-01-11</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2016-01-13</td>\n","      <td>bond_1</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>1084</th>\n","      <td>2017-10-27</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1085</th>\n","      <td>2017-11-09</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1086</th>\n","      <td>2017-11-16</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1087</th>\n","      <td>2017-11-30</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1088</th>\n","      <td>2017-12-15</td>\n","      <td>stock_2</td>\n","      <td>1</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1089 rows × 3 columns</p>\n","</div>"],"text/plain":["      Trade_date   Market  prediction\n","0     2016-01-04   bond_1           1\n","1     2016-01-05   bond_1           1\n","2     2016-01-06   bond_1           1\n","3     2016-01-11   bond_1           1\n","4     2016-01-13   bond_1           1\n","...          ...      ...         ...\n","1084  2017-10-27  stock_2           1\n","1085  2017-11-09  stock_2           1\n","1086  2017-11-16  stock_2           1\n","1087  2017-11-30  stock_2           1\n","1088  2017-12-15  stock_2           1\n","\n","[1089 rows x 3 columns]"]},"metadata":{"tags":[]},"execution_count":12}]},{"cell_type":"code","metadata":{"id":"xEoM7P485nGx"},"source":[],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"I1oTwVhS5pLn"},"source":["## Long Short Equity challenge "]},{"cell_type":"code","metadata":{"id":"J0pi8DO35rBS","executionInfo":{"status":"ok","timestamp":1616849329565,"user_tz":0,"elapsed":4120,"user":{"displayName":"thomas","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ghlf6Pz9w7HtpuCZpDO0azd-mD4P2ALY-jNUKMOqw=s64","userId":"06101255495478084616"}}},"source":["from algothon2021long_short import LongShort\n","import numpy as np"],"execution_count":3,"outputs":[]},{"cell_type":"code","metadata":{"id":"5ysM2rSb5rD0","executionInfo":{"status":"ok","timestamp":1616849359594,"user_tz":0,"elapsed":602,"user":{"displayName":"thomas","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ghlf6Pz9w7HtpuCZpDO0azd-mD4P2ALY-jNUKMOqw=s64","userId":"06101255495478084616"}}},"source":["class myLongShort(LongShort):\n","    def __init__(self, **params):\n","        super(myLongShort, self).__init__(**params)\n","\n","    def predict(self, data):\n","        return 0"],"execution_count":7,"outputs":[]},{"cell_type":"code","metadata":{"id":"IBiKTzfC_jhS","executionInfo":{"status":"ok","timestamp":1616849360880,"user_tz":0,"elapsed":407,"user":{"displayName":"thomas","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ghlf6Pz9w7HtpuCZpDO0azd-mD4P2ALY-jNUKMOqw=s64","userId":"06101255495478084616"}}},"source":["model = myLongShort(sector=3,validation_predictions_file=\"validation_predictions.csv\",test_predictions_file = \"test_predictions.csv\")"],"execution_count":8,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"GgFC1J7T_l1A","executionInfo":{"status":"ok","timestamp":1616849362343,"user_tz":0,"elapsed":758,"user":{"displayName":"thomas","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ghlf6Pz9w7HtpuCZpDO0azd-mD4P2ALY-jNUKMOqw=s64","userId":"06101255495478084616"}},"outputId":"a9ab89be-6d15-43da-d25d-2762b5070c0c"},"source":["model.run_validate()"],"execution_count":9,"outputs":[{"output_type":"execute_result","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>11</th>\n","      <th>12</th>\n","      <th>13</th>\n","      <th>14</th>\n","      <th>15</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>372</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>373</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>374</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>375</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>376</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>377 rows × 5 columns</p>\n","</div>"],"text/plain":["     11  12  13  14  15\n","0     0   0   0   0   0\n","1     0   0   0   0   0\n","2     0   0   0   0   0\n","3     0   0   0   0   0\n","4     0   0   0   0   0\n","..   ..  ..  ..  ..  ..\n","372   0   0   0   0   0\n","373   0   0   0   0   0\n","374   0   0   0   0   0\n","375   0   0   0   0   0\n","376   0   0   0   0   0\n","\n","[377 rows x 5 columns]"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":415},"id":"DebTqxPXALs9","outputId":"f7c1f623-c88f-4140-8b99-a2bfaf408dd8"},"source":["model.run_test()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>11</th>\n","      <th>12</th>\n","      <th>13</th>\n","      <th>14</th>\n","      <th>15</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>371</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>372</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>373</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>374</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>375</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>376 rows × 5 columns</p>\n","</div>"],"text/plain":["     11  12  13  14  15\n","0     0   0   0   0   0\n","1     0   0   0   0   0\n","2     0   0   0   0   0\n","3     0   0   0   0   0\n","4     0   0   0   0   0\n","..   ..  ..  ..  ..  ..\n","371   0   0   0   0   0\n","372   0   0   0   0   0\n","373   0   0   0   0   0\n","374   0   0   0   0   0\n","375   0   0   0   0   0\n","\n","[376 rows x 5 columns]"]},"metadata":{"tags":[]},"execution_count":29}]},{"cell_type":"code","metadata":{"id":"qua8YmB_JLFw"},"source":[],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"I-xZ8bgyJLLL"},"source":[],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"3E49b2BPWV0P"},"source":["## ESG challenge"]},{"cell_type":"code","metadata":{"id":"_9HlG_H0AOXO"},"source":["from algothon2021esg import EsgChallenge\n","import pandas as pd\n","import numpy as np"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"i2ZkA6RIYxUH"},"source":["validate_path = 'esg_validate_features.csv'\n","test_path = 'esg_test_features.csv'"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"w2LwARHUSbpJ"},"source":["class MyEsgChallenge(EsgChallenge):\n","    def __init__(self,**parms):\n","        super(MyEsgChallenge, self).__init__(**parms)\n","    \n","    def predict(self,data):\n","        self.StockIDs = data[data.columns.get_level_values(0)[-1]].columns\n","        self.nStocks = len(self.StockIDs)\n","        \n","        weights = np.zeros(self.nStocks)\n","        for i, stock in enumerate(self.StockIDs):\n","            if data['esg_filter'][stock].values[0]:\n","                weights[i] = 1\n","        weights /= sum(weights)\n","        return weights"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"7uDRSiYZWqsD"},"source":["Model = MyEsgChallenge(validate_features=validate_path,test_features=test_path)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"tPq19NNJWwR8","colab":{"base_uri":"https://localhost:8080/","height":435},"outputId":"35c465e6-ea0f-40cc-ba24-4a7d550c5a72"},"source":["Model.run_validate()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Asset0</th>\n","      <th>Asset1</th>\n","      <th>Asset2</th>\n","      <th>Asset3</th>\n","      <th>Asset4</th>\n","      <th>Asset5</th>\n","      <th>Asset6</th>\n","      <th>Asset7</th>\n","      <th>Asset8</th>\n","      <th>Asset9</th>\n","      <th>Asset10</th>\n","      <th>Asset11</th>\n","      <th>Asset12</th>\n","      <th>Asset13</th>\n","      <th>Asset14</th>\n","      <th>Asset15</th>\n","      <th>Asset16</th>\n","      <th>Asset17</th>\n","      <th>Asset18</th>\n","      <th>Asset19</th>\n","      <th>Asset20</th>\n","      <th>Asset21</th>\n","      <th>Asset22</th>\n","      <th>Asset23</th>\n","      <th>Asset24</th>\n","      <th>Asset25</th>\n","      <th>Asset26</th>\n","      <th>Asset27</th>\n","      <th>Asset28</th>\n","      <th>Asset29</th>\n","      <th>Asset30</th>\n","      <th>Asset31</th>\n","      <th>Asset32</th>\n","      <th>Asset33</th>\n","      <th>Asset34</th>\n","      <th>Asset35</th>\n","      <th>Asset36</th>\n","      <th>Asset37</th>\n","      <th>Asset38</th>\n","      <th>Asset39</th>\n","      <th>...</th>\n","      <th>Asset547</th>\n","      <th>Asset548</th>\n","      <th>Asset549</th>\n","      <th>Asset550</th>\n","      <th>Asset551</th>\n","      <th>Asset552</th>\n","      <th>Asset553</th>\n","      <th>Asset554</th>\n","      <th>Asset555</th>\n","      <th>Asset556</th>\n","      <th>Asset557</th>\n","      <th>Asset558</th>\n","      <th>Asset559</th>\n","      <th>Asset560</th>\n","      <th>Asset561</th>\n","      <th>Asset562</th>\n","      <th>Asset563</th>\n","      <th>Asset564</th>\n","      <th>Asset565</th>\n","      <th>Asset566</th>\n","      <th>Asset567</th>\n","      <th>Asset568</th>\n","      <th>Asset569</th>\n","      <th>Asset570</th>\n","      <th>Asset571</th>\n","      <th>Asset572</th>\n","      <th>Asset573</th>\n","      <th>Asset574</th>\n","      <th>Asset575</th>\n","      <th>Asset576</th>\n","      <th>Asset577</th>\n","      <th>Asset578</th>\n","      <th>Asset579</th>\n","      <th>Asset580</th>\n","      <th>Asset581</th>\n","      <th>Asset582</th>\n","      <th>Asset583</th>\n","      <th>Asset584</th>\n","      <th>Asset585</th>\n","      <th>Asset586</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>56</th>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>57</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>58</th>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003067</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>59</th>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>...</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.003135</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>60</th>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>...</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>61 rows × 587 columns</p>\n","</div>"],"text/plain":["      Asset0    Asset1    Asset2  ...  Asset584  Asset585  Asset586\n","0   0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","1   0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","2   0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","3   0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","4   0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","..       ...       ...       ...  ...       ...       ...       ...\n","56  0.000000  0.000000  0.003135  ...  0.000000  0.000000  0.000000\n","57  0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","58  0.003067  0.003067  0.003067  ...  0.000000  0.000000  0.000000\n","59  0.000000  0.000000  0.003135  ...  0.000000  0.000000  0.000000\n","60  0.001704  0.001704  0.001704  ...  0.001704  0.001704  0.001704\n","\n","[61 rows x 587 columns]"]},"metadata":{"tags":[]},"execution_count":37}]},{"cell_type":"code","metadata":{"id":"UV-91fsiWzBH","colab":{"base_uri":"https://localhost:8080/","height":470},"outputId":"e622962b-6c5e-4cf2-95af-5d43c3cc016a"},"source":["Model.run_test()"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:2828: DtypeWarning: Columns (3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,3542,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3553,3554,3555,3556,3557,3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3599,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659,3660,3661,3662,3663,3664,3665,3666,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3683,3684,3685,3686,3687,3688,3689,3690,3691,3692,3693,3694,3695,3696,3697,3698,3699,3700,3701,3702,3703,3704,3705,3706,3707,3708,3709,3710,3711,3712,3713,3714,3715,3716,3717,3718,3719,3720,3721,3722,3723,3724,3725,3726,3727,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,3755,3756,3757,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3773,3774,3775,3776,3777,3778,3779,3780,3781,3782,3783,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,3797,3798,3799,3800,3801,3802,3803,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3839,3840,3841,3842,3843,3844,3845,3846,3847,3848,3849,3850,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3861,3862,3863,3864,3865,3866,3867,3868,3869,3870,3871,3872,3873,3874,3875,3876,3877,3878,3879,3880,3881,3882,3883,3884,3885,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896,3897,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911,3912,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3924,3925,3926,3927,3928,3929,3930,3931,3932,3933,3934,3935,3936,3937,3938,3939,3940,3941,3942,3943,3944,3945,3946,3947,3948,3949,3950,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,3978,3979,3980,3981,3982,3983,3984,3985,3986,3987,3988,3989,3990,3991,3992,3993,3994,3995,3996,3997,3998,3999,4000,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4031,4032,4033,4034,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048,4049,4050,4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090,4091,4092,4093,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4105,4106,4107,4108,4109,8806,8807,8808,8809,8810,8811,8812,8813,8814,8815,8816,8817,8818,8819,8820,8821,8822,8823,8824,8825,8826,8827,8828,8829,8830,8831,8832,8833,8834,8835,8836,8837,8838,8839,8840,8841,8842,8843,8844,8845,8846,8847,8848,8849,8850,8851,8852,8853,8854,8855,8856,8857,8858,8859,8860,8861,8862,8863,8864,8865,8866,8867,8868,8869,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8897,8898,8899,8900,8901,8902,8903,8904,8905,8906,8907,8908,8909,8910,8911,8912,8913,8914,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8937,8938,8939,8940,8941,8942,8943,8944,8945,8946,8947,8948,8949,8950,8951,8952,8953,8954,8955,8956,8957,8958,8959,8960,8961,8962,8963,8964,8965,8966,8967,8968,8969,8970,8971,8972,8973,8974,8975,8976,8977,8978,8979,8980,8981,8982,8983,8984,8985,8986,8987,8988,8989,8990,8991,8992,8993,8994,8995,8996,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9026,9027,9028,9029,9030,9031,9032,9033,9034,9035,9036,9037,9038,9039,9040,9041,9042,9043,9044,9045,9046,9047,9048,9049,9050,9051,9052,9053,9054,9055,9056,9057,9058,9059,9060,9061,9062,9063,9064,9065,9066,9067,9068,9069,9070,9071,9072,9073,9074,9075,9076,9077,9078,9079,9080,9081,9082,9083,9084,9085,9086,9087,9088,9089,9090,9091,9092,9093,9094,9095,9096,9097,9098,9099,9100,9101,9102,9103,9104,9105,9106,9107,9108,9109,9110,9111,9112,9113,9114,9115,9116,9117,9118,9119,9120,9121,9122,9123,9124,9125,9126,9127,9128,9129,9130,9131,9132,9133,9134,9135,9136,9137,9138,9139,9140,9141,9142,9143,9144,9145,9146,9147,9148,9149,9150,9151,9152,9153,9154,9155,9156,9157,9158,9159,9160,9161,9162,9163,9164,9165,9166,9167,9168,9169,9170,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9184,9185,9186,9187,9188,9189,9190,9191,9192,9193,9194,9195,9196,9197,9198,9199,9200,9201,9202,9203,9204,9205,9206,9207,9208,9209,9210,9211,9212,9213,9214,9215,9216,9217,9218,9219,9220,9221,9222,9223,9224,9225,9226,9227,9228,9229,9230,9231,9232,9233,9234,9235,9236,9237,9238,9239,9240,9241,9242,9243,9244,9245,9246,9247,9248,9249,9250,9251,9252,9253,9254,9255,9256,9257,9258,9259,9260,9261,9262,9263,9264,9265,9266,9267,9268,9269,9270,9271,9272,9273,9274,9275,9276,9277,9278,9279,9280,9281,9282,9283,9284,9285,9286,9287,9288,9289,9290,9291,9292,9293,9294,9295,9296,9297,9298,9299,9300,9301,9302,9303,9304,9305,9306,9307,9308,9309,9310,9311,9312,9313,9314,9315,9316,9317,9318,9319,9320,9321,9322,9323,9324,9325,9326,9327,9328,9329,9330,9331,9332,9333,9334,9335,9336,9337,9338,9339,9340,9341,9342,9343,9344,9345,9346,9347,9348,9349,9350,9351,9352,9353,9354,9355,9356,9357,9358,9359,9360,9361,9362,9363,9364,9365,9366,9367,9368,9369,9370,9371,9372,9373,9374,9375,9376,9377,9378,9379,9380,9381,9382,9383,9384,9385,9386,9387,9388,9389,9390,9391,9392) have mixed types.Specify dtype option on import or set low_memory=False.\n","  if self.run_code(code, result):\n"],"name":"stderr"},{"output_type":"execute_result","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>Asset0</th>\n","      <th>Asset1</th>\n","      <th>Asset2</th>\n","      <th>Asset3</th>\n","      <th>Asset4</th>\n","      <th>Asset5</th>\n","      <th>Asset6</th>\n","      <th>Asset7</th>\n","      <th>Asset8</th>\n","      <th>Asset9</th>\n","      <th>Asset10</th>\n","      <th>Asset11</th>\n","      <th>Asset12</th>\n","      <th>Asset13</th>\n","      <th>Asset14</th>\n","      <th>Asset15</th>\n","      <th>Asset16</th>\n","      <th>Asset17</th>\n","      <th>Asset18</th>\n","      <th>Asset19</th>\n","      <th>Asset20</th>\n","      <th>Asset21</th>\n","      <th>Asset22</th>\n","      <th>Asset23</th>\n","      <th>Asset24</th>\n","      <th>Asset25</th>\n","      <th>Asset26</th>\n","      <th>Asset27</th>\n","      <th>Asset28</th>\n","      <th>Asset29</th>\n","      <th>Asset30</th>\n","      <th>Asset31</th>\n","      <th>Asset32</th>\n","      <th>Asset33</th>\n","      <th>Asset34</th>\n","      <th>Asset35</th>\n","      <th>Asset36</th>\n","      <th>Asset37</th>\n","      <th>Asset38</th>\n","      <th>Asset39</th>\n","      <th>...</th>\n","      <th>Asset547</th>\n","      <th>Asset548</th>\n","      <th>Asset549</th>\n","      <th>Asset550</th>\n","      <th>Asset551</th>\n","      <th>Asset552</th>\n","      <th>Asset553</th>\n","      <th>Asset554</th>\n","      <th>Asset555</th>\n","      <th>Asset556</th>\n","      <th>Asset557</th>\n","      <th>Asset558</th>\n","      <th>Asset559</th>\n","      <th>Asset560</th>\n","      <th>Asset561</th>\n","      <th>Asset562</th>\n","      <th>Asset563</th>\n","      <th>Asset564</th>\n","      <th>Asset565</th>\n","      <th>Asset566</th>\n","      <th>Asset567</th>\n","      <th>Asset568</th>\n","      <th>Asset569</th>\n","      <th>Asset570</th>\n","      <th>Asset571</th>\n","      <th>Asset572</th>\n","      <th>Asset573</th>\n","      <th>Asset574</th>\n","      <th>Asset575</th>\n","      <th>Asset576</th>\n","      <th>Asset577</th>\n","      <th>Asset578</th>\n","      <th>Asset579</th>\n","      <th>Asset580</th>\n","      <th>Asset581</th>\n","      <th>Asset582</th>\n","      <th>Asset583</th>\n","      <th>Asset584</th>\n","      <th>Asset585</th>\n","      <th>Asset586</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>...</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>...</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>163</th>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>...</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.003145</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>164</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>165</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>166</th>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>...</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.003096</td>\n","      <td>0.003096</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>167</th>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>...</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","      <td>0.001704</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>168 rows × 587 columns</p>\n","</div>"],"text/plain":["       Asset0    Asset1    Asset2  ...  Asset584  Asset585  Asset586\n","0    0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","1    0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","2    0.000000  0.000000  0.000000  ...  0.003145  0.000000  0.000000\n","3    0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","4    0.000000  0.000000  0.000000  ...  0.003145  0.000000  0.000000\n","..        ...       ...       ...  ...       ...       ...       ...\n","163  0.000000  0.000000  0.000000  ...  0.003145  0.000000  0.000000\n","164  0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","165  0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","166  0.003096  0.003096  0.003096  ...  0.000000  0.000000  0.000000\n","167  0.001704  0.001704  0.001704  ...  0.001704  0.001704  0.001704\n","\n","[168 rows x 587 columns]"]},"metadata":{"tags":[]},"execution_count":38}]}]}