{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "center-vision",
   "metadata": {},
   "source": [
    "# Demo for using C3S intake catalog\n",
    "\n",
    "Intake Example:\n",
    "https://github.com/intake/intake-examples/blob/master/tutorial/data_scientist.ipynb\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "demographic-regulation",
   "metadata": {},
   "outputs": [],
   "source": [
    "import intake"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fewer-robert",
   "metadata": {},
   "source": [
    "## Open remote catalog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "becoming-theater",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['c3s-cmip5',\n",
       " 'c3s-cmip5-daily-pressure-level',\n",
       " 'c3s-cmip5-daily-single-level',\n",
       " 'c3s-cmip5-monthly-pressure-level',\n",
       " 'c3s-cmip5-monthly-single-level',\n",
       " 'c3s-cmip6',\n",
       " 'c3s-cmip6-decadal',\n",
       " 'c3s-cordex',\n",
       " 'c3s-ipcc-atlas']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_url = \"https://raw.githubusercontent.com/cp4cds/c3s_34g_manifests/master/intake/catalogs/c3s.yaml\"\n",
    "\n",
    "cat = intake.open_catalog(cat_url)\n",
    "list(cat)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "forced-article",
   "metadata": {},
   "source": [
    "## Load catalog for c3s-cmip6\n",
    "Catalogs will be cached locally in `~/.intake/cache`.\n",
    "\n",
    "See: https://intake.readthedocs.io/en/latest/catalog.html?highlight=simplecache#caching-source-files-locally"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ceramic-today",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>mip_era</th>\n",
       "      <th>activity_id</th>\n",
       "      <th>institution_id</th>\n",
       "      <th>source_id</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>member_id</th>\n",
       "      <th>table_id</th>\n",
       "      <th>variable_id</th>\n",
       "      <th>grid_label</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.MOHC.UKESM1-0-LL.ssp245....</td>\n",
       "      <td>ScenarioMIP/MOHC/UKESM1-0-LL/ssp245/r1i1p1f2/A...</td>\n",
       "      <td>28037112</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>UKESM1-0-LL</td>\n",
       "      <td>ssp245</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>ts</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20190507</td>\n",
       "      <td>2015-01-16T00:00:00</td>\n",
       "      <td>2049-12-16T00:00:00</td>\n",
       "      <td>0.94, -89.38, 359.06, 89.38</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.MOHC.UKESM1-0-LL.ssp245....</td>\n",
       "      <td>ScenarioMIP/MOHC/UKESM1-0-LL/ssp245/r1i1p1f2/A...</td>\n",
       "      <td>38838222</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>UKESM1-0-LL</td>\n",
       "      <td>ssp245</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>ts</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20190507</td>\n",
       "      <td>2050-01-16T00:00:00</td>\n",
       "      <td>2100-12-16T00:00:00</td>\n",
       "      <td>0.94, -89.38, 359.06, 89.38</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.NCAR.CESM2.ssp370.r4i1p1...</td>\n",
       "      <td>ScenarioMIP/NCAR/CESM2/ssp370/r4i1p1f1/Amon/pr...</td>\n",
       "      <td>104081588</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>NCAR</td>\n",
       "      <td>CESM2</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>Amon</td>\n",
       "      <td>pr</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20200528</td>\n",
       "      <td>2015-01-15T12:00:00</td>\n",
       "      <td>2064-12-15T12:00:00</td>\n",
       "      <td>0.00, -90.00, 358.75, 90.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.NCAR.CESM2.ssp370.r4i1p1...</td>\n",
       "      <td>ScenarioMIP/NCAR/CESM2/ssp370/r4i1p1f1/Amon/pr...</td>\n",
       "      <td>74977662</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>NCAR</td>\n",
       "      <td>CESM2</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>Amon</td>\n",
       "      <td>pr</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20200528</td>\n",
       "      <td>2065-01-15T12:00:00</td>\n",
       "      <td>2100-12-15T12:00:00</td>\n",
       "      <td>0.00, -90.00, 358.75, 90.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.AS-RCEC.TaiESM1.ssp370.r...</td>\n",
       "      <td>ScenarioMIP/AS-RCEC/TaiESM1/ssp370/r1i1p1f1/Am...</td>\n",
       "      <td>144277888</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>AS-RCEC</td>\n",
       "      <td>TaiESM1</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>Amon</td>\n",
       "      <td>rlut</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20201014</td>\n",
       "      <td>2015-01-16T12:00:00</td>\n",
       "      <td>2100-12-16T12:00:00</td>\n",
       "      <td>0.00, -90.00, 358.75, 90.00</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133154</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>204026121</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>tauu</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133155</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>164344947</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>rlus</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133156</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>3420481903</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>ua</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133157</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>143468073</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133158</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>86270014</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>prsn</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>133159 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    ds_id  \\\n",
       "0       c3s-cmip6.ScenarioMIP.MOHC.UKESM1-0-LL.ssp245....   \n",
       "1       c3s-cmip6.ScenarioMIP.MOHC.UKESM1-0-LL.ssp245....   \n",
       "2       c3s-cmip6.ScenarioMIP.NCAR.CESM2.ssp370.r4i1p1...   \n",
       "3       c3s-cmip6.ScenarioMIP.NCAR.CESM2.ssp370.r4i1p1...   \n",
       "4       c3s-cmip6.ScenarioMIP.AS-RCEC.TaiESM1.ssp370.r...   \n",
       "...                                                   ...   \n",
       "133154  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133155  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133156  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133157  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133158  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "\n",
       "                                                     path        size  \\\n",
       "0       ScenarioMIP/MOHC/UKESM1-0-LL/ssp245/r1i1p1f2/A...    28037112   \n",
       "1       ScenarioMIP/MOHC/UKESM1-0-LL/ssp245/r1i1p1f2/A...    38838222   \n",
       "2       ScenarioMIP/NCAR/CESM2/ssp370/r4i1p1f1/Amon/pr...   104081588   \n",
       "3       ScenarioMIP/NCAR/CESM2/ssp370/r4i1p1f1/Amon/pr...    74977662   \n",
       "4       ScenarioMIP/AS-RCEC/TaiESM1/ssp370/r1i1p1f1/Am...   144277888   \n",
       "...                                                   ...         ...   \n",
       "133154  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   204026121   \n",
       "133155  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   164344947   \n",
       "133156  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...  3420481903   \n",
       "133157  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   143468073   \n",
       "133158  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...    86270014   \n",
       "\n",
       "          mip_era  activity_id institution_id    source_id experiment_id  \\\n",
       "0       c3s-cmip6  ScenarioMIP           MOHC  UKESM1-0-LL        ssp245   \n",
       "1       c3s-cmip6  ScenarioMIP           MOHC  UKESM1-0-LL        ssp245   \n",
       "2       c3s-cmip6  ScenarioMIP           NCAR        CESM2        ssp370   \n",
       "3       c3s-cmip6  ScenarioMIP           NCAR        CESM2        ssp370   \n",
       "4       c3s-cmip6  ScenarioMIP        AS-RCEC      TaiESM1        ssp370   \n",
       "...           ...          ...            ...          ...           ...   \n",
       "133154  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133155  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133156  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133157  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133158  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "\n",
       "       member_id table_id variable_id grid_label    version  \\\n",
       "0       r1i1p1f2     Amon          ts         gn  v20190507   \n",
       "1       r1i1p1f2     Amon          ts         gn  v20190507   \n",
       "2       r4i1p1f1     Amon          pr         gn  v20200528   \n",
       "3       r4i1p1f1     Amon          pr         gn  v20200528   \n",
       "4       r1i1p1f1     Amon        rlut         gn  v20201014   \n",
       "...          ...      ...         ...        ...        ...   \n",
       "133154  r1i1p4f2     Amon        tauu         gn  v20220322   \n",
       "133155  r1i1p4f2     Amon        rlus         gn  v20220322   \n",
       "133156  r1i1p4f2     Amon          ua         gn  v20220322   \n",
       "133157  r1i1p4f2     Amon      tasmin         gn  v20220322   \n",
       "133158  r1i1p4f2     Amon        prsn         gn  v20220322   \n",
       "\n",
       "                 start_time             end_time                         bbox  \\\n",
       "0       2015-01-16T00:00:00  2049-12-16T00:00:00  0.94, -89.38, 359.06, 89.38   \n",
       "1       2050-01-16T00:00:00  2100-12-16T00:00:00  0.94, -89.38, 359.06, 89.38   \n",
       "2       2015-01-15T12:00:00  2064-12-15T12:00:00  0.00, -90.00, 358.75, 90.00   \n",
       "3       2065-01-15T12:00:00  2100-12-15T12:00:00  0.00, -90.00, 358.75, 90.00   \n",
       "4       2015-01-16T12:00:00  2100-12-16T12:00:00  0.00, -90.00, 358.75, 90.00   \n",
       "...                     ...                  ...                          ...   \n",
       "133154  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133155  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133156  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133157  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133158  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "\n",
       "                                                    level  \n",
       "0                                                     NaN  \n",
       "1                                                     NaN  \n",
       "2                                                     NaN  \n",
       "3                                                     NaN  \n",
       "4                                                     NaN  \n",
       "...                                                   ...  \n",
       "133154                                                NaN  \n",
       "133155                                                NaN  \n",
       "133156  100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...  \n",
       "133157                                               2.00  \n",
       "133158                                                NaN  \n",
       "\n",
       "[133159 rows x 17 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip6 = cat['c3s-cmip6'].read()\n",
    "df_cmip6"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "architectural-suspension",
   "metadata": {},
   "source": [
    "### Search dataset ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "important-algebra",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>mip_era</th>\n",
       "      <th>activity_id</th>\n",
       "      <th>institution_id</th>\n",
       "      <th>source_id</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>member_id</th>\n",
       "      <th>table_id</th>\n",
       "      <th>variable_id</th>\n",
       "      <th>grid_label</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>133127</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>143258359</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>tas</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133128</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>207232287</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>vas</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133129</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>144450061</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>ts</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133130</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>3085501617</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>hur</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133131</th>\n",
       "      <td>c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...</td>\n",
       "      <td>CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...</td>\n",
       "      <td>3717607962</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>MIROC</td>\n",
       "      <td>MIROC-ES2H</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p4f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>va</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20220322</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>0.00, -88.93, 358.59, 88.93</td>\n",
       "      <td>100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    ds_id  \\\n",
       "133127  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133128  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133129  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133130  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133131  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "\n",
       "                                                     path        size  \\\n",
       "133127  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   143258359   \n",
       "133128  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   207232287   \n",
       "133129  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   144450061   \n",
       "133130  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...  3085501617   \n",
       "133131  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...  3717607962   \n",
       "\n",
       "          mip_era activity_id institution_id   source_id experiment_id  \\\n",
       "133127  c3s-cmip6        CMIP          MIROC  MIROC-ES2H    historical   \n",
       "133128  c3s-cmip6        CMIP          MIROC  MIROC-ES2H    historical   \n",
       "133129  c3s-cmip6        CMIP          MIROC  MIROC-ES2H    historical   \n",
       "133130  c3s-cmip6        CMIP          MIROC  MIROC-ES2H    historical   \n",
       "133131  c3s-cmip6        CMIP          MIROC  MIROC-ES2H    historical   \n",
       "\n",
       "       member_id table_id variable_id grid_label    version  \\\n",
       "133127  r1i1p4f2     Amon         tas         gn  v20220322   \n",
       "133128  r1i1p4f2     Amon         vas         gn  v20220322   \n",
       "133129  r1i1p4f2     Amon          ts         gn  v20220322   \n",
       "133130  r1i1p4f2     Amon         hur         gn  v20220322   \n",
       "133131  r1i1p4f2     Amon          va         gn  v20220322   \n",
       "\n",
       "                 start_time             end_time                         bbox  \\\n",
       "133127  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133128  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133129  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133130  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133131  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "\n",
       "                                                    level  \n",
       "133127                                               2.00  \n",
       "133128                                              10.00  \n",
       "133129                                                NaN  \n",
       "133130  100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...  \n",
       "133131  100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cmip6.loc[\n",
    "    (df_cmip6.experiment_id==\"historical\")\n",
    "    & (df_cmip6.member_id==\"r1i1p4f2\")\n",
    "    & (df_cmip6.source_id==\"MIROC-ES2H\")\n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "maritime-association",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.tas.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.vas.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.ts.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.hur.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.va.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rsds.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.uas.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.ps.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.hfls.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.hfss.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rlut.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rsut.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.tauv.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.pr.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rsdt.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.tasmax.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.zg.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rlds.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.clt.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.hus.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.sfcWind.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.psl.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.ta.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.evspsbl.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.huss.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.hurs.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rsus.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.tauu.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.rlus.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.ua.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.tasmin.gn.v20220322',\n",
       "       'c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i1p4f2.Amon.prsn.gn.v20220322'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.ds_id.unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2967e076-00f6-4353-a287-5301b51f0dc3",
   "metadata": {},
   "source": [
    "## Load catalog for c3s-cmip6-decadal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0e1b6e47-c67b-4d7b-8aa1-efaae72a6ee3",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>mip_era</th>\n",
       "      <th>activity_id</th>\n",
       "      <th>institution_id</th>\n",
       "      <th>source_id</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>member_id</th>\n",
       "      <th>table_id</th>\n",
       "      <th>variable_id</th>\n",
       "      <th>grid_label</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "      <th>member_year</th>\n",
       "      <th>member_ensemble</th>\n",
       "      <th>prefix</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.MPI-M.MPI-ESM1-2-HR.dcp...</td>\n",
       "      <td>DCPP/MPI-M/MPI-ESM1-2-HR/dcppA-hindcast/s2016-...</td>\n",
       "      <td>492479692</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>MPI-M</td>\n",
       "      <td>MPI-ESM1-2-HR</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s2016-r8i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20210111</td>\n",
       "      <td>2016-11-01T12:00:00</td>\n",
       "      <td>2026-12-31T12:00:00</td>\n",
       "      <td>0.00, -89.28, 359.06, 89.28</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s2016</td>\n",
       "      <td>r8i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.MPI-M.MPI-ESM1-2-HR.dcp...</td>\n",
       "      <td>DCPP/MPI-M/MPI-ESM1-2-HR/dcppA-hindcast/s2009-...</td>\n",
       "      <td>737204109</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>MPI-M</td>\n",
       "      <td>MPI-ESM1-2-HR</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s2009-r8i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>pr</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20210107</td>\n",
       "      <td>2009-11-01T12:00:00</td>\n",
       "      <td>2019-12-31T12:00:00</td>\n",
       "      <td>0.00, -89.28, 359.06, 89.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>s2009</td>\n",
       "      <td>r8i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...</td>\n",
       "      <td>DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s1987...</td>\n",
       "      <td>953384</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>HadGEM3-GC31-MM</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1987-r3i1p1f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>pr</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20200417</td>\n",
       "      <td>1987-11-16T00:00:00</td>\n",
       "      <td>1987-12-16T00:00:00</td>\n",
       "      <td>0.42, -89.72, 359.58, 89.72</td>\n",
       "      <td>NaN</td>\n",
       "      <td>s1987</td>\n",
       "      <td>r3i1p1f2</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...</td>\n",
       "      <td>DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s1995...</td>\n",
       "      <td>603757</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>HadGEM3-GC31-MM</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1995-r6i1p1f2</td>\n",
       "      <td>Amon</td>\n",
       "      <td>tas</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20200417</td>\n",
       "      <td>1995-11-16T00:00:00</td>\n",
       "      <td>1995-12-16T00:00:00</td>\n",
       "      <td>0.42, -89.72, 359.58, 89.72</td>\n",
       "      <td>1.50</td>\n",
       "      <td>s1995</td>\n",
       "      <td>r6i1p1f2</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...</td>\n",
       "      <td>DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s2004...</td>\n",
       "      <td>14824913</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>HadGEM3-GC31-MM</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s2004-r10i1p1f2</td>\n",
       "      <td>AERday</td>\n",
       "      <td>zg500</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20200417</td>\n",
       "      <td>2004-11-01T12:00:00</td>\n",
       "      <td>2004-12-30T12:00:00</td>\n",
       "      <td>0.42, -89.72, 359.58, 89.72</td>\n",
       "      <td>50000.00</td>\n",
       "      <td>s2004</td>\n",
       "      <td>r10i1p1f2</td>\n",
       "      <td>c3s-cmip6-decadal</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>115225</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...</td>\n",
       "      <td>DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...</td>\n",
       "      <td>138842521</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>EC-Earth-Consortium</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1991-r7i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gr</td>\n",
       "      <td>v20201216</td>\n",
       "      <td>1997-11-01T12:00:00</td>\n",
       "      <td>1998-10-31T12:00:00</td>\n",
       "      <td>0.00, -89.46, 359.30, 89.46</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s1991</td>\n",
       "      <td>r7i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115226</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...</td>\n",
       "      <td>DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...</td>\n",
       "      <td>138881574</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>EC-Earth-Consortium</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1991-r7i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gr</td>\n",
       "      <td>v20201216</td>\n",
       "      <td>1998-11-01T12:00:00</td>\n",
       "      <td>1999-10-31T12:00:00</td>\n",
       "      <td>0.00, -89.46, 359.30, 89.46</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s1991</td>\n",
       "      <td>r7i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115227</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...</td>\n",
       "      <td>DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...</td>\n",
       "      <td>139375727</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>EC-Earth-Consortium</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1991-r7i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gr</td>\n",
       "      <td>v20201216</td>\n",
       "      <td>1999-11-01T12:00:00</td>\n",
       "      <td>2000-10-31T12:00:00</td>\n",
       "      <td>0.00, -89.46, 359.30, 89.46</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s1991</td>\n",
       "      <td>r7i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115228</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...</td>\n",
       "      <td>DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...</td>\n",
       "      <td>138971412</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>EC-Earth-Consortium</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1991-r7i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gr</td>\n",
       "      <td>v20201216</td>\n",
       "      <td>2000-11-01T12:00:00</td>\n",
       "      <td>2001-10-31T12:00:00</td>\n",
       "      <td>0.00, -89.46, 359.30, 89.46</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s1991</td>\n",
       "      <td>r7i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115229</th>\n",
       "      <td>c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...</td>\n",
       "      <td>DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...</td>\n",
       "      <td>138898806</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "      <td>DCPP</td>\n",
       "      <td>EC-Earth-Consortium</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>dcppA-hindcast</td>\n",
       "      <td>s1991-r7i1p1f1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmax</td>\n",
       "      <td>gr</td>\n",
       "      <td>v20201216</td>\n",
       "      <td>2001-11-01T12:00:00</td>\n",
       "      <td>2002-10-31T12:00:00</td>\n",
       "      <td>0.00, -89.46, 359.30, 89.46</td>\n",
       "      <td>2.00</td>\n",
       "      <td>s1991</td>\n",
       "      <td>r7i1p1f1</td>\n",
       "      <td>c3s-cmip6-decadal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115230 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    ds_id  \\\n",
       "0       c3s-cmip6-decadal.DCPP.MPI-M.MPI-ESM1-2-HR.dcp...   \n",
       "1       c3s-cmip6-decadal.DCPP.MPI-M.MPI-ESM1-2-HR.dcp...   \n",
       "2       c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...   \n",
       "3       c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...   \n",
       "4       c3s-cmip6-decadal.DCPP.MOHC.HadGEM3-GC31-MM.dc...   \n",
       "...                                                   ...   \n",
       "115225  c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...   \n",
       "115226  c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...   \n",
       "115227  c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...   \n",
       "115228  c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...   \n",
       "115229  c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-...   \n",
       "\n",
       "                                                     path       size  \\\n",
       "0       DCPP/MPI-M/MPI-ESM1-2-HR/dcppA-hindcast/s2016-...  492479692   \n",
       "1       DCPP/MPI-M/MPI-ESM1-2-HR/dcppA-hindcast/s2009-...  737204109   \n",
       "2       DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s1987...     953384   \n",
       "3       DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s1995...     603757   \n",
       "4       DCPP/MOHC/HadGEM3-GC31-MM/dcppA-hindcast/s2004...   14824913   \n",
       "...                                                   ...        ...   \n",
       "115225  DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...  138842521   \n",
       "115226  DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...  138881574   \n",
       "115227  DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...  139375727   \n",
       "115228  DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...  138971412   \n",
       "115229  DCPP/EC-Earth-Consortium/EC-Earth3/dcppA-hindc...  138898806   \n",
       "\n",
       "                  mip_era activity_id       institution_id        source_id  \\\n",
       "0       c3s-cmip6-decadal        DCPP                MPI-M    MPI-ESM1-2-HR   \n",
       "1       c3s-cmip6-decadal        DCPP                MPI-M    MPI-ESM1-2-HR   \n",
       "2       c3s-cmip6-decadal        DCPP                 MOHC  HadGEM3-GC31-MM   \n",
       "3       c3s-cmip6-decadal        DCPP                 MOHC  HadGEM3-GC31-MM   \n",
       "4       c3s-cmip6-decadal        DCPP                 MOHC  HadGEM3-GC31-MM   \n",
       "...                   ...         ...                  ...              ...   \n",
       "115225  c3s-cmip6-decadal        DCPP  EC-Earth-Consortium        EC-Earth3   \n",
       "115226  c3s-cmip6-decadal        DCPP  EC-Earth-Consortium        EC-Earth3   \n",
       "115227  c3s-cmip6-decadal        DCPP  EC-Earth-Consortium        EC-Earth3   \n",
       "115228  c3s-cmip6-decadal        DCPP  EC-Earth-Consortium        EC-Earth3   \n",
       "115229  c3s-cmip6-decadal        DCPP  EC-Earth-Consortium        EC-Earth3   \n",
       "\n",
       "         experiment_id        member_id table_id variable_id grid_label  \\\n",
       "0       dcppA-hindcast   s2016-r8i1p1f1      day      tasmax         gn   \n",
       "1       dcppA-hindcast   s2009-r8i1p1f1      day          pr         gn   \n",
       "2       dcppA-hindcast   s1987-r3i1p1f2     Amon          pr         gn   \n",
       "3       dcppA-hindcast   s1995-r6i1p1f2     Amon         tas         gn   \n",
       "4       dcppA-hindcast  s2004-r10i1p1f2   AERday       zg500         gn   \n",
       "...                ...              ...      ...         ...        ...   \n",
       "115225  dcppA-hindcast   s1991-r7i1p1f1      day      tasmax         gr   \n",
       "115226  dcppA-hindcast   s1991-r7i1p1f1      day      tasmax         gr   \n",
       "115227  dcppA-hindcast   s1991-r7i1p1f1      day      tasmax         gr   \n",
       "115228  dcppA-hindcast   s1991-r7i1p1f1      day      tasmax         gr   \n",
       "115229  dcppA-hindcast   s1991-r7i1p1f1      day      tasmax         gr   \n",
       "\n",
       "          version           start_time             end_time  \\\n",
       "0       v20210111  2016-11-01T12:00:00  2026-12-31T12:00:00   \n",
       "1       v20210107  2009-11-01T12:00:00  2019-12-31T12:00:00   \n",
       "2       v20200417  1987-11-16T00:00:00  1987-12-16T00:00:00   \n",
       "3       v20200417  1995-11-16T00:00:00  1995-12-16T00:00:00   \n",
       "4       v20200417  2004-11-01T12:00:00  2004-12-30T12:00:00   \n",
       "...           ...                  ...                  ...   \n",
       "115225  v20201216  1997-11-01T12:00:00  1998-10-31T12:00:00   \n",
       "115226  v20201216  1998-11-01T12:00:00  1999-10-31T12:00:00   \n",
       "115227  v20201216  1999-11-01T12:00:00  2000-10-31T12:00:00   \n",
       "115228  v20201216  2000-11-01T12:00:00  2001-10-31T12:00:00   \n",
       "115229  v20201216  2001-11-01T12:00:00  2002-10-31T12:00:00   \n",
       "\n",
       "                               bbox     level member_year member_ensemble  \\\n",
       "0       0.00, -89.28, 359.06, 89.28      2.00       s2016        r8i1p1f1   \n",
       "1       0.00, -89.28, 359.06, 89.28       NaN       s2009        r8i1p1f1   \n",
       "2       0.42, -89.72, 359.58, 89.72       NaN       s1987        r3i1p1f2   \n",
       "3       0.42, -89.72, 359.58, 89.72      1.50       s1995        r6i1p1f2   \n",
       "4       0.42, -89.72, 359.58, 89.72  50000.00       s2004       r10i1p1f2   \n",
       "...                             ...       ...         ...             ...   \n",
       "115225  0.00, -89.46, 359.30, 89.46      2.00       s1991        r7i1p1f1   \n",
       "115226  0.00, -89.46, 359.30, 89.46      2.00       s1991        r7i1p1f1   \n",
       "115227  0.00, -89.46, 359.30, 89.46      2.00       s1991        r7i1p1f1   \n",
       "115228  0.00, -89.46, 359.30, 89.46      2.00       s1991        r7i1p1f1   \n",
       "115229  0.00, -89.46, 359.30, 89.46      2.00       s1991        r7i1p1f1   \n",
       "\n",
       "                   prefix  \n",
       "0       c3s-cmip6-decadal  \n",
       "1       c3s-cmip6-decadal  \n",
       "2       c3s-cmip6-decadal  \n",
       "3       c3s-cmip6-decadal  \n",
       "4       c3s-cmip6-decadal  \n",
       "...                   ...  \n",
       "115225  c3s-cmip6-decadal  \n",
       "115226  c3s-cmip6-decadal  \n",
       "115227  c3s-cmip6-decadal  \n",
       "115228  c3s-cmip6-decadal  \n",
       "115229  c3s-cmip6-decadal  \n",
       "\n",
       "[115230 rows x 20 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip6_decadal = cat['c3s-cmip6-decadal'].read()\n",
    "df_cmip6_decadal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9f40de66-b9ad-4062-885d-543d30574f37",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ds_id               10\n",
       "path               110\n",
       "size               109\n",
       "mip_era              1\n",
       "activity_id          1\n",
       "institution_id       1\n",
       "source_id            1\n",
       "experiment_id        1\n",
       "member_id           10\n",
       "table_id             1\n",
       "variable_id          1\n",
       "grid_label           1\n",
       "version              2\n",
       "start_time          11\n",
       "end_time            11\n",
       "bbox                 1\n",
       "level                1\n",
       "member_year          1\n",
       "member_ensemble     10\n",
       "prefix               1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cmip6_decadal.loc[\n",
    "    (df_cmip6_decadal.variable_id==\"tas\") \n",
    "    & (df_cmip6_decadal.experiment_id==\"dcppA-hindcast\")\n",
    "    & (df_cmip6_decadal.table_id==\"Amon\")\n",
    "    & (df_cmip6_decadal.institution_id==\"EC-Earth-Consortium\")\n",
    "    & (df_cmip6_decadal.member_year==\"s1995\")\n",
    "]\n",
    "df.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0208c132-dc03-46d9-b2bd-56f4296b02ec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r10i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r1i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r2i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r3i1p1f1.Amon.tas.gr.v20201215',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r4i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r5i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r6i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r7i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r8i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216',\n",
       " 'c3s-cmip6-decadal.DCPP.EC-Earth-Consortium.EC-Earth3.dcppA-hindcast.s1995-r9i1p1f1.Amon.tas.gr.v20201216']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds_ids = list(df.ds_id)\n",
    "ds_ids.sort()\n",
    "ds_ids"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "159209e3-bb6d-4280-8c44-240de51d28bf",
   "metadata": {},
   "source": [
    "## Load Catalog for C3S-CORDEX"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d04937d7-744b-45db-876a-ae487751b0ab",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>project</th>\n",
       "      <th>product</th>\n",
       "      <th>domain</th>\n",
       "      <th>institute</th>\n",
       "      <th>driving_model</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>ensemble</th>\n",
       "      <th>rcm_name</th>\n",
       "      <th>rcm_version</th>\n",
       "      <th>time_frequency</th>\n",
       "      <th>variable</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...</td>\n",
       "      <td>output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...</td>\n",
       "      <td>176452637</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EAS-44</td>\n",
       "      <td>CLMcom</td>\n",
       "      <td>CNRM-CERFACS-CNRM-CM5</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>CLMcom-CCLM5-0-2</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>huss</td>\n",
       "      <td>v20201215</td>\n",
       "      <td>2006-01-01T12:00:00</td>\n",
       "      <td>2010-12-31T12:00:00</td>\n",
       "      <td>63.36, -18.23, 175.13, 58.59</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...</td>\n",
       "      <td>output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...</td>\n",
       "      <td>176393262</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EAS-44</td>\n",
       "      <td>CLMcom</td>\n",
       "      <td>CNRM-CERFACS-CNRM-CM5</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>CLMcom-CCLM5-0-2</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>huss</td>\n",
       "      <td>v20201215</td>\n",
       "      <td>2011-01-01T12:00:00</td>\n",
       "      <td>2015-12-31T12:00:00</td>\n",
       "      <td>63.36, -18.23, 175.13, 58.59</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...</td>\n",
       "      <td>output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...</td>\n",
       "      <td>176557045</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EAS-44</td>\n",
       "      <td>CLMcom</td>\n",
       "      <td>CNRM-CERFACS-CNRM-CM5</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>CLMcom-CCLM5-0-2</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>huss</td>\n",
       "      <td>v20201215</td>\n",
       "      <td>2016-01-01T12:00:00</td>\n",
       "      <td>2020-12-31T12:00:00</td>\n",
       "      <td>63.36, -18.23, 175.13, 58.59</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...</td>\n",
       "      <td>output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...</td>\n",
       "      <td>176346476</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EAS-44</td>\n",
       "      <td>CLMcom</td>\n",
       "      <td>CNRM-CERFACS-CNRM-CM5</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>CLMcom-CCLM5-0-2</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>huss</td>\n",
       "      <td>v20201215</td>\n",
       "      <td>2021-01-01T12:00:00</td>\n",
       "      <td>2025-12-31T12:00:00</td>\n",
       "      <td>63.36, -18.23, 175.13, 58.59</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...</td>\n",
       "      <td>output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...</td>\n",
       "      <td>176260737</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EAS-44</td>\n",
       "      <td>CLMcom</td>\n",
       "      <td>CNRM-CERFACS-CNRM-CM5</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>CLMcom-CCLM5-0-2</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>huss</td>\n",
       "      <td>v20201215</td>\n",
       "      <td>2026-01-01T12:00:00</td>\n",
       "      <td>2030-12-31T12:00:00</td>\n",
       "      <td>63.36, -18.23, 175.13, 58.59</td>\n",
       "      <td>10.00</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567374</th>\n",
       "      <td>c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...</td>\n",
       "      <td>output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...</td>\n",
       "      <td>60776141</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>CAM-44</td>\n",
       "      <td>SMHI</td>\n",
       "      <td>ICHEC-EC-EARTH</td>\n",
       "      <td>historical</td>\n",
       "      <td>r12i1p1</td>\n",
       "      <td>SMHI-RCA4</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>v20201201</td>\n",
       "      <td>1981-01-01T12:00:00</td>\n",
       "      <td>1985-12-31T12:00:00</td>\n",
       "      <td>-127.58, -19.46, -19.41, 46.38</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567375</th>\n",
       "      <td>c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...</td>\n",
       "      <td>output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...</td>\n",
       "      <td>60562273</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>CAM-44</td>\n",
       "      <td>SMHI</td>\n",
       "      <td>ICHEC-EC-EARTH</td>\n",
       "      <td>historical</td>\n",
       "      <td>r12i1p1</td>\n",
       "      <td>SMHI-RCA4</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>v20201201</td>\n",
       "      <td>1986-01-01T12:00:00</td>\n",
       "      <td>1990-12-31T12:00:00</td>\n",
       "      <td>-127.58, -19.46, -19.41, 46.38</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567376</th>\n",
       "      <td>c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...</td>\n",
       "      <td>output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...</td>\n",
       "      <td>60779301</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>CAM-44</td>\n",
       "      <td>SMHI</td>\n",
       "      <td>ICHEC-EC-EARTH</td>\n",
       "      <td>historical</td>\n",
       "      <td>r12i1p1</td>\n",
       "      <td>SMHI-RCA4</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>v20201201</td>\n",
       "      <td>1991-01-01T12:00:00</td>\n",
       "      <td>1995-12-31T12:00:00</td>\n",
       "      <td>-127.58, -19.46, -19.41, 46.38</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567377</th>\n",
       "      <td>c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...</td>\n",
       "      <td>output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...</td>\n",
       "      <td>60957749</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>CAM-44</td>\n",
       "      <td>SMHI</td>\n",
       "      <td>ICHEC-EC-EARTH</td>\n",
       "      <td>historical</td>\n",
       "      <td>r12i1p1</td>\n",
       "      <td>SMHI-RCA4</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>v20201201</td>\n",
       "      <td>1996-01-01T12:00:00</td>\n",
       "      <td>2000-12-31T12:00:00</td>\n",
       "      <td>-127.58, -19.46, -19.41, 46.38</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567378</th>\n",
       "      <td>c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...</td>\n",
       "      <td>output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...</td>\n",
       "      <td>60801923</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>CAM-44</td>\n",
       "      <td>SMHI</td>\n",
       "      <td>ICHEC-EC-EARTH</td>\n",
       "      <td>historical</td>\n",
       "      <td>r12i1p1</td>\n",
       "      <td>SMHI-RCA4</td>\n",
       "      <td>v1</td>\n",
       "      <td>day</td>\n",
       "      <td>tasmin</td>\n",
       "      <td>v20201201</td>\n",
       "      <td>2001-01-01T12:00:00</td>\n",
       "      <td>2005-12-31T12:00:00</td>\n",
       "      <td>-127.58, -19.46, -19.41, 46.38</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>567379 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    ds_id  \\\n",
       "0       c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...   \n",
       "1       c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...   \n",
       "2       c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...   \n",
       "3       c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...   \n",
       "4       c3s-cordex.output.EAS-44.CLMcom.CNRM-CERFACS-C...   \n",
       "...                                                   ...   \n",
       "567374  c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...   \n",
       "567375  c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...   \n",
       "567376  c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...   \n",
       "567377  c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...   \n",
       "567378  c3s-cordex.output.CAM-44.SMHI.ICHEC-EC-EARTH.h...   \n",
       "\n",
       "                                                     path       size  \\\n",
       "0       output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...  176452637   \n",
       "1       output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...  176393262   \n",
       "2       output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...  176557045   \n",
       "3       output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...  176346476   \n",
       "4       output/EAS-44/CLMcom/CNRM-CERFACS-CNRM-CM5/rcp...  176260737   \n",
       "...                                                   ...        ...   \n",
       "567374  output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...   60776141   \n",
       "567375  output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...   60562273   \n",
       "567376  output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...   60779301   \n",
       "567377  output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...   60957749   \n",
       "567378  output/CAM-44/SMHI/ICHEC-EC-EARTH/historical/r...   60801923   \n",
       "\n",
       "           project product  domain institute          driving_model  \\\n",
       "0       c3s-cordex  output  EAS-44    CLMcom  CNRM-CERFACS-CNRM-CM5   \n",
       "1       c3s-cordex  output  EAS-44    CLMcom  CNRM-CERFACS-CNRM-CM5   \n",
       "2       c3s-cordex  output  EAS-44    CLMcom  CNRM-CERFACS-CNRM-CM5   \n",
       "3       c3s-cordex  output  EAS-44    CLMcom  CNRM-CERFACS-CNRM-CM5   \n",
       "4       c3s-cordex  output  EAS-44    CLMcom  CNRM-CERFACS-CNRM-CM5   \n",
       "...            ...     ...     ...       ...                    ...   \n",
       "567374  c3s-cordex  output  CAM-44      SMHI         ICHEC-EC-EARTH   \n",
       "567375  c3s-cordex  output  CAM-44      SMHI         ICHEC-EC-EARTH   \n",
       "567376  c3s-cordex  output  CAM-44      SMHI         ICHEC-EC-EARTH   \n",
       "567377  c3s-cordex  output  CAM-44      SMHI         ICHEC-EC-EARTH   \n",
       "567378  c3s-cordex  output  CAM-44      SMHI         ICHEC-EC-EARTH   \n",
       "\n",
       "       experiment_id ensemble          rcm_name rcm_version time_frequency  \\\n",
       "0              rcp45   r1i1p1  CLMcom-CCLM5-0-2          v1            day   \n",
       "1              rcp45   r1i1p1  CLMcom-CCLM5-0-2          v1            day   \n",
       "2              rcp45   r1i1p1  CLMcom-CCLM5-0-2          v1            day   \n",
       "3              rcp45   r1i1p1  CLMcom-CCLM5-0-2          v1            day   \n",
       "4              rcp45   r1i1p1  CLMcom-CCLM5-0-2          v1            day   \n",
       "...              ...      ...               ...         ...            ...   \n",
       "567374    historical  r12i1p1         SMHI-RCA4          v1            day   \n",
       "567375    historical  r12i1p1         SMHI-RCA4          v1            day   \n",
       "567376    historical  r12i1p1         SMHI-RCA4          v1            day   \n",
       "567377    historical  r12i1p1         SMHI-RCA4          v1            day   \n",
       "567378    historical  r12i1p1         SMHI-RCA4          v1            day   \n",
       "\n",
       "       variable    version           start_time             end_time  \\\n",
       "0          huss  v20201215  2006-01-01T12:00:00  2010-12-31T12:00:00   \n",
       "1          huss  v20201215  2011-01-01T12:00:00  2015-12-31T12:00:00   \n",
       "2          huss  v20201215  2016-01-01T12:00:00  2020-12-31T12:00:00   \n",
       "3          huss  v20201215  2021-01-01T12:00:00  2025-12-31T12:00:00   \n",
       "4          huss  v20201215  2026-01-01T12:00:00  2030-12-31T12:00:00   \n",
       "...         ...        ...                  ...                  ...   \n",
       "567374   tasmin  v20201201  1981-01-01T12:00:00  1985-12-31T12:00:00   \n",
       "567375   tasmin  v20201201  1986-01-01T12:00:00  1990-12-31T12:00:00   \n",
       "567376   tasmin  v20201201  1991-01-01T12:00:00  1995-12-31T12:00:00   \n",
       "567377   tasmin  v20201201  1996-01-01T12:00:00  2000-12-31T12:00:00   \n",
       "567378   tasmin  v20201201  2001-01-01T12:00:00  2005-12-31T12:00:00   \n",
       "\n",
       "                                  bbox  level  \n",
       "0         63.36, -18.23, 175.13, 58.59  10.00  \n",
       "1         63.36, -18.23, 175.13, 58.59  10.00  \n",
       "2         63.36, -18.23, 175.13, 58.59  10.00  \n",
       "3         63.36, -18.23, 175.13, 58.59  10.00  \n",
       "4         63.36, -18.23, 175.13, 58.59  10.00  \n",
       "...                                ...    ...  \n",
       "567374  -127.58, -19.46, -19.41, 46.38   2.00  \n",
       "567375  -127.58, -19.46, -19.41, 46.38   2.00  \n",
       "567376  -127.58, -19.46, -19.41, 46.38   2.00  \n",
       "567377  -127.58, -19.46, -19.41, 46.38   2.00  \n",
       "567378  -127.58, -19.46, -19.41, 46.38   2.00  \n",
       "\n",
       "[567379 rows x 19 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cordex = cat['c3s-cordex'].read()\n",
    "df_cordex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "46ec77bb-ce85-4b52-96bb-3e5bb81dabf6",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>project</th>\n",
       "      <th>product</th>\n",
       "      <th>domain</th>\n",
       "      <th>institute</th>\n",
       "      <th>driving_model</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>ensemble</th>\n",
       "      <th>rcm_name</th>\n",
       "      <th>rcm_version</th>\n",
       "      <th>time_frequency</th>\n",
       "      <th>variable</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11817</th>\n",
       "      <td>c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....</td>\n",
       "      <td>output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...</td>\n",
       "      <td>27812779</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EUR-11</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>MOHC-HadGEM2-ES</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>MOHC-HadREM3-GA7-05</td>\n",
       "      <td>v1</td>\n",
       "      <td>mon</td>\n",
       "      <td>tas</td>\n",
       "      <td>v20200330</td>\n",
       "      <td>2005-12-16T00:00:00</td>\n",
       "      <td>2010-12-16T00:00:00</td>\n",
       "      <td>-44.59, 21.99, 64.96, 72.59</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11818</th>\n",
       "      <td>c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....</td>\n",
       "      <td>output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...</td>\n",
       "      <td>46090612</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EUR-11</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>MOHC-HadGEM2-ES</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>MOHC-HadREM3-GA7-05</td>\n",
       "      <td>v1</td>\n",
       "      <td>mon</td>\n",
       "      <td>tas</td>\n",
       "      <td>v20200330</td>\n",
       "      <td>2011-01-16T00:00:00</td>\n",
       "      <td>2020-12-16T00:00:00</td>\n",
       "      <td>-44.59, 21.99, 64.96, 72.59</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11819</th>\n",
       "      <td>c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....</td>\n",
       "      <td>output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...</td>\n",
       "      <td>46067468</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EUR-11</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>MOHC-HadGEM2-ES</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>MOHC-HadREM3-GA7-05</td>\n",
       "      <td>v1</td>\n",
       "      <td>mon</td>\n",
       "      <td>tas</td>\n",
       "      <td>v20200330</td>\n",
       "      <td>2021-01-16T00:00:00</td>\n",
       "      <td>2030-12-16T00:00:00</td>\n",
       "      <td>-44.59, 21.99, 64.96, 72.59</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11820</th>\n",
       "      <td>c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....</td>\n",
       "      <td>output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...</td>\n",
       "      <td>46059570</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EUR-11</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>MOHC-HadGEM2-ES</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>MOHC-HadREM3-GA7-05</td>\n",
       "      <td>v1</td>\n",
       "      <td>mon</td>\n",
       "      <td>tas</td>\n",
       "      <td>v20200330</td>\n",
       "      <td>2031-01-16T00:00:00</td>\n",
       "      <td>2040-12-16T00:00:00</td>\n",
       "      <td>-44.59, 21.99, 64.96, 72.59</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11821</th>\n",
       "      <td>c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....</td>\n",
       "      <td>output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...</td>\n",
       "      <td>46034891</td>\n",
       "      <td>c3s-cordex</td>\n",
       "      <td>output</td>\n",
       "      <td>EUR-11</td>\n",
       "      <td>MOHC</td>\n",
       "      <td>MOHC-HadGEM2-ES</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>r1i1p1</td>\n",
       "      <td>MOHC-HadREM3-GA7-05</td>\n",
       "      <td>v1</td>\n",
       "      <td>mon</td>\n",
       "      <td>tas</td>\n",
       "      <td>v20200330</td>\n",
       "      <td>2041-01-16T00:00:00</td>\n",
       "      <td>2050-12-16T00:00:00</td>\n",
       "      <td>-44.59, 21.99, 64.96, 72.59</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   ds_id  \\\n",
       "11817  c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....   \n",
       "11818  c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....   \n",
       "11819  c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....   \n",
       "11820  c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....   \n",
       "11821  c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES....   \n",
       "\n",
       "                                                    path      size  \\\n",
       "11817  output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...  27812779   \n",
       "11818  output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...  46090612   \n",
       "11819  output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...  46067468   \n",
       "11820  output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...  46059570   \n",
       "11821  output/EUR-11/MOHC/MOHC-HadGEM2-ES/rcp85/r1i1p...  46034891   \n",
       "\n",
       "          project product  domain institute    driving_model experiment_id  \\\n",
       "11817  c3s-cordex  output  EUR-11      MOHC  MOHC-HadGEM2-ES         rcp85   \n",
       "11818  c3s-cordex  output  EUR-11      MOHC  MOHC-HadGEM2-ES         rcp85   \n",
       "11819  c3s-cordex  output  EUR-11      MOHC  MOHC-HadGEM2-ES         rcp85   \n",
       "11820  c3s-cordex  output  EUR-11      MOHC  MOHC-HadGEM2-ES         rcp85   \n",
       "11821  c3s-cordex  output  EUR-11      MOHC  MOHC-HadGEM2-ES         rcp85   \n",
       "\n",
       "      ensemble             rcm_name rcm_version time_frequency variable  \\\n",
       "11817   r1i1p1  MOHC-HadREM3-GA7-05          v1            mon      tas   \n",
       "11818   r1i1p1  MOHC-HadREM3-GA7-05          v1            mon      tas   \n",
       "11819   r1i1p1  MOHC-HadREM3-GA7-05          v1            mon      tas   \n",
       "11820   r1i1p1  MOHC-HadREM3-GA7-05          v1            mon      tas   \n",
       "11821   r1i1p1  MOHC-HadREM3-GA7-05          v1            mon      tas   \n",
       "\n",
       "         version           start_time             end_time  \\\n",
       "11817  v20200330  2005-12-16T00:00:00  2010-12-16T00:00:00   \n",
       "11818  v20200330  2011-01-16T00:00:00  2020-12-16T00:00:00   \n",
       "11819  v20200330  2021-01-16T00:00:00  2030-12-16T00:00:00   \n",
       "11820  v20200330  2031-01-16T00:00:00  2040-12-16T00:00:00   \n",
       "11821  v20200330  2041-01-16T00:00:00  2050-12-16T00:00:00   \n",
       "\n",
       "                              bbox level  \n",
       "11817  -44.59, 21.99, 64.96, 72.59  1.50  \n",
       "11818  -44.59, 21.99, 64.96, 72.59  1.50  \n",
       "11819  -44.59, 21.99, 64.96, 72.59  1.50  \n",
       "11820  -44.59, 21.99, 64.96, 72.59  1.50  \n",
       "11821  -44.59, 21.99, 64.96, 72.59  1.50  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cordex.loc[\n",
    "    (df_cordex.variable==\"tas\") \n",
    "    & (df_cordex.experiment_id==\"rcp85\")\n",
    "    & (df_cordex.domain==\"EUR-11\")\n",
    "    & (df_cordex.time_frequency==\"mon\")\n",
    "    & (df_cordex.driving_model==\"MOHC-HadGEM2-ES\")\n",
    "    & (df_cordex.ensemble==\"r1i1p1\")\n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8f5fb385-f19b-4263-8b6a-ba71316307e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'c3s-cordex.output.EUR-11.MOHC.MOHC-HadGEM2-ES.rcp85.r1i1p1.MOHC-HadREM3-GA7-05.v1.mon.tas.v20200330'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection = df.ds_id.unique()[0]\n",
    "collection"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b706e525-4a39-4eaf-b3ed-a3a86ffba534",
   "metadata": {},
   "source": [
    "## Load Catalog for C3S-CMIP5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "34858887-9592-4e73-8cb6-30e0bed63671",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>project</th>\n",
       "      <th>product</th>\n",
       "      <th>institute</th>\n",
       "      <th>model</th>\n",
       "      <th>experiment</th>\n",
       "      <th>time_frequency</th>\n",
       "      <th>realm</th>\n",
       "      <th>...</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "      <th>units</th>\n",
       "      <th>variable_name</th>\n",
       "      <th>description</th>\n",
       "      <th>url</th>\n",
       "      <th>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1</td>\n",
       "      <td>amip</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>1979-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Total cloud fraction (clt)</td>\n",
       "      <td>Total refers to the whole atmosphere column, a...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1</td>\n",
       "      <td>amip</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>1979-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>kg.m^-2.s^-1</td>\n",
       "      <td>Evaporation (evspsbl)</td>\n",
       "      <td>Evaporation rate. It includes conversion to va...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1</td>\n",
       "      <td>amip</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>1979-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W.m^-2</td>\n",
       "      <td>Surface latent heat flux (hfls)</td>\n",
       "      <td>Flux per unit area of heat between the surface...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1</td>\n",
       "      <td>amip</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>1979-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W.m^-2</td>\n",
       "      <td>Surface sensible heat flux (hfss)</td>\n",
       "      <td>Flux per unit area of heat between the surface...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1</td>\n",
       "      <td>amip</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>1979-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>kg.m-^2.s^-1</td>\n",
       "      <td>Snowfall flux (prsn)</td>\n",
       "      <td>Mass of water in the form of snow precipitatin...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</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>171682</th>\n",
       "      <td>c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...</td>\n",
       "      <td>output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>NOAA-GFDL</td>\n",
       "      <td>GFDL-HIRAM-C360</td>\n",
       "      <td>amip</td>\n",
       "      <td>day</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20110601</td>\n",
       "      <td>2004-01-01T12:00:00</td>\n",
       "      <td>2004-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>m</td>\n",
       "      <td>Geopotential height (zg)</td>\n",
       "      <td>Gravitational potential energy per unit mass n...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-daily-pressure-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171683</th>\n",
       "      <td>c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...</td>\n",
       "      <td>output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>NOAA-GFDL</td>\n",
       "      <td>GFDL-HIRAM-C360</td>\n",
       "      <td>amip</td>\n",
       "      <td>day</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20110601</td>\n",
       "      <td>2005-01-01T12:00:00</td>\n",
       "      <td>2005-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>m</td>\n",
       "      <td>Geopotential height (zg)</td>\n",
       "      <td>Gravitational potential energy per unit mass n...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-daily-pressure-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171684</th>\n",
       "      <td>c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...</td>\n",
       "      <td>output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>NOAA-GFDL</td>\n",
       "      <td>GFDL-HIRAM-C360</td>\n",
       "      <td>amip</td>\n",
       "      <td>day</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20110601</td>\n",
       "      <td>2006-01-01T12:00:00</td>\n",
       "      <td>2006-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>m</td>\n",
       "      <td>Geopotential height (zg)</td>\n",
       "      <td>Gravitational potential energy per unit mass n...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-daily-pressure-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171685</th>\n",
       "      <td>c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...</td>\n",
       "      <td>output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>NOAA-GFDL</td>\n",
       "      <td>GFDL-HIRAM-C360</td>\n",
       "      <td>amip</td>\n",
       "      <td>day</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20110601</td>\n",
       "      <td>2007-01-01T12:00:00</td>\n",
       "      <td>2007-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>m</td>\n",
       "      <td>Geopotential height (zg)</td>\n",
       "      <td>Gravitational potential energy per unit mass n...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-daily-pressure-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171686</th>\n",
       "      <td>c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...</td>\n",
       "      <td>output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>NOAA-GFDL</td>\n",
       "      <td>GFDL-HIRAM-C360</td>\n",
       "      <td>amip</td>\n",
       "      <td>day</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20110601</td>\n",
       "      <td>2008-01-01T12:00:00</td>\n",
       "      <td>2008-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>m</td>\n",
       "      <td>Geopotential height (zg)</td>\n",
       "      <td>Gravitational potential energy per unit mass n...</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-daily-pressure-level</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>171687 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    ds_id  \\\n",
       "0       c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...   \n",
       "1       c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...   \n",
       "2       c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...   \n",
       "3       c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...   \n",
       "4       c3s-cmip5.output1.BCC.bcc-csm1-1.amip.mon.atmo...   \n",
       "...                                                   ...   \n",
       "171682  c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...   \n",
       "171683  c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...   \n",
       "171684  c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...   \n",
       "171685  c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...   \n",
       "171686  c3s-cmip5.output1.NOAA-GFDL.GFDL-HIRAM-C360.am...   \n",
       "\n",
       "                                                     path  size    project  \\\n",
       "0       output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...   NaN  c3s-cmip5   \n",
       "1       output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...   NaN  c3s-cmip5   \n",
       "2       output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...   NaN  c3s-cmip5   \n",
       "3       output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...   NaN  c3s-cmip5   \n",
       "4       output1/BCC/bcc-csm1-1/amip/mon/atmos/Amon/r1i...   NaN  c3s-cmip5   \n",
       "...                                                   ...   ...        ...   \n",
       "171682  output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...   NaN  c3s-cmip5   \n",
       "171683  output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...   NaN  c3s-cmip5   \n",
       "171684  output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...   NaN  c3s-cmip5   \n",
       "171685  output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...   NaN  c3s-cmip5   \n",
       "171686  output1/NOAA-GFDL/GFDL-HIRAM-C360/amip/day/atm...   NaN  c3s-cmip5   \n",
       "\n",
       "        product  institute            model experiment time_frequency  realm  \\\n",
       "0       output1        BCC       bcc-csm1-1       amip            mon  atmos   \n",
       "1       output1        BCC       bcc-csm1-1       amip            mon  atmos   \n",
       "2       output1        BCC       bcc-csm1-1       amip            mon  atmos   \n",
       "3       output1        BCC       bcc-csm1-1       amip            mon  atmos   \n",
       "4       output1        BCC       bcc-csm1-1       amip            mon  atmos   \n",
       "...         ...        ...              ...        ...            ...    ...   \n",
       "171682  output1  NOAA-GFDL  GFDL-HIRAM-C360       amip            day  atmos   \n",
       "171683  output1  NOAA-GFDL  GFDL-HIRAM-C360       amip            day  atmos   \n",
       "171684  output1  NOAA-GFDL  GFDL-HIRAM-C360       amip            day  atmos   \n",
       "171685  output1  NOAA-GFDL  GFDL-HIRAM-C360       amip            day  atmos   \n",
       "171686  output1  NOAA-GFDL  GFDL-HIRAM-C360       amip            day  atmos   \n",
       "\n",
       "        ...    version           start_time             end_time bbox level  \\\n",
       "0       ...  v20181201  1979-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "1       ...  v20181201  1979-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "2       ...  v20181201  1979-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "3       ...  v20181201  1979-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "4       ...  v20181201  1979-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "...     ...        ...                  ...                  ...  ...   ...   \n",
       "171682  ...  v20110601  2004-01-01T12:00:00  2004-12-31T12:00:00  NaN   NaN   \n",
       "171683  ...  v20110601  2005-01-01T12:00:00  2005-12-31T12:00:00  NaN   NaN   \n",
       "171684  ...  v20110601  2006-01-01T12:00:00  2006-12-31T12:00:00  NaN   NaN   \n",
       "171685  ...  v20110601  2007-01-01T12:00:00  2007-12-31T12:00:00  NaN   NaN   \n",
       "171686  ...  v20110601  2008-01-01T12:00:00  2008-12-31T12:00:00  NaN   NaN   \n",
       "\n",
       "               units                      variable_name  \\\n",
       "0                  1         Total cloud fraction (clt)   \n",
       "1       kg.m^-2.s^-1              Evaporation (evspsbl)   \n",
       "2             W.m^-2    Surface latent heat flux (hfls)   \n",
       "3             W.m^-2  Surface sensible heat flux (hfss)   \n",
       "4       kg.m-^2.s^-1               Snowfall flux (prsn)   \n",
       "...              ...                                ...   \n",
       "171682             m           Geopotential height (zg)   \n",
       "171683             m           Geopotential height (zg)   \n",
       "171684             m           Geopotential height (zg)   \n",
       "171685             m           Geopotential height (zg)   \n",
       "171686             m           Geopotential height (zg)   \n",
       "\n",
       "                                              description  \\\n",
       "0       Total refers to the whole atmosphere column, a...   \n",
       "1       Evaporation rate. It includes conversion to va...   \n",
       "2       Flux per unit area of heat between the surface...   \n",
       "3       Flux per unit area of heat between the surface...   \n",
       "4       Mass of water in the form of snow precipitatin...   \n",
       "...                                                   ...   \n",
       "171682  Gravitational potential energy per unit mass n...   \n",
       "171683  Gravitational potential energy per unit mass n...   \n",
       "171684  Gravitational potential energy per unit mass n...   \n",
       "171685  Gravitational potential energy per unit mass n...   \n",
       "171686  Gravitational potential energy per unit mass n...   \n",
       "\n",
       "                                                      url  \\\n",
       "0       https://data.mips.copernicus-climate.eu/thredd...   \n",
       "1       https://data.mips.copernicus-climate.eu/thredd...   \n",
       "2       https://data.mips.copernicus-climate.eu/thredd...   \n",
       "3       https://data.mips.copernicus-climate.eu/thredd...   \n",
       "4       https://data.mips.copernicus-climate.eu/thredd...   \n",
       "...                                                   ...   \n",
       "171682  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "171683  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "171684  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "171685  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "171686  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "\n",
       "                             label  \n",
       "0       cmip5-monthly-single-level  \n",
       "1       cmip5-monthly-single-level  \n",
       "2       cmip5-monthly-single-level  \n",
       "3       cmip5-monthly-single-level  \n",
       "4       cmip5-monthly-single-level  \n",
       "...                            ...  \n",
       "171682  cmip5-daily-pressure-level  \n",
       "171683  cmip5-daily-pressure-level  \n",
       "171684  cmip5-daily-pressure-level  \n",
       "171685  cmip5-daily-pressure-level  \n",
       "171686  cmip5-daily-pressure-level  \n",
       "\n",
       "[171687 rows x 23 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip5 = cat['c3s-cmip5'].read()\n",
    "df_cmip5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b8224e1c-fb84-4c3d-b267-feb26cefcd97",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>project</th>\n",
       "      <th>product</th>\n",
       "      <th>institute</th>\n",
       "      <th>model</th>\n",
       "      <th>experiment</th>\n",
       "      <th>time_frequency</th>\n",
       "      <th>realm</th>\n",
       "      <th>...</th>\n",
       "      <th>version</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "      <th>units</th>\n",
       "      <th>variable_name</th>\n",
       "      <th>description</th>\n",
       "      <th>url</th>\n",
       "      <th>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1-m.rcp85.mon.a...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1-m/rcp85/mon/atmos/Amon/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1-m</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>2006-01-01T12:00:00</td>\n",
       "      <td>2099-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K</td>\n",
       "      <td>Near-surface (2m) air temperature (tas)</td>\n",
       "      <td>Temperature of the air near the surface.</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>c3s-cmip5.output1.BCC.bcc-csm1-1-m.rcp85.mon.a...</td>\n",
       "      <td>output1/BCC/bcc-csm1-1-m/rcp85/mon/atmos/Amon/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-cmip5</td>\n",
       "      <td>output1</td>\n",
       "      <td>BCC</td>\n",
       "      <td>bcc-csm1-1-m</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>atmos</td>\n",
       "      <td>...</td>\n",
       "      <td>v20181201</td>\n",
       "      <td>2100-01-01T12:00:00</td>\n",
       "      <td>2100-12-31T12:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>K</td>\n",
       "      <td>Near-surface (2m) air temperature (tas)</td>\n",
       "      <td>Temperature of the air near the surface.</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "      <td>cmip5-monthly-single-level</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 ds_id  \\\n",
       "546  c3s-cmip5.output1.BCC.bcc-csm1-1-m.rcp85.mon.a...   \n",
       "547  c3s-cmip5.output1.BCC.bcc-csm1-1-m.rcp85.mon.a...   \n",
       "\n",
       "                                                  path  size    project  \\\n",
       "546  output1/BCC/bcc-csm1-1-m/rcp85/mon/atmos/Amon/...   NaN  c3s-cmip5   \n",
       "547  output1/BCC/bcc-csm1-1-m/rcp85/mon/atmos/Amon/...   NaN  c3s-cmip5   \n",
       "\n",
       "     product institute         model experiment time_frequency  realm  ...  \\\n",
       "546  output1       BCC  bcc-csm1-1-m      rcp85            mon  atmos  ...   \n",
       "547  output1       BCC  bcc-csm1-1-m      rcp85            mon  atmos  ...   \n",
       "\n",
       "       version           start_time             end_time bbox level units  \\\n",
       "546  v20181201  2006-01-01T12:00:00  2099-12-31T12:00:00  NaN   NaN     K   \n",
       "547  v20181201  2100-01-01T12:00:00  2100-12-31T12:00:00  NaN   NaN     K   \n",
       "\n",
       "                               variable_name  \\\n",
       "546  Near-surface (2m) air temperature (tas)   \n",
       "547  Near-surface (2m) air temperature (tas)   \n",
       "\n",
       "                                  description  \\\n",
       "546  Temperature of the air near the surface.   \n",
       "547  Temperature of the air near the surface.   \n",
       "\n",
       "                                                   url  \\\n",
       "546  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "547  https://data.mips.copernicus-climate.eu/thredd...   \n",
       "\n",
       "                          label  \n",
       "546  cmip5-monthly-single-level  \n",
       "547  cmip5-monthly-single-level  \n",
       "\n",
       "[2 rows x 23 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cmip5.loc[\n",
    "    (df_cmip5.variable==\"tas\") \n",
    "    & (df_cmip5.experiment==\"rcp85\")\n",
    "    & (df_cmip5.time_frequency==\"mon\")\n",
    "    & (df_cmip5.model==\"bcc-csm1-1-m\")\n",
    "    & (df_cmip5.ensemble==\"r1i1p1\")\n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "85441254-938b-40e2-aa3b-9b86544275ee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'c3s-cmip5.output1.BCC.bcc-csm1-1-m.rcp85.mon.atmos.Amon.r1i1p1.tas.v20181201'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection = df.ds_id.unique()[0]\n",
    "collection"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b91ef41f-4196-41bc-ba85-799ec92c240e",
   "metadata": {},
   "source": [
    "## Load Catalog for C3S-ATLAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "33cb6371-bcd3-4bb6-a901-f7f7051945f3",
   "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>ds_id</th>\n",
       "      <th>path</th>\n",
       "      <th>size</th>\n",
       "      <th>project</th>\n",
       "      <th>domain</th>\n",
       "      <th>experiment</th>\n",
       "      <th>time_frequency</th>\n",
       "      <th>variable</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bbox</th>\n",
       "      <th>level</th>\n",
       "      <th>prefix</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-ipcc-atlas.fd.CMIP5.rcp45.mon</td>\n",
       "      <td>CMIP5/rcp45/fd_CMIP5_rcp45_mon_200601-210012.nc</td>\n",
       "      <td>206830356</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>mon</td>\n",
       "      <td>fd</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>-179.00, -89.00, 179.00, 89.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-ipcc-atlas.tnn.CMIP5.rcp45.mon</td>\n",
       "      <td>CMIP5/rcp45/tnn_CMIP5_rcp45_mon_200601-210012.nc</td>\n",
       "      <td>899056159</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>mon</td>\n",
       "      <td>tnn</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>-179.00, -89.00, 179.00, 89.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-ipcc-atlas.tx40.CMIP5.rcp45.mon</td>\n",
       "      <td>CMIP5/rcp45/tx40_CMIP5_rcp45_mon_200601-210012.nc</td>\n",
       "      <td>52647634</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx40</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>-179.00, -89.00, 179.00, 89.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-ipcc-atlas.tx35ba.CMIP5.rcp45.mon</td>\n",
       "      <td>CMIP5/rcp45/tx35ba_CMIP5_rcp45_mon_200601-2100...</td>\n",
       "      <td>40939549</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx35ba</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>-179.00, -89.00, 179.00, 89.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-ipcc-atlas.rx1day.CMIP5.rcp45.mon</td>\n",
       "      <td>CMIP5/rcp45/rx1day_CMIP5_rcp45_mon_200601-2100...</td>\n",
       "      <td>1002850075</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>rcp45</td>\n",
       "      <td>mon</td>\n",
       "      <td>rx1day</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>-179.00, -89.00, 179.00, 89.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-ipcc-atlas</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>c3s-ipcc-atlas.tx35.CORDEX-WAS.rcp85.mon</td>\n",
       "      <td>CORDEX-WAS/rcp85/tx35_CORDEX-WAS_rcp85_mon_200...</td>\n",
       "      <td>315822711</td>\n",
       "      <td>CORDEX</td>\n",
       "      <td>WAS</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx35</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>19.25, -15.75, 116.25, 45.75</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>859</th>\n",
       "      <td>c3s-ipcc-atlas.spi6.CORDEX-WAS.rcp85.mon</td>\n",
       "      <td>CORDEX-WAS/rcp85/spi6_CORDEX-WAS_rcp85_mon_200...</td>\n",
       "      <td>877566524</td>\n",
       "      <td>CORDEX</td>\n",
       "      <td>WAS</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>spi6</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>19.25, -15.75, 116.25, 45.75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>c3s-ipcc-atlas.rx5day.CORDEX-WAS.rcp85.mon</td>\n",
       "      <td>CORDEX-WAS/rcp85/rx5day_CORDEX-WAS_rcp85_mon_2...</td>\n",
       "      <td>1107127612</td>\n",
       "      <td>CORDEX</td>\n",
       "      <td>WAS</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>rx5day</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>19.25, -15.75, 116.25, 45.75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>861</th>\n",
       "      <td>c3s-ipcc-atlas.tn.CORDEX-WAS.rcp85.mon</td>\n",
       "      <td>CORDEX-WAS/rcp85/tn_CORDEX-WAS_rcp85_mon_20060...</td>\n",
       "      <td>853394968</td>\n",
       "      <td>CORDEX</td>\n",
       "      <td>WAS</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>tn</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>19.25, -15.75, 116.25, 45.75</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>862</th>\n",
       "      <td>c3s-ipcc-atlas.tx40ba.CORDEX-WAS.rcp85.mon</td>\n",
       "      <td>CORDEX-WAS/rcp85/tx40ba_CORDEX-WAS_rcp85_mon_2...</td>\n",
       "      <td>70997195</td>\n",
       "      <td>CORDEX</td>\n",
       "      <td>WAS</td>\n",
       "      <td>rcp85</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx40ba</td>\n",
       "      <td>2006-01-01T00:00:00</td>\n",
       "      <td>2100-12-01T00:00:00</td>\n",
       "      <td>19.25, -15.75, 116.25, 45.75</td>\n",
       "      <td>2.00</td>\n",
       "      <td>c3s-ipcc-atlas</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>863 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          ds_id  \\\n",
       "0             c3s-ipcc-atlas.fd.CMIP5.rcp45.mon   \n",
       "1            c3s-ipcc-atlas.tnn.CMIP5.rcp45.mon   \n",
       "2           c3s-ipcc-atlas.tx40.CMIP5.rcp45.mon   \n",
       "3         c3s-ipcc-atlas.tx35ba.CMIP5.rcp45.mon   \n",
       "4         c3s-ipcc-atlas.rx1day.CMIP5.rcp45.mon   \n",
       "..                                          ...   \n",
       "858    c3s-ipcc-atlas.tx35.CORDEX-WAS.rcp85.mon   \n",
       "859    c3s-ipcc-atlas.spi6.CORDEX-WAS.rcp85.mon   \n",
       "860  c3s-ipcc-atlas.rx5day.CORDEX-WAS.rcp85.mon   \n",
       "861      c3s-ipcc-atlas.tn.CORDEX-WAS.rcp85.mon   \n",
       "862  c3s-ipcc-atlas.tx40ba.CORDEX-WAS.rcp85.mon   \n",
       "\n",
       "                                                  path        size project  \\\n",
       "0      CMIP5/rcp45/fd_CMIP5_rcp45_mon_200601-210012.nc   206830356   CMIP5   \n",
       "1     CMIP5/rcp45/tnn_CMIP5_rcp45_mon_200601-210012.nc   899056159   CMIP5   \n",
       "2    CMIP5/rcp45/tx40_CMIP5_rcp45_mon_200601-210012.nc    52647634   CMIP5   \n",
       "3    CMIP5/rcp45/tx35ba_CMIP5_rcp45_mon_200601-2100...    40939549   CMIP5   \n",
       "4    CMIP5/rcp45/rx1day_CMIP5_rcp45_mon_200601-2100...  1002850075   CMIP5   \n",
       "..                                                 ...         ...     ...   \n",
       "858  CORDEX-WAS/rcp85/tx35_CORDEX-WAS_rcp85_mon_200...   315822711  CORDEX   \n",
       "859  CORDEX-WAS/rcp85/spi6_CORDEX-WAS_rcp85_mon_200...   877566524  CORDEX   \n",
       "860  CORDEX-WAS/rcp85/rx5day_CORDEX-WAS_rcp85_mon_2...  1107127612  CORDEX   \n",
       "861  CORDEX-WAS/rcp85/tn_CORDEX-WAS_rcp85_mon_20060...   853394968  CORDEX   \n",
       "862  CORDEX-WAS/rcp85/tx40ba_CORDEX-WAS_rcp85_mon_2...    70997195  CORDEX   \n",
       "\n",
       "    domain experiment time_frequency variable           start_time  \\\n",
       "0      NaN      rcp45            mon       fd  2006-01-01T00:00:00   \n",
       "1      NaN      rcp45            mon      tnn  2006-01-01T00:00:00   \n",
       "2      NaN      rcp45            mon     tx40  2006-01-01T00:00:00   \n",
       "3      NaN      rcp45            mon   tx35ba  2006-01-01T00:00:00   \n",
       "4      NaN      rcp45            mon   rx1day  2006-01-01T00:00:00   \n",
       "..     ...        ...            ...      ...                  ...   \n",
       "858    WAS      rcp85            mon     tx35  2006-01-01T00:00:00   \n",
       "859    WAS      rcp85            mon     spi6  2006-01-01T00:00:00   \n",
       "860    WAS      rcp85            mon   rx5day  2006-01-01T00:00:00   \n",
       "861    WAS      rcp85            mon       tn  2006-01-01T00:00:00   \n",
       "862    WAS      rcp85            mon   tx40ba  2006-01-01T00:00:00   \n",
       "\n",
       "                end_time                            bbox level          prefix  \n",
       "0    2100-12-01T00:00:00  -179.00, -89.00, 179.00, 89.00  2.00  c3s-ipcc-atlas  \n",
       "1    2100-12-01T00:00:00  -179.00, -89.00, 179.00, 89.00  2.00  c3s-ipcc-atlas  \n",
       "2    2100-12-01T00:00:00  -179.00, -89.00, 179.00, 89.00  2.00  c3s-ipcc-atlas  \n",
       "3    2100-12-01T00:00:00  -179.00, -89.00, 179.00, 89.00  2.00  c3s-ipcc-atlas  \n",
       "4    2100-12-01T00:00:00  -179.00, -89.00, 179.00, 89.00   NaN  c3s-ipcc-atlas  \n",
       "..                   ...                             ...   ...             ...  \n",
       "858  2100-12-01T00:00:00    19.25, -15.75, 116.25, 45.75  2.00  c3s-ipcc-atlas  \n",
       "859  2100-12-01T00:00:00    19.25, -15.75, 116.25, 45.75   NaN  c3s-ipcc-atlas  \n",
       "860  2100-12-01T00:00:00    19.25, -15.75, 116.25, 45.75   NaN  c3s-ipcc-atlas  \n",
       "861  2100-12-01T00:00:00    19.25, -15.75, 116.25, 45.75  2.00  c3s-ipcc-atlas  \n",
       "862  2100-12-01T00:00:00    19.25, -15.75, 116.25, 45.75  2.00  c3s-ipcc-atlas  \n",
       "\n",
       "[863 rows x 13 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_atlas = cat['c3s-ipcc-atlas'].read()\n",
    "df_atlas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "0feaccea-a910-4e10-9cb9-a112cb654a6f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ds_id             863\n",
       "path              863\n",
       "size              863\n",
       "project             3\n",
       "domain             11\n",
       "experiment          8\n",
       "time_frequency      2\n",
       "variable           22\n",
       "start_time          5\n",
       "end_time            7\n",
       "bbox               14\n",
       "level               2\n",
       "prefix              1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_atlas.nunique()"
   ]
  }
 ],
 "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}