{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## ISD data with location, distance and time" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
USAFWBANSTATION NAMECTRYSTATEICAOLATLONELEV(M)BEGINEND
000701899999WXPOD 7018NaNNaNNaN0.000.0007018.02011030920130730
100702699999WXPOD 7026AFNaNNaN0.000.0007026.02012071320170822
200707099999WXPOD 7070AFNaNNaN0.000.0007070.02014092320150926
300826099999WXPOD8270NaNNaNNaN0.000.0000.02005010120120731
400826899999WXPOD8278AFNaNNaN32.9565.5671156.72010051920120323
\n", "
" ], "text/plain": [ " USAF WBAN STATION NAME CTRY STATE ICAO LAT LON ELEV(M) \\\n", "0 007018 99999 WXPOD 7018 NaN NaN NaN 0.00 0.000 7018.0 \n", "1 007026 99999 WXPOD 7026 AF NaN NaN 0.00 0.000 7026.0 \n", "2 007070 99999 WXPOD 7070 AF NaN NaN 0.00 0.000 7070.0 \n", "3 008260 99999 WXPOD8270 NaN NaN NaN 0.00 0.000 0.0 \n", "4 008268 99999 WXPOD8278 AF NaN NaN 32.95 65.567 1156.7 \n", "\n", " BEGIN END \n", "0 20110309 20130730 \n", "1 20120713 20170822 \n", "2 20140923 20150926 \n", "3 20050101 20120731 \n", "4 20100519 20120323 " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from obswx import *\n", "\n", "# Get the metadata for the ISD dataset\n", "met = obswx(source='ISD')\n", "met.get_meta(load=True).head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "- `lat`: Latitude of the interested points. type: int, float; or list, tuple for selecting a region.\n", "- `lon`: Longitude of the interested point. type: int, float; or list, tuple for selecting a region.\n", "- `radius` (optional): Radius of the circle in km around the interested point.\n", "- `year` (optional): Year of the interested data (default is None, all the available years; if a specific year is selected, return the data for that year)\n", " - year can be int or list and tuple of 2 int (begin and end year)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Found 26 stations at point (51.5, -0.1) within 100 km\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
USAFWBANSTATION NAMECTRYSTATEICAOLATLONELEV(M)BEGINENDdistancestation_idyear_begainyear_end
156503557399999CRANFIELDUKNaNEGTC52.072-0.617109.1199002082024041372.9593100355739999919902024
156803560099999BEDFORDUKNaNNaN52.217-0.48384.0198704092024041384.0269350356009999919872024
157403566099999WYTONUKNaNEGUY52.357-0.10841.1195010032015100495.3565410356609999919502015
157803571599999CAMBRIDGEUKNaNEGSC52.2050.17514.3197702012024041280.6975030357159999919772024
163603658099999BENSONUKNaNEGUB51.616-1.09668.9197301012024041370.2696850365809999919732024
163803660099999HIGH WYCOMBE HQAIRUKNaNNaN51.683-0.800205.0199712012023022252.6102090366009999919972023
164003672099999NORTHOLTUKNaNEGWU51.553-0.41837.8197301012024041322.8434440367209999919732024
164203673399999LUTONUKNaNEGGW51.875-0.368160.3198801052024041345.6541090367339999919882024
164503683099999STANSTEDUKNaNEGSS51.8850.235106.1197301012024041348.6977820368309999919732024
164603684099999ANDREWSFIELDUKNaNNaN51.8830.45087.0199803012024041357.1163370368409999919982024
165103691399999SOUTHENDUKNaNEGMC51.5710.69614.9198801052024041355.7934390369139999919882024
165203693099999SHOEBURYNESS LANDWICKUKNaNNaN51.5500.8333.0192910012024041364.9906170369309999919292024
168903761099999ODIHAMUKNaNEGVO51.234-0.943123.4197301012024041365.7451420376109999919732024
169003763099999BRACKNELL/BEAUFORTUKNaNEGRR51.383-0.78374.0197301012023052449.2400900376309999919732023
169403766399999BIGGIN HILLUKNaNEGKB51.3310.033182.3198801052024041320.9556160376639999919882024
169603768099999FARNBOROUGHUKNaNEGLF51.276-0.77672.5198805012024041353.2482540376809999919882024
169703768399999CITYUKNaNEGLC51.5050.0555.8198801292024041310.7770560376839999919882024
169803769099999CHARLWOODUKNaNNaN51.144-0.22968.0199203012024041340.6146260376909999919922024
169903770099999ST JAMES PARKUKNaNNaN51.500-0.1175.020091218202404131.1804890377009999920092024
170003772099999HEATHROWUKNaNEGLL51.478-0.46125.3194812012024041325.1932190377209999919482024
170303776099999GATWICKUKNaNEGKK51.148-0.19061.6197301012024041339.6609050377609999919732024
170803781099999KENLEY AIRFIELDUKNaNNaN51.300-0.083170.0198802012024041322.2826140378109999919882024
177903872099999THORNEY ISLANDUKNaNNaN50.817-0.9173.0198407032024041395.0800140387209999919842024
178303876099999SHOREHAMUKNaNEGKA50.836-0.2972.1198612012024041375.1449940387609999919862024
178903882099999HERSTMONCEUX WEST ENDUKNaNNaN50.9000.31752.0199212012024041372.8367880388209999919922024
179503887399999LYDDUKNaNEGMD50.9560.9394.0198801052024041394.4986980388739999919882024
\n", "
" ], "text/plain": [ " USAF WBAN STATION NAME CTRY STATE ICAO LAT LON \\\n", "1565 035573 99999 CRANFIELD UK NaN EGTC 52.072 -0.617 \n", "1568 035600 99999 BEDFORD UK NaN NaN 52.217 -0.483 \n", "1574 035660 99999 WYTON UK NaN EGUY 52.357 -0.108 \n", "1578 035715 99999 CAMBRIDGE UK NaN EGSC 52.205 0.175 \n", "1636 036580 99999 BENSON UK NaN EGUB 51.616 -1.096 \n", "1638 036600 99999 HIGH WYCOMBE HQAIR UK NaN NaN 51.683 -0.800 \n", "1640 036720 99999 NORTHOLT UK NaN EGWU 51.553 -0.418 \n", "1642 036733 99999 LUTON UK NaN EGGW 51.875 -0.368 \n", "1645 036830 99999 STANSTED UK NaN EGSS 51.885 0.235 \n", "1646 036840 99999 ANDREWSFIELD UK NaN NaN 51.883 0.450 \n", "1651 036913 99999 SOUTHEND UK NaN EGMC 51.571 0.696 \n", "1652 036930 99999 SHOEBURYNESS LANDWICK UK NaN NaN 51.550 0.833 \n", "1689 037610 99999 ODIHAM UK NaN EGVO 51.234 -0.943 \n", "1690 037630 99999 BRACKNELL/BEAUFORT UK NaN EGRR 51.383 -0.783 \n", "1694 037663 99999 BIGGIN HILL UK NaN EGKB 51.331 0.033 \n", "1696 037680 99999 FARNBOROUGH UK NaN EGLF 51.276 -0.776 \n", "1697 037683 99999 CITY UK NaN EGLC 51.505 0.055 \n", "1698 037690 99999 CHARLWOOD UK NaN NaN 51.144 -0.229 \n", "1699 037700 99999 ST JAMES PARK UK NaN NaN 51.500 -0.117 \n", "1700 037720 99999 HEATHROW UK NaN EGLL 51.478 -0.461 \n", "1703 037760 99999 GATWICK UK NaN EGKK 51.148 -0.190 \n", "1708 037810 99999 KENLEY AIRFIELD UK NaN NaN 51.300 -0.083 \n", "1779 038720 99999 THORNEY ISLAND UK NaN NaN 50.817 -0.917 \n", "1783 038760 99999 SHOREHAM UK NaN EGKA 50.836 -0.297 \n", "1789 038820 99999 HERSTMONCEUX WEST END UK NaN NaN 50.900 0.317 \n", "1795 038873 99999 LYDD UK NaN EGMD 50.956 0.939 \n", "\n", " ELEV(M) BEGIN END distance station_id year_begain \\\n", "1565 109.1 19900208 20240413 72.959310 03557399999 1990 \n", "1568 84.0 19870409 20240413 84.026935 03560099999 1987 \n", "1574 41.1 19501003 20151004 95.356541 03566099999 1950 \n", "1578 14.3 19770201 20240412 80.697503 03571599999 1977 \n", "1636 68.9 19730101 20240413 70.269685 03658099999 1973 \n", "1638 205.0 19971201 20230222 52.610209 03660099999 1997 \n", "1640 37.8 19730101 20240413 22.843444 03672099999 1973 \n", "1642 160.3 19880105 20240413 45.654109 03673399999 1988 \n", "1645 106.1 19730101 20240413 48.697782 03683099999 1973 \n", "1646 87.0 19980301 20240413 57.116337 03684099999 1998 \n", "1651 14.9 19880105 20240413 55.793439 03691399999 1988 \n", "1652 3.0 19291001 20240413 64.990617 03693099999 1929 \n", "1689 123.4 19730101 20240413 65.745142 03761099999 1973 \n", "1690 74.0 19730101 20230524 49.240090 03763099999 1973 \n", "1694 182.3 19880105 20240413 20.955616 03766399999 1988 \n", "1696 72.5 19880501 20240413 53.248254 03768099999 1988 \n", "1697 5.8 19880129 20240413 10.777056 03768399999 1988 \n", "1698 68.0 19920301 20240413 40.614626 03769099999 1992 \n", "1699 5.0 20091218 20240413 1.180489 03770099999 2009 \n", "1700 25.3 19481201 20240413 25.193219 03772099999 1948 \n", "1703 61.6 19730101 20240413 39.660905 03776099999 1973 \n", "1708 170.0 19880201 20240413 22.282614 03781099999 1988 \n", "1779 3.0 19840703 20240413 95.080014 03872099999 1984 \n", "1783 2.1 19861201 20240413 75.144994 03876099999 1986 \n", "1789 52.0 19921201 20240413 72.836788 03882099999 1992 \n", "1795 4.0 19880105 20240413 94.498698 03887399999 1988 \n", "\n", " year_end \n", "1565 2024 \n", "1568 2024 \n", "1574 2015 \n", "1578 2024 \n", "1636 2024 \n", "1638 2023 \n", "1640 2024 \n", "1642 2024 \n", "1645 2024 \n", "1646 2024 \n", "1651 2024 \n", "1652 2024 \n", "1689 2024 \n", "1690 2023 \n", "1694 2024 \n", "1696 2024 \n", "1697 2024 \n", "1698 2024 \n", "1699 2024 \n", "1700 2024 \n", "1703 2024 \n", "1708 2024 \n", "1779 2024 \n", "1783 2024 \n", "1789 2024 \n", "1795 2024 " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "res = met.get_location(lat=51.5, lon=-0.1, radius=100, year=2011)\n", "res" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Closest station found at point (51.5, -0.1) is 03770099999, distance: 1.180488780223389 km\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
USAFWBANSTATION NAMECTRYSTATEICAOLATLONELEV(M)BEGINENDdistancestation_idyear_begainyear_end
169903770099999ST JAMES PARKUKNaNNaN51.5-0.1175.020091218202404131.1804890377009999920092024
\n", "
" ], "text/plain": [ " USAF WBAN STATION NAME CTRY STATE ICAO LAT LON ELEV(M) \\\n", "1699 037700 99999 ST JAMES PARK UK NaN NaN 51.5 -0.117 5.0 \n", "\n", " BEGIN END distance station_id year_begain year_end \n", "1699 20091218 20240413 1.180489 03770099999 2009 2024 " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "res = met.get_location(lat=51.5, lon=-0.1, year=2011)\n", "res" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "03770099999\n", "Getting data from NOAA ISD\n", "Goto here to help select station: https://junjieyu-uom.github.io/obswx/isd_map\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
STATIONDATESOURCELATITUDELONGITUDEELEVATIONNAMEREPORT_TYPECALL_SIGNQUALITY_CONTROL...VISTMPDEWSLPAA1AA2IA2KA1REMEQD
037700999992011-01-01T00:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0068,1+0027,199999,906,0000,9,1NaNNaNNaNSYN054AAXX 01004 03770 16/// ///// 10068 2002...Q01 00002PRCP06
137700999992011-01-01T01:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0067,1+0028,199999,9NaNNaNNaNNaNSYN048AAXX 01014 03770 46/// ///// 10067 2002...NaN
237700999992011-01-01T02:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0064,1+0028,199999,9NaNNaNNaNNaNSYN048AAXX 01024 03770 46/// ///// 10064 2002...NaN
337700999992011-01-01T03:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0064,1+0028,199999,9NaNNaNNaNNaNSYN048AAXX 01034 03770 46/// ///// 10064 2002...NaN
437700999992011-01-01T04:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0059,1+0027,199999,9NaNNaNNaNNaNSYN048AAXX 01044 03770 46/// ///// 10059 2002...NaN
..................................................................
870637700999992011-12-30T10:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0066,1+0030,199999,9NaNNaNNaNNaNSYN048AAXX 30104 03770 46/// ///// 10066 2003...NaN
870737700999992011-12-30T11:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0070,1+0030,199999,9NaNNaNNaNNaNSYN048AAXX 30114 03770 46/// ///// 10070 2003...NaN
870837700999992011-12-31T21:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0127,1+0106,199999,9NaNNaNNaNNaNSYN048AAXX 31214 03770 46/// ///// 10127 2010...NaN
870937700999992011-12-31T22:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0122,1+0107,199999,9NaNNaNNaNNaNSYN048AAXX 31224 03770 46/// ///// 10122 2010...NaN
871037700999992011-12-31T23:00:00451.5-0.1166675.0ST JAMES PARK, UKFM-1299999V020...999999,9,N,1+0120,1+0110,199999,9NaNNaNNaNNaNSYN048AAXX 31234 03770 46/// ///// 10120 2011...NaN
\n", "

8711 rows × 22 columns

\n", "
" ], "text/plain": [ " STATION DATE SOURCE LATITUDE LONGITUDE ELEVATION \\\n", "0 3770099999 2011-01-01T00:00:00 4 51.5 -0.116667 5.0 \n", "1 3770099999 2011-01-01T01:00:00 4 51.5 -0.116667 5.0 \n", "2 3770099999 2011-01-01T02:00:00 4 51.5 -0.116667 5.0 \n", "3 3770099999 2011-01-01T03:00:00 4 51.5 -0.116667 5.0 \n", "4 3770099999 2011-01-01T04:00:00 4 51.5 -0.116667 5.0 \n", "... ... ... ... ... ... ... \n", "8706 3770099999 2011-12-30T10:00:00 4 51.5 -0.116667 5.0 \n", "8707 3770099999 2011-12-30T11:00:00 4 51.5 -0.116667 5.0 \n", "8708 3770099999 2011-12-31T21:00:00 4 51.5 -0.116667 5.0 \n", "8709 3770099999 2011-12-31T22:00:00 4 51.5 -0.116667 5.0 \n", "8710 3770099999 2011-12-31T23:00:00 4 51.5 -0.116667 5.0 \n", "\n", " NAME REPORT_TYPE CALL_SIGN QUALITY_CONTROL ... \\\n", "0 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "1 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "2 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "3 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "4 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "... ... ... ... ... ... \n", "8706 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "8707 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "8708 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "8709 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "8710 ST JAMES PARK, UK FM-12 99999 V020 ... \n", "\n", " VIS TMP DEW SLP AA1 AA2 IA2 KA1 \\\n", "0 999999,9,N,1 +0068,1 +0027,1 99999,9 06,0000,9,1 NaN NaN NaN \n", "1 999999,9,N,1 +0067,1 +0028,1 99999,9 NaN NaN NaN NaN \n", "2 999999,9,N,1 +0064,1 +0028,1 99999,9 NaN NaN NaN NaN \n", "3 999999,9,N,1 +0064,1 +0028,1 99999,9 NaN NaN NaN NaN \n", "4 999999,9,N,1 +0059,1 +0027,1 99999,9 NaN NaN NaN NaN \n", "... ... ... ... ... ... ... ... ... \n", "8706 999999,9,N,1 +0066,1 +0030,1 99999,9 NaN NaN NaN NaN \n", "8707 999999,9,N,1 +0070,1 +0030,1 99999,9 NaN NaN NaN NaN \n", "8708 999999,9,N,1 +0127,1 +0106,1 99999,9 NaN NaN NaN NaN \n", "8709 999999,9,N,1 +0122,1 +0107,1 99999,9 NaN NaN NaN NaN \n", "8710 999999,9,N,1 +0120,1 +0110,1 99999,9 NaN NaN NaN NaN \n", "\n", " REM EQD \n", "0 SYN054AAXX 01004 03770 16/// ///// 10068 2002... Q01 00002PRCP06 \n", "1 SYN048AAXX 01014 03770 46/// ///// 10067 2002... NaN \n", "2 SYN048AAXX 01024 03770 46/// ///// 10064 2002... NaN \n", "3 SYN048AAXX 01034 03770 46/// ///// 10064 2002... NaN \n", "4 SYN048AAXX 01044 03770 46/// ///// 10059 2002... NaN \n", "... ... ... \n", "8706 SYN048AAXX 30104 03770 46/// ///// 10066 2003... NaN \n", "8707 SYN048AAXX 30114 03770 46/// ///// 10070 2003... NaN \n", "8708 SYN048AAXX 31214 03770 46/// ///// 10127 2010... NaN \n", "8709 SYN048AAXX 31224 03770 46/// ///// 10122 2010... NaN \n", "8710 SYN048AAXX 31234 03770 46/// ///// 10120 2011... NaN \n", "\n", "[8711 rows x 22 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "result = pd.DataFrame()\n", "for id in res['station_id'].values:\n", " print(id)\n", " df_ = met.get_data(year=2011, station= id, isd_source=\"AWS\")\n", " result = pd.concat([result, df_], axis=0)\n", "result" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.9" } }, "nbformat": 4, "nbformat_minor": 4 }