xarray_pandas_explore.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "e798145f-971c-484f-81ab-3943aeaabdc7",
   "metadata": {},
   "source": [
    "# 20220323: Explore the use of Xarray -> Pandas interface\n",
    "I want to generate gridded climate projection data to a table of variables for each lat, lon and time step in a NetCDF file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "362cdb08-4655-40d7-8179-b1fb889af1d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import xarray as xr\n",
    "import pandas as pd\n",
    "import iris #just incase\n",
    "import numpy as np\n",
    "import cartopy.crs as ccrs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "84537262-2427-4be6-a9a2-9f54d5e8e8b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><svg style=\"position: absolute; width: 0; height: 0; overflow: hidden\">\n",
       "<defs>\n",
       "<symbol id=\"icon-database\" viewBox=\"0 0 32 32\">\n",
       "<path d=\"M16 0c-8.837 0-16 2.239-16 5v4c0 2.761 7.163 5 16 5s16-2.239 16-5v-4c0-2.761-7.163-5-16-5z\"></path>\n",
       "<path d=\"M16 17c-8.837 0-16-2.239-16-5v6c0 2.761 7.163 5 16 5s16-2.239 16-5v-6c0 2.761-7.163 5-16 5z\"></path>\n",
       "<path d=\"M16 26c-8.837 0-16-2.239-16-5v6c0 2.761 7.163 5 16 5s16-2.239 16-5v-6c0 2.761-7.163 5-16 5z\"></path>\n",
       "</symbol>\n",
       "<symbol id=\"icon-file-text2\" viewBox=\"0 0 32 32\">\n",
       "<path d=\"M28.681 7.159c-0.694-0.947-1.662-2.053-2.724-3.116s-2.169-2.030-3.116-2.724c-1.612-1.182-2.393-1.319-2.841-1.319h-15.5c-1.378 0-2.5 1.121-2.5 2.5v27c0 1.378 1.122 2.5 2.5 2.5h23c1.378 0 2.5-1.122 2.5-2.5v-19.5c0-0.448-0.137-1.23-1.319-2.841zM24.543 5.457c0.959 0.959 1.712 1.825 2.268 2.543h-4.811v-4.811c0.718 0.556 1.584 1.309 2.543 2.268zM28 29.5c0 0.271-0.229 0.5-0.5 0.5h-23c-0.271 0-0.5-0.229-0.5-0.5v-27c0-0.271 0.229-0.5 0.5-0.5 0 0 15.499-0 15.5 0v7c0 0.552 0.448 1 1 1h7v19.5z\"></path>\n",
       "<path d=\"M23 26h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "<path d=\"M23 22h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "<path d=\"M23 18h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "</symbol>\n",
       "</defs>\n",
       "</svg>\n",
       "<style>/* CSS stylesheet for displaying xarray objects in jupyterlab.\n",
       " *\n",
       " */\n",
       "\n",
       ":root {\n",
       "  --xr-font-color0: var(--jp-content-font-color0, rgba(0, 0, 0, 1));\n",
       "  --xr-font-color2: var(--jp-content-font-color2, rgba(0, 0, 0, 0.54));\n",
       "  --xr-font-color3: var(--jp-content-font-color3, rgba(0, 0, 0, 0.38));\n",
       "  --xr-border-color: var(--jp-border-color2, #e0e0e0);\n",
       "  --xr-disabled-color: var(--jp-layout-color3, #bdbdbd);\n",
       "  --xr-background-color: var(--jp-layout-color0, white);\n",
       "  --xr-background-color-row-even: var(--jp-layout-color1, white);\n",
       "  --xr-background-color-row-odd: var(--jp-layout-color2, #eeeeee);\n",
       "}\n",
       "\n",
       "html[theme=dark],\n",
       "body.vscode-dark {\n",
       "  --xr-font-color0: rgba(255, 255, 255, 1);\n",
       "  --xr-font-color2: rgba(255, 255, 255, 0.54);\n",
       "  --xr-font-color3: rgba(255, 255, 255, 0.38);\n",
       "  --xr-border-color: #1F1F1F;\n",
       "  --xr-disabled-color: #515151;\n",
       "  --xr-background-color: #111111;\n",
       "  --xr-background-color-row-even: #111111;\n",
       "  --xr-background-color-row-odd: #313131;\n",
       "}\n",
       "\n",
       ".xr-wrap {\n",
       "  display: block !important;\n",
       "  min-width: 300px;\n",
       "  max-width: 700px;\n",
       "}\n",
       "\n",
       ".xr-text-repr-fallback {\n",
       "  /* fallback to plain text repr when CSS is not injected (untrusted notebook) */\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-header {\n",
       "  padding-top: 6px;\n",
       "  padding-bottom: 6px;\n",
       "  margin-bottom: 4px;\n",
       "  border-bottom: solid 1px var(--xr-border-color);\n",
       "}\n",
       "\n",
       ".xr-header > div,\n",
       ".xr-header > ul {\n",
       "  display: inline;\n",
       "  margin-top: 0;\n",
       "  margin-bottom: 0;\n",
       "}\n",
       "\n",
       ".xr-obj-type,\n",
       ".xr-array-name {\n",
       "  margin-left: 2px;\n",
       "  margin-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-obj-type {\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-sections {\n",
       "  padding-left: 0 !important;\n",
       "  display: grid;\n",
       "  grid-template-columns: 150px auto auto 1fr 20px 20px;\n",
       "}\n",
       "\n",
       ".xr-section-item {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-section-item input {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-section-item input + label {\n",
       "  color: var(--xr-disabled-color);\n",
       "}\n",
       "\n",
       ".xr-section-item input:enabled + label {\n",
       "  cursor: pointer;\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-section-item input:enabled + label:hover {\n",
       "  color: var(--xr-font-color0);\n",
       "}\n",
       "\n",
       ".xr-section-summary {\n",
       "  grid-column: 1;\n",
       "  color: var(--xr-font-color2);\n",
       "  font-weight: 500;\n",
       "}\n",
       "\n",
       ".xr-section-summary > span {\n",
       "  display: inline-block;\n",
       "  padding-left: 0.5em;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:disabled + label {\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-section-summary-in + label:before {\n",
       "  display: inline-block;\n",
       "  content: '►';\n",
       "  font-size: 11px;\n",
       "  width: 15px;\n",
       "  text-align: center;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:disabled + label:before {\n",
       "  color: var(--xr-disabled-color);\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked + label:before {\n",
       "  content: '▼';\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked + label > span {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-section-summary,\n",
       ".xr-section-inline-details {\n",
       "  padding-top: 4px;\n",
       "  padding-bottom: 4px;\n",
       "}\n",
       "\n",
       ".xr-section-inline-details {\n",
       "  grid-column: 2 / -1;\n",
       "}\n",
       "\n",
       ".xr-section-details {\n",
       "  display: none;\n",
       "  grid-column: 1 / -1;\n",
       "  margin-bottom: 5px;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked ~ .xr-section-details {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-array-wrap {\n",
       "  grid-column: 1 / -1;\n",
       "  display: grid;\n",
       "  grid-template-columns: 20px auto;\n",
       "}\n",
       "\n",
       ".xr-array-wrap > label {\n",
       "  grid-column: 1;\n",
       "  vertical-align: top;\n",
       "}\n",
       "\n",
       ".xr-preview {\n",
       "  color: var(--xr-font-color3);\n",
       "}\n",
       "\n",
       ".xr-array-preview,\n",
       ".xr-array-data {\n",
       "  padding: 0 5px !important;\n",
       "  grid-column: 2;\n",
       "}\n",
       "\n",
       ".xr-array-data,\n",
       ".xr-array-in:checked ~ .xr-array-preview {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-array-in:checked ~ .xr-array-data,\n",
       ".xr-array-preview {\n",
       "  display: inline-block;\n",
       "}\n",
       "\n",
       ".xr-dim-list {\n",
       "  display: inline-block !important;\n",
       "  list-style: none;\n",
       "  padding: 0 !important;\n",
       "  margin: 0;\n",
       "}\n",
       "\n",
       ".xr-dim-list li {\n",
       "  display: inline-block;\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "}\n",
       "\n",
       ".xr-dim-list:before {\n",
       "  content: '(';\n",
       "}\n",
       "\n",
       ".xr-dim-list:after {\n",
       "  content: ')';\n",
       "}\n",
       "\n",
       ".xr-dim-list li:not(:last-child):after {\n",
       "  content: ',';\n",
       "  padding-right: 5px;\n",
       "}\n",
       "\n",
       ".xr-has-index {\n",
       "  font-weight: bold;\n",
       "}\n",
       "\n",
       ".xr-var-list,\n",
       ".xr-var-item {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-var-item > div,\n",
       ".xr-var-item label,\n",
       ".xr-var-item > .xr-var-name span {\n",
       "  background-color: var(--xr-background-color-row-even);\n",
       "  margin-bottom: 0;\n",
       "}\n",
       "\n",
       ".xr-var-item > .xr-var-name:hover span {\n",
       "  padding-right: 5px;\n",
       "}\n",
       "\n",
       ".xr-var-list > li:nth-child(odd) > div,\n",
       ".xr-var-list > li:nth-child(odd) > label,\n",
       ".xr-var-list > li:nth-child(odd) > .xr-var-name span {\n",
       "  background-color: var(--xr-background-color-row-odd);\n",
       "}\n",
       "\n",
       ".xr-var-name {\n",
       "  grid-column: 1;\n",
       "}\n",
       "\n",
       ".xr-var-dims {\n",
       "  grid-column: 2;\n",
       "}\n",
       "\n",
       ".xr-var-dtype {\n",
       "  grid-column: 3;\n",
       "  text-align: right;\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-var-preview {\n",
       "  grid-column: 4;\n",
       "}\n",
       "\n",
       ".xr-var-name,\n",
       ".xr-var-dims,\n",
       ".xr-var-dtype,\n",
       ".xr-preview,\n",
       ".xr-attrs dt {\n",
       "  white-space: nowrap;\n",
       "  overflow: hidden;\n",
       "  text-overflow: ellipsis;\n",
       "  padding-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-var-name:hover,\n",
       ".xr-var-dims:hover,\n",
       ".xr-var-dtype:hover,\n",
       ".xr-attrs dt:hover {\n",
       "  overflow: visible;\n",
       "  width: auto;\n",
       "  z-index: 1;\n",
       "}\n",
       "\n",
       ".xr-var-attrs,\n",
       ".xr-var-data {\n",
       "  display: none;\n",
       "  background-color: var(--xr-background-color) !important;\n",
       "  padding-bottom: 5px !important;\n",
       "}\n",
       "\n",
       ".xr-var-attrs-in:checked ~ .xr-var-attrs,\n",
       ".xr-var-data-in:checked ~ .xr-var-data {\n",
       "  display: block;\n",
       "}\n",
       "\n",
       ".xr-var-data > table {\n",
       "  float: right;\n",
       "}\n",
       "\n",
       ".xr-var-name span,\n",
       ".xr-var-data,\n",
       ".xr-attrs {\n",
       "  padding-left: 25px !important;\n",
       "}\n",
       "\n",
       ".xr-attrs,\n",
       ".xr-var-attrs,\n",
       ".xr-var-data {\n",
       "  grid-column: 1 / -1;\n",
       "}\n",
       "\n",
       "dl.xr-attrs {\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "  display: grid;\n",
       "  grid-template-columns: 125px auto;\n",
       "}\n",
       "\n",
       ".xr-attrs dt,\n",
       ".xr-attrs dd {\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "  float: left;\n",
       "  padding-right: 10px;\n",
       "  width: auto;\n",
       "}\n",
       "\n",
       ".xr-attrs dt {\n",
       "  font-weight: normal;\n",
       "  grid-column: 1;\n",
       "}\n",
       "\n",
       ".xr-attrs dt:hover span {\n",
       "  display: inline-block;\n",
       "  background: var(--xr-background-color);\n",
       "  padding-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-attrs dd {\n",
       "  grid-column: 2;\n",
       "  white-space: pre-wrap;\n",
       "  word-break: break-all;\n",
       "}\n",
       "\n",
       ".xr-icon-database,\n",
       ".xr-icon-file-text2 {\n",
       "  display: inline-block;\n",
       "  vertical-align: middle;\n",
       "  width: 1em;\n",
       "  height: 1.5em !important;\n",
       "  stroke-width: 0;\n",
       "  stroke: currentColor;\n",
       "  fill: currentColor;\n",
       "}\n",
       "</style><pre class='xr-text-repr-fallback'>&lt;xarray.Dataset&gt;\n",
       "Dimensions:                       (ensemble_member: 1, time: 3600, projection_y_coordinate: 112, projection_x_coordinate: 82, bnds: 2)\n",
       "Coordinates:\n",
       "  * ensemble_member               (ensemble_member) int32 1\n",
       "  * time                          (time) object 2020-12-01 12:00:00 ... 2030-...\n",
       "  * projection_y_coordinate       (projection_y_coordinate) float64 -1.02e+05...\n",
       "  * projection_x_coordinate       (projection_x_coordinate) float64 -2.1e+05 ...\n",
       "    ensemble_member_id            (ensemble_member) |S27 b&#x27;HadREM3-GA705-r001...\n",
       "    grid_latitude                 (projection_y_coordinate, projection_x_coordinate) float64 ...\n",
       "    grid_longitude                (projection_y_coordinate, projection_x_coordinate) float64 ...\n",
       "    month_number                  (time) int32 12 12 12 12 12 ... 11 11 11 11 11\n",
       "    year                          (time) int32 2020 2020 2020 ... 2030 2030 2030\n",
       "    yyyymmdd                      (time) |S64 b&#x27;20201201                     ...\n",
       "Dimensions without coordinates: bnds\n",
       "Data variables:\n",
       "    pr                            (ensemble_member, time, projection_y_coordinate, projection_x_coordinate) float32 ...\n",
       "    transverse_mercator           int32 -2147483647\n",
       "    time_bnds                     (time, bnds) object 2020-12-01 00:00:00 ......\n",
       "    projection_y_coordinate_bnds  (projection_y_coordinate, bnds) float64 -1....\n",
       "    projection_x_coordinate_bnds  (projection_x_coordinate, bnds) float64 -2....\n",
       "Attributes: (12/15)\n",
       "    collection:      land-rcm\n",
       "    contact:         ukcpproject@metoffice.gov.uk\n",
       "    creation_date:   2019-07-31T00:00\n",
       "    domain:          uk\n",
       "    frequency:       day\n",
       "    institution:     Met Office Hadley Centre (MOHC), FitzRoy Road, Exeter, D...\n",
       "    ...              ...\n",
       "    resolution:      12km\n",
       "    scenario:        rcp85\n",
       "    source:          UKCP18 regional realisation from a set of 12 limited-are...\n",
       "    title:           UKCP18 land projections - 12km regional climate model, p...\n",
       "    version:         v20190731\n",
       "    Conventions:     CF-1.5</pre><div class='xr-wrap' style='display:none'><div class='xr-header'><div class='xr-obj-type'>xarray.Dataset</div></div><ul class='xr-sections'><li class='xr-section-item'><input id='section-03b17b28-6e1e-4b12-aa6f-0b7d578f1b41' class='xr-section-summary-in' type='checkbox' disabled ><label for='section-03b17b28-6e1e-4b12-aa6f-0b7d578f1b41' class='xr-section-summary'  title='Expand/collapse section'>Dimensions:</label><div class='xr-section-inline-details'><ul class='xr-dim-list'><li><span class='xr-has-index'>ensemble_member</span>: 1</li><li><span class='xr-has-index'>time</span>: 3600</li><li><span class='xr-has-index'>projection_y_coordinate</span>: 112</li><li><span class='xr-has-index'>projection_x_coordinate</span>: 82</li><li><span>bnds</span>: 2</li></ul></div><div class='xr-section-details'></div></li><li class='xr-section-item'><input id='section-eea7a1b0-cc72-4d86-89d1-ed345c2ed910' class='xr-section-summary-in' type='checkbox'  checked><label for='section-eea7a1b0-cc72-4d86-89d1-ed345c2ed910' class='xr-section-summary' >Coordinates: <span>(10)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><ul class='xr-var-list'><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>ensemble_member</span></div><div class='xr-var-dims'>(ensemble_member)</div><div class='xr-var-dtype'>int32</div><div class='xr-var-preview xr-preview'>1</div><input id='attrs-27f6d814-b4ed-4623-a245-701f77944bdc' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-27f6d814-b4ed-4623-a245-701f77944bdc' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-f1cf2519-b8b5-4e06-810f-26b9a4ca2349' class='xr-var-data-in' type='checkbox'><label for='data-f1cf2519-b8b5-4e06-810f-26b9a4ca2349' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>1</dd><dt><span>long_name :</span></dt><dd>ensemble_member</dd></dl></div><div class='xr-var-data'><pre>array([1], dtype=int32)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>time</span></div><div class='xr-var-dims'>(time)</div><div class='xr-var-dtype'>object</div><div class='xr-var-preview xr-preview'>2020-12-01 12:00:00 ... 2030-11-...</div><input id='attrs-f4cdb15b-16e2-4394-88d4-71ce59eba6b3' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-f4cdb15b-16e2-4394-88d4-71ce59eba6b3' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-0f22ecae-422e-4922-b693-023ff2bc8e16' class='xr-var-data-in' type='checkbox'><label for='data-0f22ecae-422e-4922-b693-023ff2bc8e16' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>axis :</span></dt><dd>T</dd><dt><span>bounds :</span></dt><dd>time_bnds</dd><dt><span>standard_name :</span></dt><dd>time</dd></dl></div><div class='xr-var-data'><pre>array([cftime.Datetime360Day(2020, 12, 1, 12, 0, 0, 0),\n",
       "       cftime.Datetime360Day(2020, 12, 2, 12, 0, 0, 0),\n",
       "       cftime.Datetime360Day(2020, 12, 3, 12, 0, 0, 0), ...,\n",
       "       cftime.Datetime360Day(2030, 11, 28, 12, 0, 0, 0),\n",
       "       cftime.Datetime360Day(2030, 11, 29, 12, 0, 0, 0),\n",
       "       cftime.Datetime360Day(2030, 11, 30, 12, 0, 0, 0)], dtype=object)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>projection_y_coordinate</span></div><div class='xr-var-dims'>(projection_y_coordinate)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>-1.02e+05 -9e+04 ... 1.23e+06</div><input id='attrs-ba5473a0-0acc-430c-8b5a-a829af2d9363' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-ba5473a0-0acc-430c-8b5a-a829af2d9363' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-6a89df1f-807c-4084-a5b8-5dbd8eb895c9' class='xr-var-data-in' type='checkbox'><label for='data-6a89df1f-807c-4084-a5b8-5dbd8eb895c9' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>axis :</span></dt><dd>Y</dd><dt><span>bounds :</span></dt><dd>projection_y_coordinate_bnds</dd><dt><span>units :</span></dt><dd>m</dd><dt><span>standard_name :</span></dt><dd>projection_y_coordinate</dd></dl></div><div class='xr-var-data'><pre>array([-102000.,  -90000.,  -78000.,  -66000.,  -54000.,  -42000.,  -30000.,\n",
       "        -18000.,   -6000.,    6000.,   18000.,   30000.,   42000.,   54000.,\n",
       "         66000.,   78000.,   90000.,  102000.,  114000.,  126000.,  138000.,\n",
       "        150000.,  162000.,  174000.,  186000.,  198000.,  210000.,  222000.,\n",
       "        234000.,  246000.,  258000.,  270000.,  282000.,  294000.,  306000.,\n",
       "        318000.,  330000.,  342000.,  354000.,  366000.,  378000.,  390000.,\n",
       "        402000.,  414000.,  426000.,  438000.,  450000.,  462000.,  474000.,\n",
       "        486000.,  498000.,  510000.,  522000.,  534000.,  546000.,  558000.,\n",
       "        570000.,  582000.,  594000.,  606000.,  618000.,  630000.,  642000.,\n",
       "        654000.,  666000.,  678000.,  690000.,  702000.,  714000.,  726000.,\n",
       "        738000.,  750000.,  762000.,  774000.,  786000.,  798000.,  810000.,\n",
       "        822000.,  834000.,  846000.,  858000.,  870000.,  882000.,  894000.,\n",
       "        906000.,  918000.,  930000.,  942000.,  954000.,  966000.,  978000.,\n",
       "        990000., 1002000., 1014000., 1026000., 1038000., 1050000., 1062000.,\n",
       "       1074000., 1086000., 1098000., 1110000., 1122000., 1134000., 1146000.,\n",
       "       1158000., 1170000., 1182000., 1194000., 1206000., 1218000., 1230000.])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>projection_x_coordinate</span></div><div class='xr-var-dims'>(projection_x_coordinate)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>-2.1e+05 -1.98e+05 ... 7.62e+05</div><input id='attrs-22828841-2eb9-49d9-9c0e-a140f1e4df1c' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-22828841-2eb9-49d9-9c0e-a140f1e4df1c' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-23e2edad-8ddd-41e7-a5d1-76612b78c293' class='xr-var-data-in' type='checkbox'><label for='data-23e2edad-8ddd-41e7-a5d1-76612b78c293' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>axis :</span></dt><dd>X</dd><dt><span>bounds :</span></dt><dd>projection_x_coordinate_bnds</dd><dt><span>units :</span></dt><dd>m</dd><dt><span>standard_name :</span></dt><dd>projection_x_coordinate</dd></dl></div><div class='xr-var-data'><pre>array([-210000., -198000., -186000., -174000., -162000., -150000., -138000.,\n",
       "       -126000., -114000., -102000.,  -90000.,  -78000.,  -66000.,  -54000.,\n",
       "        -42000.,  -30000.,  -18000.,   -6000.,    6000.,   18000.,   30000.,\n",
       "         42000.,   54000.,   66000.,   78000.,   90000.,  102000.,  114000.,\n",
       "        126000.,  138000.,  150000.,  162000.,  174000.,  186000.,  198000.,\n",
       "        210000.,  222000.,  234000.,  246000.,  258000.,  270000.,  282000.,\n",
       "        294000.,  306000.,  318000.,  330000.,  342000.,  354000.,  366000.,\n",
       "        378000.,  390000.,  402000.,  414000.,  426000.,  438000.,  450000.,\n",
       "        462000.,  474000.,  486000.,  498000.,  510000.,  522000.,  534000.,\n",
       "        546000.,  558000.,  570000.,  582000.,  594000.,  606000.,  618000.,\n",
       "        630000.,  642000.,  654000.,  666000.,  678000.,  690000.,  702000.,\n",
       "        714000.,  726000.,  738000.,  750000.,  762000.])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>ensemble_member_id</span></div><div class='xr-var-dims'>(ensemble_member)</div><div class='xr-var-dtype'>|S27</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-1bc39880-0075-4673-9cae-6a563ce1fe4a' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-1bc39880-0075-4673-9cae-6a563ce1fe4a' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-10f7f2a8-7fc3-408f-9850-8fb5c6d506f2' class='xr-var-data-in' type='checkbox'><label for='data-10f7f2a8-7fc3-408f-9850-8fb5c6d506f2' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>1</dd><dt><span>long_name :</span></dt><dd>ensemble_member_id</dd></dl></div><div class='xr-var-data'><pre>array([b&#x27;HadREM3-GA705-r001i1p00000 &#x27;], dtype=&#x27;|S27&#x27;)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>grid_latitude</span></div><div class='xr-var-dims'>(projection_y_coordinate, projection_x_coordinate)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-21f22bc3-c689-46ec-a36a-fdb8131602f6' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-21f22bc3-c689-46ec-a36a-fdb8131602f6' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-1ef620a8-edd5-4104-bb9c-15b5e62bef83' class='xr-var-data-in' type='checkbox'><label for='data-1ef620a8-edd5-4104-bb9c-15b5e62bef83' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>degrees_north</dd><dt><span>standard_name :</span></dt><dd>grid_latitude</dd></dl></div><div class='xr-var-data'><pre>array([[ 1.432699,  1.404462,  1.376215, ..., -0.814169, -0.842618, -0.871062],\n",
       "       [ 1.536353,  1.508133,  1.479903, ..., -0.7102  , -0.738658, -0.767112],\n",
       "       [ 1.640009,  1.611807,  1.583594, ..., -0.606235, -0.634703, -0.663167],\n",
       "       ...,\n",
       "       [12.742209, 12.715315, 12.688373, ..., 10.485867, 10.455806, 10.425714],\n",
       "       [12.846025, 12.819138, 12.792204, ..., 10.589177, 10.559096, 10.528984],\n",
       "       [12.949841, 12.922962, 12.896034, ..., 10.69248 , 10.662379, 10.632246]])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>grid_longitude</span></div><div class='xr-var-dims'>(projection_y_coordinate, projection_x_coordinate)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-cd515501-b245-47ed-8a98-28be9f47399a' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-cd515501-b245-47ed-8a98-28be9f47399a' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-73386bd6-1cc9-43ba-ac48-b85d19278304' class='xr-var-data-in' type='checkbox'><label for='data-73386bd6-1cc9-43ba-ac48-b85d19278304' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>degrees_east</dd><dt><span>standard_name :</span></dt><dd>grid_longitude</dd></dl></div><div class='xr-var-data'><pre>array([[-18.241456, -18.138041, -18.034611, ..., -10.048993,  -9.945325,\n",
       "         -9.841665],\n",
       "       [-18.213078, -18.109654, -18.006215, ..., -10.020489,  -9.916826,\n",
       "         -9.813173],\n",
       "       [-18.184716, -18.081283, -17.977835, ...,  -9.991977,  -9.888319,\n",
       "         -9.784672],\n",
       "       ...,\n",
       "       [-15.206875, -15.100591, -14.99431 , ...,  -6.851294,  -6.746416,\n",
       "         -6.64157 ],\n",
       "       [-15.179224, -15.072894, -14.966569, ...,  -6.820707,  -6.715801,\n",
       "         -6.610926],\n",
       "       [-15.15157 , -15.045194, -14.938824, ...,  -6.79009 ,  -6.685155,\n",
       "         -6.580251]])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>month_number</span></div><div class='xr-var-dims'>(time)</div><div class='xr-var-dtype'>int32</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-5d27fab1-b8d3-4a41-8f6a-8b6b352e471a' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-5d27fab1-b8d3-4a41-8f6a-8b6b352e471a' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-99d29476-720e-44d0-8655-4177a5a88a8d' class='xr-var-data-in' type='checkbox'><label for='data-99d29476-720e-44d0-8655-4177a5a88a8d' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>1</dd><dt><span>long_name :</span></dt><dd>month_number</dd></dl></div><div class='xr-var-data'><pre>array([12, 12, 12, ..., 11, 11, 11], dtype=int32)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>year</span></div><div class='xr-var-dims'>(time)</div><div class='xr-var-dtype'>int32</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-21da4996-0047-43b3-ae45-851df3ab91b4' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-21da4996-0047-43b3-ae45-851df3ab91b4' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-8940fc00-5784-436e-bc52-c04031c62c81' class='xr-var-data-in' type='checkbox'><label for='data-8940fc00-5784-436e-bc52-c04031c62c81' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>1</dd><dt><span>long_name :</span></dt><dd>year</dd></dl></div><div class='xr-var-data'><pre>array([2020, 2020, 2020, ..., 2030, 2030, 2030], dtype=int32)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>yyyymmdd</span></div><div class='xr-var-dims'>(time)</div><div class='xr-var-dtype'>|S64</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-4f067563-d32a-4db0-8940-8e9ef7bf274c' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-4f067563-d32a-4db0-8940-8e9ef7bf274c' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-ca0ba5a5-b05c-4570-8595-b5719b26e3ee' class='xr-var-data-in' type='checkbox'><label for='data-ca0ba5a5-b05c-4570-8595-b5719b26e3ee' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>1</dd><dt><span>long_name :</span></dt><dd>yyyymmdd</dd></dl></div><div class='xr-var-data'><pre>array([b&#x27;20201201                                                        &#x27;,\n",
       "       b&#x27;20201202                                                        &#x27;,\n",
       "       b&#x27;20201203                                                        &#x27;,\n",
       "       ...,\n",
       "       b&#x27;20301128                                                        &#x27;,\n",
       "       b&#x27;20301129                                                        &#x27;,\n",
       "       b&#x27;20301130                                                        &#x27;],\n",
       "      dtype=&#x27;|S64&#x27;)</pre></div></li></ul></div></li><li class='xr-section-item'><input id='section-8c9a53f6-ca67-4e2b-b795-928822482e32' class='xr-section-summary-in' type='checkbox'  checked><label for='section-8c9a53f6-ca67-4e2b-b795-928822482e32' class='xr-section-summary' >Data variables: <span>(5)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><ul class='xr-var-list'><li class='xr-var-item'><div class='xr-var-name'><span>pr</span></div><div class='xr-var-dims'>(ensemble_member, time, projection_y_coordinate, projection_x_coordinate)</div><div class='xr-var-dtype'>float32</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-2f5790c2-dc9c-4bd3-9415-7e586dd658dd' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-2f5790c2-dc9c-4bd3-9415-7e586dd658dd' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-7419db71-4e5c-496f-bf1f-e38c76ff90a9' class='xr-var-data-in' type='checkbox'><label for='data-7419db71-4e5c-496f-bf1f-e38c76ff90a9' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>standard_name :</span></dt><dd>lwe_precipitation_rate</dd><dt><span>long_name :</span></dt><dd>Precipitation rate</dd><dt><span>units :</span></dt><dd>mm/day</dd><dt><span>description :</span></dt><dd>Precipitation rate</dd><dt><span>label_units :</span></dt><dd>mm/day</dd><dt><span>plot_label :</span></dt><dd>Precipitation rate (mm/day)</dd><dt><span>cell_methods :</span></dt><dd>time: mean</dd><dt><span>grid_mapping :</span></dt><dd>transverse_mercator</dd></dl></div><div class='xr-var-data'><pre>[33062400 values with dtype=float32]</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>transverse_mercator</span></div><div class='xr-var-dims'>()</div><div class='xr-var-dtype'>int32</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-58ae3b86-db97-4b75-9dd3-04b8f278c59d' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-58ae3b86-db97-4b75-9dd3-04b8f278c59d' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-19793e39-d66b-4352-8f99-4c995dd89023' class='xr-var-data-in' type='checkbox'><label for='data-19793e39-d66b-4352-8f99-4c995dd89023' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>grid_mapping_name :</span></dt><dd>transverse_mercator</dd><dt><span>longitude_of_prime_meridian :</span></dt><dd>0.0</dd><dt><span>semi_major_axis :</span></dt><dd>6377563.396</dd><dt><span>semi_minor_axis :</span></dt><dd>6356256.909</dd><dt><span>longitude_of_central_meridian :</span></dt><dd>-2.0</dd><dt><span>latitude_of_projection_origin :</span></dt><dd>49.0</dd><dt><span>false_easting :</span></dt><dd>400000.0</dd><dt><span>false_northing :</span></dt><dd>-100000.0</dd><dt><span>scale_factor_at_central_meridian :</span></dt><dd>0.9996012717</dd></dl></div><div class='xr-var-data'><pre>array(-2147483647, dtype=int32)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>time_bnds</span></div><div class='xr-var-dims'>(time, bnds)</div><div class='xr-var-dtype'>object</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-634a6f74-9aac-40ce-8441-ef4e3e5b7125' class='xr-var-attrs-in' type='checkbox' disabled><label for='attrs-634a6f74-9aac-40ce-8441-ef4e3e5b7125' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-9a3ad663-2ba2-44bb-8ae7-5c16834e3454' class='xr-var-data-in' type='checkbox'><label for='data-9a3ad663-2ba2-44bb-8ae7-5c16834e3454' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'></dl></div><div class='xr-var-data'><pre>array([[cftime.Datetime360Day(2020, 12, 1, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2020, 12, 2, 0, 0, 0, 0)],\n",
       "       [cftime.Datetime360Day(2020, 12, 2, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2020, 12, 3, 0, 0, 0, 0)],\n",
       "       [cftime.Datetime360Day(2020, 12, 3, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2020, 12, 4, 0, 0, 0, 0)],\n",
       "       ...,\n",
       "       [cftime.Datetime360Day(2030, 11, 28, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2030, 11, 29, 0, 0, 0, 0)],\n",
       "       [cftime.Datetime360Day(2030, 11, 29, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2030, 11, 30, 0, 0, 0, 0)],\n",
       "       [cftime.Datetime360Day(2030, 11, 30, 0, 0, 0, 0),\n",
       "        cftime.Datetime360Day(2030, 12, 1, 0, 0, 0, 0)]], dtype=object)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>projection_y_coordinate_bnds</span></div><div class='xr-var-dims'>(projection_y_coordinate, bnds)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-c4db5aa2-44c5-48ea-b09e-e356f7b4c91c' class='xr-var-attrs-in' type='checkbox' disabled><label for='attrs-c4db5aa2-44c5-48ea-b09e-e356f7b4c91c' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-6e960593-7cb9-4d05-b708-cf94cdf48935' class='xr-var-data-in' type='checkbox'><label for='data-6e960593-7cb9-4d05-b708-cf94cdf48935' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'></dl></div><div class='xr-var-data'><pre>array([[-108000.,  -96000.],\n",
       "       [ -96000.,  -84000.],\n",
       "       [ -84000.,  -72000.],\n",
       "       ...,\n",
       "       [1200000., 1212000.],\n",
       "       [1212000., 1224000.],\n",
       "       [1224000., 1236000.]])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>projection_x_coordinate_bnds</span></div><div class='xr-var-dims'>(projection_x_coordinate, bnds)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>...</div><input id='attrs-72a28a1b-66ba-4dfb-ad71-6af0a95ba016' class='xr-var-attrs-in' type='checkbox' disabled><label for='attrs-72a28a1b-66ba-4dfb-ad71-6af0a95ba016' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-b76d9370-3e8e-4296-8b09-c646fc546b77' class='xr-var-data-in' type='checkbox'><label for='data-b76d9370-3e8e-4296-8b09-c646fc546b77' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'></dl></div><div class='xr-var-data'><pre>array([[-216000., -204000.],\n",
       "       [-204000., -192000.],\n",
       "       [-192000., -180000.],\n",
       "       [-180000., -168000.],\n",
       "       [-168000., -156000.],\n",
       "       [-156000., -144000.],\n",
       "       [-144000., -132000.],\n",
       "       [-132000., -120000.],\n",
       "       [-120000., -108000.],\n",
       "       [-108000.,  -96000.],\n",
       "       [ -96000.,  -84000.],\n",
       "       [ -84000.,  -72000.],\n",
       "       [ -72000.,  -60000.],\n",
       "       [ -60000.,  -48000.],\n",
       "       [ -48000.,  -36000.],\n",
       "       [ -36000.,  -24000.],\n",
       "       [ -24000.,  -12000.],\n",
       "       [ -12000.,       0.],\n",
       "       [      0.,   12000.],\n",
       "       [  12000.,   24000.],\n",
       "       [  24000.,   36000.],\n",
       "       [  36000.,   48000.],\n",
       "       [  48000.,   60000.],\n",
       "       [  60000.,   72000.],\n",
       "       [  72000.,   84000.],\n",
       "       [  84000.,   96000.],\n",
       "       [  96000.,  108000.],\n",
       "       [ 108000.,  120000.],\n",
       "       [ 120000.,  132000.],\n",
       "       [ 132000.,  144000.],\n",
       "       [ 144000.,  156000.],\n",
       "       [ 156000.,  168000.],\n",
       "       [ 168000.,  180000.],\n",
       "       [ 180000.,  192000.],\n",
       "       [ 192000.,  204000.],\n",
       "       [ 204000.,  216000.],\n",
       "       [ 216000.,  228000.],\n",
       "       [ 228000.,  240000.],\n",
       "       [ 240000.,  252000.],\n",
       "       [ 252000.,  264000.],\n",
       "       [ 264000.,  276000.],\n",
       "       [ 276000.,  288000.],\n",
       "       [ 288000.,  300000.],\n",
       "       [ 300000.,  312000.],\n",
       "       [ 312000.,  324000.],\n",
       "       [ 324000.,  336000.],\n",
       "       [ 336000.,  348000.],\n",
       "       [ 348000.,  360000.],\n",
       "       [ 360000.,  372000.],\n",
       "       [ 372000.,  384000.],\n",
       "       [ 384000.,  396000.],\n",
       "       [ 396000.,  408000.],\n",
       "       [ 408000.,  420000.],\n",
       "       [ 420000.,  432000.],\n",
       "       [ 432000.,  444000.],\n",
       "       [ 444000.,  456000.],\n",
       "       [ 456000.,  468000.],\n",
       "       [ 468000.,  480000.],\n",
       "       [ 480000.,  492000.],\n",
       "       [ 492000.,  504000.],\n",
       "       [ 504000.,  516000.],\n",
       "       [ 516000.,  528000.],\n",
       "       [ 528000.,  540000.],\n",
       "       [ 540000.,  552000.],\n",
       "       [ 552000.,  564000.],\n",
       "       [ 564000.,  576000.],\n",
       "       [ 576000.,  588000.],\n",
       "       [ 588000.,  600000.],\n",
       "       [ 600000.,  612000.],\n",
       "       [ 612000.,  624000.],\n",
       "       [ 624000.,  636000.],\n",
       "       [ 636000.,  648000.],\n",
       "       [ 648000.,  660000.],\n",
       "       [ 660000.,  672000.],\n",
       "       [ 672000.,  684000.],\n",
       "       [ 684000.,  696000.],\n",
       "       [ 696000.,  708000.],\n",
       "       [ 708000.,  720000.],\n",
       "       [ 720000.,  732000.],\n",
       "       [ 732000.,  744000.],\n",
       "       [ 744000.,  756000.],\n",
       "       [ 756000.,  768000.]])</pre></div></li></ul></div></li><li class='xr-section-item'><input id='section-815fad39-11bc-4249-9c55-b9f5550249ad' class='xr-section-summary-in' type='checkbox'  ><label for='section-815fad39-11bc-4249-9c55-b9f5550249ad' class='xr-section-summary' >Attributes: <span>(15)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><dl class='xr-attrs'><dt><span>collection :</span></dt><dd>land-rcm</dd><dt><span>contact :</span></dt><dd>ukcpproject@metoffice.gov.uk</dd><dt><span>creation_date :</span></dt><dd>2019-07-31T00:00</dd><dt><span>domain :</span></dt><dd>uk</dd><dt><span>frequency :</span></dt><dd>day</dd><dt><span>institution :</span></dt><dd>Met Office Hadley Centre (MOHC), FitzRoy Road, Exeter, Devon, EX1 3PB, UK.</dd><dt><span>institution_id :</span></dt><dd>MOHC</dd><dt><span>project :</span></dt><dd>UKCP18</dd><dt><span>references :</span></dt><dd>https://ukclimateprojections.metoffice.gov.uk</dd><dt><span>resolution :</span></dt><dd>12km</dd><dt><span>scenario :</span></dt><dd>rcp85</dd><dt><span>source :</span></dt><dd>UKCP18 regional realisation from a set of 12 limited-area Met Office Unified Model Global Atmosphere GA7 models at 12km resolution driven by perturbed variants of the global HadGEM3-GC3.05</dd><dt><span>title :</span></dt><dd>UKCP18 land projections - 12km regional climate model, precipitation rate (mm/day) over the UK for the RCP 8.5 scenario</dd><dt><span>version :</span></dt><dd>v20190731</dd><dt><span>Conventions :</span></dt><dd>CF-1.5</dd></dl></div></li></ul></div></div>"
      ],
      "text/plain": [
       "<xarray.Dataset>\n",
       "Dimensions:                       (ensemble_member: 1, time: 3600, projection_y_coordinate: 112, projection_x_coordinate: 82, bnds: 2)\n",
       "Coordinates:\n",
       "  * ensemble_member               (ensemble_member) int32 1\n",
       "  * time                          (time) object 2020-12-01 12:00:00 ... 2030-...\n",
       "  * projection_y_coordinate       (projection_y_coordinate) float64 -1.02e+05...\n",
       "  * projection_x_coordinate       (projection_x_coordinate) float64 -2.1e+05 ...\n",
       "    ensemble_member_id            (ensemble_member) |S27 ...\n",
       "    grid_latitude                 (projection_y_coordinate, projection_x_coordinate) float64 ...\n",
       "    grid_longitude                (projection_y_coordinate, projection_x_coordinate) float64 ...\n",
       "    month_number                  (time) int32 ...\n",
       "    year                          (time) int32 ...\n",
       "    yyyymmdd                      (time) |S64 ...\n",
       "Dimensions without coordinates: bnds\n",
       "Data variables:\n",
       "    pr                            (ensemble_member, time, projection_y_coordinate, projection_x_coordinate) float32 ...\n",
       "    transverse_mercator           int32 ...\n",
       "    time_bnds                     (time, bnds) object ...\n",
       "    projection_y_coordinate_bnds  (projection_y_coordinate, bnds) float64 ...\n",
       "    projection_x_coordinate_bnds  (projection_x_coordinate, bnds) float64 ...\n",
       "Attributes: (12/15)\n",
       "    collection:      land-rcm\n",
       "    contact:         ukcpproject@metoffice.gov.uk\n",
       "    creation_date:   2019-07-31T00:00\n",
       "    domain:          uk\n",
       "    frequency:       day\n",
       "    institution:     Met Office Hadley Centre (MOHC), FitzRoy Road, Exeter, D...\n",
       "    ...              ...\n",
       "    resolution:      12km\n",
       "    scenario:        rcp85\n",
       "    source:          UKCP18 regional realisation from a set of 12 limited-are...\n",
       "    title:           UKCP18 land projections - 12km regional climate model, p...\n",
       "    version:         v20190731\n",
       "    Conventions:     CF-1.5"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fname = \"pr_rcp85_land-rcm_uk_12km_01_day_20201201-20301130.nc\"\n",
    "ds = xr.open_dataset(fname)\n",
    "ds"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2ed0bdd6-9e04-4920-b402-1a5f383f4535",
   "metadata": {},
   "source": [
    "## Transform into Pandas dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a383453e-f39b-4324-9a2f-0f1caa8df746",
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<timed exec>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n",
      "\u001b[0;32m~/opt/miniconda3/envs/data/lib/python3.7/site-packages/xarray/core/dataset.py\u001b[0m in \u001b[0;36mto_dataframe\u001b[0;34m(self, dim_order)\u001b[0m\n\u001b[1;32m   5394\u001b[0m         \u001b[0mordered_dims\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_normalize_dim_order\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdim_order\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mdim_order\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   5395\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 5396\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_to_dataframe\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   5397\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   5398\u001b[0m     def _set_sparse_data_from_dataframe(\n",
      "\u001b[0;32m~/opt/miniconda3/envs/data/lib/python3.7/site-packages/xarray/core/dataset.py\u001b[0m in \u001b[0;36m_to_dataframe\u001b[0;34m(self, ordered_dims)\u001b[0m\n\u001b[1;32m   5360\u001b[0m         data = [\n\u001b[1;32m   5361\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_variables\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mk\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mset_dims\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreshape\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 5362\u001b[0;31m             \u001b[0;32mfor\u001b[0m \u001b[0mk\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   5363\u001b[0m         ]\n\u001b[1;32m   5364\u001b[0m         \u001b[0mindex\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/miniconda3/envs/data/lib/python3.7/site-packages/xarray/core/dataset.py\u001b[0m in \u001b[0;36m<listcomp>\u001b[0;34m(.0)\u001b[0m\n\u001b[1;32m   5360\u001b[0m         data = [\n\u001b[1;32m   5361\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_variables\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mk\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mset_dims\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreshape\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 5362\u001b[0;31m             \u001b[0;32mfor\u001b[0m \u001b[0mk\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   5363\u001b[0m         ]\n\u001b[1;32m   5364\u001b[0m         \u001b[0mindex\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0mordered_dims\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "%%time\n",
    "df = ds.to_dataframe().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a36435c5-a933-4faa-a4a0-4e2c1942aa53",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'df' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-5-c42a15b2c7cf>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'df' is not defined"
     ]
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "158d140e-0f30-4354-9759-57edb18f9601",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['grid_latitude']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "03e88568-bf43-4e8a-9cdf-643a25a1a565",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[['grid_latitude', 'grid_latitude']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "ee56783a-f657-4459-9aca-eaba7ae991ee",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 3.05 s, sys: 9.45 s, total: 12.5 s\n",
      "Wall time: 15.1 s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "pr = df[['yyyymmdd', 'month_number', 'year', 'pr', 'grid_latitude', 'grid_longitude', 'ensemble_member']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "a84bd6db-7740-4857-97ce-3e90e1c0b6bb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 51.1 s, sys: 38.2 s, total: 1min 29s\n",
      "Wall time: 1min 49s\n"
     ]
    },
    {
     "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>yyyymmdd</th>\n",
       "      <th>month_number</th>\n",
       "      <th>year</th>\n",
       "      <th>pr</th>\n",
       "      <th>grid_latitude</th>\n",
       "      <th>grid_longitude</th>\n",
       "      <th>ensemble_member</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b'20201201                                    ...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>0.690706</td>\n",
       "      <td>1.432699</td>\n",
       "      <td>-18.241456</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b'20201201                                    ...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>0.853663</td>\n",
       "      <td>1.404462</td>\n",
       "      <td>-18.138041</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b'20201201                                    ...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.088705</td>\n",
       "      <td>1.376215</td>\n",
       "      <td>-18.034611</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b'20201201                                    ...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.452076</td>\n",
       "      <td>1.347959</td>\n",
       "      <td>-17.931165</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>b'20201201                                    ...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.969763</td>\n",
       "      <td>1.319692</td>\n",
       "      <td>-17.827705</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062395</th>\n",
       "      <td>b'20301130                                    ...</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.989718</td>\n",
       "      <td>10.752585</td>\n",
       "      <td>-7.000053</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062396</th>\n",
       "      <td>b'20301130                                    ...</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.240123</td>\n",
       "      <td>10.722549</td>\n",
       "      <td>-6.895056</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062397</th>\n",
       "      <td>b'20301130                                    ...</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.035135</td>\n",
       "      <td>10.692480</td>\n",
       "      <td>-6.790090</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062398</th>\n",
       "      <td>b'20301130                                    ...</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.000422</td>\n",
       "      <td>10.662379</td>\n",
       "      <td>-6.685155</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062399</th>\n",
       "      <td>b'20301130                                    ...</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>10.632246</td>\n",
       "      <td>-6.580251</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33062400 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   yyyymmdd  month_number  \\\n",
       "0         b'20201201                                    ...            12   \n",
       "1         b'20201201                                    ...            12   \n",
       "2         b'20201201                                    ...            12   \n",
       "3         b'20201201                                    ...            12   \n",
       "4         b'20201201                                    ...            12   \n",
       "...                                                     ...           ...   \n",
       "33062395  b'20301130                                    ...            11   \n",
       "33062396  b'20301130                                    ...            11   \n",
       "33062397  b'20301130                                    ...            11   \n",
       "33062398  b'20301130                                    ...            11   \n",
       "33062399  b'20301130                                    ...            11   \n",
       "\n",
       "          year        pr  grid_latitude  grid_longitude  ensemble_member  \n",
       "0         2020  0.690706       1.432699      -18.241456                1  \n",
       "1         2020  0.853663       1.404462      -18.138041                1  \n",
       "2         2020  1.088705       1.376215      -18.034611                1  \n",
       "3         2020  1.452076       1.347959      -17.931165                1  \n",
       "4         2020  1.969763       1.319692      -17.827705                1  \n",
       "...        ...       ...            ...             ...              ...  \n",
       "33062395  2030  0.989718      10.752585       -7.000053                1  \n",
       "33062396  2030  0.240123      10.722549       -6.895056                1  \n",
       "33062397  2030  0.035135      10.692480       -6.790090                1  \n",
       "33062398  2030  0.000422      10.662379       -6.685155                1  \n",
       "33062399  2030  0.000002      10.632246       -6.580251                1  \n",
       "\n",
       "[33062400 rows x 7 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%time\n",
    "pr.drop_duplicates(ignore_index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c23df6f-4681-498d-91eb-dd28a7297cca",
   "metadata": {},
   "source": [
    "## Final Xarray -> Pandas pipeline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b37fa3d7-78b3-41f6-8029-872d9c9530b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = (ds.to_dataframe()\n",
    "      .reset_index()\n",
    "      [['yyyymmdd', 'month_number', 'year', 'pr', 'grid_latitude', 'grid_longitude', 'ensemble_member']]\n",
    "      .drop_duplicates(ignore_index=True)\n",
    "     )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5527e8c3-3e6a-49c1-a87b-f12280876e03",
   "metadata": {},
   "source": [
    "## Generate lat-lon pairs in Xarray Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a6e77b1e-ea68-4689-84d4-1ce751b0359a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import cartopy.crs as ccrs"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "088ca2ea-e9c0-4923-b787-42222dde36dc",
   "metadata": {},
   "source": [
    "### Add lat lon coords using Iris"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "f6121fa6-f02e-4735-8f4f-c1f2315ee1b0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  a.iris {\n",
       "      text-decoration: none !important;\n",
       "  }\n",
       "  table.iris {\n",
       "      white-space: pre;\n",
       "      border: 1px solid;\n",
       "      border-color: #9c9c9c;\n",
       "      font-family: monaco, monospace;\n",
       "  }\n",
       "  th.iris {\n",
       "      background: #303f3f;\n",
       "      color: #e0e0e0;\n",
       "      border-left: 1px solid;\n",
       "      border-color: #9c9c9c;\n",
       "      font-size: 1.05em;\n",
       "      min-width: 50px;\n",
       "      max-width: 125px;\n",
       "  }\n",
       "  tr.iris :first-child {\n",
       "      border-right: 1px solid #9c9c9c !important;\n",
       "  }\n",
       "  td.iris-title {\n",
       "      background: #d5dcdf;\n",
       "      border-top: 1px solid #9c9c9c;\n",
       "      font-weight: bold;\n",
       "  }\n",
       "  .iris-word-cell {\n",
       "      text-align: left !important;\n",
       "      white-space: pre;\n",
       "  }\n",
       "  .iris-subheading-cell {\n",
       "      padding-left: 2em !important;\n",
       "  }\n",
       "  .iris-inclusion-cell {\n",
       "      padding-right: 1em !important;\n",
       "  }\n",
       "  .iris-panel-body {\n",
       "      padding-top: 0px;\n",
       "  }\n",
       "  .iris-panel-title {\n",
       "      padding-left: 3em;\n",
       "  }\n",
       "  .iris-panel-title {\n",
       "      margin-top: 7px;\n",
       "  }\n",
       "</style>\n",
       "<table class=\"iris\" id=\"140397340635024\">\n",
       "    <tr class=\"iris\">\n",
       "<th class=\"iris iris-word-cell\">Lwe Precipitation Rate (mm/day)</th>\n",
       "<th class=\"iris iris-word-cell\">ensemble_member</th>\n",
       "<th class=\"iris iris-word-cell\">time</th>\n",
       "<th class=\"iris iris-word-cell\">projection_y_coordinate</th>\n",
       "<th class=\"iris iris-word-cell\">projection_x_coordinate</th>\n",
       "</tr>\n",
       "    <tr class=\"iris\">\n",
       "<td class=\"iris-word-cell iris-subheading-cell\">Shape</td>\n",
       "<td class=\"iris iris-inclusion-cell\">1</td>\n",
       "<td class=\"iris iris-inclusion-cell\">3600</td>\n",
       "<td class=\"iris iris-inclusion-cell\">112</td>\n",
       "<td class=\"iris iris-inclusion-cell\">82</td>\n",
       "</tr>\n",
       "    <tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Dimension coordinates</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tensemble_member</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\ttime</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tprojection_y_coordinate</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tprojection_x_coordinate</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Auxiliary coordinates</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tensemble_member_id</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tmonth_number</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tyear</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tyyyymmdd</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tgrid_latitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tgrid_longitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Attributes</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tConventions</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">CF-1.5</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcollection</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">land-rcm</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcontact</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">ukcpproject@metoffice.gov.uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcreation_date</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">2019-07-31T00:00</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tdescription</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Precipitation rate</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tdomain</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tfrequency</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">day</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tinstitution</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Met Office Hadley Centre (MOHC), FitzRoy Road, Exeter, Devon, EX1 3PB,...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tinstitution_id</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">MOHC</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tlabel_units</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">mm/day</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tplot_label</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Precipitation rate (mm/day)</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tproject</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\treferences</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">https://ukclimateprojections.metoffice.gov.uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tresolution</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">12km</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tscenario</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">rcp85</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tsource</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18 regional realisation from a set of 12 limited-area Met Office Unified...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\ttitle</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18 land projections - 12km regional climate model, precipitation rate...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tversion</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">v20190731</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Cell methods</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tmean: time</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\"></td>\n",
       "</tr>\n",
       "</table>\n",
       "        "
      ],
      "text/plain": [
       "<iris 'Cube' of lwe_precipitation_rate / (mm/day) (ensemble_member: 1; time: 3600; projection_y_coordinate: 112; projection_x_coordinate: 82)>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cube = iris.load_cube(fname)\n",
    "cube"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "07530a59-3d27-4422-b8b3-a63cc74a85d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "def add_lat_lon(cube, inplace=True, geodetic=None):\n",
    "    if not inplace:\n",
    "        cube = cube.copy()\n",
    "    if geodetic==None:\n",
    "        geodetic = iris.coord_systems.GeogCS(iris.fileformats.pp.EARTH_RADIUS)\n",
    "    \n",
    "    cube_crs = cube.coord_system().as_cartopy_crs()\n",
    "    \n",
    "    x = cube.coord(dim_coords=True, axis='X')\n",
    "    y = cube.coord(dim_coords=True, axis='Y')\n",
    "\n",
    "    mx, my = np.meshgrid(x.points, y.points)\n",
    "\n",
    "    latlons = geodetic.as_cartopy_crs().transform_points(cube_crs, mx, my)\n",
    "\n",
    "    lons = latlons[:,:,0]\n",
    "    lats = latlons[:,:,1]\n",
    "\n",
    "    lat_coord = iris.coords.AuxCoord(lats, \n",
    "                                     standard_name='latitude',\n",
    "                                     long_name='latitude', \n",
    "                                     units='degrees',\n",
    "                                     coord_system=geodetic)\n",
    "    lon_coord = iris.coords.AuxCoord(lons, \n",
    "                                     standard_name='longitude',\n",
    "                                     long_name='longitude', \n",
    "                                     units='degrees',\n",
    "                                     coord_system=geodetic)\n",
    "\n",
    "    cube.add_aux_coord(lat_coord, (y.cube_dims(cube)[0], x.cube_dims(cube)[0]))\n",
    "    cube.add_aux_coord(lon_coord, (y.cube_dims(cube)[0], x.cube_dims(cube)[0]))\n",
    "    \n",
    "    return cube"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e9e285a2-5eae-4bd4-b964-91f7e6b95a95",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/kevin.donkers/opt/miniconda3/envs/data/lib/python3.7/site-packages/iris/coord_systems.py:531: UserWarning: The default value for the *approx* keyword argument to TransverseMercator will change from True to False after 0.18.\n",
      "  globe=globe,\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  a.iris {\n",
       "      text-decoration: none !important;\n",
       "  }\n",
       "  table.iris {\n",
       "      white-space: pre;\n",
       "      border: 1px solid;\n",
       "      border-color: #9c9c9c;\n",
       "      font-family: monaco, monospace;\n",
       "  }\n",
       "  th.iris {\n",
       "      background: #303f3f;\n",
       "      color: #e0e0e0;\n",
       "      border-left: 1px solid;\n",
       "      border-color: #9c9c9c;\n",
       "      font-size: 1.05em;\n",
       "      min-width: 50px;\n",
       "      max-width: 125px;\n",
       "  }\n",
       "  tr.iris :first-child {\n",
       "      border-right: 1px solid #9c9c9c !important;\n",
       "  }\n",
       "  td.iris-title {\n",
       "      background: #d5dcdf;\n",
       "      border-top: 1px solid #9c9c9c;\n",
       "      font-weight: bold;\n",
       "  }\n",
       "  .iris-word-cell {\n",
       "      text-align: left !important;\n",
       "      white-space: pre;\n",
       "  }\n",
       "  .iris-subheading-cell {\n",
       "      padding-left: 2em !important;\n",
       "  }\n",
       "  .iris-inclusion-cell {\n",
       "      padding-right: 1em !important;\n",
       "  }\n",
       "  .iris-panel-body {\n",
       "      padding-top: 0px;\n",
       "  }\n",
       "  .iris-panel-title {\n",
       "      padding-left: 3em;\n",
       "  }\n",
       "  .iris-panel-title {\n",
       "      margin-top: 7px;\n",
       "  }\n",
       "</style>\n",
       "<table class=\"iris\" id=\"140397340635024\">\n",
       "    <tr class=\"iris\">\n",
       "<th class=\"iris iris-word-cell\">Lwe Precipitation Rate (mm/day)</th>\n",
       "<th class=\"iris iris-word-cell\">ensemble_member</th>\n",
       "<th class=\"iris iris-word-cell\">time</th>\n",
       "<th class=\"iris iris-word-cell\">projection_y_coordinate</th>\n",
       "<th class=\"iris iris-word-cell\">projection_x_coordinate</th>\n",
       "</tr>\n",
       "    <tr class=\"iris\">\n",
       "<td class=\"iris-word-cell iris-subheading-cell\">Shape</td>\n",
       "<td class=\"iris iris-inclusion-cell\">1</td>\n",
       "<td class=\"iris iris-inclusion-cell\">3600</td>\n",
       "<td class=\"iris iris-inclusion-cell\">112</td>\n",
       "<td class=\"iris iris-inclusion-cell\">82</td>\n",
       "</tr>\n",
       "    <tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Dimension coordinates</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tensemble_member</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\ttime</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tprojection_y_coordinate</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tprojection_x_coordinate</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Auxiliary coordinates</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tensemble_member_id</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tmonth_number</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tyear</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tyyyymmdd</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tgrid_latitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tgrid_longitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tlatitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tlongitude</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">-</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "    <td class=\"iris-inclusion-cell\">x</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Attributes</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tConventions</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">CF-1.5</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcollection</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">land-rcm</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcontact</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">ukcpproject@metoffice.gov.uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tcreation_date</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">2019-07-31T00:00</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tdescription</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Precipitation rate</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tdomain</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tfrequency</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">day</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tinstitution</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Met Office Hadley Centre (MOHC), FitzRoy Road, Exeter, Devon, EX1 3PB,...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tinstitution_id</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">MOHC</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tlabel_units</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">mm/day</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tplot_label</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">Precipitation rate (mm/day)</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tproject</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\treferences</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">https://ukclimateprojections.metoffice.gov.uk</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tresolution</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">12km</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tscenario</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">rcp85</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tsource</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18 regional realisation from a set of 12 limited-area Met Office Unified...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\ttitle</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">UKCP18 land projections - 12km regional climate model, precipitation rate...</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tversion</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\">v20190731</td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-title iris-word-cell\">Cell methods</td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "    <td class=\"iris-title\"></td>\n",
       "</tr>\n",
       "<tr class=\"iris\">\n",
       "    <td class=\"iris-word-cell iris-subheading-cell\">\tmean: time</td>\n",
       "    <td class=\"iris-word-cell\" colspan=\"4\"></td>\n",
       "</tr>\n",
       "</table>\n",
       "        "
      ],
      "text/plain": [
       "<iris 'Cube' of lwe_precipitation_rate / (mm/day) (ensemble_member: 1; time: 3600; projection_y_coordinate: 112; projection_x_coordinate: 82)>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%time\n",
    "add_lat_lon(cube)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "34028427-b771-4d6d-80b6-e1174b32358b",
   "metadata": {
    "tags": []
   },
   "source": [
    "### Trasfer Cube to DataArray"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "222b9397-1369-4e89-985c-2535013d2589",
   "metadata": {},
   "outputs": [],
   "source": [
    "da = xr.DataArray.from_iris(cube)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "346eed72-a750-40a4-9574-6a0bddb2b607",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\u001b[0;31mSignature:\u001b[0m \u001b[0mcube\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0madd_aux_coord\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoord\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata_dims\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
       "\u001b[0;31mDocstring:\u001b[0m\n",
       "Adds a CF auxiliary coordinate to the cube.\n",
       "\n",
       "Args:\n",
       "\n",
       "* coord\n",
       "    The :class:`iris.coords.DimCoord` or :class:`iris.coords.AuxCoord`\n",
       "    instance to add to the cube.\n",
       "\n",
       "Kwargs:\n",
       "\n",
       "* data_dims\n",
       "    Integer or iterable of integers giving the data dimensions spanned\n",
       "    by the coordinate.\n",
       "\n",
       "Raises a ValueError if a coordinate with identical metadata already\n",
       "exists on the cube.\n",
       "\n",
       "See also :meth:`Cube.remove_coord()<iris.cube.Cube.remove_coord>`.\n",
       "\u001b[0;31mFile:\u001b[0m      ~/opt/miniconda3/envs/data/lib/python3.7/site-packages/iris/cube.py\n",
       "\u001b[0;31mType:\u001b[0m      method\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "cube.add_aux_coord?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5d530854-0f56-48fb-abc2-698b5f3e33ed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 52.9 s, sys: 44.4 s, total: 1min 37s\n",
      "Wall time: 2min 3s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "df = (da.to_dataframe()\n",
    "      .reset_index()\n",
    "      [['yyyymmdd', 'month_number', 'year', 'latitude', 'longitude', 'ensemble_member', 'pr']]\n",
    "      .drop_duplicates(ignore_index=True)\n",
    "     )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "78eb3fbd-7416-46cb-8251-dc520c5756ab",
   "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>yyyymmdd</th>\n",
       "      <th>month_number</th>\n",
       "      <th>year</th>\n",
       "      <th>pr</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>ensemble_member</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20201201</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>0.690706</td>\n",
       "      <td>48.682767</td>\n",
       "      <td>-10.291939</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20201201</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>0.853663</td>\n",
       "      <td>48.694350</td>\n",
       "      <td>-10.130549</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20201201</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.088705</td>\n",
       "      <td>48.705708</td>\n",
       "      <td>-9.969056</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20201201</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.452076</td>\n",
       "      <td>48.716841</td>\n",
       "      <td>-9.807464</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20201201</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "      <td>1.969763</td>\n",
       "      <td>48.727750</td>\n",
       "      <td>-9.645773</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062395</th>\n",
       "      <td>20301130</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.989718</td>\n",
       "      <td>60.828859</td>\n",
       "      <td>3.780264</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062396</th>\n",
       "      <td>20301130</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.240123</td>\n",
       "      <td>60.819205</td>\n",
       "      <td>3.999770</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062397</th>\n",
       "      <td>20301130</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.035135</td>\n",
       "      <td>60.809193</td>\n",
       "      <td>4.219121</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062398</th>\n",
       "      <td>20301130</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.000422</td>\n",
       "      <td>60.798825</td>\n",
       "      <td>4.438310</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33062399</th>\n",
       "      <td>20301130</td>\n",
       "      <td>11</td>\n",
       "      <td>2030</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>60.788100</td>\n",
       "      <td>4.657333</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33062400 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          yyyymmdd  month_number  year        pr   latitude  longitude  \\\n",
       "0         20201201            12  2020  0.690706  48.682767 -10.291939   \n",
       "1         20201201            12  2020  0.853663  48.694350 -10.130549   \n",
       "2         20201201            12  2020  1.088705  48.705708  -9.969056   \n",
       "3         20201201            12  2020  1.452076  48.716841  -9.807464   \n",
       "4         20201201            12  2020  1.969763  48.727750  -9.645773   \n",
       "...            ...           ...   ...       ...        ...        ...   \n",
       "33062395  20301130            11  2030  0.989718  60.828859   3.780264   \n",
       "33062396  20301130            11  2030  0.240123  60.819205   3.999770   \n",
       "33062397  20301130            11  2030  0.035135  60.809193   4.219121   \n",
       "33062398  20301130            11  2030  0.000422  60.798825   4.438310   \n",
       "33062399  20301130            11  2030  0.000002  60.788100   4.657333   \n",
       "\n",
       "          ensemble_member  \n",
       "0                       1  \n",
       "1                       1  \n",
       "2                       1  \n",
       "3                       1  \n",
       "4                       1  \n",
       "...                   ...  \n",
       "33062395                1  \n",
       "33062396                1  \n",
       "33062397                1  \n",
       "33062398                1  \n",
       "33062399                1  \n",
       "\n",
       "[33062400 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ddaac166-fdc4-4e05-bc76-596e654db86e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}