{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Stations to DataFrame\n",
    "\n",
    "Station data can be converted to a dataframe using the predefined [DataFrameExtractor](../utils/dataframeextractor.ipynb). This creates an entry for each channel, an inventory with channel information is needed. In the future we hope to make this a bit more general to handle inventories with only station level information."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-02-28T22:20:11.458658Z",
     "iopub.status.busy": "2024-02-28T22:20:11.458230Z",
     "iopub.status.idle": "2024-02-28T22:20:13.669197Z",
     "shell.execute_reply": "2024-02-28T22:20:13.668565Z"
    }
   },
   "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>network</th>\n",
       "      <th>station</th>\n",
       "      <th>location</th>\n",
       "      <th>channel</th>\n",
       "      <th>seed_id</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>elevation</th>\n",
       "      <th>depth</th>\n",
       "      <th>azimuth</th>\n",
       "      <th>dip</th>\n",
       "      <th>sample_rate</th>\n",
       "      <th>start_date</th>\n",
       "      <th>end_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GR</td>\n",
       "      <td>FUR</td>\n",
       "      <td></td>\n",
       "      <td>HHZ</td>\n",
       "      <td>GR.FUR..HHZ</td>\n",
       "      <td>48.162899</td>\n",
       "      <td>11.2752</td>\n",
       "      <td>565.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2006-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GR</td>\n",
       "      <td>FUR</td>\n",
       "      <td></td>\n",
       "      <td>HHN</td>\n",
       "      <td>GR.FUR..HHN</td>\n",
       "      <td>48.162899</td>\n",
       "      <td>11.2752</td>\n",
       "      <td>565.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2006-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GR</td>\n",
       "      <td>FUR</td>\n",
       "      <td></td>\n",
       "      <td>HHE</td>\n",
       "      <td>GR.FUR..HHE</td>\n",
       "      <td>48.162899</td>\n",
       "      <td>11.2752</td>\n",
       "      <td>565.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2006-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GR</td>\n",
       "      <td>FUR</td>\n",
       "      <td></td>\n",
       "      <td>BHZ</td>\n",
       "      <td>GR.FUR..BHZ</td>\n",
       "      <td>48.162899</td>\n",
       "      <td>11.2752</td>\n",
       "      <td>565.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2006-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GR</td>\n",
       "      <td>FUR</td>\n",
       "      <td></td>\n",
       "      <td>BHN</td>\n",
       "      <td>GR.FUR..BHN</td>\n",
       "      <td>48.162899</td>\n",
       "      <td>11.2752</td>\n",
       "      <td>565.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2006-12-16</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  network station location channel      seed_id   latitude  longitude  \\\n",
       "0      GR     FUR              HHZ  GR.FUR..HHZ  48.162899    11.2752   \n",
       "1      GR     FUR              HHN  GR.FUR..HHN  48.162899    11.2752   \n",
       "2      GR     FUR              HHE  GR.FUR..HHE  48.162899    11.2752   \n",
       "3      GR     FUR              BHZ  GR.FUR..BHZ  48.162899    11.2752   \n",
       "4      GR     FUR              BHN  GR.FUR..BHN  48.162899    11.2752   \n",
       "\n",
       "   elevation  depth  azimuth   dip  sample_rate start_date end_date  \n",
       "0      565.0    0.0      0.0 -90.0        100.0 2006-12-16      NaT  \n",
       "1      565.0    0.0      0.0   0.0        100.0 2006-12-16      NaT  \n",
       "2      565.0    0.0     90.0   0.0        100.0 2006-12-16      NaT  \n",
       "3      565.0    0.0      0.0 -90.0         20.0 2006-12-16      NaT  \n",
       "4      565.0    0.0      0.0   0.0         20.0 2006-12-16      NaT  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import obspy\n",
    "\n",
    "import obsplus\n",
    "\n",
    "inv = obspy.read_inventory()\n",
    "inv_df = obsplus.stations_to_df(inv)\n",
    "inv_df.head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}