{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Table basics\n",
    "\n",
    "OOMMF saves the scalar data of micromagnetic simulations in `.odt` files, whereas mumax$^{3}$ saves it in `.txt` files. `ubermagtable` is a convenience tool which provides functions for reading, manipulating, and visualising data from those files.\n",
    "\n",
    "Reading data from OOMMF and mumax3 table files is done using `ubermagtable.Table.fromfile` class method. It takes filename as an input argument."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "\n",
    "import ubermagtable as ut\n",
    "\n",
    "# Sample OOMMF .odt file\n",
    "dirname = os.path.join(\"..\", \"ubermagtable\", \"tests\", \"test_sample\")\n",
    "odtfile = os.path.join(dirname, \"oommf-new-file2.odt\")\n",
    "\n",
    "table = ut.Table.fromfile(odtfile)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Table data is now loaded into `pandas.DataFrame` and it can be accessed via `data` attribute."
   ]
  },
  {
   "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>E</th>\n",
       "      <th>E_calc_count</th>\n",
       "      <th>max_dmdt</th>\n",
       "      <th>dE/dt</th>\n",
       "      <th>delta_E</th>\n",
       "      <th>average_u</th>\n",
       "      <th>E_exchange</th>\n",
       "      <th>max_spin_ang_exchange</th>\n",
       "      <th>stage_max_spin_ang_exchange</th>\n",
       "      <th>run_max_spin_ang_exchange</th>\n",
       "      <th>E_dmi</th>\n",
       "      <th>E_uniaxialanisotropy</th>\n",
       "      <th>iteration</th>\n",
       "      <th>stage_iteration</th>\n",
       "      <th>stage</th>\n",
       "      <th>mx</th>\n",
       "      <th>my</th>\n",
       "      <th>mz</th>\n",
       "      <th>last_time_step</th>\n",
       "      <th>t</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-3.138757e-19</td>\n",
       "      <td>61.0</td>\n",
       "      <td>5105.786662</td>\n",
       "      <td>1.131548e-09</td>\n",
       "      <td>1.234439e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.819720e-19</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>-1.791404e-18</td>\n",
       "      <td>6.955566e-19</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.004356</td>\n",
       "      <td>0.001711</td>\n",
       "      <td>0.779309</td>\n",
       "      <td>1.146802e-13</td>\n",
       "      <td>1.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-3.123365e-19</td>\n",
       "      <td>92.0</td>\n",
       "      <td>5393.820357</td>\n",
       "      <td>1.881778e-09</td>\n",
       "      <td>2.714936e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.859070e-19</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>-1.795166e-18</td>\n",
       "      <td>6.969222e-19</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.007399</td>\n",
       "      <td>0.002527</td>\n",
       "      <td>0.779212</td>\n",
       "      <td>1.481817e-13</td>\n",
       "      <td>2.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-3.101629e-19</td>\n",
       "      <td>129.0</td>\n",
       "      <td>5478.105937</td>\n",
       "      <td>2.410525e-09</td>\n",
       "      <td>1.525909e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.908188e-19</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>-1.800156e-18</td>\n",
       "      <td>6.991741e-19</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.010058</td>\n",
       "      <td>0.002596</td>\n",
       "      <td>0.779103</td>\n",
       "      <td>6.371456e-14</td>\n",
       "      <td>3.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-3.075651e-19</td>\n",
       "      <td>172.0</td>\n",
       "      <td>5775.596117</td>\n",
       "      <td>2.750961e-09</td>\n",
       "      <td>2.026333e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.963184e-19</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>-1.806035e-18</td>\n",
       "      <td>7.021517e-19</td>\n",
       "      <td>28.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.012243</td>\n",
       "      <td>0.002078</td>\n",
       "      <td>0.779037</td>\n",
       "      <td>7.397143e-14</td>\n",
       "      <td>4.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-3.046980e-19</td>\n",
       "      <td>209.0</td>\n",
       "      <td>6099.408455</td>\n",
       "      <td>2.938665e-09</td>\n",
       "      <td>1.417659e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>8.020796e-19</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>-1.812650e-18</td>\n",
       "      <td>7.058726e-19</td>\n",
       "      <td>35.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.013915</td>\n",
       "      <td>0.001139</td>\n",
       "      <td>0.779058</td>\n",
       "      <td>4.838847e-14</td>\n",
       "      <td>5.000000e-12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>-4.666219e-20</td>\n",
       "      <td>7786.0</td>\n",
       "      <td>6419.713717</td>\n",
       "      <td>2.798949e-10</td>\n",
       "      <td>1.373560e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222876e-18</td>\n",
       "      <td>29.279242</td>\n",
       "      <td>29.396487</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.937412e-18</td>\n",
       "      <td>6.678731e-19</td>\n",
       "      <td>1372.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>-0.007893</td>\n",
       "      <td>-0.008017</td>\n",
       "      <td>0.899229</td>\n",
       "      <td>5.094469e-14</td>\n",
       "      <td>1.960000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>-4.634379e-20</td>\n",
       "      <td>7829.0</td>\n",
       "      <td>6444.188876</td>\n",
       "      <td>2.763562e-10</td>\n",
       "      <td>1.564748e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222846e-18</td>\n",
       "      <td>29.358338</td>\n",
       "      <td>29.358338</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.936677e-18</td>\n",
       "      <td>6.674871e-19</td>\n",
       "      <td>1379.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>-0.007885</td>\n",
       "      <td>-0.008007</td>\n",
       "      <td>0.899298</td>\n",
       "      <td>6.044352e-14</td>\n",
       "      <td>1.970000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>-4.601751e-20</td>\n",
       "      <td>7866.0</td>\n",
       "      <td>6397.295744</td>\n",
       "      <td>2.905618e-10</td>\n",
       "      <td>1.926693e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222790e-18</td>\n",
       "      <td>29.418283</td>\n",
       "      <td>29.418283</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.935846e-18</td>\n",
       "      <td>6.670387e-19</td>\n",
       "      <td>1386.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>-0.007876</td>\n",
       "      <td>-0.007998</td>\n",
       "      <td>0.899383</td>\n",
       "      <td>7.101084e-14</td>\n",
       "      <td>1.980000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>-4.568193e-20</td>\n",
       "      <td>7909.0</td>\n",
       "      <td>6374.587944</td>\n",
       "      <td>3.124776e-10</td>\n",
       "      <td>1.795553e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222710e-18</td>\n",
       "      <td>29.397007</td>\n",
       "      <td>29.419861</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.934920e-18</td>\n",
       "      <td>6.665281e-19</td>\n",
       "      <td>1393.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>-0.007866</td>\n",
       "      <td>-0.007989</td>\n",
       "      <td>0.899482</td>\n",
       "      <td>5.961504e-14</td>\n",
       "      <td>1.990000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>-4.533615e-20</td>\n",
       "      <td>7946.0</td>\n",
       "      <td>6479.674566</td>\n",
       "      <td>3.377564e-10</td>\n",
       "      <td>2.490729e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222607e-18</td>\n",
       "      <td>29.301311</td>\n",
       "      <td>29.397007</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.933899e-18</td>\n",
       "      <td>6.659556e-19</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>-0.007854</td>\n",
       "      <td>-0.007981</td>\n",
       "      <td>0.899595</td>\n",
       "      <td>7.547542e-14</td>\n",
       "      <td>2.000000e-10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                E  E_calc_count     max_dmdt         dE/dt       delta_E  \\\n",
       "0   -3.138757e-19          61.0  5105.786662  1.131548e-09  1.234439e-22   \n",
       "1   -3.123365e-19          92.0  5393.820357  1.881778e-09  2.714936e-22   \n",
       "2   -3.101629e-19         129.0  5478.105937  2.410525e-09  1.525909e-22   \n",
       "3   -3.075651e-19         172.0  5775.596117  2.750961e-09  2.026333e-22   \n",
       "4   -3.046980e-19         209.0  6099.408455  2.938665e-09  1.417659e-22   \n",
       "..            ...           ...          ...           ...           ...   \n",
       "195 -4.666219e-20        7786.0  6419.713717  2.798949e-10  1.373560e-23   \n",
       "196 -4.634379e-20        7829.0  6444.188876  2.763562e-10  1.564748e-23   \n",
       "197 -4.601751e-20        7866.0  6397.295744  2.905618e-10  1.926693e-23   \n",
       "198 -4.568193e-20        7909.0  6374.587944  3.124776e-10  1.795553e-23   \n",
       "199 -4.533615e-20        7946.0  6479.674566  3.377564e-10  2.490729e-23   \n",
       "\n",
       "     average_u    E_exchange  max_spin_ang_exchange  \\\n",
       "0        400.0  7.819720e-19              24.981919   \n",
       "1        400.0  7.859070e-19              25.999114   \n",
       "2        400.0  7.908188e-19              26.839540   \n",
       "3        400.0  7.963184e-19              27.523018   \n",
       "4        400.0  8.020796e-19              27.968494   \n",
       "..         ...           ...                    ...   \n",
       "195      400.0  1.222876e-18              29.279242   \n",
       "196      400.0  1.222846e-18              29.358338   \n",
       "197      400.0  1.222790e-18              29.418283   \n",
       "198      400.0  1.222710e-18              29.397007   \n",
       "199      400.0  1.222607e-18              29.301311   \n",
       "\n",
       "     stage_max_spin_ang_exchange  run_max_spin_ang_exchange         E_dmi  \\\n",
       "0                      24.981919                  24.981919 -1.791404e-18   \n",
       "1                      25.999114                  25.999114 -1.795166e-18   \n",
       "2                      26.839540                  26.839540 -1.800156e-18   \n",
       "3                      27.523018                  27.523018 -1.806035e-18   \n",
       "4                      27.968494                  27.968494 -1.812650e-18   \n",
       "..                           ...                        ...           ...   \n",
       "195                    29.396487                  33.740702 -1.937412e-18   \n",
       "196                    29.358338                  33.740702 -1.936677e-18   \n",
       "197                    29.418283                  33.740702 -1.935846e-18   \n",
       "198                    29.419861                  33.740702 -1.934920e-18   \n",
       "199                    29.397007                  33.740702 -1.933899e-18   \n",
       "\n",
       "     E_uniaxialanisotropy  iteration  stage_iteration  stage        mx  \\\n",
       "0            6.955566e-19        8.0              8.0    0.0 -0.004356   \n",
       "1            6.969222e-19       14.0              5.0    1.0 -0.007399   \n",
       "2            6.991741e-19       21.0              6.0    2.0 -0.010058   \n",
       "3            7.021517e-19       28.0              6.0    3.0 -0.012243   \n",
       "4            7.058726e-19       35.0              6.0    4.0 -0.013915   \n",
       "..                    ...        ...              ...    ...       ...   \n",
       "195          6.678731e-19     1372.0              6.0  195.0 -0.007893   \n",
       "196          6.674871e-19     1379.0              6.0  196.0 -0.007885   \n",
       "197          6.670387e-19     1386.0              6.0  197.0 -0.007876   \n",
       "198          6.665281e-19     1393.0              6.0  198.0 -0.007866   \n",
       "199          6.659556e-19     1400.0              6.0  199.0 -0.007854   \n",
       "\n",
       "           my        mz  last_time_step             t  \n",
       "0    0.001711  0.779309    1.146802e-13  1.000000e-12  \n",
       "1    0.002527  0.779212    1.481817e-13  2.000000e-12  \n",
       "2    0.002596  0.779103    6.371456e-14  3.000000e-12  \n",
       "3    0.002078  0.779037    7.397143e-14  4.000000e-12  \n",
       "4    0.001139  0.779058    4.838847e-14  5.000000e-12  \n",
       "..        ...       ...             ...           ...  \n",
       "195 -0.008017  0.899229    5.094469e-14  1.960000e-10  \n",
       "196 -0.008007  0.899298    6.044352e-14  1.970000e-10  \n",
       "197 -0.007998  0.899383    7.101084e-14  1.980000e-10  \n",
       "198 -0.007989  0.899482    5.961504e-14  1.990000e-10  \n",
       "199 -0.007981  0.899595    7.547542e-14  2.000000e-10  \n",
       "\n",
       "[200 rows x 20 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Apart from the data, units for individual columns are stored in `units` attribute."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'E': 'J',\n",
       " 'E_calc_count': '',\n",
       " 'max_dmdt': 'deg/ns',\n",
       " 'dE/dt': 'J/s',\n",
       " 'delta_E': 'J',\n",
       " 'average_u': 'm/s',\n",
       " 'E_exchange': 'J',\n",
       " 'max_spin_ang_exchange': 'deg',\n",
       " 'stage_max_spin_ang_exchange': 'deg',\n",
       " 'run_max_spin_ang_exchange': 'deg',\n",
       " 'E_dmi': 'J',\n",
       " 'E_uniaxialanisotropy': 'J',\n",
       " 'iteration': '',\n",
       " 'stage_iteration': '',\n",
       " 'stage': '',\n",
       " 'mx': '',\n",
       " 'my': '',\n",
       " 'mz': '',\n",
       " 'last_time_step': 's',\n",
       " 't': 's'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.units"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This returns a dictionary, whose keys are column names and its values are the units.\n",
    "\n",
    "By default, column names from OOMMF `.odt` and mumax3 `.txt` files are shortened. This can be changed by passing `rename=False` to the `Table.fromfile` class method:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "table_not_renamed = ut.Table.fromfile(odtfile, rename=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The column names are now:"
   ]
  },
  {
   "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>SpinTEvolve:evolver:Total energy</th>\n",
       "      <th>SpinTEvolve:evolver:Energy calc count</th>\n",
       "      <th>SpinTEvolve:evolver:Max dm/dt</th>\n",
       "      <th>SpinTEvolve:evolver:dE/dt</th>\n",
       "      <th>SpinTEvolve:evolver:Delta E</th>\n",
       "      <th>SpinTEvolve:evolver:average u</th>\n",
       "      <th>UniformExchange:exchange:Energy</th>\n",
       "      <th>UniformExchange:exchange:Max Spin Ang</th>\n",
       "      <th>UniformExchange:exchange:Stage Max Spin Ang</th>\n",
       "      <th>UniformExchange:exchange:Run Max Spin Ang</th>\n",
       "      <th>DMI_Cnv:dmi:Energy</th>\n",
       "      <th>UniaxialAnisotropy:uniaxialanisotropy:Energy</th>\n",
       "      <th>TimeDriver::Iteration</th>\n",
       "      <th>TimeDriver::Stage iteration</th>\n",
       "      <th>TimeDriver::Stage</th>\n",
       "      <th>TimeDriver::mx</th>\n",
       "      <th>TimeDriver::my</th>\n",
       "      <th>TimeDriver::mz</th>\n",
       "      <th>TimeDriver::Last time step</th>\n",
       "      <th>TimeDriver::Simulation time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-3.138757e-19</td>\n",
       "      <td>61.0</td>\n",
       "      <td>5105.786662</td>\n",
       "      <td>1.131548e-09</td>\n",
       "      <td>1.234439e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.819720e-19</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>24.981919</td>\n",
       "      <td>-1.791404e-18</td>\n",
       "      <td>6.955566e-19</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.004356</td>\n",
       "      <td>0.001711</td>\n",
       "      <td>0.779309</td>\n",
       "      <td>1.146802e-13</td>\n",
       "      <td>1.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-3.123365e-19</td>\n",
       "      <td>92.0</td>\n",
       "      <td>5393.820357</td>\n",
       "      <td>1.881778e-09</td>\n",
       "      <td>2.714936e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.859070e-19</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>25.999114</td>\n",
       "      <td>-1.795166e-18</td>\n",
       "      <td>6.969222e-19</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.007399</td>\n",
       "      <td>0.002527</td>\n",
       "      <td>0.779212</td>\n",
       "      <td>1.481817e-13</td>\n",
       "      <td>2.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-3.101629e-19</td>\n",
       "      <td>129.0</td>\n",
       "      <td>5478.105937</td>\n",
       "      <td>2.410525e-09</td>\n",
       "      <td>1.525909e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.908188e-19</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>26.839540</td>\n",
       "      <td>-1.800156e-18</td>\n",
       "      <td>6.991741e-19</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.010058</td>\n",
       "      <td>0.002596</td>\n",
       "      <td>0.779103</td>\n",
       "      <td>6.371456e-14</td>\n",
       "      <td>3.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-3.075651e-19</td>\n",
       "      <td>172.0</td>\n",
       "      <td>5775.596117</td>\n",
       "      <td>2.750961e-09</td>\n",
       "      <td>2.026333e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>7.963184e-19</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>27.523018</td>\n",
       "      <td>-1.806035e-18</td>\n",
       "      <td>7.021517e-19</td>\n",
       "      <td>28.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.012243</td>\n",
       "      <td>0.002078</td>\n",
       "      <td>0.779037</td>\n",
       "      <td>7.397143e-14</td>\n",
       "      <td>4.000000e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-3.046980e-19</td>\n",
       "      <td>209.0</td>\n",
       "      <td>6099.408455</td>\n",
       "      <td>2.938665e-09</td>\n",
       "      <td>1.417659e-22</td>\n",
       "      <td>400.0</td>\n",
       "      <td>8.020796e-19</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>27.968494</td>\n",
       "      <td>-1.812650e-18</td>\n",
       "      <td>7.058726e-19</td>\n",
       "      <td>35.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.013915</td>\n",
       "      <td>0.001139</td>\n",
       "      <td>0.779058</td>\n",
       "      <td>4.838847e-14</td>\n",
       "      <td>5.000000e-12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>-4.666219e-20</td>\n",
       "      <td>7786.0</td>\n",
       "      <td>6419.713717</td>\n",
       "      <td>2.798949e-10</td>\n",
       "      <td>1.373560e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222876e-18</td>\n",
       "      <td>29.279242</td>\n",
       "      <td>29.396487</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.937412e-18</td>\n",
       "      <td>6.678731e-19</td>\n",
       "      <td>1372.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>-0.007893</td>\n",
       "      <td>-0.008017</td>\n",
       "      <td>0.899229</td>\n",
       "      <td>5.094469e-14</td>\n",
       "      <td>1.960000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>-4.634379e-20</td>\n",
       "      <td>7829.0</td>\n",
       "      <td>6444.188876</td>\n",
       "      <td>2.763562e-10</td>\n",
       "      <td>1.564748e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222846e-18</td>\n",
       "      <td>29.358338</td>\n",
       "      <td>29.358338</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.936677e-18</td>\n",
       "      <td>6.674871e-19</td>\n",
       "      <td>1379.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>-0.007885</td>\n",
       "      <td>-0.008007</td>\n",
       "      <td>0.899298</td>\n",
       "      <td>6.044352e-14</td>\n",
       "      <td>1.970000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>-4.601751e-20</td>\n",
       "      <td>7866.0</td>\n",
       "      <td>6397.295744</td>\n",
       "      <td>2.905618e-10</td>\n",
       "      <td>1.926693e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222790e-18</td>\n",
       "      <td>29.418283</td>\n",
       "      <td>29.418283</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.935846e-18</td>\n",
       "      <td>6.670387e-19</td>\n",
       "      <td>1386.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>-0.007876</td>\n",
       "      <td>-0.007998</td>\n",
       "      <td>0.899383</td>\n",
       "      <td>7.101084e-14</td>\n",
       "      <td>1.980000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>-4.568193e-20</td>\n",
       "      <td>7909.0</td>\n",
       "      <td>6374.587944</td>\n",
       "      <td>3.124776e-10</td>\n",
       "      <td>1.795553e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222710e-18</td>\n",
       "      <td>29.397007</td>\n",
       "      <td>29.419861</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.934920e-18</td>\n",
       "      <td>6.665281e-19</td>\n",
       "      <td>1393.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>-0.007866</td>\n",
       "      <td>-0.007989</td>\n",
       "      <td>0.899482</td>\n",
       "      <td>5.961504e-14</td>\n",
       "      <td>1.990000e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>-4.533615e-20</td>\n",
       "      <td>7946.0</td>\n",
       "      <td>6479.674566</td>\n",
       "      <td>3.377564e-10</td>\n",
       "      <td>2.490729e-23</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.222607e-18</td>\n",
       "      <td>29.301311</td>\n",
       "      <td>29.397007</td>\n",
       "      <td>33.740702</td>\n",
       "      <td>-1.933899e-18</td>\n",
       "      <td>6.659556e-19</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>-0.007854</td>\n",
       "      <td>-0.007981</td>\n",
       "      <td>0.899595</td>\n",
       "      <td>7.547542e-14</td>\n",
       "      <td>2.000000e-10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     SpinTEvolve:evolver:Total energy  SpinTEvolve:evolver:Energy calc count  \\\n",
       "0                       -3.138757e-19                                   61.0   \n",
       "1                       -3.123365e-19                                   92.0   \n",
       "2                       -3.101629e-19                                  129.0   \n",
       "3                       -3.075651e-19                                  172.0   \n",
       "4                       -3.046980e-19                                  209.0   \n",
       "..                                ...                                    ...   \n",
       "195                     -4.666219e-20                                 7786.0   \n",
       "196                     -4.634379e-20                                 7829.0   \n",
       "197                     -4.601751e-20                                 7866.0   \n",
       "198                     -4.568193e-20                                 7909.0   \n",
       "199                     -4.533615e-20                                 7946.0   \n",
       "\n",
       "     SpinTEvolve:evolver:Max dm/dt  SpinTEvolve:evolver:dE/dt  \\\n",
       "0                      5105.786662               1.131548e-09   \n",
       "1                      5393.820357               1.881778e-09   \n",
       "2                      5478.105937               2.410525e-09   \n",
       "3                      5775.596117               2.750961e-09   \n",
       "4                      6099.408455               2.938665e-09   \n",
       "..                             ...                        ...   \n",
       "195                    6419.713717               2.798949e-10   \n",
       "196                    6444.188876               2.763562e-10   \n",
       "197                    6397.295744               2.905618e-10   \n",
       "198                    6374.587944               3.124776e-10   \n",
       "199                    6479.674566               3.377564e-10   \n",
       "\n",
       "     SpinTEvolve:evolver:Delta E  SpinTEvolve:evolver:average u  \\\n",
       "0                   1.234439e-22                          400.0   \n",
       "1                   2.714936e-22                          400.0   \n",
       "2                   1.525909e-22                          400.0   \n",
       "3                   2.026333e-22                          400.0   \n",
       "4                   1.417659e-22                          400.0   \n",
       "..                           ...                            ...   \n",
       "195                 1.373560e-23                          400.0   \n",
       "196                 1.564748e-23                          400.0   \n",
       "197                 1.926693e-23                          400.0   \n",
       "198                 1.795553e-23                          400.0   \n",
       "199                 2.490729e-23                          400.0   \n",
       "\n",
       "     UniformExchange:exchange:Energy  UniformExchange:exchange:Max Spin Ang  \\\n",
       "0                       7.819720e-19                              24.981919   \n",
       "1                       7.859070e-19                              25.999114   \n",
       "2                       7.908188e-19                              26.839540   \n",
       "3                       7.963184e-19                              27.523018   \n",
       "4                       8.020796e-19                              27.968494   \n",
       "..                               ...                                    ...   \n",
       "195                     1.222876e-18                              29.279242   \n",
       "196                     1.222846e-18                              29.358338   \n",
       "197                     1.222790e-18                              29.418283   \n",
       "198                     1.222710e-18                              29.397007   \n",
       "199                     1.222607e-18                              29.301311   \n",
       "\n",
       "     UniformExchange:exchange:Stage Max Spin Ang  \\\n",
       "0                                      24.981919   \n",
       "1                                      25.999114   \n",
       "2                                      26.839540   \n",
       "3                                      27.523018   \n",
       "4                                      27.968494   \n",
       "..                                           ...   \n",
       "195                                    29.396487   \n",
       "196                                    29.358338   \n",
       "197                                    29.418283   \n",
       "198                                    29.419861   \n",
       "199                                    29.397007   \n",
       "\n",
       "     UniformExchange:exchange:Run Max Spin Ang  DMI_Cnv:dmi:Energy  \\\n",
       "0                                    24.981919       -1.791404e-18   \n",
       "1                                    25.999114       -1.795166e-18   \n",
       "2                                    26.839540       -1.800156e-18   \n",
       "3                                    27.523018       -1.806035e-18   \n",
       "4                                    27.968494       -1.812650e-18   \n",
       "..                                         ...                 ...   \n",
       "195                                  33.740702       -1.937412e-18   \n",
       "196                                  33.740702       -1.936677e-18   \n",
       "197                                  33.740702       -1.935846e-18   \n",
       "198                                  33.740702       -1.934920e-18   \n",
       "199                                  33.740702       -1.933899e-18   \n",
       "\n",
       "     UniaxialAnisotropy:uniaxialanisotropy:Energy  TimeDriver::Iteration  \\\n",
       "0                                    6.955566e-19                    8.0   \n",
       "1                                    6.969222e-19                   14.0   \n",
       "2                                    6.991741e-19                   21.0   \n",
       "3                                    7.021517e-19                   28.0   \n",
       "4                                    7.058726e-19                   35.0   \n",
       "..                                            ...                    ...   \n",
       "195                                  6.678731e-19                 1372.0   \n",
       "196                                  6.674871e-19                 1379.0   \n",
       "197                                  6.670387e-19                 1386.0   \n",
       "198                                  6.665281e-19                 1393.0   \n",
       "199                                  6.659556e-19                 1400.0   \n",
       "\n",
       "     TimeDriver::Stage iteration  TimeDriver::Stage  TimeDriver::mx  \\\n",
       "0                            8.0                0.0       -0.004356   \n",
       "1                            5.0                1.0       -0.007399   \n",
       "2                            6.0                2.0       -0.010058   \n",
       "3                            6.0                3.0       -0.012243   \n",
       "4                            6.0                4.0       -0.013915   \n",
       "..                           ...                ...             ...   \n",
       "195                          6.0              195.0       -0.007893   \n",
       "196                          6.0              196.0       -0.007885   \n",
       "197                          6.0              197.0       -0.007876   \n",
       "198                          6.0              198.0       -0.007866   \n",
       "199                          6.0              199.0       -0.007854   \n",
       "\n",
       "     TimeDriver::my  TimeDriver::mz  TimeDriver::Last time step  \\\n",
       "0          0.001711        0.779309                1.146802e-13   \n",
       "1          0.002527        0.779212                1.481817e-13   \n",
       "2          0.002596        0.779103                6.371456e-14   \n",
       "3          0.002078        0.779037                7.397143e-14   \n",
       "4          0.001139        0.779058                4.838847e-14   \n",
       "..              ...             ...                         ...   \n",
       "195       -0.008017        0.899229                5.094469e-14   \n",
       "196       -0.008007        0.899298                6.044352e-14   \n",
       "197       -0.007998        0.899383                7.101084e-14   \n",
       "198       -0.007989        0.899482                5.961504e-14   \n",
       "199       -0.007981        0.899595                7.547542e-14   \n",
       "\n",
       "     TimeDriver::Simulation time  \n",
       "0                   1.000000e-12  \n",
       "1                   2.000000e-12  \n",
       "2                   3.000000e-12  \n",
       "3                   4.000000e-12  \n",
       "4                   5.000000e-12  \n",
       "..                           ...  \n",
       "195                 1.960000e-10  \n",
       "196                 1.970000e-10  \n",
       "197                 1.980000e-10  \n",
       "198                 1.990000e-10  \n",
       "199                 2.000000e-10  \n",
       "\n",
       "[200 rows x 20 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table_not_renamed.data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can specify the name of an independent variable in the table."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "table.x = \"t\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If we already knew what the independent variable was going to be when we loaded the file, we could have passed it to `fromfile` method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "table = ut.Table.fromfile(odtfile, x=\"t\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If table data was obtained by using time driver, table data store different values which are all a function of time. Column names of all time-dependent data can be obtained using `y`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['E',\n",
       " 'E_calc_count',\n",
       " 'max_dmdt',\n",
       " 'dE/dt',\n",
       " 'delta_E',\n",
       " 'average_u',\n",
       " 'E_exchange',\n",
       " 'max_spin_ang_exchange',\n",
       " 'stage_max_spin_ang_exchange',\n",
       " 'run_max_spin_ang_exchange',\n",
       " 'E_dmi',\n",
       " 'E_uniaxialanisotropy',\n",
       " 'iteration',\n",
       " 'stage_iteration',\n",
       " 'stage',\n",
       " 'mx',\n",
       " 'my',\n",
       " 'mz',\n",
       " 'last_time_step']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.y"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Similarly, column name storing independent variable:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'t'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.x"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The maximum value of `x`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2e-10"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table.xmax"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finally, the representation string of the table is:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                E  E_calc_count     max_dmdt         dE/dt       delta_E  \\\n",
       "0   -3.138757e-19          61.0  5105.786662  1.131548e-09  1.234439e-22   \n",
       "1   -3.123365e-19          92.0  5393.820357  1.881778e-09  2.714936e-22   \n",
       "2   -3.101629e-19         129.0  5478.105937  2.410525e-09  1.525909e-22   \n",
       "3   -3.075651e-19         172.0  5775.596117  2.750961e-09  2.026333e-22   \n",
       "4   -3.046980e-19         209.0  6099.408455  2.938665e-09  1.417659e-22   \n",
       "..            ...           ...          ...           ...           ...   \n",
       "195 -4.666219e-20        7786.0  6419.713717  2.798949e-10  1.373560e-23   \n",
       "196 -4.634379e-20        7829.0  6444.188876  2.763562e-10  1.564748e-23   \n",
       "197 -4.601751e-20        7866.0  6397.295744  2.905618e-10  1.926693e-23   \n",
       "198 -4.568193e-20        7909.0  6374.587944  3.124776e-10  1.795553e-23   \n",
       "199 -4.533615e-20        7946.0  6479.674566  3.377564e-10  2.490729e-23   \n",
       "\n",
       "     average_u    E_exchange  max_spin_ang_exchange  \\\n",
       "0        400.0  7.819720e-19              24.981919   \n",
       "1        400.0  7.859070e-19              25.999114   \n",
       "2        400.0  7.908188e-19              26.839540   \n",
       "3        400.0  7.963184e-19              27.523018   \n",
       "4        400.0  8.020796e-19              27.968494   \n",
       "..         ...           ...                    ...   \n",
       "195      400.0  1.222876e-18              29.279242   \n",
       "196      400.0  1.222846e-18              29.358338   \n",
       "197      400.0  1.222790e-18              29.418283   \n",
       "198      400.0  1.222710e-18              29.397007   \n",
       "199      400.0  1.222607e-18              29.301311   \n",
       "\n",
       "     stage_max_spin_ang_exchange  run_max_spin_ang_exchange         E_dmi  \\\n",
       "0                      24.981919                  24.981919 -1.791404e-18   \n",
       "1                      25.999114                  25.999114 -1.795166e-18   \n",
       "2                      26.839540                  26.839540 -1.800156e-18   \n",
       "3                      27.523018                  27.523018 -1.806035e-18   \n",
       "4                      27.968494                  27.968494 -1.812650e-18   \n",
       "..                           ...                        ...           ...   \n",
       "195                    29.396487                  33.740702 -1.937412e-18   \n",
       "196                    29.358338                  33.740702 -1.936677e-18   \n",
       "197                    29.418283                  33.740702 -1.935846e-18   \n",
       "198                    29.419861                  33.740702 -1.934920e-18   \n",
       "199                    29.397007                  33.740702 -1.933899e-18   \n",
       "\n",
       "     E_uniaxialanisotropy  iteration  stage_iteration  stage        mx  \\\n",
       "0            6.955566e-19        8.0              8.0    0.0 -0.004356   \n",
       "1            6.969222e-19       14.0              5.0    1.0 -0.007399   \n",
       "2            6.991741e-19       21.0              6.0    2.0 -0.010058   \n",
       "3            7.021517e-19       28.0              6.0    3.0 -0.012243   \n",
       "4            7.058726e-19       35.0              6.0    4.0 -0.013915   \n",
       "..                    ...        ...              ...    ...       ...   \n",
       "195          6.678731e-19     1372.0              6.0  195.0 -0.007893   \n",
       "196          6.674871e-19     1379.0              6.0  196.0 -0.007885   \n",
       "197          6.670387e-19     1386.0              6.0  197.0 -0.007876   \n",
       "198          6.665281e-19     1393.0              6.0  198.0 -0.007866   \n",
       "199          6.659556e-19     1400.0              6.0  199.0 -0.007854   \n",
       "\n",
       "           my        mz  last_time_step             t  \n",
       "0    0.001711  0.779309    1.146802e-13  1.000000e-12  \n",
       "1    0.002527  0.779212    1.481817e-13  2.000000e-12  \n",
       "2    0.002596  0.779103    6.371456e-14  3.000000e-12  \n",
       "3    0.002078  0.779037    7.397143e-14  4.000000e-12  \n",
       "4    0.001139  0.779058    4.838847e-14  5.000000e-12  \n",
       "..        ...       ...             ...           ...  \n",
       "195 -0.008017  0.899229    5.094469e-14  1.960000e-10  \n",
       "196 -0.008007  0.899298    6.044352e-14  1.970000e-10  \n",
       "197 -0.007998  0.899383    7.101084e-14  1.980000e-10  \n",
       "198 -0.007989  0.899482    5.961504e-14  1.990000e-10  \n",
       "199 -0.007981  0.899595    7.547542e-14  2.000000e-10  \n",
       "\n",
       "[200 rows x 20 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table"
   ]
  }
 ],
 "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.8.10"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}