{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "GlassPy: loading data\n",
    "=====================\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Introduction\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "GlassPy can load experimental data in its subpackage `glasspy.data`. Currently, GlassPy has the SciGlass database as an available data source.\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Basic usage\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Below is a minimal example of loading SciGlass data into a `pandas` DataFrame. This loads the SciGlass data with the default configuration. This means that you will load most of the available data and metadata.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from glasspy.data import SciGlass, sciglass_dbinfo\n",
    "\n",
    "source = SciGlass()\n",
    "df = source.data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It takes a while to run this cell, but after it loads all the data, we can check what we have.\n",
    "\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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">elements</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"5\" halign=\"left\">property</th>\n",
       "      <th colspan=\"5\" halign=\"left\">metadata</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>H</th>\n",
       "      <th>Li</th>\n",
       "      <th>Be</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>O</th>\n",
       "      <th>F</th>\n",
       "      <th>Na</th>\n",
       "      <th>Mg</th>\n",
       "      <th>...</th>\n",
       "      <th>SurfaceTensionAboveTg</th>\n",
       "      <th>SurfaceTension1173K</th>\n",
       "      <th>SurfaceTension1473K</th>\n",
       "      <th>SurfaceTension1573K</th>\n",
       "      <th>SurfaceTension1673K</th>\n",
       "      <th>ChemicalAnalysis</th>\n",
       "      <th>Author</th>\n",
       "      <th>Year</th>\n",
       "      <th>NumberElements</th>\n",
       "      <th>NumberCompounds</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20400020000</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Volarovich M.P.</td>\n",
       "      <td>1936</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020001</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.579213</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.196815</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020002</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.580869</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.193449</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020003</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.581986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.187167</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020004</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.583672</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.183080</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611694</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.625485</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.049125</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Murata T.</td>\n",
       "      <td>2019</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611695</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001948</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.637540</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.009932</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Murata T.</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611696</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.635921</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Murata T.</td>\n",
       "      <td>2019</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611697</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014544</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.622226</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.035890</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Murata T.</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611698</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.041532</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.634462</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000487</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Murata T.</td>\n",
       "      <td>2019</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>283102 rows × 793 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              elements                                                          \n",
       "                     H   Li   Be         B    C    N         O    F        Na   \n",
       "ID                                                                              \n",
       "20400020000        0.0  0.0  0.0  0.000000  0.0  0.0  0.666667  0.0  0.000000  \\\n",
       "20500020001        0.0  0.0  0.0  0.000000  0.0  0.0  0.579213  0.0  0.196815   \n",
       "20500020002        0.0  0.0  0.0  0.000000  0.0  0.0  0.580869  0.0  0.193449   \n",
       "20500020003        0.0  0.0  0.0  0.000000  0.0  0.0  0.581986  0.0  0.187167   \n",
       "20500020004        0.0  0.0  0.0  0.000000  0.0  0.0  0.583672  0.0  0.183080   \n",
       "...                ...  ...  ...       ...  ...  ...       ...  ...       ...   \n",
       "4493300611694      0.0  0.0  0.0  0.000000  0.0  0.0  0.625485  0.0  0.000000   \n",
       "4493300611695      0.0  0.0  0.0  0.001948  0.0  0.0  0.637540  0.0  0.000000   \n",
       "4493300611696      0.0  0.0  0.0  0.000000  0.0  0.0  0.635921  0.0  0.000000   \n",
       "4493300611697      0.0  0.0  0.0  0.014544  0.0  0.0  0.622226  0.0  0.035890   \n",
       "4493300611698      0.0  0.0  0.0  0.041532  0.0  0.0  0.634462  0.0  0.000000   \n",
       "\n",
       "                         ...              property                       \n",
       "                     Mg  ... SurfaceTensionAboveTg SurfaceTension1173K   \n",
       "ID                       ...                                             \n",
       "20400020000    0.000000  ...                   NaN                 NaN  \\\n",
       "20500020001    0.000000  ...                   NaN                 NaN   \n",
       "20500020002    0.000000  ...                   NaN                 NaN   \n",
       "20500020003    0.000000  ...                   NaN                 NaN   \n",
       "20500020004    0.000000  ...                   NaN                 NaN   \n",
       "...                 ...  ...                   ...                 ...   \n",
       "4493300611694  0.049125  ...                   NaN                 NaN   \n",
       "4493300611695  0.009932  ...                   NaN                 NaN   \n",
       "4493300611696  0.000000  ...                   NaN                 NaN   \n",
       "4493300611697  0.000000  ...                   NaN                 NaN   \n",
       "4493300611698  0.000487  ...                   NaN                 NaN   \n",
       "\n",
       "                                                                            \n",
       "              SurfaceTension1473K SurfaceTension1573K SurfaceTension1673K   \n",
       "ID                                                                          \n",
       "20400020000                   NaN                 NaN                 NaN  \\\n",
       "20500020001                   NaN                 NaN                 NaN   \n",
       "20500020002                   NaN                 NaN                 NaN   \n",
       "20500020003                   NaN                 NaN                 NaN   \n",
       "20500020004                   NaN                 NaN                 NaN   \n",
       "...                           ...                 ...                 ...   \n",
       "4493300611694                 NaN                 NaN                 NaN   \n",
       "4493300611695                 NaN                 NaN                 NaN   \n",
       "4493300611696                 NaN                 NaN                 NaN   \n",
       "4493300611697                 NaN                 NaN                 NaN   \n",
       "4493300611698                 NaN                 NaN                 NaN   \n",
       "\n",
       "                      metadata                                         \n",
       "              ChemicalAnalysis           Author  Year NumberElements   \n",
       "ID                                                                     \n",
       "20400020000              False  Volarovich M.P.  1936              2  \\\n",
       "20500020001              False         Hoj J.W.  1992              5   \n",
       "20500020002              False         Hoj J.W.  1992              5   \n",
       "20500020003              False         Hoj J.W.  1992              5   \n",
       "20500020004              False         Hoj J.W.  1992              5   \n",
       "...                        ...              ...   ...            ...   \n",
       "4493300611694            False        Murata T.  2019              7   \n",
       "4493300611695            False        Murata T.  2019             10   \n",
       "4493300611696            False        Murata T.  2019              8   \n",
       "4493300611697            False        Murata T.  2019              9   \n",
       "4493300611698            False        Murata T.  2019              7   \n",
       "\n",
       "                               \n",
       "              NumberCompounds  \n",
       "ID                             \n",
       "20400020000                 1  \n",
       "20500020001                 4  \n",
       "20500020002                 4  \n",
       "20500020003                 4  \n",
       "20500020004                 4  \n",
       "...                       ...  \n",
       "4493300611694               6  \n",
       "4493300611695               9  \n",
       "4493300611696               7  \n",
       "4493300611697               8  \n",
       "4493300611698               6  \n",
       "\n",
       "[283102 rows x 793 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To avoid naming conflicts and to make it easier to navigate through the DataFrame, the data is structured in two levels. In the first level, we have information grouped by composition, property, or metadata.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['elements', 'compounds', 'property', 'metadata'], dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(df.columns.levels[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So if you want to explore the chemical elements of the data, you can just filter that part of the DataFrame.\n",
    "\n"
   ]
  },
  {
   "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>H</th>\n",
       "      <th>Li</th>\n",
       "      <th>Be</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>O</th>\n",
       "      <th>F</th>\n",
       "      <th>Na</th>\n",
       "      <th>Mg</th>\n",
       "      <th>...</th>\n",
       "      <th>W</th>\n",
       "      <th>Re</th>\n",
       "      <th>Pt</th>\n",
       "      <th>Au</th>\n",
       "      <th>Hg</th>\n",
       "      <th>Tl</th>\n",
       "      <th>Pb</th>\n",
       "      <th>Bi</th>\n",
       "      <th>Th</th>\n",
       "      <th>U</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20400020000</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020001</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.579213</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.196815</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020002</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.580869</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.193449</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020003</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.581986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.187167</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020004</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.583672</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.183080</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611694</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.625485</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.049125</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611695</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001948</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.637540</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.009932</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611696</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.635921</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611697</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014544</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.622226</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.035890</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493300611698</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.041532</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.634462</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000487</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>283102 rows × 76 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 H   Li   Be         B    C    N         O    F        Na   \n",
       "ID                                                                          \n",
       "20400020000    0.0  0.0  0.0  0.000000  0.0  0.0  0.666667  0.0  0.000000  \\\n",
       "20500020001    0.0  0.0  0.0  0.000000  0.0  0.0  0.579213  0.0  0.196815   \n",
       "20500020002    0.0  0.0  0.0  0.000000  0.0  0.0  0.580869  0.0  0.193449   \n",
       "20500020003    0.0  0.0  0.0  0.000000  0.0  0.0  0.581986  0.0  0.187167   \n",
       "20500020004    0.0  0.0  0.0  0.000000  0.0  0.0  0.583672  0.0  0.183080   \n",
       "...            ...  ...  ...       ...  ...  ...       ...  ...       ...   \n",
       "4493300611694  0.0  0.0  0.0  0.000000  0.0  0.0  0.625485  0.0  0.000000   \n",
       "4493300611695  0.0  0.0  0.0  0.001948  0.0  0.0  0.637540  0.0  0.000000   \n",
       "4493300611696  0.0  0.0  0.0  0.000000  0.0  0.0  0.635921  0.0  0.000000   \n",
       "4493300611697  0.0  0.0  0.0  0.014544  0.0  0.0  0.622226  0.0  0.035890   \n",
       "4493300611698  0.0  0.0  0.0  0.041532  0.0  0.0  0.634462  0.0  0.000000   \n",
       "\n",
       "                     Mg  ...    W   Re   Pt   Au   Hg   Tl   Pb   Bi   Th    U  \n",
       "ID                       ...                                                    \n",
       "20400020000    0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "20500020001    0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "20500020002    0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "20500020003    0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "20500020004    0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "...                 ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "4493300611694  0.049125  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "4493300611695  0.009932  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "4493300611696  0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "4493300611697  0.000000  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "4493300611698  0.000487  ...  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
       "\n",
       "[283102 rows x 76 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "els = df[\"elements\"]\n",
    "els"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The same is true if you want to explore a particular column of the DataFrame. Suppose you want to explore the glass transition temperature:\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID\n",
       "20400020000          NaN\n",
       "20500020001      1017.15\n",
       "20500020002      1096.15\n",
       "20500020003      1013.15\n",
       "20500020004      1013.15\n",
       "                  ...   \n",
       "4493300611694        NaN\n",
       "4493300611695        NaN\n",
       "4493300611696        NaN\n",
       "4493300611697        NaN\n",
       "4493300611698        NaN\n",
       "Name: Tg, Length: 283102, dtype: float64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Tg = df[\"property\"][\"Tg\"]\n",
    "Tg"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As you can see, not all entries have a value for Tg.\n",
    "\n",
    "To check for all available properties in GlassPy, run:\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "ChemicalAnalysis: Indicates if the glass composition was obtained by chemical analysis [metadata]\n",
      "Author: First author of the publication [metadata]\n",
      "Year: Year of the publication [metadata]\n",
      "T0: Temperature where viscosity is 1 Pa.s (K)\n",
      "T1: Temperature where viscosity is 10 Pa.s (K)\n",
      "T2: Temperature where viscosity is 100 Pa.s (K)\n",
      "T3: Temperature where viscosity is 1000 Pa.s (K)\n",
      "T4: Temperature where viscosity is 10000 Pa.s (K)\n",
      "T5: Temperature where viscosity is 100000 Pa.s (K)\n",
      "T6: Temperature where viscosity is 1000000 Pa.s (K)\n",
      "T7: Temperature where viscosity is 10000000 Pa.s (K)\n",
      "T8: Temperature where viscosity is 100000000 Pa.s (K)\n",
      "T9: Temperature where viscosity is 1000000000 Pa.s (K)\n",
      "T10: Temperature where viscosity is 10000000000 Pa.s (K)\n",
      "T11: Temperature where viscosity is 100000000000 Pa.s (K)\n",
      "T12: Temperature where viscosity is 1000000000000 Pa.s (K)\n",
      "Viscosity773K: Viscosity at 773 K (Pa.s)\n",
      "Viscosity873K: Viscosity at 873 K (Pa.s)\n",
      "Viscosity973K: Viscosity at 973 K (Pa.s)\n",
      "Viscosity1073K: Viscosity at 1073 K (Pa.s)\n",
      "Viscosity1173K: Viscosity at 1173 K (Pa.s)\n",
      "Viscosity1273K: Viscosity at 1273 K (Pa.s)\n",
      "Viscosity1373K: Viscosity at 1373 K (Pa.s)\n",
      "Viscosity1473K: Viscosity at 1473 K (Pa.s)\n",
      "Viscosity1573K: Viscosity at 1573 K (Pa.s)\n",
      "Viscosity1673K: Viscosity at 1673 K (Pa.s)\n",
      "Viscosity1773K: Viscosity at 1773 K (Pa.s)\n",
      "Viscosity1873K: Viscosity at 1873 K (Pa.s)\n",
      "Viscosity2073K: Viscosity at 2073 K (Pa.s)\n",
      "Viscosity2273K: Viscosity at 2273 K (Pa.s)\n",
      "Viscosity2473K: Viscosity at 2473 K (Pa.s)\n",
      "Tg: Glass transition temperature (K)\n",
      "Tmelt: Melting temperature (K)\n",
      "Tliquidus: Liquidus temperature (K)\n",
      "TLittletons: Littletons softening temperature (K)\n",
      "TAnnealing: Annealing point (K)\n",
      "Tstrain: Strain point (K)\n",
      "Tsoft: Softening point (K)\n",
      "TdilatometricSoftening: Dilatometric softening temperature (K)\n",
      "AbbeNum: Abbe's number\n",
      "RefractiveIndex: Refractive index\n",
      "RefractiveIndexLow: Refractive index measured at a wavelenght between 0.6 and 1 micron at 293 K\n",
      "RefractiveIndexHigh: Refractive index measured at a wavelenght greater than 1 micron at 293 K\n",
      "MeanDispersion: Mean dispersion (nF - nC)\n",
      "Permittivity: Relative permittivity at ambient temperature anf frequency of1 MHz (or the nearest frequency in the range of 0.01 MHz to 10 MHz)\n",
      "TangentOfLossAngle: Tangent of loss angle\n",
      "TresistivityIs1MOhm.m: Temperature where the specific electrical resistivity is 1MOhm.m (K)\n",
      "Resistivity293K: Specific electrical resistivity measured at 293 K (Ohm.m)\n",
      "Resistivity373K: Specific electrical resistivity measured at 373 K (Ohm.m)\n",
      "Resistivity423K: Specific electrical resistivity measured at 423 K (Ohm.m)\n",
      "Resistivity573K: Specific electrical resistivity measured at 573 K (Ohm.m)\n",
      "Resistivity1073K: Specific electrical resistivity measured at 1073 K (Ohm.m)\n",
      "Resistivity1273K: Specific electrical resistivity measured at 1273 K (Ohm.m)\n",
      "Resistivity1473K: Specific electrical resistivity measured at 1473 K (Ohm.m)\n",
      "Resistivity1673K: Specific electrical resistivity measured at 1673 K (Ohm.m)\n",
      "YoungModulus: Young's Modulus (GPa)\n",
      "ShearModulus: Shear Modulus (GPa)\n",
      "Microhardness: Microhardness measured by Knoop or Vickers indentation (GPa)\n",
      "PoissonRatio: Poisson's ratio\n",
      "Density293K: Density measured at 293 K (g/cm3)\n",
      "Density1073K: Density measured at 1073 K (g/cm3)\n",
      "Density1273K: Density measured at 1273 K (g/cm3)\n",
      "Density1473K: Density measured at 1473 K (g/cm3)\n",
      "Density1673K: Density measured at 1673 K (g/cm3)\n",
      "ThermalConductivity: Thermal conductivity (W/(m.K))\n",
      "ThermalShockRes: Thermal shock resistance (K)\n",
      "CTEbelowTg: Linear coefficient of thermal expansion measured below the glass transition temperature (1/K)\n",
      "CTE328K: Linear coefficient of thermal expansion measured at 328 +/- 10 K (1/K)\n",
      "CTE373K: Linear coefficient of thermal expansion measured at 373 +/- 10 K (1/K)\n",
      "CTE433K: Linear coefficient of thermal expansion measured at 433 +/- 10 K (1/K)\n",
      "CTE483K: Linear coefficient of thermal expansion measured at 483 +/- 10 K (1/K)\n",
      "CTE623K: Linear coefficient of thermal expansion measured at 623 +/- 10 K (1/K)\n",
      "Cp293K: Heat capacity at constant pressure measured at 293 K (J/(kg.K))\n",
      "Cp473K: Heat capacity at constant pressure measured at 473 K (J/(kg.K))\n",
      "Cp673K: Heat capacity at constant pressure measured at 673 K (J/(kg.K))\n",
      "Cp1073K: Heat capacity at constant pressure measured at 1073 K (J/(kg.K))\n",
      "Cp1273K: Heat capacity at constant pressure measured at 1273 K (J/(kg.K))\n",
      "Cp1473K: Heat capacity at constant pressure measured at 1473 K (J/(kg.K))\n",
      "Cp1673K: Heat capacity at constant pressure measured at 1673 K (J/(kg.K))\n",
      "NucleationTemperature: Nucleation temperature (K)\n",
      "NucleationRate: Crystal nucleation rate (1/(s.m3))\n",
      "TMaxGrowthVelocity: Temperature of maximum crystal growth velocity (K)\n",
      "MaxGrowthVelocity: Maximum crystal growth velocity (m/s)\n",
      "CrystallizationPeak: DTA temperature of crystallization peak (K)\n",
      "CrystallizationOnset: DTA temperature of crystallization onset (K)\n",
      "SurfaceTensionAboveTg: Surface tension above the glass transition temperature (J/m2)\n",
      "SurfaceTension1173K: Surface tension at 1173 K (J/m2)\n",
      "SurfaceTension1473K: Surface tension at 1473 K (J/m2)\n",
      "SurfaceTension1573K: Surface tension at 1573 K (J/m2)\n",
      "SurfaceTension1673K: Surface tension at 1673 K (J/m2)\n"
     ]
    }
   ],
   "source": [
    "sciglass_dbinfo()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "See the `pandas` [documentation](https://pandas.pydata.org/docs/) if you are not familiar with how to use a `pandas` DataFrame.\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Controlling the initial data collection\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It takes a while to load all the SciGlass data. It is wise to load only what you will actually use. You can control what you load by passing your configuration as dictionaries to the `SciGlass` class.\n",
    "\n",
    "For example, say you don&rsquo;t want glasses with silver or gold in their composition, you are only interested in the glass transition temperature, and you don&rsquo;t want information about the compounds that make up the glass. You can run this query like this:\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_properties_except_Tg = SciGlass.available_properties()\n",
    "all_properties_except_Tg.remove(\"Tg\")\n",
    "\n",
    "config_el = {\n",
    "    \"drop\": [\"Ag\", \"Au\"],\n",
    "}\n",
    "\n",
    "config_prop = {\n",
    "    \"keep\": [\"Tg\"],\n",
    "    \"drop\": all_properties_except_Tg,\n",
    "}\n",
    "\n",
    "config_comp = {}\n",
    "\n",
    "source = SciGlass(\n",
    "    elements_cfg=config_el,\n",
    "    properties_cfg=config_prop,\n",
    "    compounds_cfg=config_comp,\n",
    ")\n",
    "\n",
    "df = source.data"
   ]
  },
  {
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"16\" halign=\"left\">elements</th>\n",
       "      <th>property</th>\n",
       "      <th colspan=\"4\" halign=\"left\">metadata</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>H</th>\n",
       "      <th>Li</th>\n",
       "      <th>Be</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>O</th>\n",
       "      <th>F</th>\n",
       "      <th>Na</th>\n",
       "      <th>Mg</th>\n",
       "      <th>...</th>\n",
       "      <th>Tl</th>\n",
       "      <th>Pb</th>\n",
       "      <th>Bi</th>\n",
       "      <th>Th</th>\n",
       "      <th>U</th>\n",
       "      <th>Tg</th>\n",
       "      <th>ChemicalAnalysis</th>\n",
       "      <th>Author</th>\n",
       "      <th>Year</th>\n",
       "      <th>NumberElements</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20500020001</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.921249</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.681530</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1017.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020002</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58.086941</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.344940</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1096.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020003</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58.198601</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.716690</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1013.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020004</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58.367241</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.308001</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1013.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500020005</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58.282768</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.264561</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>978.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Hoj J.W.</td>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493200611415</th>\n",
       "      <td>0.0</td>\n",
       "      <td>7.250638</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.368801</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.389221</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.964828</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.536447</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>543.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Jung Woo Man</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493200611416</th>\n",
       "      <td>0.0</td>\n",
       "      <td>7.445931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.358826</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.595871</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.650183</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.808963</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>545.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Jung Woo Man</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493200611417</th>\n",
       "      <td>0.0</td>\n",
       "      <td>6.593068</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.288480</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.600090</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10.782570</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>532.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Jung Woo Man</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493200611418</th>\n",
       "      <td>0.0</td>\n",
       "      <td>5.919064</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.936039</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.014076</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.322553</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>506.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Jung Woo Man</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4493200611419</th>\n",
       "      <td>0.0</td>\n",
       "      <td>6.371798</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.019926</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.761761</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.882636</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>522.15</td>\n",
       "      <td>False</td>\n",
       "      <td>Jung Woo Man</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>91738 rows × 78 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              elements                                                       \n",
       "                     H        Li   Be          B    C    N          O    F   \n",
       "ID                                                                           \n",
       "20500020001        0.0  0.000000  0.0   0.000000  0.0  0.0  57.921249  0.0  \\\n",
       "20500020002        0.0  0.000000  0.0   0.000000  0.0  0.0  58.086941  0.0   \n",
       "20500020003        0.0  0.000000  0.0   0.000000  0.0  0.0  58.198601  0.0   \n",
       "20500020004        0.0  0.000000  0.0   0.000000  0.0  0.0  58.367241  0.0   \n",
       "20500020005        0.0  0.000000  0.0   0.000000  0.0  0.0  58.282768  0.0   \n",
       "...                ...       ...  ...        ...  ...  ...        ...  ...   \n",
       "4493200611415      0.0  7.250638  0.0   2.368801  0.0  0.0  59.389221  0.0   \n",
       "4493200611416      0.0  7.445931  0.0   2.358826  0.0  0.0  59.595871  0.0   \n",
       "4493200611417      0.0  6.593068  0.0  10.288480  0.0  0.0  59.600090  0.0   \n",
       "4493200611418      0.0  5.919064  0.0   1.936039  0.0  0.0  64.014076  0.0   \n",
       "4493200611419      0.0  6.371798  0.0   2.019926  0.0  0.0  63.761761  0.0   \n",
       "\n",
       "                               ...                                       \n",
       "                      Na   Mg  ...         Tl   Pb        Bi   Th    U   \n",
       "ID                             ...                                       \n",
       "20500020001    19.681530  0.0  ...   0.000000  0.0  0.000000  0.0  0.0  \\\n",
       "20500020002    19.344940  0.0  ...   0.000000  0.0  0.000000  0.0  0.0   \n",
       "20500020003    18.716690  0.0  ...   0.000000  0.0  0.000000  0.0  0.0   \n",
       "20500020004    18.308001  0.0  ...   0.000000  0.0  0.000000  0.0  0.0   \n",
       "20500020005    18.264561  0.0  ...   0.000000  0.0  0.000000  0.0  0.0   \n",
       "...                  ...  ...  ...        ...  ...       ...  ...  ...   \n",
       "4493200611415   0.000000  0.0  ...   8.964828  0.0  5.536447  0.0  0.0   \n",
       "4493200611416   0.000000  0.0  ...   6.650183  0.0  5.808963  0.0  0.0   \n",
       "4493200611417   0.000000  0.0  ...  10.782570  0.0  0.000000  0.0  0.0   \n",
       "4493200611418   0.000000  0.0  ...   7.322553  0.0  0.000000  0.0  0.0   \n",
       "4493200611419   0.000000  0.0  ...   7.882636  0.0  0.000000  0.0  0.0   \n",
       "\n",
       "              property         metadata                                     \n",
       "                    Tg ChemicalAnalysis        Author  Year NumberElements  \n",
       "ID                                                                          \n",
       "20500020001    1017.15            False      Hoj J.W.  1992              5  \n",
       "20500020002    1096.15            False      Hoj J.W.  1992              5  \n",
       "20500020003    1013.15            False      Hoj J.W.  1992              5  \n",
       "20500020004    1013.15            False      Hoj J.W.  1992              5  \n",
       "20500020005     978.15            False      Hoj J.W.  1992              5  \n",
       "...                ...              ...           ...   ...            ...  \n",
       "4493200611415   543.15            False  Jung Woo Man  2019              9  \n",
       "4493200611416   545.15            False  Jung Woo Man  2019              9  \n",
       "4493200611417   532.15            False  Jung Woo Man  2019              9  \n",
       "4493200611418   506.15            False  Jung Woo Man  2019              9  \n",
       "4493200611419   522.15            False  Jung Woo Man  2019              9  \n",
       "\n",
       "[91738 rows x 78 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "See the documentation for the `SciGlass` class for more information on how to control your initial data collection.\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  },
  "org": null
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
