notebooks/get-temperature-data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extraction of temperature data out of the Temperature12K LiPD files\n",
    "\n",
    "This notebook extracts the temperature data of all temperature series in the Temperature12K database and exports them in a tab-separated file. To get the latest version of the data, just click on *Cell* &rarr; *Run all*. When the notebook is finished (i.e. if you see a table [at the bottom](#final)), you can download the temperature data [here](../data/binned-temperature-data.tsv).\n",
    "\n",
    "This notebook downloads the database from http://lipdverse.org/globalHolocene/current_version, based on the version you specify in the `db_version` variable (see below). It has been developed by Philipp Sommer (philipp.sommer@unil.ch), please do not hesitate to get in touch if you run into any problems.\n",
    "\n",
    "**Things you might want to adapt:**\n",
    "\n",
    "- the database version string (`db_version`, see [here](#db_version))\n",
    "- the `binwidth` (by default 100, see [here](#binwidth)). We have to make averages over the time series in order to put everything together\n",
    "- the records you want to download (see [here](#filter))\n",
    "- the meta data for the temperature export (see [here](#meta-cols))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import lipd\n",
    "import numpy as np\n",
    "import contextlib\n",
    "import os\n",
    "import os.path as osp\n",
    "from urllib import request\n",
    "import zipfile"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<a id=binwidth></a>We have to specify the bin widths in years. Each timeseries will be averaged into bins with this length in order to merge them all together."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "binwidth = 100"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<a id=db_version></a>Read in the LipD data from http://lipdverse.org/globalHolocene/current_version\n",
    "\n",
    "You should set the latest version here manually!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "db_version = '0_30_1'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "downloading http://lipdverse.org/globalHolocene/current_version/globalHolocene0_30_1.zip\n",
      "CPU times: user 289 ms, sys: 317 ms, total: 607 ms\n",
      "Wall time: 5.58 s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "if not osp.exists('../data'):\n",
    "    os.makedirs('../data')\n",
    "zipped = f'globalHolocene{db_version}.zip'\n",
    "uri = f'http://lipdverse.org/globalHolocene/current_version/{zipped}'\n",
    "target = osp.join('../data', zipped)\n",
    "print('downloading ' + uri)\n",
    "request.urlretrieve(uri, target)\n",
    "with zipfile.ZipFile(target) as f:\n",
    "    f.extractall('../data')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "@contextlib.contextmanager\n",
    "def remember_cwd():\n",
    "    \"\"\"Context manager to switch back to the current working directory\n",
    "\n",
    "    Usage::\n",
    "\n",
    "        with remember_cwd():\n",
    "            os.chdir('test')\n",
    "            print(os.getcwd())  # test\n",
    "        print(os.getcwd())      # test/..\"\"\"\n",
    "    curdir = os.getcwd()\n",
    "    try:\n",
    "        yield\n",
    "    except:\n",
    "        raise\n",
    "    finally:\n",
    "        os.chdir(curdir)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Disclaimer: LiPD files may be updated and modified to adhere to standards\n",
      "\n",
      "Found: 943 LiPD file(s)\n",
      "reading: Hams.Bennett.1987.lpd\n",
      "reading: MV99-GC31.Barron.2012.lpd\n",
      "reading: EagleTarn.Rees.2010.lpd\n",
      "reading: Sonk11D.Lauterbach.2014.lpd\n",
      "reading: HjortSo.Wagner.2008.lpd\n",
      "reading: Alley.GISP2.2000.lpd\n",
      "reading: Victoria.Berke.2012.lpd\n",
      "reading: GeoB58044.Lamy.2003.lpd\n",
      "reading: Frozen.Rosenberg.2004.lpd\n",
      "reading: GeoB9307_3.lpd\n",
      "reading: Composit_MD012421,KR0206.lpd\n",
      "reading: FloatingIsland.Baker.1976.lpd\n",
      "reading: LakeSix.Liu.1990.lpd\n",
      "reading: ScreamingLynxLake.Clegg.2011.lpd\n",
      "reading: LonarLake.Prasad.2014.lpd\n",
      "reading: Malawi.Johnson.2016.lpd\n",
      "reading: WCA3B_GumboLimboFarTail.Willard.2001.lpd\n",
      "reading: Coghill.King.1986.lpd\n",
      "reading: Rogers.Marsicek.2013.lpd\n",
      "reading: LacduSommet.Hausmann.2011.lpd\n",
      "reading: BanksIsland74MS15.Gajewski.2000.lpd\n",
      "reading: Mohawk_Pond.Marsicek.2013.lpd\n",
      "reading: Sagistalsee.Pollen.Switzerland.lpd\n",
      "reading: MD03_2611.lpd\n",
      "reading: ODP1084B.lpd\n",
      "reading: GiK18515_3.lpd\n",
      "reading: DolgoeOzero.Pollen.Russia.lpd\n",
      "reading: MD06_3075.lpd\n",
      "reading: gunnarsfjorden.Allen.2007.lpd\n",
      "reading: MundayCreek.Peteet.1986.lpd\n",
      "reading: Buckeye.Hardt.2010.lpd\n",
      "reading: Saarikko.Heikkil.2010.lpd\n",
      "reading: sjuuodjijaure.Rosen.2001.lpd\n",
      "reading: Lochnagar.Dalton.2005.lpd\n",
      "reading: lapland.Helama.2010.lpd\n",
      "reading: LakeSixteen.Futyma.1986.lpd\n",
      "reading: Stazersee.Heiri.2015.lpd\n",
      "reading: LakeBolshieToroki.Pollen.Russia.lpd\n",
      "reading: GIK17049_6.lpd\n",
      "reading: Wonderkrater.Scott.2016.lpd\n",
      "reading: NevadoHuascaran.Thompson.1995.lpd\n",
      "reading: HumberPond3.McAndrews.1989.lpd\n",
      "reading: Jansvetnet.Birks.2012.lpd\n",
      "reading: LakePupuke.Pollen.NewZealand.lpd\n",
      "reading: PechoraLake.Andren.2015.lpd\n",
      "reading: Bosten.Chen.2008.lpd\n",
      "reading: TN062-0550.Barron.2018.lpd\n",
      "reading: Varddoaijavri.Luoto.2014.lpd\n",
      "reading: TalkinTarn.Langdon.2004.lpd\n",
      "reading: Nattmalsvatn.Janbu.2011.lpd\n",
      "reading: Issyk.Chen.2008.lpd\n",
      "reading: GeoB4905.Weldeab.2005.lpd\n",
      "reading: BattleGround.Whitlock.1985.lpd\n",
      "reading: JR244_GC528.lpd\n",
      "reading: 117_723A.lpd\n",
      "reading: PortageLake.McAndrews.NA.lpd\n",
      "reading: Lynn.Nichols.1967.lpd\n",
      "reading: dravladalsvatn.Bakke.2005.lpd\n",
      "reading: Burden.Webb.1986.lpd\n",
      "reading: UnitLake.Camill.2012.lpd\n",
      "reading: SP10WINZ.Williams.2010.lpd\n",
      "reading: V1927.lpd\n",
      "reading: PC56_grayscale.Hughen.2000.lpd\n",
      "reading: GrandRapids.Ritchie.1975.lpd\n",
      "reading: Alzasca.Wirth.2013.lpd\n",
      "reading: MD03_2607.lpd\n",
      "reading: Duck.Winkler.1985.lpd\n",
      "reading: Llet-Ti.Pollen.Russia.lpd\n",
      "reading: DonggeCave_b.lpd\n",
      "reading: CaribouHill.Lamb.1985.lpd\n",
      "reading: Takahula.Clegg.2010.lpd\n",
      "reading: PlateauRemote.MosleyThompson.1996.lpd\n",
      "reading: GeoB71392.Kaiser.2008.lpd\n",
      "reading: Ennadai_1972Site.Nichols.1975.lpd\n",
      "reading: Sofular.Fleitmann.2009.lpd\n",
      "reading: JohnKlondike.Matthews.1980.lpd\n",
      "reading: LagoVerdarolo.Samartin.2011.lpd\n",
      "reading: Iglutalik.Davis.NA.lpd\n",
      "reading: KF16.lpd\n",
      "reading: SP02.Adams.2010.lpd\n",
      "reading: MD01-2446.Salguero.2014.lpd\n",
      "reading: ParkPond3.Lynch.1998.lpd\n",
      "reading: Lyadhej-To.Andreev.2005.lpd\n",
      "reading: ARC4.Belt.2010.lpd\n",
      "reading: ODP967D.Emeis.2000.lpd\n",
      "reading: MD01-2412.Harada.2006.lpd\n",
      "reading: Ledro.Wirth.2013.lpd\n",
      "reading: PS2641.Muller.2012.lpd\n",
      "reading: GravelRidge.Lamb.1985.lpd\n",
      "reading: LakeLR1.Gajewski.1993.lpd\n",
      "reading: Hinterburg.Wirth.2013.lpd\n",
      "reading: PointEscuminac.Warner.1991.lpd\n",
      "reading: Hirvijaervi.Luoto.2010.lpd\n",
      "reading: GeoB10043_3.lpd\n",
      "reading: Hovsgol.Chen.2008.lpd\n",
      "reading: ODP967.Larrasoana.2008.lpd\n",
      "reading: Redstone.Brubaker.1985.lpd\n",
      "reading: Kennys.Macpherson.1983.lpd\n",
      "reading: Vostok_Antarctica.lpd\n",
      "reading: BogD.McAndrews.1966.lpd\n",
      "reading: ParkPond2.Lynch.1998.lpd\n",
      "reading: BiglandTarn.Barber.2013.lpd\n",
      "reading: Medicine.Radle.1992.lpd\n",
      "reading: trehorningen.Antonsson.2007.lpd\n",
      "reading: Chatsworth.King.1981.lpd\n",
      "reading: HealLake.Brown.2006.lpd\n",
      "reading: Midden.Cluster9.2019.lpd\n",
      "reading: KNR140_51GGC.lpd\n",
      "reading: Midden.Cluster8.2019.lpd\n",
      "reading: GeoB58044.Lamy.2005.lpd\n",
      "reading: H214.lpd\n",
      "reading: Hamundarstadhahals.Caseldine.2006.lpd\n",
      "reading: ClarksJunction.Pollen.NewZealand.lpd\n",
      "reading: ARC3.Belt.2010.lpd\n",
      "reading: AjaxBog.Pollen.NewZealand.lpd\n",
      "reading: HiddenLake.Potito.2006.lpd\n",
      "reading: DomeC.Stenni.2001.lpd\n",
      "reading: E_Lake.Ritchie.1976.lpd\n",
      "reading: LacFaribault.Larouche.1981.lpd\n",
      "reading: OliverPond_1770.McAndrews.1990.lpd\n",
      "reading: Sud_duLac_duNoyer.Larouche.1977.lpd\n",
      "reading: M25_4_KL11.lpd\n",
      "reading: Deltasoe.Axford.2019.lpd\n",
      "reading: raigastvere.Seppa.2004.lpd\n",
      "reading: Asia-LakeHuguangMaar.lpd\n",
      "reading: BotuveraCave.lpd\n",
      "reading: MeerfelderMaar.Pollen-Germany-MeerfelderMaar.Kuehl.lpd\n",
      "reading: SihailongwanMaarLake.Stebich.2015.lpd\n",
      "reading: Koucha.Pollen.China.lpd\n",
      "reading: Nina.Liu.1990.lpd\n",
      "reading: Marion_BC.Mathewes.1973.lpd\n",
      "reading: KeystoneIronbog.Fall.1985.lpd\n",
      "reading: LacPetel.King.1986.lpd\n",
      "reading: MD06_3067.lpd\n",
      "reading: NevadaPrecip.Hughes.1996.lpd\n",
      "reading: GRIP.Vinther.2006.lpd\n",
      "reading: Jewell.Baker.1986.lpd\n",
      "reading: Garlate.Wirth.2013.lpd\n",
      "reading: njakajaure.Bigler.1998.lpd\n",
      "reading: Pickerel.Shuman.2016.lpd\n",
      "reading: dalene.Eide.2009.lpd\n",
      "reading: ArolikLake.Hu.2003.lpd\n",
      "reading: tornetrask.Grudd.2002.lpd\n",
      "reading: Gerzensee.Cladocera.Switzerland.lpd\n",
      "reading: Ladd.Shane.1993.lpd\n",
      "reading: BI2.Gajewski.1992.lpd\n",
      "reading: Brandreth.Overpeck.1985.lpd\n",
      "reading: HeihaiLake.Chang.2017.lpd\n",
      "reading: Pallcacocha.Moy.2002.lpd\n",
      "reading: SS16.Perren.2012.lpd\n",
      "reading: Marion.Mathewes.1973.lpd\n",
      "reading: O2kLR-Tagusmudpatc.Abrantes.2005.lpd\n",
      "reading: GeoB58044.Lamy.2004.lpd\n",
      "reading: grostjorn.Eide.2009.lpd\n",
      "reading: GeoB5844_2.lpd\n",
      "reading: DHP174.Porter.2019.lpd\n",
      "reading: Qixing.Cai.2001.lpd\n",
      "reading: Hvitarvatn.Larsen.2013.lpd\n",
      "reading: LacGras.King.1986.lpd\n",
      "reading: LakeHintererSchwendisee.Wirth.2013.lpd\n",
      "reading: Minucua.Goman.2018.lpd\n",
      "reading: HawkeHillsKettle.Macpherson.1982.lpd\n",
      "reading: LakeWestOkoboji.Van.1979.lpd\n",
      "reading: GeoB58044.Lamy.2006.lpd\n",
      "reading: Chatsworth.Shuman.2016.lpd\n",
      "reading: Toskaljavri.Seppa.2002.lpd\n",
      "reading: jarburvatnet.Nesje.2001.lpd\n",
      "reading: Harrie.King.1986.lpd\n",
      "reading: SanbaoSB43.Dong.2010.lpd\n",
      "reading: MD032707.Weldeab.2007.lpd\n",
      "reading: agassiz.Vinther.2009.lpd\n",
      "reading: Heihai.Ramisch.2016.lpd\n",
      "reading: BanksIsland74MS11.Gajewski.2000.lpd\n",
      "reading: RedmountainLake.Chase.2008.lpd\n",
      "reading: BearBog.McAndrews.1992.lpd\n",
      "reading: Midden.Cluster3.2019.lpd\n",
      "reading: Midden.Cluster2.2019.lpd\n",
      "reading: M40-4-SL78.Emeis.2003.lpd\n",
      "reading: braya_so.Dandrea.2011.lpd\n",
      "reading: Ammersee.Czymzik.2012.lpd\n",
      "reading: MSM5_512.lpd\n",
      "reading: JamesRossIsland.Mulvaney.2012.lpd\n",
      "reading: LakeNalengcuo.Pollen.China.lpd\n",
      "reading: Big.Cumming.2002.lpd\n",
      "reading: ODP1019.Barron.2003.lpd\n",
      "reading: ColdWater.Denniston.1999.lpd\n",
      "reading: MD952042.Bard.2002.lpd\n",
      "reading: JM98-1.Husum.2004.lpd\n",
      "reading: Hams.Shuman.2016.lpd\n",
      "reading: Logan.Fisher.2008.lpd\n",
      "reading: GeoB9508_5.lpd\n",
      "reading: OwensLake.Benson.2002.lpd\n",
      "reading: Emerald.Shuman.2014.lpd\n",
      "reading: PortageBog.Anderson.1980.lpd\n",
      "reading: vuoskkujavri.Bigler.2002.lpd\n",
      "reading: PorquiPond.McAndrews.NA.lpd\n",
      "reading: dalmutladdo.Bjune.2004.lpd\n",
      "reading: PSh-5157.Risebrobakken.2011.lpd\n",
      "reading: Buckeye.Springer.2008.lpd\n",
      "reading: CC04.lpd\n",
      "reading: KZAI_01.lpd\n",
      "reading: Elfstadalsvatn.Langdon.2008.lpd\n",
      "reading: M_Lake.Ritchie.1977.lpd\n",
      "reading: sfl4-1.Willemse.1999.lpd\n",
      "reading: MD012378.Xu.2008.lpd\n",
      "reading: Seelisberg.Wirth.2013.lpd\n",
      "reading: ThunderLake.Chase.2008.lpd\n",
      "reading: PolevaCave.Constantin.2007.lpd\n",
      "reading: Kenosee.Porter.1992.lpd\n",
      "reading: SSDP102.lpd\n",
      "reading: GRIP_accumulation.Vinther.2006.lpd\n",
      "reading: LakeEC1.Gajewski.1993.lpd\n",
      "reading: PL0739PC.Lea.2003.lpd\n",
      "reading: NBJ2015iso.Wong.2015.lpd\n",
      "reading: PSh-5159N.Risebrobakken.2011.lpd\n",
      "reading: AwengCo.Li.2017.lpd\n",
      "reading: PinkPanther.Asmerom.2007.lpd\n",
      "reading: SU81_18.lpd\n",
      "reading: LakeEC2.Gajewski.1991.lpd\n",
      "reading: DajiuhuPeatland.Huang.2013.lpd\n",
      "reading: MSM055_723-2.Werner.2015.lpd\n",
      "reading: spaime.Hammarlund.2004.lpd\n",
      "reading: PathLake.Neil.2014.lpd\n",
      "reading: Ennadai.Nichols.1967.lpd\n",
      "reading: Corser.Nichols.2014.lpd\n",
      "reading: SS49.Perren.2012.lpd\n",
      "reading: Kyutyunda.Pollen.Russia.lpd\n",
      "reading: SprucePond.Shuman.2016.lpd\n",
      "reading: Minnetonka.Lundeen.2013.lpd\n",
      "reading: 161_976.lpd\n",
      "reading: JiuxianCave.Cai.2010.lpd\n",
      "reading: MSM05_5_723_2.lpd\n",
      "reading: MD01_2378.lpd\n",
      "reading: waskey.Levy.2004.lpd\n",
      "reading: TN062-0550.Addison.2018.lpd\n",
      "reading: LacMartyne.McAndrews.NA.lpd\n",
      "reading: fauske.Linge.2009.lpd\n",
      "reading: KaiteCobreMayor.Martin-Chivelet.2011.lpd\n",
      "reading: Peggy.McAndrews.NA.lpd\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "reading: GeoB6211_2.lpd\n",
      "reading: MooseLake.Clegg.2010.lpd\n",
      "reading: penny.Fisher.1998.lpd\n",
      "reading: DonggeCave.Wang.2005.lpd\n",
      "reading: MD03_2699.lpd\n",
      "reading: YakYakumo.Leipe.2013.lpd\n",
      "reading: LakeLyadhej-To.Andreev.2005.lpd\n",
      "reading: igaliku.Massa.2012.lpd\n",
      "reading: LochantSuidhe.Edwards.2007.lpd\n",
      "reading: Khoe.Leipe.2015.lpd\n",
      "reading: igelsjon..2003.lpd\n",
      "reading: GeoB12605_3.lpd\n",
      "reading: LacColin.Mott.1977.lpd\n",
      "reading: Decoy.Szeicz.1991.lpd\n",
      "reading: PC_01.lpd\n",
      "reading: SouthRhodyBog.Booth.2012.lpd\n",
      "reading: POS362_2_33.lpd\n",
      "reading: Little.Whitlock.1995.lpd\n",
      "reading: Yanahaizi.Chen.2003.lpd\n",
      "reading: Egelsee.Larocque.2010.lpd\n",
      "reading: Baldegg.Wirth.2013.lpd\n",
      "reading: Camp11.Brubaker.1975.lpd\n",
      "reading: MD99-2322.Jennings.2011.lpd\n",
      "reading: Duck_Pond.Marsicek.2013.lpd\n",
      "reading: soylegrotta.Lauritzen.1999.lpd\n",
      "reading: OregonCaves.Ersek.2012.lpd\n",
      "reading: GeoB10235.Kim.2002.lpd\n",
      "reading: PerchLake_Manitoba.Ritchie.NA.lpd\n",
      "reading: LV29_114_3.lpd\n",
      "reading: MD84_527.lpd\n",
      "reading: GeoB9508-5.Collins.2013.lpd\n",
      "reading: MD02_2575.Ziegler.2008.lpd\n",
      "reading: ODP1098B.lpd\n",
      "reading: Moraine.Hansen.1985.lpd\n",
      "reading: MD99-2284.Risebrobakken.2009.lpd\n",
      "reading: Chaohu.Pollen.China.lpd\n",
      "reading: KirmanLake.MacDonald.2016.lpd\n",
      "reading: MoonLake.Shuman.2016.lpd\n",
      "reading: hallet.McKay.2009.lpd\n",
      "reading: LacBrule.Pollen.Canada.lpd\n",
      "reading: LakeStowell.Lemmen&Lacourse.2018.lpd\n",
      "reading: klotjarnen.Seppa.2009.lpd\n",
      "reading: HodellMiragoane1991.lpd\n",
      "reading: BS7938.lpd\n",
      "reading: DSDP480.Barron.2004.lpd\n",
      "reading: JR51-GC35.Bendle.2007.lpd\n",
      "reading: SaintCalixte.Larouche.NA.lpd\n",
      "reading: MD982181.lpd\n",
      "reading: LakeLR3.Gajewski.1992.lpd\n",
      "reading: vikjordvatnet.Balascio.2012.lpd\n",
      "reading: WCA3B_GumboLimboMarsh.Willard.2001.lpd\n",
      "reading: GEOFAR_KF16_MgCa.Repschlager.2016.lpd\n",
      "reading: EagleLake.Lamb.1980.lpd\n",
      "reading: RAPID-12.Thournally.2009.lpd\n",
      "reading: Lake31.Eisner.1995.lpd\n",
      "reading: Midden.Cluster4.2019.lpd\n",
      "reading: BanksIsland74MS12.Gajewski.2000.lpd\n",
      "reading: Midden.Cluster5.2019.lpd\n",
      "reading: MD01_2390.lpd\n",
      "reading: JM96-1207.Solignac.2013.lpd\n",
      "reading: Mohawk.Webb.1986.lpd\n",
      "reading: MD952015.lpd\n",
      "reading: SchwarzseeobSoelden.Ilyashuk.2011.lpd\n",
      "reading: KR02.Pollen.Canada.lpd\n",
      "reading: Holtjaernen.Pollen.Sweden.lpd\n",
      "reading: VestreOEykjamyrtjoern.Pollen.Sweden.lpd\n",
      "reading: myrvatn.Seppa.2009.lpd\n",
      "reading: trettetjorn.Bjune.2005.lpd\n",
      "reading: Reidel.Almquist.1992.lpd\n",
      "reading: ennadai.Bender.1967.lpd\n",
      "reading: LouisePond.Mathewes.1994.lpd\n",
      "reading: GeoB10042_1.lpd\n",
      "reading: SoreqCave.lpd\n",
      "reading: Abalone.Cole.1994.lpd\n",
      "reading: LakeoftheWoods.Palmer.2002.lpd\n",
      "reading: Ramsay.Mott.1978.lpd\n",
      "reading: MeliLake.Anderson.2001.lpd\n",
      "reading: BerryPond.Shuman.2004.lpd\n",
      "reading: svanavatnet.Bjune.2008.lpd\n",
      "reading: MSM055_712-2.Werner.2015.lpd\n",
      "reading: isbenttjonn.Seppa.2009.lpd\n",
      "reading: oykjamyrtjorn.Bjune.2005.lpd\n",
      "reading: TanaLake.lpd\n",
      "reading: VestreOykjamytjorn.Velle.2005.lpd\n",
      "reading: MD032601.Crosta.2007.lpd\n",
      "reading: Wolverine.Mann.2002.lpd\n",
      "reading: Nutt.Shuman.2016.lpd\n",
      "reading: Cadagno.Niemann.2012.lpd\n",
      "reading: DomeF.Kawamura.2007.lpd\n",
      "reading: Holebudalen.Seppa.2009.lpd\n",
      "reading: Hongyuan.Yu.2006.lpd\n",
      "reading: GreatBasin.Salzer.2013.lpd\n",
      "reading: TaquitzMeadow.Pollen.USA.lpd\n",
      "reading: Aus-MorosMurrayCanyon.lpd\n",
      "reading: B997-321.Smith.2005.lpd\n",
      "reading: LakePupuke.VandenBos.2018.lpd\n",
      "reading: ElGygytgynCrater.Schwamborn.2006.lpd\n",
      "reading: Irvin.Cushing.1982.lpd\n",
      "reading: MorrisPond.Morris.2013.lpd\n",
      "reading: High.Fuller.1997.lpd\n",
      "reading: GeoB9526-5.Collins.2013.lpd\n",
      "reading: LakeBN7.Gajewski.1991.lpd\n",
      "reading: PotrokAike.Massaferro.2013.lpd\n",
      "reading: ODP1751078C.lpd\n",
      "reading: Lofty.Lichti.1970.lpd\n",
      "reading: Agassiz.Lecavalier.2017.lpd\n",
      "reading: Gucheng.Pollen.China.lpd\n",
      "reading: Indian.Bjorck.1985.lpd\n",
      "reading: Dune.Finney.2012.lpd\n",
      "reading: CoppermineSaddleback.Nichols.1975.lpd\n",
      "reading: Svartvatnet.Luoto.2018.lpd\n",
      "reading: M75_3_137_3.lpd\n",
      "reading: Lions.Sabatier.2012.lpd\n",
      "reading: Neor.Sharifi.2015.lpd\n",
      "reading: NorthCraterLake.Palmer.2002.lpd\n",
      "reading: kortlanda..2008.lpd\n",
      "reading: BloodPond.Marsicek.2013T.lpd\n",
      "reading: ColdAirCave.lpd\n",
      "reading: s53s52.Tillman.2010.lpd\n",
      "reading: farewell.Hu.1998.lpd\n",
      "reading: nautajarvi.Ojala.2009.lpd\n",
      "reading: MD99-2317.Jennings.2011.lpd\n",
      "reading: SN-6.STiwari.2015.lpd\n",
      "reading: Rystad.Vorren.2012.lpd\n",
      "reading: GeoB100384.Mohtadi.2010.lpd\n",
      "reading: XingyunLake.Wu.2018.lpd\n",
      "reading: JPC76.Friddell.2002.lpd\n",
      "reading: MD022529.Leduc.2007.lpd\n",
      "reading: GYXO.Self.2015.lpd\n",
      "reading: Porphyry.Brown.2002.lpd\n",
      "reading: SanJuanRiverDischarge.Brown.2015.lpd\n",
      "reading: TigrePerdido.vanBreukelen.2008.lpd\n",
      "reading: hudson.Clegg.2011.lpd\n",
      "reading: Mount_Honey.lpd\n",
      "reading: tibetanus.Hammarlund.2002.lpd\n",
      "reading: FinseStasjonsdam.Velle.2005.lpd\n",
      "reading: Devils.Maher.1982.lpd\n",
      "reading: Kharinei.Pollen.Russia.lpd\n",
      "reading: 893A.Kennet.2007.lpd\n",
      "reading: LeadingTickles.Macpherson.1985.lpd\n",
      "reading: SouthernCalifornia.OhlweinWahl.2012.lpd\n",
      "reading: DA05.Lloyd.2007.lpd\n",
      "reading: QunfCave.Fleitmann.2007.lpd\n",
      "reading: starvatn.Andresen.2006.lpd\n",
      "reading: Aus-MarxUpperSnowy.lpd\n",
      "reading: V2130.lpd\n",
      "reading: GeoB10069-3.Gibbons.2014.lpd\n",
      "reading: FoyLake.Stone.2008.lpd\n",
      "reading: Crates.Liu.NA.lpd\n",
      "reading: ParkPond1.Lynch.1998.lpd\n",
      "reading: PeatlandKlukva.Pollen.Russia.lpd\n",
      "reading: Compass.Macpherson.1986.lpd\n",
      "reading: Svartkalstjarn..2010.lpd\n",
      "reading: Mansell.Shuman.2016.lpd\n",
      "reading: AralSea.Chen.2008.lpd\n",
      "reading: GeoB65181.Schefu.2005.lpd\n",
      "reading: MD07-3104.Pollen.Chile.lpd\n",
      "reading: TangledUpLake.Anderson.2001.lpd\n",
      "reading: kjennsvatn.Bakke.2010.lpd\n",
      "reading: D13822.lpd\n",
      "reading: CarletonLake(informalname).Upiter.2014.lpd\n",
      "reading: GrahamLake.Shuman.2016.lpd\n",
      "reading: Tourbiere_deLanoraieJoseph.Comtois.1982.lpd\n",
      "reading: HM03_133_25.lpd\n",
      "reading: ODP-984.Came.2007.lpd\n",
      "reading: BOFS5K.lpd\n",
      "reading: kusawa.Chakraborty.2010.lpd\n",
      "reading: Deep.Marsicek.2013.lpd\n",
      "reading: Vuoksjavratje.Berntsson.2014.lpd\n",
      "reading: ODP1671017E.lpd\n",
      "reading: Atocas.Gauthier.1981.lpd\n",
      "reading: GeoB7702-3.Castaneda.2016.lpd\n",
      "reading: SIPLEMelt.Das.2008.lpd\n",
      "reading: ratasjoen.Velle.2005.lpd\n",
      "reading: ClelandLake.Steinman.2016.lpd\n",
      "reading: Maplehurst.Mott.1978.lpd\n",
      "reading: BisonLake.Anderson.2011.lpd\n",
      "reading: laihalampi.Heikkila.2003.lpd\n",
      "reading: kinnshaugen.Seppa.2009.lpd\n",
      "reading: Davis.Newby.2014.lpd\n",
      "reading: Ferndale.Albert.1981.lpd\n",
      "reading: Tourbiere_deLanorieHenri.Comtois.1982.lpd\n",
      "reading: Windy.Chase.2008.lpd\n",
      "reading: KY07_04_01.Kubota.2010.lpd\n",
      "reading: JR01.Fortin&Gajewski.2017.lpd\n",
      "reading: MSM343300.lpd\n",
      "reading: BighornBasin.Shuman.2012.lpd\n",
      "reading: JinchueanBog.Yu.2013.lpd\n",
      "reading: Longwoods.Pollen.NewZealand.lpd\n",
      "reading: LoonPond.Jacobson.Ja.lpd\n",
      "reading: GeoB7920-2.Collins.2013.lpd\n",
      "reading: Qipisarqo.Wooller.2004.lpd\n",
      "reading: HAP0212.vanderBilt.2016.lpd\n",
      "reading: HU90.deVernal.2013.lpd\n",
      "reading: BoothIrwinSmith2012.lpd\n",
      "reading: ODP658C.deMenocal.1997.lpd\n",
      "reading: MD012390.Steinke.2008.lpd\n",
      "reading: TaulMuced.Diaconu.2017.lpd\n",
      "reading: M77_2_059_1.lpd\n",
      "reading: jake.Kerwin.2005.lpd\n",
      "reading: Crowsnest.Anderson.NA.lpd\n",
      "reading: GIK18287_3.lpd\n",
      "reading: M39008.Cacho.2001.lpd\n",
      "reading: Sigrid.Nazarova.2017.lpd\n",
      "reading: N14..2004.lpd\n",
      "reading: Hershop.Larson.1972.lpd\n",
      "reading: LakeNikolay.Pollen.Russia.lpd\n",
      "reading: Spannagel.Fohlmeister.2012.lpd\n",
      "reading: devon.Fisher.1983.lpd\n",
      "reading: Gould.Jacobson.1992.lpd\n",
      "reading: M35003_4.lpd\n",
      "reading: TTR-12_293G.Rodrigo-Gamiz.2014.lpd\n",
      "reading: HumberPond5.McAndrews.1989.lpd\n",
      "reading: Fiskebolvatnet.Balascio.2012.lpd\n",
      "reading: MD02_2529.lpd\n",
      "reading: ODP658C_UK37.Zhao.1995.lpd\n",
      "reading: NorthPond.Whitehead.1978.lpd\n",
      "reading: Kotokel.Tarasov.2009.lpd\n",
      "reading: GIK23258.Sarnthein.2003.lpd\n",
      "reading: Clearwater.Mott.1973.lpd\n",
      "reading: LacLeonard.Labelle.1984.lpd\n",
      "reading: Beaverhouse.Ritchie.1976.lpd\n",
      "reading: LO09.Berner.2008.lpd\n",
      "reading: StewartsDark.Peters.1984.lpd\n",
      "reading: Hanging.Cwynar.1982.lpd\n",
      "reading: AlanenLaanijarvi.Heinrichs.2005.lpd\n",
      "reading: P178-15P.Tierney.2015.lpd\n",
      "reading: LacMeleze.MacDonald.1987.lpd\n",
      "reading: Zabieninec.Plociennik.2011.lpd\n",
      "reading: BloodPond.Marsicek.2013.lpd\n",
      "reading: Elsinore.Kirby.2010.lpd\n",
      "reading: big_round.Thomas.2010.lpd\n",
      "reading: Hidden.Shuman.2009.lpd\n",
      "reading: PassLake.McAndrews.1986.lpd\n",
      "reading: KR02.Peros.2008.lpd\n",
      "reading: WA01.Rainville.2013.lpd\n",
      "reading: Olive-backedLake.Self.2015.lpd\n",
      "reading: MD99-2264.Olafsdottir.2010.lpd\n",
      "reading: RiviereFeuilles1.Larouche.1981.lpd\n",
      "reading: MSM05-712.Muller.2013.lpd\n",
      "reading: BoomerangLake.Brown.2006.lpd\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "reading: tsuolbmajavri.Korhola.2009.lpd\n",
      "reading: Hinterburgsee.Heiri.2003.lpd\n",
      "reading: Bjornfjell.Brooks.2006.lpd\n",
      "reading: renland.Vinther.2009.lpd\n",
      "reading: BerryPondWest1979.lpd\n",
      "reading: Asia-LianhuaCave.lpd\n",
      "reading: BegbieLake.Brown.2019.lpd\n",
      "reading: WCA3B_GumboLimboWetHead.Willard.2001.lpd\n",
      "reading: Hani.Zheng.2017.lpd\n",
      "reading: MD97_2151.lpd\n",
      "reading: Gass.Webb.1983.lpd\n",
      "reading: DavisLake.Whitlock.1981.lpd\n",
      "reading: ME005A43JC.lpd\n",
      "reading: CuevadeAsiul.Smith.2016.lpd\n",
      "reading: rainbow.Clegg.2011.lpd\n",
      "reading: V12-107.Schmidt.2016.lpd\n",
      "reading: k2.Fallu.2005.lpd\n",
      "reading: Gammelheimvatnet.Seppa.2009.lpd\n",
      "reading: PlatypusTarn.Rees.2010.lpd\n",
      "reading: Castor.Nelson.2011.lpd\n",
      "reading: LakeLB1.Gajewski.1993.lpd\n",
      "reading: CottonwoodLake.Grimm.1987.lpd\n",
      "reading: DANA12_11_2_GC01.lpd\n",
      "reading: Midden.Cluster1.2019.lpd\n",
      "reading: LacAurelie.Bajolle.2018.lpd\n",
      "reading: EDML.Stenni.2009.lpd\n",
      "reading: CottonwoodPassPond.Fall.1997.lpd\n",
      "reading: PP10-07.Mary.2016.lpd\n",
      "reading: SouthAfricanSummerRainfallZone.Climate-12k-Site-Data-Entry-Form-v3.SASRZ.lpd\n",
      "reading: ranger.Brubaker.1983.lpd\n",
      "reading: Deep.Shuman.2016.lpd\n",
      "reading: PixieLake.Brown.2006.lpd\n",
      "reading: MD95-2040.Salguero.2014.lpd\n",
      "reading: Jack.Liu.1985.lpd\n",
      "reading: Gilltjarnen.Antonsson.2006.lpd\n",
      "reading: LittleWindy.Minckley.2012.lpd\n",
      "reading: Balikun.Chen.2008.lpd\n",
      "reading: HU91.Levac.2013.lpd\n",
      "reading: OCE326GGC26.lpd\n",
      "reading: Nerfloen.Vasskog.2012.lpd\n",
      "reading: StaroselskyMoch.Pollen.Russia.lpd\n",
      "reading: BS7933.lpd\n",
      "reading: McMaster.Moser.1990.lpd\n",
      "reading: Tumbulovaty.Kultti.2004.lpd\n",
      "reading: Berry.Whitehead.1979.lpd\n",
      "reading: Gushantun.Zheng.2018.lpd\n",
      "reading: TaylorDome_dD.lpd\n",
      "reading: Bastien.Bennett.1987.lpd\n",
      "reading: MD99-2256.Olafsdottir.2010.lpd\n",
      "reading: OCE326GGC30.lpd\n",
      "reading: Flarken.Seppa.2005.lpd\n",
      "reading: South_Island.lpd\n",
      "reading: Cummins.McAndrews.1984.lpd\n",
      "reading: LakeXimencuo.Pollen.China.lpd\n",
      "reading: lake850.Shemesh.2001.lpd\n",
      "reading: Kharinei.Jones.2011.lpd\n",
      "reading: LakeCF8.Axford.2011.lpd\n",
      "reading: Kurupa.Boldt.2015.lpd\n",
      "reading: LawDome.Dahl-Jensen.1999.lpd\n",
      "reading: HulunLake.Wen.2009.lpd\n",
      "reading: HomesteadScarp.McGlone.2010.lpd\n",
      "reading: CangoCave.Climate-12k-Site-Data-Entry-Form-v3.Cango.lpd\n",
      "reading: DevonIslandGlacier.McAndrews.1984.lpd\n",
      "reading: SaintGabriel.Larouche.1977.lpd\n",
      "reading: Edward.Russell.2003.lpd\n",
      "reading: Cadagno.Wirth.2013.lpd\n",
      "reading: NP04KH3KH4.Tierney.2008.lpd\n",
      "reading: Hudson.Bailey.1972.lpd\n",
      "reading: LagoMoreno.Pollen.Argentina.lpd\n",
      "reading: LostLake_MT.Whitlock.1989.lpd\n",
      "reading: ODP1019D.lpd\n",
      "reading: LittleBass.Swain.NA.lpd\n",
      "reading: arapisto.Sarmaja-Korjonen.2007.lpd\n",
      "reading: DonggeCave.Dyoski.2005.lpd\n",
      "reading: Hypkana.Hajkova.2016.lpd\n",
      "reading: LakeKupal'noe.Ilyashuk.2013.lpd\n",
      "reading: MSM05-723..2012.lpd\n",
      "reading: Pingwang.Pollen.China.lpd\n",
      "reading: SO139-74KL.Luckge.2008.lpd\n",
      "reading: LakeVan.Chen.2008.lpd\n",
      "reading: 165_1002C.lpd\n",
      "reading: CH0798GGC19.lpd\n",
      "reading: MD02-2515.Bhattacharya.2018.lpd\n",
      "reading: LowerBearLake.Kirby.2012.lpd\n",
      "reading: BeaverLake.Schmieder.2011.lpd\n",
      "reading: EnosLake.Brown.2006.lpd\n",
      "reading: Hinterburgsee.Heiri.2015.lpd\n",
      "reading: Mendota.Winkler.1986.lpd\n",
      "reading: Moon.Grimm.1996.lpd\n",
      "reading: Tigalmamine.Climate-12k-Site-Data-Entry-Form-v3.Tigalmamine.lpd\n",
      "reading: gloppsjon.Seppa.2009.lpd\n",
      "reading: GeoB7622-2.Lamy.2006.lpd\n",
      "reading: MD982176.lpd\n",
      "reading: Ghirla.Wirth.2016.lpd\n",
      "reading: LacLouis.Vincent.1973.lpd\n",
      "reading: Grenadier.McAndrews.1988.lpd\n",
      "reading: NewLong.Newby.2014.lpd\n",
      "reading: LimeLake.Steinman.2016.lpd\n",
      "reading: HomesteadScarp,CampbellIsland.Pollen.NewZealand.lpd\n",
      "reading: Malawi.Powers.2005.lpd\n",
      "reading: LongLake.Kay.1979.lpd\n",
      "reading: StellaLake.Reinemann.2009.lpd\n",
      "reading: SanLuisLake.Yuan.2013.lpd\n",
      "reading: JM01-1199.Hald.2007.lpd\n",
      "reading: LakeGB2.Gajewski.1993.lpd\n",
      "reading: Pickerel_SD.Watts.1968.lpd\n",
      "reading: tiavatnet.Seppa.2009.lpd\n",
      "reading: 18287-3.Kienast.2001.lpd\n",
      "reading: Kirchner.Wright.1963.lpd\n",
      "reading: nikolay.Andreev.2004.lpd\n",
      "reading: Troll28-03.Klitgard-Kristensen.2001.lpd\n",
      "reading: lonespruce.Kaufman.2012.lpd\n",
      "reading: 74KL_UK37.Huguet.2006.lpd\n",
      "reading: Qipisarqo.Frechette.2009.lpd\n",
      "reading: AlfonsoBasin.StainesUrias.2015.lpd\n",
      "reading: 2005-804.Ledu.2013.lpd\n",
      "reading: GeoB7625-2.Lamy.2006.lpd\n",
      "reading: YellowLake.Anderson.2012.lpd\n",
      "reading: Graham.Fuller.1997.lpd\n",
      "reading: MilandreCav.Affolter.2019.lpd\n",
      "reading: iglutalik.Davis.1980.lpd\n",
      "reading: P1003.Sejrup.2011.lpd\n",
      "reading: 2004_804_009_PC.lpd\n",
      "reading: Aus-WilkinsKeilambeteGnotuk.lpd\n",
      "reading: candelabra.Cwynar.1995.lpd\n",
      "reading: upper_fly.Bunbury.2009.lpd\n",
      "reading: MD972120.lpd\n",
      "reading: CariacoBasin.Haug.2001.lpd\n",
      "reading: trout.Irvine.2012.lpd\n",
      "reading: EaglenestLake.Vance.1986.lpd\n",
      "reading: MD95-2011.Berner.2010.lpd\n",
      "reading: CaribouLake.Rolland.2008.lpd\n",
      "reading: Laihalampi.Pollen.Sweden.lpd\n",
      "reading: austerkjosen.Seppa.2009.lpd\n",
      "reading: RhamnusLake.Brown.2006.lpd\n",
      "reading: Jeita.Cheng.2015.lpd\n",
      "reading: NoBottom.Dunwiddie.1990.lpd\n",
      "reading: M39_008.lpd\n",
      "reading: SO90_56KA.lpd\n",
      "reading: MD99-2227.deVernal.2013.lpd\n",
      "reading: BJ8_70GGC.lpd\n",
      "reading: Khatanga-12Lake.Syrykh.2017.lpd\n",
      "reading: TorontoLake.Wolfe.1996.lpd\n",
      "reading: RC12-10.Poore.2003.lpd\n",
      "reading: MV99-GC41.Marchitto. 2010.lpd\n",
      "reading: MD79257.lpd\n",
      "reading: Tanganyika.Tierney.2008.lpd\n",
      "reading: MD972121.lpd\n",
      "reading: CuevaDiablo.Bernal.2011.lpd\n",
      "reading: Delorme1.Bouchard.1982.lpd\n",
      "reading: BJ8_13GGC.lpd\n",
      "reading: SpringValleyCave.Denniston.1999.lpd\n",
      "reading: M25and4KL11.Emeis.2003.lpd\n",
      "reading: Hinterburgsee.Heiri.2004.lpd\n",
      "reading: njulla.Bigler.2003.lpd\n",
      "reading: Ghirla.Wirth.2013.lpd\n",
      "reading: MD98_2188.lpd\n",
      "reading: UpperBigCreek.Shuman.2015.lpd\n",
      "reading: No_Bottom_Pond.Marsicek.2013.lpd\n",
      "reading: HU84.deVernal.2013.lpd\n",
      "reading: Ammersee.vonGrafenstein.1996.lpd\n",
      "reading: PM9462_4.lpd\n",
      "reading: LakeBerkut.Ilyashuk.2005.lpd\n",
      "reading: PC2.Seki.2004.lpd\n",
      "reading: NIOP905_TEX86.lpd\n",
      "reading: Sokli.Shala.2017.lpd\n",
      "reading: ClearLake_Iowa.Baker.1992.lpd\n",
      "reading: MD07-3088.Pollen.Chile.lpd\n",
      "reading: Njulla.Larocque&Hall.2004.lpd\n",
      "reading: Posy.Shafer.1989.lpd\n",
      "reading: MysteryCave..2004.lpd\n",
      "reading: EDC.Jouzel.2007.lpd\n",
      "reading: SO189-39KL.Mohtadi.2014.lpd\n",
      "reading: Nutt.Bennett.1987.lpd\n",
      "reading: Chichancanab.Hodell.1995.lpd\n",
      "reading: chuna.Jones.2005.lpd\n",
      "reading: UpperPintoFen.Yu.2003.lpd\n",
      "reading: BorderBeacon.Lamb.1985.lpd\n",
      "reading: Pella.Climate-12k-Site-Data-Entry-Form-v3.Pella.lpd\n",
      "reading: MD99-2269.Justwan.2008.lpd\n",
      "reading: PerchLake_ON.Terasmae.1975.lpd\n",
      "reading: MD01-2416.Sarnthien.2004.lpd\n",
      "reading: ruila.Seppa.2004.lpd\n",
      "reading: Haukdalsvatn.Larsen.2013.lpd\n",
      "reading: LehmanCaves.Steponaitis.2015.lpd\n",
      "reading: GeoB12610_2.lpd\n",
      "reading: MD982165.lpd\n",
      "reading: KT05_7_PC_02.lpd\n",
      "reading: LakeAspvatnet_ELA.Bakke.2005.lpd\n",
      "reading: O2kLR-CapeGhirNWAf.Kim.2006.lpd\n",
      "reading: MD02-2517.Bhattacharya.2018.lpd\n",
      "reading: M350034.Rhlemann.lpd\n",
      "reading: Klotjaernen.Pollen.Sweden.lpd\n",
      "reading: Sysy-Kyuele.Biskaborn.2012.lpd\n",
      "reading: GeoB65181_MBT.Weijers.2007.lpd\n",
      "reading: Heshang.Wang.2018.lpd\n",
      "reading: CascadeFen.Maher.1963.lpd\n",
      "reading: GIK17940_2.lpd\n",
      "reading: Billys.Jacobson.1975.lpd\n",
      "reading: LagoGeminiInferiore.Samartin.2011.lpd\n",
      "reading: TauldintreBrazi.Toth.2015.lpd\n",
      "reading: LaPAS_KF02.lpd\n",
      "reading: Carp.Whitlock.1985.lpd\n",
      "reading: IOW225514.Elmis.2003.lpd\n",
      "reading: LakeCH2.Garralla.1992.lpd\n",
      "reading: TourbiereDeLanoraieSTJEAN.Comtois.1982.lpd\n",
      "reading: LakeChalla.Climate-12k-Site-Data-Entry-Form-v3.Challa.lpd\n",
      "reading: PTHE.Self.2015.lpd\n",
      "reading: DomeC.Jouzel.2007.lpd\n",
      "reading: KR02.Fortin&Gajewski.2010.lpd\n",
      "reading: flower_valley..2013.lpd\n",
      "reading: Chron.Iceland.2013.lpd\n",
      "reading: LakeAspvatnet_precip.Bakke.2005.lpd\n",
      "reading: BCTempComp.Gavin.2013.lpd\n",
      "reading: BasadelaMoraLake.Tarrats.2018.lpd\n",
      "reading: MD94-103.Sicre.2005.lpd\n",
      "reading: ThreePinesBog.McAndrews.1990.lpd\n",
      "reading: AMP112.vanderBilt.2016.lpd\n",
      "reading: flotatjonn.Seppa.2009.lpd\n",
      "reading: Holzmaar.Luke..lpd\n",
      "reading: MD02-2553.Poore.2009.lpd\n",
      "reading: SumxiCo.Leipe.2014.lpd\n",
      "reading: Nichols.Corser.2014.lpd\n",
      "reading: BC01.Peros.2010.lpd\n",
      "reading: SilverLake.Kirby.2015.lpd\n",
      "reading: HLY0501.deVernal.2013.lpd\n",
      "reading: Core_63KA.lpd\n",
      "reading: MD982170.lpd\n",
      "reading: GGC19.Farmer.2011.lpd\n",
      "reading: SV_04.lpd\n",
      "reading: MonheganIslandMeadow.Bostwick.1978.lpd\n",
      "reading: GISP2.Alley.2000.lpd\n",
      "reading: MicaLake.Schiff.2009.lpd\n",
      "reading: BrayaSo.vonGunten.2012.lpd\n",
      "reading: LostLake_MI.Brubaker.1975.lpd\n",
      "reading: Jones.Shapley.2009.lpd\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "reading: Steel.Shuman.2016.lpd\n",
      "reading: GeoB59012.Kim.2004.lpd\n",
      "reading: ForestPond1.Lynch.1998.lpd\n",
      "reading: MD97-2151.Yamamoto.2013.lpd\n",
      "reading: Whatever.Wolfe.1996.lpd\n",
      "reading: Topptjonna.Paus.2011.lpd\n",
      "reading: TR163_22.lpd\n",
      "reading: MB01.Pollen.Canada.lpd\n",
      "reading: Mo05LakeMondsee.Swierczynski.2013.lpd\n",
      "reading: Hulun.Chen.2008.lpd\n",
      "reading: GeoB3129.Weldeab.2006.lpd\n",
      "reading: P1B3.deVernal.2005.lpd\n",
      "reading: ClearLake_Indiana.Bailey.1972.lpd\n",
      "reading: Jenny.Larson.2016.lpd\n",
      "reading: century.Vinther.2009.lpd\n",
      "reading: LacNoir.Pollen.Canada.lpd\n",
      "reading: Kollioksak.Anderson.NA.lpd\n",
      "reading: yarnyshnoe.Seppa.2008.lpd\n",
      "reading: Glattalp.Wirth.2013.lpd\n",
      "reading: Telmen.Chen.2008.lpd\n",
      "reading: LoughMeenachrinna,CountyDonegal.Taylor.2018.lpd\n",
      "reading: quartz.Wooller.2012.lpd\n",
      "reading: Gerzensee.Pollen.Switzerland.lpd\n",
      "reading: SK168_GC_1.lpd\n",
      "reading: KinderlinskayaCave.Baker.2017.lpd\n",
      "reading: Colo.Baker.1990.lpd\n",
      "reading: LacMarcotte.Labelle.1981.lpd\n",
      "reading: SS8.Anderson.2012.lpd\n",
      "reading: Furnival.McAndrews.NA.lpd\n",
      "reading: NIOP905_UK37.lpd\n",
      "reading: SecretLake.Lasher.2017.lpd\n",
      "reading: Minakokosa.Anderson.NA.lpd\n",
      "reading: Mawmluh.Berkelhammer.2012.lpd\n",
      "reading: BeefPasture.Petersen.1985.lpd\n",
      "reading: brurskardstjorni.Velle.2005.lpd\n",
      "reading: haugtjern.Eide.2009.lpd\n",
      "reading: PolandSpring.Jacobson.Ja.lpd\n",
      "reading: KP2.Seppa.2009.lpd\n",
      "reading: Myrtle.Janssen.1968.lpd\n",
      "reading: Jellybean.Anderson.2005.lpd\n",
      "reading: meleze.MacDonald.1983.lpd\n",
      "reading: WAISBubble.Fegyveresi.2016.lpd\n",
      "reading: SL06.Pollen.Canada.lpd\n",
      "reading: SK237-GC04.Saraswat.2013.lpd\n",
      "reading: AD9117.Guinta.2001.lpd\n",
      "reading: Little_Pond_Royalston.Marsicek.2013.lpd\n",
      "reading: Delorme2.Bouchard.1982.lpd\n",
      "reading: LagunaDeJuanacatlan.Jones.2015.lpd\n",
      "reading: SacredLake.lpd\n",
      "reading: Caribou.Labelle.1992.lpd\n",
      "reading: Kilimanjaro.Thompson.2002.lpd\n",
      "reading: Medvedevskoe.Nazarova.2018.lpd\n",
      "reading: Core17940.lpd\n",
      "reading: Mjauvotn.Olsen.2010.lpd\n",
      "reading: MD99_2304.lpd\n",
      "reading: lily.Cwynar.1990.lpd\n",
      "reading: NH-8P.Bhattacharya.2018.lpd\n",
      "reading: Sharkey.Shuman.2016.lpd\n",
      "reading: MD95_2002.lpd\n",
      "reading: Iffig.Wirth.2013.lpd\n",
      "reading: TaylorDome_d18O.lpd\n",
      "reading: Saint-JeanIle_dOrleans.Larouche.1971.lpd\n",
      "reading: SO136GC11.Barrows.2007.lpd\n",
      "reading: Ew0408-85JC.Praetorius.2015.lpd\n",
      "reading: PL-96.Voronina.2013.lpd\n",
      "reading: MD05_2904.lpd\n",
      "reading: LakeHopeSimpson.Hansen.1985.lpd\n",
      "reading: WhitePond.Krause.2019.lpd\n",
      "reading: LS009.Ledu.2010.lpd\n",
      "reading: MD99-2266.Moossen.2015.lpd\n",
      "reading: Mackenzie.Woltering.2014.lpd\n",
      "reading: Reiarsdalvatnet.Seppa.2009.lpd\n",
      "reading: ESM-1.Mackay.2012.lpd\n",
      "reading: andy.Szeicz.1995.lpd\n",
      "reading: MD95-2011.Calvo.2002.lpd\n",
      "reading: Tourbiere_deLanorie_CoteauJaune.Comtois.1982.lpd\n",
      "reading: NorthGRIP.Gkinis.2014.lpd\n",
      "reading: hjort.Schmidt.2011.lpd\n",
      "reading: MD952043.lpd\n",
      "reading: Eldora.Maher.1969.lpd\n",
      "reading: Buckbean.Baker.1976.lpd\n",
      "reading: Turkana.Berke.2012.lpd\n",
      "reading: Sellevollmyra.Vorren.2007.lpd\n",
      "reading: SchellingsBog.Barron.2004.lpd\n",
      "reading: MD99-2256.Jennings.2015.lpd\n",
      "reading: Pixie.Brown.2002.lpd\n",
      "reading: Leviathan.Lachniet.2014.lpd\n",
      "reading: FiddlersPond.White.1982.lpd\n",
      "reading: GISP2.Kobashi.2012.lpd\n",
      "reading: Boone.White.1986.lpd\n",
      "reading: LoneFoxLake.MacDonald.1985.lpd\n",
      "reading: Minnie.McAndrews.1992.lpd\n",
      "reading: OroLake.Michels.2007.lpd\n",
      "reading: A7.Sun.2005.lpd\n",
      "reading: 74KL_TEX86.Huguet.2006.lpd\n",
      "reading: Cub.Rasmussen.1982.lpd\n",
      "reading: bjornfjelltjorn.Brooks.2006.lpd\n",
      "reading: TTR17_434G.Rodrigo-Gamiz.2014.lpd\n",
      "reading: Stomyren..2008.lpd\n",
      "reading: Korallgrottan.Sundqvist.2010.lpd\n",
      "reading: BlueMoundsCreek.Davis.1977.lpd\n",
      "reading: Lyadhej-To.Pollen.Russia.lpd\n",
      "reading: GeoB3910.Jaeschke.2007.lpd\n",
      "reading: svartvatnet.Seppa.2009.lpd\n",
      "reading: SO42_74KL.lpd\n",
      "reading: Crowfoot.Reasoner.1996.lpd\n",
      "reading: LakeGB1.Gajewski.1991.lpd\n",
      "reading: Cranberry.McAndrews.NA.lpd\n",
      "reading: MD99-2256..2010.lpd\n",
      "reading: VuolepNjakajaure.Heinrichs.2006.lpd\n",
      "reading: LittlePond.Marsicek.2013.lpd\n",
      "reading: GeoB12610-2.Rippert.2015.lpd\n",
      "reading: Aus-KempWimmeraLakes.lpd\n",
      "reading: MD01-2444.Martrat.2007.lpd\n",
      "reading: akvaqiak.Frechette.2009.lpd\n",
      "reading: GreyIslands.Cullen.2002.lpd\n",
      "reading: Vouskku.Larocque.2004.lpd\n",
      "reading: ClearPond_SCarolina.Hussey.1993.lpd\n",
      "reading: Station803.Bringue.2012.lpd\n",
      "reading: RiviereFeuilles2.Larouche.1981.lpd\n",
      "reading: HeshangCave.Hu.2007.lpd\n",
      "reading: Castor.Larouche.NA.lpd\n",
      "reading: ElJunco.Conroy.2008.lpd\n",
      "reading: Two-YourtsLake.Nazarova.2013.lpd\n",
      "reading: Holzmaar.Pollen-Germany-Holzmaar.Kuehl.lpd\n",
      "reading: Midden.Cluster7.2019.lpd\n",
      "reading: Midden.Cluster6.2019.lpd\n",
      "reading: RR1313_23PC.lpd\n",
      "reading: honeymoon.Cwynar.1991.lpd\n",
      "reading: MD97_2120.lpd\n",
      "reading: JR01.Zabenskie.2007.lpd\n",
      "reading: Sutherland.Shuman.2016.lpd\n",
      "reading: Faelen.Wirth.2013.lpd\n",
      "reading: Temje.Nazarova.2013.lpd\n",
      "reading: Aden.Tierney.2013.lpd\n",
      "reading: Queens.MacDonald.1990.lpd\n",
      "reading: GISP2.Kobashi.2017.lpd\n",
      "reading: hail.Cwynar.1995.lpd\n",
      "reading: GunNuur.Chen.2008.lpd\n",
      "reading: Crooked.Engels.2012.lpd\n",
      "reading: LakeMina.Pollen.USA.lpd\n",
      "reading: Eleanor.Gavin.2011.lpd\n",
      "reading: NA87_22.lpd\n",
      "reading: D13902.lpd\n",
      "reading: MD95-2015.Giraudeau.2002.lpd\n",
      "reading: IndianPrairieFen.Whitlock.1995.lpd\n",
      "reading: Juyanze.Chen.2008.lpd\n",
      "reading: Gemini.Samartin.2017.lpd\n",
      "reading: NGRIP..2004.lpd\n",
      "reading: LakeOfTheWoods.Pribyl.2014.lpd\n",
      "reading: Marcella.Anderson.2007.lpd\n",
      "reading: GeoB77023.Castaeda.2010.lpd\n",
      "reading: NikolayLake.Andreev.2004.lpd\n",
      "reading: GeoB7926_2.lpd\n",
      "reading: Demont.Kapp.NA.lpd\n",
      "reading: ODP1017E.Kennett.2000.lpd\n",
      "reading: BoundaryLake.Stravers.1981.lpd\n",
      "reading: Copley.Fall.1997.lpd\n",
      "reading: HangingLake.Kurek.2009.lpd\n",
      "reading: greyling.Mckay.2009.lpd\n",
      "reading: Okoboji.Shuman.2016.lpd\n",
      "reading: LagunaDeAljojuca.Bhattacharya.2015.lpd\n",
      "reading: Vatnamyri.Caseldine.2006.lpd\n",
      "reading: Dye3.Vinther.2006.lpd\n",
      "reading: MR003-K03-PC01.Harada.2004.lpd\n",
      "reading: TY93-905.Kim.2004.lpd\n",
      "reading: Seukokjaure.Rosen.2003.lpd\n",
      "reading: Wulun.Chen.2008.lpd\n",
      "reading: TsoMoriri.Leipe.2013.lpd\n",
      "reading: SS1381.Anderson.2012.lpd\n",
      "reading: 3MPond.Pellatt.2000.lpd\n",
      "reading: Keele.Szeicz.1995.lpd\n",
      "reading: Chippewa.Bailey.1981.lpd\n",
      "reading: Redondo.Brubaker.1983.lpd\n",
      "reading: Bosumtwi.Shanahan.2015.lpd\n",
      "reading: LiangLuarCave.Griggiths.2009.lpd\n",
      "reading: ForestPond2.Lynch.1998.lpd\n",
      "reading: MaraisdeKeswick.Larouche.1986.lpd\n",
      "reading: GeoB10069_3.lpd\n",
      "reading: Qinghai.Leipe.2013.lpd\n",
      "reading: HighLake.Shuman.2016.lpd\n",
      "reading: Grimsel.Wirth.2013.lpd\n",
      "reading: LakeQinghai.Hou.2016.lpd\n",
      "reading: Nedlouc.Larouche.1981.lpd\n",
      "reading: liltlvatn.Seppa.2009.lpd\n",
      "reading: Radtke.Webb.1983.lpd\n",
      "reading: ARC5.Belt.2010.lpd\n",
      "reading: TiancaiLake.Zhang.2017.lpd\n",
      "reading: ODP_1240.lpd\n",
      "reading: ParadiseLake.Steinman.2016.lpd\n",
      "reading: TALDICE.Mezgec.2017.lpd\n",
      "reading: EastBalticBog.Anderson.1980.lpd\n",
      "reading: LagoDellAccesa.Finsinger.2010.lpd\n",
      "reading: V1928.lpd\n",
      "reading: BayanNuur.Chen.2008.lpd\n",
      "reading: SO189-119KL.Mohtadi.2014.lpd\n",
      "reading: LR01.Gajewski.1993.lpd\n",
      "reading: Komosomolskaia.Ciais.1992.lpd\n",
      "reading: Malangen.Husum.2004.lpd\n",
      "reading: M44-KL71.Sperling.2003.lpd\n",
      "reading: LacPatricia.McAndrews.1983.lpd\n",
      "reading: Redrock.Maher.1972.lpd\n",
      "reading: GeoB33131.Lamy.2002.lpd\n",
      "reading: IOW225517.Elmis.2003.lpd\n",
      "reading: PyramidLake.Benson.2001.lpd\n",
      "reading: naujg1.Willemse.1999.lpd\n",
      "reading: MD972141.lpd\n",
      "reading: WAISDivide.Cuffey.2016.lpd\n",
      "reading: north.Axford.2013.lpd\n",
      "reading: LacHamard.Stravers.1981.lpd\n",
      "reading: Axe.McAndrews.No.lpd\n",
      "reading: EagleLake.Rosenberg.2004.lpd\n",
      "reading: BoundaryPond.Mott.1977.lpd\n",
      "reading: GeoB1711_4.lpd\n",
      "reading: LifebuoyLake.Solivieva.2015.lpd\n",
      "reading: Rapid.Fall.1994.lpd\n",
      "reading: PogoniaBog.Cushing.1979.lpd\n",
      "reading: MV0811-14JC.Du.2018.lpd\n",
      "reading: MD02_2594.lpd\n",
      "reading: PetenItza.Curtis.1998.lpd\n",
      "reading: Dolgoe.Wolfe.2000.lpd\n",
      "reading: DevilsLake.Shuman.2016.lpd\n",
      "reading: GeoB9528-3.Collins.2013.lpd\n",
      "reading: MD95_2011.lpd\n",
      "reading: GeoB12615_4.lpd\n",
      "reading: LagunaChaplin.Pollen.Bolivia.lpd\n",
      "reading: M77_2_056_5.lpd\n",
      "Finished read: 943 records\n",
      "CPU times: user 1min 1s, sys: 5.6 s, total: 1min 7s\n",
      "Wall time: 1min 11s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "with remember_cwd():\n",
    "    os.chdir('../data/')\n",
    "    data = lipd.readLipd('.')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Extract all the paleoData series from the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "extracting paleoData...\n",
      "extracting: Hams.Bennett.1987\n",
      "extracting: MV99-GC31.Barron.2012\n",
      "extracting: EagleTarn.Rees.2010\n",
      "extracting: Sonk11D.Lauterbach.2014\n",
      "extracting: HjortSo.Wagner.2008\n",
      "extracting: Alley.GISP2.2000\n",
      "extracting: Victoria.Berke.2012\n",
      "extracting: GeoB58044.Lamy.2003\n",
      "extracting: Frozen.Rosenberg.2004\n",
      "extracting: GeoB9307_3\n",
      "extracting: Composit_MD012421,KR0206\n",
      "extracting: FloatingIsland.Baker.1976\n",
      "extracting: LakeSix.Liu.1990\n",
      "extracting: ScreamingLynxLake.Clegg.2011\n",
      "extracting: LonarLake.Prasad.2014\n",
      "extracting: Malawi.Johnson.2016\n",
      "extracting: WCA3B_GumboLimboFarTail.Willard.2001\n",
      "extracting: Coghill.King.1986\n",
      "extracting: Rogers.Marsicek.2013\n",
      "extracting: LacduSommet.Hausmann.2011\n",
      "extracting: BanksIsland74MS15.Gajewski.2000\n",
      "extracting: Mohawk_Pond.Marsicek.2013\n",
      "extracting: Sagistalsee.Pollen.Switzerland\n",
      "extracting: MD03_2611\n",
      "extracting: ODP1084B\n",
      "extracting: GiK18515_3\n",
      "extracting: DolgoeOzero.Pollen.Russia\n",
      "extracting: MD06_3075\n",
      "extracting: gunnarsfjorden.Allen.2007\n",
      "extracting: MundayCreek.Peteet.1986\n",
      "extracting: Buckeye.Hardt.2010\n",
      "extracting: Saarikko.Heikkil.2010\n",
      "extracting: sjuuodjijaure.Rosen.2001\n",
      "extracting: Lochnagar.Dalton.2005\n",
      "extracting: lapland.Helama.2010\n",
      "extracting: LakeSixteen.Futyma.1986\n",
      "extracting: Stazersee.Heiri.2015\n",
      "extracting: LakeBolshieToroki.Pollen.Russia\n",
      "extracting: GIK17049_6\n",
      "extracting: Wonderkrater.Scott.2016\n",
      "extracting: NevadoHuascaran.Thompson.1995\n",
      "extracting: HumberPond3.McAndrews.1989\n",
      "extracting: Jansvetnet.Birks.2012\n",
      "extracting: LakePupuke.Pollen.NewZealand\n",
      "extracting: PechoraLake.Andren.2015\n",
      "extracting: Bosten.Chen.2008\n",
      "extracting: TN062-0550.Barron.2018\n",
      "extracting: Varddoaijavri.Luoto.2014\n",
      "extracting: TalkinTarn.Langdon.2004\n",
      "extracting: Nattmalsvatn.Janbu.2011\n",
      "extracting: Issyk.Chen.2008\n",
      "extracting: GeoB4905.Weldeab.2005\n",
      "extracting: BattleGround.Whitlock.1985\n",
      "extracting: JR244_GC528\n",
      "extracting: 117_723A\n",
      "extracting: PortageLake.McAndrews.NA\n",
      "extracting: Lynn.Nichols.1967\n",
      "extracting: dravladalsvatn.Bakke.2005\n",
      "extracting: Burden.Webb.1986\n",
      "extracting: UnitLake.Camill.2012\n",
      "extracting: SP10WINZ.Williams.2010\n",
      "extracting: V1927\n",
      "extracting: PC56_grayscale.Hughen.2000\n",
      "extracting: GrandRapids.Ritchie.1975\n",
      "extracting: Alzasca.Wirth.2013\n",
      "extracting: MD03_2607\n",
      "extracting: Duck.Winkler.1985\n",
      "extracting: Llet-Ti.Pollen.Russia\n",
      "extracting: DonggeCave_b\n",
      "extracting: CaribouHill.Lamb.1985\n",
      "extracting: Takahula.Clegg.2010\n",
      "extracting: PlateauRemote.MosleyThompson.1996\n",
      "extracting: GeoB71392.Kaiser.2008\n",
      "extracting: Ennadai_1972Site.Nichols.1975\n",
      "extracting: Sofular.Fleitmann.2009\n",
      "extracting: JohnKlondike.Matthews.1980\n",
      "extracting: LagoVerdarolo.Samartin.2011\n",
      "extracting: Iglutalik.Davis.NA\n",
      "extracting: KF16\n",
      "extracting: SP02.Adams.2010\n",
      "extracting: MD01-2446.Salguero.2014\n",
      "extracting: ParkPond3.Lynch.1998\n",
      "extracting: Lyadhej-To.Andreev.2005\n",
      "extracting: ARC4.Belt.2010\n",
      "extracting: ODP967D.Emeis.2000\n",
      "extracting: MD01-2412.Harada.2006\n",
      "extracting: Ledro.Wirth.2013\n",
      "extracting: PS2641.Muller.2012\n",
      "extracting: GravelRidge.Lamb.1985\n",
      "extracting: LakeLR1.Gajewski.1993\n",
      "extracting: Hinterburg.Wirth.2013\n",
      "extracting: PointEscuminac.Warner.1991\n",
      "extracting: Hirvijaervi.Luoto.2010\n",
      "extracting: GeoB10043_3\n",
      "extracting: Hovsgol.Chen.2008\n",
      "extracting: ODP967.Larrasoana.2008\n",
      "extracting: Redstone.Brubaker.1985\n",
      "extracting: Kennys.Macpherson.1983\n",
      "extracting: Vostok_Antarctica\n",
      "extracting: BogD.McAndrews.1966\n",
      "extracting: ParkPond2.Lynch.1998\n",
      "extracting: BiglandTarn.Barber.2013\n",
      "extracting: Medicine.Radle.1992\n",
      "extracting: trehorningen.Antonsson.2007\n",
      "extracting: Chatsworth.King.1981\n",
      "extracting: HealLake.Brown.2006\n",
      "extracting: Midden.Cluster9.2019\n",
      "extracting: KNR140_51GGC\n",
      "extracting: Midden.Cluster8.2019\n",
      "extracting: GeoB58044.Lamy.2005\n",
      "extracting: H214\n",
      "extracting: Hamundarstadhahals.Caseldine.2006\n",
      "extracting: ClarksJunction.Pollen.NewZealand\n",
      "extracting: ARC3.Belt.2010\n",
      "extracting: AjaxBog.Pollen.NewZealand\n",
      "extracting: HiddenLake.Potito.2006\n",
      "extracting: DomeC.Stenni.2001\n",
      "extracting: E_Lake.Ritchie.1976\n",
      "extracting: LacFaribault.Larouche.1981\n",
      "extracting: OliverPond_1770.McAndrews.1990\n",
      "extracting: Sud_duLac_duNoyer.Larouche.1977\n",
      "extracting: M25_4_KL11\n",
      "extracting: Deltasoe.Axford.2019\n",
      "extracting: raigastvere.Seppa.2004\n",
      "extracting: Asia-LakeHuguangMaar\n",
      "extracting: BotuveraCave\n",
      "extracting: MeerfelderMaar.Pollen-Germany-MeerfelderMaar.Kuehl\n",
      "extracting: SihailongwanMaarLake.Stebich.2015\n",
      "extracting: Koucha.Pollen.China\n",
      "extracting: Nina.Liu.1990\n",
      "extracting: Marion_BC.Mathewes.1973\n",
      "extracting: KeystoneIronbog.Fall.1985\n",
      "extracting: LacPetel.King.1986\n",
      "extracting: MD06_3067\n",
      "extracting: NevadaPrecip.Hughes.1996\n",
      "extracting: GRIP.Vinther.2006\n",
      "extracting: Jewell.Baker.1986\n",
      "extracting: Garlate.Wirth.2013\n",
      "extracting: njakajaure.Bigler.1998\n",
      "extracting: Pickerel.Shuman.2016\n",
      "extracting: dalene.Eide.2009\n",
      "extracting: ArolikLake.Hu.2003\n",
      "extracting: tornetrask.Grudd.2002\n",
      "extracting: Gerzensee.Cladocera.Switzerland\n",
      "extracting: Ladd.Shane.1993\n",
      "extracting: BI2.Gajewski.1992\n",
      "extracting: Brandreth.Overpeck.1985\n",
      "extracting: HeihaiLake.Chang.2017\n",
      "extracting: Pallcacocha.Moy.2002\n",
      "extracting: SS16.Perren.2012\n",
      "extracting: Marion.Mathewes.1973\n",
      "extracting: O2kLR-Tagusmudpatc.Abrantes.2005\n",
      "extracting: GeoB58044.Lamy.2004\n",
      "extracting: grostjorn.Eide.2009\n",
      "extracting: GeoB5844_2\n",
      "extracting: DHP174.Porter.2019\n",
      "extracting: Qixing.Cai.2001\n",
      "extracting: Hvitarvatn.Larsen.2013\n",
      "extracting: LacGras.King.1986\n",
      "extracting: LakeHintererSchwendisee.Wirth.2013\n",
      "extracting: Minucua.Goman.2018\n",
      "extracting: HawkeHillsKettle.Macpherson.1982\n",
      "extracting: LakeWestOkoboji.Van.1979\n",
      "extracting: GeoB58044.Lamy.2006\n",
      "extracting: Chatsworth.Shuman.2016\n",
      "extracting: Toskaljavri.Seppa.2002\n",
      "extracting: jarburvatnet.Nesje.2001\n",
      "extracting: Harrie.King.1986\n",
      "extracting: SanbaoSB43.Dong.2010\n",
      "extracting: MD032707.Weldeab.2007\n",
      "extracting: agassiz.Vinther.2009\n",
      "extracting: Heihai.Ramisch.2016\n",
      "extracting: BanksIsland74MS11.Gajewski.2000\n",
      "extracting: RedmountainLake.Chase.2008\n",
      "extracting: BearBog.McAndrews.1992\n",
      "extracting: Midden.Cluster3.2019\n",
      "extracting: Midden.Cluster2.2019\n",
      "extracting: M40-4-SL78.Emeis.2003\n",
      "extracting: braya_so.Dandrea.2011\n",
      "extracting: Ammersee.Czymzik.2012\n",
      "extracting: MSM5_512\n",
      "extracting: JamesRossIsland.Mulvaney.2012\n",
      "extracting: LakeNalengcuo.Pollen.China\n",
      "extracting: Big.Cumming.2002\n",
      "extracting: ODP1019.Barron.2003\n",
      "extracting: ColdWater.Denniston.1999\n",
      "extracting: MD952042.Bard.2002\n",
      "extracting: JM98-1.Husum.2004\n",
      "extracting: Hams.Shuman.2016\n",
      "extracting: Logan.Fisher.2008\n",
      "extracting: GeoB9508_5\n",
      "extracting: OwensLake.Benson.2002\n",
      "extracting: Emerald.Shuman.2014\n",
      "extracting: PortageBog.Anderson.1980\n",
      "extracting: vuoskkujavri.Bigler.2002\n",
      "extracting: PorquiPond.McAndrews.NA\n",
      "extracting: dalmutladdo.Bjune.2004\n",
      "extracting: PSh-5157.Risebrobakken.2011\n",
      "extracting: Buckeye.Springer.2008\n",
      "extracting: CC04\n",
      "extracting: KZAI_01\n",
      "extracting: Elfstadalsvatn.Langdon.2008\n",
      "extracting: M_Lake.Ritchie.1977\n",
      "extracting: sfl4-1.Willemse.1999\n",
      "extracting: MD012378.Xu.2008\n",
      "extracting: Seelisberg.Wirth.2013\n",
      "extracting: ThunderLake.Chase.2008\n",
      "extracting: PolevaCave.Constantin.2007\n",
      "extracting: Kenosee.Porter.1992\n",
      "extracting: SSDP102\n",
      "extracting: GRIP_accumulation.Vinther.2006\n",
      "extracting: LakeEC1.Gajewski.1993\n",
      "extracting: PL0739PC.Lea.2003\n",
      "extracting: NBJ2015iso.Wong.2015\n",
      "extracting: PSh-5159N.Risebrobakken.2011\n",
      "extracting: AwengCo.Li.2017\n",
      "extracting: PinkPanther.Asmerom.2007\n",
      "extracting: SU81_18\n",
      "extracting: LakeEC2.Gajewski.1991\n",
      "extracting: DajiuhuPeatland.Huang.2013\n",
      "extracting: MSM055_723-2.Werner.2015\n",
      "extracting: spaime.Hammarlund.2004\n",
      "extracting: PathLake.Neil.2014\n",
      "extracting: Ennadai.Nichols.1967\n",
      "extracting: Corser.Nichols.2014\n",
      "extracting: SS49.Perren.2012\n",
      "extracting: Kyutyunda.Pollen.Russia\n",
      "extracting: SprucePond.Shuman.2016\n",
      "extracting: Minnetonka.Lundeen.2013\n",
      "extracting: 161_976\n",
      "extracting: JiuxianCave.Cai.2010\n",
      "extracting: MSM05_5_723_2\n",
      "extracting: MD01_2378\n",
      "extracting: waskey.Levy.2004\n",
      "extracting: TN062-0550.Addison.2018\n",
      "extracting: LacMartyne.McAndrews.NA\n",
      "extracting: fauske.Linge.2009\n",
      "extracting: KaiteCobreMayor.Martin-Chivelet.2011\n",
      "extracting: Peggy.McAndrews.NA\n",
      "extracting: GeoB6211_2\n",
      "extracting: MooseLake.Clegg.2010\n",
      "extracting: penny.Fisher.1998\n",
      "extracting: DonggeCave.Wang.2005\n",
      "extracting: MD03_2699\n",
      "extracting: YakYakumo.Leipe.2013\n",
      "extracting: LakeLyadhej-To.Andreev.2005\n",
      "extracting: igaliku.Massa.2012\n",
      "extracting: LochantSuidhe.Edwards.2007\n",
      "extracting: Khoe.Leipe.2015\n",
      "extracting: igelsjon..2003\n",
      "extracting: GeoB12605_3\n",
      "extracting: LacColin.Mott.1977\n",
      "extracting: Decoy.Szeicz.1991\n",
      "extracting: PC_01\n",
      "extracting: SouthRhodyBog.Booth.2012\n",
      "extracting: POS362_2_33\n",
      "extracting: Little.Whitlock.1995\n",
      "extracting: Yanahaizi.Chen.2003\n",
      "extracting: Egelsee.Larocque.2010\n",
      "extracting: Baldegg.Wirth.2013\n",
      "extracting: Camp11.Brubaker.1975\n",
      "extracting: MD99-2322.Jennings.2011\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "extracting: Duck_Pond.Marsicek.2013\n",
      "extracting: soylegrotta.Lauritzen.1999\n",
      "extracting: OregonCaves.Ersek.2012\n",
      "extracting: GeoB10235.Kim.2002\n",
      "extracting: PerchLake_Manitoba.Ritchie.NA\n",
      "extracting: LV29_114_3\n",
      "extracting: MD84_527\n",
      "extracting: GeoB9508-5.Collins.2013\n",
      "extracting: MD02_2575.Ziegler.2008\n",
      "extracting: ODP1098B\n",
      "extracting: Moraine.Hansen.1985\n",
      "extracting: MD99-2284.Risebrobakken.2009\n",
      "extracting: Chaohu.Pollen.China\n",
      "extracting: KirmanLake.MacDonald.2016\n",
      "extracting: MoonLake.Shuman.2016\n",
      "extracting: hallet.McKay.2009\n",
      "extracting: LacBrule.Pollen.Canada\n",
      "extracting: LakeStowell.Lemmen&Lacourse.2018\n",
      "extracting: klotjarnen.Seppa.2009\n",
      "extracting: HodellMiragoane1991\n",
      "extracting: BS7938\n",
      "extracting: DSDP480.Barron.2004\n",
      "extracting: JR51-GC35.Bendle.2007\n",
      "extracting: SaintCalixte.Larouche.NA\n",
      "extracting: MD982181\n",
      "extracting: LakeLR3.Gajewski.1992\n",
      "extracting: vikjordvatnet.Balascio.2012\n",
      "extracting: WCA3B_GumboLimboMarsh.Willard.2001\n",
      "extracting: GEOFAR_KF16_MgCa.Repschlager.2016\n",
      "extracting: EagleLake.Lamb.1980\n",
      "extracting: RAPID-12.Thournally.2009\n",
      "extracting: Lake31.Eisner.1995\n",
      "extracting: Midden.Cluster4.2019\n",
      "extracting: BanksIsland74MS12.Gajewski.2000\n",
      "extracting: Midden.Cluster5.2019\n",
      "extracting: MD01_2390\n",
      "extracting: JM96-1207.Solignac.2013\n",
      "extracting: Mohawk.Webb.1986\n",
      "extracting: MD952015\n",
      "extracting: SchwarzseeobSoelden.Ilyashuk.2011\n",
      "extracting: KR02.Pollen.Canada\n",
      "extracting: Holtjaernen.Pollen.Sweden\n",
      "extracting: VestreOEykjamyrtjoern.Pollen.Sweden\n",
      "extracting: myrvatn.Seppa.2009\n",
      "extracting: trettetjorn.Bjune.2005\n",
      "extracting: Reidel.Almquist.1992\n",
      "extracting: ennadai.Bender.1967\n",
      "extracting: LouisePond.Mathewes.1994\n",
      "extracting: GeoB10042_1\n",
      "extracting: SoreqCave\n",
      "extracting: Abalone.Cole.1994\n",
      "extracting: LakeoftheWoods.Palmer.2002\n",
      "extracting: Ramsay.Mott.1978\n",
      "extracting: MeliLake.Anderson.2001\n",
      "extracting: BerryPond.Shuman.2004\n",
      "extracting: svanavatnet.Bjune.2008\n",
      "extracting: MSM055_712-2.Werner.2015\n",
      "extracting: isbenttjonn.Seppa.2009\n",
      "extracting: oykjamyrtjorn.Bjune.2005\n",
      "extracting: TanaLake\n",
      "extracting: VestreOykjamytjorn.Velle.2005\n",
      "extracting: MD032601.Crosta.2007\n",
      "extracting: Wolverine.Mann.2002\n",
      "extracting: Nutt.Shuman.2016\n",
      "extracting: Cadagno.Niemann.2012\n",
      "extracting: DomeF.Kawamura.2007\n",
      "extracting: Holebudalen.Seppa.2009\n",
      "extracting: Hongyuan.Yu.2006\n",
      "extracting: GreatBasin.Salzer.2013\n",
      "extracting: TaquitzMeadow.Pollen.USA\n",
      "extracting: Aus-MorosMurrayCanyon\n",
      "extracting: B997-321.Smith.2005\n",
      "extracting: LakePupuke.VandenBos.2018\n",
      "extracting: ElGygytgynCrater.Schwamborn.2006\n",
      "extracting: Irvin.Cushing.1982\n",
      "extracting: MorrisPond.Morris.2013\n",
      "extracting: High.Fuller.1997\n",
      "extracting: GeoB9526-5.Collins.2013\n",
      "extracting: LakeBN7.Gajewski.1991\n",
      "extracting: PotrokAike.Massaferro.2013\n",
      "extracting: ODP1751078C\n",
      "extracting: Lofty.Lichti.1970\n",
      "extracting: Agassiz.Lecavalier.2017\n",
      "extracting: Gucheng.Pollen.China\n",
      "extracting: Indian.Bjorck.1985\n",
      "extracting: Dune.Finney.2012\n",
      "extracting: CoppermineSaddleback.Nichols.1975\n",
      "extracting: Svartvatnet.Luoto.2018\n",
      "extracting: M75_3_137_3\n",
      "extracting: Lions.Sabatier.2012\n",
      "extracting: Neor.Sharifi.2015\n",
      "extracting: NorthCraterLake.Palmer.2002\n",
      "extracting: kortlanda..2008\n",
      "extracting: BloodPond.Marsicek.2013T\n",
      "extracting: ColdAirCave\n",
      "extracting: s53s52.Tillman.2010\n",
      "extracting: farewell.Hu.1998\n",
      "extracting: nautajarvi.Ojala.2009\n",
      "extracting: MD99-2317.Jennings.2011\n",
      "extracting: SN-6.STiwari.2015\n",
      "extracting: Rystad.Vorren.2012\n",
      "extracting: GeoB100384.Mohtadi.2010\n",
      "extracting: XingyunLake.Wu.2018\n",
      "extracting: JPC76.Friddell.2002\n",
      "extracting: MD022529.Leduc.2007\n",
      "extracting: GYXO.Self.2015\n",
      "extracting: Porphyry.Brown.2002\n",
      "extracting: SanJuanRiverDischarge.Brown.2015\n",
      "extracting: TigrePerdido.vanBreukelen.2008\n",
      "extracting: hudson.Clegg.2011\n",
      "extracting: Mount_Honey\n",
      "extracting: tibetanus.Hammarlund.2002\n",
      "extracting: FinseStasjonsdam.Velle.2005\n",
      "extracting: Devils.Maher.1982\n",
      "extracting: Kharinei.Pollen.Russia\n",
      "extracting: 893A.Kennet.2007\n",
      "extracting: LeadingTickles.Macpherson.1985\n",
      "extracting: SouthernCalifornia.OhlweinWahl.2012\n",
      "extracting: DA05.Lloyd.2007\n",
      "extracting: QunfCave.Fleitmann.2007\n",
      "extracting: starvatn.Andresen.2006\n",
      "extracting: Aus-MarxUpperSnowy\n",
      "extracting: V2130\n",
      "extracting: GeoB10069-3.Gibbons.2014\n",
      "extracting: FoyLake.Stone.2008\n",
      "extracting: Crates.Liu.NA\n",
      "extracting: ParkPond1.Lynch.1998\n",
      "extracting: PeatlandKlukva.Pollen.Russia\n",
      "extracting: Compass.Macpherson.1986\n",
      "extracting: Svartkalstjarn..2010\n",
      "extracting: Mansell.Shuman.2016\n",
      "extracting: AralSea.Chen.2008\n",
      "extracting: GeoB65181.Schefu.2005\n",
      "extracting: MD07-3104.Pollen.Chile\n",
      "extracting: TangledUpLake.Anderson.2001\n",
      "extracting: kjennsvatn.Bakke.2010\n",
      "extracting: D13822\n",
      "extracting: CarletonLake(informalname).Upiter.2014\n",
      "extracting: GrahamLake.Shuman.2016\n",
      "extracting: Tourbiere_deLanoraieJoseph.Comtois.1982\n",
      "extracting: HM03_133_25\n",
      "extracting: ODP-984.Came.2007\n",
      "extracting: BOFS5K\n",
      "extracting: kusawa.Chakraborty.2010\n",
      "extracting: Deep.Marsicek.2013\n",
      "extracting: Vuoksjavratje.Berntsson.2014\n",
      "extracting: ODP1671017E\n",
      "extracting: Atocas.Gauthier.1981\n",
      "extracting: GeoB7702-3.Castaneda.2016\n",
      "extracting: SIPLEMelt.Das.2008\n",
      "extracting: ratasjoen.Velle.2005\n",
      "extracting: ClelandLake.Steinman.2016\n",
      "extracting: Maplehurst.Mott.1978\n",
      "extracting: BisonLake.Anderson.2011\n",
      "extracting: laihalampi.Heikkila.2003\n",
      "extracting: kinnshaugen.Seppa.2009\n",
      "extracting: Davis.Newby.2014\n",
      "extracting: Ferndale.Albert.1981\n",
      "extracting: Tourbiere_deLanorieHenri.Comtois.1982\n",
      "extracting: Windy.Chase.2008\n",
      "extracting: KY07_04_01.Kubota.2010\n",
      "extracting: JR01.Fortin&Gajewski.2017\n",
      "extracting: MSM343300\n",
      "extracting: BighornBasin.Shuman.2012\n",
      "extracting: JinchueanBog.Yu.2013\n",
      "extracting: Longwoods.Pollen.NewZealand\n",
      "extracting: LoonPond.Jacobson.Ja\n",
      "extracting: GeoB7920-2.Collins.2013\n",
      "extracting: Qipisarqo.Wooller.2004\n",
      "extracting: HAP0212.vanderBilt.2016\n",
      "extracting: HU90.deVernal.2013\n",
      "extracting: BoothIrwinSmith2012\n",
      "extracting: ODP658C.deMenocal.1997\n",
      "extracting: MD012390.Steinke.2008\n",
      "extracting: TaulMuced.Diaconu.2017\n",
      "extracting: M77_2_059_1\n",
      "extracting: jake.Kerwin.2005\n",
      "extracting: Crowsnest.Anderson.NA\n",
      "extracting: GIK18287_3\n",
      "extracting: M39008.Cacho.2001\n",
      "extracting: Sigrid.Nazarova.2017\n",
      "extracting: N14..2004\n",
      "extracting: Hershop.Larson.1972\n",
      "extracting: LakeNikolay.Pollen.Russia\n",
      "extracting: Spannagel.Fohlmeister.2012\n",
      "extracting: devon.Fisher.1983\n",
      "extracting: Gould.Jacobson.1992\n",
      "extracting: M35003_4\n",
      "extracting: TTR-12_293G.Rodrigo-Gamiz.2014\n",
      "extracting: HumberPond5.McAndrews.1989\n",
      "extracting: Fiskebolvatnet.Balascio.2012\n",
      "extracting: MD02_2529\n",
      "extracting: ODP658C_UK37.Zhao.1995\n",
      "extracting: NorthPond.Whitehead.1978\n",
      "extracting: Kotokel.Tarasov.2009\n",
      "extracting: GIK23258.Sarnthein.2003\n",
      "extracting: Clearwater.Mott.1973\n",
      "extracting: LacLeonard.Labelle.1984\n",
      "extracting: Beaverhouse.Ritchie.1976\n",
      "extracting: LO09.Berner.2008\n",
      "extracting: StewartsDark.Peters.1984\n",
      "extracting: Hanging.Cwynar.1982\n",
      "extracting: AlanenLaanijarvi.Heinrichs.2005\n",
      "extracting: P178-15P.Tierney.2015\n",
      "extracting: LacMeleze.MacDonald.1987\n",
      "extracting: Zabieninec.Plociennik.2011\n",
      "extracting: BloodPond.Marsicek.2013\n",
      "extracting: Elsinore.Kirby.2010\n",
      "extracting: big_round.Thomas.2010\n",
      "extracting: Hidden.Shuman.2009\n",
      "extracting: PassLake.McAndrews.1986\n",
      "extracting: KR02.Peros.2008\n",
      "extracting: WA01.Rainville.2013\n",
      "extracting: Olive-backedLake.Self.2015\n",
      "extracting: MD99-2264.Olafsdottir.2010\n",
      "extracting: RiviereFeuilles1.Larouche.1981\n",
      "extracting: MSM05-712.Muller.2013\n",
      "extracting: BoomerangLake.Brown.2006\n",
      "extracting: tsuolbmajavri.Korhola.2009\n",
      "extracting: Hinterburgsee.Heiri.2003\n",
      "extracting: Bjornfjell.Brooks.2006\n",
      "extracting: renland.Vinther.2009\n",
      "extracting: BerryPondWest1979\n",
      "extracting: Asia-LianhuaCave\n",
      "extracting: BegbieLake.Brown.2019\n",
      "extracting: WCA3B_GumboLimboWetHead.Willard.2001\n",
      "extracting: Hani.Zheng.2017\n",
      "extracting: MD97_2151\n",
      "extracting: Gass.Webb.1983\n",
      "extracting: DavisLake.Whitlock.1981\n",
      "extracting: ME005A43JC\n",
      "extracting: CuevadeAsiul.Smith.2016\n",
      "extracting: rainbow.Clegg.2011\n",
      "extracting: V12-107.Schmidt.2016\n",
      "extracting: k2.Fallu.2005\n",
      "extracting: Gammelheimvatnet.Seppa.2009\n",
      "extracting: PlatypusTarn.Rees.2010\n",
      "extracting: Castor.Nelson.2011\n",
      "extracting: LakeLB1.Gajewski.1993\n",
      "extracting: CottonwoodLake.Grimm.1987\n",
      "extracting: DANA12_11_2_GC01\n",
      "extracting: Midden.Cluster1.2019\n",
      "extracting: LacAurelie.Bajolle.2018\n",
      "extracting: EDML.Stenni.2009\n",
      "extracting: CottonwoodPassPond.Fall.1997\n",
      "extracting: PP10-07.Mary.2016\n",
      "extracting: SouthAfricanSummerRainfallZone.Climate-12k-Site-Data-Entry-Form-v3.SASRZ\n",
      "extracting: ranger.Brubaker.1983\n",
      "extracting: Deep.Shuman.2016\n",
      "extracting: PixieLake.Brown.2006\n",
      "extracting: MD95-2040.Salguero.2014\n",
      "extracting: Jack.Liu.1985\n",
      "extracting: Gilltjarnen.Antonsson.2006\n",
      "extracting: LittleWindy.Minckley.2012\n",
      "extracting: Balikun.Chen.2008\n",
      "extracting: HU91.Levac.2013\n",
      "extracting: OCE326GGC26\n",
      "extracting: Nerfloen.Vasskog.2012\n",
      "extracting: StaroselskyMoch.Pollen.Russia\n",
      "extracting: BS7933\n",
      "extracting: McMaster.Moser.1990\n",
      "extracting: Tumbulovaty.Kultti.2004\n",
      "extracting: Berry.Whitehead.1979\n",
      "extracting: Gushantun.Zheng.2018\n",
      "extracting: TaylorDome_dD\n",
      "extracting: Bastien.Bennett.1987\n",
      "extracting: MD99-2256.Olafsdottir.2010\n",
      "extracting: OCE326GGC30\n",
      "extracting: Flarken.Seppa.2005\n",
      "extracting: South_Island\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "extracting: Cummins.McAndrews.1984\n",
      "extracting: LakeXimencuo.Pollen.China\n",
      "extracting: lake850.Shemesh.2001\n",
      "extracting: Kharinei.Jones.2011\n",
      "extracting: LakeCF8.Axford.2011\n",
      "extracting: Kurupa.Boldt.2015\n",
      "extracting: LawDome.Dahl-Jensen.1999\n",
      "extracting: HulunLake.Wen.2009\n",
      "extracting: HomesteadScarp.McGlone.2010\n",
      "extracting: CangoCave.Climate-12k-Site-Data-Entry-Form-v3.Cango\n",
      "extracting: DevonIslandGlacier.McAndrews.1984\n",
      "extracting: SaintGabriel.Larouche.1977\n",
      "extracting: Edward.Russell.2003\n",
      "extracting: Cadagno.Wirth.2013\n",
      "extracting: NP04KH3KH4.Tierney.2008\n",
      "extracting: Hudson.Bailey.1972\n",
      "extracting: LagoMoreno.Pollen.Argentina\n",
      "extracting: LostLake_MT.Whitlock.1989\n",
      "extracting: ODP1019D\n",
      "extracting: LittleBass.Swain.NA\n",
      "extracting: arapisto.Sarmaja-Korjonen.2007\n",
      "extracting: DonggeCave.Dyoski.2005\n",
      "extracting: Hypkana.Hajkova.2016\n",
      "extracting: LakeKupal'noe.Ilyashuk.2013\n",
      "extracting: MSM05-723..2012\n",
      "extracting: Pingwang.Pollen.China\n",
      "extracting: SO139-74KL.Luckge.2008\n",
      "extracting: LakeVan.Chen.2008\n",
      "extracting: 165_1002C\n",
      "extracting: CH0798GGC19\n",
      "extracting: MD02-2515.Bhattacharya.2018\n",
      "extracting: LowerBearLake.Kirby.2012\n",
      "extracting: BeaverLake.Schmieder.2011\n",
      "extracting: EnosLake.Brown.2006\n",
      "extracting: Hinterburgsee.Heiri.2015\n",
      "extracting: Mendota.Winkler.1986\n",
      "extracting: Moon.Grimm.1996\n",
      "extracting: Tigalmamine.Climate-12k-Site-Data-Entry-Form-v3.Tigalmamine\n",
      "extracting: gloppsjon.Seppa.2009\n",
      "extracting: GeoB7622-2.Lamy.2006\n",
      "extracting: MD982176\n",
      "extracting: Ghirla.Wirth.2016\n",
      "extracting: LacLouis.Vincent.1973\n",
      "extracting: Grenadier.McAndrews.1988\n",
      "extracting: NewLong.Newby.2014\n",
      "extracting: LimeLake.Steinman.2016\n",
      "extracting: HomesteadScarp,CampbellIsland.Pollen.NewZealand\n",
      "extracting: Malawi.Powers.2005\n",
      "extracting: LongLake.Kay.1979\n",
      "extracting: StellaLake.Reinemann.2009\n",
      "extracting: SanLuisLake.Yuan.2013\n",
      "extracting: JM01-1199.Hald.2007\n",
      "extracting: LakeGB2.Gajewski.1993\n",
      "extracting: Pickerel_SD.Watts.1968\n",
      "extracting: tiavatnet.Seppa.2009\n",
      "extracting: 18287-3.Kienast.2001\n",
      "extracting: Kirchner.Wright.1963\n",
      "extracting: nikolay.Andreev.2004\n",
      "extracting: Troll28-03.Klitgard-Kristensen.2001\n",
      "extracting: lonespruce.Kaufman.2012\n",
      "extracting: 74KL_UK37.Huguet.2006\n",
      "extracting: Qipisarqo.Frechette.2009\n",
      "extracting: AlfonsoBasin.StainesUrias.2015\n",
      "extracting: 2005-804.Ledu.2013\n",
      "extracting: GeoB7625-2.Lamy.2006\n",
      "extracting: YellowLake.Anderson.2012\n",
      "extracting: Graham.Fuller.1997\n",
      "extracting: MilandreCav.Affolter.2019\n",
      "extracting: iglutalik.Davis.1980\n",
      "extracting: P1003.Sejrup.2011\n",
      "extracting: 2004_804_009_PC\n",
      "extracting: Aus-WilkinsKeilambeteGnotuk\n",
      "extracting: candelabra.Cwynar.1995\n",
      "extracting: upper_fly.Bunbury.2009\n",
      "extracting: MD972120\n",
      "extracting: CariacoBasin.Haug.2001\n",
      "extracting: trout.Irvine.2012\n",
      "extracting: EaglenestLake.Vance.1986\n",
      "extracting: MD95-2011.Berner.2010\n",
      "extracting: CaribouLake.Rolland.2008\n",
      "extracting: Laihalampi.Pollen.Sweden\n",
      "extracting: austerkjosen.Seppa.2009\n",
      "extracting: RhamnusLake.Brown.2006\n",
      "extracting: Jeita.Cheng.2015\n",
      "extracting: NoBottom.Dunwiddie.1990\n",
      "extracting: M39_008\n",
      "extracting: SO90_56KA\n",
      "extracting: MD99-2227.deVernal.2013\n",
      "extracting: BJ8_70GGC\n",
      "extracting: Khatanga-12Lake.Syrykh.2017\n",
      "extracting: TorontoLake.Wolfe.1996\n",
      "extracting: RC12-10.Poore.2003\n",
      "extracting: MV99-GC41.Marchitto. 2010\n",
      "extracting: MD79257\n",
      "extracting: Tanganyika.Tierney.2008\n",
      "extracting: MD972121\n",
      "extracting: CuevaDiablo.Bernal.2011\n",
      "extracting: Delorme1.Bouchard.1982\n",
      "extracting: BJ8_13GGC\n",
      "extracting: SpringValleyCave.Denniston.1999\n",
      "extracting: M25and4KL11.Emeis.2003\n",
      "extracting: Hinterburgsee.Heiri.2004\n",
      "extracting: njulla.Bigler.2003\n",
      "extracting: Ghirla.Wirth.2013\n",
      "extracting: MD98_2188\n",
      "extracting: UpperBigCreek.Shuman.2015\n",
      "extracting: No_Bottom_Pond.Marsicek.2013\n",
      "extracting: HU84.deVernal.2013\n",
      "extracting: Ammersee.vonGrafenstein.1996\n",
      "extracting: PM9462_4\n",
      "extracting: LakeBerkut.Ilyashuk.2005\n",
      "extracting: PC2.Seki.2004\n",
      "extracting: NIOP905_TEX86\n",
      "extracting: Sokli.Shala.2017\n",
      "extracting: ClearLake_Iowa.Baker.1992\n",
      "extracting: MD07-3088.Pollen.Chile\n",
      "extracting: Njulla.Larocque&Hall.2004\n",
      "extracting: Posy.Shafer.1989\n",
      "extracting: MysteryCave..2004\n",
      "extracting: EDC.Jouzel.2007\n",
      "extracting: SO189-39KL.Mohtadi.2014\n",
      "extracting: Nutt.Bennett.1987\n",
      "extracting: Chichancanab.Hodell.1995\n",
      "extracting: chuna.Jones.2005\n",
      "extracting: UpperPintoFen.Yu.2003\n",
      "extracting: BorderBeacon.Lamb.1985\n",
      "extracting: Pella.Climate-12k-Site-Data-Entry-Form-v3.Pella\n",
      "extracting: MD99-2269.Justwan.2008\n",
      "extracting: PerchLake_ON.Terasmae.1975\n",
      "extracting: MD01-2416.Sarnthien.2004\n",
      "extracting: ruila.Seppa.2004\n",
      "extracting: Haukdalsvatn.Larsen.2013\n",
      "extracting: LehmanCaves.Steponaitis.2015\n",
      "extracting: GeoB12610_2\n",
      "extracting: MD982165\n",
      "extracting: KT05_7_PC_02\n",
      "extracting: LakeAspvatnet_ELA.Bakke.2005\n",
      "extracting: O2kLR-CapeGhirNWAf.Kim.2006\n",
      "extracting: MD02-2517.Bhattacharya.2018\n",
      "extracting: M350034.Rhlemann\n",
      "extracting: Klotjaernen.Pollen.Sweden\n",
      "extracting: Sysy-Kyuele.Biskaborn.2012\n",
      "extracting: GeoB65181_MBT.Weijers.2007\n",
      "extracting: Heshang.Wang.2018\n",
      "extracting: CascadeFen.Maher.1963\n",
      "extracting: GIK17940_2\n",
      "extracting: Billys.Jacobson.1975\n",
      "extracting: LagoGeminiInferiore.Samartin.2011\n",
      "extracting: TauldintreBrazi.Toth.2015\n",
      "extracting: LaPAS_KF02\n",
      "extracting: Carp.Whitlock.1985\n",
      "extracting: IOW225514.Elmis.2003\n",
      "extracting: LakeCH2.Garralla.1992\n",
      "extracting: TourbiereDeLanoraieSTJEAN.Comtois.1982\n",
      "extracting: LakeChalla.Climate-12k-Site-Data-Entry-Form-v3.Challa\n",
      "extracting: PTHE.Self.2015\n",
      "extracting: DomeC.Jouzel.2007\n",
      "extracting: KR02.Fortin&Gajewski.2010\n",
      "extracting: flower_valley..2013\n",
      "extracting: Chron.Iceland.2013\n",
      "extracting: LakeAspvatnet_precip.Bakke.2005\n",
      "extracting: BCTempComp.Gavin.2013\n",
      "extracting: BasadelaMoraLake.Tarrats.2018\n",
      "extracting: MD94-103.Sicre.2005\n",
      "extracting: ThreePinesBog.McAndrews.1990\n",
      "extracting: AMP112.vanderBilt.2016\n",
      "extracting: flotatjonn.Seppa.2009\n",
      "extracting: Holzmaar.Luke.\n",
      "extracting: MD02-2553.Poore.2009\n",
      "extracting: SumxiCo.Leipe.2014\n",
      "extracting: Nichols.Corser.2014\n",
      "extracting: BC01.Peros.2010\n",
      "extracting: SilverLake.Kirby.2015\n",
      "extracting: HLY0501.deVernal.2013\n",
      "extracting: Core_63KA\n",
      "extracting: MD982170\n",
      "extracting: GGC19.Farmer.2011\n",
      "extracting: SV_04\n",
      "extracting: MonheganIslandMeadow.Bostwick.1978\n",
      "extracting: GISP2.Alley.2000\n",
      "extracting: MicaLake.Schiff.2009\n",
      "extracting: BrayaSo.vonGunten.2012\n",
      "extracting: LostLake_MI.Brubaker.1975\n",
      "extracting: Jones.Shapley.2009\n",
      "extracting: Steel.Shuman.2016\n",
      "extracting: GeoB59012.Kim.2004\n",
      "extracting: ForestPond1.Lynch.1998\n",
      "extracting: MD97-2151.Yamamoto.2013\n",
      "extracting: Whatever.Wolfe.1996\n",
      "extracting: Topptjonna.Paus.2011\n",
      "extracting: TR163_22\n",
      "extracting: MB01.Pollen.Canada\n",
      "extracting: Mo05LakeMondsee.Swierczynski.2013\n",
      "extracting: Hulun.Chen.2008\n",
      "extracting: GeoB3129.Weldeab.2006\n",
      "extracting: P1B3.deVernal.2005\n",
      "extracting: ClearLake_Indiana.Bailey.1972\n",
      "extracting: Jenny.Larson.2016\n",
      "extracting: century.Vinther.2009\n",
      "extracting: LacNoir.Pollen.Canada\n",
      "extracting: Kollioksak.Anderson.NA\n",
      "extracting: yarnyshnoe.Seppa.2008\n",
      "extracting: Glattalp.Wirth.2013\n",
      "extracting: Telmen.Chen.2008\n",
      "extracting: LoughMeenachrinna,CountyDonegal.Taylor.2018\n",
      "extracting: quartz.Wooller.2012\n",
      "extracting: Gerzensee.Pollen.Switzerland\n",
      "extracting: SK168_GC_1\n",
      "extracting: KinderlinskayaCave.Baker.2017\n",
      "extracting: Colo.Baker.1990\n",
      "extracting: LacMarcotte.Labelle.1981\n",
      "extracting: SS8.Anderson.2012\n",
      "extracting: Furnival.McAndrews.NA\n",
      "extracting: NIOP905_UK37\n",
      "extracting: SecretLake.Lasher.2017\n",
      "extracting: Minakokosa.Anderson.NA\n",
      "extracting: Mawmluh.Berkelhammer.2012\n",
      "extracting: BeefPasture.Petersen.1985\n",
      "extracting: brurskardstjorni.Velle.2005\n",
      "extracting: haugtjern.Eide.2009\n",
      "extracting: PolandSpring.Jacobson.Ja\n",
      "extracting: KP2.Seppa.2009\n",
      "extracting: Myrtle.Janssen.1968\n",
      "extracting: Jellybean.Anderson.2005\n",
      "extracting: meleze.MacDonald.1983\n",
      "extracting: WAISBubble.Fegyveresi.2016\n",
      "extracting: SL06.Pollen.Canada\n",
      "extracting: SK237-GC04.Saraswat.2013\n",
      "extracting: AD9117.Guinta.2001\n",
      "extracting: Little_Pond_Royalston.Marsicek.2013\n",
      "extracting: Delorme2.Bouchard.1982\n",
      "extracting: LagunaDeJuanacatlan.Jones.2015\n",
      "extracting: SacredLake\n",
      "extracting: Caribou.Labelle.1992\n",
      "extracting: Kilimanjaro.Thompson.2002\n",
      "extracting: Medvedevskoe.Nazarova.2018\n",
      "extracting: Core17940\n",
      "extracting: Mjauvotn.Olsen.2010\n",
      "extracting: MD99_2304\n",
      "extracting: lily.Cwynar.1990\n",
      "extracting: NH-8P.Bhattacharya.2018\n",
      "extracting: Sharkey.Shuman.2016\n",
      "extracting: MD95_2002\n",
      "extracting: Iffig.Wirth.2013\n",
      "extracting: TaylorDome_d18O\n",
      "extracting: Saint-JeanIle_dOrleans.Larouche.1971\n",
      "extracting: SO136GC11.Barrows.2007\n",
      "extracting: Ew0408-85JC.Praetorius.2015\n",
      "extracting: PL-96.Voronina.2013\n",
      "extracting: MD05_2904\n",
      "extracting: LakeHopeSimpson.Hansen.1985\n",
      "extracting: WhitePond.Krause.2019\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "extracting: LS009.Ledu.2010\n",
      "extracting: MD99-2266.Moossen.2015\n",
      "extracting: Mackenzie.Woltering.2014\n",
      "extracting: Reiarsdalvatnet.Seppa.2009\n",
      "extracting: ESM-1.Mackay.2012\n",
      "extracting: andy.Szeicz.1995\n",
      "extracting: MD95-2011.Calvo.2002\n",
      "extracting: Tourbiere_deLanorie_CoteauJaune.Comtois.1982\n",
      "extracting: NorthGRIP.Gkinis.2014\n",
      "extracting: hjort.Schmidt.2011\n",
      "extracting: MD952043\n",
      "extracting: Eldora.Maher.1969\n",
      "extracting: Buckbean.Baker.1976\n",
      "extracting: Turkana.Berke.2012\n",
      "extracting: Sellevollmyra.Vorren.2007\n",
      "extracting: SchellingsBog.Barron.2004\n",
      "extracting: MD99-2256.Jennings.2015\n",
      "extracting: Pixie.Brown.2002\n",
      "extracting: Leviathan.Lachniet.2014\n",
      "extracting: FiddlersPond.White.1982\n",
      "extracting: GISP2.Kobashi.2012\n",
      "extracting: Boone.White.1986\n",
      "extracting: LoneFoxLake.MacDonald.1985\n",
      "extracting: Minnie.McAndrews.1992\n",
      "extracting: OroLake.Michels.2007\n",
      "extracting: A7.Sun.2005\n",
      "extracting: 74KL_TEX86.Huguet.2006\n",
      "extracting: Cub.Rasmussen.1982\n",
      "extracting: bjornfjelltjorn.Brooks.2006\n",
      "extracting: TTR17_434G.Rodrigo-Gamiz.2014\n",
      "extracting: Stomyren..2008\n",
      "extracting: Korallgrottan.Sundqvist.2010\n",
      "extracting: BlueMoundsCreek.Davis.1977\n",
      "extracting: Lyadhej-To.Pollen.Russia\n",
      "extracting: GeoB3910.Jaeschke.2007\n",
      "extracting: svartvatnet.Seppa.2009\n",
      "extracting: SO42_74KL\n",
      "extracting: Crowfoot.Reasoner.1996\n",
      "extracting: LakeGB1.Gajewski.1991\n",
      "extracting: Cranberry.McAndrews.NA\n",
      "extracting: MD99-2256..2010\n",
      "extracting: VuolepNjakajaure.Heinrichs.2006\n",
      "extracting: LittlePond.Marsicek.2013\n",
      "extracting: GeoB12610-2.Rippert.2015\n",
      "extracting: Aus-KempWimmeraLakes\n",
      "extracting: MD01-2444.Martrat.2007\n",
      "extracting: akvaqiak.Frechette.2009\n",
      "extracting: GreyIslands.Cullen.2002\n",
      "extracting: Vouskku.Larocque.2004\n",
      "extracting: ClearPond_SCarolina.Hussey.1993\n",
      "extracting: Station803.Bringue.2012\n",
      "extracting: RiviereFeuilles2.Larouche.1981\n",
      "extracting: HeshangCave.Hu.2007\n",
      "extracting: Castor.Larouche.NA\n",
      "extracting: ElJunco.Conroy.2008\n",
      "extracting: Two-YourtsLake.Nazarova.2013\n",
      "extracting: Holzmaar.Pollen-Germany-Holzmaar.Kuehl\n",
      "extracting: Midden.Cluster7.2019\n",
      "extracting: Midden.Cluster6.2019\n",
      "extracting: RR1313_23PC\n",
      "extracting: honeymoon.Cwynar.1991\n",
      "extracting: MD97_2120\n",
      "extracting: JR01.Zabenskie.2007\n",
      "extracting: Sutherland.Shuman.2016\n",
      "extracting: Faelen.Wirth.2013\n",
      "extracting: Temje.Nazarova.2013\n",
      "extracting: Aden.Tierney.2013\n",
      "extracting: Queens.MacDonald.1990\n",
      "extracting: GISP2.Kobashi.2017\n",
      "extracting: hail.Cwynar.1995\n",
      "extracting: GunNuur.Chen.2008\n",
      "extracting: Crooked.Engels.2012\n",
      "extracting: LakeMina.Pollen.USA\n",
      "extracting: Eleanor.Gavin.2011\n",
      "extracting: NA87_22\n",
      "extracting: D13902\n",
      "extracting: MD95-2015.Giraudeau.2002\n",
      "extracting: IndianPrairieFen.Whitlock.1995\n",
      "extracting: Juyanze.Chen.2008\n",
      "extracting: Gemini.Samartin.2017\n",
      "extracting: NGRIP..2004\n",
      "extracting: LakeOfTheWoods.Pribyl.2014\n",
      "extracting: Marcella.Anderson.2007\n",
      "extracting: GeoB77023.Castaeda.2010\n",
      "extracting: NikolayLake.Andreev.2004\n",
      "extracting: GeoB7926_2\n",
      "extracting: Demont.Kapp.NA\n",
      "extracting: ODP1017E.Kennett.2000\n",
      "extracting: BoundaryLake.Stravers.1981\n",
      "extracting: Copley.Fall.1997\n",
      "extracting: HangingLake.Kurek.2009\n",
      "extracting: greyling.Mckay.2009\n",
      "extracting: Okoboji.Shuman.2016\n",
      "extracting: LagunaDeAljojuca.Bhattacharya.2015\n",
      "extracting: Vatnamyri.Caseldine.2006\n",
      "extracting: Dye3.Vinther.2006\n",
      "extracting: MR003-K03-PC01.Harada.2004\n",
      "extracting: TY93-905.Kim.2004\n",
      "extracting: Seukokjaure.Rosen.2003\n",
      "extracting: Wulun.Chen.2008\n",
      "extracting: TsoMoriri.Leipe.2013\n",
      "extracting: SS1381.Anderson.2012\n",
      "extracting: 3MPond.Pellatt.2000\n",
      "extracting: Keele.Szeicz.1995\n",
      "extracting: Chippewa.Bailey.1981\n",
      "extracting: Redondo.Brubaker.1983\n",
      "extracting: Bosumtwi.Shanahan.2015\n",
      "extracting: LiangLuarCave.Griggiths.2009\n",
      "extracting: ForestPond2.Lynch.1998\n",
      "extracting: MaraisdeKeswick.Larouche.1986\n",
      "extracting: GeoB10069_3\n",
      "extracting: Qinghai.Leipe.2013\n",
      "extracting: HighLake.Shuman.2016\n",
      "extracting: Grimsel.Wirth.2013\n",
      "extracting: LakeQinghai.Hou.2016\n",
      "extracting: Nedlouc.Larouche.1981\n",
      "extracting: liltlvatn.Seppa.2009\n",
      "extracting: Radtke.Webb.1983\n",
      "extracting: ARC5.Belt.2010\n",
      "extracting: TiancaiLake.Zhang.2017\n",
      "extracting: ODP_1240\n",
      "extracting: ParadiseLake.Steinman.2016\n",
      "extracting: TALDICE.Mezgec.2017\n",
      "extracting: EastBalticBog.Anderson.1980\n",
      "extracting: LagoDellAccesa.Finsinger.2010\n",
      "extracting: V1928\n",
      "extracting: BayanNuur.Chen.2008\n",
      "extracting: SO189-119KL.Mohtadi.2014\n",
      "extracting: LR01.Gajewski.1993\n",
      "extracting: Komosomolskaia.Ciais.1992\n",
      "extracting: Malangen.Husum.2004\n",
      "extracting: M44-KL71.Sperling.2003\n",
      "extracting: LacPatricia.McAndrews.1983\n",
      "extracting: Redrock.Maher.1972\n",
      "extracting: GeoB33131.Lamy.2002\n",
      "extracting: IOW225517.Elmis.2003\n",
      "extracting: PyramidLake.Benson.2001\n",
      "extracting: naujg1.Willemse.1999\n",
      "extracting: MD972141\n",
      "extracting: WAISDivide.Cuffey.2016\n",
      "extracting: north.Axford.2013\n",
      "extracting: LacHamard.Stravers.1981\n",
      "extracting: Axe.McAndrews.No\n",
      "extracting: EagleLake.Rosenberg.2004\n",
      "extracting: BoundaryPond.Mott.1977\n",
      "extracting: GeoB1711_4\n",
      "extracting: LifebuoyLake.Solivieva.2015\n",
      "extracting: Rapid.Fall.1994\n",
      "extracting: PogoniaBog.Cushing.1979\n",
      "extracting: MV0811-14JC.Du.2018\n",
      "extracting: MD02_2594\n",
      "extracting: PetenItza.Curtis.1998\n",
      "extracting: Dolgoe.Wolfe.2000\n",
      "extracting: DevilsLake.Shuman.2016\n",
      "extracting: GeoB9528-3.Collins.2013\n",
      "extracting: MD95_2011\n",
      "extracting: GeoB12615_4\n",
      "extracting: LagunaChaplin.Pollen.Bolivia\n",
      "extracting: M77_2_056_5\n",
      "Created time series: 6396 entries\n",
      "CPU times: user 7.49 s, sys: 1.57 s, total: 9.07 s\n",
      "Wall time: 9.03 s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "all_series = lipd.extractTs(data)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Extract only the temperature series with units in degrees Celsius"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Found 1085 matches from 6396 columns\n",
      "Found 548 matches from 1085 columns\n",
      "Found 509 matches from 548 columns\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['@context',\n",
       " 'age',\n",
       " 'ageUnits',\n",
       " 'agesPerKyr',\n",
       " 'archiveType',\n",
       " 'archiveTypeOriginal',\n",
       " 'createdBy',\n",
       " 'dataSetName',\n",
       " 'depth',\n",
       " 'depthUnits',\n",
       " 'geo_countryOcean',\n",
       " 'geo_location',\n",
       " 'geo_meanElev',\n",
       " 'geo_meanLat',\n",
       " 'geo_meanLon',\n",
       " 'geo_notes',\n",
       " 'geo_siteName',\n",
       " 'investigator',\n",
       " 'lastUpdated',\n",
       " 'lipdVersion',\n",
       " 'lipdverseLink',\n",
       " 'maxYear',\n",
       " 'minYear',\n",
       " 'mode',\n",
       " 'nUniqueAges',\n",
       " 'neotomaCoreID',\n",
       " 'paleoData_QCCertification',\n",
       " 'paleoData_QCLastUpdated',\n",
       " 'paleoData_TSid',\n",
       " 'paleoData_calibration_method',\n",
       " 'paleoData_calibration_methodDetail',\n",
       " 'paleoData_calibration_uncertainty',\n",
       " 'paleoData_calibration_uncertaintyType',\n",
       " 'paleoData_datum',\n",
       " 'paleoData_filename',\n",
       " 'paleoData_hasMaxValue',\n",
       " 'paleoData_hasMeanValue',\n",
       " 'paleoData_hasMedianValue',\n",
       " 'paleoData_hasMinValue',\n",
       " 'paleoData_hasResolution_hasMaxValue',\n",
       " 'paleoData_hasResolution_hasMeanValue',\n",
       " 'paleoData_hasResolution_hasMedianValue',\n",
       " 'paleoData_hasResolution_hasMinValue',\n",
       " 'paleoData_inCompilation',\n",
       " 'paleoData_interpretation',\n",
       " 'paleoData_meanValue12k',\n",
       " 'paleoData_medianRes12k',\n",
       " 'paleoData_missingValue',\n",
       " 'paleoData_number',\n",
       " 'paleoData_proxy',\n",
       " 'paleoData_proxyDetail',\n",
       " 'paleoData_proxyGeneral',\n",
       " 'paleoData_proxyLumps',\n",
       " 'paleoData_proxyOriginal',\n",
       " 'paleoData_tableName',\n",
       " 'paleoData_temp12kDkIndex',\n",
       " 'paleoData_units',\n",
       " 'paleoData_unitsOriginal',\n",
       " 'paleoData_useInGlobalTemperatureAnalysis',\n",
       " 'paleoData_values',\n",
       " 'paleoData_variableName',\n",
       " 'paleoData_variableNameOriginal',\n",
       " 'pub1_citation',\n",
       " 'pub1_doi',\n",
       " 'pub1_pubDataUrl',\n",
       " 'pub2_citation',\n",
       " 'pub2_doi',\n",
       " 'pub2_pubDataUrl',\n",
       " 'tableType',\n",
       " 'time_id']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_ts_temp12k = lipd.filterTs(all_series,'paleoData_inCompilation == Temp12k')\n",
    "filtered_ts_useinglobal = lipd.filterTs(filtered_ts_temp12k,'paleoData_useInGlobalTemperatureAnalysis == TRUE')\n",
    "temperatures = lipd.filterTs(filtered_ts_useinglobal,'paleoData_units == degC')\n",
    "sorted(temperatures[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<a id='meta_cols'></a>Transform the temperatures into pandas series. The `meta_cols` is the meta data that should be available as column in the data frame and has to match one of the keys in the previous list. The `meta_names` then specifies how the corresponding field from `meta_cols` appears in the final data frame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "meta_cols = ['geo_meanLon', 'geo_meanLat', 'dataSetName', 'paleoData_variableName']\n",
    "meta_names = ['lon', 'lat', 'dataSetName', 'variableName']\n",
    "\n",
    "series = [\n",
    "    pd.Series(\n",
    "        np.asarray(d['paleoData_values'], dtype=float),\n",
    "        index=np.asarray(d['age'], dtype=float),\n",
    "        name=tuple(d.get(name, np.nan) for name in meta_cols))\n",
    "    for d in temperatures if 'age' in d]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "and bin them based on centennial scales and merge them into one single dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def age_grouper(age):\n",
    "    \"\"\"Bin age to centuries\"\"\"\n",
    "    return age - (age % binwidth)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "binned = [s.groupby(age_grouper).mean() for s in series]\n",
    "\n",
    "merged = binned[0].to_frame()\n",
    "merged.columns.names = meta_names\n",
    "\n",
    "for s in binned[1:]:\n",
    "    merged = merged.merge(s.to_frame(), left_index=True, right_index=True,\n",
    "                          how='outer')\n",
    "    \n",
    "merged = merged.T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now save the results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "merged.to_csv('../data/binned-temperature-data.tsv', '\\t')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<a id='final'></a>That's it! If the notebook has finished, you can download the temperature data [here](../data/binned-temperature-data.tsv) and the corresponding meta data [here](../data/meta.tsv) as tab-separated files.\n",
    "\n",
    "So let's have a look into the final temperature data:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>-300.0</th>\n",
       "      <th>-200.0</th>\n",
       "      <th>-100.0</th>\n",
       "      <th>0.0</th>\n",
       "      <th>100.0</th>\n",
       "      <th>200.0</th>\n",
       "      <th>300.0</th>\n",
       "      <th>400.0</th>\n",
       "      <th>500.0</th>\n",
       "      <th>600.0</th>\n",
       "      <th>...</th>\n",
       "      <th>1237500.0</th>\n",
       "      <th>1240500.0</th>\n",
       "      <th>1241800.0</th>\n",
       "      <th>1243100.0</th>\n",
       "      <th>1261400.0</th>\n",
       "      <th>1263300.0</th>\n",
       "      <th>1264800.0</th>\n",
       "      <th>1266200.0</th>\n",
       "      <th>1267900.0</th>\n",
       "      <th>1277300.0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>dataSetName</th>\n",
       "      <th>variableName</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>-80.41</th>\n",
       "      <th>43.2400</th>\n",
       "      <th>Hams.Bennett.1987</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.015000</td>\n",
       "      <td>8.005000</td>\n",
       "      <td>7.798000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.595000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.849000</td>\n",
       "      <td>8.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146.5914</th>\n",
       "      <th>-42.6799</th>\n",
       "      <th>EagleTarn.Rees.2010</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.618000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.489000</td>\n",
       "      <td>8.589000</td>\n",
       "      <td>7.566500</td>\n",
       "      <td>7.509000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-38.5</th>\n",
       "      <th>72.6000</th>\n",
       "      <th>Alley.GISP2.2000</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-37.785174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33.1983</th>\n",
       "      <th>-1.2317</th>\n",
       "      <th>Victoria.Berke.2012</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37.38</th>\n",
       "      <th>-18.5650</th>\n",
       "      <th>GeoB9307_3</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.300000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.900000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141.8</th>\n",
       "      <th>36.0000</th>\n",
       "      <th>Composit_MD012421,KR0206</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.465000</td>\n",
       "      <td>17.236000</td>\n",
       "      <td>17.115000</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>17.330000</td>\n",
       "      <td>17.542000</td>\n",
       "      <td>17.978000</td>\n",
       "      <td>17.810000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-107.47</th>\n",
       "      <th>44.5500</th>\n",
       "      <th>FloatingIsland.Baker.1976</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.167000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.808000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-81.32</th>\n",
       "      <th>48.4000</th>\n",
       "      <th>LakeSix.Liu.1990</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.175000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.321000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.175000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34.4372</th>\n",
       "      <th>-11.2939</th>\n",
       "      <th>Malawi.Johnson.2016</th>\n",
       "      <th>temperatureCorrected</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.115000</td>\n",
       "      <td>21.910000</td>\n",
       "      <td>23.190000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>23.34</td>\n",
       "      <td>20.62</td>\n",
       "      <td>17.26</td>\n",
       "      <td>17.46</td>\n",
       "      <td>24.2</td>\n",
       "      <td>19.51</td>\n",
       "      <td>22.02</td>\n",
       "      <td>17.9</td>\n",
       "      <td>17.65</td>\n",
       "      <td>21.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-80.5056</th>\n",
       "      <th>25.7747</th>\n",
       "      <th>WCA3B_GumboLimboFarTail.Willard.2001</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.636000</td>\n",
       "      <td>23.425000</td>\n",
       "      <td>23.580000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.527000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-66.77</th>\n",
       "      <th>53.9000</th>\n",
       "      <th>Coghill.King.1986</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.504000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.635000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-70.6667</th>\n",
       "      <th>47.7167</th>\n",
       "      <th>LacduSommet.Hausmann.2011</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.355143</td>\n",
       "      <td>12.476333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.214000</td>\n",
       "      <td>12.325000</td>\n",
       "      <td>12.235000</td>\n",
       "      <td>12.562000</td>\n",
       "      <td>12.349500</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-120.22</th>\n",
       "      <th>73.5300</th>\n",
       "      <th>BanksIsland74MS15.Gajewski.2000</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-15.760000</td>\n",
       "      <td>-13.904000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-13.235000</td>\n",
       "      <td>-12.614000</td>\n",
       "      <td>-11.344500</td>\n",
       "      <td>-8.104000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.0277</th>\n",
       "      <th>-25.5137</th>\n",
       "      <th>ODP1084B</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.100000</td>\n",
       "      <td>13.900000</td>\n",
       "      <td>13.800000</td>\n",
       "      <td>13.100000</td>\n",
       "      <td>13.200000</td>\n",
       "      <td>12.750000</td>\n",
       "      <td>14.400000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119.36</th>\n",
       "      <th>-3.6298</th>\n",
       "      <th>GiK18515_3</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.050000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.660000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28.17</th>\n",
       "      <th>71.0400</th>\n",
       "      <th>gunnarsfjorden.Allen.2007</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.125000</td>\n",
       "      <td>2.275000</td>\n",
       "      <td>2.366667</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.825000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>2.125000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-141.97</th>\n",
       "      <th>60.0300</th>\n",
       "      <th>MundayCreek.Peteet.1986</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.011000</td>\n",
       "      <td>5.036000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.508000</td>\n",
       "      <td>3.476000</td>\n",
       "      <td>4.388000</td>\n",
       "      <td>5.480000</td>\n",
       "      <td>4.508000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18.07_x</th>\n",
       "      <th>67.3700</th>\n",
       "      <th>sjuuodjijaure.Rosen.2001</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.966500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.008000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.044000</td>\n",
       "      <td>10.496000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18.07_y</th>\n",
       "      <th>67.3700</th>\n",
       "      <th>sjuuodjijaure.Rosen.2001</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.745000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.777000</td>\n",
       "      <td>10.581000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.452000</td>\n",
       "      <td>10.612000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18.07</th>\n",
       "      <th>67.3700</th>\n",
       "      <th>sjuuodjijaure.Rosen.2001</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.721500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.776000</td>\n",
       "      <td>9.831000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.836000</td>\n",
       "      <td>9.472000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25.0</th>\n",
       "      <th>69.0000</th>\n",
       "      <th>lapland.Helama.2010</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.248364</td>\n",
       "      <td>13.111300</td>\n",
       "      <td>12.537100</td>\n",
       "      <td>12.882700</td>\n",
       "      <td>12.621800</td>\n",
       "      <td>12.893100</td>\n",
       "      <td>13.117800</td>\n",
       "      <td>13.048100</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-84.32</th>\n",
       "      <th>45.6000</th>\n",
       "      <th>LakeSixteen.Futyma.1986</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9.87</th>\n",
       "      <th>46.4800</th>\n",
       "      <th>Stazersee.Heiri.2015</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80.62</th>\n",
       "      <th>55.3900</th>\n",
       "      <th>LakeBolshieToroki.Pollen.Russia</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.708000</td>\n",
       "      <td>17.917000</td>\n",
       "      <td>17.378000</td>\n",
       "      <td>17.587000</td>\n",
       "      <td>17.238000</td>\n",
       "      <td>17.757000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.853000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-79.48</th>\n",
       "      <th>43.6400</th>\n",
       "      <th>HumberPond3.McAndrews.1989</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.594750</td>\n",
       "      <td>7.374000</td>\n",
       "      <td>7.004714</td>\n",
       "      <td>6.446000</td>\n",
       "      <td>7.223000</td>\n",
       "      <td>6.702000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.401000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-2.71</th>\n",
       "      <th>54.9200</th>\n",
       "      <th>TalkinTarn.Langdon.2004</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.584000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.959000</td>\n",
       "      <td>14.029000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.789000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9.4</th>\n",
       "      <th>2.5000</th>\n",
       "      <th>GeoB4905.Weldeab.2005</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.050000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.400000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-122.49</th>\n",
       "      <th>45.8000</th>\n",
       "      <th>BattleGround.Whitlock.1985</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.330000</td>\n",
       "      <td>7.003000</td>\n",
       "      <td>7.344750</td>\n",
       "      <td>7.475500</td>\n",
       "      <td>7.471500</td>\n",
       "      <td>7.174000</td>\n",
       "      <td>6.535000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-58.04</th>\n",
       "      <th>-53.0100</th>\n",
       "      <th>JR244_GC528</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57.609</th>\n",
       "      <th>18.0518</th>\n",
       "      <th>117_723A</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.306000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-155.03</th>\n",
       "      <th>67.6800</th>\n",
       "      <th>Redondo.Brubaker.1983</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-3.380000</td>\n",
       "      <td>-4.952000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.961000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-6.475000</td>\n",
       "      <td>-4.905000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-109.95</th>\n",
       "      <th>43.4400</th>\n",
       "      <th>ForestPond2.Lynch.1998</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.970000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.960000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.887000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-79.51</th>\n",
       "      <th>44.2000</th>\n",
       "      <th>MaraisdeKeswick.Larouche.1986</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.755000</td>\n",
       "      <td>1.382000</td>\n",
       "      <td>-1.510000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.226000</td>\n",
       "      <td>5.175000</td>\n",
       "      <td>5.185000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120.917</th>\n",
       "      <th>-9.5948</th>\n",
       "      <th>GeoB10069_3</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.774000</td>\n",
       "      <td>26.421000</td>\n",
       "      <td>26.774000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100.137</th>\n",
       "      <th>36.8112</th>\n",
       "      <th>LakeQinghai.Hou.2016</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>17.390000</td>\n",
       "      <td>17.680000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.160000</td>\n",
       "      <td>14.870000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-71.65</th>\n",
       "      <th>57.6500</th>\n",
       "      <th>Nedlouc.Larouche.1981</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-6.213000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.599000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14.87</th>\n",
       "      <th>68.5200</th>\n",
       "      <th>liltlvatn.Seppa.2009</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.118000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.335000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.899000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.829000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-88.1</th>\n",
       "      <th>43.4000</th>\n",
       "      <th>Radtke.Webb.1983</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.271750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.287000</td>\n",
       "      <td>8.513500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.183000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99.72</th>\n",
       "      <th>26.6300</th>\n",
       "      <th>TiancaiLake.Zhang.2017</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.646000</td>\n",
       "      <td>7.414500</td>\n",
       "      <td>8.377000</td>\n",
       "      <td>7.984000</td>\n",
       "      <td>8.054000</td>\n",
       "      <td>7.529000</td>\n",
       "      <td>7.843000</td>\n",
       "      <td>7.259000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-62.15</th>\n",
       "      <th>46.4100</th>\n",
       "      <th>EastBalticBog.Anderson.1980</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9.364000</td>\n",
       "      <td>-8.877000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.970000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.237000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.8972</th>\n",
       "      <th>42.9888</th>\n",
       "      <th>LagoDellAccesa.Finsinger.2010</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96.3167</th>\n",
       "      <th>3.5167</th>\n",
       "      <th>SO189-119KL.Mohtadi.2014</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.210000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.240000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.140000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-75.25</th>\n",
       "      <th>58.5800</th>\n",
       "      <th>LR01.Gajewski.1993</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.067000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.033000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97.4833</th>\n",
       "      <th>-74.0830</th>\n",
       "      <th>Komosomolskaia.Ciais.1992</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.507867</td>\n",
       "      <td>-0.027273</td>\n",
       "      <td>0.098600</td>\n",
       "      <td>-0.521111</td>\n",
       "      <td>-0.201125</td>\n",
       "      <td>0.095333</td>\n",
       "      <td>0.813750</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-64.68</th>\n",
       "      <th>56.6700</th>\n",
       "      <th>LacPatricia.McAndrews.1983</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.062000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.045000</td>\n",
       "      <td>-1.062000</td>\n",
       "      <td>0.230000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.230000</td>\n",
       "      <td>0.573000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-105.54</th>\n",
       "      <th>40.0800</th>\n",
       "      <th>Redrock.Maher.1972</th>\n",
       "      <th>temperature</th>\n",
       "      <td>2.295</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.665000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.173000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.102000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.739000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-74.3</th>\n",
       "      <th>-41.0000</th>\n",
       "      <th>GeoB33131.Lamy.2002</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.670000</td>\n",
       "      <td>14.910000</td>\n",
       "      <td>14.620000</td>\n",
       "      <td>14.810000</td>\n",
       "      <td>14.960000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7.091</th>\n",
       "      <th>57.6600</th>\n",
       "      <th>IOW225517.Elmis.2003</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121.28</th>\n",
       "      <th>8.7800</th>\n",
       "      <th>MD972141</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-112.08</th>\n",
       "      <th>-79.4676</th>\n",
       "      <th>WAISDivide.Cuffey.2016</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.976212</td>\n",
       "      <td>-30.213310</td>\n",
       "      <td>-30.437298</td>\n",
       "      <td>-30.240966</td>\n",
       "      <td>-30.218586</td>\n",
       "      <td>-30.294190</td>\n",
       "      <td>-30.332632</td>\n",
       "      <td>-30.350534</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-50.0267</th>\n",
       "      <th>69.2417</th>\n",
       "      <th>north.Axford.2013</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.171833</td>\n",
       "      <td>-1.045000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.290000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.449000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-67.5</th>\n",
       "      <th>54.8000</th>\n",
       "      <th>LacHamard.Stravers.1981</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5.942000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-6.167000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-79.51</th>\n",
       "      <th>45.3800</th>\n",
       "      <th>Axe.McAndrews.No</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.783000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.117000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.655000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-70.68</th>\n",
       "      <th>45.5700</th>\n",
       "      <th>BoundaryPond.Mott.1977</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.198500</td>\n",
       "      <td>3.513000</td>\n",
       "      <td>3.711000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.906000</td>\n",
       "      <td>4.050000</td>\n",
       "      <td>3.892000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-109.19</th>\n",
       "      <th>42.7300</th>\n",
       "      <th>Rapid.Fall.1994</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.857000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.856000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-93.63</th>\n",
       "      <th>45.0400</th>\n",
       "      <th>PogoniaBog.Cushing.1979</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.100000</td>\n",
       "      <td>7.046667</td>\n",
       "      <td>7.117333</td>\n",
       "      <td>7.047000</td>\n",
       "      <td>7.009500</td>\n",
       "      <td>6.961500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.599000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17.338</th>\n",
       "      <th>-34.7100</th>\n",
       "      <th>MD02_2594</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.716000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.173000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127.07</th>\n",
       "      <th>71.8700</th>\n",
       "      <th>Dolgoe.Wolfe.2000</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.191000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.197000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.998000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39.8408</th>\n",
       "      <th>-7.1383</th>\n",
       "      <th>GeoB12615_4</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-81.1247</th>\n",
       "      <th>-3.7498</th>\n",
       "      <th>M77_2_056_5</th>\n",
       "      <th>temperature</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>504 rows × 2724 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                         -300.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                         -200.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                         -100.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature        8.015   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature        7.100   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          0.0        \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature     8.005000   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature     9.618000   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature   -37.785174   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature     7.046667   \n",
       " 17.3380  -34.7100 MD02_2594               temperature    15.716000   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature    15.191000   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          100.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature     7.798000   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature     7.117333   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          200.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature       25.300   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature        7.047   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature       15.197   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          300.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature       8.5950   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature      10.4890   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature       7.0095   \n",
       " 17.3380  -34.7100 MD02_2594               temperature      15.1730   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          400.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature       8.5890   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature       6.9615   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          500.0      \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature       8.8490   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature       7.5665   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          600.0      ...  \\\n",
       "lon       lat      dataSetName             variableName              ...   \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature        8.500  ...   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature        7.509  ...   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN  ...   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN  ...   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature       25.900  ...   \n",
       "...                                                             ...  ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature        7.599  ...   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN  ...   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature       14.998  ...   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN  ...   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN  ...   \n",
       "\n",
       "                                                          1237500.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1240500.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1241800.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1243100.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1261400.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1263300.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1264800.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1266200.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1267900.0  \\\n",
       "lon       lat      dataSetName             variableName               \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN   \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN   \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN   \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN   \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN   \n",
       "...                                                             ...   \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN   \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN   \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN   \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN   \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN   \n",
       "\n",
       "                                                          1277300.0  \n",
       "lon       lat      dataSetName             variableName              \n",
       "-80.4100   43.2400 Hams.Bennett.1987       temperature          NaN  \n",
       " 146.5914 -42.6799 EagleTarn.Rees.2010     temperature          NaN  \n",
       "-38.5000   72.6000 Alley.GISP2.2000        temperature          NaN  \n",
       " 33.1983  -1.2317  Victoria.Berke.2012     temperature          NaN  \n",
       " 37.3800  -18.5650 GeoB9307_3              temperature          NaN  \n",
       "...                                                             ...  \n",
       "-93.6300   45.0400 PogoniaBog.Cushing.1979 temperature          NaN  \n",
       " 17.3380  -34.7100 MD02_2594               temperature          NaN  \n",
       " 127.0700  71.8700 Dolgoe.Wolfe.2000       temperature          NaN  \n",
       " 39.8408  -7.1383  GeoB12615_4             temperature          NaN  \n",
       "-81.1247  -3.7498  M77_2_056_5             temperature          NaN  \n",
       "\n",
       "[504 rows x 2724 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>-300.0</th>\n",
       "      <th>-200.0</th>\n",
       "      <th>-100.0</th>\n",
       "      <th>0.0</th>\n",
       "      <th>100.0</th>\n",
       "      <th>200.0</th>\n",
       "      <th>300.0</th>\n",
       "      <th>400.0</th>\n",
       "      <th>500.0</th>\n",
       "      <th>600.0</th>\n",
       "      <th>...</th>\n",
       "      <th>1237500.0</th>\n",
       "      <th>1240500.0</th>\n",
       "      <th>1241800.0</th>\n",
       "      <th>1243100.0</th>\n",
       "      <th>1261400.0</th>\n",
       "      <th>1263300.0</th>\n",
       "      <th>1264800.0</th>\n",
       "      <th>1266200.0</th>\n",
       "      <th>1267900.0</th>\n",
       "      <th>1277300.0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>dataSetName</th>\n",
       "      <th>variableName</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>-120.82</th>\n",
       "      <th>49.54</th>\n",
       "      <th>BCTempComp.Gavin.2013</th>\n",
       "      <th>temperature</th>\n",
       "      <td>-0.6715</td>\n",
       "      <td>-0.5005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.126667</td>\n",
       "      <td>-0.414</td>\n",
       "      <td>0.6675</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.3125</td>\n",
       "      <td>-0.4055</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-105.54</th>\n",
       "      <th>40.08</th>\n",
       "      <th>Redrock.Maher.1972</th>\n",
       "      <th>temperature</th>\n",
       "      <td>2.2950</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.173</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.1020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.739</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 2724 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  -300.0      -200.0      \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature      -0.6715     -0.5005   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature       2.2950         NaN   \n",
       "\n",
       "                                                  -100.0       0.0        \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN   -1.126667   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature        1.665         NaN   \n",
       "\n",
       "                                                   100.0       200.0      \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature       -0.414      0.6675   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature        2.173         NaN   \n",
       "\n",
       "                                                   300.0       400.0      \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature         0.28      0.3125   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN      2.1020   \n",
       "\n",
       "                                                   500.0       600.0      ...  \\\n",
       "lon     lat   dataSetName           variableName                          ...   \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature      -0.4055         NaN  ...   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN       2.739  ...   \n",
       "\n",
       "                                                   1237500.0   1240500.0  \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN         NaN   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN         NaN   \n",
       "\n",
       "                                                   1241800.0   1243100.0  \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN         NaN   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN         NaN   \n",
       "\n",
       "                                                   1261400.0   1263300.0  \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN         NaN   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN         NaN   \n",
       "\n",
       "                                                   1264800.0   1266200.0  \\\n",
       "lon     lat   dataSetName           variableName                           \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN         NaN   \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN         NaN   \n",
       "\n",
       "                                                   1267900.0   1277300.0  \n",
       "lon     lat   dataSetName           variableName                          \n",
       "-120.82 49.54 BCTempComp.Gavin.2013 temperature          NaN         NaN  \n",
       "-105.54 40.08 Redrock.Maher.1972    temperature          NaN         NaN  \n",
       "\n",
       "[2 rows x 2724 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.loc[merged.iloc[:, 0].notnull()]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "python3",
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}