OntoMetrics_max_values.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "import pickle\n",
    "\n",
    "\n",
    "\n",
    "def extract_metric(tree_element):\n",
    "    metric_family = tree_element.tag\n",
    "    #print(metric_family)\n",
    "    for child in tree_element:\n",
    "        #print(\"---- \", child)\n",
    "        metric_document = {}\n",
    "        # if metric_document[\"metric_family\"] == \"ClassMetrics\":\n",
    "        #     metric_document[\"metric_family\"] =  metric_family\n",
    "        #     print(child)\n",
    "        #     exit()\n",
    "        #     metric_document[\"metric_name\"] = child.tag\n",
    "        #     metric_document[\"value\"] = child.text \n",
    "        #     print(metric_document)\n",
    "        # else:\n",
    "        metric_document[\"metric_family\"] =  metric_family\n",
    "        metric_document[\"metric_name\"] = child.tag\n",
    "        metric_document[\"value\"] = child.text \n",
    "        #print(metric_document)\n",
    "        yield metric_document\n",
    "\n",
    "def load_metrics(filename: str, ontology_name: str) -> pd.DataFrame:\n",
    "    tree = ET.parse(filename)\n",
    "    root = tree.getroot()\n",
    "    metrics = []\n",
    "    for child in root[0]:\n",
    "        if child.tag == \"Classmetrics\": ## we don't handle class metrics\n",
    "            #print(child)\n",
    "            continue\n",
    "            #exit()\n",
    "            #for metric_document in extract_metric(child):\n",
    "                #print(metric_document)\n",
    "                #metrics.append(metric_document)\n",
    "                #exit()\n",
    "        for metric_document in extract_metric(child):\n",
    "            metrics.append(metric_document)\n",
    "    df = pd.DataFrame(metrics).rename(columns={\"metric_name\": \"metric_code\", \"value\": ontology_name})\n",
    "    return df\n",
    "\n",
    "def add_metrics(df_metrics: pd.DataFrame, df_new_metrics: pd.DataFrame) -> pd.DataFrame:\n",
    "    selected_columns = list(set(df_new_metrics.columns) -  set(['metric_family']))\n",
    "    df_new_table = df_metrics.merge(df_new_metrics[selected_columns],how='left', on= \"metric_code\")\n",
    "    return df_new_table\n",
    "\n",
    "df_all = pd.read_csv(\"output2_mse.csv\")\n",
    "df_metrics_table = pd.read_excel(\"metrics_labels.xlsx\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>metric_family</th>\n",
       "      <th>metric_code</th>\n",
       "      <th>MatOnto</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Basemetrics</td>\n",
       "      <td>Axioms</td>\n",
       "      <td>631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Basemetrics</td>\n",
       "      <td>Logicalaxiomscount</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Basemetrics</td>\n",
       "      <td>Classcount</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Basemetrics</td>\n",
       "      <td>Totalclassescount</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Basemetrics</td>\n",
       "      <td>Objectpropertycount</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>ClassMetrics</td>\n",
       "      <td>Class</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>ClassMetrics</td>\n",
       "      <td>Class</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>ClassMetrics</td>\n",
       "      <td>Class</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>ClassMetrics</td>\n",
       "      <td>Class</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>ClassMetrics</td>\n",
       "      <td>Class</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>153 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    metric_family          metric_code MatOnto\n",
       "0     Basemetrics               Axioms     631\n",
       "1     Basemetrics   Logicalaxiomscount     226\n",
       "2     Basemetrics           Classcount      81\n",
       "3     Basemetrics    Totalclassescount      81\n",
       "4     Basemetrics  Objectpropertycount      35\n",
       "..            ...                  ...     ...\n",
       "148  ClassMetrics                Class      \\n\n",
       "149  ClassMetrics                Class      \\n\n",
       "150  ClassMetrics                Class      \\n\n",
       "151  ClassMetrics                Class      \\n\n",
       "152  ClassMetrics                Class      \\n\n",
       "\n",
       "[153 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_metrics_table = df_metrics_table[[\"metric_name\",\"metric_code\",\"ontometrics_name\",\"evaluation_criteria\"]]\n",
    "evaluated_ontologies = []\n",
    "\n",
    "filename = 'all_files/SAREF.xml'\n",
    "\n",
    "df_ = load_metrics(filename, df_all['namespace'][23])\n",
    "\n",
    "df_metrics_table = add_metrics(df_metrics_table, df_)\n",
    "\n",
    "\n",
    "df_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Element 'Classconnectivity' at 0x0000021C0678A110>\n",
      "<Element 'Classfulness' at 0x0000021C0678A160>\n",
      "<Element 'Classimportance' at 0x0000021C0678A1B0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678A250>\n",
      "<Element 'Classreadability' at 0x0000021C0678A2F0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678A390>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678A430>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678A4D0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678A570>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678A610>\n",
      "<Element 'Classfulness' at 0x0000021C0678A660>\n",
      "<Element 'Classimportance' at 0x0000021C0678A6B0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678A700>\n",
      "<Element 'Classreadability' at 0x0000021C0678A750>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678A7A0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678A7F0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678A840>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678A890>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678A930>\n",
      "<Element 'Classfulness' at 0x0000021C0678A980>\n",
      "<Element 'Classimportance' at 0x0000021C0678A9D0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678AA20>\n",
      "<Element 'Classreadability' at 0x0000021C0678AA70>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678AAC0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678AB10>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678AB60>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678ABB0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678AC50>\n",
      "<Element 'Classfulness' at 0x0000021C0678ACA0>\n",
      "<Element 'Classimportance' at 0x0000021C0678ACF0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678AD40>\n",
      "<Element 'Classreadability' at 0x0000021C0678AD90>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678ADE0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678AE30>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678AE80>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678AED0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678AF70>\n",
      "<Element 'Classfulness' at 0x0000021C0678AFC0>\n",
      "<Element 'Classimportance' at 0x0000021C0678B010>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678B060>\n",
      "<Element 'Classreadability' at 0x0000021C0678B0B0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678B100>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678B150>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678B1A0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678B1F0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678B290>\n",
      "<Element 'Classfulness' at 0x0000021C0678B2E0>\n",
      "<Element 'Classimportance' at 0x0000021C0678B330>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678B380>\n",
      "<Element 'Classreadability' at 0x0000021C0678B3D0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678B420>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678B470>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678B4C0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678B510>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678B5B0>\n",
      "<Element 'Classfulness' at 0x0000021C0678B600>\n",
      "<Element 'Classimportance' at 0x0000021C0678B650>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678B6A0>\n",
      "<Element 'Classreadability' at 0x0000021C0678B6F0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678B740>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678B790>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678B7E0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678B830>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678B8D0>\n",
      "<Element 'Classfulness' at 0x0000021C0678B920>\n",
      "<Element 'Classimportance' at 0x0000021C0678B970>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678B9C0>\n",
      "<Element 'Classreadability' at 0x0000021C0678BA10>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678BA60>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678BAB0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678BB00>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678BB50>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678BBF0>\n",
      "<Element 'Classfulness' at 0x0000021C0678BC40>\n",
      "<Element 'Classimportance' at 0x0000021C0678BC90>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0678BCE0>\n",
      "<Element 'Classreadability' at 0x0000021C0678BD30>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0678BD80>\n",
      "<Element 'Classchildrencount' at 0x0000021C0678BDD0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0678BE20>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0678BE70>\n",
      "<Element 'Classconnectivity' at 0x0000021C0678BF10>\n",
      "<Element 'Classfulness' at 0x0000021C0678BF60>\n",
      "<Element 'Classimportance' at 0x0000021C0678BFB0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06790040>\n",
      "<Element 'Classreadability' at 0x0000021C06790090>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067900E0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06790130>\n",
      "<Element 'Classinstancescount' at 0x0000021C06790180>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067901D0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06790270>\n",
      "<Element 'Classfulness' at 0x0000021C067902C0>\n",
      "<Element 'Classimportance' at 0x0000021C06790310>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06790360>\n",
      "<Element 'Classreadability' at 0x0000021C067903B0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06790400>\n",
      "<Element 'Classchildrencount' at 0x0000021C06790450>\n",
      "<Element 'Classinstancescount' at 0x0000021C067904A0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067904F0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06790590>\n",
      "<Element 'Classfulness' at 0x0000021C067905E0>\n",
      "<Element 'Classimportance' at 0x0000021C06790630>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06790680>\n",
      "<Element 'Classreadability' at 0x0000021C067906D0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06790720>\n",
      "<Element 'Classchildrencount' at 0x0000021C06790770>\n",
      "<Element 'Classinstancescount' at 0x0000021C067907C0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06790810>\n",
      "<Element 'Classconnectivity' at 0x0000021C067908B0>\n",
      "<Element 'Classfulness' at 0x0000021C06790900>\n",
      "<Element 'Classimportance' at 0x0000021C06790950>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067909A0>\n",
      "<Element 'Classreadability' at 0x0000021C067909F0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06790A40>\n",
      "<Element 'Classchildrencount' at 0x0000021C06790A90>\n",
      "<Element 'Classinstancescount' at 0x0000021C06790AE0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06790B30>\n",
      "<Element 'Classconnectivity' at 0x0000021C06790BD0>\n",
      "<Element 'Classfulness' at 0x0000021C06790C20>\n",
      "<Element 'Classimportance' at 0x0000021C06790C70>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06790CC0>\n",
      "<Element 'Classreadability' at 0x0000021C06790D10>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06790D60>\n",
      "<Element 'Classchildrencount' at 0x0000021C06790DB0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06790E00>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06790E50>\n",
      "<Element 'Classconnectivity' at 0x0000021C06790EF0>\n",
      "<Element 'Classfulness' at 0x0000021C06790F40>\n",
      "<Element 'Classimportance' at 0x0000021C06790F90>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06790FE0>\n",
      "<Element 'Classreadability' at 0x0000021C06791030>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06791080>\n",
      "<Element 'Classchildrencount' at 0x0000021C067910D0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06791120>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06791170>\n",
      "<Element 'Classconnectivity' at 0x0000021C06791210>\n",
      "<Element 'Classfulness' at 0x0000021C06791260>\n",
      "<Element 'Classimportance' at 0x0000021C067912B0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06791300>\n",
      "<Element 'Classreadability' at 0x0000021C06791350>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067913A0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067913F0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06791440>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06791490>\n",
      "<Element 'Classconnectivity' at 0x0000021C06791530>\n",
      "<Element 'Classfulness' at 0x0000021C06791580>\n",
      "<Element 'Classimportance' at 0x0000021C067915D0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06791620>\n",
      "<Element 'Classreadability' at 0x0000021C06791670>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067916C0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06791710>\n",
      "<Element 'Classinstancescount' at 0x0000021C06791760>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067917B0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06791850>\n",
      "<Element 'Classfulness' at 0x0000021C067918A0>\n",
      "<Element 'Classimportance' at 0x0000021C067918F0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06791940>\n",
      "<Element 'Classreadability' at 0x0000021C06791990>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067919E0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06791A30>\n",
      "<Element 'Classinstancescount' at 0x0000021C06791A80>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06791AD0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06791B70>\n",
      "<Element 'Classfulness' at 0x0000021C06791BC0>\n",
      "<Element 'Classimportance' at 0x0000021C06791C10>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06791C60>\n",
      "<Element 'Classreadability' at 0x0000021C06791CB0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06791D00>\n",
      "<Element 'Classchildrencount' at 0x0000021C06791D50>\n",
      "<Element 'Classinstancescount' at 0x0000021C06791DA0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06791DF0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06791E90>\n",
      "<Element 'Classfulness' at 0x0000021C06791EE0>\n",
      "<Element 'Classimportance' at 0x0000021C06791F30>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06791F80>\n",
      "<Element 'Classreadability' at 0x0000021C06791FD0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792020>\n",
      "<Element 'Classchildrencount' at 0x0000021C06792070>\n",
      "<Element 'Classinstancescount' at 0x0000021C067920C0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06792110>\n",
      "<Element 'Classconnectivity' at 0x0000021C067921B0>\n",
      "<Element 'Classfulness' at 0x0000021C06792200>\n",
      "<Element 'Classimportance' at 0x0000021C06792250>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067922A0>\n",
      "<Element 'Classreadability' at 0x0000021C067922F0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792340>\n",
      "<Element 'Classchildrencount' at 0x0000021C06792390>\n",
      "<Element 'Classinstancescount' at 0x0000021C067923E0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06792430>\n",
      "<Element 'Classconnectivity' at 0x0000021C067924D0>\n",
      "<Element 'Classfulness' at 0x0000021C06792520>\n",
      "<Element 'Classimportance' at 0x0000021C06792570>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067925C0>\n",
      "<Element 'Classreadability' at 0x0000021C06792610>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792660>\n",
      "<Element 'Classchildrencount' at 0x0000021C067926B0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06792700>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06792750>\n",
      "<Element 'Classconnectivity' at 0x0000021C067927F0>\n",
      "<Element 'Classfulness' at 0x0000021C06792840>\n",
      "<Element 'Classimportance' at 0x0000021C06792890>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067928E0>\n",
      "<Element 'Classreadability' at 0x0000021C06792930>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792980>\n",
      "<Element 'Classchildrencount' at 0x0000021C067929D0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06792A20>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06792A70>\n",
      "<Element 'Classconnectivity' at 0x0000021C06792B10>\n",
      "<Element 'Classfulness' at 0x0000021C06792B60>\n",
      "<Element 'Classimportance' at 0x0000021C06792BB0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06792C00>\n",
      "<Element 'Classreadability' at 0x0000021C06792C50>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792CA0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06792CF0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06792D40>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06792D90>\n",
      "<Element 'Classconnectivity' at 0x0000021C06792E30>\n",
      "<Element 'Classfulness' at 0x0000021C06792E80>\n",
      "<Element 'Classimportance' at 0x0000021C06792ED0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06792F20>\n",
      "<Element 'Classreadability' at 0x0000021C06792F70>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06792FC0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793010>\n",
      "<Element 'Classinstancescount' at 0x0000021C06793060>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067930B0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06793150>\n",
      "<Element 'Classfulness' at 0x0000021C067931A0>\n",
      "<Element 'Classimportance' at 0x0000021C067931F0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06793240>\n",
      "<Element 'Classreadability' at 0x0000021C06793290>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067932E0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793330>\n",
      "<Element 'Classinstancescount' at 0x0000021C06793380>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067933D0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06793470>\n",
      "<Element 'Classfulness' at 0x0000021C067934C0>\n",
      "<Element 'Classimportance' at 0x0000021C06793510>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06793560>\n",
      "<Element 'Classreadability' at 0x0000021C067935B0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06793600>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793650>\n",
      "<Element 'Classinstancescount' at 0x0000021C067936A0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067936F0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06793790>\n",
      "<Element 'Classfulness' at 0x0000021C067937E0>\n",
      "<Element 'Classimportance' at 0x0000021C06793830>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06793880>\n",
      "<Element 'Classreadability' at 0x0000021C067938D0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06793920>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793970>\n",
      "<Element 'Classinstancescount' at 0x0000021C067939C0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06793A10>\n",
      "<Element 'Classconnectivity' at 0x0000021C06793AB0>\n",
      "<Element 'Classfulness' at 0x0000021C06793B00>\n",
      "<Element 'Classimportance' at 0x0000021C06793B50>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06793BA0>\n",
      "<Element 'Classreadability' at 0x0000021C06793BF0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06793C40>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793C90>\n",
      "<Element 'Classinstancescount' at 0x0000021C06793CE0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06793D30>\n",
      "<Element 'Classconnectivity' at 0x0000021C06793DD0>\n",
      "<Element 'Classfulness' at 0x0000021C06793E20>\n",
      "<Element 'Classimportance' at 0x0000021C06793E70>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06793EC0>\n",
      "<Element 'Classreadability' at 0x0000021C06793F10>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06793F60>\n",
      "<Element 'Classchildrencount' at 0x0000021C06793FB0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06794040>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06794090>\n",
      "<Element 'Classconnectivity' at 0x0000021C06794130>\n",
      "<Element 'Classfulness' at 0x0000021C06794180>\n",
      "<Element 'Classimportance' at 0x0000021C067941D0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06794220>\n",
      "<Element 'Classreadability' at 0x0000021C06794270>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067942C0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06794310>\n",
      "<Element 'Classinstancescount' at 0x0000021C06794360>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067943B0>\n",
      "<Element 'Classconnectivity' at 0x0000021C067944A0>\n",
      "<Element 'Classfulness' at 0x0000021C067944F0>\n",
      "<Element 'Classimportance' at 0x0000021C06794540>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06794590>\n",
      "<Element 'Classreadability' at 0x0000021C067945E0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06794630>\n",
      "<Element 'Classchildrencount' at 0x0000021C06794680>\n",
      "<Element 'Classinstancescount' at 0x0000021C067946D0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06794720>\n",
      "<Element 'Classconnectivity' at 0x0000021C067947C0>\n",
      "<Element 'Classfulness' at 0x0000021C06794810>\n",
      "<Element 'Classimportance' at 0x0000021C06794860>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067948B0>\n",
      "<Element 'Classreadability' at 0x0000021C06794900>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06794950>\n",
      "<Element 'Classchildrencount' at 0x0000021C067949A0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067949F0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06794A40>\n",
      "<Element 'Classconnectivity' at 0x0000021C06794AE0>\n",
      "<Element 'Classfulness' at 0x0000021C06794B30>\n",
      "<Element 'Classimportance' at 0x0000021C06794B80>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06794BD0>\n",
      "<Element 'Classreadability' at 0x0000021C06794C20>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06794C70>\n",
      "<Element 'Classchildrencount' at 0x0000021C06794CC0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06794D10>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06794D60>\n",
      "<Element 'Classconnectivity' at 0x0000021C06794E00>\n",
      "<Element 'Classfulness' at 0x0000021C06794E50>\n",
      "<Element 'Classimportance' at 0x0000021C06794EA0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06794EF0>\n",
      "<Element 'Classreadability' at 0x0000021C06794F40>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06794F90>\n",
      "<Element 'Classchildrencount' at 0x0000021C06794FE0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795030>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06795080>\n",
      "<Element 'Classconnectivity' at 0x0000021C06795120>\n",
      "<Element 'Classfulness' at 0x0000021C06795170>\n",
      "<Element 'Classimportance' at 0x0000021C067951C0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06795210>\n",
      "<Element 'Classreadability' at 0x0000021C06795260>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067952B0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06795300>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795350>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067953A0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06795440>\n",
      "<Element 'Classfulness' at 0x0000021C06795490>\n",
      "<Element 'Classimportance' at 0x0000021C067954E0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06795530>\n",
      "<Element 'Classreadability' at 0x0000021C06795580>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067955D0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06795620>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795670>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067956C0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06795760>\n",
      "<Element 'Classfulness' at 0x0000021C067957B0>\n",
      "<Element 'Classimportance' at 0x0000021C06795800>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06795850>\n",
      "<Element 'Classreadability' at 0x0000021C067958A0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067958F0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06795940>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795990>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067959E0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06795A80>\n",
      "<Element 'Classfulness' at 0x0000021C06795AD0>\n",
      "<Element 'Classimportance' at 0x0000021C06795B20>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06795B70>\n",
      "<Element 'Classreadability' at 0x0000021C06795BC0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06795C10>\n",
      "<Element 'Classchildrencount' at 0x0000021C06795C60>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795CB0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06795D00>\n",
      "<Element 'Classconnectivity' at 0x0000021C06795DA0>\n",
      "<Element 'Classfulness' at 0x0000021C06795DF0>\n",
      "<Element 'Classimportance' at 0x0000021C06795E40>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06795E90>\n",
      "<Element 'Classreadability' at 0x0000021C06795EE0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06795F30>\n",
      "<Element 'Classchildrencount' at 0x0000021C06795F80>\n",
      "<Element 'Classinstancescount' at 0x0000021C06795FD0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796020>\n",
      "<Element 'Classconnectivity' at 0x0000021C067960C0>\n",
      "<Element 'Classfulness' at 0x0000021C06796110>\n",
      "<Element 'Classimportance' at 0x0000021C06796160>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067961B0>\n",
      "<Element 'Classreadability' at 0x0000021C06796200>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06796250>\n",
      "<Element 'Classchildrencount' at 0x0000021C067962A0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067962F0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796340>\n",
      "<Element 'Classconnectivity' at 0x0000021C067963E0>\n",
      "<Element 'Classfulness' at 0x0000021C06796430>\n",
      "<Element 'Classimportance' at 0x0000021C06796480>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067964D0>\n",
      "<Element 'Classreadability' at 0x0000021C06796520>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06796570>\n",
      "<Element 'Classchildrencount' at 0x0000021C067965C0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06796610>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796660>\n",
      "<Element 'Classconnectivity' at 0x0000021C06796700>\n",
      "<Element 'Classfulness' at 0x0000021C06796750>\n",
      "<Element 'Classimportance' at 0x0000021C067967A0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067967F0>\n",
      "<Element 'Classreadability' at 0x0000021C06796840>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06796890>\n",
      "<Element 'Classchildrencount' at 0x0000021C067968E0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06796930>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796980>\n",
      "<Element 'Classconnectivity' at 0x0000021C06796A20>\n",
      "<Element 'Classfulness' at 0x0000021C06796A70>\n",
      "<Element 'Classimportance' at 0x0000021C06796AC0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06796B10>\n",
      "<Element 'Classreadability' at 0x0000021C06796B60>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06796BB0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06796C00>\n",
      "<Element 'Classinstancescount' at 0x0000021C06796C50>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796CA0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06796D40>\n",
      "<Element 'Classfulness' at 0x0000021C06796D90>\n",
      "<Element 'Classimportance' at 0x0000021C06796DE0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06796E30>\n",
      "<Element 'Classreadability' at 0x0000021C06796E80>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06796ED0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06796F20>\n",
      "<Element 'Classinstancescount' at 0x0000021C06796F70>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06796FC0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06797060>\n",
      "<Element 'Classfulness' at 0x0000021C067970B0>\n",
      "<Element 'Classimportance' at 0x0000021C06797100>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06797150>\n",
      "<Element 'Classreadability' at 0x0000021C067971A0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067971F0>\n",
      "<Element 'Classchildrencount' at 0x0000021C06797240>\n",
      "<Element 'Classinstancescount' at 0x0000021C06797290>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067972E0>\n",
      "<Element 'Classconnectivity' at 0x0000021C06797380>\n",
      "<Element 'Classfulness' at 0x0000021C067973D0>\n",
      "<Element 'Classimportance' at 0x0000021C06797420>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06797470>\n",
      "<Element 'Classreadability' at 0x0000021C067974C0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06797510>\n",
      "<Element 'Classchildrencount' at 0x0000021C06797560>\n",
      "<Element 'Classinstancescount' at 0x0000021C067975B0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06797600>\n",
      "<Element 'Classconnectivity' at 0x0000021C067976A0>\n",
      "<Element 'Classfulness' at 0x0000021C067976F0>\n",
      "<Element 'Classimportance' at 0x0000021C06797740>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06797790>\n",
      "<Element 'Classreadability' at 0x0000021C067977E0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06797830>\n",
      "<Element 'Classchildrencount' at 0x0000021C06797880>\n",
      "<Element 'Classinstancescount' at 0x0000021C067978D0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06797920>\n",
      "<Element 'Classconnectivity' at 0x0000021C067979C0>\n",
      "<Element 'Classfulness' at 0x0000021C06797A10>\n",
      "<Element 'Classimportance' at 0x0000021C06797A60>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06797AB0>\n",
      "<Element 'Classreadability' at 0x0000021C06797B00>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06797B50>\n",
      "<Element 'Classchildrencount' at 0x0000021C06797BA0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06797BF0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06797C40>\n",
      "<Element 'Classconnectivity' at 0x0000021C06797CE0>\n",
      "<Element 'Classfulness' at 0x0000021C06797D30>\n",
      "<Element 'Classimportance' at 0x0000021C06797D80>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C06797DD0>\n",
      "<Element 'Classreadability' at 0x0000021C06797E20>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C06797E70>\n",
      "<Element 'Classchildrencount' at 0x0000021C06797EC0>\n",
      "<Element 'Classinstancescount' at 0x0000021C06797F10>\n",
      "<Element 'Classpropertiescount' at 0x0000021C06797F60>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679C040>\n",
      "<Element 'Classfulness' at 0x0000021C0679C090>\n",
      "<Element 'Classimportance' at 0x0000021C0679C0E0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679C130>\n",
      "<Element 'Classreadability' at 0x0000021C0679C180>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679C1D0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679C220>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679C270>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679C2C0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679C360>\n",
      "<Element 'Classfulness' at 0x0000021C0679C3B0>\n",
      "<Element 'Classimportance' at 0x0000021C0679C400>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679C450>\n",
      "<Element 'Classreadability' at 0x0000021C0679C4A0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679C4F0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679C540>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679C590>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679C5E0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679C680>\n",
      "<Element 'Classfulness' at 0x0000021C0679C6D0>\n",
      "<Element 'Classimportance' at 0x0000021C0679C720>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679C770>\n",
      "<Element 'Classreadability' at 0x0000021C0679C7C0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679C810>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679C860>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679C8B0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679C900>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679C9A0>\n",
      "<Element 'Classfulness' at 0x0000021C0679C9F0>\n",
      "<Element 'Classimportance' at 0x0000021C0679CA40>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679CA90>\n",
      "<Element 'Classreadability' at 0x0000021C0679CAE0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679CB30>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679CB80>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679CBD0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679CC20>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679CCC0>\n",
      "<Element 'Classfulness' at 0x0000021C0679CD10>\n",
      "<Element 'Classimportance' at 0x0000021C0679CD60>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679CDB0>\n",
      "<Element 'Classreadability' at 0x0000021C0679CE00>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679CE50>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679CEA0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679CEF0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679CF40>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679CFE0>\n",
      "<Element 'Classfulness' at 0x0000021C0679D030>\n",
      "<Element 'Classimportance' at 0x0000021C0679D080>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679D0D0>\n",
      "<Element 'Classreadability' at 0x0000021C0679D120>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679D170>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679D1C0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679D210>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679D260>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679D300>\n",
      "<Element 'Classfulness' at 0x0000021C0679D350>\n",
      "<Element 'Classimportance' at 0x0000021C0679D3A0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679D3F0>\n",
      "<Element 'Classreadability' at 0x0000021C0679D440>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679D490>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679D4E0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679D530>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679D580>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679D620>\n",
      "<Element 'Classfulness' at 0x0000021C0679D670>\n",
      "<Element 'Classimportance' at 0x0000021C0679D6C0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679D710>\n",
      "<Element 'Classreadability' at 0x0000021C0679D760>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679D7B0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679D800>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679D850>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679D8A0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679D940>\n",
      "<Element 'Classfulness' at 0x0000021C0679D990>\n",
      "<Element 'Classimportance' at 0x0000021C0679D9E0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679DA30>\n",
      "<Element 'Classreadability' at 0x0000021C0679DA80>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679DAD0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679DB20>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679DB70>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679DBC0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679DC60>\n",
      "<Element 'Classfulness' at 0x0000021C0679DCB0>\n",
      "<Element 'Classimportance' at 0x0000021C0679DD00>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679DD50>\n",
      "<Element 'Classreadability' at 0x0000021C0679DDA0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679DDF0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679DE40>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679DE90>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679DEE0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679DF80>\n",
      "<Element 'Classfulness' at 0x0000021C0679DFD0>\n",
      "<Element 'Classimportance' at 0x0000021C0679E020>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679E070>\n",
      "<Element 'Classreadability' at 0x0000021C0679E0C0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679E110>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679E160>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679E1B0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679E200>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679E2A0>\n",
      "<Element 'Classfulness' at 0x0000021C0679E2F0>\n",
      "<Element 'Classimportance' at 0x0000021C0679E340>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679E390>\n",
      "<Element 'Classreadability' at 0x0000021C0679E3E0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679E430>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679E480>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679E4D0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679E520>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679E5C0>\n",
      "<Element 'Classfulness' at 0x0000021C0679E610>\n",
      "<Element 'Classimportance' at 0x0000021C0679E660>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679E6B0>\n",
      "<Element 'Classreadability' at 0x0000021C0679E700>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679E750>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679E7A0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679E7F0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679E840>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679E8E0>\n",
      "<Element 'Classfulness' at 0x0000021C0679E930>\n",
      "<Element 'Classimportance' at 0x0000021C0679E980>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679E9D0>\n",
      "<Element 'Classreadability' at 0x0000021C0679EA20>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679EA70>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679EAC0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679EB10>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679EB60>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679EC00>\n",
      "<Element 'Classfulness' at 0x0000021C0679EC50>\n",
      "<Element 'Classimportance' at 0x0000021C0679ECA0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679ECF0>\n",
      "<Element 'Classreadability' at 0x0000021C0679ED40>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679ED90>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679EDE0>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679EE30>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679EE80>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679EF20>\n",
      "<Element 'Classfulness' at 0x0000021C0679EF70>\n",
      "<Element 'Classimportance' at 0x0000021C0679EFC0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679F010>\n",
      "<Element 'Classreadability' at 0x0000021C0679F060>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679F0B0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679F100>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679F150>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679F1A0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679F240>\n",
      "<Element 'Classfulness' at 0x0000021C0679F290>\n",
      "<Element 'Classimportance' at 0x0000021C0679F2E0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679F330>\n",
      "<Element 'Classreadability' at 0x0000021C0679F380>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679F3D0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679F420>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679F470>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679F4C0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679F560>\n",
      "<Element 'Classfulness' at 0x0000021C0679F5B0>\n",
      "<Element 'Classimportance' at 0x0000021C0679F600>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679F650>\n",
      "<Element 'Classreadability' at 0x0000021C0679F6A0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679F6F0>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679F740>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679F790>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679F7E0>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679F880>\n",
      "<Element 'Classfulness' at 0x0000021C0679F8D0>\n",
      "<Element 'Classimportance' at 0x0000021C0679F920>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679F970>\n",
      "<Element 'Classreadability' at 0x0000021C0679F9C0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679FA10>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679FA60>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679FAB0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679FB00>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679FBA0>\n",
      "<Element 'Classfulness' at 0x0000021C0679FBF0>\n",
      "<Element 'Classimportance' at 0x0000021C0679FC40>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679FC90>\n",
      "<Element 'Classreadability' at 0x0000021C0679FCE0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C0679FD30>\n",
      "<Element 'Classchildrencount' at 0x0000021C0679FD80>\n",
      "<Element 'Classinstancescount' at 0x0000021C0679FDD0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C0679FE20>\n",
      "<Element 'Classconnectivity' at 0x0000021C0679FEC0>\n",
      "<Element 'Classfulness' at 0x0000021C0679FF10>\n",
      "<Element 'Classimportance' at 0x0000021C0679FF60>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C0679FFB0>\n",
      "<Element 'Classreadability' at 0x0000021C067A0040>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A0090>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A00E0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A0130>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A0180>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A0220>\n",
      "<Element 'Classfulness' at 0x0000021C067A0270>\n",
      "<Element 'Classimportance' at 0x0000021C067A02C0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A0310>\n",
      "<Element 'Classreadability' at 0x0000021C067A0360>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A03B0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A0400>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A0450>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A04A0>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A0540>\n",
      "<Element 'Classfulness' at 0x0000021C067A0590>\n",
      "<Element 'Classimportance' at 0x0000021C067A05E0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A0630>\n",
      "<Element 'Classreadability' at 0x0000021C067A0680>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A06D0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A0720>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A0770>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A07C0>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A0860>\n",
      "<Element 'Classfulness' at 0x0000021C067A08B0>\n",
      "<Element 'Classimportance' at 0x0000021C067A0900>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A0950>\n",
      "<Element 'Classreadability' at 0x0000021C067A09A0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A09F0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A0A40>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A0A90>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A0AE0>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A0B80>\n",
      "<Element 'Classfulness' at 0x0000021C067A0BD0>\n",
      "<Element 'Classimportance' at 0x0000021C067A0C20>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A0C70>\n",
      "<Element 'Classreadability' at 0x0000021C067A0CC0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A0D10>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A0D60>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A0DB0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A0E00>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A0EA0>\n",
      "<Element 'Classfulness' at 0x0000021C067A0EF0>\n",
      "<Element 'Classimportance' at 0x0000021C067A0F40>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A0F90>\n",
      "<Element 'Classreadability' at 0x0000021C067A0FE0>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1030>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A1080>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A10D0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A1120>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A11C0>\n",
      "<Element 'Classfulness' at 0x0000021C067A1210>\n",
      "<Element 'Classimportance' at 0x0000021C067A1260>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A12B0>\n",
      "<Element 'Classreadability' at 0x0000021C067A1300>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1350>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A13A0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A13F0>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A1440>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A14E0>\n",
      "<Element 'Classfulness' at 0x0000021C067A1530>\n",
      "<Element 'Classimportance' at 0x0000021C067A1580>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A15D0>\n",
      "<Element 'Classreadability' at 0x0000021C067A1620>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1670>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A16C0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A1710>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A1760>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A1800>\n",
      "<Element 'Classfulness' at 0x0000021C067A1850>\n",
      "<Element 'Classimportance' at 0x0000021C067A18A0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A18F0>\n",
      "<Element 'Classreadability' at 0x0000021C067A1940>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1990>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A19E0>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A1A30>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A1A80>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A1B20>\n",
      "<Element 'Classfulness' at 0x0000021C067A1B70>\n",
      "<Element 'Classimportance' at 0x0000021C067A1BC0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A1C10>\n",
      "<Element 'Classreadability' at 0x0000021C067A1C60>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1CB0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A1D00>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A1D50>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A1DA0>\n",
      "<Element 'Classconnectivity' at 0x0000021C067A1E40>\n",
      "<Element 'Classfulness' at 0x0000021C067A1E90>\n",
      "<Element 'Classimportance' at 0x0000021C067A1EE0>\n",
      "<Element 'Classinheritancerichness' at 0x0000021C067A1F30>\n",
      "<Element 'Classreadability' at 0x0000021C067A1F80>\n",
      "<Element 'Classrelationshiprichness' at 0x0000021C067A1FD0>\n",
      "<Element 'Classchildrencount' at 0x0000021C067A2020>\n",
      "<Element 'Classinstancescount' at 0x0000021C067A2070>\n",
      "<Element 'Classpropertiescount' at 0x0000021C067A20C0>\n",
      "0 https://saref.etsi.org/core/TemperatureSensor\n"
     ]
    }
   ],
   "source": [
    "tree = ET.parse(filename)\n",
    "root = tree.getroot()\n",
    "metrics = []\n",
    "metric_document = {}\n",
    "ClassMetrics = ['Classconnectivity',\n",
    "'Classfulness',\n",
    "'Classimportance',\n",
    "'Classinheritancerichness',\n",
    "'Classreadability',\n",
    "'Classrelationshiprichness',\n",
    "'Classchildrencount',\n",
    "'Classinstancescount',\n",
    "'Classpropertiescount']\n",
    "\n",
    "for child in root[0]:\n",
    "    if child.tag == \"ClassMetrics\":\n",
    "        child_l_ = []\n",
    "        child_l_names = []\n",
    "        for child_ in child:\n",
    "            child_l = []\n",
    "            child_l_names.append(child_.attrib.get('iri'))\n",
    "            for child_2 in child_:\n",
    "                print(child_2)\n",
    "                child_l.append(int(float(child_2.text)))\n",
    "            child_l_.append(child_l)\n",
    "        transposed_data = zip(*child_l_)\n",
    "\n",
    "        # Calculate max, min, and average for each column\n",
    "        max_values = [max(column) for column in transposed_data]\n",
    "        min_values = [min(column) for column in transposed_data]\n",
    "        avg_values = [sum(column) / len(column) for column in transposed_data]\n",
    "        for j in range(9):\n",
    "            for ii in [i for i, sublist in enumerate(child_l_) if sublist[j] == max_values[j] and max_values[j] != 0]:\n",
    "                continue\n",
    "        print(max_values[j], child_l_names[0])\n",
    "        metric_document[\"metric_family\"] =  \"ClassMetrics\"\n",
    "        metric_document[\"metric_name\"] = ClassMetrics[j]\n",
    "        metric_document[\"value\"] = child_l_names[0]\n",
    "        #child_l_names[child_l_.index(max_values)]\n",
    "        \n",
    "        #max_indices = [i for i, column in enumerate(transposed_data) if max(column) == max_values[i]]\n",
    "\n",
    "        # Map the indices to the corresponding data names\n",
    "        #max_names = [child_l_names[index] for index in max_indices]\n",
    "\n",
    "        # Map the indices to the corresponding data names\n",
    "\n",
    "        #print(max_names)\n",
    "        #print(\"Max values:\", max_values)\n",
    "        #print(\"Min values:\", min_values)\n",
    "        #print(\"Avg values:\", avg_values)\n",
    "        \n",
    "            #max(child_max)\n",
    "            #metric_document = {}\n",
    "            # if metric_document[\"metric_family\"] == \"ClassMetrics\":\n",
    "            #     metric_document[\"metric_family\"] =  metric_family\n",
    "            #     print(child)\n",
    "            #     exit()\n",
    "            #     metric_document[\"metric_name\"] = child.tag\n",
    "            #     metric_document[\"value\"] = child.text \n",
    "            #     print(metric_document)\n",
    "            # else:\n",
    "            #metric_document[\"metric_family\"] =  metric_family\n",
    "            #metric_document[\"metric_name\"] = child.tag\n",
    "            #metric_document[\"value\"] = child.text \n",
    "        #print(metric_document)\n",
    "        #continue\n",
    "        #exit()\n",
    "        #for metric_document in extract_metric(child):\n",
    "            #print(metric_document)\n",
    "            #metrics.append(metric_document)\n",
    "            #exit()\n",
    "    #for metric_document in extract_metric(child):\n",
    "        #print(metric_document)\n",
    "        #metrics.append(metric_document)\n",
    "    #print(child.tag)\n",
    "#metrics\n",
    "#df_ = pd.DataFrame(metrics).rename(columns={\"metric_name\": \"metric_code\", \"value\": df_all['namespace'][28]})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 https://saref.etsi.org/core/TemperatureSensor\n",
      "0 https://saref.etsi.org/core/TemperatureSensor\n",
      "1 https://saref.etsi.org/core/TemperatureSensor\n",
      "81 https://saref.etsi.org/core/TemperatureSensor\n",
      "2 https://saref.etsi.org/core/TemperatureSensor\n",
      "0 https://saref.etsi.org/core/TemperatureSensor\n",
      "19 https://saref.etsi.org/core/TemperatureSensor\n",
      "10 https://saref.etsi.org/core/TemperatureSensor\n",
      "0 https://saref.etsi.org/core/TemperatureSensor\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_values[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>metric_name</th>\n",
       "      <th>ontometrics_name</th>\n",
       "      <th>evaluation_criteria</th>\n",
       "      <th>MatOnto_x</th>\n",
       "      <th>MatOnto_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td># axioms</td>\n",
       "      <td>Axioms</td>\n",
       "      <td>None</td>\n",
       "      <td>631</td>\n",
       "      <td>631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td># logical axioms</td>\n",
       "      <td>Logical Axiom count</td>\n",
       "      <td>None</td>\n",
       "      <td>226</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td># classes</td>\n",
       "      <td>Class count</td>\n",
       "      <td>None</td>\n",
       "      <td>81</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td># object properties</td>\n",
       "      <td>Object properties count</td>\n",
       "      <td>None</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td># datatype properties</td>\n",
       "      <td>Data property count</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td># annotation assertions</td>\n",
       "      <td>Annotation assertions axiom count</td>\n",
       "      <td>None</td>\n",
       "      <td>264</td>\n",
       "      <td>264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DL expressivity</td>\n",
       "      <td>DL expressivity</td>\n",
       "      <td>None</td>\n",
       "      <td>ALCIQ(D)</td>\n",
       "      <td>ALCIQ(D)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Attribute Richness</td>\n",
       "      <td>Attribute Richness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.061728</td>\n",
       "      <td>0.061728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Inheritance Richness</td>\n",
       "      <td>Inheritance Richness</td>\n",
       "      <td>low =&gt; vertical&amp;#10;high =&gt; orizontal&amp;#10;</td>\n",
       "      <td>1.814815</td>\n",
       "      <td>1.814815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Relationship Richness</td>\n",
       "      <td>Relationship Richness</td>\n",
       "      <td>low =&gt; less information&amp;#10;High =&gt; more infor...</td>\n",
       "      <td>0.209677</td>\n",
       "      <td>0.209677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Axiom Class Ratio</td>\n",
       "      <td>Axiom Class Ratio</td>\n",
       "      <td>low (near 0) =&gt; poor axiomatisation&amp;#10;Higher...</td>\n",
       "      <td>7.790123</td>\n",
       "      <td>7.790123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Equivalence Ratio</td>\n",
       "      <td>Equivalence Ratio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Class/propery ratio</td>\n",
       "      <td>Class Relation Ratio</td>\n",
       "      <td>Low values (i.e near 0) indicate an ontology w...</td>\n",
       "      <td>0.435484</td>\n",
       "      <td>0.435484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NoR</td>\n",
       "      <td>Absolute root cardinality</td>\n",
       "      <td>The interpretation of NoR values depends on th...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NoL</td>\n",
       "      <td>Absolute leaf cardinality</td>\n",
       "      <td>The interpretation of NoL values depends on th...</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Absolute depth</td>\n",
       "      <td>Absolute depth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ADIT-LN</td>\n",
       "      <td>Average depth</td>\n",
       "      <td>The interpretation of the values depends on th...</td>\n",
       "      <td>2.04</td>\n",
       "      <td>2.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Max depth</td>\n",
       "      <td>Maximal depth</td>\n",
       "      <td>The interpretation of max depth is similar to ...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Absolute breadth</td>\n",
       "      <td>Absolute breadth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Average breadth</td>\n",
       "      <td>Average breadth</td>\n",
       "      <td>The value should be interpreted relatively to ...</td>\n",
       "      <td>3.571429</td>\n",
       "      <td>3.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Max breadth</td>\n",
       "      <td>Maximal breadth</td>\n",
       "      <td>The value should be interpreted relatively to ...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Tangledness</td>\n",
       "      <td>Tangledness</td>\n",
       "      <td>Values for tangledness range from 0 (i.e. no t...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Classconnectivity</td>\n",
       "      <td>Classconnectivity</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Classfulness</td>\n",
       "      <td>Classfulness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Classimportance</td>\n",
       "      <td>Classimportance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Classinheritancerichness</td>\n",
       "      <td>Classinheritancerichness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Classreadability</td>\n",
       "      <td>Classreadability</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Classrelationshiprichness</td>\n",
       "      <td>Classrelationshiprichness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Classchildrencount</td>\n",
       "      <td>Classchildrencount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Classinstancescount</td>\n",
       "      <td>Classinstancescount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Classpropertiescount</td>\n",
       "      <td>Classpropertiescount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  metric_name                   ontometrics_name  \\\n",
       "0                    # axioms                             Axioms   \n",
       "1            # logical axioms                Logical Axiom count   \n",
       "2                   # classes                        Class count   \n",
       "3         # object properties            Object properties count   \n",
       "4       # datatype properties                Data property count   \n",
       "5     # annotation assertions  Annotation assertions axiom count   \n",
       "6             DL expressivity                    DL expressivity   \n",
       "7          Attribute Richness                 Attribute Richness   \n",
       "8        Inheritance Richness               Inheritance Richness   \n",
       "9       Relationship Richness              Relationship Richness   \n",
       "10          Axiom Class Ratio                  Axiom Class Ratio   \n",
       "11          Equivalence Ratio                  Equivalence Ratio   \n",
       "12        Class/propery ratio               Class Relation Ratio   \n",
       "13                        NoR          Absolute root cardinality   \n",
       "14                        NoL          Absolute leaf cardinality   \n",
       "15             Absolute depth                     Absolute depth   \n",
       "16                    ADIT-LN                      Average depth   \n",
       "17                  Max depth                      Maximal depth   \n",
       "18           Absolute breadth                   Absolute breadth   \n",
       "19            Average breadth                    Average breadth   \n",
       "20                Max breadth                    Maximal breadth   \n",
       "21                Tangledness                        Tangledness   \n",
       "22          Classconnectivity                  Classconnectivity   \n",
       "23               Classfulness                       Classfulness   \n",
       "24            Classimportance                    Classimportance   \n",
       "25   Classinheritancerichness           Classinheritancerichness   \n",
       "26           Classreadability                   Classreadability   \n",
       "27  Classrelationshiprichness          Classrelationshiprichness   \n",
       "28         Classchildrencount                 Classchildrencount   \n",
       "29        Classinstancescount                Classinstancescount   \n",
       "30       Classpropertiescount               Classpropertiescount   \n",
       "\n",
       "                                  evaluation_criteria MatOnto_x MatOnto_y  \n",
       "0                                                None       631       631  \n",
       "1                                                None       226       226  \n",
       "2                                                None        81        81  \n",
       "3                                                None        35        35  \n",
       "4                                                None         5         5  \n",
       "5                                                None       264       264  \n",
       "6                                                None  ALCIQ(D)  ALCIQ(D)  \n",
       "7                                                 NaN  0.061728  0.061728  \n",
       "8          low => vertical&#10;high => orizontal&#10;  1.814815  1.814815  \n",
       "9   low => less information&#10;High => more infor...  0.209677  0.209677  \n",
       "10  low (near 0) => poor axiomatisation&#10;Higher...  7.790123  7.790123  \n",
       "11                                                NaN       0.0       0.0  \n",
       "12  Low values (i.e near 0) indicate an ontology w...  0.435484  0.435484  \n",
       "13  The interpretation of NoR values depends on th...         5         5  \n",
       "14  The interpretation of NoL values depends on th...        19        19  \n",
       "15                                                NaN        51        51  \n",
       "16  The interpretation of the values depends on th...      2.04      2.04  \n",
       "17  The interpretation of max depth is similar to ...         3         3  \n",
       "18                                                NaN        25        25  \n",
       "19  The value should be interpreted relatively to ...  3.571429  3.571429  \n",
       "20  The value should be interpreted relatively to ...         6         6  \n",
       "21  Values for tangledness range from 0 (i.e. no t...       0.0       0.0  \n",
       "22                                                NaN       NaN       NaN  \n",
       "23                                                NaN       NaN       NaN  \n",
       "24                                                NaN       NaN       NaN  \n",
       "25                                                NaN       NaN       NaN  \n",
       "26                                                NaN       NaN       NaN  \n",
       "27                                                NaN       NaN       NaN  \n",
       "28                                                NaN       NaN       NaN  \n",
       "29                                                NaN       NaN       NaN  \n",
       "30                                                NaN       NaN       NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_metrics_table = add_metrics(df_metrics_table, df_)\n",
    "\n",
    "    \n",
    "\n",
    "df_metrics_table.drop([\"metric_code\"], axis=1, inplace=True)\n",
    "\n",
    "df_metrics_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ontology IRI: https://w3id.org/pmd/co\n",
      "Number of neither defined nor imported classes: <built-in method count of ResultRow object at 0x00000298D94CB200>\n",
      "Number of imported classes: <built-in method count of ResultRow object at 0x00000298D9588400>\n"
     ]
    }
   ],
   "source": [
    "from rdflib import Graph, OWL\n",
    "\n",
    "# Initialize graph\n",
    "g = Graph()\n",
    "\n",
    "# Parse the Turtle file\n",
    "g.parse(\"all_files/PMDCO.ttl\", format=\"turtle\")\n",
    "\n",
    "# Query to find the ontology IRI\n",
    "qres1 = g.query(\n",
    "    \"\"\"SELECT ?ontologyIRI WHERE {\n",
    "       ?ontologyIRI a <http://www.w3.org/2002/07/owl#Ontology> .\n",
    "    }\"\"\"\n",
    ")\n",
    "\n",
    "# Get the first ontology IRI (assuming there's only one)\n",
    "ontologyIRI = [row.ontologyIRI for row in qres1][0]\n",
    "\n",
    "# Print the ontology IRI\n",
    "print(f\"Ontology IRI: {ontologyIRI}\")\n",
    "\n",
    "# Query to count the number of classes that are neither imported nor defined in another ontology\n",
    "qres2 = g.query(\n",
    "    \"\"\"SELECT (COUNT(?class) AS ?count) WHERE {\n",
    "       ?class a <http://www.w3.org/2002/07/owl#Class> .\n",
    "       MINUS {\n",
    "         ?class <http://www.w3.org/2000/01/rdf-schema#isDefinedBy> ?otherOntology .\n",
    "       }\n",
    "       FILTER NOT EXISTS {\n",
    "         ?class <http://www.w3.org/2002/07/owl#imports> ?anotherOntology .\n",
    "       }\n",
    "    }\"\"\"\n",
    ")\n",
    "\n",
    "for row in qres2:\n",
    "    print(f\"Number of neither defined nor imported classes: {row.count}\")\n",
    "\n",
    "# Query to count the number of imported classes from another ontology\n",
    "qres3 = g.query(\n",
    "    f\"\"\"\n",
    "PREFIX owl: <http://www.w3.org/2002/07/owl#>\n",
    "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\n",
    "\n",
    "SELECT (COUNT(DISTINCT ?class) AS ?count) WHERE {{\n",
    "  ?class a owl:Class .\n",
    "  \n",
    "  # Filter out classes that are sub- or superclasses\n",
    "  FILTER NOT EXISTS {{ ?class rdfs:subClassOf ?super . }}\n",
    "  FILTER NOT EXISTS {{ ?sub rdfs:subClassOf ?class . }}\n",
    "  \n",
    "  # Filter out classes that are equivalent to another class\n",
    "  FILTER NOT EXISTS {{ ?class owl:equivalentClass ?equivalent . }}\n",
    "  \n",
    "  FILTER(!strstarts(str(?class), \"{ontologyIRI}\"))\n",
    "}}\"\"\"\n",
    ")\n",
    "\n",
    "for row in qres3:\n",
    "    print(f\"Number of imported classes: {row.count}\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.11 64-bit (microsoft store)",
   "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.11"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "372ad118f81acd4222add26895f13bc27a937b9d5021100e967f342fe93795e5"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}