02.5 - Summary results (mean of sessions).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "32db4443",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "from tabulate import tabulate\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "1c4ccbc4",
   "metadata": {},
   "outputs": [],
   "source": [
    "datasets=[['./csvs\\\\A211102.csv',\n",
    "  './csvs\\\\A211105.csv',\n",
    "  './csvs\\\\A211108.csv',\n",
    "  './csvs\\\\A211109.csv',\n",
    "  './csvs\\\\A211110.csv',\n",
    "  './csvs\\\\A211112.csv',\n",
    "  './csvs\\\\A211115.csv',\n",
    "  './csvs\\\\A211116.csv',\n",
    "  './csvs\\\\A211117.csv',\n",
    "  './csvs\\\\A211118.csv',\n",
    "  './csvs\\\\A211122.csv',\n",
    "  './csvs\\\\A211123.csv',\n",
    "  './csvs\\\\A211125.csv',\n",
    "  './csvs\\\\A211206.csv',\n",
    "  './csvs\\\\A211208.csv',\n",
    "  './csvs\\\\A211223.csv',\n",
    "  './csvs\\\\A211225.csv',\n",
    "  './csvs\\\\A211228.csv',\n",
    "  './csvs\\\\I211102.csv',\n",
    "  './csvs\\\\I211103.csv',\n",
    "  './csvs\\\\I211104.csv',\n",
    "  './csvs\\\\I211108.csv',\n",
    "  './csvs\\\\I211110.csv',\n",
    "  './csvs\\\\I211112.csv',\n",
    "  './csvs\\\\I211115.csv',\n",
    "  './csvs\\\\I211118.csv',\n",
    "  './csvs\\\\I211119.csv',\n",
    "  './csvs\\\\I211122.csv'],\n",
    " ['./csvs\\\\A211103.csv', './csvs\\\\A211126.csv', './csvs\\\\A211207.csv'],\n",
    " ['./csvs\\\\A211124.csv',\n",
    "  './csvs\\\\I211124.csv',\n",
    "  './csvs\\\\I211125.csv',\n",
    "  './csvs\\\\I211130.csv',\n",
    "  './csvs\\\\I211201.csv',\n",
    "  './csvs\\\\I211202.csv',\n",
    "  './csvs\\\\I211203.csv',\n",
    "  './csvs\\\\I211207.csv',\n",
    "  './csvs\\\\I211208.csv',\n",
    "  './csvs\\\\I211209.csv',\n",
    "  './csvs\\\\I211210.csv',\n",
    "  './csvs\\\\I211213.csv',\n",
    "  './csvs\\\\I211215.csv',\n",
    "  './csvs\\\\I211216.csv',\n",
    "  './csvs\\\\I211220.csv',\n",
    "  './csvs\\\\I211222.csv',\n",
    "  './csvs\\\\I211223.csv'],\n",
    " ['./csvs\\\\I211116.csv', './csvs\\\\I211117.csv']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "8a555eaf",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 ['./csvs\\\\A211102.csv', './csvs\\\\A211105.csv', './csvs\\\\A211108.csv', './csvs\\\\A211109.csv', './csvs\\\\A211110.csv', './csvs\\\\A211112.csv', './csvs\\\\A211115.csv', './csvs\\\\A211116.csv', './csvs\\\\A211117.csv', './csvs\\\\A211118.csv', './csvs\\\\A211122.csv', './csvs\\\\A211123.csv', './csvs\\\\A211125.csv', './csvs\\\\A211206.csv', './csvs\\\\A211208.csv', './csvs\\\\A211223.csv', './csvs\\\\A211225.csv', './csvs\\\\A211228.csv', './csvs\\\\I211102.csv', './csvs\\\\I211103.csv', './csvs\\\\I211104.csv', './csvs\\\\I211108.csv', './csvs\\\\I211110.csv', './csvs\\\\I211112.csv', './csvs\\\\I211115.csv', './csvs\\\\I211118.csv', './csvs\\\\I211119.csv', './csvs\\\\I211122.csv']\n",
      "1 ['./csvs\\\\A211103.csv', './csvs\\\\A211126.csv', './csvs\\\\A211207.csv']\n",
      "2 ['./csvs\\\\A211124.csv', './csvs\\\\I211124.csv', './csvs\\\\I211125.csv', './csvs\\\\I211130.csv', './csvs\\\\I211201.csv', './csvs\\\\I211202.csv', './csvs\\\\I211203.csv', './csvs\\\\I211207.csv', './csvs\\\\I211208.csv', './csvs\\\\I211209.csv', './csvs\\\\I211210.csv', './csvs\\\\I211213.csv', './csvs\\\\I211215.csv', './csvs\\\\I211216.csv', './csvs\\\\I211220.csv', './csvs\\\\I211222.csv', './csvs\\\\I211223.csv']\n",
      "3 ['./csvs\\\\I211116.csv', './csvs\\\\I211117.csv']\n"
     ]
    }
   ],
   "source": [
    "say=0\n",
    "dataset=\"./results/vs/\"\n",
    "lines=[[\"Type\",\"file\",'T', 'CV', 'Acc', 'b_Acc', 'Prec', 'Rec', 'F1', 'kap', 'ROC', 'tra-T', 'test-T', 'Al-Time']]\n",
    "for no, i in enumerate(datasets):\n",
    "    print(no,i)\n",
    "    for ii in i:\n",
    "        row=[]\n",
    "        for iii in i:\n",
    "            if ii[7:-4]!=iii[7:-4]:\n",
    "                file=f\"{dataset}/@{ii[7:-4]}@{iii[7:-4]}.csv\"\n",
    "                #print(file)\n",
    "            \n",
    "                df=pd.read_csv(file)\n",
    "                a=list(dict(df.mean()).values())\n",
    "                a.insert(0, file[14:-4])\n",
    "                a.insert(0, f\"{ii[7]}-{iii[7]}\")\n",
    "                lines.append(a)\n",
    "            \n",
    "results = pd.DataFrame (lines[1:], columns = lines[0])\n",
    "results.to_csv(\"periodvsperiod.csv\",index=False)\n",
    "\n",
    "#print (tabulate(results, headers=list(results.columns)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "b367337a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A-A\n",
      "A-I\n",
      "I-A\n",
      "I-I\n"
     ]
    }
   ],
   "source": [
    "lines=[[\"Type\",'T', 'CV', 'Acc', 'b_Acc', 'Prec', 'Rec', 'F1', 'kap', 'ROC', 'tra-T', 'test-T', 'Al-Time']]\n",
    "\n",
    "for i in results['Type'].unique():\n",
    "    sub=results[results['Type']==i]\n",
    "    a=list(dict(sub.mean()).values())\n",
    "    a.insert(0, i)\n",
    "    lines.append(a)\n",
    "    print(i)\n",
    "score = pd.DataFrame (lines[1:], columns = lines[0])\n",
    "score.to_csv(\"meantable_scores.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "37d68b3c",
   "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>Type</th>\n",
       "      <th>T</th>\n",
       "      <th>CV</th>\n",
       "      <th>Acc</th>\n",
       "      <th>b_Acc</th>\n",
       "      <th>Prec</th>\n",
       "      <th>Rec</th>\n",
       "      <th>F1</th>\n",
       "      <th>kap</th>\n",
       "      <th>ROC</th>\n",
       "      <th>tra-T</th>\n",
       "      <th>test-T</th>\n",
       "      <th>Al-Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A-A</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.756274</td>\n",
       "      <td>0.737748</td>\n",
       "      <td>0.726432</td>\n",
       "      <td>0.737748</td>\n",
       "      <td>0.702000</td>\n",
       "      <td>0.741305</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.620038</td>\n",
       "      <td>0.184970</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A-I</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.760485</td>\n",
       "      <td>0.740175</td>\n",
       "      <td>0.743269</td>\n",
       "      <td>0.740175</td>\n",
       "      <td>0.714114</td>\n",
       "      <td>0.747170</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.528198</td>\n",
       "      <td>0.190997</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I-A</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.686411</td>\n",
       "      <td>0.725415</td>\n",
       "      <td>0.719754</td>\n",
       "      <td>0.725415</td>\n",
       "      <td>0.679336</td>\n",
       "      <td>0.670883</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.545128</td>\n",
       "      <td>0.170743</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I-I</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.767732</td>\n",
       "      <td>0.741384</td>\n",
       "      <td>0.756386</td>\n",
       "      <td>0.741384</td>\n",
       "      <td>0.719747</td>\n",
       "      <td>0.754727</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.515919</td>\n",
       "      <td>0.193987</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Type    T   CV       Acc     b_Acc      Prec       Rec        F1       kap  \\\n",
       "0  A-A  2.0  3.0  0.756274  0.737748  0.726432  0.737748  0.702000  0.741305   \n",
       "1  A-I  2.0  3.0  0.760485  0.740175  0.743269  0.740175  0.714114  0.747170   \n",
       "2  I-A  2.0  3.0  0.686411  0.725415  0.719754  0.725415  0.679336  0.670883   \n",
       "3  I-I  2.0  3.0  0.767732  0.741384  0.756386  0.741384  0.719747  0.754727   \n",
       "\n",
       "   ROC     tra-T    test-T  Al-Time  \n",
       "0  0.0  1.620038  0.184970      0.0  \n",
       "1  0.0  1.528198  0.190997      0.0  \n",
       "2  0.0  1.545128  0.170743      0.0  \n",
       "3  0.0  1.515919  0.193987      0.0  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c2513807",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "03a9efa0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 ['./csvs\\\\A211102.csv', './csvs\\\\A211105.csv', './csvs\\\\A211108.csv', './csvs\\\\A211109.csv', './csvs\\\\A211110.csv', './csvs\\\\A211112.csv', './csvs\\\\A211115.csv', './csvs\\\\A211116.csv', './csvs\\\\A211117.csv', './csvs\\\\A211118.csv', './csvs\\\\A211122.csv', './csvs\\\\A211123.csv', './csvs\\\\A211125.csv', './csvs\\\\A211206.csv', './csvs\\\\A211208.csv', './csvs\\\\A211223.csv', './csvs\\\\A211225.csv', './csvs\\\\A211228.csv', './csvs\\\\I211102.csv', './csvs\\\\I211103.csv', './csvs\\\\I211104.csv', './csvs\\\\I211108.csv', './csvs\\\\I211110.csv', './csvs\\\\I211112.csv', './csvs\\\\I211115.csv', './csvs\\\\I211118.csv', './csvs\\\\I211119.csv', './csvs\\\\I211122.csv']\n",
      "1 ['./csvs\\\\A211103.csv', './csvs\\\\A211126.csv', './csvs\\\\A211207.csv']\n",
      "2 ['./csvs\\\\A211124.csv', './csvs\\\\I211124.csv', './csvs\\\\I211125.csv', './csvs\\\\I211130.csv', './csvs\\\\I211201.csv', './csvs\\\\I211202.csv', './csvs\\\\I211203.csv', './csvs\\\\I211207.csv', './csvs\\\\I211208.csv', './csvs\\\\I211209.csv', './csvs\\\\I211210.csv', './csvs\\\\I211213.csv', './csvs\\\\I211215.csv', './csvs\\\\I211216.csv', './csvs\\\\I211220.csv', './csvs\\\\I211222.csv', './csvs\\\\I211223.csv']\n",
      "3 ['./csvs\\\\I211116.csv', './csvs\\\\I211117.csv']\n"
     ]
    }
   ],
   "source": [
    "say=0\n",
    "dataset=\"./results/vs/\"\n",
    "lines=[[\"Type\",\"file\",'T', 'CV', 'Acc', 'b_Acc', 'Prec', 'Rec', 'F1', 'kap', 'ROC', 'tra-T', 'test-T', 'Al-Time']]\n",
    "for no, i in enumerate(datasets):\n",
    "    print(no,i)\n",
    "    for ii in i:\n",
    "        row=[]\n",
    "        for iii in i:\n",
    "            if ii[7:-4]!=iii[7:-4]:\n",
    "                file=f\"{dataset}/@{ii[7:-4]}@{iii[7:-4]}.csv\"\n",
    "                #print(file)\n",
    "            \n",
    "                df=pd.read_csv(file)\n",
    "                a=list(dict(df.std()).values())\n",
    "                a.insert(0, file[14:-4])\n",
    "                a.insert(0, f\"{ii[7]}-{iii[7]}\")\n",
    "                lines.append(a)\n",
    "            \n",
    "results = pd.DataFrame (lines[1:], columns = lines[0])\n",
    "results.to_csv(\"periodvsperiod_std.csv\",index=False)\n",
    "\n",
    "#print (tabulate(results, headers=list(results.columns)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "d37ada86",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Type\n",
       "A-A    312\n",
       "A-I    196\n",
       "I-A    196\n",
       "I-I    332\n",
       "dtype: int64"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results.groupby(\"Type\").size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "be96a557",
   "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>Type</th>\n",
       "      <th>file</th>\n",
       "      <th>T</th>\n",
       "      <th>CV</th>\n",
       "      <th>Acc</th>\n",
       "      <th>b_Acc</th>\n",
       "      <th>Prec</th>\n",
       "      <th>Rec</th>\n",
       "      <th>F1</th>\n",
       "      <th>kap</th>\n",
       "      <th>ROC</th>\n",
       "      <th>tra-T</th>\n",
       "      <th>test-T</th>\n",
       "      <th>Al-Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A-A</td>\n",
       "      <td>@A211102@A211105</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000010</td>\n",
       "      <td>0.000066</td>\n",
       "      <td>0.000187</td>\n",
       "      <td>0.000066</td>\n",
       "      <td>0.000136</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.036376</td>\n",
       "      <td>0.014441</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A-A</td>\n",
       "      <td>@A211102@A211108</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000025</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000842</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000428</td>\n",
       "      <td>0.000025</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.072251</td>\n",
       "      <td>0.013024</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A-A</td>\n",
       "      <td>@A211102@A211109</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000121</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>0.000397</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>0.000199</td>\n",
       "      <td>0.000129</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.036765</td>\n",
       "      <td>0.014545</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A-A</td>\n",
       "      <td>@A211102@A211110</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000412</td>\n",
       "      <td>0.000496</td>\n",
       "      <td>0.002909</td>\n",
       "      <td>0.000496</td>\n",
       "      <td>0.000693</td>\n",
       "      <td>0.000469</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.034295</td>\n",
       "      <td>0.015950</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A-A</td>\n",
       "      <td>@A211102@A211112</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000062</td>\n",
       "      <td>0.000049</td>\n",
       "      <td>0.001278</td>\n",
       "      <td>0.000049</td>\n",
       "      <td>0.001024</td>\n",
       "      <td>0.000082</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.048316</td>\n",
       "      <td>0.007760</td>\n",
       "      <td>0.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",
       "      <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>1031</th>\n",
       "      <td>I-I</td>\n",
       "      <td>@I211223@I211216</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000190</td>\n",
       "      <td>0.001085</td>\n",
       "      <td>0.005705</td>\n",
       "      <td>0.001085</td>\n",
       "      <td>0.004010</td>\n",
       "      <td>0.000214</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.047500</td>\n",
       "      <td>0.013474</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1032</th>\n",
       "      <td>I-I</td>\n",
       "      <td>@I211223@I211220</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000026</td>\n",
       "      <td>0.000792</td>\n",
       "      <td>0.000026</td>\n",
       "      <td>0.000397</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.063790</td>\n",
       "      <td>0.025216</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033</th>\n",
       "      <td>I-I</td>\n",
       "      <td>@I211223@I211222</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000010</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.000539</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.000267</td>\n",
       "      <td>0.000011</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.076802</td>\n",
       "      <td>0.008240</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1034</th>\n",
       "      <td>I-I</td>\n",
       "      <td>@I211116@I211117</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000028</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.008898</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.005722</td>\n",
       "      <td>0.000201</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099309</td>\n",
       "      <td>0.011788</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035</th>\n",
       "      <td>I-I</td>\n",
       "      <td>@I211117@I211116</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.001536</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.001432</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.137059</td>\n",
       "      <td>0.018398</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1036 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Type              file         T        CV       Acc     b_Acc      Prec  \\\n",
       "0     A-A  @A211102@A211105  1.581139  1.581139  0.000010  0.000066  0.000187   \n",
       "1     A-A  @A211102@A211108  1.581139  1.581139  0.000025  0.000043  0.000842   \n",
       "2     A-A  @A211102@A211109  1.581139  1.581139  0.000121  0.000110  0.000397   \n",
       "3     A-A  @A211102@A211110  1.581139  1.581139  0.000412  0.000496  0.002909   \n",
       "4     A-A  @A211102@A211112  1.581139  1.581139  0.000062  0.000049  0.001278   \n",
       "...   ...               ...       ...       ...       ...       ...       ...   \n",
       "1031  I-I  @I211223@I211216  1.581139  1.581139  0.000190  0.001085  0.005705   \n",
       "1032  I-I  @I211223@I211220  1.581139  1.581139  0.000030  0.000026  0.000792   \n",
       "1033  I-I  @I211223@I211222  1.581139  1.581139  0.000010  0.000012  0.000539   \n",
       "1034  I-I  @I211116@I211117  1.581139  1.581139  0.000028  0.000031  0.008898   \n",
       "1035  I-I  @I211117@I211116  1.581139  1.581139  0.000033  0.000047  0.001536   \n",
       "\n",
       "           Rec        F1       kap  ROC     tra-T    test-T  Al-Time  \n",
       "0     0.000066  0.000136  0.000012  0.0  0.036376  0.014441      0.0  \n",
       "1     0.000043  0.000428  0.000025  0.0  0.072251  0.013024      0.0  \n",
       "2     0.000110  0.000199  0.000129  0.0  0.036765  0.014545      0.0  \n",
       "3     0.000496  0.000693  0.000469  0.0  0.034295  0.015950      0.0  \n",
       "4     0.000049  0.001024  0.000082  0.0  0.048316  0.007760      0.0  \n",
       "...        ...       ...       ...  ...       ...       ...      ...  \n",
       "1031  0.001085  0.004010  0.000214  0.0  0.047500  0.013474      0.0  \n",
       "1032  0.000026  0.000397  0.000031  0.0  0.063790  0.025216      0.0  \n",
       "1033  0.000012  0.000267  0.000011  0.0  0.076802  0.008240      0.0  \n",
       "1034  0.000031  0.005722  0.000201  0.0  0.099309  0.011788      0.0  \n",
       "1035  0.000047  0.001432  0.000042  0.0  0.137059  0.018398      0.0  \n",
       "\n",
       "[1036 rows x 14 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "cec3d0e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "82880"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1036*80"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "5178fac6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23.022222222222222"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "82880/3600"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "953caaff",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "7566061f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A-A\n",
      "A-I\n",
      "I-A\n",
      "I-I\n"
     ]
    }
   ],
   "source": [
    "lines=[[\"Type\",'T', 'CV', 'Acc', 'b_Acc', 'Prec', 'Rec', 'F1', 'kap', 'ROC', 'tra-T', 'test-T', 'Al-Time']]\n",
    "\n",
    "for i in results['Type'].unique():\n",
    "    sub=results[results['Type']==i]\n",
    "    a=list(dict(sub.mean()).values())\n",
    "    a.insert(0, i)\n",
    "    lines.append(a)\n",
    "    print(i)\n",
    "std = pd.DataFrame (lines[1:], columns = lines[0])\n",
    "std.to_csv(\"meantable_std.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "e799325d",
   "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>Type</th>\n",
       "      <th>T</th>\n",
       "      <th>CV</th>\n",
       "      <th>Acc</th>\n",
       "      <th>b_Acc</th>\n",
       "      <th>Prec</th>\n",
       "      <th>Rec</th>\n",
       "      <th>F1</th>\n",
       "      <th>kap</th>\n",
       "      <th>ROC</th>\n",
       "      <th>tra-T</th>\n",
       "      <th>test-T</th>\n",
       "      <th>Al-Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A-A</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.001465</td>\n",
       "      <td>0.001660</td>\n",
       "      <td>0.004707</td>\n",
       "      <td>0.001660</td>\n",
       "      <td>0.003459</td>\n",
       "      <td>0.001559</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.061823</td>\n",
       "      <td>0.011790</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A-I</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.001854</td>\n",
       "      <td>0.001827</td>\n",
       "      <td>0.004322</td>\n",
       "      <td>0.001827</td>\n",
       "      <td>0.003619</td>\n",
       "      <td>0.001955</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.057142</td>\n",
       "      <td>0.012602</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I-A</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.002139</td>\n",
       "      <td>0.002601</td>\n",
       "      <td>0.004262</td>\n",
       "      <td>0.002601</td>\n",
       "      <td>0.004379</td>\n",
       "      <td>0.002290</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.072132</td>\n",
       "      <td>0.013467</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I-I</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>1.581139</td>\n",
       "      <td>0.002808</td>\n",
       "      <td>0.002685</td>\n",
       "      <td>0.005458</td>\n",
       "      <td>0.002685</td>\n",
       "      <td>0.005079</td>\n",
       "      <td>0.002969</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.068445</td>\n",
       "      <td>0.014539</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Type         T        CV       Acc     b_Acc      Prec       Rec        F1  \\\n",
       "0  A-A  1.581139  1.581139  0.001465  0.001660  0.004707  0.001660  0.003459   \n",
       "1  A-I  1.581139  1.581139  0.001854  0.001827  0.004322  0.001827  0.003619   \n",
       "2  I-A  1.581139  1.581139  0.002139  0.002601  0.004262  0.002601  0.004379   \n",
       "3  I-I  1.581139  1.581139  0.002808  0.002685  0.005458  0.002685  0.005079   \n",
       "\n",
       "        kap  ROC     tra-T    test-T  Al-Time  \n",
       "0  0.001559  0.0  0.061823  0.011790      0.0  \n",
       "1  0.001955  0.0  0.057142  0.012602      0.0  \n",
       "2  0.002290  0.0  0.072132  0.013467      0.0  \n",
       "3  0.002969  0.0  0.068445  0.014539      0.0  "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "std"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "be4f237c",
   "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>Type</th>\n",
       "      <th>T</th>\n",
       "      <th>CV</th>\n",
       "      <th>Acc</th>\n",
       "      <th>b_Acc</th>\n",
       "      <th>Prec</th>\n",
       "      <th>Rec</th>\n",
       "      <th>F1</th>\n",
       "      <th>kap</th>\n",
       "      <th>ROC</th>\n",
       "      <th>tra-T</th>\n",
       "      <th>test-T</th>\n",
       "      <th>Al-Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A-A±A-A</td>\n",
       "      <td>2.0±1.581</td>\n",
       "      <td>3.0±1.581</td>\n",
       "      <td>0.756±0.001</td>\n",
       "      <td>0.738±0.002</td>\n",
       "      <td>0.726±0.005</td>\n",
       "      <td>0.738±0.002</td>\n",
       "      <td>0.702±0.003</td>\n",
       "      <td>0.741±0.002</td>\n",
       "      <td>0.0±0.0</td>\n",
       "      <td>1.62±0.062</td>\n",
       "      <td>0.185±0.012</td>\n",
       "      <td>0.0±0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A-I±A-I</td>\n",
       "      <td>2.0±1.581</td>\n",
       "      <td>3.0±1.581</td>\n",
       "      <td>0.76±0.002</td>\n",
       "      <td>0.74±0.002</td>\n",
       "      <td>0.743±0.004</td>\n",
       "      <td>0.74±0.002</td>\n",
       "      <td>0.714±0.004</td>\n",
       "      <td>0.747±0.002</td>\n",
       "      <td>0.0±0.0</td>\n",
       "      <td>1.528±0.057</td>\n",
       "      <td>0.191±0.013</td>\n",
       "      <td>0.0±0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I-A±I-A</td>\n",
       "      <td>2.0±1.581</td>\n",
       "      <td>3.0±1.581</td>\n",
       "      <td>0.686±0.002</td>\n",
       "      <td>0.725±0.003</td>\n",
       "      <td>0.72±0.004</td>\n",
       "      <td>0.725±0.003</td>\n",
       "      <td>0.679±0.004</td>\n",
       "      <td>0.671±0.002</td>\n",
       "      <td>0.0±0.0</td>\n",
       "      <td>1.545±0.072</td>\n",
       "      <td>0.171±0.013</td>\n",
       "      <td>0.0±0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I-I±I-I</td>\n",
       "      <td>2.0±1.581</td>\n",
       "      <td>3.0±1.581</td>\n",
       "      <td>0.768±0.003</td>\n",
       "      <td>0.741±0.003</td>\n",
       "      <td>0.756±0.005</td>\n",
       "      <td>0.741±0.003</td>\n",
       "      <td>0.72±0.005</td>\n",
       "      <td>0.755±0.003</td>\n",
       "      <td>0.0±0.0</td>\n",
       "      <td>1.516±0.068</td>\n",
       "      <td>0.194±0.015</td>\n",
       "      <td>0.0±0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Type          T         CV          Acc        b_Acc         Prec  \\\n",
       "0  A-A±A-A  2.0±1.581  3.0±1.581  0.756±0.001  0.738±0.002  0.726±0.005   \n",
       "1  A-I±A-I  2.0±1.581  3.0±1.581   0.76±0.002   0.74±0.002  0.743±0.004   \n",
       "2  I-A±I-A  2.0±1.581  3.0±1.581  0.686±0.002  0.725±0.003   0.72±0.004   \n",
       "3  I-I±I-I  2.0±1.581  3.0±1.581  0.768±0.003  0.741±0.003  0.756±0.005   \n",
       "\n",
       "           Rec           F1          kap      ROC        tra-T       test-T  \\\n",
       "0  0.738±0.002  0.702±0.003  0.741±0.002  0.0±0.0   1.62±0.062  0.185±0.012   \n",
       "1   0.74±0.002  0.714±0.004  0.747±0.002  0.0±0.0  1.528±0.057  0.191±0.013   \n",
       "2  0.725±0.003  0.679±0.004  0.671±0.002  0.0±0.0  1.545±0.072  0.171±0.013   \n",
       "3  0.741±0.003   0.72±0.005  0.755±0.003  0.0±0.0  1.516±0.068  0.194±0.015   \n",
       "\n",
       "   Al-Time  \n",
       "0  0.0±0.0  \n",
       "1  0.0±0.0  \n",
       "2  0.0±0.0  \n",
       "3  0.0±0.0  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score=score.round(3)\n",
    "std=std.round(3)\n",
    "merged=pd.DataFrame()\n",
    "for i in mean.columns:\n",
    "    merged[i]=score[i].astype(str)+\"±\"+std[i].astype(str)\n",
    "\n",
    "\n",
    "merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "25b8fe4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "merged.to_csv(\"merged.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8c41c761",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}