PyODAM_demo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### import the PyODAM module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from PyODAM import Odam"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Using the API"
   ]
  },
  {
   "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>index</th>\n",
       "      <th>LinkID</th>\n",
       "      <th>Subset</th>\n",
       "      <th>Identifier</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>plants</td>\n",
       "      <td>PlantID</td>\n",
       "      <td>Plant features</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>samples</td>\n",
       "      <td>SampleID</td>\n",
       "      <td>Sample features</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>aliquots</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Aliquots features</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>cellwall_metabo</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Cell wall Compound quantifications</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>cellwall_metaboFW</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Cell Wall Compound quantifications (FW)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>activome</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Activome Features</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>pools</td>\n",
       "      <td>PoolID</td>\n",
       "      <td>Pools of remaining pools</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>qMS_metabo</td>\n",
       "      <td>PoolID</td>\n",
       "      <td>MS Compounds quantification</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>qNMR_metabo</td>\n",
       "      <td>PoolID</td>\n",
       "      <td>NMR Compounds quantification</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>plato_hexosesP</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Hexoses Phosphate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>lipids_AG</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Lipids AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>AminoAcid</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Amino Acids</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index  LinkID             Subset Identifier  \\\n",
       "0       1       0             plants    PlantID   \n",
       "1       2       1            samples   SampleID   \n",
       "2       3       2           aliquots  AliquotID   \n",
       "3       4       3    cellwall_metabo  AliquotID   \n",
       "4       5       3  cellwall_metaboFW  AliquotID   \n",
       "5       6       3           activome  AliquotID   \n",
       "6       7       2              pools     PoolID   \n",
       "7       8       7         qMS_metabo     PoolID   \n",
       "8       9       7        qNMR_metabo     PoolID   \n",
       "9      10       3     plato_hexosesP  AliquotID   \n",
       "10     11       3          lipids_AG  AliquotID   \n",
       "11     12       3          AminoAcid  AliquotID   \n",
       "\n",
       "                                Description  \n",
       "0                            Plant features  \n",
       "1                           Sample features  \n",
       "2                         Aliquots features  \n",
       "3        Cell wall Compound quantifications  \n",
       "4   Cell Wall Compound quantifications (FW)  \n",
       "5                         Activome Features  \n",
       "6                  Pools of remaining pools  \n",
       "7               MS Compounds quantification  \n",
       "8              NMR Compounds quantification  \n",
       "9                         Hexoses Phosphate  \n",
       "10                                Lipids AG  \n",
       "11                              Amino Acids  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the subset list of a dataset\n",
    "po = Odam('https://pmb-bordeaux.fr','frim1')\n",
    "meta = po.getDataFromODAM()\n",
    "meta[['index', 'LinkID','Subset','Identifier', 'Description']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['index', 'PlantID', 'Rank', 'PlantNum', 'Treatment', 'SampleID',\n",
       "       'Truss', 'DevStage', 'FruitAge', 'HarvestDate', 'HarvestHour',\n",
       "       'FruitPosition', 'FruitDiameter', 'FruitHeight', 'FruitFW', 'FruitDW',\n",
       "       'DW', 'AliquotID', 'PGM', 'cFBPase', 'PyrK', 'CitS', 'PFP', 'Aconitase',\n",
       "       'PFK', 'FruK', 'pFBPase', 'GluK', 'NAD_ISODH', 'Enolase', 'NADP_ISODH',\n",
       "       'PEPC', 'Aldolase', 'Succ_CoA_ligase', 'NAD_MalDH', 'AlaAT', 'Fumarase',\n",
       "       'AspAT', 'NADP_GluDH', 'NAD_GAPDH', 'NADP_GAPDH', 'NAD_GluDH', 'TPI',\n",
       "       'PGK', 'Neutral_Inv', 'Acid_Inv', 'G6PDH', 'UGPase', 'SuSy', 'NAD_ME',\n",
       "       'ShiDH', 'NADP_ME', 'PGI', 'StarchS', 'AGPase', 'SPS', 'PoolID',\n",
       "       'glucose', 'saccharose', 'fructose', 'galactose', 'mannose', 'rhamnose',\n",
       "       'acetate', 'chlorogenate', 'citrate', 'fumarate', 'galacturonate',\n",
       "       'malate', 'quinate', 'alanine', 'asparagine', 'aspartate', 'GABA',\n",
       "       'glutamine', 'glutamate', 'isoleucine', 'phenylalanine', 'tryptophane',\n",
       "       'tyrosine', 'valine', 'pyroglutamate', 'trigonelline', 'choline',\n",
       "       'inositol'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get all values of a merged data subsets ( both activome & qNMR_metabofor) the specific 'sample' entry equal to 365\n",
    "subset = 'activome,qNMR_metabo'\n",
    "df = po.getSubsetFromODAM(subset,'sample/365?limit=10')\n",
    "data = df['data']\n",
    "\n",
    "# View all merged subset columns\n",
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>PlantID</th>\n",
       "      <th>Rank</th>\n",
       "      <th>PlantNum</th>\n",
       "      <th>Treatment</th>\n",
       "      <th>SampleID</th>\n",
       "      <th>Truss</th>\n",
       "      <th>DevStage</th>\n",
       "      <th>FruitAge</th>\n",
       "      <th>HarvestDate</th>\n",
       "      <th>...</th>\n",
       "      <th>glutamate</th>\n",
       "      <th>isoleucine</th>\n",
       "      <th>phenylalanine</th>\n",
       "      <th>tryptophane</th>\n",
       "      <th>tyrosine</th>\n",
       "      <th>valine</th>\n",
       "      <th>pyroglutamate</th>\n",
       "      <th>trigonelline</th>\n",
       "      <th>choline</th>\n",
       "      <th>inositol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>A17</td>\n",
       "      <td>A</td>\n",
       "      <td>17</td>\n",
       "      <td>Control</td>\n",
       "      <td>365</td>\n",
       "      <td>T6</td>\n",
       "      <td>FR.02</td>\n",
       "      <td>47DPA</td>\n",
       "      <td>09/02/2010</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>A8</td>\n",
       "      <td>A</td>\n",
       "      <td>8</td>\n",
       "      <td>Control</td>\n",
       "      <td>365</td>\n",
       "      <td>T6</td>\n",
       "      <td>FR.02</td>\n",
       "      <td>47DPA</td>\n",
       "      <td>09/02/2010</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>D3</td>\n",
       "      <td>D</td>\n",
       "      <td>210</td>\n",
       "      <td>Control</td>\n",
       "      <td>365</td>\n",
       "      <td>T6</td>\n",
       "      <td>FR.02</td>\n",
       "      <td>47DPA</td>\n",
       "      <td>09/02/2010</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>E35</td>\n",
       "      <td>E</td>\n",
       "      <td>311</td>\n",
       "      <td>Control</td>\n",
       "      <td>365</td>\n",
       "      <td>T6</td>\n",
       "      <td>FR.02</td>\n",
       "      <td>47DPA</td>\n",
       "      <td>09/02/2010</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>H11</td>\n",
       "      <td>H</td>\n",
       "      <td>356</td>\n",
       "      <td>Control</td>\n",
       "      <td>365</td>\n",
       "      <td>T6</td>\n",
       "      <td>FR.02</td>\n",
       "      <td>47DPA</td>\n",
       "      <td>09/02/2010</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 85 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   index PlantID Rank  PlantNum Treatment  SampleID Truss DevStage FruitAge  \\\n",
       "0      1     A17    A        17   Control       365    T6    FR.02    47DPA   \n",
       "1      2      A8    A         8   Control       365    T6    FR.02    47DPA   \n",
       "2      3      D3    D       210   Control       365    T6    FR.02    47DPA   \n",
       "3      4     E35    E       311   Control       365    T6    FR.02    47DPA   \n",
       "4      5     H11    H       356   Control       365    T6    FR.02    47DPA   \n",
       "\n",
       "  HarvestDate  ...  glutamate  isoleucine  phenylalanine  tryptophane  \\\n",
       "0  09/02/2010  ...  45.478818    2.750447       5.153496     0.345287   \n",
       "1  09/02/2010  ...  45.478818    2.750447       5.153496     0.345287   \n",
       "2  09/02/2010  ...  45.478818    2.750447       5.153496     0.345287   \n",
       "3  09/02/2010  ...  45.478818    2.750447       5.153496     0.345287   \n",
       "4  09/02/2010  ...  45.478818    2.750447       5.153496     0.345287   \n",
       "\n",
       "   tyrosine    valine  pyroglutamate  trigonelline   choline   inositol  \n",
       "0  1.624778  1.372135      24.046419      1.078428  5.936098  65.898711  \n",
       "1  1.624778  1.372135      24.046419      1.078428  5.936098  65.898711  \n",
       "2  1.624778  1.372135      24.046419      1.078428  5.936098  65.898711  \n",
       "3  1.624778  1.372135      24.046419      1.078428  5.936098  65.898711  \n",
       "4  1.624778  1.372135      24.046419      1.078428  5.936098  65.898711  \n",
       "\n",
       "[5 rows x 85 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert both data and time in MS Excel format into String\n",
    "data.HarvestDate = po.convertDateToStr(data.HarvestDate)\n",
    "data.HarvestHour = po.convertTimeToStr(data.HarvestHour)\n",
    "data"
   ]
  },
  {
   "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>index</th>\n",
       "      <th>Subset</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Description</th>\n",
       "      <th>Type</th>\n",
       "      <th>CV_Term_ID</th>\n",
       "      <th>CV_Term_Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>plants</td>\n",
       "      <td>Treatment</td>\n",
       "      <td>Treatment applied on plants</td>\n",
       "      <td>string</td>\n",
       "      <td>http://www.ebi.ac.uk/efo/EFO_0000469</td>\n",
       "      <td>environmental factor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>samples</td>\n",
       "      <td>DevStage</td>\n",
       "      <td>fruit development stage</td>\n",
       "      <td>string</td>\n",
       "      <td>http://purl.obolibrary.org/obo/PO_0001002</td>\n",
       "      <td>fruit development stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>samples</td>\n",
       "      <td>FruitAge</td>\n",
       "      <td>fruit age (dpa)</td>\n",
       "      <td>string</td>\n",
       "      <td>http://purl.obolibrary.org/obo/PO_0001002</td>\n",
       "      <td>fruit development stage</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index   Subset  Attribute                  Description    Type  \\\n",
       "0      1   plants  Treatment  Treatment applied on plants  string   \n",
       "1      2  samples   DevStage      fruit development stage  string   \n",
       "2      3  samples   FruitAge              fruit age (dpa)  string   \n",
       "\n",
       "                                  CV_Term_ID             CV_Term_Name  \n",
       "0       http://www.ebi.ac.uk/efo/EFO_0000469     environmental factor  \n",
       "1  http://purl.obolibrary.org/obo/PO_0001002  fruit development stage  \n",
       "2  http://purl.obolibrary.org/obo/PO_0001002  fruit development stage  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Display the variable list within the 'factor' category of a merged data subset\n",
    "df['factor']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>index</th>\n",
       "      <th>Subset</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Description</th>\n",
       "      <th>Type</th>\n",
       "      <th>CV_Term_ID</th>\n",
       "      <th>CV_Term_Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>plants</td>\n",
       "      <td>PlantID</td>\n",
       "      <td>Plant identifier</td>\n",
       "      <td>string</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>samples</td>\n",
       "      <td>SampleID</td>\n",
       "      <td>Pool of several harvests</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>aliquots</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Aliquot Identifier</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>activome</td>\n",
       "      <td>AliquotID</td>\n",
       "      <td>Aliquot Identifier</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>pools</td>\n",
       "      <td>PoolID</td>\n",
       "      <td>Pool of several samples</td>\n",
       "      <td>string</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>qNMR_metabo</td>\n",
       "      <td>PoolID</td>\n",
       "      <td>Pool of several samples</td>\n",
       "      <td>string</td>\n",
       "      <td>http://edamontology.org/data_0842</td>\n",
       "      <td>identifier</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index       Subset  Attribute               Description     Type  \\\n",
       "0      1       plants    PlantID          Plant identifier   string   \n",
       "1      2      samples   SampleID  Pool of several harvests  numeric   \n",
       "2      3     aliquots  AliquotID        Aliquot Identifier  numeric   \n",
       "3      4     activome  AliquotID        Aliquot Identifier  numeric   \n",
       "4      5        pools     PoolID   Pool of several samples   string   \n",
       "5      6  qNMR_metabo     PoolID   Pool of several samples   string   \n",
       "\n",
       "                          CV_Term_ID CV_Term_Name  \n",
       "0  http://edamontology.org/data_0842   identifier  \n",
       "1  http://edamontology.org/data_0842   identifier  \n",
       "2  http://edamontology.org/data_0842   identifier  \n",
       "3  http://edamontology.org/data_0842   identifier  \n",
       "4  http://edamontology.org/data_0842   identifier  \n",
       "5  http://edamontology.org/data_0842   identifier  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Display the variable list within the 'identifier' category of a merged data subset\n",
    "df['identifier']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>index</th>\n",
       "      <th>Subset</th>\n",
       "      <th>Attribute</th>\n",
       "      <th>Description</th>\n",
       "      <th>Type</th>\n",
       "      <th>CV_Term_ID</th>\n",
       "      <th>CV_Term_Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>samples</td>\n",
       "      <td>FruitDiameter</td>\n",
       "      <td>Fruit diameter (mm)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://aims.fao.org/aos/agrovoc/c_16072</td>\n",
       "      <td>Diameter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>samples</td>\n",
       "      <td>FruitHeight</td>\n",
       "      <td>Fruit height (mm)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://aims.fao.org/aos/agrovoc/c_3536</td>\n",
       "      <td>Height</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>samples</td>\n",
       "      <td>FruitFW</td>\n",
       "      <td>Fruit Fresh Weight(g)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://aims.fao.org/aos/agrovoc/c_8349</td>\n",
       "      <td>Weight</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>samples</td>\n",
       "      <td>FruitDW</td>\n",
       "      <td>Fruit Dry Weight(g)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://aims.fao.org/aos/agrovoc/c_8349</td>\n",
       "      <td>Weight</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>samples</td>\n",
       "      <td>DW</td>\n",
       "      <td>Percentage of dry matter (% DW), measured afte...</td>\n",
       "      <td>numeric</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>activome</td>\n",
       "      <td>PGM</td>\n",
       "      <td>Phosphoglucomutase (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_0004614</td>\n",
       "      <td>EC 5.4.2.2 Phosphoglucomutase</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>activome</td>\n",
       "      <td>cFBPase</td>\n",
       "      <td>cytosolic Fru-1,6-bisphosphatase (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_0042132</td>\n",
       "      <td>EC 3.1.3.11 fructose-bisphosphatase</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>activome</td>\n",
       "      <td>PyrK</td>\n",
       "      <td>Pyruvate Kinase (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_0004743</td>\n",
       "      <td>EC 2.7.1.40 pyruvate kinase</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>activome</td>\n",
       "      <td>CitS</td>\n",
       "      <td>Citrate Synthase Total (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_0036440</td>\n",
       "      <td>EC 2.3.3.1 citrate synthase</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>activome</td>\n",
       "      <td>PFP</td>\n",
       "      <td>6-phosphofructokinase (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_0047334</td>\n",
       "      <td>EC 2.7.1.90 6-phosphofructokinase</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>activome</td>\n",
       "      <td>Aconitase</td>\n",
       "      <td>Aconitase (nmol/gFW/min)</td>\n",
       "      <td>numeric</td>\n",
       "      <td>http://purl.obolibrary.org/obo/GO_000394</td>\n",
       "      <td>EC 4.2.1.3 Aconitase</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index    Subset      Attribute  \\\n",
       "0       1   samples  FruitDiameter   \n",
       "1       2   samples    FruitHeight   \n",
       "2       3   samples        FruitFW   \n",
       "3       4   samples        FruitDW   \n",
       "4       5   samples             DW   \n",
       "5       6  activome            PGM   \n",
       "6       7  activome        cFBPase   \n",
       "7       8  activome           PyrK   \n",
       "8       9  activome           CitS   \n",
       "9      10  activome            PFP   \n",
       "10     11  activome      Aconitase   \n",
       "\n",
       "                                          Description     Type  \\\n",
       "0                                 Fruit diameter (mm)  numeric   \n",
       "1                                   Fruit height (mm)  numeric   \n",
       "2                               Fruit Fresh Weight(g)  numeric   \n",
       "3                                 Fruit Dry Weight(g)  numeric   \n",
       "4   Percentage of dry matter (% DW), measured afte...  numeric   \n",
       "5                   Phosphoglucomutase (nmol/gFW/min)  numeric   \n",
       "6     cytosolic Fru-1,6-bisphosphatase (nmol/gFW/min)  numeric   \n",
       "7                      Pyruvate Kinase (nmol/gFW/min)  numeric   \n",
       "8               Citrate Synthase Total (nmol/gFW/min)  numeric   \n",
       "9                6-phosphofructokinase (nmol/gFW/min)  numeric   \n",
       "10                           Aconitase (nmol/gFW/min)  numeric   \n",
       "\n",
       "                                   CV_Term_ID  \\\n",
       "0     http://aims.fao.org/aos/agrovoc/c_16072   \n",
       "1      http://aims.fao.org/aos/agrovoc/c_3536   \n",
       "2      http://aims.fao.org/aos/agrovoc/c_8349   \n",
       "3      http://aims.fao.org/aos/agrovoc/c_8349   \n",
       "4                                               \n",
       "5   http://purl.obolibrary.org/obo/GO_0004614   \n",
       "6   http://purl.obolibrary.org/obo/GO_0042132   \n",
       "7   http://purl.obolibrary.org/obo/GO_0004743   \n",
       "8   http://purl.obolibrary.org/obo/GO_0036440   \n",
       "9   http://purl.obolibrary.org/obo/GO_0047334   \n",
       "10   http://purl.obolibrary.org/obo/GO_000394   \n",
       "\n",
       "                           CV_Term_Name  \n",
       "0                              Diameter  \n",
       "1                                Height  \n",
       "2                                Weight  \n",
       "3                                Weight  \n",
       "4                                        \n",
       "5         EC 5.4.2.2 Phosphoglucomutase  \n",
       "6   EC 3.1.3.11 fructose-bisphosphatase  \n",
       "7           EC 2.7.1.40 pyruvate kinase  \n",
       "8           EC 2.3.3.1 citrate synthase  \n",
       "9     EC 2.7.1.90 6-phosphofructokinase  \n",
       "10                 EC 4.2.1.3 Aconitase  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Display the variable list within the 'quantitative' category of a merged data subset\n",
    "quantitative = df['quantitative']\n",
    "quantitative.loc[ 0:10, ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>PGM</th>\n",
       "      <th>cFBPase</th>\n",
       "      <th>PyrK</th>\n",
       "      <th>CitS</th>\n",
       "      <th>PFP</th>\n",
       "      <th>Aconitase</th>\n",
       "      <th>PFK</th>\n",
       "      <th>FruK</th>\n",
       "      <th>pFBPase</th>\n",
       "      <th>GluK</th>\n",
       "      <th>...</th>\n",
       "      <th>G6PDH</th>\n",
       "      <th>UGPase</th>\n",
       "      <th>SuSy</th>\n",
       "      <th>NAD_ME</th>\n",
       "      <th>ShiDH</th>\n",
       "      <th>NADP_ME</th>\n",
       "      <th>PGI</th>\n",
       "      <th>StarchS</th>\n",
       "      <th>AGPase</th>\n",
       "      <th>SPS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>NA</td>\n",
       "      <td>10.92</td>\n",
       "      <td>304.68</td>\n",
       "      <td>6.12</td>\n",
       "      <td>576.56</td>\n",
       "      <td>145.05</td>\n",
       "      <td>73.97</td>\n",
       "      <td>73.88</td>\n",
       "      <td>44.38</td>\n",
       "      <td>26.46</td>\n",
       "      <td>...</td>\n",
       "      <td>109.01</td>\n",
       "      <td>3233.62</td>\n",
       "      <td>NA</td>\n",
       "      <td>535.3</td>\n",
       "      <td>67.44</td>\n",
       "      <td>219.78</td>\n",
       "      <td>384.85</td>\n",
       "      <td>77.01</td>\n",
       "      <td>80.18</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>NA</td>\n",
       "      <td>10.92</td>\n",
       "      <td>304.68</td>\n",
       "      <td>6.12</td>\n",
       "      <td>576.56</td>\n",
       "      <td>145.05</td>\n",
       "      <td>73.97</td>\n",
       "      <td>73.88</td>\n",
       "      <td>44.38</td>\n",
       "      <td>26.46</td>\n",
       "      <td>...</td>\n",
       "      <td>109.01</td>\n",
       "      <td>3233.62</td>\n",
       "      <td>NA</td>\n",
       "      <td>535.3</td>\n",
       "      <td>67.44</td>\n",
       "      <td>219.78</td>\n",
       "      <td>384.85</td>\n",
       "      <td>77.01</td>\n",
       "      <td>80.18</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>NA</td>\n",
       "      <td>10.92</td>\n",
       "      <td>304.68</td>\n",
       "      <td>6.12</td>\n",
       "      <td>576.56</td>\n",
       "      <td>145.05</td>\n",
       "      <td>73.97</td>\n",
       "      <td>73.88</td>\n",
       "      <td>44.38</td>\n",
       "      <td>26.46</td>\n",
       "      <td>...</td>\n",
       "      <td>109.01</td>\n",
       "      <td>3233.62</td>\n",
       "      <td>NA</td>\n",
       "      <td>535.3</td>\n",
       "      <td>67.44</td>\n",
       "      <td>219.78</td>\n",
       "      <td>384.85</td>\n",
       "      <td>77.01</td>\n",
       "      <td>80.18</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>NA</td>\n",
       "      <td>10.92</td>\n",
       "      <td>304.68</td>\n",
       "      <td>6.12</td>\n",
       "      <td>576.56</td>\n",
       "      <td>145.05</td>\n",
       "      <td>73.97</td>\n",
       "      <td>73.88</td>\n",
       "      <td>44.38</td>\n",
       "      <td>26.46</td>\n",
       "      <td>...</td>\n",
       "      <td>109.01</td>\n",
       "      <td>3233.62</td>\n",
       "      <td>NA</td>\n",
       "      <td>535.3</td>\n",
       "      <td>67.44</td>\n",
       "      <td>219.78</td>\n",
       "      <td>384.85</td>\n",
       "      <td>77.01</td>\n",
       "      <td>80.18</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>NA</td>\n",
       "      <td>10.92</td>\n",
       "      <td>304.68</td>\n",
       "      <td>6.12</td>\n",
       "      <td>576.56</td>\n",
       "      <td>145.05</td>\n",
       "      <td>73.97</td>\n",
       "      <td>73.88</td>\n",
       "      <td>44.38</td>\n",
       "      <td>26.46</td>\n",
       "      <td>...</td>\n",
       "      <td>109.01</td>\n",
       "      <td>3233.62</td>\n",
       "      <td>NA</td>\n",
       "      <td>535.3</td>\n",
       "      <td>67.44</td>\n",
       "      <td>219.78</td>\n",
       "      <td>384.85</td>\n",
       "      <td>77.01</td>\n",
       "      <td>80.18</td>\n",
       "      <td>64.33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  PGM  cFBPase    PyrK  CitS     PFP  Aconitase    PFK   FruK  pFBPase   GluK  \\\n",
       "0  NA    10.92  304.68  6.12  576.56     145.05  73.97  73.88    44.38  26.46   \n",
       "1  NA    10.92  304.68  6.12  576.56     145.05  73.97  73.88    44.38  26.46   \n",
       "2  NA    10.92  304.68  6.12  576.56     145.05  73.97  73.88    44.38  26.46   \n",
       "3  NA    10.92  304.68  6.12  576.56     145.05  73.97  73.88    44.38  26.46   \n",
       "4  NA    10.92  304.68  6.12  576.56     145.05  73.97  73.88    44.38  26.46   \n",
       "\n",
       "   ...   G6PDH   UGPase  SuSy  NAD_ME  ShiDH  NADP_ME     PGI  StarchS AGPase  \\\n",
       "0  ...  109.01  3233.62    NA   535.3  67.44   219.78  384.85    77.01  80.18   \n",
       "1  ...  109.01  3233.62    NA   535.3  67.44   219.78  384.85    77.01  80.18   \n",
       "2  ...  109.01  3233.62    NA   535.3  67.44   219.78  384.85    77.01  80.18   \n",
       "3  ...  109.01  3233.62    NA   535.3  67.44   219.78  384.85    77.01  80.18   \n",
       "4  ...  109.01  3233.62    NA   535.3  67.44   219.78  384.85    77.01  80.18   \n",
       "\n",
       "     SPS  \n",
       "0  64.33  \n",
       "1  64.33  \n",
       "2  64.33  \n",
       "3  64.33  \n",
       "4  64.33  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Select the variables from the merged data belongings to the 'activome' data subset\n",
    "data[quantitative[quantitative.Subset=='activome']['Attribute']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>glucose</th>\n",
       "      <th>saccharose</th>\n",
       "      <th>fructose</th>\n",
       "      <th>galactose</th>\n",
       "      <th>mannose</th>\n",
       "      <th>rhamnose</th>\n",
       "      <th>acetate</th>\n",
       "      <th>chlorogenate</th>\n",
       "      <th>citrate</th>\n",
       "      <th>fumarate</th>\n",
       "      <th>...</th>\n",
       "      <th>glutamate</th>\n",
       "      <th>isoleucine</th>\n",
       "      <th>phenylalanine</th>\n",
       "      <th>tryptophane</th>\n",
       "      <th>tyrosine</th>\n",
       "      <th>valine</th>\n",
       "      <th>pyroglutamate</th>\n",
       "      <th>trigonelline</th>\n",
       "      <th>choline</th>\n",
       "      <th>inositol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>756.688509</td>\n",
       "      <td>33.907515</td>\n",
       "      <td>975.485366</td>\n",
       "      <td>1.544911</td>\n",
       "      <td>4.150709</td>\n",
       "      <td>4.02276</td>\n",
       "      <td>4.296019</td>\n",
       "      <td>2.428279</td>\n",
       "      <td>182.777927</td>\n",
       "      <td>0.079999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>756.688509</td>\n",
       "      <td>33.907515</td>\n",
       "      <td>975.485366</td>\n",
       "      <td>1.544911</td>\n",
       "      <td>4.150709</td>\n",
       "      <td>4.02276</td>\n",
       "      <td>4.296019</td>\n",
       "      <td>2.428279</td>\n",
       "      <td>182.777927</td>\n",
       "      <td>0.079999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>756.688509</td>\n",
       "      <td>33.907515</td>\n",
       "      <td>975.485366</td>\n",
       "      <td>1.544911</td>\n",
       "      <td>4.150709</td>\n",
       "      <td>4.02276</td>\n",
       "      <td>4.296019</td>\n",
       "      <td>2.428279</td>\n",
       "      <td>182.777927</td>\n",
       "      <td>0.079999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>756.688509</td>\n",
       "      <td>33.907515</td>\n",
       "      <td>975.485366</td>\n",
       "      <td>1.544911</td>\n",
       "      <td>4.150709</td>\n",
       "      <td>4.02276</td>\n",
       "      <td>4.296019</td>\n",
       "      <td>2.428279</td>\n",
       "      <td>182.777927</td>\n",
       "      <td>0.079999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>756.688509</td>\n",
       "      <td>33.907515</td>\n",
       "      <td>975.485366</td>\n",
       "      <td>1.544911</td>\n",
       "      <td>4.150709</td>\n",
       "      <td>4.02276</td>\n",
       "      <td>4.296019</td>\n",
       "      <td>2.428279</td>\n",
       "      <td>182.777927</td>\n",
       "      <td>0.079999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.478818</td>\n",
       "      <td>2.750447</td>\n",
       "      <td>5.153496</td>\n",
       "      <td>0.345287</td>\n",
       "      <td>1.624778</td>\n",
       "      <td>1.372135</td>\n",
       "      <td>24.046419</td>\n",
       "      <td>1.078428</td>\n",
       "      <td>5.936098</td>\n",
       "      <td>65.898711</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      glucose  saccharose    fructose  galactose   mannose  rhamnose  \\\n",
       "0  756.688509   33.907515  975.485366   1.544911  4.150709   4.02276   \n",
       "1  756.688509   33.907515  975.485366   1.544911  4.150709   4.02276   \n",
       "2  756.688509   33.907515  975.485366   1.544911  4.150709   4.02276   \n",
       "3  756.688509   33.907515  975.485366   1.544911  4.150709   4.02276   \n",
       "4  756.688509   33.907515  975.485366   1.544911  4.150709   4.02276   \n",
       "\n",
       "    acetate  chlorogenate     citrate  fumarate  ...  glutamate  isoleucine  \\\n",
       "0  4.296019      2.428279  182.777927  0.079999  ...  45.478818    2.750447   \n",
       "1  4.296019      2.428279  182.777927  0.079999  ...  45.478818    2.750447   \n",
       "2  4.296019      2.428279  182.777927  0.079999  ...  45.478818    2.750447   \n",
       "3  4.296019      2.428279  182.777927  0.079999  ...  45.478818    2.750447   \n",
       "4  4.296019      2.428279  182.777927  0.079999  ...  45.478818    2.750447   \n",
       "\n",
       "   phenylalanine  tryptophane  tyrosine    valine  pyroglutamate  \\\n",
       "0       5.153496     0.345287  1.624778  1.372135      24.046419   \n",
       "1       5.153496     0.345287  1.624778  1.372135      24.046419   \n",
       "2       5.153496     0.345287  1.624778  1.372135      24.046419   \n",
       "3       5.153496     0.345287  1.624778  1.372135      24.046419   \n",
       "4       5.153496     0.345287  1.624778  1.372135      24.046419   \n",
       "\n",
       "   trigonelline   choline   inositol  \n",
       "0      1.078428  5.936098  65.898711  \n",
       "1      1.078428  5.936098  65.898711  \n",
       "2      1.078428  5.936098  65.898711  \n",
       "3      1.078428  5.936098  65.898711  \n",
       "4      1.078428  5.936098  65.898711  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Select the variables from the merged data belongings to the 'qNMR_metabo' data subset\n",
    "data[quantitative[quantitative.Subset=='qNMR_metabo']['Attribute']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 0ct, 4 2019  - Daniel Jacob INRA UMR 1332 - MetaboHub Bordeaux"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernel_info": {
   "name": "python3"
  },
  "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.7.4"
  },
  "nteract": {
   "version": "0.15.0"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}