notebooks/ReadFiles/Read_single_EddyPro_fluxnet_output_file_with_ReadFileType.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "124c47aa-5027-4c5b-9a5c-8a7451597b5f",
   "metadata": {},
   "source": [
    "![lop](../../images/logo_diive1_128px.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3d27e594-5b95-4385-9487-67e42d1cbb23",
   "metadata": {},
   "source": [
    "<span style='font-size:32px; display:block;'>\n",
    "<b>\n",
    "    Read single EddyPro _fluxnet_ output file with ReadFileType\n",
    "</b>\n",
    "</span>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c268d0a9-7ebe-48fb-bdf4-ef9e9d7432d4",
   "metadata": {},
   "source": [
    "---\n",
    "**Notebook version**: `1` (20 Apr 2024)  \n",
    "**Author**: Lukas Hörtnagl (holukas@ethz.ch) "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1d10a9ef-0cee-4d5d-b402-4254299e2ed0",
   "metadata": {},
   "source": [
    "</br>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "47c5e2f4-382d-4911-b4a9-b1b211cb3a2d",
   "metadata": {},
   "source": [
    "# Description"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ed5d6781-659f-4796-8f5f-9255110fa554",
   "metadata": {},
   "source": [
    "This example shows how to read the `EddyPro` `_fluxnet_` output file with `ReadFileType` and the pre-defined filetype `EDDYPRO-FLUXNET-CSV-30MIN`."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb329cd8-8eab-4147-8e1a-880316d27b82",
   "metadata": {},
   "source": [
    "# Imports"
   ]
  },
  {
   "cell_type": "code",
   "id": "bfca8be1-b5cd-4312-ad6e-6056c0df9082",
   "metadata": {
    "tags": [],
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:10.084444Z",
     "start_time": "2024-08-22T13:43:07.839310Z"
    }
   },
   "source": [
    "import importlib.metadata\n",
    "import warnings\n",
    "from datetime import datetime\n",
    "\n",
    "from diive.core.io.filereader import ReadFileType\n",
    "\n",
    "warnings.filterwarnings('ignore')\n",
    "version_diive = importlib.metadata.version(\"diive\")\n",
    "print(f\"diive version: v{version_diive}\")"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "diive version: v0.79.0\n"
     ]
    }
   ],
   "execution_count": 1
  },
  {
   "cell_type": "markdown",
   "id": "8da30681-5095-459b-9578-744ea785bb4a",
   "metadata": {},
   "source": [
    "## Using `ReadFileType` with pre-defined filetype `EDDYPRO-FLUXNET-CSV-30MIN`"
   ]
  },
  {
   "cell_type": "code",
   "id": "6b0a881f-a277-4bbb-8271-f688940c1de1",
   "metadata": {
    "tags": [],
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:10.367839Z",
     "start_time": "2024-08-22T13:43:10.177181Z"
    }
   },
   "source": [
    "filepath = r\"F:\\TMP\\example\\eddypro_CH-CHA_FR-20240819-081003_fluxnet_2024-08-19T081023_adv.csv\"\n",
    "rft = ReadFileType(filetype='EDDYPRO-FLUXNET-CSV-30MIN',\n",
    "                   filepath=filepath)"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Reading file eddypro_CH-CHA_FR-20240819-081003_fluxnet_2024-08-19T081023_adv.csv ...\n"
     ]
    }
   ],
   "execution_count": 2
  },
  {
   "cell_type": "code",
   "id": "fdd9e178-1b10-4411-a85c-3e44b70fa9cf",
   "metadata": {
    "tags": [],
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:10.448165Z",
     "start_time": "2024-08-22T13:43:10.437169Z"
    }
   },
   "source": [
    "df, meta = rft.get_filedata()"
   ],
   "outputs": [],
   "execution_count": 3
  },
  {
   "cell_type": "markdown",
   "id": "f054bddb-ed48-47de-ac11-a53fc602e527",
   "metadata": {},
   "source": [
    "File data are now stored in a dataframe:"
   ]
  },
  {
   "cell_type": "code",
   "id": "899e83bb-c81a-4a62-8dd4-0eb522a1c73a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:10.526480Z",
     "start_time": "2024-08-22T13:43:10.482082Z"
    }
   },
   "source": [
    "df"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                     TIMESTAMP_START  DOY_START   DOY_END  FILENAME_HF  SW_IN_POT  NIGHT  EXPECT_NR  FILE_NR  CUSTOM_FILTER_NR  WD_FILTER_NR  SONIC_NR  T_SONIC_NR   CO2_NR   H2O_NR  CH4_NR  NONE_NR  TAU_NR   H_NR    FC_NR    LE_NR  FCH4_NR  FNONE_NR       TAU         H       LE  ...  BADM_INST_GA_CP_TUBE_IN_DIAM_GA_CH4  BADM_INST_GA_CP_TUBE_FLOW_RATE_GA_CH4  HPATH_GA_CH4  VPATH_GA_CH4  RESPONSE_TIME_GA_CH4  MANUFACTURER_GA_NONE  BADM_INST_MODEL_GA_NONE  BADM_INSTPAIR_NORTHWARD_SEP_GA_NONE  BADM_INSTPAIR_EASTWARD_SEP_GA_NONE  BADM_INSTPAIR_HEIGHT_SEP_GA_NONE  BADM_INST_GA_CP_TUBE_LENGTH_GA_NONE  BADM_INST_GA_CP_TUBE_IN_DIAM_GA_NONE  BADM_INST_GA_CP_TUBE_FLOW_RATE_GA_NONE  HPATH_GA_NONE  VPATH_GA_NONE  RESPONSE_TIME_GA_NONE  NUM_CUSTOM_VARS  CUSTOM_DATA_SIZE_IRGA75_MEAN  CUSTOM_STATUS_CODE_IRGA75_MEAN  CUSTOM_GA_DIAG_CODE_IRGA75_MEAN  CUSTOM_AGC_MEAN  CUSTOM_AIR_T_MEAN  CUSTOM_AIR_P_MEAN  CUSTOM_COOLER_V_MEAN  NUM_BIOMET_VARS\n",
       "TIMESTAMP_MIDDLE                                                                                                                                                                                                                                                                        ...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \n",
       "2024-08-16 01:15:00     202408160100   229.0416  229.0624          NaN      0.000      1      36000    36000             36000         35999     35999       35999  35999.0      NaN     NaN      NaN   35999  35999  35999.0      NaN      NaN       NaN -0.001736 -0.112417      NaN  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    1.349010e-07                          254.964          93.5235            292.367            97301.5               1.51643                0\n",
       "2024-08-16 01:45:00     202408160130   229.0624  229.0833          NaN      0.000      1      36000    36000             36000         36000     36000       36000  36000.0      NaN     NaN      NaN   36000  36000  36000.0      NaN      NaN       NaN  0.003221  0.357988      NaN  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          255.000          93.7500            292.357            97301.6               1.51445                0\n",
       "2024-08-16 02:15:00     202408160200   229.0833  229.1041          NaN      0.000      1      36000    36000             36000         36000     36000       36000  36000.0      NaN     NaN      NaN   36000  36000  36000.0      NaN      NaN       NaN -0.002050 -0.986744      NaN  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          255.000          93.7500            292.832            97301.5               1.52013                0\n",
       "2024-08-16 02:45:00     202408160230   229.1041  229.1249          NaN      0.000      1      36000    36000             36000         36000     36000       36000  36000.0      NaN     NaN      NaN   36000  36000  36000.0      NaN      NaN       NaN -0.007994 -2.676890      NaN  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          252.869          80.4316            293.312            97300.3               1.51980                0\n",
       "2024-08-16 03:15:00     202408160300   229.1249  229.1458          NaN      0.000      1      36000    36000             36000         36000     36000       36000  36000.0  36000.0     NaN      NaN   36000  36000  36000.0  36000.0      NaN       NaN -0.007553 -4.147340  67.7120  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          250.506          65.6618            293.339            97300.1               1.51916                0\n",
       "...                              ...        ...       ...          ...        ...    ...        ...      ...               ...           ...       ...         ...      ...      ...     ...      ...     ...    ...      ...      ...      ...       ...       ...       ...      ...  ...                                  ...                                    ...           ...           ...                   ...                   ...                      ...                                  ...                                 ...                               ...                                  ...                                   ...                                     ...            ...            ...                    ...              ...                           ...                             ...                              ...              ...                ...                ...                   ...              ...\n",
       "2024-08-18 16:45:00     202408181630   231.6873  231.7082          NaN    561.554      0      36000    36000             36000         36000     36000       36000  36000.0  36000.0     NaN      NaN   36000  36000  36000.0  36000.0      NaN       NaN -0.029640  3.774340 -51.6306  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          250.383          64.8960            292.822            96800.3               1.50279                0\n",
       "2024-08-18 17:15:00     202408181700   231.7082  231.7290          NaN    451.723      0      36000    36000             36000         36000     36000       36000  36000.0  36000.0     NaN      NaN   36000  36000  36000.0  36000.0      NaN       NaN -0.036580 -1.659720  32.0782  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          249.784          61.1524            292.389            96800.9               1.48987                0\n",
       "2024-08-18 17:45:00     202408181730   231.7290  231.7498          NaN    337.964      0      36000    36000             36000         36000     36000       36000  36000.0  36000.0     NaN      NaN   36000  36000  36000.0  36000.0      NaN       NaN -0.063546  5.119960 -52.8630  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          249.011          56.3217            292.187            96801.0               1.49139                0\n",
       "2024-08-18 18:15:00     202408181800   231.7498  231.7707          NaN    222.225      0      36000    36000             36000         36000     36000       36000  36000.0  36000.0     NaN      NaN   36000  36000  36000.0  36000.0      NaN       NaN -0.054248 -0.783710  27.7604  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          249.000          56.2500            292.180            96803.8               1.49895                0\n",
       "2024-08-18 18:45:00     202408181830   231.7707  231.7915          NaN    106.486      0      36000    36000             36000         35982     35982       35982  35982.0  35982.0     NaN      NaN   35982  35982  35982.0  35982.0      NaN       NaN -0.035735 -4.118540  39.6078  ...                                  NaN                                    NaN           NaN           NaN                   NaN                   NaN                      NaN                                  NaN                                 NaN                               NaN                                  NaN                                   NaN                                     NaN            NaN            NaN                    NaN                7                          16.0                    0.000000e+00                          249.000          56.2500            292.035            96819.9               1.49456                0\n",
       "\n",
       "[132 rows x 480 columns]"
      ],
      "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>TIMESTAMP_START</th>\n",
       "      <th>DOY_START</th>\n",
       "      <th>DOY_END</th>\n",
       "      <th>FILENAME_HF</th>\n",
       "      <th>SW_IN_POT</th>\n",
       "      <th>NIGHT</th>\n",
       "      <th>EXPECT_NR</th>\n",
       "      <th>FILE_NR</th>\n",
       "      <th>CUSTOM_FILTER_NR</th>\n",
       "      <th>WD_FILTER_NR</th>\n",
       "      <th>SONIC_NR</th>\n",
       "      <th>T_SONIC_NR</th>\n",
       "      <th>CO2_NR</th>\n",
       "      <th>H2O_NR</th>\n",
       "      <th>CH4_NR</th>\n",
       "      <th>NONE_NR</th>\n",
       "      <th>TAU_NR</th>\n",
       "      <th>H_NR</th>\n",
       "      <th>FC_NR</th>\n",
       "      <th>LE_NR</th>\n",
       "      <th>FCH4_NR</th>\n",
       "      <th>FNONE_NR</th>\n",
       "      <th>TAU</th>\n",
       "      <th>H</th>\n",
       "      <th>LE</th>\n",
       "      <th>...</th>\n",
       "      <th>BADM_INST_GA_CP_TUBE_IN_DIAM_GA_CH4</th>\n",
       "      <th>BADM_INST_GA_CP_TUBE_FLOW_RATE_GA_CH4</th>\n",
       "      <th>HPATH_GA_CH4</th>\n",
       "      <th>VPATH_GA_CH4</th>\n",
       "      <th>RESPONSE_TIME_GA_CH4</th>\n",
       "      <th>MANUFACTURER_GA_NONE</th>\n",
       "      <th>BADM_INST_MODEL_GA_NONE</th>\n",
       "      <th>BADM_INSTPAIR_NORTHWARD_SEP_GA_NONE</th>\n",
       "      <th>BADM_INSTPAIR_EASTWARD_SEP_GA_NONE</th>\n",
       "      <th>BADM_INSTPAIR_HEIGHT_SEP_GA_NONE</th>\n",
       "      <th>BADM_INST_GA_CP_TUBE_LENGTH_GA_NONE</th>\n",
       "      <th>BADM_INST_GA_CP_TUBE_IN_DIAM_GA_NONE</th>\n",
       "      <th>BADM_INST_GA_CP_TUBE_FLOW_RATE_GA_NONE</th>\n",
       "      <th>HPATH_GA_NONE</th>\n",
       "      <th>VPATH_GA_NONE</th>\n",
       "      <th>RESPONSE_TIME_GA_NONE</th>\n",
       "      <th>NUM_CUSTOM_VARS</th>\n",
       "      <th>CUSTOM_DATA_SIZE_IRGA75_MEAN</th>\n",
       "      <th>CUSTOM_STATUS_CODE_IRGA75_MEAN</th>\n",
       "      <th>CUSTOM_GA_DIAG_CODE_IRGA75_MEAN</th>\n",
       "      <th>CUSTOM_AGC_MEAN</th>\n",
       "      <th>CUSTOM_AIR_T_MEAN</th>\n",
       "      <th>CUSTOM_AIR_P_MEAN</th>\n",
       "      <th>CUSTOM_COOLER_V_MEAN</th>\n",
       "      <th>NUM_BIOMET_VARS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIMESTAMP_MIDDLE</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",
       "      <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",
       "      <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>2024-08-16 01:15:00</th>\n",
       "      <td>202408160100</td>\n",
       "      <td>229.0416</td>\n",
       "      <td>229.0624</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>35999</td>\n",
       "      <td>35999</td>\n",
       "      <td>35999</td>\n",
       "      <td>35999.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35999</td>\n",
       "      <td>35999</td>\n",
       "      <td>35999.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.001736</td>\n",
       "      <td>-0.112417</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.349010e-07</td>\n",
       "      <td>254.964</td>\n",
       "      <td>93.5235</td>\n",
       "      <td>292.367</td>\n",
       "      <td>97301.5</td>\n",
       "      <td>1.51643</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-16 01:45:00</th>\n",
       "      <td>202408160130</td>\n",
       "      <td>229.0624</td>\n",
       "      <td>229.0833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003221</td>\n",
       "      <td>0.357988</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>255.000</td>\n",
       "      <td>93.7500</td>\n",
       "      <td>292.357</td>\n",
       "      <td>97301.6</td>\n",
       "      <td>1.51445</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-16 02:15:00</th>\n",
       "      <td>202408160200</td>\n",
       "      <td>229.0833</td>\n",
       "      <td>229.1041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.002050</td>\n",
       "      <td>-0.986744</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>255.000</td>\n",
       "      <td>93.7500</td>\n",
       "      <td>292.832</td>\n",
       "      <td>97301.5</td>\n",
       "      <td>1.52013</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-16 02:45:00</th>\n",
       "      <td>202408160230</td>\n",
       "      <td>229.1041</td>\n",
       "      <td>229.1249</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.007994</td>\n",
       "      <td>-2.676890</td>\n",
       "      <td>NaN</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>252.869</td>\n",
       "      <td>80.4316</td>\n",
       "      <td>293.312</td>\n",
       "      <td>97300.3</td>\n",
       "      <td>1.51980</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-16 03:15:00</th>\n",
       "      <td>202408160300</td>\n",
       "      <td>229.1249</td>\n",
       "      <td>229.1458</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.007553</td>\n",
       "      <td>-4.147340</td>\n",
       "      <td>67.7120</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>250.506</td>\n",
       "      <td>65.6618</td>\n",
       "      <td>293.339</td>\n",
       "      <td>97300.1</td>\n",
       "      <td>1.51916</td>\n",
       "      <td>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",
       "      <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",
       "      <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>2024-08-18 16:45:00</th>\n",
       "      <td>202408181630</td>\n",
       "      <td>231.6873</td>\n",
       "      <td>231.7082</td>\n",
       "      <td>NaN</td>\n",
       "      <td>561.554</td>\n",
       "      <td>0</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.029640</td>\n",
       "      <td>3.774340</td>\n",
       "      <td>-51.6306</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>250.383</td>\n",
       "      <td>64.8960</td>\n",
       "      <td>292.822</td>\n",
       "      <td>96800.3</td>\n",
       "      <td>1.50279</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-18 17:15:00</th>\n",
       "      <td>202408181700</td>\n",
       "      <td>231.7082</td>\n",
       "      <td>231.7290</td>\n",
       "      <td>NaN</td>\n",
       "      <td>451.723</td>\n",
       "      <td>0</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.036580</td>\n",
       "      <td>-1.659720</td>\n",
       "      <td>32.0782</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>249.784</td>\n",
       "      <td>61.1524</td>\n",
       "      <td>292.389</td>\n",
       "      <td>96800.9</td>\n",
       "      <td>1.48987</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-18 17:45:00</th>\n",
       "      <td>202408181730</td>\n",
       "      <td>231.7290</td>\n",
       "      <td>231.7498</td>\n",
       "      <td>NaN</td>\n",
       "      <td>337.964</td>\n",
       "      <td>0</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.063546</td>\n",
       "      <td>5.119960</td>\n",
       "      <td>-52.8630</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>249.011</td>\n",
       "      <td>56.3217</td>\n",
       "      <td>292.187</td>\n",
       "      <td>96801.0</td>\n",
       "      <td>1.49139</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-18 18:15:00</th>\n",
       "      <td>202408181800</td>\n",
       "      <td>231.7498</td>\n",
       "      <td>231.7707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222.225</td>\n",
       "      <td>0</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.054248</td>\n",
       "      <td>-0.783710</td>\n",
       "      <td>27.7604</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>249.000</td>\n",
       "      <td>56.2500</td>\n",
       "      <td>292.180</td>\n",
       "      <td>96803.8</td>\n",
       "      <td>1.49895</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-18 18:45:00</th>\n",
       "      <td>202408181830</td>\n",
       "      <td>231.7707</td>\n",
       "      <td>231.7915</td>\n",
       "      <td>NaN</td>\n",
       "      <td>106.486</td>\n",
       "      <td>0</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>36000</td>\n",
       "      <td>35982</td>\n",
       "      <td>35982</td>\n",
       "      <td>35982</td>\n",
       "      <td>35982.0</td>\n",
       "      <td>35982.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35982</td>\n",
       "      <td>35982</td>\n",
       "      <td>35982.0</td>\n",
       "      <td>35982.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.035735</td>\n",
       "      <td>-4.118540</td>\n",
       "      <td>39.6078</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>249.000</td>\n",
       "      <td>56.2500</td>\n",
       "      <td>292.035</td>\n",
       "      <td>96819.9</td>\n",
       "      <td>1.49456</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>132 rows × 480 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 4
  },
  {
   "cell_type": "markdown",
   "id": "d99a227d-77d9-4e16-8857-48bc8490f7a0",
   "metadata": {},
   "source": [
    "Metadata are also stored, which inlcudes units (if available in the data files) and tags (for later processing). In this example, the column `TIMESTAMP_END` was used to parse the timestamp index, and was thus removed from the data columns to avoid having identical names for index and data column. However, the original data column still shows up in the metadata."
   ]
  },
  {
   "cell_type": "code",
   "id": "09aad33d-e1e3-4c3d-9d57-c73197805eea",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:10.730306Z",
     "start_time": "2024-08-22T13:43:10.703381Z"
    }
   },
   "source": [
    "meta"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                           UNITS     TAGS                       ADDED VARINDEX\n",
       "TIMESTAMP_START       -no-units-  [#orig]  2024-08-22 15:43:10.296059        0\n",
       "TIMESTAMP_END                NaN      NaN                         NaN      NaN\n",
       "DOY_START             -no-units-  [#orig]  2024-08-22 15:43:10.296059        1\n",
       "DOY_END               -no-units-  [#orig]  2024-08-22 15:43:10.296059        2\n",
       "FILENAME_HF           -no-units-  [#orig]  2024-08-22 15:43:10.296059        3\n",
       "...                          ...      ...                         ...      ...\n",
       "CUSTOM_AGC_MEAN       -no-units-  [#orig]  2024-08-22 15:43:10.296059      475\n",
       "CUSTOM_AIR_T_MEAN     -no-units-  [#orig]  2024-08-22 15:43:10.296059      476\n",
       "CUSTOM_AIR_P_MEAN     -no-units-  [#orig]  2024-08-22 15:43:10.296059      477\n",
       "CUSTOM_COOLER_V_MEAN  -no-units-  [#orig]  2024-08-22 15:43:10.296059      478\n",
       "NUM_BIOMET_VARS       -no-units-  [#orig]  2024-08-22 15:43:10.296059      479\n",
       "\n",
       "[481 rows x 4 columns]"
      ],
      "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>UNITS</th>\n",
       "      <th>TAGS</th>\n",
       "      <th>ADDED</th>\n",
       "      <th>VARINDEX</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>TIMESTAMP_START</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIMESTAMP_END</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOY_START</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOY_END</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FILENAME_HF</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUSTOM_AGC_MEAN</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUSTOM_AIR_T_MEAN</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUSTOM_AIR_P_MEAN</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUSTOM_COOLER_V_MEAN</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUM_BIOMET_VARS</th>\n",
       "      <td>-no-units-</td>\n",
       "      <td>[#orig]</td>\n",
       "      <td>2024-08-22 15:43:10.296059</td>\n",
       "      <td>479</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>481 rows × 4 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 5
  },
  {
   "cell_type": "markdown",
   "id": "f0db4988-fac6-4260-8902-a736c4dba3d8",
   "metadata": {
    "tags": []
   },
   "source": [
    "# End of notebook"
   ]
  },
  {
   "cell_type": "code",
   "id": "3f784457-e244-421b-b789-08481c2d9f9f",
   "metadata": {
    "tags": [],
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:11.029091Z",
     "start_time": "2024-08-22T13:43:11.014127Z"
    }
   },
   "source": [
    "dt_string = datetime.now().strftime(\"%Y-%m-%d %H:%M:%S\")\n",
    "print(f\"Finished {dt_string}\")"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Finished 2024-08-22 15:43:11\n"
     ]
    }
   ],
   "execution_count": 6
  },
  {
   "cell_type": "code",
   "id": "bc2102ba-6335-48be-83dc-6f753baefa2e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-22T13:43:11.061003Z",
     "start_time": "2024-08-22T13:43:11.050033Z"
    }
   },
   "source": [],
   "outputs": [],
   "execution_count": null
  }
 ],
 "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}