{
 "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',\n",
       " 'c3s-cica-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>133147</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>133148</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>133149</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>133150</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>133151</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>133152 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",
       "133147  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133148  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133149  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133150  c3s-cmip6.CMIP.MIROC.MIROC-ES2H.historical.r1i...   \n",
       "133151  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",
       "133147  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   204026121   \n",
       "133148  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   164344947   \n",
       "133149  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...  3420481903   \n",
       "133150  CMIP/MIROC/MIROC-ES2H/historical/r1i1p4f2/Amon...   143468073   \n",
       "133151  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",
       "133147  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133148  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133149  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133150  c3s-cmip6         CMIP          MIROC   MIROC-ES2H    historical   \n",
       "133151  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",
       "133147  r1i1p4f2     Amon        tauu         gn  v20220322   \n",
       "133148  r1i1p4f2     Amon        rlus         gn  v20220322   \n",
       "133149  r1i1p4f2     Amon          ua         gn  v20220322   \n",
       "133150  r1i1p4f2     Amon      tasmin         gn  v20220322   \n",
       "133151  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",
       "133147  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133148  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133149  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133150  1850-01-16T12:00:00  2014-12-16T12:00:00  0.00, -88.93, 358.59, 88.93   \n",
       "133151  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",
       "133147                                                NaN  \n",
       "133148                                                NaN  \n",
       "133149  100.00 500.00 1000.00 2000.00 3000.00 5000.00 ...  \n",
       "133150                                               2.00  \n",
       "133151                                                NaN  \n",
       "\n",
       "[133152 rows x 17 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip6 = cat['c3s-cmip6'].read()\n",
    "df_cmip6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "06307b8d-645d-4cae-89b3-071c2d85e6db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ds_id              10426\n",
       "path              133152\n",
       "size              122422\n",
       "mip_era                1\n",
       "activity_id            2\n",
       "institution_id        31\n",
       "source_id             58\n",
       "experiment_id          9\n",
       "member_id             17\n",
       "table_id               8\n",
       "variable_id           51\n",
       "grid_label             3\n",
       "version              242\n",
       "start_time           633\n",
       "end_time             674\n",
       "bbox                  54\n",
       "level                  6\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip6.nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "architectural-suspension",
   "metadata": {},
   "source": [
    "### Search dataset ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>598</th>\n",
       "      <td>c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-CM6-1.histori...</td>\n",
       "      <td>CMIP/CNRM-CERFACS/CNRM-CM6-1/historical/r1i1p1...</td>\n",
       "      <td>330937271</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>CNRM-CERFACS</td>\n",
       "      <td>CNRM-CM6-1</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Omon</td>\n",
       "      <td>sos</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20180917</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>-180.00, -79.01, 179.99, 89.74</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5491</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...</td>\n",
       "      <td>ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp119/r1...</td>\n",
       "      <td>219719456</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>CNRM-CERFACS</td>\n",
       "      <td>CNRM-ESM2-1</td>\n",
       "      <td>ssp119</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Omon</td>\n",
       "      <td>zos</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20190328</td>\n",
       "      <td>2015-01-16T12:00:00</td>\n",
       "      <td>2100-12-16T12:00:00</td>\n",
       "      <td>-180.00, -79.01, 179.99, 89.74</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6601</th>\n",
       "      <td>c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-ESM2-1.histor...</td>\n",
       "      <td>CMIP/CNRM-CERFACS/CNRM-ESM2-1/historical/r1i1p...</td>\n",
       "      <td>395765175</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>CMIP</td>\n",
       "      <td>CNRM-CERFACS</td>\n",
       "      <td>CNRM-ESM2-1</td>\n",
       "      <td>historical</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Omon</td>\n",
       "      <td>tos</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20181206</td>\n",
       "      <td>1850-01-16T12:00:00</td>\n",
       "      <td>2014-12-16T12:00:00</td>\n",
       "      <td>-180.00, -79.01, 179.99, 89.74</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8615</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...</td>\n",
       "      <td>ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp460/r1...</td>\n",
       "      <td>219877133</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>CNRM-CERFACS</td>\n",
       "      <td>CNRM-ESM2-1</td>\n",
       "      <td>ssp460</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Omon</td>\n",
       "      <td>zos</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20190328</td>\n",
       "      <td>2015-01-16T12:00:00</td>\n",
       "      <td>2100-12-16T12:00:00</td>\n",
       "      <td>-180.00, -79.01, 179.99, 89.74</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12170</th>\n",
       "      <td>c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...</td>\n",
       "      <td>ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp585/r1...</td>\n",
       "      <td>178193412</td>\n",
       "      <td>c3s-cmip6</td>\n",
       "      <td>ScenarioMIP</td>\n",
       "      <td>CNRM-CERFACS</td>\n",
       "      <td>CNRM-ESM2-1</td>\n",
       "      <td>ssp585</td>\n",
       "      <td>r1i1p1f2</td>\n",
       "      <td>Omon</td>\n",
       "      <td>sos</td>\n",
       "      <td>gn</td>\n",
       "      <td>v20191021</td>\n",
       "      <td>2015-01-16T12:00:00</td>\n",
       "      <td>2100-12-16T12:00:00</td>\n",
       "      <td>-180.00, -79.01, 179.99, 89.74</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   ds_id  \\\n",
       "598    c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-CM6-1.histori...   \n",
       "5491   c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...   \n",
       "6601   c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-ESM2-1.histor...   \n",
       "8615   c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...   \n",
       "12170  c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1...   \n",
       "\n",
       "                                                    path       size  \\\n",
       "598    CMIP/CNRM-CERFACS/CNRM-CM6-1/historical/r1i1p1...  330937271   \n",
       "5491   ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp119/r1...  219719456   \n",
       "6601   CMIP/CNRM-CERFACS/CNRM-ESM2-1/historical/r1i1p...  395765175   \n",
       "8615   ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp460/r1...  219877133   \n",
       "12170  ScenarioMIP/CNRM-CERFACS/CNRM-ESM2-1/ssp585/r1...  178193412   \n",
       "\n",
       "         mip_era  activity_id institution_id    source_id experiment_id  \\\n",
       "598    c3s-cmip6         CMIP   CNRM-CERFACS   CNRM-CM6-1    historical   \n",
       "5491   c3s-cmip6  ScenarioMIP   CNRM-CERFACS  CNRM-ESM2-1        ssp119   \n",
       "6601   c3s-cmip6         CMIP   CNRM-CERFACS  CNRM-ESM2-1    historical   \n",
       "8615   c3s-cmip6  ScenarioMIP   CNRM-CERFACS  CNRM-ESM2-1        ssp460   \n",
       "12170  c3s-cmip6  ScenarioMIP   CNRM-CERFACS  CNRM-ESM2-1        ssp585   \n",
       "\n",
       "      member_id table_id variable_id grid_label    version  \\\n",
       "598    r1i1p1f2     Omon         sos         gn  v20180917   \n",
       "5491   r1i1p1f2     Omon         zos         gn  v20190328   \n",
       "6601   r1i1p1f2     Omon         tos         gn  v20181206   \n",
       "8615   r1i1p1f2     Omon         zos         gn  v20190328   \n",
       "12170  r1i1p1f2     Omon         sos         gn  v20191021   \n",
       "\n",
       "                start_time             end_time  \\\n",
       "598    1850-01-16T12:00:00  2014-12-16T12:00:00   \n",
       "5491   2015-01-16T12:00:00  2100-12-16T12:00:00   \n",
       "6601   1850-01-16T12:00:00  2014-12-16T12:00:00   \n",
       "8615   2015-01-16T12:00:00  2100-12-16T12:00:00   \n",
       "12170  2015-01-16T12:00:00  2100-12-16T12:00:00   \n",
       "\n",
       "                                 bbox level  \n",
       "598    -180.00, -79.01, 179.99, 89.74   NaN  \n",
       "5491   -180.00, -79.01, 179.99, 89.74   NaN  \n",
       "6601   -180.00, -79.01, 179.99, 89.74   NaN  \n",
       "8615   -180.00, -79.01, 179.99, 89.74   NaN  \n",
       "12170  -180.00, -79.01, 179.99, 89.74   NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cmip6.loc[\n",
    "    (df_cmip6.institution_id==\"CNRM-CERFACS\")\n",
    "    & ( (df_cmip6.source_id==\"CNRM-CM6-1\") | (df_cmip6.source_id==\"CNRM-ESM2-1\"))\n",
    "    & (df_cmip6.table_id==\"Omon\")\n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "maritime-association",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ds_id             42\n",
       "path              42\n",
       "size              42\n",
       "mip_era            1\n",
       "activity_id        2\n",
       "institution_id     1\n",
       "source_id          2\n",
       "experiment_id      9\n",
       "member_id          2\n",
       "table_id           1\n",
       "variable_id        3\n",
       "grid_label         1\n",
       "version            6\n",
       "start_time         2\n",
       "end_time           2\n",
       "bbox               1\n",
       "level              0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "b1326e6a-ca92-4699-8cd8-b5ac53d85d29",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-CM6-1.historical.r1i1p1f2.Omon.sos.gn.v20180917',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp119.r1i1p1f2.Omon.zos.gn.v20190328',\n",
       " 'c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-ESM2-1.historical.r1i1p1f2.Omon.tos.gn.v20181206',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp460.r1i1p1f2.Omon.zos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp585.r1i1p1f2.Omon.sos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp370.r1i1p1f2.Omon.zos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp245.r1i1p1f2.Omon.zos.gn.v20190328',\n",
       " 'c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-CM6-1.historical.r1i1p1f2.Omon.tos.gn.v20180917',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp245.r1i1p1f2.Omon.sos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp460.r1i1p1f2.Omon.tos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp245.r1i1p1f2.Omon.zos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp534-over.r2i1p1f2.Omon.tos.gn.v20190410',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp126.r1i1p1f2.Omon.sos.gn.v20190328',\n",
       " 'c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-CM6-1.historical.r1i1p1f2.Omon.zos.gn.v20180917',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp245.r1i1p1f2.Omon.tos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp119.r1i1p1f2.Omon.sos.gn.v20190328',\n",
       " 'c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-ESM2-1.historical.r1i1p1f2.Omon.sos.gn.v20181206',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp534-over.r2i1p1f2.Omon.sos.gn.v20190410',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp434.r1i1p1f2.Omon.zos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp585.r1i1p1f2.Omon.zos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp126.r1i1p1f2.Omon.zos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp126.r1i1p1f2.Omon.zos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp460.r1i1p1f2.Omon.sos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp370.r1i1p1f2.Omon.sos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp370.r1i1p1f2.Omon.zos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp585.r1i1p1f2.Omon.zos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp585.r1i1p1f2.Omon.tos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp126.r1i1p1f2.Omon.sos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp585.r1i1p1f2.Omon.tos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp370.r1i1p1f2.Omon.tos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp126.r1i1p1f2.Omon.tos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp126.r1i1p1f2.Omon.tos.gn.v20190219',\n",
       " 'c3s-cmip6.CMIP.CNRM-CERFACS.CNRM-ESM2-1.historical.r1i1p1f2.Omon.zos.gn.v20181206',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp434.r1i1p1f2.Omon.tos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp585.r1i1p1f2.Omon.sos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp370.r1i1p1f2.Omon.tos.gn.v20191021',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp245.r1i1p1f2.Omon.sos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp119.r1i1p1f2.Omon.tos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp370.r1i1p1f2.Omon.sos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp434.r1i1p1f2.Omon.sos.gn.v20190328',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-CM6-1.ssp245.r1i1p1f2.Omon.tos.gn.v20190219',\n",
       " 'c3s-cmip6.ScenarioMIP.CNRM-CERFACS.CNRM-ESM2-1.ssp534-over.r2i1p1f2.Omon.zos.gn.v20190410']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(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": 8,
   "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": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip6_decadal = cat['c3s-cmip6-decadal'].read()\n",
    "df_cmip6_decadal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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": 9,
     "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": 10,
   "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": 10,
     "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": 11,
   "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": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cordex = cat['c3s-cordex'].read()\n",
    "df_cordex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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": 12,
     "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": 13,
   "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": 13,
     "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": 14,
   "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": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cmip5 = cat['c3s-cmip5'].read()\n",
    "df_cmip5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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": 15,
     "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": 16,
   "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": 16,
     "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-IPCC-ATLAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ipcc_atlas = cat['c3s-ipcc-atlas'].read()\n",
    "df_ipcc_atlas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ipcc_atlas.nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8f1902cb-e724-4f2a-86ee-ede2065493ad",
   "metadata": {},
   "source": [
    "## Load Catalog for C3S-CICA-ATLAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "f5eef820-6ed8-4958-bd98-7a8e3686d700",
   "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>version</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>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c3s-cica-atlas.pr.CMIP5.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP5/historical/pr_CMIP5_historical_mon_18500...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>pr</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>c3s-cica-atlas.prsn.CMIP5.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP5/historical/prsn_CMIP5_historical_mon_185...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>prsn</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>c3s-cica-atlas.rx1day.CMIP5.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP5/historical/rx1day_CMIP5_historical_mon_1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>rx1day</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>c3s-cica-atlas.rx5day.CMIP5.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP5/historical/rx5day_CMIP5_historical_mon_1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>rx5day</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c3s-cica-atlas.sfcwind.CMIP5.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP5/historical/sfcwind_CMIP5_historical_mon_...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP5</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>sfcwind</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>c3s-cica-atlas.tx40.ERA5.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5/tx40_ERA5_mon_194001-202212.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx40</td>\n",
       "      <td>1940-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>c3s-cica-atlas.txx.ERA5.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5/txx_ERA5_mon_194001-202212.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>txx</td>\n",
       "      <td>1940-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>c3s-cica-atlas.tx.ERA5.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5/tx_ERA5_mon_194001-202212.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>tx</td>\n",
       "      <td>1940-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>c3s-cica-atlas.siconc.ORAS5.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ORAS5/siconc_ORAS5_mon_195801-201412.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ORAS5</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>siconc</td>\n",
       "      <td>1958-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>c3s-cica-atlas.sst.ORAS5.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ORAS5/sst_ORAS5_mon_195801-201412.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ORAS5</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>sst</td>\n",
       "      <td>1958-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>412 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              ds_id version  \\\n",
       "0         c3s-cica-atlas.pr.CMIP5.historical.mon.v1      v1   \n",
       "1       c3s-cica-atlas.prsn.CMIP5.historical.mon.v1      v1   \n",
       "2     c3s-cica-atlas.rx1day.CMIP5.historical.mon.v1      v1   \n",
       "3     c3s-cica-atlas.rx5day.CMIP5.historical.mon.v1      v1   \n",
       "4    c3s-cica-atlas.sfcwind.CMIP5.historical.mon.v1      v1   \n",
       "..                                              ...     ...   \n",
       "407                 c3s-cica-atlas.tx40.ERA5.mon.v1      v1   \n",
       "408                  c3s-cica-atlas.txx.ERA5.mon.v1      v1   \n",
       "409                   c3s-cica-atlas.tx.ERA5.mon.v1      v1   \n",
       "410              c3s-cica-atlas.siconc.ORAS5.mon.v1      v1   \n",
       "411                 c3s-cica-atlas.sst.ORAS5.mon.v1      v1   \n",
       "\n",
       "                                                  path  size project  domain  \\\n",
       "0    CMIP5/historical/pr_CMIP5_historical_mon_18500...   NaN   CMIP5  Global   \n",
       "1    CMIP5/historical/prsn_CMIP5_historical_mon_185...   NaN   CMIP5  Global   \n",
       "2    CMIP5/historical/rx1day_CMIP5_historical_mon_1...   NaN   CMIP5  Global   \n",
       "3    CMIP5/historical/rx5day_CMIP5_historical_mon_1...   NaN   CMIP5  Global   \n",
       "4    CMIP5/historical/sfcwind_CMIP5_historical_mon_...   NaN   CMIP5  Global   \n",
       "..                                                 ...   ...     ...     ...   \n",
       "407                ERA5/tx40_ERA5_mon_194001-202212.nc   NaN    ERA5  Global   \n",
       "408                 ERA5/txx_ERA5_mon_194001-202212.nc   NaN    ERA5  Global   \n",
       "409                  ERA5/tx_ERA5_mon_194001-202212.nc   NaN    ERA5  Global   \n",
       "410            ORAS5/siconc_ORAS5_mon_195801-201412.nc   NaN   ORAS5  Global   \n",
       "411               ORAS5/sst_ORAS5_mon_195801-201412.nc   NaN   ORAS5  Global   \n",
       "\n",
       "     experiment time_frequency variable           start_time  \\\n",
       "0    historical            mon       pr  1850-01-01T00:00:00   \n",
       "1    historical            mon     prsn  1850-01-01T00:00:00   \n",
       "2    historical            mon   rx1day  1850-01-01T00:00:00   \n",
       "3    historical            mon   rx5day  1850-01-01T00:00:00   \n",
       "4    historical            mon  sfcwind  1850-01-01T00:00:00   \n",
       "..          ...            ...      ...                  ...   \n",
       "407         NaN            mon     tx40  1940-01-01T00:00:00   \n",
       "408         NaN            mon      txx  1940-01-01T00:00:00   \n",
       "409         NaN            mon       tx  1940-01-01T00:00:00   \n",
       "410         NaN            mon   siconc  1958-01-01T00:00:00   \n",
       "411         NaN            mon      sst  1958-01-01T00:00:00   \n",
       "\n",
       "                end_time  bbox level  \\\n",
       "0    2005-12-31T00:00:00   NaN   NaN   \n",
       "1    2005-12-31T00:00:00   NaN   NaN   \n",
       "2    2005-12-31T00:00:00   NaN   NaN   \n",
       "3    2005-12-31T00:00:00   NaN   NaN   \n",
       "4    2005-12-31T00:00:00   NaN   NaN   \n",
       "..                   ...   ...   ...   \n",
       "407  2022-12-31T00:00:00   NaN   NaN   \n",
       "408  2022-12-31T00:00:00   NaN   NaN   \n",
       "409  2022-12-31T00:00:00   NaN   NaN   \n",
       "410  2014-12-31T00:00:00   NaN   NaN   \n",
       "411  2014-12-31T00:00:00   NaN   NaN   \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",
       "407  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "408  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "409  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "410  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "411  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "\n",
       "[412 rows x 14 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cica_atlas = cat['c3s-cica-atlas'].read()\n",
    "df_cica_atlas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "feab62fd-cc6d-490e-a90d-6eab4d636807",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ds_id             412\n",
       "version             1\n",
       "path              412\n",
       "size                0\n",
       "project             8\n",
       "domain              4\n",
       "experiment          8\n",
       "time_frequency      2\n",
       "variable           30\n",
       "start_time          7\n",
       "end_time            5\n",
       "bbox                0\n",
       "level               0\n",
       "url               412\n",
       "dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cica_atlas.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "c2823727-0801-4c69-8f53-468471a08b8a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['CMIP5',\n",
       " 'CMIP6',\n",
       " 'CORDEX-CORE',\n",
       " 'CORDEX-EUR-11',\n",
       " 'E-OBS',\n",
       " 'ERA5',\n",
       " 'ERA5-Land',\n",
       " 'ORAS5']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_cica_atlas.project.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1f54da6c-5c11-43d0-9bb9-2d7fa97f20b0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Global', 'Global (mosaic)', 'Europe (EURO-CORDEX)', 'Europe']"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_cica_atlas.domain.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "05ad13d4-b100-43c8-a51a-7b9d1380d77e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['historical',\n",
       " 'rcp26',\n",
       " 'rcp45',\n",
       " 'rcp85',\n",
       " 'ssp126',\n",
       " 'ssp245',\n",
       " 'ssp370',\n",
       " 'ssp585',\n",
       " nan]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_cica_atlas.experiment.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "79858791-50eb-48ae-acd5-da44c8b6f5a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['mon', 'yr']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_cica_atlas.time_frequency.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "09978fca-6ec1-406b-ad7e-9e183926d8a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['pr',\n",
       " 'prsn',\n",
       " 'rx1day',\n",
       " 'rx5day',\n",
       " 'sfcwind',\n",
       " 't',\n",
       " 'tn',\n",
       " 'tnn',\n",
       " 'tx35',\n",
       " 'tx',\n",
       " 'tx40',\n",
       " 'txx',\n",
       " 'cd',\n",
       " 'cdd',\n",
       " 'clt',\n",
       " 'evspsbl',\n",
       " 'fd',\n",
       " 'hd',\n",
       " 'huss',\n",
       " 'mrro',\n",
       " 'mrsos',\n",
       " 'psl',\n",
       " 'rlds',\n",
       " 'rsds',\n",
       " 'siconc',\n",
       " 'spei6',\n",
       " 'spi6',\n",
       " 'sst',\n",
       " 'tx35bals',\n",
       " 'tx40bals']"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_cica_atlas.variable.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "01cf2bf7-0b1d-4061-94c1-a0a5bd8168a8",
   "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>version</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>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>c3s-cica-atlas.cd.ERA5-Land.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5-Land/cd_ERA5-Land_yr_1950-2022.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5-Land</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yr</td>\n",
       "      <td>cd</td>\n",
       "      <td>1950-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>c3s-cica-atlas.cdd.ERA5-Land.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5-Land/cdd_ERA5-Land_yr_1950-2022.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5-Land</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yr</td>\n",
       "      <td>cdd</td>\n",
       "      <td>1950-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>c3s-cica-atlas.evspsbl.ERA5-Land.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5-Land/evspsbl_ERA5-Land_mon_195001-202212.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5-Land</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>evspsbl</td>\n",
       "      <td>1950-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>c3s-cica-atlas.hd.ERA5-Land.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5-Land/hd_ERA5-Land_yr_1950-2022.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5-Land</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yr</td>\n",
       "      <td>hd</td>\n",
       "      <td>1950-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>c3s-cica-atlas.fd.ERA5-Land.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>ERA5-Land/fd_ERA5-Land_mon_195001-202212.nc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ERA5-Land</td>\n",
       "      <td>Global</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mon</td>\n",
       "      <td>fd</td>\n",
       "      <td>1950-01-01T00:00:00</td>\n",
       "      <td>2022-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       ds_id version  \\\n",
       "368        c3s-cica-atlas.cd.ERA5-Land.yr.v1      v1   \n",
       "369       c3s-cica-atlas.cdd.ERA5-Land.yr.v1      v1   \n",
       "370  c3s-cica-atlas.evspsbl.ERA5-Land.mon.v1      v1   \n",
       "371        c3s-cica-atlas.hd.ERA5-Land.yr.v1      v1   \n",
       "372       c3s-cica-atlas.fd.ERA5-Land.mon.v1      v1   \n",
       "\n",
       "                                                 path  size    project  \\\n",
       "368            ERA5-Land/cd_ERA5-Land_yr_1950-2022.nc   NaN  ERA5-Land   \n",
       "369           ERA5-Land/cdd_ERA5-Land_yr_1950-2022.nc   NaN  ERA5-Land   \n",
       "370  ERA5-Land/evspsbl_ERA5-Land_mon_195001-202212.nc   NaN  ERA5-Land   \n",
       "371            ERA5-Land/hd_ERA5-Land_yr_1950-2022.nc   NaN  ERA5-Land   \n",
       "372       ERA5-Land/fd_ERA5-Land_mon_195001-202212.nc   NaN  ERA5-Land   \n",
       "\n",
       "     domain experiment time_frequency variable           start_time  \\\n",
       "368  Global        NaN             yr       cd  1950-01-01T00:00:00   \n",
       "369  Global        NaN             yr      cdd  1950-01-01T00:00:00   \n",
       "370  Global        NaN            mon  evspsbl  1950-01-01T00:00:00   \n",
       "371  Global        NaN             yr       hd  1950-01-01T00:00:00   \n",
       "372  Global        NaN            mon       fd  1950-01-01T00:00:00   \n",
       "\n",
       "                end_time  bbox level  \\\n",
       "368  2022-12-31T00:00:00   NaN   NaN   \n",
       "369  2022-12-31T00:00:00   NaN   NaN   \n",
       "370  2022-12-31T00:00:00   NaN   NaN   \n",
       "371  2022-12-31T00:00:00   NaN   NaN   \n",
       "372  2022-12-31T00:00:00   NaN   NaN   \n",
       "\n",
       "                                                   url  \n",
       "368  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "369  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "370  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "371  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "372  https://data.mips.copernicus-climate.eu/thredd...  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cica_atlas.loc[\n",
    "    (df_cica_atlas.project==\"ERA5-Land\") \n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "e684bb3d-66cd-4e0e-8cb3-18fa68bac222",
   "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>version</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>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>c3s-cica-atlas.cdd.CORDEX-EUR-11.historical.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-EUR-11/historical/cdd_CORDEX-EUR-11_his...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-EUR-11</td>\n",
       "      <td>Europe (EURO-CORDEX)</td>\n",
       "      <td>historical</td>\n",
       "      <td>yr</td>\n",
       "      <td>cdd</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>c3s-cica-atlas.clt.CORDEX-EUR-11.historical.mo...</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-EUR-11/historical/clt_CORDEX-EUR-11_his...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-EUR-11</td>\n",
       "      <td>Europe (EURO-CORDEX)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>clt</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>c3s-cica-atlas.huss.CORDEX-EUR-11.historical.m...</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-EUR-11/historical/huss_CORDEX-EUR-11_hi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-EUR-11</td>\n",
       "      <td>Europe (EURO-CORDEX)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>huss</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>c3s-cica-atlas.evspsbl.CORDEX-EUR-11.historica...</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-EUR-11/historical/evspsbl_CORDEX-EUR-11...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-EUR-11</td>\n",
       "      <td>Europe (EURO-CORDEX)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>evspsbl</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>c3s-cica-atlas.fd.CORDEX-EUR-11.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-EUR-11/historical/fd_CORDEX-EUR-11_hist...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-EUR-11</td>\n",
       "      <td>Europe (EURO-CORDEX)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>fd</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 ds_id version  \\\n",
       "250  c3s-cica-atlas.cdd.CORDEX-EUR-11.historical.yr.v1      v1   \n",
       "253  c3s-cica-atlas.clt.CORDEX-EUR-11.historical.mo...      v1   \n",
       "254  c3s-cica-atlas.huss.CORDEX-EUR-11.historical.m...      v1   \n",
       "255  c3s-cica-atlas.evspsbl.CORDEX-EUR-11.historica...      v1   \n",
       "256  c3s-cica-atlas.fd.CORDEX-EUR-11.historical.mon.v1      v1   \n",
       "\n",
       "                                                  path  size        project  \\\n",
       "250  CORDEX-EUR-11/historical/cdd_CORDEX-EUR-11_his...   NaN  CORDEX-EUR-11   \n",
       "253  CORDEX-EUR-11/historical/clt_CORDEX-EUR-11_his...   NaN  CORDEX-EUR-11   \n",
       "254  CORDEX-EUR-11/historical/huss_CORDEX-EUR-11_hi...   NaN  CORDEX-EUR-11   \n",
       "255  CORDEX-EUR-11/historical/evspsbl_CORDEX-EUR-11...   NaN  CORDEX-EUR-11   \n",
       "256  CORDEX-EUR-11/historical/fd_CORDEX-EUR-11_hist...   NaN  CORDEX-EUR-11   \n",
       "\n",
       "                   domain  experiment time_frequency variable  \\\n",
       "250  Europe (EURO-CORDEX)  historical             yr      cdd   \n",
       "253  Europe (EURO-CORDEX)  historical            mon      clt   \n",
       "254  Europe (EURO-CORDEX)  historical            mon     huss   \n",
       "255  Europe (EURO-CORDEX)  historical            mon  evspsbl   \n",
       "256  Europe (EURO-CORDEX)  historical            mon       fd   \n",
       "\n",
       "              start_time             end_time  bbox level  \\\n",
       "250  1970-01-01T00:00:00  2005-12-31T00:00:00   NaN   NaN   \n",
       "253  1970-01-01T00:00:00  2005-12-31T00:00:00   NaN   NaN   \n",
       "254  1970-01-01T00:00:00  2005-12-31T00:00:00   NaN   NaN   \n",
       "255  1970-01-01T00:00:00  2005-12-31T00:00:00   NaN   NaN   \n",
       "256  1970-01-01T00:00:00  2005-12-31T00:00:00   NaN   NaN   \n",
       "\n",
       "                                                   url  \n",
       "250  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "253  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "254  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "255  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "256  https://data.mips.copernicus-climate.eu/thredd...  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cica_atlas.loc[\n",
    "    (df_cica_atlas.project==\"CORDEX-EUR-11\") \n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "9a57a58f-7515-4a37-9915-2b05960499d6",
   "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>version</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>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>c3s-cica-atlas.cdd.CORDEX-CORE.historical.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-CORE/historical/cdd_CORDEX-CORE_histori...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-CORE</td>\n",
       "      <td>Global (mosaic)</td>\n",
       "      <td>historical</td>\n",
       "      <td>yr</td>\n",
       "      <td>cdd</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>c3s-cica-atlas.fd.CORDEX-CORE.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-CORE/historical/fd_CORDEX-CORE_historic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-CORE</td>\n",
       "      <td>Global (mosaic)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>fd</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>c3s-cica-atlas.evspsbl.CORDEX-CORE.historical....</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-CORE/historical/evspsbl_CORDEX-CORE_his...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-CORE</td>\n",
       "      <td>Global (mosaic)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>evspsbl</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>c3s-cica-atlas.huss.CORDEX-CORE.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-CORE/historical/huss_CORDEX-CORE_histor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-CORE</td>\n",
       "      <td>Global (mosaic)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>huss</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>c3s-cica-atlas.rlds.CORDEX-CORE.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CORDEX-CORE/historical/rlds_CORDEX-CORE_histor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDEX-CORE</td>\n",
       "      <td>Global (mosaic)</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>rlds</td>\n",
       "      <td>1970-01-01T00:00:00</td>\n",
       "      <td>2005-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 ds_id version  \\\n",
       "198    c3s-cica-atlas.cdd.CORDEX-CORE.historical.yr.v1      v1   \n",
       "199    c3s-cica-atlas.fd.CORDEX-CORE.historical.mon.v1      v1   \n",
       "200  c3s-cica-atlas.evspsbl.CORDEX-CORE.historical....      v1   \n",
       "201  c3s-cica-atlas.huss.CORDEX-CORE.historical.mon.v1      v1   \n",
       "202  c3s-cica-atlas.rlds.CORDEX-CORE.historical.mon.v1      v1   \n",
       "\n",
       "                                                  path  size      project  \\\n",
       "198  CORDEX-CORE/historical/cdd_CORDEX-CORE_histori...   NaN  CORDEX-CORE   \n",
       "199  CORDEX-CORE/historical/fd_CORDEX-CORE_historic...   NaN  CORDEX-CORE   \n",
       "200  CORDEX-CORE/historical/evspsbl_CORDEX-CORE_his...   NaN  CORDEX-CORE   \n",
       "201  CORDEX-CORE/historical/huss_CORDEX-CORE_histor...   NaN  CORDEX-CORE   \n",
       "202  CORDEX-CORE/historical/rlds_CORDEX-CORE_histor...   NaN  CORDEX-CORE   \n",
       "\n",
       "              domain  experiment time_frequency variable           start_time  \\\n",
       "198  Global (mosaic)  historical             yr      cdd  1970-01-01T00:00:00   \n",
       "199  Global (mosaic)  historical            mon       fd  1970-01-01T00:00:00   \n",
       "200  Global (mosaic)  historical            mon  evspsbl  1970-01-01T00:00:00   \n",
       "201  Global (mosaic)  historical            mon     huss  1970-01-01T00:00:00   \n",
       "202  Global (mosaic)  historical            mon     rlds  1970-01-01T00:00:00   \n",
       "\n",
       "                end_time  bbox level  \\\n",
       "198  2005-12-31T00:00:00   NaN   NaN   \n",
       "199  2005-12-31T00:00:00   NaN   NaN   \n",
       "200  2005-12-31T00:00:00   NaN   NaN   \n",
       "201  2005-12-31T00:00:00   NaN   NaN   \n",
       "202  2005-12-31T00:00:00   NaN   NaN   \n",
       "\n",
       "                                                   url  \n",
       "198  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "199  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "200  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "201  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "202  https://data.mips.copernicus-climate.eu/thredd...  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cica_atlas.loc[\n",
    "    (df_cica_atlas.project==\"CORDEX-CORE\") \n",
    "]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f001b10f-c43b-4d3b-8bf1-9ea4e5bbae44",
   "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>version</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>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>c3s-cica-atlas.cd.CMIP6.historical.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP6/historical/cd_CMIP6_historical_yr_1850-2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP6</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>yr</td>\n",
       "      <td>cd</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>c3s-cica-atlas.cdd.CMIP6.historical.yr.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP6/historical/cdd_CMIP6_historical_yr_1850-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP6</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>yr</td>\n",
       "      <td>cdd</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>c3s-cica-atlas.clt.CMIP6.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP6/historical/clt_CMIP6_historical_mon_1850...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP6</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>clt</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>c3s-cica-atlas.evspsbl.CMIP6.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP6/historical/evspsbl_CMIP6_historical_mon_...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP6</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>evspsbl</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>c3s-cica-atlas.fd.CMIP6.historical.mon.v1</td>\n",
       "      <td>v1</td>\n",
       "      <td>CMIP6/historical/fd_CMIP6_historical_mon_18500...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CMIP6</td>\n",
       "      <td>Global</td>\n",
       "      <td>historical</td>\n",
       "      <td>mon</td>\n",
       "      <td>fd</td>\n",
       "      <td>1850-01-01T00:00:00</td>\n",
       "      <td>2014-12-31T00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://data.mips.copernicus-climate.eu/thredd...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             ds_id version  \\\n",
       "48        c3s-cica-atlas.cd.CMIP6.historical.yr.v1      v1   \n",
       "49       c3s-cica-atlas.cdd.CMIP6.historical.yr.v1      v1   \n",
       "50      c3s-cica-atlas.clt.CMIP6.historical.mon.v1      v1   \n",
       "51  c3s-cica-atlas.evspsbl.CMIP6.historical.mon.v1      v1   \n",
       "52       c3s-cica-atlas.fd.CMIP6.historical.mon.v1      v1   \n",
       "\n",
       "                                                 path  size project  domain  \\\n",
       "48  CMIP6/historical/cd_CMIP6_historical_yr_1850-2...   NaN   CMIP6  Global   \n",
       "49  CMIP6/historical/cdd_CMIP6_historical_yr_1850-...   NaN   CMIP6  Global   \n",
       "50  CMIP6/historical/clt_CMIP6_historical_mon_1850...   NaN   CMIP6  Global   \n",
       "51  CMIP6/historical/evspsbl_CMIP6_historical_mon_...   NaN   CMIP6  Global   \n",
       "52  CMIP6/historical/fd_CMIP6_historical_mon_18500...   NaN   CMIP6  Global   \n",
       "\n",
       "    experiment time_frequency variable           start_time  \\\n",
       "48  historical             yr       cd  1850-01-01T00:00:00   \n",
       "49  historical             yr      cdd  1850-01-01T00:00:00   \n",
       "50  historical            mon      clt  1850-01-01T00:00:00   \n",
       "51  historical            mon  evspsbl  1850-01-01T00:00:00   \n",
       "52  historical            mon       fd  1850-01-01T00:00:00   \n",
       "\n",
       "               end_time  bbox level  \\\n",
       "48  2014-12-31T00:00:00   NaN   NaN   \n",
       "49  2014-12-31T00:00:00   NaN   NaN   \n",
       "50  2014-12-31T00:00:00   NaN   NaN   \n",
       "51  2014-12-31T00:00:00   NaN   NaN   \n",
       "52  2014-12-31T00:00:00   NaN   NaN   \n",
       "\n",
       "                                                  url  \n",
       "48  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "49  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "50  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "51  https://data.mips.copernicus-climate.eu/thredd...  \n",
       "52  https://data.mips.copernicus-climate.eu/thredd...  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df_cica_atlas.loc[\n",
    "    (df_cica_atlas.project==\"CMIP6\") \n",
    "]\n",
    "df.head()"
   ]
  }
 ],
 "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.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}