{
"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",
" USAF | \n",
" WBAN | \n",
" STATION NAME | \n",
" CTRY | \n",
" STATE | \n",
" ICAO | \n",
" LAT | \n",
" LON | \n",
" ELEV(M) | \n",
" BEGIN | \n",
" END | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 007018 | \n",
" 99999 | \n",
" WXPOD 7018 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 0.00 | \n",
" 0.000 | \n",
" 7018.0 | \n",
" 20110309 | \n",
" 20130730 | \n",
"
\n",
" \n",
" 1 | \n",
" 007026 | \n",
" 99999 | \n",
" WXPOD 7026 | \n",
" AF | \n",
" NaN | \n",
" NaN | \n",
" 0.00 | \n",
" 0.000 | \n",
" 7026.0 | \n",
" 20120713 | \n",
" 20170822 | \n",
"
\n",
" \n",
" 2 | \n",
" 007070 | \n",
" 99999 | \n",
" WXPOD 7070 | \n",
" AF | \n",
" NaN | \n",
" NaN | \n",
" 0.00 | \n",
" 0.000 | \n",
" 7070.0 | \n",
" 20140923 | \n",
" 20150926 | \n",
"
\n",
" \n",
" 3 | \n",
" 008260 | \n",
" 99999 | \n",
" WXPOD8270 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 0.00 | \n",
" 0.000 | \n",
" 0.0 | \n",
" 20050101 | \n",
" 20120731 | \n",
"
\n",
" \n",
" 4 | \n",
" 008268 | \n",
" 99999 | \n",
" WXPOD8278 | \n",
" AF | \n",
" NaN | \n",
" NaN | \n",
" 32.95 | \n",
" 65.567 | \n",
" 1156.7 | \n",
" 20100519 | \n",
" 20120323 | \n",
"
\n",
" \n",
"
\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",
" USAF | \n",
" WBAN | \n",
" STATION NAME | \n",
" CTRY | \n",
" STATE | \n",
" ICAO | \n",
" LAT | \n",
" LON | \n",
" ELEV(M) | \n",
" BEGIN | \n",
" END | \n",
" distance | \n",
" station_id | \n",
" year_begain | \n",
" year_end | \n",
"
\n",
" \n",
" \n",
" \n",
" 1565 | \n",
" 035573 | \n",
" 99999 | \n",
" CRANFIELD | \n",
" UK | \n",
" NaN | \n",
" EGTC | \n",
" 52.072 | \n",
" -0.617 | \n",
" 109.1 | \n",
" 19900208 | \n",
" 20240413 | \n",
" 72.959310 | \n",
" 03557399999 | \n",
" 1990 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1568 | \n",
" 035600 | \n",
" 99999 | \n",
" BEDFORD | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 52.217 | \n",
" -0.483 | \n",
" 84.0 | \n",
" 19870409 | \n",
" 20240413 | \n",
" 84.026935 | \n",
" 03560099999 | \n",
" 1987 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1574 | \n",
" 035660 | \n",
" 99999 | \n",
" WYTON | \n",
" UK | \n",
" NaN | \n",
" EGUY | \n",
" 52.357 | \n",
" -0.108 | \n",
" 41.1 | \n",
" 19501003 | \n",
" 20151004 | \n",
" 95.356541 | \n",
" 03566099999 | \n",
" 1950 | \n",
" 2015 | \n",
"
\n",
" \n",
" 1578 | \n",
" 035715 | \n",
" 99999 | \n",
" CAMBRIDGE | \n",
" UK | \n",
" NaN | \n",
" EGSC | \n",
" 52.205 | \n",
" 0.175 | \n",
" 14.3 | \n",
" 19770201 | \n",
" 20240412 | \n",
" 80.697503 | \n",
" 03571599999 | \n",
" 1977 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1636 | \n",
" 036580 | \n",
" 99999 | \n",
" BENSON | \n",
" UK | \n",
" NaN | \n",
" EGUB | \n",
" 51.616 | \n",
" -1.096 | \n",
" 68.9 | \n",
" 19730101 | \n",
" 20240413 | \n",
" 70.269685 | \n",
" 03658099999 | \n",
" 1973 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1638 | \n",
" 036600 | \n",
" 99999 | \n",
" HIGH WYCOMBE HQAIR | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.683 | \n",
" -0.800 | \n",
" 205.0 | \n",
" 19971201 | \n",
" 20230222 | \n",
" 52.610209 | \n",
" 03660099999 | \n",
" 1997 | \n",
" 2023 | \n",
"
\n",
" \n",
" 1640 | \n",
" 036720 | \n",
" 99999 | \n",
" NORTHOLT | \n",
" UK | \n",
" NaN | \n",
" EGWU | \n",
" 51.553 | \n",
" -0.418 | \n",
" 37.8 | \n",
" 19730101 | \n",
" 20240413 | \n",
" 22.843444 | \n",
" 03672099999 | \n",
" 1973 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1642 | \n",
" 036733 | \n",
" 99999 | \n",
" LUTON | \n",
" UK | \n",
" NaN | \n",
" EGGW | \n",
" 51.875 | \n",
" -0.368 | \n",
" 160.3 | \n",
" 19880105 | \n",
" 20240413 | \n",
" 45.654109 | \n",
" 03673399999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1645 | \n",
" 036830 | \n",
" 99999 | \n",
" STANSTED | \n",
" UK | \n",
" NaN | \n",
" EGSS | \n",
" 51.885 | \n",
" 0.235 | \n",
" 106.1 | \n",
" 19730101 | \n",
" 20240413 | \n",
" 48.697782 | \n",
" 03683099999 | \n",
" 1973 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1646 | \n",
" 036840 | \n",
" 99999 | \n",
" ANDREWSFIELD | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.883 | \n",
" 0.450 | \n",
" 87.0 | \n",
" 19980301 | \n",
" 20240413 | \n",
" 57.116337 | \n",
" 03684099999 | \n",
" 1998 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1651 | \n",
" 036913 | \n",
" 99999 | \n",
" SOUTHEND | \n",
" UK | \n",
" NaN | \n",
" EGMC | \n",
" 51.571 | \n",
" 0.696 | \n",
" 14.9 | \n",
" 19880105 | \n",
" 20240413 | \n",
" 55.793439 | \n",
" 03691399999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1652 | \n",
" 036930 | \n",
" 99999 | \n",
" SHOEBURYNESS LANDWICK | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.550 | \n",
" 0.833 | \n",
" 3.0 | \n",
" 19291001 | \n",
" 20240413 | \n",
" 64.990617 | \n",
" 03693099999 | \n",
" 1929 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1689 | \n",
" 037610 | \n",
" 99999 | \n",
" ODIHAM | \n",
" UK | \n",
" NaN | \n",
" EGVO | \n",
" 51.234 | \n",
" -0.943 | \n",
" 123.4 | \n",
" 19730101 | \n",
" 20240413 | \n",
" 65.745142 | \n",
" 03761099999 | \n",
" 1973 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1690 | \n",
" 037630 | \n",
" 99999 | \n",
" BRACKNELL/BEAUFORT | \n",
" UK | \n",
" NaN | \n",
" EGRR | \n",
" 51.383 | \n",
" -0.783 | \n",
" 74.0 | \n",
" 19730101 | \n",
" 20230524 | \n",
" 49.240090 | \n",
" 03763099999 | \n",
" 1973 | \n",
" 2023 | \n",
"
\n",
" \n",
" 1694 | \n",
" 037663 | \n",
" 99999 | \n",
" BIGGIN HILL | \n",
" UK | \n",
" NaN | \n",
" EGKB | \n",
" 51.331 | \n",
" 0.033 | \n",
" 182.3 | \n",
" 19880105 | \n",
" 20240413 | \n",
" 20.955616 | \n",
" 03766399999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1696 | \n",
" 037680 | \n",
" 99999 | \n",
" FARNBOROUGH | \n",
" UK | \n",
" NaN | \n",
" EGLF | \n",
" 51.276 | \n",
" -0.776 | \n",
" 72.5 | \n",
" 19880501 | \n",
" 20240413 | \n",
" 53.248254 | \n",
" 03768099999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1697 | \n",
" 037683 | \n",
" 99999 | \n",
" CITY | \n",
" UK | \n",
" NaN | \n",
" EGLC | \n",
" 51.505 | \n",
" 0.055 | \n",
" 5.8 | \n",
" 19880129 | \n",
" 20240413 | \n",
" 10.777056 | \n",
" 03768399999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1698 | \n",
" 037690 | \n",
" 99999 | \n",
" CHARLWOOD | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.144 | \n",
" -0.229 | \n",
" 68.0 | \n",
" 19920301 | \n",
" 20240413 | \n",
" 40.614626 | \n",
" 03769099999 | \n",
" 1992 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1699 | \n",
" 037700 | \n",
" 99999 | \n",
" ST JAMES PARK | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.500 | \n",
" -0.117 | \n",
" 5.0 | \n",
" 20091218 | \n",
" 20240413 | \n",
" 1.180489 | \n",
" 03770099999 | \n",
" 2009 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1700 | \n",
" 037720 | \n",
" 99999 | \n",
" HEATHROW | \n",
" UK | \n",
" NaN | \n",
" EGLL | \n",
" 51.478 | \n",
" -0.461 | \n",
" 25.3 | \n",
" 19481201 | \n",
" 20240413 | \n",
" 25.193219 | \n",
" 03772099999 | \n",
" 1948 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1703 | \n",
" 037760 | \n",
" 99999 | \n",
" GATWICK | \n",
" UK | \n",
" NaN | \n",
" EGKK | \n",
" 51.148 | \n",
" -0.190 | \n",
" 61.6 | \n",
" 19730101 | \n",
" 20240413 | \n",
" 39.660905 | \n",
" 03776099999 | \n",
" 1973 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1708 | \n",
" 037810 | \n",
" 99999 | \n",
" KENLEY AIRFIELD | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.300 | \n",
" -0.083 | \n",
" 170.0 | \n",
" 19880201 | \n",
" 20240413 | \n",
" 22.282614 | \n",
" 03781099999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1779 | \n",
" 038720 | \n",
" 99999 | \n",
" THORNEY ISLAND | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 50.817 | \n",
" -0.917 | \n",
" 3.0 | \n",
" 19840703 | \n",
" 20240413 | \n",
" 95.080014 | \n",
" 03872099999 | \n",
" 1984 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1783 | \n",
" 038760 | \n",
" 99999 | \n",
" SHOREHAM | \n",
" UK | \n",
" NaN | \n",
" EGKA | \n",
" 50.836 | \n",
" -0.297 | \n",
" 2.1 | \n",
" 19861201 | \n",
" 20240413 | \n",
" 75.144994 | \n",
" 03876099999 | \n",
" 1986 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1789 | \n",
" 038820 | \n",
" 99999 | \n",
" HERSTMONCEUX WEST END | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 50.900 | \n",
" 0.317 | \n",
" 52.0 | \n",
" 19921201 | \n",
" 20240413 | \n",
" 72.836788 | \n",
" 03882099999 | \n",
" 1992 | \n",
" 2024 | \n",
"
\n",
" \n",
" 1795 | \n",
" 038873 | \n",
" 99999 | \n",
" LYDD | \n",
" UK | \n",
" NaN | \n",
" EGMD | \n",
" 50.956 | \n",
" 0.939 | \n",
" 4.0 | \n",
" 19880105 | \n",
" 20240413 | \n",
" 94.498698 | \n",
" 03887399999 | \n",
" 1988 | \n",
" 2024 | \n",
"
\n",
" \n",
"
\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",
" USAF | \n",
" WBAN | \n",
" STATION NAME | \n",
" CTRY | \n",
" STATE | \n",
" ICAO | \n",
" LAT | \n",
" LON | \n",
" ELEV(M) | \n",
" BEGIN | \n",
" END | \n",
" distance | \n",
" station_id | \n",
" year_begain | \n",
" year_end | \n",
"
\n",
" \n",
" \n",
" \n",
" 1699 | \n",
" 037700 | \n",
" 99999 | \n",
" ST JAMES PARK | \n",
" UK | \n",
" NaN | \n",
" NaN | \n",
" 51.5 | \n",
" -0.117 | \n",
" 5.0 | \n",
" 20091218 | \n",
" 20240413 | \n",
" 1.180489 | \n",
" 03770099999 | \n",
" 2009 | \n",
" 2024 | \n",
"
\n",
" \n",
"
\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",
" STATION | \n",
" DATE | \n",
" SOURCE | \n",
" LATITUDE | \n",
" LONGITUDE | \n",
" ELEVATION | \n",
" NAME | \n",
" REPORT_TYPE | \n",
" CALL_SIGN | \n",
" QUALITY_CONTROL | \n",
" ... | \n",
" VIS | \n",
" TMP | \n",
" DEW | \n",
" SLP | \n",
" AA1 | \n",
" AA2 | \n",
" IA2 | \n",
" KA1 | \n",
" REM | \n",
" EQD | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 3770099999 | \n",
" 2011-01-01T00:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0068,1 | \n",
" +0027,1 | \n",
" 99999,9 | \n",
" 06,0000,9,1 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN054AAXX 01004 03770 16/// ///// 10068 2002... | \n",
" Q01 00002PRCP06 | \n",
"
\n",
" \n",
" 1 | \n",
" 3770099999 | \n",
" 2011-01-01T01:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0067,1 | \n",
" +0028,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 01014 03770 46/// ///// 10067 2002... | \n",
" NaN | \n",
"
\n",
" \n",
" 2 | \n",
" 3770099999 | \n",
" 2011-01-01T02:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0064,1 | \n",
" +0028,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 01024 03770 46/// ///// 10064 2002... | \n",
" NaN | \n",
"
\n",
" \n",
" 3 | \n",
" 3770099999 | \n",
" 2011-01-01T03:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0064,1 | \n",
" +0028,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 01034 03770 46/// ///// 10064 2002... | \n",
" NaN | \n",
"
\n",
" \n",
" 4 | \n",
" 3770099999 | \n",
" 2011-01-01T04:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0059,1 | \n",
" +0027,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 01044 03770 46/// ///// 10059 2002... | \n",
" NaN | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 8706 | \n",
" 3770099999 | \n",
" 2011-12-30T10:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0066,1 | \n",
" +0030,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 30104 03770 46/// ///// 10066 2003... | \n",
" NaN | \n",
"
\n",
" \n",
" 8707 | \n",
" 3770099999 | \n",
" 2011-12-30T11:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0070,1 | \n",
" +0030,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 30114 03770 46/// ///// 10070 2003... | \n",
" NaN | \n",
"
\n",
" \n",
" 8708 | \n",
" 3770099999 | \n",
" 2011-12-31T21:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0127,1 | \n",
" +0106,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 31214 03770 46/// ///// 10127 2010... | \n",
" NaN | \n",
"
\n",
" \n",
" 8709 | \n",
" 3770099999 | \n",
" 2011-12-31T22:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0122,1 | \n",
" +0107,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 31224 03770 46/// ///// 10122 2010... | \n",
" NaN | \n",
"
\n",
" \n",
" 8710 | \n",
" 3770099999 | \n",
" 2011-12-31T23:00:00 | \n",
" 4 | \n",
" 51.5 | \n",
" -0.116667 | \n",
" 5.0 | \n",
" ST JAMES PARK, UK | \n",
" FM-12 | \n",
" 99999 | \n",
" V020 | \n",
" ... | \n",
" 999999,9,N,1 | \n",
" +0120,1 | \n",
" +0110,1 | \n",
" 99999,9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" SYN048AAXX 31234 03770 46/// ///// 10120 2011... | \n",
" NaN | \n",
"
\n",
" \n",
"
\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
}