{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt\n" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "# Load the data\n", "data_fp = '/uufs/chpc.utah.edu/common/home/u0035056/public_html/monsoon_SW_Utah/data/'\n", "pwat_anl = pd.read_json(data_fp+'hrrr_PWAT_anl_daily_avg_2023.json', typ='series')\n", "pwat_fcst = pd.read_json(data_fp+'hrrr_PWAT_midnight_fcst_daily_avg_2023.json', typ='series')\n", "\n", "cape_anl = pd.read_json(data_fp+'hrrr_CAPE_anl_daily_max_2023.json', typ='series')\n", "cape_fcst = pd.read_json(data_fp+'hrrr_CAPE_midnight_fcst_daily_max_2023.json', typ='series')\n", "\n", "anl_vars_all = pd.concat({'PWAT': pwat_anl, 'CAPE': cape_anl}, axis=1)\n", "fcst_vars_all = pd.concat({'PWAT':pwat_fcst, 'CAPE': cape_fcst}, axis=1)\n", "\n", "anl_vars_all.reset_index(inplace=True)\n", "anl_vars_all = anl_vars_all.rename(columns = {'index':'DateTime'})\n", "anl_vars_all['Month/Day'] = anl_vars_all['DateTime'].dt.strftime('%m/%d')\n", "\n", "fcst_vars_all.reset_index(inplace=True)\n", "fcst_vars_all = fcst_vars_all.rename(columns = {'index':'DateTime'})\n", "fcst_vars_all['Month/Day'] = fcst_vars_all['DateTime'].dt.strftime('%m/%d')" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | DateTime | \n", "PWAT | \n", "CAPE | \n", "Month/Day | \n", "PWAT_norm | \n", "CAPE_norm | \n", "
---|---|---|---|---|---|---|
0 | \n", "2023-06-01 | \n", "1.046123 | \n", "265.455072 | \n", "06/01 | \n", "-0.453877 | \n", "-234.544928 | \n", "
1 | \n", "2023-06-02 | \n", "1.421242 | \n", "574.527536 | \n", "06/02 | \n", "-0.078758 | \n", "74.527536 | \n", "
2 | \n", "2023-06-03 | \n", "1.204992 | \n", "316.087923 | \n", "06/03 | \n", "-0.295008 | \n", "-183.912077 | \n", "
3 | \n", "2023-06-04 | \n", "1.248299 | \n", "278.333333 | \n", "06/04 | \n", "-0.251701 | \n", "-221.666667 | \n", "
4 | \n", "2023-06-05 | \n", "1.157553 | \n", "184.988406 | \n", "06/05 | \n", "-0.342447 | \n", "-315.011594 | \n", "
5 | \n", "2023-06-06 | \n", "0.795773 | \n", "130.711111 | \n", "06/06 | \n", "-0.704227 | \n", "-369.288889 | \n", "
6 | \n", "2023-06-07 | \n", "0.733909 | \n", "68.916908 | \n", "06/07 | \n", "-0.766091 | \n", "-431.083092 | \n", "
7 | \n", "2023-06-08 | \n", "0.927878 | \n", "104.540097 | \n", "06/08 | \n", "-0.572122 | \n", "-395.459903 | \n", "
8 | \n", "2023-06-09 | \n", "1.135871 | \n", "118.455072 | \n", "06/09 | \n", "-0.364129 | \n", "-381.544928 | \n", "
9 | \n", "2023-06-10 | \n", "1.033680 | \n", "64.967150 | \n", "06/10 | \n", "-0.466320 | \n", "-435.032850 | \n", "
10 | \n", "2023-06-11 | \n", "0.945768 | \n", "303.590338 | \n", "06/11 | \n", "-0.554232 | \n", "-196.409662 | \n", "
11 | \n", "2023-06-12 | \n", "1.339454 | \n", "439.785507 | \n", "06/12 | \n", "-0.160546 | \n", "-60.214493 | \n", "
12 | \n", "2023-06-13 | \n", "1.067861 | \n", "215.497585 | \n", "06/13 | \n", "-0.432139 | \n", "-284.502415 | \n", "