Generate_Program.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#  Combining Garmin and Clue data - Generate training program\n",
    "This script uses Garmin and Clue data to visualise running performance at the same time as menstrual data. Although Garmin has it's own menstrual calendar it is not possible to download this data or to see this data alongside performance information. If you want to track your own menstrual data rather than using an app create a csv file with a column of the dates you've had your period instead.\n",
    "\n",
    "You need three files for this script to run.\n",
    "* `Activities.csv` The CSV downloaded from Garmin connect when all activities are selected.\n",
    "* `Activities_running_only.csv` The CSV downloaded from Garmin connect when only running is slected. This will export more of the running statistics.\n",
    "* `clue_measurements.json` This is the `measurements.json` file created when you download data from the menstrual tracking app Clue. If you aren't using clue then you will need `period_dates.csv`, enter the dates in the format `YYYY-MM-DD`.\n",
    "\n",
    "To download from Garmin:\n",
    "1. Login to Garmin Connect.\n",
    "2. Sidebar select `Activities>All activities`.  \n",
    "3. Select either running or all activites. You will need both.\n",
    "4. Scroll down as far as the dates you want to include.\n",
    "5. Click `Export csv`.\n",
    "6. Move your csv file to the same place you've chosen your data (probably a directory where this script is saved.)\n",
    "\n",
    "To download from Clue:\n",
    "1. Open the Clue app\n",
    "2. Go to the More Menu (the = in the top-right corner of your Cycle View)\n",
    "3. Tap Settings\n",
    "4. Tap Download my data\n",
    "5. Tap Request data\n",
    "6. A screen will appear with a unique password to download the data file - copy this. You will probably want to send this to yourself as it's likely you'll run this script on a computer rather than phone. So paste->send->copy again.\n",
    "7. Open the email from Clue that was sent to your Clue email address\n",
    "8. The email will include a link to download the data file, which expires after 72 hours\n",
    "9. Tap Download data\n",
    "10. Extract the zip to the desired location.\n",
    "11. When you open the file enter the password. Save the `measurements` file as `clue_measurements`. The others can now be deleted.\n",
    "\n",
    "## What's the program?\n",
    "This program will use the training and menstrual data to generate a program based on the following:\n",
    "* Your prior training load and mileage.\n",
    "* Any previous dips around the cycle.\n",
    "* Restricting weekly increase to no more than 10% (on average over a block, accounting for down weeks).\n",
    "* Restricting long runs to no more than 50% of total weekly mileage. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import altair as alt\n",
    "import numpy as np\n",
    "import datetime as dt\n",
    "from IPython.display import display, Markdown\n",
    "from scipy import stats\n",
    "from datetime import timedelta\n",
    "import json\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Your inputs\n",
    "Input your HR zones and the name of the directory containing your data.\n",
    "\n",
    "## Heart rate zones\n",
    "To access your heart rate (HR) zones in the Garmin Connect app, you can do the following:\n",
    "1. Open the app\n",
    "2. Select More in the bottom right corner\n",
    "3. Select Garmin Devices\n",
    "4. Select your device\n",
    "5. Select User Settings, User Profile, or My Stats\n",
    "6. Select Heart Rate Zones or Heart Rate\n",
    "7. Customize your HR zones\n",
    "8. Select Done\n",
    "\n",
    "## Data directory\n",
    "* If your data directory is saved in the same place as this script then you can enter the name inside \\\" \\\". Include \"/\" at the end.\n",
    "* Prefix the directory with \"../\" if it's in the directory above. Use this as many times as you need to go up. \n",
    "* If your data isn't in a separate folder and is in the same place as the script then set to \\\"\\\".\n",
    "* If your data is in a completely different part of your system you can use an absolute path for example \\\"C:/User/name/data/\", this is NOT advised if you are going to be sharing this script. Include \"/\" at the end."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "hr_zones = [120,148, 165, 176, 185, 213]\n",
    "dir_name = \"my_data/\" # The name and path of the directory you have the data saved in."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Setup the Functions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Function for numbering Heartrate zones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {},
   "outputs": [],
   "source": [
    "def set_hr_zone(row, hr_zones):\n",
    "    hr = row[\"Avg HR\"]\n",
    "    if hr <hr_zones[0]: return 1\n",
    "    elif hr_zones[0] <= hr < hr_zones[1]: return 2\n",
    "    elif hr_zones[1] <= hr < hr_zones[2]: return 3\n",
    "    elif hr_zones[2]<= hr < hr_zones[3]: return 4\n",
    "    elif hr_zones[3] <= hr < hr_zones[4]: return 5\n",
    "    elif hr_zones[4]<= hr < hr_zones[5]: return 6\n",
    "    elif hr_zones[5]<= hr : return 6\n",
    "    else: return 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Function to convert `Elapsed Time` and `Duration` to integer number of seconds."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_del(row):\n",
    "    if \"Elapsed Time\" in row.index:\n",
    "        entry = row[\"Elapsed Time\"]\n",
    "    elif \"Duration\" in row.index:\n",
    "        entry = row[\"Duration\"]\n",
    "    else: raise(\"Duration column is missing, check csv files.\")\n",
    "    splits = entry.split(':')\n",
    "    if len(splits)>2:\n",
    "        h, m, s = splits\n",
    "        if \".\" in s:\n",
    "          s, _ = s.split('.')\n",
    "    elif len(splits)==2:\n",
    "        h = 0\n",
    "        m = splits[0]\n",
    "        if \".\" in s:\n",
    "          s, _ = s.split('.')\n",
    "    else: return dt.timedelta(hours=int(0), minutes=int(0), seconds=int(0)).total_seconds()\n",
    "    return dt.timedelta(hours=int(h), minutes=int(m), seconds=int(s)).total_seconds()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Set workout types based on day of the week"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_rtype_by_weekday(run_date):\n",
    "    if (run_date.weekday() == 0):\n",
    "        r_day = \"Mon\"\n",
    "        r_type = \"Gym\"\n",
    "    elif (run_date.weekday() == 1):\n",
    "        r_day = \"Tue\"\n",
    "        r_type = \"Intervals\"\n",
    "    elif (run_date.weekday() == 2):\n",
    "        r_day = \"Wed\"\n",
    "        r_type = \"rest\"\n",
    "    elif (run_date.weekday() == 3):\n",
    "        r_day = \"Thur\"\n",
    "        r_type = \"Intervals\"\n",
    "    elif (run_date.weekday() == 4):\n",
    "        r_day = \"Fri\"\n",
    "        r_type = \"Gym\"\n",
    "    elif (run_date.weekday() == 5):\n",
    "        r_day = \"Sat\"\n",
    "        r_type = \"rest\"\n",
    "    elif (run_date.weekday() == 6):\n",
    "        r_day = \"Sun\"\n",
    "        r_type = \"Long_run\"\n",
    "    return ({\"day\" : r_day, \"r_type\": r_type})\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Set the distance based on type of run"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_dist_by_type(r_type, week_dist, long_dist):\n",
    "    if r_type == \"Long_run\": \n",
    "        r_dist = long_dist\n",
    "    elif r_type == \"Intervals\":\n",
    "        r_dist = (week_dist - long_dist)/2\n",
    "    else: r_dist = 0\n",
    "    return(r_dist)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find the date of the next Monday"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [],
   "source": [
    "def reset_date_next_mon(date):\n",
    "    day_week = date.weekday()\n",
    "    if day_week == 0: return(date)\n",
    "    elif day_week == 1: return(date+timedelta(days=6))\n",
    "    elif day_week == 2: return(date+timedelta(days=5))\n",
    "    elif day_week == 3: return(date+timedelta(days=4))\n",
    "    elif day_week == 4: return(date+timedelta(days=3))\n",
    "    elif day_week == 5: return(date+timedelta(days=2))\n",
    "    elif day_week == 6: return(date+timedelta(days=1))\n",
    "    return"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load Data\n",
    "## Load the activities data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Activity Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>Title</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Calories</th>\n",
       "      <th>Time</th>\n",
       "      <th>Avg HR</th>\n",
       "      <th>Max HR</th>\n",
       "      <th>Aerobic TE</th>\n",
       "      <th>...</th>\n",
       "      <th>Max Resp</th>\n",
       "      <th>Stress Change</th>\n",
       "      <th>Stress Start</th>\n",
       "      <th>Stress End</th>\n",
       "      <th>Avg Stress</th>\n",
       "      <th>Max Stress</th>\n",
       "      <th>Moving Time</th>\n",
       "      <th>Elapsed Time</th>\n",
       "      <th>Min Elevation</th>\n",
       "      <th>Max Elevation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-21 08:00:25</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>15.83</td>\n",
       "      <td>1,030</td>\n",
       "      <td>01:42:18</td>\n",
       "      <td>176</td>\n",
       "      <td>188</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>41</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>01:40:13</td>\n",
       "      <td>02:02:12</td>\n",
       "      <td>15</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>2024-07-17 20:59:15</td>\n",
       "      <td>False</td>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>0.00</td>\n",
       "      <td>58</td>\n",
       "      <td>00:20:06</td>\n",
       "      <td>88</td>\n",
       "      <td>124</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>00:20:06</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>2024-07-17 17:59:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>0.00</td>\n",
       "      <td>427</td>\n",
       "      <td>00:45:58</td>\n",
       "      <td>145</td>\n",
       "      <td>182</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>00:45:58</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cycling</td>\n",
       "      <td>2024-07-17 17:32:09</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Cycling</td>\n",
       "      <td>4.75</td>\n",
       "      <td>131</td>\n",
       "      <td>00:20:13</td>\n",
       "      <td>117</td>\n",
       "      <td>145</td>\n",
       "      <td>1.1</td>\n",
       "      <td>...</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:18:22</td>\n",
       "      <td>00:20:13</td>\n",
       "      <td>25</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cycling</td>\n",
       "      <td>2024-07-17 11:34:19</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Cycling</td>\n",
       "      <td>4.12</td>\n",
       "      <td>103</td>\n",
       "      <td>00:18:21</td>\n",
       "      <td>108</td>\n",
       "      <td>141</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:17:31</td>\n",
       "      <td>03:00:05</td>\n",
       "      <td>26</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>Walking</td>\n",
       "      <td>2023-08-22 17:03:03</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon Walking</td>\n",
       "      <td>2.61</td>\n",
       "      <td>155</td>\n",
       "      <td>00:40:42</td>\n",
       "      <td>81</td>\n",
       "      <td>108</td>\n",
       "      <td>0.4</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:37:58</td>\n",
       "      <td>00:40:42</td>\n",
       "      <td>22</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>Walking</td>\n",
       "      <td>2023-08-20 19:16:42</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon Walking</td>\n",
       "      <td>1.01</td>\n",
       "      <td>72</td>\n",
       "      <td>00:17:25</td>\n",
       "      <td>100</td>\n",
       "      <td>131</td>\n",
       "      <td>0.3</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:15:02</td>\n",
       "      <td>00:18:34</td>\n",
       "      <td>18</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-20 17:41:19</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon Running</td>\n",
       "      <td>9.52</td>\n",
       "      <td>662</td>\n",
       "      <td>01:27:29</td>\n",
       "      <td>141</td>\n",
       "      <td>166</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>37</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>01:19:33</td>\n",
       "      <td>01:27:29</td>\n",
       "      <td>15</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>Stand Up Paddleboarding</td>\n",
       "      <td>2023-08-19 13:56:30</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon Stand Up Paddleboarding</td>\n",
       "      <td>2.67</td>\n",
       "      <td>279</td>\n",
       "      <td>00:58:16</td>\n",
       "      <td>111</td>\n",
       "      <td>135</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:42:36</td>\n",
       "      <td>00:58:16</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>Strength Training</td>\n",
       "      <td>2023-08-19 10:35:44</td>\n",
       "      <td>False</td>\n",
       "      <td>post-run</td>\n",
       "      <td>0.00</td>\n",
       "      <td>82</td>\n",
       "      <td>00:23:57</td>\n",
       "      <td>98</td>\n",
       "      <td>124</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:18:37</td>\n",
       "      <td>00:23:57</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>595 rows × 58 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Activity Type                Date  Favorite  \\\n",
       "0                    Running 2024-07-21 08:00:25     False   \n",
       "1             Indoor Cycling 2024-07-17 20:59:15     False   \n",
       "2             Indoor Cycling 2024-07-17 17:59:00     False   \n",
       "3                    Cycling 2024-07-17 17:32:09     False   \n",
       "4                    Cycling 2024-07-17 11:34:19     False   \n",
       "..                       ...                 ...       ...   \n",
       "590                  Walking 2023-08-22 17:03:03     False   \n",
       "591                  Walking 2023-08-20 19:16:42     False   \n",
       "592                  Running 2023-08-20 17:41:19     False   \n",
       "593  Stand Up Paddleboarding 2023-08-19 13:56:30     False   \n",
       "594        Strength Training 2023-08-19 10:35:44     False   \n",
       "\n",
       "                                    Title Distance Calories      Time Avg HR  \\\n",
       "0    Bath and North East Somerset Running    15.83    1,030  01:42:18    176   \n",
       "1                          Indoor Cycling     0.00       58  00:20:06     88   \n",
       "2                          Indoor Cycling     0.00      427  00:45:58    145   \n",
       "3    Bath and North East Somerset Cycling     4.75      131  00:20:13    117   \n",
       "4    Bath and North East Somerset Cycling     4.12      103  00:18:21    108   \n",
       "..                                    ...      ...      ...       ...    ...   \n",
       "590                        Maldon Walking     2.61      155  00:40:42     81   \n",
       "591                        Maldon Walking     1.01       72  00:17:25    100   \n",
       "592                        Maldon Running     9.52      662  01:27:29    141   \n",
       "593        Maldon Stand Up Paddleboarding     2.67      279  00:58:16    111   \n",
       "594                              post-run     0.00       82  00:23:57     98   \n",
       "\n",
       "    Max HR Aerobic TE  ... Max Resp Stress Change Stress Start Stress End  \\\n",
       "0      188        4.4  ...       41            --           --         --   \n",
       "1      124        0.2  ...       17            --           --         --   \n",
       "2      182        3.3  ...       43            --           --         --   \n",
       "3      145        1.1  ...       --            --           --         --   \n",
       "4      141        0.5  ...       --            --           --         --   \n",
       "..     ...        ...  ...      ...           ...          ...        ...   \n",
       "590    108        0.4  ...       28            --           --         --   \n",
       "591    131        0.3  ...       29            --           --         --   \n",
       "592    166        3.0  ...       37            --           --         --   \n",
       "593    135        1.0  ...       --            --           --         --   \n",
       "594    124        0.2  ...       25            --           --         --   \n",
       "\n",
       "    Avg Stress Max Stress  Moving Time  Elapsed Time  Min Elevation  \\\n",
       "0           --         --     01:40:13      02:02:12             15   \n",
       "1           --         --     00:00:00      00:20:06             --   \n",
       "2           --         --     00:00:00      00:45:58             --   \n",
       "3           --         --     00:18:22      00:20:13             25   \n",
       "4           --         --     00:17:31      03:00:05             26   \n",
       "..         ...        ...          ...           ...            ...   \n",
       "590         --         --     00:37:58      00:40:42             22   \n",
       "591         --         --     00:15:02      00:18:34             18   \n",
       "592         --         --     01:19:33      01:27:29             15   \n",
       "593         --         --     00:42:36      00:58:16             --   \n",
       "594         --         --     00:18:37      00:23:57             --   \n",
       "\n",
       "     Max Elevation  \n",
       "0              186  \n",
       "1               --  \n",
       "2               --  \n",
       "3               51  \n",
       "4               53  \n",
       "..             ...  \n",
       "590             35  \n",
       "591             36  \n",
       "592             63  \n",
       "593             --  \n",
       "594             --  \n",
       "\n",
       "[595 rows x 58 columns]"
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "try: os.path.isfile(dir_name+ \"Activities.csv\")\n",
    "except: print(\"Activities.csv is not in the data directory. Check location and filename\")\n",
    "activities_df = pd.read_csv(dir_name+\"Activities.csv\", header = 0, parse_dates=[\"Date\"])\n",
    "activities_df.head(-5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load the running only activities data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Activity Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>Title</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Calories</th>\n",
       "      <th>Time</th>\n",
       "      <th>Avg HR</th>\n",
       "      <th>Max HR</th>\n",
       "      <th>Aerobic TE</th>\n",
       "      <th>...</th>\n",
       "      <th>Best Lap Time</th>\n",
       "      <th>Number of Laps</th>\n",
       "      <th>Max Temp</th>\n",
       "      <th>Avg Resp</th>\n",
       "      <th>Min Resp</th>\n",
       "      <th>Max Resp</th>\n",
       "      <th>Moving Time</th>\n",
       "      <th>Elapsed Time</th>\n",
       "      <th>Min Elevation</th>\n",
       "      <th>Max Elevation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-21 08:00:25</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>15.83</td>\n",
       "      <td>1,030</td>\n",
       "      <td>01:42:18</td>\n",
       "      <td>176</td>\n",
       "      <td>188</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>00:04:53.2</td>\n",
       "      <td>16</td>\n",
       "      <td>29.0</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>41</td>\n",
       "      <td>01:40:13</td>\n",
       "      <td>02:02:12</td>\n",
       "      <td>15</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-16 18:37:07</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>4.75</td>\n",
       "      <td>287</td>\n",
       "      <td>00:37:30</td>\n",
       "      <td>138</td>\n",
       "      <td>169</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>00:05:50.6</td>\n",
       "      <td>5</td>\n",
       "      <td>31.0</td>\n",
       "      <td>26</td>\n",
       "      <td>16</td>\n",
       "      <td>34</td>\n",
       "      <td>00:30:21</td>\n",
       "      <td>00:39:24</td>\n",
       "      <td>23</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-14 08:14:53</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>8.79</td>\n",
       "      <td>527</td>\n",
       "      <td>00:54:05</td>\n",
       "      <td>155</td>\n",
       "      <td>170</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>00:04:31.6</td>\n",
       "      <td>9</td>\n",
       "      <td>28.0</td>\n",
       "      <td>26</td>\n",
       "      <td>16</td>\n",
       "      <td>35</td>\n",
       "      <td>00:52:48</td>\n",
       "      <td>01:15:26</td>\n",
       "      <td>12</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-12 19:16:48</td>\n",
       "      <td>False</td>\n",
       "      <td>Wiltshire Running</td>\n",
       "      <td>9.66</td>\n",
       "      <td>620</td>\n",
       "      <td>00:57:05</td>\n",
       "      <td>169</td>\n",
       "      <td>188</td>\n",
       "      <td>3.6</td>\n",
       "      <td>...</td>\n",
       "      <td>00:03:54.3</td>\n",
       "      <td>10</td>\n",
       "      <td>23.0</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "      <td>41</td>\n",
       "      <td>00:56:59</td>\n",
       "      <td>00:57:05</td>\n",
       "      <td>52</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-11 19:30:12</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>4.38</td>\n",
       "      <td>297</td>\n",
       "      <td>00:34:38</td>\n",
       "      <td>148</td>\n",
       "      <td>171</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>00:02:05.8</td>\n",
       "      <td>5</td>\n",
       "      <td>28.0</td>\n",
       "      <td>26</td>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>00:34:22</td>\n",
       "      <td>00:35:27</td>\n",
       "      <td>34</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-18 09:03:35</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon Running</td>\n",
       "      <td>1.48</td>\n",
       "      <td>103</td>\n",
       "      <td>00:11:27</td>\n",
       "      <td>147</td>\n",
       "      <td>163</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>00:03:39.9</td>\n",
       "      <td>2</td>\n",
       "      <td>30.0</td>\n",
       "      <td>32</td>\n",
       "      <td>14</td>\n",
       "      <td>37</td>\n",
       "      <td>00:11:23</td>\n",
       "      <td>00:11:27</td>\n",
       "      <td>27</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-15 18:49:21</td>\n",
       "      <td>False</td>\n",
       "      <td>Maldon - HR efforts</td>\n",
       "      <td>5.87</td>\n",
       "      <td>395</td>\n",
       "      <td>00:43:24</td>\n",
       "      <td>155</td>\n",
       "      <td>179</td>\n",
       "      <td>3.1</td>\n",
       "      <td>...</td>\n",
       "      <td>00:00:51.0</td>\n",
       "      <td>12</td>\n",
       "      <td>29.0</td>\n",
       "      <td>31</td>\n",
       "      <td>21</td>\n",
       "      <td>38</td>\n",
       "      <td>00:43:22</td>\n",
       "      <td>00:43:24</td>\n",
       "      <td>15</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-13 11:51:14</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset - 12 miles + WU +...</td>\n",
       "      <td>23.71</td>\n",
       "      <td>1,607</td>\n",
       "      <td>03:00:43</td>\n",
       "      <td>164</td>\n",
       "      <td>183</td>\n",
       "      <td>4.6</td>\n",
       "      <td>...</td>\n",
       "      <td>00:00:15.1</td>\n",
       "      <td>37</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33</td>\n",
       "      <td>21</td>\n",
       "      <td>43</td>\n",
       "      <td>03:00:16</td>\n",
       "      <td>03:00:51</td>\n",
       "      <td>19</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-11 09:01:31</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset - Base</td>\n",
       "      <td>5.02</td>\n",
       "      <td>342</td>\n",
       "      <td>00:38:49</td>\n",
       "      <td>147</td>\n",
       "      <td>165</td>\n",
       "      <td>2.6</td>\n",
       "      <td>...</td>\n",
       "      <td>00:01:49.4</td>\n",
       "      <td>6</td>\n",
       "      <td>30.0</td>\n",
       "      <td>29</td>\n",
       "      <td>20</td>\n",
       "      <td>37</td>\n",
       "      <td>00:38:18</td>\n",
       "      <td>00:39:01</td>\n",
       "      <td>30</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>Running</td>\n",
       "      <td>2023-08-09 20:07:07</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset - out and back mi...</td>\n",
       "      <td>6.81</td>\n",
       "      <td>540</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>164</td>\n",
       "      <td>184</td>\n",
       "      <td>3.7</td>\n",
       "      <td>...</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>30</td>\n",
       "      <td>29.0</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>41</td>\n",
       "      <td>00:40:39</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>11</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>215 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Activity Type                Date  Favorite  \\\n",
       "0         Running 2024-07-21 08:00:25     False   \n",
       "1         Running 2024-07-16 18:37:07     False   \n",
       "2         Running 2024-07-14 08:14:53     False   \n",
       "3         Running 2024-07-12 19:16:48     False   \n",
       "4         Running 2024-07-11 19:30:12     False   \n",
       "..            ...                 ...       ...   \n",
       "210       Running 2023-08-18 09:03:35     False   \n",
       "211       Running 2023-08-15 18:49:21     False   \n",
       "212       Running 2023-08-13 11:51:14     False   \n",
       "213       Running 2023-08-11 09:01:31     False   \n",
       "214       Running 2023-08-09 20:07:07     False   \n",
       "\n",
       "                                                 Title  Distance Calories  \\\n",
       "0                 Bath and North East Somerset Running     15.83    1,030   \n",
       "1                 Bath and North East Somerset Running      4.75      287   \n",
       "2                 Bath and North East Somerset Running      8.79      527   \n",
       "3                                    Wiltshire Running      9.66      620   \n",
       "4                 Bath and North East Somerset Running      4.38      297   \n",
       "..                                                 ...       ...      ...   \n",
       "210                                     Maldon Running      1.48      103   \n",
       "211                                Maldon - HR efforts      5.87      395   \n",
       "212  Bath and North East Somerset - 12 miles + WU +...     23.71    1,607   \n",
       "213                Bath and North East Somerset - Base      5.02      342   \n",
       "214  Bath and North East Somerset - out and back mi...      6.81      540   \n",
       "\n",
       "         Time  Avg HR  Max HR  Aerobic TE  ...  Best Lap Time  Number of Laps  \\\n",
       "0    01:42:18     176     188         4.4  ...     00:04:53.2              16   \n",
       "1    00:37:30     138     169         2.3  ...     00:05:50.6               5   \n",
       "2    00:54:05     155     170         3.3  ...     00:04:31.6               9   \n",
       "3    00:57:05     169     188         3.6  ...     00:03:54.3              10   \n",
       "4    00:34:38     148     171         2.3  ...     00:02:05.8               5   \n",
       "..        ...     ...     ...         ...  ...            ...             ...   \n",
       "210  00:11:27     147     163         2.0  ...     00:03:39.9               2   \n",
       "211  00:43:24     155     179         3.1  ...     00:00:51.0              12   \n",
       "212  03:00:43     164     183         4.6  ...     00:00:15.1              37   \n",
       "213  00:38:49     147     165         2.6  ...     00:01:49.4               6   \n",
       "214  00:53:54     164     184         3.7  ...       00:00:30              30   \n",
       "\n",
       "    Max Temp Avg Resp  Min Resp Max Resp  Moving Time  Elapsed Time  \\\n",
       "0       29.0       34        17       41     01:40:13      02:02:12   \n",
       "1       31.0       26        16       34     00:30:21      00:39:24   \n",
       "2       28.0       26        16       35     00:52:48      01:15:26   \n",
       "3       23.0       32        21       41     00:56:59      00:57:05   \n",
       "4       28.0       26        11       35     00:34:22      00:35:27   \n",
       "..       ...      ...       ...      ...          ...           ...   \n",
       "210     30.0       32        14       37     00:11:23      00:11:27   \n",
       "211     29.0       31        21       38     00:43:22      00:43:24   \n",
       "212     31.0       33        21       43     03:00:16      03:00:51   \n",
       "213     30.0       29        20       37     00:38:18      00:39:01   \n",
       "214     29.0       33        20       41     00:40:39      00:53:54   \n",
       "\n",
       "     Min Elevation  Max Elevation  \n",
       "0               15            186  \n",
       "1               23             50  \n",
       "2               12             37  \n",
       "3               52            158  \n",
       "4               34            189  \n",
       "..             ...            ...  \n",
       "210             27             37  \n",
       "211             15             27  \n",
       "212             19             44  \n",
       "213             30             55  \n",
       "214             11             34  \n",
       "\n",
       "[215 rows x 39 columns]"
      ]
     },
     "execution_count": 186,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "try: os.path.isfile(dir_name+ \"Activities_running_only.csv\")\n",
    "except: raise(\"Activities_running_only.csv is not in the data directory. Check location and filename\")\n",
    "running_df = pd.read_csv(dir_name+\"Activities_running_only.csv\", header = 0, parse_dates=[\"Date\"])\n",
    "running_df.head(-5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load period data from Clue - JSON"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [],
   "source": [
    "try: period_df = pd.read_json(dir_name + \"clue_measurements.json\")\n",
    "except: \n",
    "    try: period_df = pd.read_csv(dir_name + \"period_dates.csv\")\n",
    "    except: print(\"No period data found. is not in the data directory. Check location and filename\")\n",
    "period_df = period_df[period_df.type=='period'].sort_values(by=\"date\")\n",
    "period_dates=period_df.date.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculate the length of each period.\n",
    "It is assumed that cycles are at least $18$ days and tracking between this is probably spotting."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Average cycle length is 31 with variance 27\n"
     ]
    }
   ],
   "source": [
    "cycle_lengths = {}\n",
    "ndates = len(period_dates)\n",
    "prior_p_date = period_dates[0]\n",
    "prior_date = period_dates[0]\n",
    "for i in range(ndates):\n",
    "    date = period_dates[i]\n",
    "    day_diff = (date-prior_p_date).days\n",
    "    if day_diff>18:\n",
    "        cycle_lengths[i] = {\n",
    "            'start_date':prior_p_date,\n",
    "            'end_date': date,\n",
    "            'cycle_length': day_diff}\n",
    "        prior_p_date = date\n",
    "cycle_df = pd.DataFrame(cycle_lengths).T\n",
    "cycle_df.sort_values(by=\"start_date\")\n",
    "cycle_df.start_date = pd.to_datetime(cycle_df.start_date)\n",
    "cycle_df.end_date = pd.to_datetime(cycle_df.end_date)\n",
    "cycle_df.cycle_length = pd.to_numeric(cycle_df.cycle_length)\n",
    "avg_cyc_leng = cycle_df.cycle_length.mean()\n",
    "cyc_var = cycle_df.cycle_length.var()\n",
    "print(\"Average cycle length is %d with variance %d\"%(avg_cyc_leng, cyc_var))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Set the data-type for the Date columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [],
   "source": [
    "activities_df[\"Date\"] = pd.to_datetime(activities_df[\"Date\"], dayfirst= True)\n",
    "running_df[\"Date\"] = pd.to_datetime(running_df[\"Date\"], dayfirst= True)\n",
    "period_dates = pd.to_datetime(period_dates, dayfirst= True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Combine and restucture the data\n",
    "## Add period data to activities and running dataframes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {},
   "outputs": [],
   "source": [
    "running_df['Period'] = 0\n",
    "activities_df['Period'] = 0\n",
    "running_df.loc[running_df.Date.dt.date.isin(period_dates.dt.date),'Period'] = 1\n",
    "activities_df.loc[activities_df.Date.dt.date.isin(period_dates.dt.date),'Period'] = 1\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get the running data\n",
    "### Extract data from the strings."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Activity Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>Title</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Calories</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Avg HR</th>\n",
       "      <th>Max HR</th>\n",
       "      <th>Aerobic TE</th>\n",
       "      <th>...</th>\n",
       "      <th>Avg Resp</th>\n",
       "      <th>Min Resp</th>\n",
       "      <th>Max Resp</th>\n",
       "      <th>Moving Time</th>\n",
       "      <th>Elapsed Time</th>\n",
       "      <th>Min Elevation</th>\n",
       "      <th>Max Elevation</th>\n",
       "      <th>Period</th>\n",
       "      <th>L_GCT Balance</th>\n",
       "      <th>R_GCT Balance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-21 08:00:25</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>15.83</td>\n",
       "      <td>1,030</td>\n",
       "      <td>01:42:18</td>\n",
       "      <td>176</td>\n",
       "      <td>188</td>\n",
       "      <td>4.4</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>41</td>\n",
       "      <td>01:40:13</td>\n",
       "      <td>02:02:12</td>\n",
       "      <td>15</td>\n",
       "      <td>186</td>\n",
       "      <td>0</td>\n",
       "      <td>0.507</td>\n",
       "      <td>0.507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-16 18:37:07</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>4.75</td>\n",
       "      <td>287</td>\n",
       "      <td>00:37:30</td>\n",
       "      <td>138</td>\n",
       "      <td>169</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>16</td>\n",
       "      <td>34</td>\n",
       "      <td>00:30:21</td>\n",
       "      <td>00:39:24</td>\n",
       "      <td>23</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0.500</td>\n",
       "      <td>0.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-14 08:14:53</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>8.79</td>\n",
       "      <td>527</td>\n",
       "      <td>00:54:05</td>\n",
       "      <td>155</td>\n",
       "      <td>170</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>16</td>\n",
       "      <td>35</td>\n",
       "      <td>00:52:48</td>\n",
       "      <td>01:15:26</td>\n",
       "      <td>12</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0.506</td>\n",
       "      <td>0.506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-12 19:16:48</td>\n",
       "      <td>False</td>\n",
       "      <td>Wiltshire Running</td>\n",
       "      <td>9.66</td>\n",
       "      <td>620</td>\n",
       "      <td>00:57:05</td>\n",
       "      <td>169</td>\n",
       "      <td>188</td>\n",
       "      <td>3.6</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "      <td>41</td>\n",
       "      <td>00:56:59</td>\n",
       "      <td>00:57:05</td>\n",
       "      <td>52</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>0.519</td>\n",
       "      <td>0.519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-11 19:30:12</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>4.38</td>\n",
       "      <td>297</td>\n",
       "      <td>00:34:38</td>\n",
       "      <td>148</td>\n",
       "      <td>171</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>00:34:22</td>\n",
       "      <td>00:35:27</td>\n",
       "      <td>34</td>\n",
       "      <td>189</td>\n",
       "      <td>1</td>\n",
       "      <td>0.498</td>\n",
       "      <td>0.498</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Activity Type                Date  Favorite  \\\n",
       "0       Running 2024-07-21 08:00:25     False   \n",
       "1       Running 2024-07-16 18:37:07     False   \n",
       "2       Running 2024-07-14 08:14:53     False   \n",
       "3       Running 2024-07-12 19:16:48     False   \n",
       "4       Running 2024-07-11 19:30:12     False   \n",
       "\n",
       "                                  Title  Distance Calories  Duration  Avg HR  \\\n",
       "0  Bath and North East Somerset Running     15.83    1,030  01:42:18     176   \n",
       "1  Bath and North East Somerset Running      4.75      287  00:37:30     138   \n",
       "2  Bath and North East Somerset Running      8.79      527  00:54:05     155   \n",
       "3                     Wiltshire Running      9.66      620  00:57:05     169   \n",
       "4  Bath and North East Somerset Running      4.38      297  00:34:38     148   \n",
       "\n",
       "   Max HR  Aerobic TE  ...  Avg Resp  Min Resp Max Resp Moving Time  \\\n",
       "0     188         4.4  ...        34        17       41    01:40:13   \n",
       "1     169         2.3  ...        26        16       34    00:30:21   \n",
       "2     170         3.3  ...        26        16       35    00:52:48   \n",
       "3     188         3.6  ...        32        21       41    00:56:59   \n",
       "4     171         2.3  ...        26        11       35    00:34:22   \n",
       "\n",
       "   Elapsed Time Min Elevation  Max Elevation  Period  L_GCT Balance  \\\n",
       "0      02:02:12            15            186       0          0.507   \n",
       "1      00:39:24            23             50       0          0.500   \n",
       "2      01:15:26            12             37       0          0.506   \n",
       "3      00:57:05            52            158       0          0.519   \n",
       "4      00:35:27            34            189       1          0.498   \n",
       "\n",
       "   R_GCT Balance  \n",
       "0          0.507  \n",
       "1          0.500  \n",
       "2          0.506  \n",
       "3          0.519  \n",
       "4          0.498  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "running_df.rename(columns = {\"Time\": \"Duration\"}, inplace= True)\n",
    "running_df[\"Distance\"] = pd.to_numeric(running_df[\"Distance\"])\n",
    "running_df[['L_GCT Balance', 'R_GCT Balance']] = running_df[\"Avg GCT Balance\"].str.split(\" / \", expand= True)\n",
    "running_df.loc[:,\"L_GCT Balance\"] = running_df.loc[:,\"L_GCT Balance\"].str.replace(r'\\D', '', regex=True)\n",
    "running_df.loc[:, \"R_GCT Balance\"] = running_df.loc[:,\"L_GCT Balance\"].str.replace(r'\\D', '', regex=True)\n",
    "col_list = ['Avg Stride Length', 'Avg Vertical Ratio', 'Avg Vertical Oscillation', 'Avg Run Cadence', \n",
    "            'Avg Ground Contact Time', \"L_GCT Balance\", \"R_GCT Balance\"]\n",
    "running_df[col_list] = running_df[col_list].apply(pd.to_numeric, errors='coerce')\n",
    "running_df[\"L_GCT Balance\"] = running_df[\"L_GCT Balance\"] / 1000\n",
    "running_df[\"R_GCT Balance\"] = running_df[\"R_GCT Balance\"] / 1000\n",
    "running_df[\"Date\"] = pd.to_datetime(running_df[\"Date\"], dayfirst=True, errors = \"coerce\")\n",
    "running_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Collect activities by date\n",
    "### Edit to match your own heart rate zones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [],
   "source": [
    "start_date = min(running_df.Date.min(),activities_df.Date.min())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate the total duration in seconds for further calculations."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [],
   "source": [
    "running_df[\"Duration_seconds\"]=running_df.apply(make_del, axis=1)\n",
    "running_df[\"Duration_minutes\"]=running_df.Duration_seconds%60\n",
    "activities_df[\"Duration_seconds\"]=activities_df.apply(make_del, axis=1)\n",
    "activities_df[\"Duration_minutes\"]=activities_df.Duration_seconds%60"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Set the heartrate zones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {},
   "outputs": [],
   "source": [
    "activities_df[\"Avg HR\"] = pd.to_numeric(activities_df[\"Avg HR\"], errors='coerce')\n",
    "activities_df[\"hr_zone\"] = activities_df.apply(set_hr_zone, hr_zones = hr_zones, axis = 1)\n",
    "activities_df['load'] = activities_df[\"Duration_minutes\"] * activities_df['Avg HR']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Activity Type', 'Date', 'Favorite', 'Title', 'Distance', 'Calories',\n",
       "       'Duration', 'Avg HR', 'Max HR', 'Aerobic TE', 'Avg Run Cadence',\n",
       "       'Max Run Cadence', 'Avg Pace', 'Best Pace', 'Total Ascent',\n",
       "       'Total Descent', 'Avg Stride Length', 'Avg Vertical Ratio',\n",
       "       'Avg Vertical Oscillation', 'Avg Ground Contact Time',\n",
       "       'Avg GCT Balance', 'Training Stress Score®', 'Grit', 'Flow',\n",
       "       'Avg. Swolf', 'Avg Stroke Rate', 'Total Reps', 'Min Temp',\n",
       "       'Decompression', 'Best Lap Time', 'Number of Laps', 'Max Temp',\n",
       "       'Avg Resp', 'Min Resp', 'Max Resp', 'Moving Time', 'Elapsed Time',\n",
       "       'Min Elevation', 'Max Elevation', 'Period', 'L_GCT Balance',\n",
       "       'R_GCT Balance', 'Duration_seconds', 'Duration_minutes'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "running_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {},
   "outputs": [],
   "source": [
    "running_df[\"Avg HR\"] = pd.to_numeric(running_df[\"Avg HR\"], errors='coerce')\n",
    "running_df[\"hr_zone\"] = running_df.apply(set_hr_zone, hr_zones = hr_zones, axis = 1)\n",
    "running_df['load'] = running_df[\"Duration_minutes\"] * running_df['Avg HR']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Day totals\n",
    "Calculate the total activity per day and the training load corresponding.\n",
    "Trianing load calculated using: $$\\text{load} = \\text{minutes of activity} * \\text{average heart rate}.$$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\4283971488.py:13: FutureWarning: The behavior of 'isin' with dtype=datetime64[ns] and castable values (e.g. strings) is deprecated. In a future version, these will not be considered matching by isin. Explicitly cast to the appropriate dtype before calling isin instead.\n",
      "  elif period_dates.isin(next_week.date).sum()>0:\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>run_dist</th>\n",
       "      <th>duration</th>\n",
       "      <th>duration_seconds</th>\n",
       "      <th>duration_minutes</th>\n",
       "      <th>load</th>\n",
       "      <th>Period</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-07-22 09:01:52</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-07-23 09:01:52</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-07-24 09:01:52</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-07-25 09:01:52</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-07-26 09:01:52</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date  run_dist duration  duration_seconds duration_minutes  \\\n",
       "0 2023-07-22 09:01:52       0.0        0               0.0              0.0   \n",
       "1 2023-07-23 09:01:52       0.0        0               0.0              0.0   \n",
       "2 2023-07-24 09:01:52       0.0        0               0.0              0.0   \n",
       "3 2023-07-25 09:01:52       0.0        0               0.0              0.0   \n",
       "4 2023-07-26 09:01:52       0.0        0               0.0              0.0   \n",
       "\n",
       "   load Period  \n",
       "0     0      1  \n",
       "1     0      1  \n",
       "2     0      0  \n",
       "3     0      0  \n",
       "4     0      0  "
      ]
     },
     "execution_count": 197,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#running_df.Date.dt.normalize(),start_date.date()\n",
    "date_format = \"%Y/%m/%d\"\n",
    "ndays = (dt.datetime.today()-start_date).days\n",
    "by_date = {}\n",
    "for i in range(ndays):\n",
    "    new_date = (start_date+timedelta(days=i))\n",
    "    next_date = (start_date+timedelta(days=i+7))\n",
    "    runs = running_df.loc[running_df.Date.dt.date==pd.Timestamp(new_date.date()).date()]\n",
    "    activities = activities_df[activities_df.Date.dt.date==pd.Timestamp(new_date.date()).date()]\n",
    "    next_week = pd.date_range(new_date, next_date, periods = 7)\n",
    "    if sum(period_dates==pd.Timestamp(new_date.date())):\n",
    "        period = 1\n",
    "    elif period_dates.isin(next_week.date).sum()>0:\n",
    "        period = 2\n",
    "    else:\n",
    "        period = 0\n",
    "    if len(activities)==0:\n",
    "        tot_dist=0\n",
    "        duration=0\n",
    "        load=0\n",
    "    else:\n",
    "        tot_dist = runs[\"Distance\"].sum()\n",
    "        duration = dt.timedelta(seconds=activities[\"Duration_seconds\"].sum())\n",
    "        load = activities.load.sum()\n",
    "    running_df.loc[running_df.Date.dt.date==pd.Timestamp(new_date.date()).date(),\"Period\"] = period\n",
    "    activities_df.loc[activities_df.Date.dt.date==pd.Timestamp(new_date.date()).date(),\"Period\"] = period\n",
    "    by_date[i] = {\n",
    "        'Date': new_date,\n",
    "        'run_dist': tot_dist,\n",
    "        'duration': duration,\n",
    "        'duration_seconds': activities[\"Duration_seconds\"].sum(),\n",
    "        'duration_minutes': activities[\"Duration_minutes\"].sum(),\n",
    "        'load': load,\n",
    "        'Period': period}\n",
    "overall_by_date_df = pd.DataFrame(by_date).T\n",
    "overall_by_date_df.Date = pd.to_datetime(overall_by_date_df.Date)\n",
    "overall_by_date_df.run_dist = pd.to_numeric(overall_by_date_df.run_dist)\n",
    "overall_by_date_df.duration_seconds = pd.to_numeric(overall_by_date_df.duration_seconds)\n",
    "overall_by_date_df.load = pd.to_numeric(overall_by_date_df.load)\n",
    "overall_by_date_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find the relationship between training load and run distance\n",
    "By finding the most common relationship between load and distance we can then create a proxy distance for none-running activities. We can then use this to create `proxy-distance` to aid coming back from injury. This also prevents over-training from additional activities.\n",
    "\n",
    "If there are more than 2 weeks with zero running then mileage will be adjusted based on previous running mileage. The `proxy-distance` will then be used to generate an alternative activity that will slowly reduce and readjust to running again. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {},
   "outputs": [],
   "source": [
    "running_df[\"coef\"]=running_df[\"Distance\"]/running_df[\"load\"]\n",
    "predict_coef = running_df[\"coef\"].median()\n",
    "overall_by_date_df[\"proxy_kms\"] = overall_by_date_df[\"load\"]*predict_coef\n",
    "activities_df[\"proxy_kms\"] = activities_df.load * predict_coef"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculate any change in load due to Luteal phase"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    2023-08-14 09:01:52\n",
       "1    2023-08-15 09:01:52\n",
       "2    2023-08-16 09:01:52\n",
       "3    2023-08-17 09:01:52\n",
       "4    2023-08-18 09:01:52\n",
       "             ...        \n",
       "71   2024-07-01 09:01:52\n",
       "72   2024-07-02 09:01:52\n",
       "73   2024-07-03 09:01:52\n",
       "74   2024-07-04 09:01:52\n",
       "75   2024-07-05 09:01:52\n",
       "Name: Date, Length: 76, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "luteal_decrease = {}\n",
    "luteal_dates = overall_by_date_df.loc[overall_by_date_df.Period == 2, \"Date\"]\n",
    "luteal_dates.reset_index(inplace=True, drop=True)\n",
    "luteal_dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Average luteal mileage decrease is -0.38 with variance 0.63\n",
      "Average luteal load decrease is -0.38 with variance 0.63\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\2611160795.py:28: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  luteal_df.start_date = pd.to_datetime(luteal_df.luteal_start_date)\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\2611160795.py:29: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  luteal_df.end_date = pd.to_datetime(luteal_df.luteal_end_date)\n",
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_33328\\2611160795.py:31: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  luteal_df.pload_diff = pd.to_numeric(luteal_df.load_diff)\n"
     ]
    }
   ],
   "source": [
    "ndates = len(luteal_dates)\n",
    "prior_p_date = luteal_dates.loc[0]\n",
    "for i in range(ndates):\n",
    "    date = luteal_dates[i]\n",
    "    day_diff = (date-prior_p_date).days\n",
    "    if day_diff>7:\n",
    "        previous_week = pd.date_range(date - timedelta(days=7), date, periods =7).date\n",
    "        this_week = pd.date_range(date, timedelta(days=7) + date, periods =7).date\n",
    "        pre_acts = overall_by_date_df[overall_by_date_df.Date.dt.date.isin(previous_week)]\n",
    "        this_acts = overall_by_date_df[overall_by_date_df.Date.dt.date.isin(this_week)]\n",
    "        if pre_acts.proxy_kms.sum()==0:\n",
    "            dist_diff = 0\n",
    "        else:\n",
    "            dist_diff = (pre_acts.proxy_kms.sum()- this_acts.proxy_kms.sum())/(pre_acts.proxy_kms.sum())\n",
    "        if pre_acts.load.sum()==0:\n",
    "            load_diff = 0\n",
    "        else:\n",
    "            load_diff = (pre_acts.load.sum()- this_acts.load.sum())/ (pre_acts.load.sum())\n",
    "        luteal_decrease[i]={\n",
    "            'luteal_start_date':date,\n",
    "            'luteal_end_date':date+timedelta(days=7),\n",
    "            'proxy_dist_diff':dist_diff,\n",
    "            'load_diff':load_diff\n",
    "        }\n",
    "        prior_p_date = date\n",
    "luteal_df = pd.DataFrame(luteal_decrease).T\n",
    "luteal_df.sort_values(by=\"luteal_start_date\")\n",
    "luteal_df.start_date = pd.to_datetime(luteal_df.luteal_start_date)\n",
    "luteal_df.end_date = pd.to_datetime(luteal_df.luteal_end_date)\n",
    "luteal_df.proxy_dist_diff = pd.to_numeric(luteal_df.proxy_dist_diff)\n",
    "luteal_df.pload_diff = pd.to_numeric(luteal_df.load_diff)\n",
    "avg_dist_diff = luteal_df.proxy_dist_diff.mean()\n",
    "dist_diff_var = luteal_df.proxy_dist_diff.var()\n",
    "avg_load_diff = luteal_df.load_diff.mean()\n",
    "load_diff_var = luteal_df.load_diff.var()\n",
    "print(\"Average luteal mileage decrease is %.2f with variance %.2f\"%(avg_dist_diff,dist_diff_var))\n",
    "print(\"Average luteal load decrease is %.2f with variance %.2f\"%(avg_load_diff,load_diff_var))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find the AVG Heartrate for not running activites\n",
    "Use the AVG HR to predict training load for non-running activities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Avg HR</th>\n",
       "      <th>Duration_minutes</th>\n",
       "      <th>hr_zone</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Activity Type</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Bouldering</th>\n",
       "      <td>104.333333</td>\n",
       "      <td>30.888889</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Breathwork</th>\n",
       "      <td>48.000000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cardio</th>\n",
       "      <td>129.574468</td>\n",
       "      <td>30.170213</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cycling</th>\n",
       "      <td>117.925234</td>\n",
       "      <td>29.850467</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elliptical</th>\n",
       "      <td>138.500000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIIT</th>\n",
       "      <td>114.705882</td>\n",
       "      <td>27.176471</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indoor Climbing</th>\n",
       "      <td>88.500000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indoor Cycling</th>\n",
       "      <td>130.125000</td>\n",
       "      <td>23.125000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Open Water Swimming</th>\n",
       "      <td>107.000000</td>\n",
       "      <td>28.833333</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other</th>\n",
       "      <td>84.090909</td>\n",
       "      <td>22.272727</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pilates</th>\n",
       "      <td>103.222222</td>\n",
       "      <td>35.222222</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pool Swim</th>\n",
       "      <td>124.333333</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Road Cycling</th>\n",
       "      <td>144.000000</td>\n",
       "      <td>23.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Running</th>\n",
       "      <td>154.170330</td>\n",
       "      <td>28.472527</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stand Up Paddleboarding</th>\n",
       "      <td>111.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Street Running</th>\n",
       "      <td>158.217391</td>\n",
       "      <td>33.173913</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strength Training</th>\n",
       "      <td>102.173913</td>\n",
       "      <td>25.942029</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trail Running</th>\n",
       "      <td>162.166667</td>\n",
       "      <td>28.166667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Virtual Cycling</th>\n",
       "      <td>133.428571</td>\n",
       "      <td>22.857143</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Walking</th>\n",
       "      <td>101.541667</td>\n",
       "      <td>34.666667</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yoga</th>\n",
       "      <td>79.803571</td>\n",
       "      <td>30.892857</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Avg HR  Duration_minutes  hr_zone\n",
       "Activity Type                                                 \n",
       "Bouldering               104.333333         30.888889        1\n",
       "Breathwork                48.000000         55.000000        1\n",
       "Cardio                   129.574468         30.170213        2\n",
       "Cycling                  117.925234         29.850467        1\n",
       "Elliptical               138.500000         30.500000        2\n",
       "HIIT                     114.705882         27.176471        1\n",
       "Indoor Climbing           88.500000         30.000000        1\n",
       "Indoor Cycling           130.125000         23.125000        2\n",
       "Open Water Swimming      107.000000         28.833333        1\n",
       "Other                     84.090909         22.272727        1\n",
       "Pilates                  103.222222         35.222222        1\n",
       "Pool Swim                124.333333         33.000000        2\n",
       "Road Cycling             144.000000         23.500000        2\n",
       "Running                  154.170330         28.472527        3\n",
       "Stand Up Paddleboarding  111.000000         16.000000        1\n",
       "Street Running           158.217391         33.173913        3\n",
       "Strength Training        102.173913         25.942029        1\n",
       "Trail Running            162.166667         28.166667        3\n",
       "Virtual Cycling          133.428571         22.857143        2\n",
       "Walking                  101.541667         34.666667        1\n",
       "Yoga                      79.803571         30.892857        1"
      ]
     },
     "execution_count": 201,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "act_mean_hrs = activities_df[['Activity Type','Avg HR','Duration_minutes']].groupby(by='Activity Type').mean()\n",
    "act_mean_hrs['hr_zone'] = act_mean_hrs.apply(set_hr_zone,hr_zones=hr_zones, axis=1)\n",
    "act_mean_hrs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Proxy distance for a strength session"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [],
   "source": [
    "sc_load = act_mean_hrs.loc['Strength Training', 'Duration_minutes']*act_mean_hrs.loc['Strength Training', 'Avg HR']\n",
    "sc_proxy_kms = sc_load * predict_coef"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Generate The future plan using the training data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "TO ADD: check the previous cycle for missing runs. If no runs have been had for more then 3 weeks then reduce the running distance and add in none running load."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "metadata": {},
   "outputs": [],
   "source": [
    "weeks_per_cycle = avg_cyc_leng%7\n",
    "last_date = overall_by_date_df.Date.dt.date.max()\n",
    "start_prev_block = pd.to_datetime(last_date-timedelta(days=7*weeks_per_cycle)).date()\n",
    "init_prox_week_dist = overall_by_date_df.loc[overall_by_date_df.Date.dt.date > start_prev_block ,\"proxy_kms\"].sum()/weeks_per_cycle\n",
    "init_load_tot = overall_by_date_df.loc[overall_by_date_df.Date.dt.date > start_prev_block,\"load\"].sum()/weeks_per_cycle\n",
    "init_long_dist = overall_by_date_df.loc[overall_by_date_df.Date.dt.date > start_prev_block,\"run_dist\"].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 289,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n",
      "59.549093572975174\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Week_No</th>\n",
       "      <th>Day</th>\n",
       "      <th>Date</th>\n",
       "      <th>Week_tot</th>\n",
       "      <th>Run_type</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Down_week</th>\n",
       "      <th>Percent_week_tot</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Mon</td>\n",
       "      <td>2024-07-22</td>\n",
       "      <td>36.710260</td>\n",
       "      <td>Top-up/ rest + Strength</td>\n",
       "      <td>3.766384</td>\n",
       "      <td>Y</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Tue</td>\n",
       "      <td>2024-07-23</td>\n",
       "      <td>36.710260</td>\n",
       "      <td>Workout</td>\n",
       "      <td>5.411180</td>\n",
       "      <td>Y</td>\n",
       "      <td>14.740240</td>\n",
       "      <td>Workout session, max dist 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Wed</td>\n",
       "      <td>2024-07-24</td>\n",
       "      <td>36.710260</td>\n",
       "      <td>Top-up/ rest + Strength</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Y</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Thur</td>\n",
       "      <td>2024-07-25</td>\n",
       "      <td>36.710260</td>\n",
       "      <td>Workout</td>\n",
       "      <td>5.411180</td>\n",
       "      <td>Y</td>\n",
       "      <td>14.740240</td>\n",
       "      <td>Workout session, max dist5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Fri</td>\n",
       "      <td>2024-07-26</td>\n",
       "      <td>36.710260</td>\n",
       "      <td>Top-up/ rest</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Y</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>19</td>\n",
       "      <td>Wed</td>\n",
       "      <td>2024-12-04</td>\n",
       "      <td>114.532769</td>\n",
       "      <td>Top-up/ rest + Strength</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>N</td>\n",
       "      <td>10.477351</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>19</td>\n",
       "      <td>Thur</td>\n",
       "      <td>2024-12-05</td>\n",
       "      <td>114.532769</td>\n",
       "      <td>Workout</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>N</td>\n",
       "      <td>10.477351</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>19</td>\n",
       "      <td>Fri</td>\n",
       "      <td>2024-12-06</td>\n",
       "      <td>114.532769</td>\n",
       "      <td>Top-up/ rest</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>N</td>\n",
       "      <td>10.477351</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>19</td>\n",
       "      <td>Sat</td>\n",
       "      <td>2024-12-07</td>\n",
       "      <td>114.532769</td>\n",
       "      <td>Top-up/ rest</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>N</td>\n",
       "      <td>10.477351</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>19</td>\n",
       "      <td>Sun</td>\n",
       "      <td>2024-12-08</td>\n",
       "      <td>114.532769</td>\n",
       "      <td>Long_run</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>N</td>\n",
       "      <td>30.558940</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Week_No   Day        Date    Week_tot                 Run_type  \\\n",
       "0          0   Mon  2024-07-22   36.710260  Top-up/ rest + Strength   \n",
       "1          0   Tue  2024-07-23   36.710260                  Workout   \n",
       "2          0   Wed  2024-07-24   36.710260  Top-up/ rest + Strength   \n",
       "3          0  Thur  2024-07-25   36.710260                  Workout   \n",
       "4          0   Fri  2024-07-26   36.710260             Top-up/ rest   \n",
       "..       ...   ...         ...         ...                      ...   \n",
       "135       19   Wed  2024-12-04  114.532769  Top-up/ rest + Strength   \n",
       "136       19  Thur  2024-12-05  114.532769                  Workout   \n",
       "137       19   Fri  2024-12-06  114.532769             Top-up/ rest   \n",
       "138       19   Sat  2024-12-07  114.532769             Top-up/ rest   \n",
       "139       19   Sun  2024-12-08  114.532769                 Long_run   \n",
       "\n",
       "      Distance Down_week  Percent_week_tot  \\\n",
       "0     3.766384         Y          0.000000   \n",
       "1     5.411180         Y         14.740240   \n",
       "2     0.000000         Y          0.000000   \n",
       "3     5.411180         Y         14.740240   \n",
       "4     0.000000         Y          0.000000   \n",
       "..         ...       ...               ...   \n",
       "135  12.000000         N         10.477351   \n",
       "136  12.000000         N         10.477351   \n",
       "137  12.000000         N         10.477351   \n",
       "138  12.000000         N         10.477351   \n",
       "139  35.000000         N         30.558940   \n",
       "\n",
       "                                           Description  \n",
       "0    max running dist: 0, Strength session, duratio...  \n",
       "1                          Workout session, max dist 5  \n",
       "2    max running dist: 0, Strength session, duratio...  \n",
       "3                           Workout session, max dist5  \n",
       "4                                Easy day, max dist: 0  \n",
       "..                                                 ...  \n",
       "135  max running dist: 12, Strength session, durati...  \n",
       "136                        Workout session, max dist12  \n",
       "137                             Easy day, max dist: 12  \n",
       "138                         Easy day, max distance: 12  \n",
       "139                                        Long run 35  \n",
       "\n",
       "[140 rows x 9 columns]"
      ]
     },
     "execution_count": 289,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tot_w = 20\n",
    "init_week_num = 0\n",
    "week_day_bound = 12 # Maximum distance on a week day. When max week_dist is met this will increase by 10%\n",
    "long_run_bound = 35 # Maximum distance for a long run. When max week_dist is met this will increase by 10%\n",
    "week_bound = 200 # Maximum distance per week. When max week_dist is met this will increase by 10%\n",
    "init_date = last_date + timedelta(days = 1)\n",
    "init_date = reset_date_next_mon(init_date)\n",
    "new_week_dist = init_prox_week_dist\n",
    "long_dist = init_long_dist\n",
    "new_date = init_date\n",
    "week_no = init_week_num\n",
    "DW = \"N\"\n",
    "list_dict = []\n",
    "for nd in range(tot_w):\n",
    "    # Check if down_week\n",
    "    print(init_prox_week_dist)\n",
    "    if nd%weeks_per_cycle==0:\n",
    "        mul = 1+avg_load_diff\n",
    "        DW = \"Y\"\n",
    "    else:\n",
    "        mul = 1.1\n",
    "        DW = \"N\"\n",
    "    if new_week_dist * mul >= week_bound:\n",
    "        new_week_dist = week_bound\n",
    "        week_bound *= 1.1\n",
    "        long_run_bound *= 1.1\n",
    "        week_day_bound *= 1.1\n",
    "        mul = 1.0\n",
    "    new_week_dist *= mul\n",
    "    long_dist *= mul\n",
    "    # Set default distances for the overflow days\n",
    "    mon_dist = 0\n",
    "    wed_dist = 0\n",
    "    fri_dist = 0\n",
    "    sat_dist = 0\n",
    "    # Add Sun\n",
    "    sun_dist = min(0.5*new_week_dist, long_run_bound)\n",
    "    wd_dist = (new_week_dist-sun_dist-2*sc_proxy_kms)*0.5\n",
    "    tue_dist = min(wd_dist, week_day_bound)\n",
    "    thur_dist = min(wd_dist,week_day_bound)\n",
    "    extra_dist = max(new_week_dist - 2*sc_proxy_kms - tue_dist - thur_dist - sun_dist,0)\n",
    "    if extra_dist < week_day_bound:\n",
    "        sat_dist = extra_dist\n",
    "    elif week_day_bound <= extra_dist < 2* week_day_bound:\n",
    "        fri_dist = 0.5*extra_dist\n",
    "        sat_dist = 0.5*extra_dist\n",
    "    elif 2*week_day_bound <= extra_dist < 3* week_day_bound:\n",
    "        mon_dist = extra_dist/3\n",
    "        fri_dist = extra_dist/3\n",
    "        sat_dist = extra_dist/3\n",
    "    elif 3*week_day_bound <= extra_dist:\n",
    "        mon_dist = min(extra_dist*0.25,week_day_bound)\n",
    "        wed_dist = min(extra_dist*0.25,week_day_bound)\n",
    "        fri_dist = min(extra_dist*0.25,week_day_bound)\n",
    "        sat_dist = min(extra_dist*0.25,week_day_bound)\n",
    "    new_week_dist = sum([2*sc_proxy_kms,mon_dist, tue_dist,wed_dist,thur_dist,fri_dist,sat_dist, sun_dist])\n",
    "    mon_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Mon\",\n",
    "        \"Date\": new_date,\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Top-up/ rest + Strength\",\n",
    "        \"Distance\": mon_dist+sc_proxy_kms,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*mon_dist/new_week_dist,\n",
    "        \"Description\": \"max running dist: %d, Strength session, duration %d mins\"%(mon_dist,act_mean_hrs.loc['Strength Training', 'Duration_minutes'])\n",
    "        }\n",
    "    tue_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Tue\",\n",
    "        \"Date\": new_date + timedelta(days=1),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Workout\",\n",
    "        \"Distance\": tue_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*tue_dist/new_week_dist,\n",
    "        \"Description\": \"Workout session, max dist %d\"%tue_dist\n",
    "        }\n",
    "    wed_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Wed\",\n",
    "        \"Date\": new_date + timedelta(days=2),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Top-up/ rest + Strength\",\n",
    "        \"Distance\": wed_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*wed_dist/new_week_dist,\n",
    "        \"Description\": \"max running dist: %d, Strength session, duration %d mins\"%(wed_dist,act_mean_hrs.loc['Strength Training', 'Duration_minutes'])\n",
    "        }\n",
    "    thur_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Thur\",\n",
    "        \"Date\": new_date + timedelta(days=3),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Workout\",\n",
    "        \"Distance\": thur_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*thur_dist/new_week_dist,\n",
    "        \"Description\": \"Workout session, max dist%d\"%thur_dist\n",
    "        }\n",
    "    fri_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Fri\",\n",
    "        \"Date\": new_date + timedelta(days=4),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Top-up/ rest\",\n",
    "        \"Distance\": fri_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*fri_dist/new_week_dist,\n",
    "        \"Description\": \"Easy day, max dist: %d\"%fri_dist\n",
    "        }\n",
    "    sat_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Sat\",\n",
    "        \"Date\": new_date + timedelta(days=5),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Top-up/ rest\",\n",
    "        \"Distance\": sat_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*sat_dist/new_week_dist,\n",
    "        \"Description\": \"Easy day, max distance: %d\"%sat_dist\n",
    "        }\n",
    "    sun_dict =  {\n",
    "        \"Week_No\": week_no,\n",
    "        \"Day\": \"Sun\",\n",
    "        \"Date\": new_date + timedelta(days=6),\n",
    "        \"Week_tot\": new_week_dist,\n",
    "        \"Run_type\": \"Long_run\",\n",
    "        \"Distance\": sun_dist,\n",
    "        \"Down_week\": DW,\n",
    "        \"Percent_week_tot\": 100*sun_dist/new_week_dist,\n",
    "        \"Description\": \"Long run %d\"%sun_dist\n",
    "        }\n",
    "    list_dict += [ mon_dict, tue_dict, wed_dict, thur_dict, fri_dict, sat_dict, sun_dict]\n",
    "    week_no+=1\n",
    "    new_date +=timedelta(days = 7)\n",
    "plan_df = pd.DataFrame(list_dict)\n",
    "plan_df\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Day</th>\n",
       "      <th>Mon</th>\n",
       "      <th>Tue</th>\n",
       "      <th>Wed</th>\n",
       "      <th>Thur</th>\n",
       "      <th>Fri</th>\n",
       "      <th>Sat</th>\n",
       "      <th>Sun</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Week_No</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 5</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist5</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 6</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist6</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 7</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist7</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 8</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist8</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 9</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist9</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 11</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist11</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 0</td>\n",
       "      <td>Long run 32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 0</td>\n",
       "      <td>Easy day, max distance: 5</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 6</td>\n",
       "      <td>Easy day, max distance: 6</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 10</td>\n",
       "      <td>Easy day, max distance: 10</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>max running dist: 9, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 0, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 9</td>\n",
       "      <td>Easy day, max distance: 9</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>max running dist: 9, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 9, Strength session, duratio...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 9</td>\n",
       "      <td>Easy day, max distance: 9</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist 12</td>\n",
       "      <td>max running dist: 12, Strength session, durati...</td>\n",
       "      <td>Workout session, max dist12</td>\n",
       "      <td>Easy day, max dist: 12</td>\n",
       "      <td>Easy day, max distance: 12</td>\n",
       "      <td>Long run 35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Day                                                    Mon  \\\n",
       "Week_No                                                      \n",
       "0        max running dist: 0, Strength session, duratio...   \n",
       "1        max running dist: 0, Strength session, duratio...   \n",
       "2        max running dist: 0, Strength session, duratio...   \n",
       "3        max running dist: 0, Strength session, duratio...   \n",
       "4        max running dist: 0, Strength session, duratio...   \n",
       "5        max running dist: 0, Strength session, duratio...   \n",
       "6        max running dist: 0, Strength session, duratio...   \n",
       "7        max running dist: 0, Strength session, duratio...   \n",
       "8        max running dist: 0, Strength session, duratio...   \n",
       "9        max running dist: 0, Strength session, duratio...   \n",
       "10       max running dist: 9, Strength session, duratio...   \n",
       "11       max running dist: 9, Strength session, duratio...   \n",
       "12       max running dist: 12, Strength session, durati...   \n",
       "13       max running dist: 12, Strength session, durati...   \n",
       "14       max running dist: 12, Strength session, durati...   \n",
       "15       max running dist: 12, Strength session, durati...   \n",
       "16       max running dist: 12, Strength session, durati...   \n",
       "17       max running dist: 12, Strength session, durati...   \n",
       "18       max running dist: 12, Strength session, durati...   \n",
       "19       max running dist: 12, Strength session, durati...   \n",
       "\n",
       "Day                               Tue  \\\n",
       "Week_No                                 \n",
       "0         Workout session, max dist 5   \n",
       "1         Workout session, max dist 6   \n",
       "2         Workout session, max dist 7   \n",
       "3         Workout session, max dist 8   \n",
       "4         Workout session, max dist 9   \n",
       "5        Workout session, max dist 11   \n",
       "6        Workout session, max dist 12   \n",
       "7        Workout session, max dist 12   \n",
       "8        Workout session, max dist 12   \n",
       "9        Workout session, max dist 12   \n",
       "10       Workout session, max dist 12   \n",
       "11       Workout session, max dist 12   \n",
       "12       Workout session, max dist 12   \n",
       "13       Workout session, max dist 12   \n",
       "14       Workout session, max dist 12   \n",
       "15       Workout session, max dist 12   \n",
       "16       Workout session, max dist 12   \n",
       "17       Workout session, max dist 12   \n",
       "18       Workout session, max dist 12   \n",
       "19       Workout session, max dist 12   \n",
       "\n",
       "Day                                                    Wed  \\\n",
       "Week_No                                                      \n",
       "0        max running dist: 0, Strength session, duratio...   \n",
       "1        max running dist: 0, Strength session, duratio...   \n",
       "2        max running dist: 0, Strength session, duratio...   \n",
       "3        max running dist: 0, Strength session, duratio...   \n",
       "4        max running dist: 0, Strength session, duratio...   \n",
       "5        max running dist: 0, Strength session, duratio...   \n",
       "6        max running dist: 0, Strength session, duratio...   \n",
       "7        max running dist: 0, Strength session, duratio...   \n",
       "8        max running dist: 0, Strength session, duratio...   \n",
       "9        max running dist: 0, Strength session, duratio...   \n",
       "10       max running dist: 0, Strength session, duratio...   \n",
       "11       max running dist: 9, Strength session, duratio...   \n",
       "12       max running dist: 12, Strength session, durati...   \n",
       "13       max running dist: 12, Strength session, durati...   \n",
       "14       max running dist: 12, Strength session, durati...   \n",
       "15       max running dist: 12, Strength session, durati...   \n",
       "16       max running dist: 12, Strength session, durati...   \n",
       "17       max running dist: 12, Strength session, durati...   \n",
       "18       max running dist: 12, Strength session, durati...   \n",
       "19       max running dist: 12, Strength session, durati...   \n",
       "\n",
       "Day                             Thur                     Fri  \\\n",
       "Week_No                                                        \n",
       "0         Workout session, max dist5   Easy day, max dist: 0   \n",
       "1         Workout session, max dist6   Easy day, max dist: 0   \n",
       "2         Workout session, max dist7   Easy day, max dist: 0   \n",
       "3         Workout session, max dist8   Easy day, max dist: 0   \n",
       "4         Workout session, max dist9   Easy day, max dist: 0   \n",
       "5        Workout session, max dist11   Easy day, max dist: 0   \n",
       "6        Workout session, max dist12   Easy day, max dist: 0   \n",
       "7        Workout session, max dist12   Easy day, max dist: 0   \n",
       "8        Workout session, max dist12   Easy day, max dist: 6   \n",
       "9        Workout session, max dist12  Easy day, max dist: 10   \n",
       "10       Workout session, max dist12   Easy day, max dist: 9   \n",
       "11       Workout session, max dist12   Easy day, max dist: 9   \n",
       "12       Workout session, max dist12  Easy day, max dist: 12   \n",
       "13       Workout session, max dist12  Easy day, max dist: 12   \n",
       "14       Workout session, max dist12  Easy day, max dist: 12   \n",
       "15       Workout session, max dist12  Easy day, max dist: 12   \n",
       "16       Workout session, max dist12  Easy day, max dist: 12   \n",
       "17       Workout session, max dist12  Easy day, max dist: 12   \n",
       "18       Workout session, max dist12  Easy day, max dist: 12   \n",
       "19       Workout session, max dist12  Easy day, max dist: 12   \n",
       "\n",
       "Day                             Sat          Sun  \n",
       "Week_No                                           \n",
       "0         Easy day, max distance: 0  Long run 18  \n",
       "1         Easy day, max distance: 0  Long run 20  \n",
       "2         Easy day, max distance: 0  Long run 22  \n",
       "3         Easy day, max distance: 0  Long run 24  \n",
       "4         Easy day, max distance: 0  Long run 26  \n",
       "5         Easy day, max distance: 0  Long run 29  \n",
       "6         Easy day, max distance: 0  Long run 32  \n",
       "7         Easy day, max distance: 5  Long run 35  \n",
       "8         Easy day, max distance: 6  Long run 35  \n",
       "9        Easy day, max distance: 10  Long run 35  \n",
       "10        Easy day, max distance: 9  Long run 35  \n",
       "11        Easy day, max distance: 9  Long run 35  \n",
       "12       Easy day, max distance: 12  Long run 35  \n",
       "13       Easy day, max distance: 12  Long run 35  \n",
       "14       Easy day, max distance: 12  Long run 35  \n",
       "15       Easy day, max distance: 12  Long run 35  \n",
       "16       Easy day, max distance: 12  Long run 35  \n",
       "17       Easy day, max distance: 12  Long run 35  \n",
       "18       Easy day, max distance: 12  Long run 35  \n",
       "19       Easy day, max distance: 12  Long run 35  "
      ]
     },
     "execution_count": 293,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weeks_df = pd.pivot(plan_df, values = \"Description\", index = 'Week_No', columns = 'Day')\n",
    "weeks_df = weeks_df[['Mon', 'Tue', 'Wed', 'Thur', 'Fri','Sat','Sun']]\n",
    "weeks_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Marathon ready by 2024-11-04 17:09:53\n",
      "Earliest race 2024-11-25 17:09:53\n"
     ]
    }
   ],
   "source": [
    "thresh_dates = plan_df.loc[plan_df.Week_tot > 100, \"Date\"]\n",
    "indices = thresh_dates.index\n",
    "mara_date = thresh_dates[indices[0]]\n",
    "print(\"Marathon ready by \"+ str(mara_date))\n",
    "print(\"Earliest race \"+ str(mara_date + timedelta(weeks = 3)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.date(2024, 4, 21)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dt.date(2023, 5, 21) + timedelta(weeks=45 + 3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load the activities data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\es21851\\AppData\\Local\\Temp\\ipykernel_31404\\1951123269.py:1: UserWarning: Parsing dates in %d/%m/%Y %H:%M format when dayfirst=False (the default) was specified. Pass `dayfirst=True` or specify a format to silence this warning.\n",
      "  activities_df = pd.read_csv(\"Activities.csv\", header = 0, parse_dates=[\"Date\"])\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Activity Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>Title</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Calories</th>\n",
       "      <th>Time</th>\n",
       "      <th>Avg HR</th>\n",
       "      <th>Max HR</th>\n",
       "      <th>Aerobic TE</th>\n",
       "      <th>...</th>\n",
       "      <th>Max Resp</th>\n",
       "      <th>Stress Change</th>\n",
       "      <th>Stress Start</th>\n",
       "      <th>Stress End</th>\n",
       "      <th>Avg Stress</th>\n",
       "      <th>Max Stress</th>\n",
       "      <th>Moving Time</th>\n",
       "      <th>Elapsed Time</th>\n",
       "      <th>Min Elevation</th>\n",
       "      <th>Max Elevation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>2024-07-17 20:59:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>00:20:06</td>\n",
       "      <td>88</td>\n",
       "      <td>124</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>00:20:06</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>2024-07-17 17:59:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Indoor Cycling</td>\n",
       "      <td>0</td>\n",
       "      <td>427</td>\n",
       "      <td>00:45:58</td>\n",
       "      <td>145</td>\n",
       "      <td>182</td>\n",
       "      <td>3.3</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>00:45:58</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cycling</td>\n",
       "      <td>2024-07-17 17:32:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Cycling</td>\n",
       "      <td>4.75</td>\n",
       "      <td>131</td>\n",
       "      <td>00:20:13</td>\n",
       "      <td>117</td>\n",
       "      <td>145</td>\n",
       "      <td>1.1</td>\n",
       "      <td>...</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:18:22</td>\n",
       "      <td>00:20:13</td>\n",
       "      <td>25</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cycling</td>\n",
       "      <td>2024-07-17 11:34:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Cycling</td>\n",
       "      <td>4.12</td>\n",
       "      <td>103</td>\n",
       "      <td>00:18:21</td>\n",
       "      <td>108</td>\n",
       "      <td>141</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:17:31</td>\n",
       "      <td>03:00:05</td>\n",
       "      <td>26</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Running</td>\n",
       "      <td>2024-07-16 18:37:00</td>\n",
       "      <td>False</td>\n",
       "      <td>Bath and North East Somerset Running</td>\n",
       "      <td>4.75</td>\n",
       "      <td>287</td>\n",
       "      <td>00:37:30</td>\n",
       "      <td>138</td>\n",
       "      <td>169</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>00:30:21</td>\n",
       "      <td>00:39:24</td>\n",
       "      <td>23</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Activity Type                Date  Favorite  \\\n",
       "0  Indoor Cycling 2024-07-17 20:59:00     False   \n",
       "1  Indoor Cycling 2024-07-17 17:59:00     False   \n",
       "2         Cycling 2024-07-17 17:32:00     False   \n",
       "3         Cycling 2024-07-17 11:34:00     False   \n",
       "4         Running 2024-07-16 18:37:00     False   \n",
       "\n",
       "                                  Title Distance  Calories      Time  Avg HR  \\\n",
       "0                        Indoor Cycling        0        58  00:20:06      88   \n",
       "1                        Indoor Cycling        0       427  00:45:58     145   \n",
       "2  Bath and North East Somerset Cycling     4.75       131  00:20:13     117   \n",
       "3  Bath and North East Somerset Cycling     4.12       103  00:18:21     108   \n",
       "4  Bath and North East Somerset Running     4.75       287  00:37:30     138   \n",
       "\n",
       "   Max HR  Aerobic TE  ... Max Resp Stress Change Stress Start Stress End  \\\n",
       "0     124         0.2  ...       17            --           --         --   \n",
       "1     182         3.3  ...       43            --           --         --   \n",
       "2     145         1.1  ...       --            --           --         --   \n",
       "3     141         0.5  ...       --            --           --         --   \n",
       "4     169         2.3  ...       34            --           --         --   \n",
       "\n",
       "  Avg Stress Max Stress  Moving Time  Elapsed Time  Min Elevation  \\\n",
       "0         --         --     00:00:00      00:20:06             --   \n",
       "1         --         --     00:00:00      00:45:58             --   \n",
       "2         --         --     00:18:22      00:20:13             25   \n",
       "3         --         --     00:17:31      03:00:05             26   \n",
       "4         --         --     00:30:21      00:39:24             23   \n",
       "\n",
       "   Max Elevation  \n",
       "0             --  \n",
       "1             --  \n",
       "2             51  \n",
       "3             53  \n",
       "4             50  \n",
       "\n",
       "[5 rows x 51 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "activities_df = pd.read_csv(\"Activities.csv\", header = 0, parse_dates=[\"Date\"])\n",
    "activities_df.head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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": 2
}