{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "58ca5f14",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib as mpl\n",
    "%matplotlib notebook\n",
    "import matplotlib.pyplot as plt\n",
    "import xarray as xr\n",
    "\n",
    "from matplotlib.cm import get_cmap\n",
    "from matplotlib.gridspec import GridSpec\n",
    "from matplotlib.colors import LightSource\n",
    "from matplotlib.cm import get_cmap\n",
    "import datetime\n",
    "from datetime import timedelta\n",
    "\n",
    "import cartopy.crs as ccrs\n",
    "import cartopy.feature as cf\n",
    "\n",
    "\n",
    "sys.path.insert(1,'/discover/nobackup/cakelle2/GEOS_CF/Apps/cftools/external/cmcrameri')\n",
    "from cmcrameri import cm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "94ddf9ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"/discover/nobackup/projects/gmao/geos_cf_dev/psturm/GCv14.0_GCMv1.17_c90/dataKPP/data0.csv\",low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c5a7e12c",
   "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>Time</th>\n",
       "      <th>Lat centers [deg]</th>\n",
       "      <th>Lon centers [deg]</th>\n",
       "      <th>L</th>\n",
       "      <th>cos(SZA)</th>\n",
       "      <th>NStp</th>\n",
       "      <th>CH2I2</th>\n",
       "      <th>CH2IBr</th>\n",
       "      <th>CH2ICl</th>\n",
       "      <th>AERI</th>\n",
       "      <th>...</th>\n",
       "      <th>SALCCL</th>\n",
       "      <th>NO3</th>\n",
       "      <th>O</th>\n",
       "      <th>Cl</th>\n",
       "      <th>SO2</th>\n",
       "      <th>Br</th>\n",
       "      <th>H2</th>\n",
       "      <th>N2</th>\n",
       "      <th>O2</th>\n",
       "      <th>RCOOH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-35.07</td>\n",
       "      <td>-54.58</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5142</td>\n",
       "      <td>15</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>2.307000e-15</td>\n",
       "      <td>...</td>\n",
       "      <td>2.771000e-11</td>\n",
       "      <td>33.09</td>\n",
       "      <td>2.479000e-09</td>\n",
       "      <td>3745.0</td>\n",
       "      <td>0.000011</td>\n",
       "      <td>9545.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-35.45</td>\n",
       "      <td>-53.74</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5106</td>\n",
       "      <td>10</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>2.968000e-14</td>\n",
       "      <td>...</td>\n",
       "      <td>2.795000e-11</td>\n",
       "      <td>33.56</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>4236.0</td>\n",
       "      <td>0.000013</td>\n",
       "      <td>9868.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-35.83</td>\n",
       "      <td>-52.90</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5070</td>\n",
       "      <td>13</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>4.825000e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>3.349000e-11</td>\n",
       "      <td>39.21</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12970.0</td>\n",
       "      <td>0.000099</td>\n",
       "      <td>11570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-36.20</td>\n",
       "      <td>-52.04</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5033</td>\n",
       "      <td>7</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>2.615000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>3.350000e-11</td>\n",
       "      <td>39.35</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12970.0</td>\n",
       "      <td>0.000099</td>\n",
       "      <td>11570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-36.57</td>\n",
       "      <td>-51.18</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.4995</td>\n",
       "      <td>8</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>2.416000e-11</td>\n",
       "      <td>...</td>\n",
       "      <td>3.352000e-11</td>\n",
       "      <td>39.50</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12990.0</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>11630.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4603</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-30.60</td>\n",
       "      <td>-52.04</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5840</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4604</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-30.94</td>\n",
       "      <td>-51.18</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5811</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4605</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-31.27</td>\n",
       "      <td>-50.30</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5780</td>\n",
       "      <td>8</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4606</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-31.60</td>\n",
       "      <td>-49.42</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5748</td>\n",
       "      <td>5</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4607</th>\n",
       "      <td>2019/01/02 02:45</td>\n",
       "      <td>-31.92</td>\n",
       "      <td>-48.54</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5714</td>\n",
       "      <td>8</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>0.2848-305</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4608 rows × 297 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Time   Lat centers [deg]   Lon centers [deg]   L   cos(SZA)  \\\n",
       "0     2019/01/02 02:45              -35.07              -54.58   1    -0.5142   \n",
       "1     2019/01/02 02:45              -35.45              -53.74   1    -0.5106   \n",
       "2     2019/01/02 02:45              -35.83              -52.90   1    -0.5070   \n",
       "3     2019/01/02 02:45              -36.20              -52.04   1    -0.5033   \n",
       "4     2019/01/02 02:45              -36.57              -51.18   1    -0.4995   \n",
       "...                ...                 ...                 ...  ..        ...   \n",
       "4603  2019/01/02 02:45              -30.60              -52.04  72    -0.5840   \n",
       "4604  2019/01/02 02:45              -30.94              -51.18  72    -0.5811   \n",
       "4605  2019/01/02 02:45              -31.27              -50.30  72    -0.5780   \n",
       "4606  2019/01/02 02:45              -31.60              -49.42  72    -0.5748   \n",
       "4607  2019/01/02 02:45              -31.92              -48.54  72    -0.5714   \n",
       "\n",
       "       NStp              CH2I2             CH2IBr             CH2ICl  \\\n",
       "0        15         0.2848-305         0.2848-305         0.2848-305   \n",
       "1        10         0.2848-305         0.2848-305         0.2848-305   \n",
       "2        13         0.2848-305         0.2848-305         0.2848-305   \n",
       "3         7         0.2848-305         0.2848-305         0.2848-305   \n",
       "4         8         0.2848-305         0.2848-305         0.2848-305   \n",
       "...     ...                ...                ...                ...   \n",
       "4603      4         0.2848-305         0.2848-305         0.2848-305   \n",
       "4604      4         0.2848-305         0.2848-305         0.2848-305   \n",
       "4605      8         0.2848-305         0.2848-305         0.2848-305   \n",
       "4606      5         0.2848-305         0.2848-305         0.2848-305   \n",
       "4607      8         0.2848-305         0.2848-305         0.2848-305   \n",
       "\n",
       "              AERI  ...        SALCCL       NO3             O         Cl  \\\n",
       "0     2.307000e-15  ...  2.771000e-11     33.09  2.479000e-09     3745.0   \n",
       "1     2.968000e-14  ...  2.795000e-11     33.56  2.481000e-09     4236.0   \n",
       "2     4.825000e-13  ...  3.349000e-11     39.21  2.481000e-09    12970.0   \n",
       "3     2.615000e-12  ...  3.350000e-11     39.35  2.481000e-09    12970.0   \n",
       "4     2.416000e-11  ...  3.352000e-11     39.50  2.481000e-09    12990.0   \n",
       "...            ...  ...           ...       ...           ...        ...   \n",
       "4603  1.136000e-07  ...  1.682000e-04  39460.00  7.239000e+01  5275000.0   \n",
       "4604  1.136000e-07  ...  1.682000e-04  39460.00  7.239000e+01  5275000.0   \n",
       "4605  1.136000e-07  ...  1.682000e-04  39460.00  7.239000e+01  5275000.0   \n",
       "4606  1.136000e-07  ...  1.682000e-04  39460.00  7.239000e+01  5275000.0   \n",
       "4607  1.136000e-07  ...  1.682000e-04  39460.00  7.239000e+01  5275000.0   \n",
       "\n",
       "            SO2         Br  H2  N2  O2  RCOOH  \n",
       "0      0.000011     9545.0 NaN NaN NaN    NaN  \n",
       "1      0.000013     9868.0 NaN NaN NaN    NaN  \n",
       "2      0.000099    11570.0 NaN NaN NaN    NaN  \n",
       "3      0.000099    11570.0 NaN NaN NaN    NaN  \n",
       "4      0.000101    11630.0 NaN NaN NaN    NaN  \n",
       "...         ...        ...  ..  ..  ..    ...  \n",
       "4603  66.940000  8091000.0 NaN NaN NaN    NaN  \n",
       "4604  66.940000  8091000.0 NaN NaN NaN    NaN  \n",
       "4605  66.940000  8091000.0 NaN NaN NaN    NaN  \n",
       "4606  66.940000  8091000.0 NaN NaN NaN    NaN  \n",
       "4607  66.940000  8091000.0 NaN NaN NaN    NaN  \n",
       "\n",
       "[4608 rows x 297 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "79d026c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "numerics = ['int16', 'int32', 'int64', 'float16', 'float32', 'float64']\n",
    "newdf = data.select_dtypes(include=numerics)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "8250430b",
   "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>Lat centers [deg]</th>\n",
       "      <th>Lon centers [deg]</th>\n",
       "      <th>L</th>\n",
       "      <th>cos(SZA)</th>\n",
       "      <th>NStp</th>\n",
       "      <th>AERI</th>\n",
       "      <th>AONITA</th>\n",
       "      <th>CO2</th>\n",
       "      <th>INDIOL</th>\n",
       "      <th>ISALA</th>\n",
       "      <th>...</th>\n",
       "      <th>SALCCL</th>\n",
       "      <th>NO3</th>\n",
       "      <th>O</th>\n",
       "      <th>Cl</th>\n",
       "      <th>SO2</th>\n",
       "      <th>Br</th>\n",
       "      <th>H2</th>\n",
       "      <th>N2</th>\n",
       "      <th>O2</th>\n",
       "      <th>RCOOH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-35.07</td>\n",
       "      <td>-54.58</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5142</td>\n",
       "      <td>15</td>\n",
       "      <td>2.307000e-15</td>\n",
       "      <td>2.925000e-09</td>\n",
       "      <td>2573.0</td>\n",
       "      <td>3.888000e-09</td>\n",
       "      <td>3.129000e-15</td>\n",
       "      <td>...</td>\n",
       "      <td>2.771000e-11</td>\n",
       "      <td>33.09</td>\n",
       "      <td>2.479000e-09</td>\n",
       "      <td>3745.0</td>\n",
       "      <td>0.000011</td>\n",
       "      <td>9545.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-35.45</td>\n",
       "      <td>-53.74</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5106</td>\n",
       "      <td>10</td>\n",
       "      <td>2.968000e-14</td>\n",
       "      <td>2.943000e-09</td>\n",
       "      <td>2904.0</td>\n",
       "      <td>4.296000e-09</td>\n",
       "      <td>7.438000e-14</td>\n",
       "      <td>...</td>\n",
       "      <td>2.795000e-11</td>\n",
       "      <td>33.56</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>4236.0</td>\n",
       "      <td>0.000013</td>\n",
       "      <td>9868.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-35.83</td>\n",
       "      <td>-52.90</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5070</td>\n",
       "      <td>13</td>\n",
       "      <td>4.825000e-13</td>\n",
       "      <td>3.619000e-09</td>\n",
       "      <td>4483.0</td>\n",
       "      <td>4.301000e-09</td>\n",
       "      <td>1.588000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>3.349000e-11</td>\n",
       "      <td>39.21</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12970.0</td>\n",
       "      <td>0.000099</td>\n",
       "      <td>11570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-36.20</td>\n",
       "      <td>-52.04</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.5033</td>\n",
       "      <td>7</td>\n",
       "      <td>2.615000e-12</td>\n",
       "      <td>3.679000e-09</td>\n",
       "      <td>4484.0</td>\n",
       "      <td>4.301000e-09</td>\n",
       "      <td>1.189000e-11</td>\n",
       "      <td>...</td>\n",
       "      <td>3.350000e-11</td>\n",
       "      <td>39.35</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12970.0</td>\n",
       "      <td>0.000099</td>\n",
       "      <td>11570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-36.57</td>\n",
       "      <td>-51.18</td>\n",
       "      <td>1</td>\n",
       "      <td>-0.4995</td>\n",
       "      <td>8</td>\n",
       "      <td>2.416000e-11</td>\n",
       "      <td>3.687000e-09</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>4.301000e-09</td>\n",
       "      <td>8.490000e-11</td>\n",
       "      <td>...</td>\n",
       "      <td>3.352000e-11</td>\n",
       "      <td>39.50</td>\n",
       "      <td>2.481000e-09</td>\n",
       "      <td>12990.0</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>11630.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4603</th>\n",
       "      <td>-30.60</td>\n",
       "      <td>-52.04</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5840</td>\n",
       "      <td>4</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>9.709000e-04</td>\n",
       "      <td>361900.0</td>\n",
       "      <td>1.316000e-02</td>\n",
       "      <td>8.701000e-08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4604</th>\n",
       "      <td>-30.94</td>\n",
       "      <td>-51.18</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5811</td>\n",
       "      <td>4</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>9.709000e-04</td>\n",
       "      <td>361900.0</td>\n",
       "      <td>1.316000e-02</td>\n",
       "      <td>8.701000e-08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4605</th>\n",
       "      <td>-31.27</td>\n",
       "      <td>-50.30</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5780</td>\n",
       "      <td>8</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>9.709000e-04</td>\n",
       "      <td>361900.0</td>\n",
       "      <td>1.316000e-02</td>\n",
       "      <td>8.701000e-08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4606</th>\n",
       "      <td>-31.60</td>\n",
       "      <td>-49.42</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5748</td>\n",
       "      <td>5</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>9.709000e-04</td>\n",
       "      <td>361900.0</td>\n",
       "      <td>1.316000e-02</td>\n",
       "      <td>8.701000e-08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4607</th>\n",
       "      <td>-31.92</td>\n",
       "      <td>-48.54</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.5714</td>\n",
       "      <td>8</td>\n",
       "      <td>1.136000e-07</td>\n",
       "      <td>9.709000e-04</td>\n",
       "      <td>361900.0</td>\n",
       "      <td>1.316000e-02</td>\n",
       "      <td>8.701000e-08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.682000e-04</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>7.239000e+01</td>\n",
       "      <td>5275000.0</td>\n",
       "      <td>66.940000</td>\n",
       "      <td>8091000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4608 rows × 271 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Lat centers [deg]   Lon centers [deg]   L   cos(SZA)   NStp  \\\n",
       "0                 -35.07              -54.58   1    -0.5142     15   \n",
       "1                 -35.45              -53.74   1    -0.5106     10   \n",
       "2                 -35.83              -52.90   1    -0.5070     13   \n",
       "3                 -36.20              -52.04   1    -0.5033      7   \n",
       "4                 -36.57              -51.18   1    -0.4995      8   \n",
       "...                  ...                 ...  ..        ...    ...   \n",
       "4603              -30.60              -52.04  72    -0.5840      4   \n",
       "4604              -30.94              -51.18  72    -0.5811      4   \n",
       "4605              -31.27              -50.30  72    -0.5780      8   \n",
       "4606              -31.60              -49.42  72    -0.5748      5   \n",
       "4607              -31.92              -48.54  72    -0.5714      8   \n",
       "\n",
       "              AERI        AONITA       CO2        INDIOL         ISALA  ...  \\\n",
       "0     2.307000e-15  2.925000e-09    2573.0  3.888000e-09  3.129000e-15  ...   \n",
       "1     2.968000e-14  2.943000e-09    2904.0  4.296000e-09  7.438000e-14  ...   \n",
       "2     4.825000e-13  3.619000e-09    4483.0  4.301000e-09  1.588000e-12  ...   \n",
       "3     2.615000e-12  3.679000e-09    4484.0  4.301000e-09  1.189000e-11  ...   \n",
       "4     2.416000e-11  3.687000e-09    4503.0  4.301000e-09  8.490000e-11  ...   \n",
       "...            ...           ...       ...           ...           ...  ...   \n",
       "4603  1.136000e-07  9.709000e-04  361900.0  1.316000e-02  8.701000e-08  ...   \n",
       "4604  1.136000e-07  9.709000e-04  361900.0  1.316000e-02  8.701000e-08  ...   \n",
       "4605  1.136000e-07  9.709000e-04  361900.0  1.316000e-02  8.701000e-08  ...   \n",
       "4606  1.136000e-07  9.709000e-04  361900.0  1.316000e-02  8.701000e-08  ...   \n",
       "4607  1.136000e-07  9.709000e-04  361900.0  1.316000e-02  8.701000e-08  ...   \n",
       "\n",
       "            SALCCL       NO3             O         Cl        SO2         Br  \\\n",
       "0     2.771000e-11     33.09  2.479000e-09     3745.0   0.000011     9545.0   \n",
       "1     2.795000e-11     33.56  2.481000e-09     4236.0   0.000013     9868.0   \n",
       "2     3.349000e-11     39.21  2.481000e-09    12970.0   0.000099    11570.0   \n",
       "3     3.350000e-11     39.35  2.481000e-09    12970.0   0.000099    11570.0   \n",
       "4     3.352000e-11     39.50  2.481000e-09    12990.0   0.000101    11630.0   \n",
       "...            ...       ...           ...        ...        ...        ...   \n",
       "4603  1.682000e-04  39460.00  7.239000e+01  5275000.0  66.940000  8091000.0   \n",
       "4604  1.682000e-04  39460.00  7.239000e+01  5275000.0  66.940000  8091000.0   \n",
       "4605  1.682000e-04  39460.00  7.239000e+01  5275000.0  66.940000  8091000.0   \n",
       "4606  1.682000e-04  39460.00  7.239000e+01  5275000.0  66.940000  8091000.0   \n",
       "4607  1.682000e-04  39460.00  7.239000e+01  5275000.0  66.940000  8091000.0   \n",
       "\n",
       "      H2  N2  O2  RCOOH  \n",
       "0    NaN NaN NaN    NaN  \n",
       "1    NaN NaN NaN    NaN  \n",
       "2    NaN NaN NaN    NaN  \n",
       "3    NaN NaN NaN    NaN  \n",
       "4    NaN NaN NaN    NaN  \n",
       "...   ..  ..  ..    ...  \n",
       "4603 NaN NaN NaN    NaN  \n",
       "4604 NaN NaN NaN    NaN  \n",
       "4605 NaN NaN NaN    NaN  \n",
       "4606 NaN NaN NaN    NaN  \n",
       "4607 NaN NaN NaN    NaN  \n",
       "\n",
       "[4608 rows x 271 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6777a242",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}