{ "cells": [ { "cell_type": "markdown", "id": "acd93376-b32d-48bb-83ce-354a74db0765", "metadata": {}, "source": [ "# Problem 3: \n", "## [ATM350 Homework 3](https://docs.google.com/document/d/1LakRQQE3ORtRqUrKRTJa7IZy93uLa2qe37AUMpY0v68/edit), Spring 2023\n", "```\n", "In the directory /data1/nysm, there exists a file named latest.csv that consists of the past hour’s worth of NYS Mesonet data at intervals of five minutes. Create a q3.ipynb notebook that does the following (see below):\n", "```" ] }, { "cell_type": "markdown", "id": "87c112a9-4675-46fd-b732-05fdca8ed0ab", "metadata": {}, "source": [ "#### Imports\n" ] }, { "cell_type": "code", "execution_count": 1, "id": "1f67d85a-042b-4b48-a59d-1b0369616149", "metadata": { "tags": [] }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "markdown", "id": "994ea893-1bf2-4dbd-b287-883ee255e4a6", "metadata": {}, "source": [ "### Part a:\n", "```\n", "Read the data into a Pandas Dataframe\n", "```" ] }, { "cell_type": "code", "execution_count": 2, "id": "273b7435-a350-4c6e-b3fb-3f0e93550681", "metadata": { "tags": [] }, "outputs": [], "source": [ "df = pd.read_csv('/data1/nysm/latest.csv').set_index('time')" ] }, { "cell_type": "markdown", "id": "b7c783fb-ba79-4855-af9d-453effe8d637", "metadata": { "tags": [] }, "source": [ "Examine the `Dataframe`" ] }, { "cell_type": "code", "execution_count": 3, "id": "0067754a-e87a-4631-80b3-b4d34f7f61b9", "metadata": { "tags": [] }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
stationtemp_2m [degC]temp_9m [degC]relative_humidity [percent]precip_incremental [mm]precip_local [mm]precip_max_intensity [mm/min]avg_wind_speed_prop [m/s]max_wind_speed_prop [m/s]wind_speed_stddev_prop [m/s]...snow_depth [cm]frozen_soil_05cm [bit]frozen_soil_25cm [bit]frozen_soil_50cm [bit]soil_temp_05cm [degC]soil_temp_25cm [degC]soil_temp_50cm [degC]soil_moisture_05cm [m^3/m^3]soil_moisture_25cm [m^3/m^3]soil_moisture_50cm [m^3/m^3]
time
2023-04-06 15:55:00 UTCADDI11.411.572.10.07.780.02.03.30.5...-2.00.00.00.09.67.76.20.580.440.44
2023-04-06 16:00:00 UTCADDI11.611.670.40.07.780.01.43.40.9...-2.00.00.00.09.67.76.20.580.440.44
2023-04-06 16:05:00 UTCADDI11.711.769.60.07.780.02.04.50.9...-2.00.00.00.09.67.76.20.580.440.44
2023-04-06 16:10:00 UTCADDI11.611.668.40.07.780.01.94.71.1...-2.00.00.00.09.67.76.20.580.440.44
2023-04-06 16:15:00 UTCADDI11.611.667.40.07.780.02.65.61.0...-2.00.00.00.09.67.76.20.580.440.44
..................................................................
2023-04-06 16:35:00 UTCYORK11.110.855.70.06.260.05.07.11.1...0.00.00.00.09.98.57.10.390.340.38
2023-04-06 16:40:00 UTCYORK11.010.756.10.06.260.04.27.01.2...0.00.00.00.09.98.47.10.390.340.38
2023-04-06 16:45:00 UTCYORK11.110.755.90.06.260.03.96.51.1...0.00.00.00.09.98.57.10.390.340.38
2023-04-06 16:50:00 UTCYORK11.210.856.80.06.260.04.56.50.9...0.00.00.00.09.98.57.10.390.340.38
2023-04-06 16:55:00 UTCYORK11.210.856.90.06.260.04.55.90.7...0.00.00.00.09.98.57.10.390.340.38
\n", "

1638 rows × 29 columns

\n", "
" ], "text/plain": [ " station temp_2m [degC] temp_9m [degC] \\\n", "time \n", "2023-04-06 15:55:00 UTC ADDI 11.4 11.5 \n", "2023-04-06 16:00:00 UTC ADDI 11.6 11.6 \n", "2023-04-06 16:05:00 UTC ADDI 11.7 11.7 \n", "2023-04-06 16:10:00 UTC ADDI 11.6 11.6 \n", "2023-04-06 16:15:00 UTC ADDI 11.6 11.6 \n", "... ... ... ... \n", "2023-04-06 16:35:00 UTC YORK 11.1 10.8 \n", "2023-04-06 16:40:00 UTC YORK 11.0 10.7 \n", "2023-04-06 16:45:00 UTC YORK 11.1 10.7 \n", "2023-04-06 16:50:00 UTC YORK 11.2 10.8 \n", "2023-04-06 16:55:00 UTC YORK 11.2 10.8 \n", "\n", " relative_humidity [percent] precip_incremental [mm] \\\n", "time \n", "2023-04-06 15:55:00 UTC 72.1 0.0 \n", "2023-04-06 16:00:00 UTC 70.4 0.0 \n", "2023-04-06 16:05:00 UTC 69.6 0.0 \n", "2023-04-06 16:10:00 UTC 68.4 0.0 \n", "2023-04-06 16:15:00 UTC 67.4 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 55.7 0.0 \n", "2023-04-06 16:40:00 UTC 56.1 0.0 \n", "2023-04-06 16:45:00 UTC 55.9 0.0 \n", "2023-04-06 16:50:00 UTC 56.8 0.0 \n", "2023-04-06 16:55:00 UTC 56.9 0.0 \n", "\n", " precip_local [mm] precip_max_intensity [mm/min] \\\n", "time \n", "2023-04-06 15:55:00 UTC 7.78 0.0 \n", "2023-04-06 16:00:00 UTC 7.78 0.0 \n", "2023-04-06 16:05:00 UTC 7.78 0.0 \n", "2023-04-06 16:10:00 UTC 7.78 0.0 \n", "2023-04-06 16:15:00 UTC 7.78 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 6.26 0.0 \n", "2023-04-06 16:40:00 UTC 6.26 0.0 \n", "2023-04-06 16:45:00 UTC 6.26 0.0 \n", "2023-04-06 16:50:00 UTC 6.26 0.0 \n", "2023-04-06 16:55:00 UTC 6.26 0.0 \n", "\n", " avg_wind_speed_prop [m/s] max_wind_speed_prop [m/s] \\\n", "time \n", "2023-04-06 15:55:00 UTC 2.0 3.3 \n", "2023-04-06 16:00:00 UTC 1.4 3.4 \n", "2023-04-06 16:05:00 UTC 2.0 4.5 \n", "2023-04-06 16:10:00 UTC 1.9 4.7 \n", "2023-04-06 16:15:00 UTC 2.6 5.6 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 5.0 7.1 \n", "2023-04-06 16:40:00 UTC 4.2 7.0 \n", "2023-04-06 16:45:00 UTC 3.9 6.5 \n", "2023-04-06 16:50:00 UTC 4.5 6.5 \n", "2023-04-06 16:55:00 UTC 4.5 5.9 \n", "\n", " wind_speed_stddev_prop [m/s] ... snow_depth [cm] \\\n", "time ... \n", "2023-04-06 15:55:00 UTC 0.5 ... -2.0 \n", "2023-04-06 16:00:00 UTC 0.9 ... -2.0 \n", "2023-04-06 16:05:00 UTC 0.9 ... -2.0 \n", "2023-04-06 16:10:00 UTC 1.1 ... -2.0 \n", "2023-04-06 16:15:00 UTC 1.0 ... -2.0 \n", "... ... ... ... \n", "2023-04-06 16:35:00 UTC 1.1 ... 0.0 \n", "2023-04-06 16:40:00 UTC 1.2 ... 0.0 \n", "2023-04-06 16:45:00 UTC 1.1 ... 0.0 \n", "2023-04-06 16:50:00 UTC 0.9 ... 0.0 \n", "2023-04-06 16:55:00 UTC 0.7 ... 0.0 \n", "\n", " frozen_soil_05cm [bit] frozen_soil_25cm [bit] \\\n", "time \n", "2023-04-06 15:55:00 UTC 0.0 0.0 \n", "2023-04-06 16:00:00 UTC 0.0 0.0 \n", "2023-04-06 16:05:00 UTC 0.0 0.0 \n", "2023-04-06 16:10:00 UTC 0.0 0.0 \n", "2023-04-06 16:15:00 UTC 0.0 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.0 0.0 \n", "2023-04-06 16:40:00 UTC 0.0 0.0 \n", "2023-04-06 16:45:00 UTC 0.0 0.0 \n", "2023-04-06 16:50:00 UTC 0.0 0.0 \n", "2023-04-06 16:55:00 UTC 0.0 0.0 \n", "\n", " frozen_soil_50cm [bit] soil_temp_05cm [degC] \\\n", "time \n", "2023-04-06 15:55:00 UTC 0.0 9.6 \n", "2023-04-06 16:00:00 UTC 0.0 9.6 \n", "2023-04-06 16:05:00 UTC 0.0 9.6 \n", "2023-04-06 16:10:00 UTC 0.0 9.6 \n", "2023-04-06 16:15:00 UTC 0.0 9.6 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.0 9.9 \n", "2023-04-06 16:40:00 UTC 0.0 9.9 \n", "2023-04-06 16:45:00 UTC 0.0 9.9 \n", "2023-04-06 16:50:00 UTC 0.0 9.9 \n", "2023-04-06 16:55:00 UTC 0.0 9.9 \n", "\n", " soil_temp_25cm [degC] soil_temp_50cm [degC] \\\n", "time \n", "2023-04-06 15:55:00 UTC 7.7 6.2 \n", "2023-04-06 16:00:00 UTC 7.7 6.2 \n", "2023-04-06 16:05:00 UTC 7.7 6.2 \n", "2023-04-06 16:10:00 UTC 7.7 6.2 \n", "2023-04-06 16:15:00 UTC 7.7 6.2 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 8.5 7.1 \n", "2023-04-06 16:40:00 UTC 8.4 7.1 \n", "2023-04-06 16:45:00 UTC 8.5 7.1 \n", "2023-04-06 16:50:00 UTC 8.5 7.1 \n", "2023-04-06 16:55:00 UTC 8.5 7.1 \n", "\n", " soil_moisture_05cm [m^3/m^3] \\\n", "time \n", "2023-04-06 15:55:00 UTC 0.58 \n", "2023-04-06 16:00:00 UTC 0.58 \n", "2023-04-06 16:05:00 UTC 0.58 \n", "2023-04-06 16:10:00 UTC 0.58 \n", "2023-04-06 16:15:00 UTC 0.58 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.39 \n", "2023-04-06 16:40:00 UTC 0.39 \n", "2023-04-06 16:45:00 UTC 0.39 \n", "2023-04-06 16:50:00 UTC 0.39 \n", "2023-04-06 16:55:00 UTC 0.39 \n", "\n", " soil_moisture_25cm [m^3/m^3] \\\n", "time \n", "2023-04-06 15:55:00 UTC 0.44 \n", "2023-04-06 16:00:00 UTC 0.44 \n", "2023-04-06 16:05:00 UTC 0.44 \n", "2023-04-06 16:10:00 UTC 0.44 \n", "2023-04-06 16:15:00 UTC 0.44 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.34 \n", "2023-04-06 16:40:00 UTC 0.34 \n", "2023-04-06 16:45:00 UTC 0.34 \n", "2023-04-06 16:50:00 UTC 0.34 \n", "2023-04-06 16:55:00 UTC 0.34 \n", "\n", " soil_moisture_50cm [m^3/m^3] \n", "time \n", "2023-04-06 15:55:00 UTC 0.44 \n", "2023-04-06 16:00:00 UTC 0.44 \n", "2023-04-06 16:05:00 UTC 0.44 \n", "2023-04-06 16:10:00 UTC 0.44 \n", "2023-04-06 16:15:00 UTC 0.44 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.38 \n", "2023-04-06 16:40:00 UTC 0.38 \n", "2023-04-06 16:45:00 UTC 0.38 \n", "2023-04-06 16:50:00 UTC 0.38 \n", "2023-04-06 16:55:00 UTC 0.38 \n", "\n", "[1638 rows x 29 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "markdown", "id": "5ddf9449-4327-4393-a469-298a64421c30", "metadata": {}, "source": [ "### Part b:\n", "```\n", "Create objects corresponding to the following variables:\n", "2m temperature, 9m temperature, relative humidity, five-minute accumulated precip (which is referenced as precip_incremental [mm]), daily accumulated precip (which is referenced as precip_local [mm]), and peak wind speed (max_wind_speed_prop [m/s]).\n", "```" ] }, { "cell_type": "code", "execution_count": 4, "id": "f27e3b78-4932-411e-8c1d-c11ee9e8aca1", "metadata": { "tags": [] }, "outputs": [], "source": [ "t2m = df['temp_2m [degC]']\n", "t9m = df['temp_9m [degC]']\n", "rh = df['relative_humidity [percent]']\n", "prcp = df['precip_incremental [mm]']\n", "pDay = df['precip_local [mm]']\n", "pkwd = df['max_wind_speed_prop [m/s]']" ] }, { "cell_type": "markdown", "id": "a0208dd3-3b28-485d-b8c3-37d80c6d8706", "metadata": {}, "source": [ "### Part c:\n", "```\n", "Convert temperatures to F, precip to inches, and wind speeds to knots (look up the conversions on the web).\n", "```" ] }, { "cell_type": "code", "execution_count": 5, "id": "7877034c-45d5-4af4-b037-6a1a8937c0eb", "metadata": { "tags": [] }, "outputs": [], "source": [ "t2m = t2m * 1.8 + 32\n", "t9m = t9m * 1.8 + 32\n", "prcp = prcp / 25.4\n", "pDay = pDay / 25.4\n", "pkwd = pkwd * 1.94384" ] }, { "cell_type": "markdown", "id": "bbbdd616-f881-4f94-8312-12cea23db4a9", "metadata": {}, "source": [ "### Part d:\n", "```\n", "Print out the max, min, and mean values of the temperature, RH, and wind speed objects (e.g., ”the max temperature in the past hour for all NYS Mesonet sites was xx.x F and the min temperature was xx.x F”) and max values for the precip objects. \n", "```" ] }, { "cell_type": "code", "execution_count": 6, "id": "70452cf9-942f-4017-a920-e09c78562fd5", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The maximum 2m temp in the past hour for all NYS Mesonet sites was 73.8°F\n", "The minimum 2m temp in the past hour for all NYS Mesonet sites was 42.8°F\n", "The mean 2m temp in the past hour for all NYS Mesonet sites was 54.9°F\n", "\n", "The maximum 9m temp in the past hour for all NYS Mesonet sites was 72.5°F\n", "The minimum 9m temp in the past hour for all NYS Mesonet sites was 41.9°F\n", "The mean 9m temp in the past hour for all NYS Mesonet sites was 54.4°F\n" ] } ], "source": [ "print(f\"The maximum 2m temp in the past hour for all NYS Mesonet sites was {t2m.max():.1f}°F\")\n", "print(f\"The minimum 2m temp in the past hour for all NYS Mesonet sites was {t2m.min():.1f}°F\")\n", "print(f\"The mean 2m temp in the past hour for all NYS Mesonet sites was {t2m.mean():.1f}°F\")\n", "print ()\n", "print(f\"The maximum 9m temp in the past hour for all NYS Mesonet sites was {t9m.max():.1f}°F\")\n", "print(f\"The minimum 9m temp in the past hour for all NYS Mesonet sites was {t9m.min():.1f}°F\")\n", "print(f\"The mean 9m temp in the past hour for all NYS Mesonet sites was {t9m.mean():.1f}°F\")" ] }, { "cell_type": "code", "execution_count": 7, "id": "cee10f71-bb8e-4cc8-a4f3-82d77b500d56", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The maximum RH in the past hour for all NYS Mesonet sites was 99.9%\n", "The minimum RH in the past hour for all NYS Mesonet sites was 40.0%\n", "The mean RH in the past hour for all NYS Mesonet sites was 70.5%\n" ] } ], "source": [ "print(f\"The maximum RH in the past hour for all NYS Mesonet sites was {rh.max():.1f}%\")\n", "print(f\"The minimum RH in the past hour for all NYS Mesonet sites was {rh.min():.1f}%\")\n", "print(f\"The mean RH in the past hour for all NYS Mesonet sites was {rh.mean():.1f}%\")" ] }, { "cell_type": "code", "execution_count": 8, "id": "0c60ef31-8ea5-4d9d-8673-f4e2e6571d9d", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The maximum 5-minute precip in the past hour for all NYS Mesonet sites was 0.01 in.\n", "\n", "The maximum 24-hour precip in the past hour for all NYS Mesonet sites was 1.57 in.\n" ] } ], "source": [ "print(f\"The maximum 5-minute precip in the past hour for all NYS Mesonet sites was {prcp.max():.2f} in.\")\n", "print ()\n", "print(f\"The maximum 24-hour precip in the past hour for all NYS Mesonet sites was {pDay.max():.2f} in.\")" ] }, { "cell_type": "code", "execution_count": 9, "id": "94c11639-3480-44c8-ab23-20f6d9aeb002", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The maximum 5-minute peak wind speed for all NYS Mesonet sites was 31.3 kts\n", "The minimum 5-minute peak wind speed for all NYS Mesonet sites was 1.6 kts\n", "The mean 5-minute peak wind speed for all NYS Mesonet sites was 10.4 kts\n" ] } ], "source": [ "print(f\"The maximum 5-minute peak wind speed for all NYS Mesonet sites was {pkwd.max():.1f} kts\")\n", "print(f\"The minimum 5-minute peak wind speed for all NYS Mesonet sites was {pkwd.min():.1f} kts\") \n", "print(f\"The mean 5-minute peak wind speed for all NYS Mesonet sites was {pkwd.mean():.1f} kts\") " ] }, { "cell_type": "markdown", "id": "15405b2a-8483-4263-b181-6ea91c50ad4a", "metadata": {}, "source": [ "### Part e:\n", "```\n", "Output a dataframe that contains only those rows in the original dataframe that had non-zero snow depth.\n", "```" ] }, { "cell_type": "code", "execution_count": 10, "id": "fac9fed6-376e-4a74-878e-71fd1d8da7d7", "metadata": { "tags": [] }, "outputs": [], "source": [ "sdpt = df['snow_depth [cm]']\n", "sdpt = sdpt > 0.0 # Some sites, due to settling of the ground, may report negative values!" ] }, { "cell_type": "code", "execution_count": 11, "id": "0e08068a-eb16-4e0c-8b93-0dc74dbbeabe", "metadata": { "tags": [] }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
stationtemp_2m [degC]temp_9m [degC]relative_humidity [percent]precip_incremental [mm]precip_local [mm]precip_max_intensity [mm/min]avg_wind_speed_prop [m/s]max_wind_speed_prop [m/s]wind_speed_stddev_prop [m/s]...snow_depth [cm]frozen_soil_05cm [bit]frozen_soil_25cm [bit]frozen_soil_50cm [bit]soil_temp_05cm [degC]soil_temp_25cm [degC]soil_temp_50cm [degC]soil_moisture_05cm [m^3/m^3]soil_moisture_25cm [m^3/m^3]soil_moisture_50cm [m^3/m^3]
time
2023-04-06 16:10:00 UTCANDE18.317.972.00.02.760.02.94.80.6...1.00.00.00.08.16.76.10.270.170.15
2023-04-06 16:05:00 UTCBATA9.79.263.50.06.500.07.910.31.1...1.00.00.00.09.67.76.30.340.280.30
2023-04-06 16:35:00 UTCBATA9.79.261.80.06.500.07.110.11.3...1.00.00.00.09.67.76.30.340.280.29
2023-04-06 15:55:00 UTCBEAC18.817.372.30.00.290.02.65.31.0...1.00.00.00.010.88.17.80.280.250.21
2023-04-06 16:00:00 UTCBEAC19.017.972.40.00.290.03.24.30.7...1.00.00.00.011.08.27.80.280.250.21
..................................................................
2023-04-06 16:35:00 UTCWGAT6.99.065.60.05.190.00.92.50.5...1.00.00.00.00.10.20.60.210.300.13
2023-04-06 16:40:00 UTCWGAT6.68.768.60.05.190.00.92.80.6...1.00.00.00.00.10.20.50.210.300.13
2023-04-06 16:45:00 UTCWGAT6.58.668.40.05.190.00.71.30.3...1.00.00.00.00.10.20.60.210.300.12
2023-04-06 16:50:00 UTCWGAT6.78.767.90.05.190.00.61.50.3...1.00.00.00.00.10.20.60.210.300.12
2023-04-06 16:55:00 UTCWGAT7.08.667.40.05.190.00.82.30.5...1.00.00.00.00.10.20.60.210.300.13
\n", "

455 rows × 29 columns

\n", "
" ], "text/plain": [ " station temp_2m [degC] temp_9m [degC] \\\n", "time \n", "2023-04-06 16:10:00 UTC ANDE 18.3 17.9 \n", "2023-04-06 16:05:00 UTC BATA 9.7 9.2 \n", "2023-04-06 16:35:00 UTC BATA 9.7 9.2 \n", "2023-04-06 15:55:00 UTC BEAC 18.8 17.3 \n", "2023-04-06 16:00:00 UTC BEAC 19.0 17.9 \n", "... ... ... ... \n", "2023-04-06 16:35:00 UTC WGAT 6.9 9.0 \n", "2023-04-06 16:40:00 UTC WGAT 6.6 8.7 \n", "2023-04-06 16:45:00 UTC WGAT 6.5 8.6 \n", "2023-04-06 16:50:00 UTC WGAT 6.7 8.7 \n", "2023-04-06 16:55:00 UTC WGAT 7.0 8.6 \n", "\n", " relative_humidity [percent] precip_incremental [mm] \\\n", "time \n", "2023-04-06 16:10:00 UTC 72.0 0.0 \n", "2023-04-06 16:05:00 UTC 63.5 0.0 \n", "2023-04-06 16:35:00 UTC 61.8 0.0 \n", "2023-04-06 15:55:00 UTC 72.3 0.0 \n", "2023-04-06 16:00:00 UTC 72.4 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 65.6 0.0 \n", "2023-04-06 16:40:00 UTC 68.6 0.0 \n", "2023-04-06 16:45:00 UTC 68.4 0.0 \n", "2023-04-06 16:50:00 UTC 67.9 0.0 \n", "2023-04-06 16:55:00 UTC 67.4 0.0 \n", "\n", " precip_local [mm] precip_max_intensity [mm/min] \\\n", "time \n", "2023-04-06 16:10:00 UTC 2.76 0.0 \n", "2023-04-06 16:05:00 UTC 6.50 0.0 \n", "2023-04-06 16:35:00 UTC 6.50 0.0 \n", "2023-04-06 15:55:00 UTC 0.29 0.0 \n", "2023-04-06 16:00:00 UTC 0.29 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 5.19 0.0 \n", "2023-04-06 16:40:00 UTC 5.19 0.0 \n", "2023-04-06 16:45:00 UTC 5.19 0.0 \n", "2023-04-06 16:50:00 UTC 5.19 0.0 \n", "2023-04-06 16:55:00 UTC 5.19 0.0 \n", "\n", " avg_wind_speed_prop [m/s] max_wind_speed_prop [m/s] \\\n", "time \n", "2023-04-06 16:10:00 UTC 2.9 4.8 \n", "2023-04-06 16:05:00 UTC 7.9 10.3 \n", "2023-04-06 16:35:00 UTC 7.1 10.1 \n", "2023-04-06 15:55:00 UTC 2.6 5.3 \n", "2023-04-06 16:00:00 UTC 3.2 4.3 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.9 2.5 \n", "2023-04-06 16:40:00 UTC 0.9 2.8 \n", "2023-04-06 16:45:00 UTC 0.7 1.3 \n", "2023-04-06 16:50:00 UTC 0.6 1.5 \n", "2023-04-06 16:55:00 UTC 0.8 2.3 \n", "\n", " wind_speed_stddev_prop [m/s] ... snow_depth [cm] \\\n", "time ... \n", "2023-04-06 16:10:00 UTC 0.6 ... 1.0 \n", "2023-04-06 16:05:00 UTC 1.1 ... 1.0 \n", "2023-04-06 16:35:00 UTC 1.3 ... 1.0 \n", "2023-04-06 15:55:00 UTC 1.0 ... 1.0 \n", "2023-04-06 16:00:00 UTC 0.7 ... 1.0 \n", "... ... ... ... \n", "2023-04-06 16:35:00 UTC 0.5 ... 1.0 \n", "2023-04-06 16:40:00 UTC 0.6 ... 1.0 \n", "2023-04-06 16:45:00 UTC 0.3 ... 1.0 \n", "2023-04-06 16:50:00 UTC 0.3 ... 1.0 \n", "2023-04-06 16:55:00 UTC 0.5 ... 1.0 \n", "\n", " frozen_soil_05cm [bit] frozen_soil_25cm [bit] \\\n", "time \n", "2023-04-06 16:10:00 UTC 0.0 0.0 \n", "2023-04-06 16:05:00 UTC 0.0 0.0 \n", "2023-04-06 16:35:00 UTC 0.0 0.0 \n", "2023-04-06 15:55:00 UTC 0.0 0.0 \n", "2023-04-06 16:00:00 UTC 0.0 0.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.0 0.0 \n", "2023-04-06 16:40:00 UTC 0.0 0.0 \n", "2023-04-06 16:45:00 UTC 0.0 0.0 \n", "2023-04-06 16:50:00 UTC 0.0 0.0 \n", "2023-04-06 16:55:00 UTC 0.0 0.0 \n", "\n", " frozen_soil_50cm [bit] soil_temp_05cm [degC] \\\n", "time \n", "2023-04-06 16:10:00 UTC 0.0 8.1 \n", "2023-04-06 16:05:00 UTC 0.0 9.6 \n", "2023-04-06 16:35:00 UTC 0.0 9.6 \n", "2023-04-06 15:55:00 UTC 0.0 10.8 \n", "2023-04-06 16:00:00 UTC 0.0 11.0 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.0 0.1 \n", "2023-04-06 16:40:00 UTC 0.0 0.1 \n", "2023-04-06 16:45:00 UTC 0.0 0.1 \n", "2023-04-06 16:50:00 UTC 0.0 0.1 \n", "2023-04-06 16:55:00 UTC 0.0 0.1 \n", "\n", " soil_temp_25cm [degC] soil_temp_50cm [degC] \\\n", "time \n", "2023-04-06 16:10:00 UTC 6.7 6.1 \n", "2023-04-06 16:05:00 UTC 7.7 6.3 \n", "2023-04-06 16:35:00 UTC 7.7 6.3 \n", "2023-04-06 15:55:00 UTC 8.1 7.8 \n", "2023-04-06 16:00:00 UTC 8.2 7.8 \n", "... ... ... \n", "2023-04-06 16:35:00 UTC 0.2 0.6 \n", "2023-04-06 16:40:00 UTC 0.2 0.5 \n", "2023-04-06 16:45:00 UTC 0.2 0.6 \n", "2023-04-06 16:50:00 UTC 0.2 0.6 \n", "2023-04-06 16:55:00 UTC 0.2 0.6 \n", "\n", " soil_moisture_05cm [m^3/m^3] \\\n", "time \n", "2023-04-06 16:10:00 UTC 0.27 \n", "2023-04-06 16:05:00 UTC 0.34 \n", "2023-04-06 16:35:00 UTC 0.34 \n", "2023-04-06 15:55:00 UTC 0.28 \n", "2023-04-06 16:00:00 UTC 0.28 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.21 \n", "2023-04-06 16:40:00 UTC 0.21 \n", "2023-04-06 16:45:00 UTC 0.21 \n", "2023-04-06 16:50:00 UTC 0.21 \n", "2023-04-06 16:55:00 UTC 0.21 \n", "\n", " soil_moisture_25cm [m^3/m^3] \\\n", "time \n", "2023-04-06 16:10:00 UTC 0.17 \n", "2023-04-06 16:05:00 UTC 0.28 \n", "2023-04-06 16:35:00 UTC 0.28 \n", "2023-04-06 15:55:00 UTC 0.25 \n", "2023-04-06 16:00:00 UTC 0.25 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.30 \n", "2023-04-06 16:40:00 UTC 0.30 \n", "2023-04-06 16:45:00 UTC 0.30 \n", "2023-04-06 16:50:00 UTC 0.30 \n", "2023-04-06 16:55:00 UTC 0.30 \n", "\n", " soil_moisture_50cm [m^3/m^3] \n", "time \n", "2023-04-06 16:10:00 UTC 0.15 \n", "2023-04-06 16:05:00 UTC 0.30 \n", "2023-04-06 16:35:00 UTC 0.29 \n", "2023-04-06 15:55:00 UTC 0.21 \n", "2023-04-06 16:00:00 UTC 0.21 \n", "... ... \n", "2023-04-06 16:35:00 UTC 0.13 \n", "2023-04-06 16:40:00 UTC 0.13 \n", "2023-04-06 16:45:00 UTC 0.12 \n", "2023-04-06 16:50:00 UTC 0.12 \n", "2023-04-06 16:55:00 UTC 0.13 \n", "\n", "[455 rows x 29 columns]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[sdpt]" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 August 2022 Environment", "language": "python", "name": "aug22" }, "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.10.5" } }, "nbformat": 4, "nbformat_minor": 5 }