{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "#Import the icepython library\n", "#Make sure to read our quick start guide! Additional support can be reached by contacting DesktopClientSupport@theice.com\n", "import icepython as ice" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1 2 3\n", "0 2M Hourly Temp Accum Precip hourly Interpolated GWDD\n", "1 KORD-METR 12.2 0 13.1753\n", "2 KATL-METR 24.4 0 3.658\n", "3 KNYC-METR 18.9 0.254 12.6775\n" ] } ], "source": [ "#Quotes- Latest METAR values for observations\n", "import pandas as pd\n", "data = ice.get_quotes(['KORD-METR','KATL-METR','KNYC-METR'],['2M Hourly Temp','Accum Precip hourly Interpolated','GWDD'])\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1\n", "0 2M Hourly Temp\n", "1 KORD FDH0!-GFS 4.87\n", "2 KORD FDH1!-GFS 6.52\n", "3 KORD FDH2!-GFS 8.31\n", "4 KORD FDH3!-GFS 9.82\n", "5 KORD FDH4!-GFS 10.78\n", "6 KORD FDH5!-GFS 11.62\n", "7 KORD FDH6!-GFS 12.16\n", "8 KORD FDH7!-GFS 12.12\n", "9 KORD FDH8!-GFS 11.98\n", "10 KORD FDH9!-GFS 11.37\n", "11 KORD FDH10!-GFS 10.26\n", "12 KORD FDH11!-GFS 9.69\n", "13 KORD FDH12!-GFS 8.96\n", "14 KORD FDH13!-GFS 7.87\n", "15 KORD FDH14!-GFS 7.04\n", "16 KORD FDH15!-GFS 6.58\n", "17 KORD FDH16!-GFS 6.19\n", "18 KORD FDH17!-GFS 5.93\n", "19 KORD FDH18!-GFS 5.65\n", "20 KORD FDH19!-GFS 5.37\n", "21 KORD FDH20!-GFS 5.09\n", "22 KORD FDH21!-GFS 4.7\n", "23 KORD FDH22!-GFS 4.43\n", "24 KORD FDH23!-GFS 4.44\n", "25 KORD FDH24!-GFS 5.96\n", "26 KORD FDH25!-GFS 7.99\n", "27 KORD FDH26!-GFS 10.04\n", "28 KORD FDH27!-GFS 11.93\n", "29 KORD FDH28!-GFS 13.53\n", ".. ... ...\n", "272 KORD FDH271!-GFS 21.11\n", "273 KORD FDH272!-GFS 21.48\n", "274 KORD FDH273!-GFS 21.84\n", "275 KORD FDH274!-GFS 21.04\n", "276 KORD FDH275!-GFS 20.25\n", "277 KORD FDH276!-GFS 19.45\n", "278 KORD FDH277!-GFS 18.23\n", "279 KORD FDH278!-GFS 17.02\n", "280 KORD FDH279!-GFS 15.8\n", "281 KORD FDH280!-GFS 15.26\n", "282 KORD FDH281!-GFS 14.73\n", "283 KORD FDH282!-GFS 14.19\n", "284 KORD FDH283!-GFS 13.7\n", "285 KORD FDH284!-GFS 13.22\n", "286 KORD FDH285!-GFS 12.73\n", "287 KORD FDH286!-GFS 13.11\n", "288 KORD FDH287!-GFS 13.48\n", "289 KORD FDH288!-GFS 13.86\n", "290 KORD FDH289!-GFS 16.06\n", "291 KORD FDH290!-GFS 18.26\n", "292 KORD FDH291!-GFS 20.46\n", "293 KORD FDH292!-GFS 21.79\n", "294 KORD FDH293!-GFS 23.12\n", "295 KORD FDH294!-GFS 24.45\n", "296 KORD FDH295!-GFS 24.7\n", "297 KORD FDH296!-GFS 24.95\n", "298 KORD FDH297!-GFS 25.2\n", "299 KORD FDH298!-GFS 24.37\n", "300 KORD FDH299!-GFS 23.54\n", "301 KORD FDH300!-GFS 22.71\n", "\n", "[302 rows x 2 columns]\n" ] } ], "source": [ "#Quotes - Latest model run data - Hourly values for current model run of GFS\n", "import pandas as pd\n", "data = ice.get_quotes(['KORD FDH0!-GFS','KORD FDH1!-GFS','KORD FDH2!-GFS','KORD FDH3!-GFS','KORD FDH4!-GFS','KORD FDH5!-GFS','KORD FDH6!-GFS','KORD FDH7!-GFS','KORD FDH8!-GFS','KORD FDH9!-GFS','KORD FDH10!-GFS','KORD FDH11!-GFS','KORD FDH12!-GFS','KORD FDH13!-GFS','KORD FDH14!-GFS','KORD FDH15!-GFS','KORD FDH16!-GFS','KORD FDH17!-GFS','KORD FDH18!-GFS','KORD FDH19!-GFS','KORD FDH20!-GFS','KORD FDH21!-GFS','KORD FDH22!-GFS','KORD FDH23!-GFS','KORD FDH24!-GFS','KORD FDH25!-GFS','KORD FDH26!-GFS','KORD FDH27!-GFS','KORD FDH28!-GFS','KORD FDH29!-GFS','KORD FDH30!-GFS','KORD FDH31!-GFS','KORD FDH32!-GFS','KORD FDH33!-GFS','KORD FDH34!-GFS','KORD FDH35!-GFS','KORD FDH36!-GFS','KORD FDH37!-GFS','KORD FDH38!-GFS','KORD FDH39!-GFS','KORD FDH40!-GFS','KORD FDH41!-GFS','KORD FDH42!-GFS','KORD FDH43!-GFS','KORD FDH44!-GFS','KORD FDH45!-GFS','KORD FDH46!-GFS','KORD FDH47!-GFS','KORD FDH48!-GFS','KORD FDH49!-GFS','KORD FDH50!-GFS','KORD FDH51!-GFS','KORD FDH52!-GFS','KORD FDH53!-GFS','KORD FDH54!-GFS','KORD FDH55!-GFS','KORD FDH56!-GFS','KORD FDH57!-GFS','KORD FDH58!-GFS','KORD FDH59!-GFS','KORD FDH60!-GFS','KORD FDH61!-GFS','KORD FDH62!-GFS','KORD FDH63!-GFS','KORD FDH64!-GFS','KORD FDH65!-GFS','KORD FDH66!-GFS','KORD FDH67!-GFS','KORD FDH68!-GFS','KORD FDH69!-GFS','KORD FDH70!-GFS','KORD FDH71!-GFS','KORD FDH72!-GFS','KORD FDH73!-GFS','KORD FDH74!-GFS','KORD FDH75!-GFS','KORD FDH76!-GFS','KORD FDH77!-GFS','KORD FDH78!-GFS','KORD FDH79!-GFS','KORD FDH80!-GFS','KORD FDH81!-GFS','KORD FDH82!-GFS','KORD FDH83!-GFS','KORD FDH84!-GFS','KORD FDH85!-GFS','KORD FDH86!-GFS','KORD FDH87!-GFS','KORD FDH88!-GFS','KORD FDH89!-GFS','KORD FDH90!-GFS','KORD FDH91!-GFS','KORD FDH92!-GFS','KORD FDH93!-GFS','KORD FDH94!-GFS','KORD FDH95!-GFS','KORD FDH96!-GFS','KORD FDH97!-GFS','KORD FDH98!-GFS','KORD FDH99!-GFS','KORD FDH100!-GFS','KORD FDH101!-GFS','KORD FDH102!-GFS','KORD FDH103!-GFS','KORD FDH104!-GFS','KORD FDH105!-GFS','KORD FDH106!-GFS','KORD FDH107!-GFS','KORD FDH108!-GFS','KORD FDH109!-GFS','KORD FDH110!-GFS','KORD FDH111!-GFS','KORD FDH112!-GFS','KORD FDH113!-GFS','KORD FDH114!-GFS','KORD FDH115!-GFS','KORD FDH116!-GFS','KORD FDH117!-GFS','KORD FDH118!-GFS','KORD FDH119!-GFS','KORD FDH120!-GFS','KORD FDH121!-GFS','KORD FDH122!-GFS','KORD FDH123!-GFS','KORD FDH124!-GFS','KORD FDH125!-GFS','KORD FDH126!-GFS','KORD FDH127!-GFS','KORD FDH128!-GFS','KORD FDH129!-GFS','KORD FDH130!-GFS','KORD FDH131!-GFS','KORD FDH132!-GFS','KORD FDH133!-GFS','KORD FDH134!-GFS','KORD FDH135!-GFS','KORD FDH136!-GFS','KORD FDH137!-GFS','KORD FDH138!-GFS','KORD FDH139!-GFS','KORD FDH140!-GFS','KORD FDH141!-GFS','KORD FDH142!-GFS','KORD FDH143!-GFS','KORD FDH144!-GFS','KORD FDH145!-GFS','KORD FDH146!-GFS','KORD FDH147!-GFS','KORD FDH148!-GFS','KORD FDH149!-GFS','KORD FDH150!-GFS','KORD FDH151!-GFS','KORD FDH152!-GFS','KORD FDH153!-GFS','KORD FDH154!-GFS','KORD FDH155!-GFS','KORD FDH156!-GFS','KORD FDH157!-GFS','KORD FDH158!-GFS','KORD FDH159!-GFS','KORD FDH160!-GFS','KORD FDH161!-GFS','KORD FDH162!-GFS','KORD FDH163!-GFS','KORD FDH164!-GFS','KORD FDH165!-GFS','KORD FDH166!-GFS','KORD FDH167!-GFS','KORD FDH168!-GFS','KORD FDH169!-GFS','KORD FDH170!-GFS','KORD FDH171!-GFS','KORD FDH172!-GFS','KORD FDH173!-GFS','KORD FDH174!-GFS','KORD FDH175!-GFS','KORD FDH176!-GFS','KORD FDH177!-GFS','KORD FDH178!-GFS','KORD FDH179!-GFS','KORD FDH180!-GFS','KORD FDH181!-GFS','KORD FDH182!-GFS','KORD FDH183!-GFS','KORD FDH184!-GFS','KORD FDH185!-GFS','KORD FDH186!-GFS','KORD FDH187!-GFS','KORD FDH188!-GFS','KORD FDH189!-GFS','KORD FDH190!-GFS','KORD FDH191!-GFS','KORD FDH192!-GFS','KORD FDH193!-GFS','KORD FDH194!-GFS','KORD FDH195!-GFS','KORD FDH196!-GFS','KORD FDH197!-GFS','KORD FDH198!-GFS','KORD FDH199!-GFS','KORD FDH200!-GFS','KORD FDH201!-GFS','KORD FDH202!-GFS','KORD FDH203!-GFS','KORD FDH204!-GFS','KORD FDH205!-GFS','KORD FDH206!-GFS','KORD FDH207!-GFS','KORD FDH208!-GFS','KORD FDH209!-GFS','KORD FDH210!-GFS','KORD FDH211!-GFS','KORD FDH212!-GFS','KORD FDH213!-GFS','KORD FDH214!-GFS','KORD FDH215!-GFS','KORD FDH216!-GFS','KORD FDH217!-GFS','KORD FDH218!-GFS','KORD FDH219!-GFS','KORD FDH220!-GFS','KORD FDH221!-GFS','KORD FDH222!-GFS','KORD FDH223!-GFS','KORD FDH224!-GFS','KORD FDH225!-GFS','KORD FDH226!-GFS','KORD FDH227!-GFS','KORD FDH228!-GFS','KORD FDH229!-GFS','KORD FDH230!-GFS','KORD FDH231!-GFS','KORD FDH232!-GFS','KORD FDH233!-GFS','KORD FDH234!-GFS','KORD FDH235!-GFS','KORD FDH236!-GFS','KORD FDH237!-GFS','KORD FDH238!-GFS','KORD FDH239!-GFS','KORD FDH240!-GFS','KORD FDH241!-GFS','KORD FDH242!-GFS','KORD FDH243!-GFS','KORD FDH244!-GFS','KORD FDH245!-GFS','KORD FDH246!-GFS','KORD FDH247!-GFS','KORD FDH248!-GFS','KORD FDH249!-GFS','KORD FDH250!-GFS','KORD FDH251!-GFS','KORD FDH252!-GFS','KORD FDH253!-GFS','KORD FDH254!-GFS','KORD FDH255!-GFS','KORD FDH256!-GFS','KORD FDH257!-GFS','KORD FDH258!-GFS','KORD FDH259!-GFS','KORD FDH260!-GFS','KORD FDH261!-GFS','KORD FDH262!-GFS','KORD FDH263!-GFS','KORD FDH264!-GFS','KORD FDH265!-GFS','KORD FDH266!-GFS','KORD FDH267!-GFS','KORD FDH268!-GFS','KORD FDH269!-GFS','KORD FDH270!-GFS','KORD FDH271!-GFS','KORD FDH272!-GFS','KORD FDH273!-GFS','KORD FDH274!-GFS','KORD FDH275!-GFS','KORD FDH276!-GFS','KORD FDH277!-GFS','KORD FDH278!-GFS','KORD FDH279!-GFS','KORD FDH280!-GFS','KORD FDH281!-GFS','KORD FDH282!-GFS','KORD FDH283!-GFS','KORD FDH284!-GFS','KORD FDH285!-GFS','KORD FDH286!-GFS','KORD FDH287!-GFS','KORD FDH288!-GFS','KORD FDH289!-GFS','KORD FDH290!-GFS','KORD FDH291!-GFS','KORD FDH292!-GFS','KORD FDH293!-GFS','KORD FDH294!-GFS','KORD FDH295!-GFS','KORD FDH296!-GFS','KORD FDH297!-GFS','KORD FDH298!-GFS','KORD FDH299!-GFS','KORD FDH300!-GFS'],['2M Hourly Temp'])\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1 2\n", "0 2M Daily Avg Temp GWDD\n", "1 KORD FDD1!-GFS 8.64 10.992\n", "2 KORD FDD2!-GFS 10.06 9.657\n", "3 KORD FDD3!-GFS 12.12 8.093\n", "4 KORD FDD4!-GFS 13.73 5.677\n", "5 KORD FDD5!-GFS 13.95 4.333\n", "6 KORD FDD6!-GFS 12.92 3.168\n", "7 KORD FDD7!-GFS 16.58 2.323\n", "8 KORD FDD8!-GFS 12.34 5.302\n", "9 KORD FDD9!-GFS 12.79 6.883\n", "10 KORD FDD10!-GFS 15.66 5.283\n", "11 KORD FDD11!-GFS 14.6 3.492\n", "12 KORD FDD12!-GFS 15.4 5.187\n", "13 KORD FDD13!-GFS 18.83 1.447\n", "14 KORD FDD14!-GFS 19.8 0.861\n", "15 KORD FDD15!-GFS 21.46 2.032\n", "16 KORD FDD16!-GFS 22.53 1.435\n" ] } ], "source": [ "#Quotes - Latest model run - Daily Values for current model run of GFS\n", "import pandas as pd\n", "data = ice.get_quotes(['KORD FDD1!-GFS','KORD FDD2!-GFS','KORD FDD3!-GFS','KORD FDD4!-GFS','KORD FDD5!-GFS','KORD FDD6!-GFS','KORD FDD7!-GFS','KORD FDD8!-GFS','KORD FDD9!-GFS','KORD FDD10!-GFS','KORD FDD11!-GFS','KORD FDD12!-GFS','KORD FDD13!-GFS','KORD FDD14!-GFS','KORD FDD15!-GFS','KORD FDD16!-GFS'],['2M Daily Avg Temp','GWDD'])\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1\n", "0 Time KSFO MR0!-ECM.2M DAILY AVG TEMP\n", "1 2021-05-11 15\n", "2 2021-05-12 15.2\n", "3 2021-05-13 13.44\n", "4 2021-05-14 11.42\n", "5 2021-05-15 12.65\n", "6 2021-05-16 13.42\n", "7 2021-05-17 12.05\n", "8 2021-05-18 11.74\n", "9 2021-05-19 12.77\n", "10 2021-05-20 12.49\n" ] } ], "source": [ "#Time Series - Daily values for Model run in a Time Series - Euro Model\n", "import pandas as pd\n", "data = ice.get_timeseries(['KSFO MR0!-ECM'],['2M Daily Avg Temp'],'D','2021-05-10','2021-05-20')\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1 \\\n", "0 Time KSFO MR0!-ECE.DEFAULT \n", "1 2021-05-11T07:00:00 11.88 \n", "2 2021-05-11T08:00:00 10.7 \n", "3 2021-05-11T09:00:00 10.86 \n", "4 2021-05-11T10:00:00 11.52 \n", "5 2021-05-11T11:00:00 12.28 \n", "6 2021-05-11T12:00:00 12.96 \n", "7 2021-05-11T13:00:00 13.64 \n", "8 2021-05-11T14:00:00 14.19 \n", "9 2021-05-11T15:00:00 14.42 \n", "10 2021-05-11T16:00:00 14.39 \n", "11 2021-05-11T17:00:00 14.18 \n", "12 2021-05-11T18:00:00 14.04 \n", "13 2021-05-11T19:00:00 13.89 \n", "14 2021-05-11T20:00:00 13.53 \n", "15 2021-05-11T21:00:00 13.03 \n", "16 2021-05-11T22:00:00 12.35 \n", "17 2021-05-11T23:00:00 11.94 \n", "18 2021-05-12T00:00:00 11.74 \n", "19 2021-05-12T01:00:00 11.65 \n", "20 2021-05-12T02:00:00 11.56 \n", "21 2021-05-12T03:00:00 11.43 \n", "22 2021-05-12T04:00:00 11.36 \n", "23 2021-05-12T05:00:00 11.27 \n", "24 2021-05-12T06:00:00 11.26 \n", "25 2021-05-12T07:00:00 11.19 \n", "26 2021-05-12T08:00:00 11.01 \n", "27 2021-05-12T09:00:00 11.22 \n", "28 2021-05-12T10:00:00 11.88 \n", "29 2021-05-12T11:00:00 12.69 \n", ".. ... ... \n", "181 2021-05-18T19:00:00 13.55 \n", "182 2021-05-18T20:00:00 13.2 \n", "183 2021-05-18T21:00:00 12.84 \n", "184 2021-05-18T22:00:00 12.49 \n", "185 2021-05-18T23:00:00 12.13 \n", "186 2021-05-19T00:00:00 11.78 \n", "187 2021-05-19T01:00:00 11.42 \n", "188 2021-05-19T02:00:00 11.32 \n", "189 2021-05-19T03:00:00 11.21 \n", "190 2021-05-19T04:00:00 11.1 \n", "191 2021-05-19T05:00:00 10.99 \n", "192 2021-05-19T06:00:00 10.89 \n", "193 2021-05-19T07:00:00 10.78 \n", "194 2021-05-19T08:00:00 11.28 \n", "195 2021-05-19T09:00:00 11.78 \n", "196 2021-05-19T10:00:00 12.28 \n", "197 2021-05-19T11:00:00 12.78 \n", "198 2021-05-19T12:00:00 13.28 \n", "199 2021-05-19T13:00:00 13.78 \n", "200 2021-05-19T14:00:00 13.88 \n", "201 2021-05-19T15:00:00 13.96 \n", "202 2021-05-19T16:00:00 14.06 \n", "203 2021-05-19T17:00:00 14.15 \n", "204 2021-05-19T18:00:00 14.24 \n", "205 2021-05-19T19:00:00 14.33 \n", "206 2021-05-19T20:00:00 13.89 \n", "207 2021-05-19T21:00:00 13.45 \n", "208 2021-05-19T22:00:00 13.01 \n", "209 2021-05-19T23:00:00 12.57 \n", "210 2021-05-20T00:00:00 12.13 \n", "\n", " 2 \n", "0 KSFO MR0!-ECE.2M HOURLY TEMP AVERAGE \n", "1 11.88 \n", "2 10.7 \n", "3 10.86 \n", "4 11.52 \n", "5 12.28 \n", "6 12.96 \n", "7 13.64 \n", "8 14.19 \n", "9 14.42 \n", "10 14.39 \n", "11 14.18 \n", "12 14.04 \n", "13 13.89 \n", "14 13.53 \n", "15 13.03 \n", "16 12.35 \n", "17 11.94 \n", "18 11.74 \n", "19 11.65 \n", "20 11.56 \n", "21 11.43 \n", "22 11.36 \n", "23 11.27 \n", "24 11.26 \n", "25 11.19 \n", "26 11.01 \n", "27 11.22 \n", "28 11.88 \n", "29 12.69 \n", ".. ... \n", "181 13.55 \n", "182 13.2 \n", "183 12.84 \n", "184 12.49 \n", "185 12.13 \n", "186 11.78 \n", "187 11.42 \n", "188 11.32 \n", "189 11.21 \n", "190 11.1 \n", "191 10.99 \n", "192 10.89 \n", "193 10.78 \n", "194 11.28 \n", "195 11.78 \n", "196 12.28 \n", "197 12.78 \n", "198 13.28 \n", "199 13.78 \n", "200 13.88 \n", "201 13.96 \n", "202 14.06 \n", "203 14.15 \n", "204 14.24 \n", "205 14.33 \n", "206 13.89 \n", "207 13.45 \n", "208 13.01 \n", "209 12.57 \n", "210 12.13 \n", "\n", "[211 rows x 3 columns]\n" ] } ], "source": [ "#Time Series - Hourly values for Model run in a Time Series - Euro Ensemble Model\n", "import pandas as pd\n", "data = ice.get_timeseries(['KSFO MR0!-ECE'],['Default','2M Hourly Temp Average'],'i60','2021-05-10','2021-05-20')\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1\n", "0 Time KBOS-CFSR.2M HOURLY TEMP AVERAGE\n", "1 1990-01-01 0.9363\n", "2 1990-01-02 -1.4279\n", "3 1990-01-03 0.3583\n", "4 1990-01-04 3.6417\n", "5 1990-01-05 2.3508\n", "6 1990-01-06 0.1787\n", "7 1990-01-07 -0.4654\n", "8 1990-01-08 1.5292\n", "9 1990-01-09 1.6871\n", "10 1990-01-10 3.2521\n", "11 1990-01-11 1.9617\n", "12 1990-01-12 1.1046\n", "13 1990-01-13 -3.5867\n", "14 1990-01-14 -6.29\n", "15 1990-01-15 -0.6196\n", "16 1990-01-16 2.8462\n", "17 1990-01-17 4.2837\n", "18 1990-01-18 8.1342\n", "19 1990-01-19 -0.8175\n", "20 1990-01-20 -0.9004\n", "21 1990-01-21 -1.5712\n", "22 1990-01-22 -3.0025\n", "23 1990-01-23 -0.0846\n", "24 1990-01-24 3.5871\n", "25 1990-01-25 4.8288\n", "26 1990-01-26 5.88\n", "27 1990-01-27 1.2413\n", "28 1990-01-28 3.1271\n", "29 1990-01-29 1.9546\n", "... ... ...\n", "11398 2021-03-31 11.3479\n", "11399 2021-04-01 6.3996\n", "11400 2021-04-02 -0.7425\n", "11401 2021-04-03 1.3283\n", "11402 2021-04-04 5.3671\n", "11403 2021-04-08 5.83\n", "11404 2021-04-09 9.1904\n", "11405 2021-04-10 13.7054\n", "11406 2021-04-11 7.8138\n", "11407 2021-04-12 6.1117\n", "11408 2021-04-13 7.6871\n", "11409 2021-04-14 7.7612\n", "11410 2021-04-15 7.4096\n", "11411 2021-04-16 3.6671\n", "11412 2021-04-17 4.7092\n", "11413 2021-04-22 3.2454\n", "11414 2021-04-23 7.7121\n", "11415 2021-04-24 14.1629\n", "11416 2021-04-25 9.8254\n", "11417 2021-04-26 8.0446\n", "11418 2021-04-27 11.1492\n", "11419 2021-04-28 12.2642\n", "11420 2021-04-29 9.1883\n", "11421 2021-04-30 11.2908\n", "11422 2021-05-01 9.8279\n", "11423 2021-05-02 16.1838\n", "11424 2021-05-03 13.035\n", "11425 2021-05-04 9.3667\n", "11426 2021-05-05 8.2125\n", "11427 2021-05-06 11.865\n", "\n", "[11428 rows x 2 columns]\n" ] } ], "source": [ "#Time Series - Daily History of observational CFSR data\n", "import pandas as pd\n", "data = ice.get_timeseries(['KBOS-CFSR'],['2M Hourly Temp Average'],'D','1990-01-01','2021-05-20')\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " 0 1\n", "0 Time KBOS-CFSR.2M HOURLY TEMP AVERAGE\n", "1 2021-01-01T00:00:00 -0.6\n", "2 2021-01-01T01:00:00 -1.18\n", "3 2021-01-01T02:00:00 -1.63\n", "4 2021-01-01T03:00:00 -2.07\n", "5 2021-01-01T04:00:00 -2.19\n", "6 2021-01-01T05:00:00 -2.41\n", "7 2021-01-01T06:00:00 -2.4\n", "8 2021-01-01T07:00:00 -1.98\n", "9 2021-01-01T08:00:00 -0.62\n", "10 2021-01-01T09:00:00 0.32\n", "11 2021-01-01T10:00:00 0.94\n", "12 2021-01-01T11:00:00 1.5\n", "13 2021-01-01T12:00:00 2.42\n", "14 2021-01-01T13:00:00 2.4\n", "15 2021-01-01T14:00:00 2.1\n", "16 2021-01-01T15:00:00 0.45\n", "17 2021-01-01T16:00:00 0.01\n", "18 2021-01-01T17:00:00 0.25\n", "19 2021-01-01T18:00:00 0.87\n", "20 2021-01-01T19:00:00 0.79\n", "21 2021-01-01T20:00:00 0.91\n", "22 2021-01-01T21:00:00 1.21\n", "23 2021-01-01T22:00:00 1.78\n", "24 2021-01-01T23:00:00 2.32\n", "25 2021-01-02T00:00:00 2.57\n", "26 2021-01-02T01:00:00 2.91\n", "27 2021-01-02T02:00:00 3.14\n", "28 2021-01-02T03:00:00 3.44\n", "29 2021-01-02T04:00:00 3.96\n", "... ... ...\n", "2571 2021-05-05T18:00:00 7.94\n", "2572 2021-05-05T19:00:00 7.84\n", "2573 2021-05-05T20:00:00 7.71\n", "2574 2021-05-05T21:00:00 7.68\n", "2575 2021-05-05T22:00:00 7.86\n", "2576 2021-05-05T23:00:00 8.05\n", "2577 2021-05-06T00:00:00 8.24\n", "2578 2021-05-06T01:00:00 8.4\n", "2579 2021-05-06T02:00:00 8.96\n", "2580 2021-05-06T03:00:00 9.31\n", "2581 2021-05-06T04:00:00 8.94\n", "2582 2021-05-06T05:00:00 8.41\n", "2583 2021-05-06T06:00:00 8.85\n", "2584 2021-05-06T07:00:00 10.35\n", "2585 2021-05-06T08:00:00 11.56\n", "2586 2021-05-06T09:00:00 13.01\n", "2587 2021-05-06T10:00:00 14.1\n", "2588 2021-05-06T11:00:00 15.05\n", "2589 2021-05-06T12:00:00 15.71\n", "2590 2021-05-06T13:00:00 16.61\n", "2591 2021-05-06T14:00:00 17.35\n", "2592 2021-05-06T15:00:00 17.25\n", "2593 2021-05-06T16:00:00 16.57\n", "2594 2021-05-06T17:00:00 15.12\n", "2595 2021-05-06T18:00:00 12.72\n", "2596 2021-05-06T19:00:00 10.1\n", "2597 2021-05-06T20:00:00 10.61\n", "2598 2021-05-06T21:00:00 10.04\n", "2599 2021-05-06T22:00:00 8.99\n", "2600 2021-05-06T23:00:00 8.51\n", "\n", "[2601 rows x 2 columns]\n" ] } ], "source": [ "#Time Series - Hourly History of observational CFSR data\n", "import pandas as pd\n", "data = ice.get_timeseries(['KBOS-CFSR'],['2M Hourly Temp Average'],'i60','2021-01-01','2021-05-20')\n", "df = pd.DataFrame(list(data))\n", "print(df)" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.1" } }, "nbformat": 4, "nbformat_minor": 2 }