data_preparation_for_stat.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "4253dac9-d107-4825-9c4d-42d2101aabaa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Users/tarapongsrisongkram/OneDrive - Khon Kaen University (1)/Amylase inhibitor/Python'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pwd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "102ebd54-20c5-473a-a350-d56f99508301",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import scipy.stats\n",
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import networkx as nx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2cee8fd2-e31c-409e-aa43-fadfd2e5e54e",
   "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>Emax_amylase_1</th>\n",
       "      <th>Emax_amylase_2</th>\n",
       "      <th>Emax_amylase_3</th>\n",
       "      <th>IC50_amylase_1</th>\n",
       "      <th>IC50_amylase_2</th>\n",
       "      <th>IC50_amylase_3</th>\n",
       "      <th>Emax_glucosidase_1</th>\n",
       "      <th>Emax_glucosidase_2</th>\n",
       "      <th>Emax_glucosidase_3</th>\n",
       "      <th>IC50_glucosidase_1</th>\n",
       "      <th>IC50_glucosidase_2</th>\n",
       "      <th>IC50_glucosidase_3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.759423</td>\n",
       "      <td>99.438653</td>\n",
       "      <td>99.518845</td>\n",
       "      <td>0.133532</td>\n",
       "      <td>0.133488</td>\n",
       "      <td>0.132589</td>\n",
       "      <td>51.121951</td>\n",
       "      <td>51.560976</td>\n",
       "      <td>50.682927</td>\n",
       "      <td>0.630757</td>\n",
       "      <td>0.608844</td>\n",
       "      <td>0.644284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>99.358460</td>\n",
       "      <td>99.679230</td>\n",
       "      <td>99.438653</td>\n",
       "      <td>0.136870</td>\n",
       "      <td>0.137005</td>\n",
       "      <td>0.136889</td>\n",
       "      <td>50.024390</td>\n",
       "      <td>50.097561</td>\n",
       "      <td>49.878049</td>\n",
       "      <td>0.697793</td>\n",
       "      <td>0.727287</td>\n",
       "      <td>0.731095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>93.825180</td>\n",
       "      <td>93.905373</td>\n",
       "      <td>93.825180</td>\n",
       "      <td>0.136675</td>\n",
       "      <td>0.134144</td>\n",
       "      <td>0.134566</td>\n",
       "      <td>51.780488</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>52.073171</td>\n",
       "      <td>0.575490</td>\n",
       "      <td>0.572706</td>\n",
       "      <td>0.566192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_Rhizome</th>\n",
       "      <td>36.086608</td>\n",
       "      <td>35.124298</td>\n",
       "      <td>36.086608</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.317073</td>\n",
       "      <td>50.902439</td>\n",
       "      <td>50.463415</td>\n",
       "      <td>0.641052</td>\n",
       "      <td>0.591333</td>\n",
       "      <td>0.652540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cuneatum</th>\n",
       "      <td>86.447474</td>\n",
       "      <td>86.447474</td>\n",
       "      <td>86.607859</td>\n",
       "      <td>0.171532</td>\n",
       "      <td>0.164251</td>\n",
       "      <td>0.186663</td>\n",
       "      <td>39.487805</td>\n",
       "      <td>39.560976</td>\n",
       "      <td>39.707317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_anamense</th>\n",
       "      <td>35.364876</td>\n",
       "      <td>35.124298</td>\n",
       "      <td>34.803528</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.268293</td>\n",
       "      <td>54.195122</td>\n",
       "      <td>55.073171</td>\n",
       "      <td>0.531791</td>\n",
       "      <td>0.523259</td>\n",
       "      <td>0.511069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A_marginata</th>\n",
       "      <td>15.958300</td>\n",
       "      <td>16.038492</td>\n",
       "      <td>16.118685</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.512195</td>\n",
       "      <td>37.731707</td>\n",
       "      <td>37.439024</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cherrevensis</th>\n",
       "      <td>77.786688</td>\n",
       "      <td>77.947073</td>\n",
       "      <td>77.546111</td>\n",
       "      <td>0.176733</td>\n",
       "      <td>0.182894</td>\n",
       "      <td>0.173494</td>\n",
       "      <td>39.634146</td>\n",
       "      <td>39.707317</td>\n",
       "      <td>40.146341</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F_indica</th>\n",
       "      <td>84.522855</td>\n",
       "      <td>84.362470</td>\n",
       "      <td>84.442662</td>\n",
       "      <td>0.158998</td>\n",
       "      <td>0.163765</td>\n",
       "      <td>0.154956</td>\n",
       "      <td>38.902439</td>\n",
       "      <td>39.121951</td>\n",
       "      <td>39.268293</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>H_perforata</th>\n",
       "      <td>34.803528</td>\n",
       "      <td>35.364876</td>\n",
       "      <td>35.284683</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.512195</td>\n",
       "      <td>39.926829</td>\n",
       "      <td>39.195122</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_dumetorum</th>\n",
       "      <td>30.312751</td>\n",
       "      <td>30.152366</td>\n",
       "      <td>30.553328</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.634146</td>\n",
       "      <td>10.585366</td>\n",
       "      <td>11.243902</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_filiformis</th>\n",
       "      <td>35.284683</td>\n",
       "      <td>35.685646</td>\n",
       "      <td>35.846030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.853659</td>\n",
       "      <td>36.195122</td>\n",
       "      <td>37.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>94.947875</td>\n",
       "      <td>95.028067</td>\n",
       "      <td>94.867682</td>\n",
       "      <td>0.110735</td>\n",
       "      <td>0.110631</td>\n",
       "      <td>0.112672</td>\n",
       "      <td>52.365854</td>\n",
       "      <td>52.292683</td>\n",
       "      <td>52.292683</td>\n",
       "      <td>0.596355</td>\n",
       "      <td>0.586174</td>\n",
       "      <td>0.613579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A_pulchellus</th>\n",
       "      <td>24.859663</td>\n",
       "      <td>24.298316</td>\n",
       "      <td>24.859663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.926829</td>\n",
       "      <td>15.707317</td>\n",
       "      <td>15.926829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_loureiri</th>\n",
       "      <td>47.313553</td>\n",
       "      <td>47.473937</td>\n",
       "      <td>47.233360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.682927</td>\n",
       "      <td>20.463415</td>\n",
       "      <td>20.390244</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_succedanea</th>\n",
       "      <td>29.831596</td>\n",
       "      <td>29.911788</td>\n",
       "      <td>29.991981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.439024</td>\n",
       "      <td>31.658537</td>\n",
       "      <td>31.731707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_javanica</th>\n",
       "      <td>82.036889</td>\n",
       "      <td>82.117081</td>\n",
       "      <td>82.117081</td>\n",
       "      <td>0.135099</td>\n",
       "      <td>0.136926</td>\n",
       "      <td>0.135988</td>\n",
       "      <td>38.829268</td>\n",
       "      <td>38.756098</td>\n",
       "      <td>38.975610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>87.249399</td>\n",
       "      <td>86.848436</td>\n",
       "      <td>87.008821</td>\n",
       "      <td>0.165075</td>\n",
       "      <td>0.161986</td>\n",
       "      <td>0.172439</td>\n",
       "      <td>49.878049</td>\n",
       "      <td>50.756098</td>\n",
       "      <td>50.170732</td>\n",
       "      <td>0.627348</td>\n",
       "      <td>0.634788</td>\n",
       "      <td>0.685348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_daltonii</th>\n",
       "      <td>27.425822</td>\n",
       "      <td>25.180433</td>\n",
       "      <td>29.430634</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.804878</td>\n",
       "      <td>37.658537</td>\n",
       "      <td>37.365854</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B_anceps</th>\n",
       "      <td>13.151564</td>\n",
       "      <td>13.071371</td>\n",
       "      <td>13.472334</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.780488</td>\n",
       "      <td>38.756098</td>\n",
       "      <td>38.902439</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_tomentosa</th>\n",
       "      <td>21.331195</td>\n",
       "      <td>23.496391</td>\n",
       "      <td>19.085806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.926829</td>\n",
       "      <td>33.414634</td>\n",
       "      <td>34.219512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_castanea_twig</th>\n",
       "      <td>42.341620</td>\n",
       "      <td>41.619888</td>\n",
       "      <td>42.261427</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.609756</td>\n",
       "      <td>29.536585</td>\n",
       "      <td>29.902439</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_castanea_leaf</th>\n",
       "      <td>84.202085</td>\n",
       "      <td>84.282277</td>\n",
       "      <td>83.961508</td>\n",
       "      <td>0.161299</td>\n",
       "      <td>0.161509</td>\n",
       "      <td>0.160221</td>\n",
       "      <td>20.682927</td>\n",
       "      <td>20.902439</td>\n",
       "      <td>20.975610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L_coromandelica</th>\n",
       "      <td>29.991981</td>\n",
       "      <td>29.671211</td>\n",
       "      <td>29.911788</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.292683</td>\n",
       "      <td>31.585366</td>\n",
       "      <td>31.292683</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_succirubrum</th>\n",
       "      <td>35.525261</td>\n",
       "      <td>35.204491</td>\n",
       "      <td>35.364876</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.682927</td>\n",
       "      <td>32.609756</td>\n",
       "      <td>32.243902</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_mucronata</th>\n",
       "      <td>95.829992</td>\n",
       "      <td>95.669607</td>\n",
       "      <td>95.589415</td>\n",
       "      <td>0.156587</td>\n",
       "      <td>0.154551</td>\n",
       "      <td>0.156910</td>\n",
       "      <td>9.268293</td>\n",
       "      <td>9.487805</td>\n",
       "      <td>10.219512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_winitii</th>\n",
       "      <td>93.424218</td>\n",
       "      <td>93.183641</td>\n",
       "      <td>93.183641</td>\n",
       "      <td>0.118879</td>\n",
       "      <td>0.119152</td>\n",
       "      <td>0.118391</td>\n",
       "      <td>39.487805</td>\n",
       "      <td>39.780488</td>\n",
       "      <td>39.853659</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B_insulana</th>\n",
       "      <td>92.060946</td>\n",
       "      <td>91.980754</td>\n",
       "      <td>92.782678</td>\n",
       "      <td>0.158688</td>\n",
       "      <td>0.157088</td>\n",
       "      <td>0.163883</td>\n",
       "      <td>34.146341</td>\n",
       "      <td>32.536585</td>\n",
       "      <td>31.439024</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A_vanprukii</th>\n",
       "      <td>27.105052</td>\n",
       "      <td>27.185245</td>\n",
       "      <td>27.425822</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.560976</td>\n",
       "      <td>30.926829</td>\n",
       "      <td>30.780488</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>33.360064</td>\n",
       "      <td>33.440257</td>\n",
       "      <td>33.520449</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.756098</td>\n",
       "      <td>32.536585</td>\n",
       "      <td>32.463415</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.269447</td>\n",
       "      <td>12.510024</td>\n",
       "      <td>12.991179</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.097561</td>\n",
       "      <td>52.219512</td>\n",
       "      <td>53.682927</td>\n",
       "      <td>0.498516</td>\n",
       "      <td>0.530108</td>\n",
       "      <td>0.439253</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Emax_amylase_1  Emax_amylase_2  Emax_amylase_3  \\\n",
       "Names                                                              \n",
       "G_cowa                 99.759423       99.438653       99.518845   \n",
       "P_debilis              99.358460       99.679230       99.438653   \n",
       "P_evecta_leaf          93.825180       93.905373       93.825180   \n",
       "P_evecta_Rhizome       36.086608       35.124298       36.086608   \n",
       "E_cuneatum             86.447474       86.447474       86.607859   \n",
       "P_anamense             35.364876       35.124298       34.803528   \n",
       "A_marginata            15.958300       16.038492       16.118685   \n",
       "E_cherrevensis         77.786688       77.947073       77.546111   \n",
       "F_indica               84.522855       84.362470       84.442662   \n",
       "H_perforata            34.803528       35.364876       35.284683   \n",
       "R_dumetorum            30.312751       30.152366       30.553328   \n",
       "C_filiformis           35.284683       35.685646       35.846030   \n",
       "P_Kesiya               94.947875       95.028067       94.867682   \n",
       "A_pulchellus           24.859663       24.298316       24.859663   \n",
       "T_loureiri             47.313553       47.473937       47.233360   \n",
       "R_succedanea           29.831596       29.911788       29.991981   \n",
       "R_javanica             82.036889       82.117081       82.117081   \n",
       "C_formosum             87.249399       86.848436       87.008821   \n",
       "G_daltonii             27.425822       25.180433       29.430634   \n",
       "B_anceps               13.151564       13.071371       13.472334   \n",
       "C_tomentosa            21.331195       23.496391       19.085806   \n",
       "D_castanea_twig        42.341620       41.619888       42.261427   \n",
       "D_castanea_leaf        84.202085       84.282277       83.961508   \n",
       "L_coromandelica        29.991981       29.671211       29.911788   \n",
       "E_succirubrum          35.525261       35.204491       35.364876   \n",
       "T_mucronata            95.829992       95.669607       95.589415   \n",
       "D_winitii              93.424218       93.183641       93.183641   \n",
       "B_insulana             92.060946       91.980754       92.782678   \n",
       "A_vanprukii            27.105052       27.185245       27.425822   \n",
       "T_triptera             33.360064       33.440257       33.520449   \n",
       "C_oblongifolius        12.269447       12.510024       12.991179   \n",
       "\n",
       "                  IC50_amylase_1  IC50_amylase_2  IC50_amylase_3  \\\n",
       "Names                                                              \n",
       "G_cowa                  0.133532        0.133488        0.132589   \n",
       "P_debilis               0.136870        0.137005        0.136889   \n",
       "P_evecta_leaf           0.136675        0.134144        0.134566   \n",
       "P_evecta_Rhizome             NaN             NaN             NaN   \n",
       "E_cuneatum              0.171532        0.164251        0.186663   \n",
       "P_anamense                   NaN             NaN             NaN   \n",
       "A_marginata                  NaN             NaN             NaN   \n",
       "E_cherrevensis          0.176733        0.182894        0.173494   \n",
       "F_indica                0.158998        0.163765        0.154956   \n",
       "H_perforata                  NaN             NaN             NaN   \n",
       "R_dumetorum                  NaN             NaN             NaN   \n",
       "C_filiformis                 NaN             NaN             NaN   \n",
       "P_Kesiya                0.110735        0.110631        0.112672   \n",
       "A_pulchellus                 NaN             NaN             NaN   \n",
       "T_loureiri                   NaN             NaN             NaN   \n",
       "R_succedanea                 NaN             NaN             NaN   \n",
       "R_javanica              0.135099        0.136926        0.135988   \n",
       "C_formosum              0.165075        0.161986        0.172439   \n",
       "G_daltonii                   NaN             NaN             NaN   \n",
       "B_anceps                     NaN             NaN             NaN   \n",
       "C_tomentosa                  NaN             NaN             NaN   \n",
       "D_castanea_twig              NaN             NaN             NaN   \n",
       "D_castanea_leaf         0.161299        0.161509        0.160221   \n",
       "L_coromandelica              NaN             NaN             NaN   \n",
       "E_succirubrum                NaN             NaN             NaN   \n",
       "T_mucronata             0.156587        0.154551        0.156910   \n",
       "D_winitii               0.118879        0.119152        0.118391   \n",
       "B_insulana              0.158688        0.157088        0.163883   \n",
       "A_vanprukii                  NaN             NaN             NaN   \n",
       "T_triptera                   NaN             NaN             NaN   \n",
       "C_oblongifolius              NaN             NaN             NaN   \n",
       "\n",
       "                  Emax_glucosidase_1  Emax_glucosidase_2  Emax_glucosidase_3  \\\n",
       "Names                                                                          \n",
       "G_cowa                     51.121951           51.560976           50.682927   \n",
       "P_debilis                  50.024390           50.097561           49.878049   \n",
       "P_evecta_leaf              51.780488           52.000000           52.073171   \n",
       "P_evecta_Rhizome           50.317073           50.902439           50.463415   \n",
       "E_cuneatum                 39.487805           39.560976           39.707317   \n",
       "P_anamense                 54.268293           54.195122           55.073171   \n",
       "A_marginata                37.512195           37.731707           37.439024   \n",
       "E_cherrevensis             39.634146           39.707317           40.146341   \n",
       "F_indica                   38.902439           39.121951           39.268293   \n",
       "H_perforata                40.512195           39.926829           39.195122   \n",
       "R_dumetorum                 9.634146           10.585366           11.243902   \n",
       "C_filiformis               36.853659           36.195122           37.000000   \n",
       "P_Kesiya                   52.365854           52.292683           52.292683   \n",
       "A_pulchellus               15.926829           15.707317           15.926829   \n",
       "T_loureiri                 20.682927           20.463415           20.390244   \n",
       "R_succedanea               31.439024           31.658537           31.731707   \n",
       "R_javanica                 38.829268           38.756098           38.975610   \n",
       "C_formosum                 49.878049           50.756098           50.170732   \n",
       "G_daltonii                 37.804878           37.658537           37.365854   \n",
       "B_anceps                   39.780488           38.756098           38.902439   \n",
       "C_tomentosa                33.926829           33.414634           34.219512   \n",
       "D_castanea_twig            29.609756           29.536585           29.902439   \n",
       "D_castanea_leaf            20.682927           20.902439           20.975610   \n",
       "L_coromandelica            31.292683           31.585366           31.292683   \n",
       "E_succirubrum              32.682927           32.609756           32.243902   \n",
       "T_mucronata                 9.268293            9.487805           10.219512   \n",
       "D_winitii                  39.487805           39.780488           39.853659   \n",
       "B_insulana                 34.146341           32.536585           31.439024   \n",
       "A_vanprukii                30.560976           30.926829           30.780488   \n",
       "T_triptera                 32.756098           32.536585           32.463415   \n",
       "C_oblongifolius            53.097561           52.219512           53.682927   \n",
       "\n",
       "                  IC50_glucosidase_1  IC50_glucosidase_2  IC50_glucosidase_3  \n",
       "Names                                                                         \n",
       "G_cowa                      0.630757            0.608844            0.644284  \n",
       "P_debilis                   0.697793            0.727287            0.731095  \n",
       "P_evecta_leaf               0.575490            0.572706            0.566192  \n",
       "P_evecta_Rhizome            0.641052            0.591333            0.652540  \n",
       "E_cuneatum                       NaN                 NaN                 NaN  \n",
       "P_anamense                  0.531791            0.523259            0.511069  \n",
       "A_marginata                      NaN                 NaN                 NaN  \n",
       "E_cherrevensis                   NaN                 NaN                 NaN  \n",
       "F_indica                         NaN                 NaN                 NaN  \n",
       "H_perforata                      NaN                 NaN                 NaN  \n",
       "R_dumetorum                      NaN                 NaN                 NaN  \n",
       "C_filiformis                     NaN                 NaN                 NaN  \n",
       "P_Kesiya                    0.596355            0.586174            0.613579  \n",
       "A_pulchellus                     NaN                 NaN                 NaN  \n",
       "T_loureiri                       NaN                 NaN                 NaN  \n",
       "R_succedanea                     NaN                 NaN                 NaN  \n",
       "R_javanica                       NaN                 NaN                 NaN  \n",
       "C_formosum                  0.627348            0.634788            0.685348  \n",
       "G_daltonii                       NaN                 NaN                 NaN  \n",
       "B_anceps                         NaN                 NaN                 NaN  \n",
       "C_tomentosa                      NaN                 NaN                 NaN  \n",
       "D_castanea_twig                  NaN                 NaN                 NaN  \n",
       "D_castanea_leaf                  NaN                 NaN                 NaN  \n",
       "L_coromandelica                  NaN                 NaN                 NaN  \n",
       "E_succirubrum                    NaN                 NaN                 NaN  \n",
       "T_mucronata                      NaN                 NaN                 NaN  \n",
       "D_winitii                        NaN                 NaN                 NaN  \n",
       "B_insulana                       NaN                 NaN                 NaN  \n",
       "A_vanprukii                      NaN                 NaN                 NaN  \n",
       "T_triptera                       NaN                 NaN                 NaN  \n",
       "C_oblongifolius             0.498516            0.530108            0.439253  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df= pd.read_csv('df_bioactivities.csv', index_col='Names')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d607a45c-44ab-4963-9dcc-2f18ca565f91",
   "metadata": {},
   "outputs": [],
   "source": [
    "indices = df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "7316023f-1049-4f9d-9f19-a8857e063df9",
   "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>Emax_amylase</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.759423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.438653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.518845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>99.358460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>99.679230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>33.440257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>33.520449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.269447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.510024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.991179</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>93 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Emax_amylase\n",
       "Names                        \n",
       "G_cowa              99.759423\n",
       "G_cowa              99.438653\n",
       "G_cowa              99.518845\n",
       "P_debilis           99.358460\n",
       "P_debilis           99.679230\n",
       "...                       ...\n",
       "T_triptera          33.440257\n",
       "T_triptera          33.520449\n",
       "C_oblongifolius     12.269447\n",
       "C_oblongifolius     12.510024\n",
       "C_oblongifolius     12.991179\n",
       "\n",
       "[93 rows x 1 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Emax_amylase = ['Emax_amylase_1', 'Emax_amylase_2','Emax_amylase_3']\n",
    "df_Emax_amylase = pd.DataFrame(df[Emax_amylase], index=indices)\n",
    "#convert matrix to list of edges and rename the columns\n",
    "dft_Emax_amylase = df_Emax_amylase.stack().reset_index()\n",
    "dft_Emax_amylase.columns = ['Names','Bioactivities','Emax_amylase']\n",
    "df_Emax_amylase_for_stat = dft_Emax_amylase.drop('Bioactivities', axis=1)\n",
    "df_Emax_amylase_for_stat = df_Emax_amylase_for_stat.set_index('Names')\n",
    "df_Emax_amylase_for_stat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "77acd964-f6ea-4bbd-a9fa-66d426707732",
   "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>Emax_glucosidase</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>51.121951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>51.560976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>50.682927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>50.024390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>50.097561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>32.536585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>32.463415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>53.097561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>52.219512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>53.682927</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>93 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Emax_glucosidase\n",
       "Names                            \n",
       "G_cowa                  51.121951\n",
       "G_cowa                  51.560976\n",
       "G_cowa                  50.682927\n",
       "P_debilis               50.024390\n",
       "P_debilis               50.097561\n",
       "...                           ...\n",
       "T_triptera              32.536585\n",
       "T_triptera              32.463415\n",
       "C_oblongifolius         53.097561\n",
       "C_oblongifolius         52.219512\n",
       "C_oblongifolius         53.682927\n",
       "\n",
       "[93 rows x 1 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Emax_glucosidase = ['Emax_glucosidase_1', 'Emax_glucosidase_2','Emax_glucosidase_3']\n",
    "df_Emax_glucosidase = pd.DataFrame(df[Emax_glucosidase], index=indices)\n",
    "dft = df_Emax_glucosidase.stack().reset_index()\n",
    "dft.columns = ['Names','Bioactivities','Emax_glucosidase']\n",
    "df_Emax_glucosidase_for_stat = dft.drop('Bioactivities', axis=1)\n",
    "df_Emax_glucosidase_for_stat = df_Emax_glucosidase_for_stat.set_index('Names')\n",
    "df_Emax_glucosidase_for_stat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "d3bb7623-35be-49cd-9c9b-6e34e5f5e160",
   "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>IC50_amylase</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.133532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.133488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.132589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.136870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.137005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.136889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.136675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.134144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.134566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cuneatum</th>\n",
       "      <td>0.171532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cuneatum</th>\n",
       "      <td>0.164251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cuneatum</th>\n",
       "      <td>0.186663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cherrevensis</th>\n",
       "      <td>0.176733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cherrevensis</th>\n",
       "      <td>0.182894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E_cherrevensis</th>\n",
       "      <td>0.173494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F_indica</th>\n",
       "      <td>0.158998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F_indica</th>\n",
       "      <td>0.163765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F_indica</th>\n",
       "      <td>0.154956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.110735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.110631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.112672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_javanica</th>\n",
       "      <td>0.135099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_javanica</th>\n",
       "      <td>0.136926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R_javanica</th>\n",
       "      <td>0.135988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.165075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.161986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.172439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_castanea_leaf</th>\n",
       "      <td>0.161299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_castanea_leaf</th>\n",
       "      <td>0.161509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_castanea_leaf</th>\n",
       "      <td>0.160221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_mucronata</th>\n",
       "      <td>0.156587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_mucronata</th>\n",
       "      <td>0.154551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_mucronata</th>\n",
       "      <td>0.156910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_winitii</th>\n",
       "      <td>0.118879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_winitii</th>\n",
       "      <td>0.119152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D_winitii</th>\n",
       "      <td>0.118391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B_insulana</th>\n",
       "      <td>0.158688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B_insulana</th>\n",
       "      <td>0.157088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B_insulana</th>\n",
       "      <td>0.163883</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 IC50_amylase\n",
       "Names                        \n",
       "G_cowa               0.133532\n",
       "G_cowa               0.133488\n",
       "G_cowa               0.132589\n",
       "P_debilis            0.136870\n",
       "P_debilis            0.137005\n",
       "P_debilis            0.136889\n",
       "P_evecta_leaf        0.136675\n",
       "P_evecta_leaf        0.134144\n",
       "P_evecta_leaf        0.134566\n",
       "E_cuneatum           0.171532\n",
       "E_cuneatum           0.164251\n",
       "E_cuneatum           0.186663\n",
       "E_cherrevensis       0.176733\n",
       "E_cherrevensis       0.182894\n",
       "E_cherrevensis       0.173494\n",
       "F_indica             0.158998\n",
       "F_indica             0.163765\n",
       "F_indica             0.154956\n",
       "P_Kesiya             0.110735\n",
       "P_Kesiya             0.110631\n",
       "P_Kesiya             0.112672\n",
       "R_javanica           0.135099\n",
       "R_javanica           0.136926\n",
       "R_javanica           0.135988\n",
       "C_formosum           0.165075\n",
       "C_formosum           0.161986\n",
       "C_formosum           0.172439\n",
       "D_castanea_leaf      0.161299\n",
       "D_castanea_leaf      0.161509\n",
       "D_castanea_leaf      0.160221\n",
       "T_mucronata          0.156587\n",
       "T_mucronata          0.154551\n",
       "T_mucronata          0.156910\n",
       "D_winitii            0.118879\n",
       "D_winitii            0.119152\n",
       "D_winitii            0.118391\n",
       "B_insulana           0.158688\n",
       "B_insulana           0.157088\n",
       "B_insulana           0.163883"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IC50_amylase = ['IC50_amylase_1', 'IC50_amylase_2','IC50_amylase_3']\n",
    "df_IC50_amylase = pd.DataFrame(df[IC50_amylase], index=indices)\n",
    "#convert matrix to list of edges and rename the columns\n",
    "dft_IC50_amylase = df_IC50_amylase.stack().reset_index()\n",
    "dft_IC50_amylase.columns = ['Names','Bioactivities','IC50_amylase']\n",
    "df_IC50_amylase_for_stat = dft_IC50_amylase.drop('Bioactivities', axis=1)\n",
    "df_IC50_amylase_for_stat = df_IC50_amylase_for_stat.set_index('Names')\n",
    "df_IC50_amylase_for_stat.to_csv('IC50_amylase.csv')\n",
    "df_IC50_amylase_for_stat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "f2762c0b-1261-4e5e-bced-088c2a51974a",
   "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>IC50_glucosidase</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.630757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.608844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>0.644284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.697793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.727287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>0.731095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.575490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.572706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_leaf</th>\n",
       "      <td>0.566192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_Rhizome</th>\n",
       "      <td>0.641052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_Rhizome</th>\n",
       "      <td>0.591333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_evecta_Rhizome</th>\n",
       "      <td>0.652540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_anamense</th>\n",
       "      <td>0.531791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_anamense</th>\n",
       "      <td>0.523259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_anamense</th>\n",
       "      <td>0.511069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.596355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.586174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_Kesiya</th>\n",
       "      <td>0.613579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.627348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.634788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_formosum</th>\n",
       "      <td>0.685348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>0.498516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>0.530108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>0.439253</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  IC50_glucosidase\n",
       "Names                             \n",
       "G_cowa                    0.630757\n",
       "G_cowa                    0.608844\n",
       "G_cowa                    0.644284\n",
       "P_debilis                 0.697793\n",
       "P_debilis                 0.727287\n",
       "P_debilis                 0.731095\n",
       "P_evecta_leaf             0.575490\n",
       "P_evecta_leaf             0.572706\n",
       "P_evecta_leaf             0.566192\n",
       "P_evecta_Rhizome          0.641052\n",
       "P_evecta_Rhizome          0.591333\n",
       "P_evecta_Rhizome          0.652540\n",
       "P_anamense                0.531791\n",
       "P_anamense                0.523259\n",
       "P_anamense                0.511069\n",
       "P_Kesiya                  0.596355\n",
       "P_Kesiya                  0.586174\n",
       "P_Kesiya                  0.613579\n",
       "C_formosum                0.627348\n",
       "C_formosum                0.634788\n",
       "C_formosum                0.685348\n",
       "C_oblongifolius           0.498516\n",
       "C_oblongifolius           0.530108\n",
       "C_oblongifolius           0.439253"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IC50_glucosidase = ['IC50_glucosidase_1', 'IC50_glucosidase_2','IC50_glucosidase_3']\n",
    "df_IC50_glucosidase = pd.DataFrame(df[IC50_glucosidase], index=indices)\n",
    "#convert matrix to list of edges and rename the columns\n",
    "dft_IC50_glucosidase = df_IC50_glucosidase.stack().reset_index()\n",
    "dft_IC50_glucosidase.columns = ['Names','Bioactivities','IC50_glucosidase']\n",
    "df_IC50_glucosidase_for_stat = dft_IC50_glucosidase.drop('Bioactivities', axis=1)\n",
    "df_IC50_glucosidase_for_stat = df_IC50_glucosidase_for_stat.set_index('Names')\n",
    "df_IC50_glucosidase_for_stat.to_csv('IC50_glucosidase.csv')\n",
    "df_IC50_glucosidase_for_stat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "974bae3d-296f-4a83-9bde-37701598ffc1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Emax = pd.concat([df_Emax_amylase_for_stat, df_Emax_glucosidase_for_stat], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "38f16814-82fc-4d1b-a0d9-3d54e695edea",
   "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>Emax_amylase</th>\n",
       "      <th>Emax_glucosidase</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Names</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.759423</td>\n",
       "      <td>51.121951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.438653</td>\n",
       "      <td>51.560976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G_cowa</th>\n",
       "      <td>99.518845</td>\n",
       "      <td>50.682927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>99.358460</td>\n",
       "      <td>50.024390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P_debilis</th>\n",
       "      <td>99.679230</td>\n",
       "      <td>50.097561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>33.440257</td>\n",
       "      <td>32.536585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T_triptera</th>\n",
       "      <td>33.520449</td>\n",
       "      <td>32.463415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.269447</td>\n",
       "      <td>53.097561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.510024</td>\n",
       "      <td>52.219512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C_oblongifolius</th>\n",
       "      <td>12.991179</td>\n",
       "      <td>53.682927</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>93 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Emax_amylase  Emax_glucosidase\n",
       "Names                                          \n",
       "G_cowa              99.759423         51.121951\n",
       "G_cowa              99.438653         51.560976\n",
       "G_cowa              99.518845         50.682927\n",
       "P_debilis           99.358460         50.024390\n",
       "P_debilis           99.679230         50.097561\n",
       "...                       ...               ...\n",
       "T_triptera          33.440257         32.536585\n",
       "T_triptera          33.520449         32.463415\n",
       "C_oblongifolius     12.269447         53.097561\n",
       "C_oblongifolius     12.510024         52.219512\n",
       "C_oblongifolius     12.991179         53.682927\n",
       "\n",
       "[93 rows x 2 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Emax.to_csv('Emax_all.csv')\n",
    "df_Emax"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "433c6aa2-27e9-47b8-aa6c-02d6b83fbcb3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}