change_decimals.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r\"C:\\Users\\sigit\\OneDrive\\TSI\\thesis\\thesis-rag\\ballad\\results\\results_report.csv\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>System</th>\n",
       "      <th>Faithfulness</th>\n",
       "      <th>Answer Relevancy</th>\n",
       "      <th>Context Precision</th>\n",
       "      <th>Context Recall</th>\n",
       "      <th>Answer Similarity</th>\n",
       "      <th>Answer Correctness</th>\n",
       "      <th>Average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GPT-3.5</td>\n",
       "      <td>0.971429</td>\n",
       "      <td>0.745413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.866096</td>\n",
       "      <td>0.660199</td>\n",
       "      <td>0.810784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Naive</td>\n",
       "      <td>0.881621</td>\n",
       "      <td>0.726491</td>\n",
       "      <td>0.512500</td>\n",
       "      <td>0.693275</td>\n",
       "      <td>0.683565</td>\n",
       "      <td>0.715710</td>\n",
       "      <td>0.702194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Recursive</td>\n",
       "      <td>0.865996</td>\n",
       "      <td>0.729346</td>\n",
       "      <td>0.512500</td>\n",
       "      <td>0.580707</td>\n",
       "      <td>0.816281</td>\n",
       "      <td>0.789784</td>\n",
       "      <td>0.715769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Chunk 500, overlap 0%</td>\n",
       "      <td>0.866667</td>\n",
       "      <td>0.884760</td>\n",
       "      <td>0.376543</td>\n",
       "      <td>0.435185</td>\n",
       "      <td>0.866883</td>\n",
       "      <td>0.664614</td>\n",
       "      <td>0.682442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chunk 500, overlap 5%</td>\n",
       "      <td>0.680952</td>\n",
       "      <td>0.901854</td>\n",
       "      <td>0.441358</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.863189</td>\n",
       "      <td>0.652780</td>\n",
       "      <td>0.701133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chunk 500, overlap 10%</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.885184</td>\n",
       "      <td>0.450617</td>\n",
       "      <td>0.592593</td>\n",
       "      <td>0.863726</td>\n",
       "      <td>0.662760</td>\n",
       "      <td>0.709147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chunk 500, overlap 15%</td>\n",
       "      <td>0.826190</td>\n",
       "      <td>0.879043</td>\n",
       "      <td>0.645062</td>\n",
       "      <td>0.824074</td>\n",
       "      <td>0.869306</td>\n",
       "      <td>0.631235</td>\n",
       "      <td>0.779152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Chunk 500, overlap 20%</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.903706</td>\n",
       "      <td>0.506173</td>\n",
       "      <td>0.675926</td>\n",
       "      <td>0.872395</td>\n",
       "      <td>0.586756</td>\n",
       "      <td>0.709874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chunk 1000, overlap 0%</td>\n",
       "      <td>0.834282</td>\n",
       "      <td>0.723396</td>\n",
       "      <td>0.487500</td>\n",
       "      <td>0.689591</td>\n",
       "      <td>0.780951</td>\n",
       "      <td>0.769929</td>\n",
       "      <td>0.714275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Chunk 1000, overlap 5%</td>\n",
       "      <td>0.859269</td>\n",
       "      <td>0.710329</td>\n",
       "      <td>0.520833</td>\n",
       "      <td>0.567662</td>\n",
       "      <td>0.789020</td>\n",
       "      <td>0.710835</td>\n",
       "      <td>0.692992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Chunk 1000, overlap 10%</td>\n",
       "      <td>0.833369</td>\n",
       "      <td>0.724186</td>\n",
       "      <td>0.472222</td>\n",
       "      <td>0.635688</td>\n",
       "      <td>0.677939</td>\n",
       "      <td>0.762695</td>\n",
       "      <td>0.684350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Chunk 1000, overlap 15%</td>\n",
       "      <td>0.809964</td>\n",
       "      <td>0.719308</td>\n",
       "      <td>0.519048</td>\n",
       "      <td>0.558069</td>\n",
       "      <td>0.735682</td>\n",
       "      <td>0.784538</td>\n",
       "      <td>0.687768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Chunk 1000, overlap 20%</td>\n",
       "      <td>0.808816</td>\n",
       "      <td>0.718937</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.538053</td>\n",
       "      <td>0.763482</td>\n",
       "      <td>0.799512</td>\n",
       "      <td>0.668292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Chunk 2000, overlap 0%</td>\n",
       "      <td>0.788936</td>\n",
       "      <td>0.747135</td>\n",
       "      <td>0.470833</td>\n",
       "      <td>0.693106</td>\n",
       "      <td>0.660520</td>\n",
       "      <td>0.555794</td>\n",
       "      <td>0.652721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Chunk 2000, overlap 5%</td>\n",
       "      <td>0.819300</td>\n",
       "      <td>0.724491</td>\n",
       "      <td>0.537037</td>\n",
       "      <td>0.653868</td>\n",
       "      <td>0.765334</td>\n",
       "      <td>0.596272</td>\n",
       "      <td>0.682717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Chunk 2000, overlap 10%</td>\n",
       "      <td>0.894395</td>\n",
       "      <td>0.730272</td>\n",
       "      <td>0.470833</td>\n",
       "      <td>0.560752</td>\n",
       "      <td>0.678642</td>\n",
       "      <td>0.799907</td>\n",
       "      <td>0.689133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Chunk 2000, overlap 15%</td>\n",
       "      <td>0.762022</td>\n",
       "      <td>0.723838</td>\n",
       "      <td>0.442857</td>\n",
       "      <td>0.579288</td>\n",
       "      <td>0.733706</td>\n",
       "      <td>0.766451</td>\n",
       "      <td>0.668027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chunk 2000, overlap 20%</td>\n",
       "      <td>0.859328</td>\n",
       "      <td>0.730800</td>\n",
       "      <td>0.470833</td>\n",
       "      <td>0.675626</td>\n",
       "      <td>0.699462</td>\n",
       "      <td>0.725637</td>\n",
       "      <td>0.693614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Chunk 3000, overlap 0%</td>\n",
       "      <td>0.864944</td>\n",
       "      <td>0.729709</td>\n",
       "      <td>0.637500</td>\n",
       "      <td>0.689309</td>\n",
       "      <td>0.733664</td>\n",
       "      <td>0.805561</td>\n",
       "      <td>0.743448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Chunk 3000, overlap 5%</td>\n",
       "      <td>0.862070</td>\n",
       "      <td>0.747021</td>\n",
       "      <td>0.464286</td>\n",
       "      <td>0.729848</td>\n",
       "      <td>0.670983</td>\n",
       "      <td>0.641577</td>\n",
       "      <td>0.685964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Chunk 3000, overlap 10%</td>\n",
       "      <td>0.863684</td>\n",
       "      <td>0.711061</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.579188</td>\n",
       "      <td>0.677831</td>\n",
       "      <td>0.758354</td>\n",
       "      <td>0.681686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chunk 3000, overlap 15%</td>\n",
       "      <td>0.884277</td>\n",
       "      <td>0.744819</td>\n",
       "      <td>0.414583</td>\n",
       "      <td>0.577723</td>\n",
       "      <td>0.736018</td>\n",
       "      <td>0.577863</td>\n",
       "      <td>0.655881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Chunk 3000, overlap 20%</td>\n",
       "      <td>0.877549</td>\n",
       "      <td>0.747584</td>\n",
       "      <td>0.458333</td>\n",
       "      <td>0.747531</td>\n",
       "      <td>0.724320</td>\n",
       "      <td>0.648772</td>\n",
       "      <td>0.700682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=2</td>\n",
       "      <td>0.740000</td>\n",
       "      <td>0.880395</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.729630</td>\n",
       "      <td>0.870647</td>\n",
       "      <td>0.659500</td>\n",
       "      <td>0.757806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=3</td>\n",
       "      <td>0.750577</td>\n",
       "      <td>0.806049</td>\n",
       "      <td>0.775391</td>\n",
       "      <td>0.453704</td>\n",
       "      <td>0.804792</td>\n",
       "      <td>0.757130</td>\n",
       "      <td>0.724607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=5</td>\n",
       "      <td>0.966667</td>\n",
       "      <td>0.905295</td>\n",
       "      <td>0.636883</td>\n",
       "      <td>0.944444</td>\n",
       "      <td>0.874627</td>\n",
       "      <td>0.631657</td>\n",
       "      <td>0.826595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=6</td>\n",
       "      <td>0.792857</td>\n",
       "      <td>0.897322</td>\n",
       "      <td>0.681821</td>\n",
       "      <td>0.675926</td>\n",
       "      <td>0.866473</td>\n",
       "      <td>0.624575</td>\n",
       "      <td>0.756496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=7</td>\n",
       "      <td>0.693972</td>\n",
       "      <td>0.747306</td>\n",
       "      <td>0.844508</td>\n",
       "      <td>0.625705</td>\n",
       "      <td>0.824804</td>\n",
       "      <td>0.771200</td>\n",
       "      <td>0.751249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Parent Retriever 1000-200</td>\n",
       "      <td>0.731250</td>\n",
       "      <td>0.582884</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.685185</td>\n",
       "      <td>0.862021</td>\n",
       "      <td>0.573332</td>\n",
       "      <td>0.646519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Parent Retriever 500-100</td>\n",
       "      <td>0.815535</td>\n",
       "      <td>0.880237</td>\n",
       "      <td>0.719369</td>\n",
       "      <td>0.648148</td>\n",
       "      <td>0.850717</td>\n",
       "      <td>0.738159</td>\n",
       "      <td>0.775361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Parent Retriever 1500-200</td>\n",
       "      <td>0.775000</td>\n",
       "      <td>0.792080</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.768519</td>\n",
       "      <td>0.869522</td>\n",
       "      <td>0.612883</td>\n",
       "      <td>0.710408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>MMR</td>\n",
       "      <td>0.792857</td>\n",
       "      <td>0.898714</td>\n",
       "      <td>0.738735</td>\n",
       "      <td>0.888889</td>\n",
       "      <td>0.874188</td>\n",
       "      <td>0.649778</td>\n",
       "      <td>0.807193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>BM25</td>\n",
       "      <td>0.851285</td>\n",
       "      <td>0.577793</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.880525</td>\n",
       "      <td>0.600237</td>\n",
       "      <td>0.779732</td>\n",
       "      <td>0.741913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Ensambler 1</td>\n",
       "      <td>0.862500</td>\n",
       "      <td>0.896181</td>\n",
       "      <td>0.641499</td>\n",
       "      <td>0.712963</td>\n",
       "      <td>0.883615</td>\n",
       "      <td>0.675582</td>\n",
       "      <td>0.778723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Ensambler 2</td>\n",
       "      <td>0.911111</td>\n",
       "      <td>0.899975</td>\n",
       "      <td>0.631411</td>\n",
       "      <td>0.944444</td>\n",
       "      <td>0.883797</td>\n",
       "      <td>0.678357</td>\n",
       "      <td>0.824849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ensambler 3</td>\n",
       "      <td>0.828580</td>\n",
       "      <td>0.589649</td>\n",
       "      <td>0.975000</td>\n",
       "      <td>0.784893</td>\n",
       "      <td>0.551250</td>\n",
       "      <td>0.887134</td>\n",
       "      <td>0.769418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Search query</td>\n",
       "      <td>0.826606</td>\n",
       "      <td>0.613022</td>\n",
       "      <td>0.587500</td>\n",
       "      <td>0.530187</td>\n",
       "      <td>0.767127</td>\n",
       "      <td>0.511787</td>\n",
       "      <td>0.639372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=5- GPT4</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.745908</td>\n",
       "      <td>0.658642</td>\n",
       "      <td>0.944444</td>\n",
       "      <td>0.886735</td>\n",
       "      <td>0.725199</td>\n",
       "      <td>0.826822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ensambler 2, GPT-4</td>\n",
       "      <td>0.947619</td>\n",
       "      <td>0.879338</td>\n",
       "      <td>0.689436</td>\n",
       "      <td>0.922222</td>\n",
       "      <td>0.892164</td>\n",
       "      <td>0.684419</td>\n",
       "      <td>0.835866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>MMR GPT4</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.869917</td>\n",
       "      <td>0.738735</td>\n",
       "      <td>0.888889</td>\n",
       "      <td>0.871896</td>\n",
       "      <td>0.719863</td>\n",
       "      <td>0.848217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>GPT-4</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.783206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.861252</td>\n",
       "      <td>0.678698</td>\n",
       "      <td>0.830789</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    System  Faithfulness  Answer Relevancy  \\\n",
       "0                                  GPT-3.5      0.971429          0.745413   \n",
       "1                                    Naive      0.881621          0.726491   \n",
       "2                                Recursive      0.865996          0.729346   \n",
       "3                    Chunk 500, overlap 0%      0.866667          0.884760   \n",
       "4                    Chunk 500, overlap 5%      0.680952          0.901854   \n",
       "5                   Chunk 500, overlap 10%      0.800000          0.885184   \n",
       "6                   Chunk 500, overlap 15%      0.826190          0.879043   \n",
       "7                   Chunk 500, overlap 20%      0.714286          0.903706   \n",
       "8                   Chunk 1000, overlap 0%      0.834282          0.723396   \n",
       "9                   Chunk 1000, overlap 5%      0.859269          0.710329   \n",
       "10                 Chunk 1000, overlap 10%      0.833369          0.724186   \n",
       "11                 Chunk 1000, overlap 15%      0.809964          0.719308   \n",
       "12                 Chunk 1000, overlap 20%      0.808816          0.718937   \n",
       "13                  Chunk 2000, overlap 0%      0.788936          0.747135   \n",
       "14                  Chunk 2000, overlap 5%      0.819300          0.724491   \n",
       "15                 Chunk 2000, overlap 10%      0.894395          0.730272   \n",
       "16                 Chunk 2000, overlap 15%      0.762022          0.723838   \n",
       "17                 Chunk 2000, overlap 20%      0.859328          0.730800   \n",
       "18                  Chunk 3000, overlap 0%      0.864944          0.729709   \n",
       "19                  Chunk 3000, overlap 5%      0.862070          0.747021   \n",
       "20                 Chunk 3000, overlap 10%      0.863684          0.711061   \n",
       "21                 Chunk 3000, overlap 15%      0.884277          0.744819   \n",
       "22                 Chunk 3000, overlap 20%      0.877549          0.747584   \n",
       "23        Chunk size 500, overlap 15%, K=2      0.740000          0.880395   \n",
       "24        Chunk size 500, overlap 15%, K=3      0.750577          0.806049   \n",
       "25        Chunk size 500, overlap 15%, K=5      0.966667          0.905295   \n",
       "26        Chunk size 500, overlap 15%, K=6      0.792857          0.897322   \n",
       "27        Chunk size 500, overlap 15%, K=7      0.693972          0.747306   \n",
       "28               Parent Retriever 1000-200      0.731250          0.582884   \n",
       "29                Parent Retriever 500-100      0.815535          0.880237   \n",
       "30               Parent Retriever 1500-200      0.775000          0.792080   \n",
       "31                                     MMR      0.792857          0.898714   \n",
       "32                                    BM25      0.851285          0.577793   \n",
       "33                             Ensambler 1      0.862500          0.896181   \n",
       "34                             Ensambler 2      0.911111          0.899975   \n",
       "35                             Ensambler 3      0.828580          0.589649   \n",
       "36                            Search query      0.826606          0.613022   \n",
       "37  Chunk size 500, overlap 15%, K=5- GPT4      1.000000          0.745908   \n",
       "38                      Ensambler 2, GPT-4      0.947619          0.879338   \n",
       "39                                MMR GPT4      1.000000          0.869917   \n",
       "40                                   GPT-4      1.000000          0.783206   \n",
       "\n",
       "    Context Precision  Context Recall  Answer Similarity  Answer Correctness  \\\n",
       "0                 NaN             NaN           0.866096            0.660199   \n",
       "1            0.512500        0.693275           0.683565            0.715710   \n",
       "2            0.512500        0.580707           0.816281            0.789784   \n",
       "3            0.376543        0.435185           0.866883            0.664614   \n",
       "4            0.441358        0.666667           0.863189            0.652780   \n",
       "5            0.450617        0.592593           0.863726            0.662760   \n",
       "6            0.645062        0.824074           0.869306            0.631235   \n",
       "7            0.506173        0.675926           0.872395            0.586756   \n",
       "8            0.487500        0.689591           0.780951            0.769929   \n",
       "9            0.520833        0.567662           0.789020            0.710835   \n",
       "10           0.472222        0.635688           0.677939            0.762695   \n",
       "11           0.519048        0.558069           0.735682            0.784538   \n",
       "12           0.380952        0.538053           0.763482            0.799512   \n",
       "13           0.470833        0.693106           0.660520            0.555794   \n",
       "14           0.537037        0.653868           0.765334            0.596272   \n",
       "15           0.470833        0.560752           0.678642            0.799907   \n",
       "16           0.442857        0.579288           0.733706            0.766451   \n",
       "17           0.470833        0.675626           0.699462            0.725637   \n",
       "18           0.637500        0.689309           0.733664            0.805561   \n",
       "19           0.464286        0.729848           0.670983            0.641577   \n",
       "20           0.500000        0.579188           0.677831            0.758354   \n",
       "21           0.414583        0.577723           0.736018            0.577863   \n",
       "22           0.458333        0.747531           0.724320            0.648772   \n",
       "23           0.666667        0.729630           0.870647            0.659500   \n",
       "24           0.775391        0.453704           0.804792            0.757130   \n",
       "25           0.636883        0.944444           0.874627            0.631657   \n",
       "26           0.681821        0.675926           0.866473            0.624575   \n",
       "27           0.844508        0.625705           0.824804            0.771200   \n",
       "28           0.444444        0.685185           0.862021            0.573332   \n",
       "29           0.719369        0.648148           0.850717            0.738159   \n",
       "30           0.444444        0.768519           0.869522            0.612883   \n",
       "31           0.738735        0.888889           0.874188            0.649778   \n",
       "32           0.761905        0.880525           0.600237            0.779732   \n",
       "33           0.641499        0.712963           0.883615            0.675582   \n",
       "34           0.631411        0.944444           0.883797            0.678357   \n",
       "35           0.975000        0.784893           0.551250            0.887134   \n",
       "36           0.587500        0.530187           0.767127            0.511787   \n",
       "37           0.658642        0.944444           0.886735            0.725199   \n",
       "38           0.689436        0.922222           0.892164            0.684419   \n",
       "39           0.738735        0.888889           0.871896            0.719863   \n",
       "40                NaN             NaN           0.861252            0.678698   \n",
       "\n",
       "     Average  \n",
       "0   0.810784  \n",
       "1   0.702194  \n",
       "2   0.715769  \n",
       "3   0.682442  \n",
       "4   0.701133  \n",
       "5   0.709147  \n",
       "6   0.779152  \n",
       "7   0.709874  \n",
       "8   0.714275  \n",
       "9   0.692992  \n",
       "10  0.684350  \n",
       "11  0.687768  \n",
       "12  0.668292  \n",
       "13  0.652721  \n",
       "14  0.682717  \n",
       "15  0.689133  \n",
       "16  0.668027  \n",
       "17  0.693614  \n",
       "18  0.743448  \n",
       "19  0.685964  \n",
       "20  0.681686  \n",
       "21  0.655881  \n",
       "22  0.700682  \n",
       "23  0.757806  \n",
       "24  0.724607  \n",
       "25  0.826595  \n",
       "26  0.756496  \n",
       "27  0.751249  \n",
       "28  0.646519  \n",
       "29  0.775361  \n",
       "30  0.710408  \n",
       "31  0.807193  \n",
       "32  0.741913  \n",
       "33  0.778723  \n",
       "34  0.824849  \n",
       "35  0.769418  \n",
       "36  0.639372  \n",
       "37  0.826822  \n",
       "38  0.835866  \n",
       "39  0.848217  \n",
       "40  0.830789  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(path)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>System</th>\n",
       "      <th>Faithfulness</th>\n",
       "      <th>Answer Relevancy</th>\n",
       "      <th>Context Precision</th>\n",
       "      <th>Context Recall</th>\n",
       "      <th>Answer Similarity</th>\n",
       "      <th>Answer Correctness</th>\n",
       "      <th>Average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GPT-3.5</td>\n",
       "      <td>0.971</td>\n",
       "      <td>0.745</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.866</td>\n",
       "      <td>0.660</td>\n",
       "      <td>0.811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Naive</td>\n",
       "      <td>0.882</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.512</td>\n",
       "      <td>0.693</td>\n",
       "      <td>0.684</td>\n",
       "      <td>0.716</td>\n",
       "      <td>0.702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Recursive</td>\n",
       "      <td>0.866</td>\n",
       "      <td>0.729</td>\n",
       "      <td>0.512</td>\n",
       "      <td>0.581</td>\n",
       "      <td>0.816</td>\n",
       "      <td>0.790</td>\n",
       "      <td>0.716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Chunk 500, overlap 0%</td>\n",
       "      <td>0.867</td>\n",
       "      <td>0.885</td>\n",
       "      <td>0.377</td>\n",
       "      <td>0.435</td>\n",
       "      <td>0.867</td>\n",
       "      <td>0.665</td>\n",
       "      <td>0.682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chunk 500, overlap 5%</td>\n",
       "      <td>0.681</td>\n",
       "      <td>0.902</td>\n",
       "      <td>0.441</td>\n",
       "      <td>0.667</td>\n",
       "      <td>0.863</td>\n",
       "      <td>0.653</td>\n",
       "      <td>0.701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chunk 500, overlap 10%</td>\n",
       "      <td>0.800</td>\n",
       "      <td>0.885</td>\n",
       "      <td>0.451</td>\n",
       "      <td>0.593</td>\n",
       "      <td>0.864</td>\n",
       "      <td>0.663</td>\n",
       "      <td>0.709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Chunk 500, overlap 15%</td>\n",
       "      <td>0.826</td>\n",
       "      <td>0.879</td>\n",
       "      <td>0.645</td>\n",
       "      <td>0.824</td>\n",
       "      <td>0.869</td>\n",
       "      <td>0.631</td>\n",
       "      <td>0.779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Chunk 500, overlap 20%</td>\n",
       "      <td>0.714</td>\n",
       "      <td>0.904</td>\n",
       "      <td>0.506</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.587</td>\n",
       "      <td>0.710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chunk 1000, overlap 0%</td>\n",
       "      <td>0.834</td>\n",
       "      <td>0.723</td>\n",
       "      <td>0.487</td>\n",
       "      <td>0.690</td>\n",
       "      <td>0.781</td>\n",
       "      <td>0.770</td>\n",
       "      <td>0.714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Chunk 1000, overlap 5%</td>\n",
       "      <td>0.859</td>\n",
       "      <td>0.710</td>\n",
       "      <td>0.521</td>\n",
       "      <td>0.568</td>\n",
       "      <td>0.789</td>\n",
       "      <td>0.711</td>\n",
       "      <td>0.693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Chunk 1000, overlap 10%</td>\n",
       "      <td>0.833</td>\n",
       "      <td>0.724</td>\n",
       "      <td>0.472</td>\n",
       "      <td>0.636</td>\n",
       "      <td>0.678</td>\n",
       "      <td>0.763</td>\n",
       "      <td>0.684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Chunk 1000, overlap 15%</td>\n",
       "      <td>0.810</td>\n",
       "      <td>0.719</td>\n",
       "      <td>0.519</td>\n",
       "      <td>0.558</td>\n",
       "      <td>0.736</td>\n",
       "      <td>0.785</td>\n",
       "      <td>0.688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Chunk 1000, overlap 20%</td>\n",
       "      <td>0.809</td>\n",
       "      <td>0.719</td>\n",
       "      <td>0.381</td>\n",
       "      <td>0.538</td>\n",
       "      <td>0.763</td>\n",
       "      <td>0.800</td>\n",
       "      <td>0.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Chunk 2000, overlap 0%</td>\n",
       "      <td>0.789</td>\n",
       "      <td>0.747</td>\n",
       "      <td>0.471</td>\n",
       "      <td>0.693</td>\n",
       "      <td>0.661</td>\n",
       "      <td>0.556</td>\n",
       "      <td>0.653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Chunk 2000, overlap 5%</td>\n",
       "      <td>0.819</td>\n",
       "      <td>0.724</td>\n",
       "      <td>0.537</td>\n",
       "      <td>0.654</td>\n",
       "      <td>0.765</td>\n",
       "      <td>0.596</td>\n",
       "      <td>0.683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Chunk 2000, overlap 10%</td>\n",
       "      <td>0.894</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.471</td>\n",
       "      <td>0.561</td>\n",
       "      <td>0.679</td>\n",
       "      <td>0.800</td>\n",
       "      <td>0.689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Chunk 2000, overlap 15%</td>\n",
       "      <td>0.762</td>\n",
       "      <td>0.724</td>\n",
       "      <td>0.443</td>\n",
       "      <td>0.579</td>\n",
       "      <td>0.734</td>\n",
       "      <td>0.766</td>\n",
       "      <td>0.668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chunk 2000, overlap 20%</td>\n",
       "      <td>0.859</td>\n",
       "      <td>0.731</td>\n",
       "      <td>0.471</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.699</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Chunk 3000, overlap 0%</td>\n",
       "      <td>0.865</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.637</td>\n",
       "      <td>0.689</td>\n",
       "      <td>0.734</td>\n",
       "      <td>0.806</td>\n",
       "      <td>0.743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Chunk 3000, overlap 5%</td>\n",
       "      <td>0.862</td>\n",
       "      <td>0.747</td>\n",
       "      <td>0.464</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.671</td>\n",
       "      <td>0.642</td>\n",
       "      <td>0.686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Chunk 3000, overlap 10%</td>\n",
       "      <td>0.864</td>\n",
       "      <td>0.711</td>\n",
       "      <td>0.500</td>\n",
       "      <td>0.579</td>\n",
       "      <td>0.678</td>\n",
       "      <td>0.758</td>\n",
       "      <td>0.682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Chunk 3000, overlap 15%</td>\n",
       "      <td>0.884</td>\n",
       "      <td>0.745</td>\n",
       "      <td>0.415</td>\n",
       "      <td>0.578</td>\n",
       "      <td>0.736</td>\n",
       "      <td>0.578</td>\n",
       "      <td>0.656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Chunk 3000, overlap 20%</td>\n",
       "      <td>0.878</td>\n",
       "      <td>0.748</td>\n",
       "      <td>0.458</td>\n",
       "      <td>0.748</td>\n",
       "      <td>0.724</td>\n",
       "      <td>0.649</td>\n",
       "      <td>0.701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=2</td>\n",
       "      <td>0.740</td>\n",
       "      <td>0.880</td>\n",
       "      <td>0.667</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.871</td>\n",
       "      <td>0.659</td>\n",
       "      <td>0.758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=3</td>\n",
       "      <td>0.751</td>\n",
       "      <td>0.806</td>\n",
       "      <td>0.775</td>\n",
       "      <td>0.454</td>\n",
       "      <td>0.805</td>\n",
       "      <td>0.757</td>\n",
       "      <td>0.725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=5</td>\n",
       "      <td>0.967</td>\n",
       "      <td>0.905</td>\n",
       "      <td>0.637</td>\n",
       "      <td>0.944</td>\n",
       "      <td>0.875</td>\n",
       "      <td>0.632</td>\n",
       "      <td>0.827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=6</td>\n",
       "      <td>0.793</td>\n",
       "      <td>0.897</td>\n",
       "      <td>0.682</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.866</td>\n",
       "      <td>0.625</td>\n",
       "      <td>0.756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=7</td>\n",
       "      <td>0.694</td>\n",
       "      <td>0.747</td>\n",
       "      <td>0.845</td>\n",
       "      <td>0.626</td>\n",
       "      <td>0.825</td>\n",
       "      <td>0.771</td>\n",
       "      <td>0.751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Parent Retriever 1000-200</td>\n",
       "      <td>0.731</td>\n",
       "      <td>0.583</td>\n",
       "      <td>0.444</td>\n",
       "      <td>0.685</td>\n",
       "      <td>0.862</td>\n",
       "      <td>0.573</td>\n",
       "      <td>0.647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Parent Retriever 500-100</td>\n",
       "      <td>0.816</td>\n",
       "      <td>0.880</td>\n",
       "      <td>0.719</td>\n",
       "      <td>0.648</td>\n",
       "      <td>0.851</td>\n",
       "      <td>0.738</td>\n",
       "      <td>0.775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Parent Retriever 1500-200</td>\n",
       "      <td>0.775</td>\n",
       "      <td>0.792</td>\n",
       "      <td>0.444</td>\n",
       "      <td>0.769</td>\n",
       "      <td>0.870</td>\n",
       "      <td>0.613</td>\n",
       "      <td>0.710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>MMR</td>\n",
       "      <td>0.793</td>\n",
       "      <td>0.899</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.889</td>\n",
       "      <td>0.874</td>\n",
       "      <td>0.650</td>\n",
       "      <td>0.807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>BM25</td>\n",
       "      <td>0.851</td>\n",
       "      <td>0.578</td>\n",
       "      <td>0.762</td>\n",
       "      <td>0.881</td>\n",
       "      <td>0.600</td>\n",
       "      <td>0.780</td>\n",
       "      <td>0.742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Ensambler 1</td>\n",
       "      <td>0.862</td>\n",
       "      <td>0.896</td>\n",
       "      <td>0.641</td>\n",
       "      <td>0.713</td>\n",
       "      <td>0.884</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Ensambler 2</td>\n",
       "      <td>0.911</td>\n",
       "      <td>0.900</td>\n",
       "      <td>0.631</td>\n",
       "      <td>0.944</td>\n",
       "      <td>0.884</td>\n",
       "      <td>0.678</td>\n",
       "      <td>0.825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Ensambler 3</td>\n",
       "      <td>0.829</td>\n",
       "      <td>0.590</td>\n",
       "      <td>0.975</td>\n",
       "      <td>0.785</td>\n",
       "      <td>0.551</td>\n",
       "      <td>0.887</td>\n",
       "      <td>0.769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Search query</td>\n",
       "      <td>0.827</td>\n",
       "      <td>0.613</td>\n",
       "      <td>0.587</td>\n",
       "      <td>0.530</td>\n",
       "      <td>0.767</td>\n",
       "      <td>0.512</td>\n",
       "      <td>0.639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Chunk size 500, overlap 15%, K=5- GPT4</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.746</td>\n",
       "      <td>0.659</td>\n",
       "      <td>0.944</td>\n",
       "      <td>0.887</td>\n",
       "      <td>0.725</td>\n",
       "      <td>0.827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ensambler 2, GPT-4</td>\n",
       "      <td>0.948</td>\n",
       "      <td>0.879</td>\n",
       "      <td>0.689</td>\n",
       "      <td>0.922</td>\n",
       "      <td>0.892</td>\n",
       "      <td>0.684</td>\n",
       "      <td>0.836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>MMR GPT4</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.870</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.889</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.720</td>\n",
       "      <td>0.848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>GPT-4</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.783</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.861</td>\n",
       "      <td>0.679</td>\n",
       "      <td>0.831</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    System  Faithfulness  Answer Relevancy  \\\n",
       "0                                  GPT-3.5         0.971             0.745   \n",
       "1                                    Naive         0.882             0.726   \n",
       "2                                Recursive         0.866             0.729   \n",
       "3                    Chunk 500, overlap 0%         0.867             0.885   \n",
       "4                    Chunk 500, overlap 5%         0.681             0.902   \n",
       "5                   Chunk 500, overlap 10%         0.800             0.885   \n",
       "6                   Chunk 500, overlap 15%         0.826             0.879   \n",
       "7                   Chunk 500, overlap 20%         0.714             0.904   \n",
       "8                   Chunk 1000, overlap 0%         0.834             0.723   \n",
       "9                   Chunk 1000, overlap 5%         0.859             0.710   \n",
       "10                 Chunk 1000, overlap 10%         0.833             0.724   \n",
       "11                 Chunk 1000, overlap 15%         0.810             0.719   \n",
       "12                 Chunk 1000, overlap 20%         0.809             0.719   \n",
       "13                  Chunk 2000, overlap 0%         0.789             0.747   \n",
       "14                  Chunk 2000, overlap 5%         0.819             0.724   \n",
       "15                 Chunk 2000, overlap 10%         0.894             0.730   \n",
       "16                 Chunk 2000, overlap 15%         0.762             0.724   \n",
       "17                 Chunk 2000, overlap 20%         0.859             0.731   \n",
       "18                  Chunk 3000, overlap 0%         0.865             0.730   \n",
       "19                  Chunk 3000, overlap 5%         0.862             0.747   \n",
       "20                 Chunk 3000, overlap 10%         0.864             0.711   \n",
       "21                 Chunk 3000, overlap 15%         0.884             0.745   \n",
       "22                 Chunk 3000, overlap 20%         0.878             0.748   \n",
       "23        Chunk size 500, overlap 15%, K=2         0.740             0.880   \n",
       "24        Chunk size 500, overlap 15%, K=3         0.751             0.806   \n",
       "25        Chunk size 500, overlap 15%, K=5         0.967             0.905   \n",
       "26        Chunk size 500, overlap 15%, K=6         0.793             0.897   \n",
       "27        Chunk size 500, overlap 15%, K=7         0.694             0.747   \n",
       "28               Parent Retriever 1000-200         0.731             0.583   \n",
       "29                Parent Retriever 500-100         0.816             0.880   \n",
       "30               Parent Retriever 1500-200         0.775             0.792   \n",
       "31                                     MMR         0.793             0.899   \n",
       "32                                    BM25         0.851             0.578   \n",
       "33                             Ensambler 1         0.862             0.896   \n",
       "34                             Ensambler 2         0.911             0.900   \n",
       "35                             Ensambler 3         0.829             0.590   \n",
       "36                            Search query         0.827             0.613   \n",
       "37  Chunk size 500, overlap 15%, K=5- GPT4         1.000             0.746   \n",
       "38                      Ensambler 2, GPT-4         0.948             0.879   \n",
       "39                                MMR GPT4         1.000             0.870   \n",
       "40                                   GPT-4         1.000             0.783   \n",
       "\n",
       "    Context Precision  Context Recall  Answer Similarity  Answer Correctness  \\\n",
       "0                 NaN             NaN              0.866               0.660   \n",
       "1               0.512           0.693              0.684               0.716   \n",
       "2               0.512           0.581              0.816               0.790   \n",
       "3               0.377           0.435              0.867               0.665   \n",
       "4               0.441           0.667              0.863               0.653   \n",
       "5               0.451           0.593              0.864               0.663   \n",
       "6               0.645           0.824              0.869               0.631   \n",
       "7               0.506           0.676              0.872               0.587   \n",
       "8               0.487           0.690              0.781               0.770   \n",
       "9               0.521           0.568              0.789               0.711   \n",
       "10              0.472           0.636              0.678               0.763   \n",
       "11              0.519           0.558              0.736               0.785   \n",
       "12              0.381           0.538              0.763               0.800   \n",
       "13              0.471           0.693              0.661               0.556   \n",
       "14              0.537           0.654              0.765               0.596   \n",
       "15              0.471           0.561              0.679               0.800   \n",
       "16              0.443           0.579              0.734               0.766   \n",
       "17              0.471           0.676              0.699               0.726   \n",
       "18              0.637           0.689              0.734               0.806   \n",
       "19              0.464           0.730              0.671               0.642   \n",
       "20              0.500           0.579              0.678               0.758   \n",
       "21              0.415           0.578              0.736               0.578   \n",
       "22              0.458           0.748              0.724               0.649   \n",
       "23              0.667           0.730              0.871               0.659   \n",
       "24              0.775           0.454              0.805               0.757   \n",
       "25              0.637           0.944              0.875               0.632   \n",
       "26              0.682           0.676              0.866               0.625   \n",
       "27              0.845           0.626              0.825               0.771   \n",
       "28              0.444           0.685              0.862               0.573   \n",
       "29              0.719           0.648              0.851               0.738   \n",
       "30              0.444           0.769              0.870               0.613   \n",
       "31              0.739           0.889              0.874               0.650   \n",
       "32              0.762           0.881              0.600               0.780   \n",
       "33              0.641           0.713              0.884               0.676   \n",
       "34              0.631           0.944              0.884               0.678   \n",
       "35              0.975           0.785              0.551               0.887   \n",
       "36              0.587           0.530              0.767               0.512   \n",
       "37              0.659           0.944              0.887               0.725   \n",
       "38              0.689           0.922              0.892               0.684   \n",
       "39              0.739           0.889              0.872               0.720   \n",
       "40                NaN             NaN              0.861               0.679   \n",
       "\n",
       "    Average  \n",
       "0     0.811  \n",
       "1     0.702  \n",
       "2     0.716  \n",
       "3     0.682  \n",
       "4     0.701  \n",
       "5     0.709  \n",
       "6     0.779  \n",
       "7     0.710  \n",
       "8     0.714  \n",
       "9     0.693  \n",
       "10    0.684  \n",
       "11    0.688  \n",
       "12    0.668  \n",
       "13    0.653  \n",
       "14    0.683  \n",
       "15    0.689  \n",
       "16    0.668  \n",
       "17    0.694  \n",
       "18    0.743  \n",
       "19    0.686  \n",
       "20    0.682  \n",
       "21    0.656  \n",
       "22    0.701  \n",
       "23    0.758  \n",
       "24    0.725  \n",
       "25    0.827  \n",
       "26    0.756  \n",
       "27    0.751  \n",
       "28    0.647  \n",
       "29    0.775  \n",
       "30    0.710  \n",
       "31    0.807  \n",
       "32    0.742  \n",
       "33    0.779  \n",
       "34    0.825  \n",
       "35    0.769  \n",
       "36    0.639  \n",
       "37    0.827  \n",
       "38    0.836  \n",
       "39    0.848  \n",
       "40    0.831  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_round = round(df, 3)\n",
    "df_round"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_round.to_csv(path, index = False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "TSI",
   "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.9.16"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}