{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Tutorial 2: Aggregation to Precipitation Sums\n", "This tutorial will show you, how to calculate precipitation sums from the data stored in HDF5 and how to export the results to ArcGIS.\n", "\n", "To import your RADOLAN data into the necessary HDF5 file, please follow the tutorial on raw data processing." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Example 1: Annual Precipitation Sums\n", "In this example, the annual precipitation sums for the time period from 2001 to 2016 are calculated and exported to ArcGIS. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### 1. Import radproc" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import radproc as rp" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### 2. Load Data from HDF5 and Aggregate to Annual Precipitation Sums \n", "\n", "The following function loads precipitation data of the specified time period (2001-2016) from an HDF5 file and generates a DataFrame with annual precipitation sums for every raster cell." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Rasterzellen-ID | \n", "427005 | \n", "427006 | \n", "427903 | \n", "427904 | \n", "427905 | \n", "427906 | \n", "428803 | \n", "428804 | \n", "428805 | \n", "428806 | \n", "... | \n", "661855 | \n", "661856 | \n", "661857 | \n", "662752 | \n", "662753 | \n", "662754 | \n", "662755 | \n", "662756 | \n", "663652 | \n", "663655 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Datum (UTC) | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2001-12-31 00:00:00+00:00 | \n", "783.400024 | \n", "809.500000 | \n", "763.299988 | \n", "773.500000 | \n", "779.700012 | \n", "788.500000 | \n", "769.500000 | \n", "780.400024 | \n", "778.700012 | \n", "783.000000 | \n", "... | \n", "1066.599976 | \n", "1098.699951 | \n", "1125.400024 | \n", "994.000000 | \n", "998.700012 | \n", "1020.599976 | \n", "1056.099976 | \n", "1075.200073 | \n", "989.200012 | \n", "1039.500000 | \n", "
2002-12-31 00:00:00+00:00 | \n", "967.700012 | \n", "980.799988 | \n", "951.000000 | \n", "935.500000 | \n", "947.200012 | \n", "950.700012 | \n", "956.000000 | \n", "960.700012 | \n", "938.700012 | \n", "955.400024 | \n", "... | \n", "1491.599976 | \n", "1529.500000 | \n", "1539.199951 | \n", "1383.099976 | \n", "1387.500000 | \n", "1407.400024 | \n", "1478.099976 | \n", "1488.800049 | \n", "1380.400024 | \n", "1467.099976 | \n", "
2003-12-31 00:00:00+00:00 | \n", "597.200012 | \n", "614.200012 | \n", "578.000000 | \n", "583.000000 | \n", "592.200012 | \n", "592.299988 | \n", "573.400024 | \n", "587.700012 | \n", "587.299988 | \n", "589.600037 | \n", "... | \n", "697.600037 | \n", "696.099976 | \n", "683.700012 | \n", "670.400024 | \n", "652.599976 | \n", "638.400024 | \n", "663.599976 | \n", "668.599976 | \n", "663.099976 | \n", "648.000000 | \n", "
2004-12-31 00:00:00+00:00 | \n", "795.000000 | \n", "801.000000 | \n", "772.000000 | \n", "768.099976 | \n", "776.600037 | \n", "792.799988 | \n", "746.500000 | \n", "767.099976 | \n", "779.000000 | \n", "792.900024 | \n", "... | \n", "851.599976 | \n", "872.200012 | \n", "869.799988 | \n", "803.000000 | \n", "802.000000 | \n", "804.099976 | \n", "825.099976 | \n", "841.599976 | \n", "806.000000 | \n", "813.700012 | \n", "
2005-12-31 00:00:00+00:00 | \n", "728.099976 | \n", "710.799988 | \n", "678.500000 | \n", "676.799988 | \n", "730.200012 | \n", "681.399963 | \n", "671.400024 | \n", "664.099976 | \n", "658.799988 | \n", "666.299988 | \n", "... | \n", "914.799988 | \n", "922.900024 | \n", "911.099976 | \n", "847.799988 | \n", "861.500000 | \n", "868.099976 | \n", "893.200012 | \n", "903.299988 | \n", "850.799988 | \n", "872.500000 | \n", "
5 rows × 23320 columns
\n", "Rasterzellen-ID | \n", "427005 | \n", "427006 | \n", "427903 | \n", "427904 | \n", "427905 | \n", "427906 | \n", "428803 | \n", "428804 | \n", "428805 | \n", "428806 | \n", "... | \n", "661855 | \n", "661856 | \n", "661857 | \n", "662752 | \n", "662753 | \n", "662754 | \n", "662755 | \n", "662756 | \n", "663652 | \n", "663655 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Datum (UTC) | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2016-01-31 00:00:00+00:00 | \n", "71.400002 | \n", "71.900002 | \n", "68.000000 | \n", "69.099998 | \n", "70.099998 | \n", "71.699997 | \n", "65.500000 | \n", "67.300003 | \n", "66.199997 | \n", "69.800003 | \n", "... | \n", "128.199997 | \n", "129.500000 | \n", "129.600006 | \n", "120.199997 | \n", "121.300003 | \n", "123.500000 | \n", "125.699997 | \n", "122.900002 | \n", "118.099998 | \n", "120.400002 | \n", "
2016-02-29 00:00:00+00:00 | \n", "68.699997 | \n", "71.199997 | \n", "61.500000 | \n", "64.300003 | \n", "67.300003 | \n", "68.400002 | \n", "58.200001 | \n", "61.700001 | \n", "65.000000 | \n", "64.300003 | \n", "... | \n", "105.900002 | \n", "106.199997 | \n", "110.099998 | \n", "96.800003 | \n", "96.699997 | \n", "100.099998 | \n", "102.599998 | \n", "101.400002 | \n", "92.800003 | \n", "97.400002 | \n", "
2016-03-31 00:00:00+00:00 | \n", "41.799999 | \n", "41.299999 | \n", "40.299999 | \n", "39.900002 | \n", "40.099998 | \n", "39.299999 | \n", "37.700001 | \n", "38.200001 | \n", "38.799999 | \n", "37.500000 | \n", "... | \n", "65.500000 | \n", "64.400002 | \n", "65.199997 | \n", "70.000000 | \n", "67.500000 | \n", "64.400002 | \n", "65.099998 | \n", "65.099998 | \n", "69.800003 | \n", "65.500000 | \n", "
2016-04-30 00:00:00+00:00 | \n", "55.700001 | \n", "56.600002 | \n", "51.799999 | \n", "52.400002 | \n", "54.000000 | \n", "55.299999 | \n", "50.799999 | \n", "51.200001 | \n", "52.799999 | \n", "54.400002 | \n", "... | \n", "108.500000 | \n", "112.199997 | \n", "115.400002 | \n", "106.700005 | \n", "106.500000 | \n", "107.699997 | \n", "112.599998 | \n", "114.300003 | \n", "105.199997 | \n", "108.099998 | \n", "
2016-05-31 00:00:00+00:00 | \n", "38.200001 | \n", "40.600002 | \n", "47.299999 | \n", "44.799999 | \n", "39.400002 | \n", "34.299999 | \n", "46.799999 | \n", "45.400002 | \n", "43.200001 | \n", "38.500000 | \n", "... | \n", "121.299995 | \n", "119.300003 | \n", "115.099998 | \n", "128.100006 | \n", "138.199997 | \n", "135.500000 | \n", "124.300003 | \n", "128.500000 | \n", "130.199997 | \n", "134.399994 | \n", "
5 rows × 23320 columns
\n", "