Jupyter/swim_run_times.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b461816b",
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "from IPython.display import display, Markdown\n",
    "from datetime import time, datetime, date, timedelta\n",
    "import snakemd\n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib.dates as dates\n",
    "\n",
    "import fitfile\n",
    "from garmindb import ConfigManager\n",
    "from garmindb.garmindb import GarminDb, Attributes, ActivitiesDb, Activities, StepsActivities, ActivityLaps, ActivityRecords\n",
    "from idbutils.list_and_dict import list_not_none\n",
    "\n",
    "from jupyter_funcs import format_number\n",
    "\n",
    "db_params_dict = ConfigManager.get_db_params()\n",
    "\n",
    "garmin_db = GarminDb(db_params_dict)\n",
    "garmin_act_db = ActivitiesDb(db_params_dict)\n",
    "measurement_system = Attributes.measurements_type(garmin_db)\n",
    "unit_strings = fitfile.units.unit_strings[measurement_system]\n",
    "distance_units = {\"kilometers\": \"km\"}[unit_strings[fitfile.units.UnitTypes.distance_long]]\n",
    "\n",
    "def __format_activity(activity):\n",
    "    if activity:\n",
    "        if activity.is_steps_activity():\n",
    "            steps_activity = StepsActivities.get(garmin_act_db, activity.activity_id)\n",
    "#             return [activity.activity_id, activity.name, activity.start_time.strftime(\"%y%m%d\"), activity.sport, format_number(activity.distance, 1), activity.elapsed_time, format_number(activity.avg_speed, 1), steps_activity.avg_pace, format_number(activity.calories)]\n",
    "            return [activity.activity_id, activity.name, activity.start_time.strftime(\"%y%m%d\"), activity.sport, format_number(activity.distance, 1), activity.elapsed_time, activity.moving_time, format_number(activity.avg_speed, 1), format_number(activity.calories)]\n",
    "        return [activity.activity_id, activity.name, activity.start_time.strftime(\"%y%m%d\"), activity.sport, format_number(activity.distance, 1), activity.elapsed_time, activity.moving_time, format_number(activity.avg_speed, 1), format_number(activity.calories)]\n",
    "    return ['', '', '', '', '', '', '', '', '']\n",
    "\n",
    "\n",
    "activities = Activities.get_latest(garmin_act_db, Activities.row_count(garmin_act_db))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e20bf3a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# All Actitivies\n",
    "\n",
    "doc = snakemd.new_doc(\"activities\")\n",
    "rows = [__format_activity(activity) for activity in activities]\n",
    "doc.add_header(\"All Recorded Activities\", 3)\n",
    "doc.add_table(['Id', 'Name', 'Date', 'Sport', f'Dist ({distance_units})', 'Elapsed Time', f'Moving Time', f'Speed ({unit_strings[fitfile.units.UnitTypes.speed]})', 'Calories'], rows)\n",
    "\n",
    "display(Markdown(str(doc)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5913e314",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Swimming Only\n",
    "\n",
    "doc = snakemd.new_doc(\"swims\")\n",
    "rows = [__format_activity(activity) for activity in activities if ((activity.name is not None) and (\"swim\" in activity.name.lower()))]\n",
    "doc.add_header(\"All Swims: {}\".format(len(rows)), 3)\n",
    "doc.add_table(['Id', 'Name', 'Date', 'Sport', f'Dist ({distance_units})', 'Elapsed Time', f'Moving Time', f'Speed ({unit_strings[fitfile.units.UnitTypes.speed]})', 'Calories'], rows)\n",
    "\n",
    "display(Markdown(str(doc)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0218bf42",
   "metadata": {},
   "outputs": [],
   "source": [
    "start_dates = []\n",
    "moving_times = []\n",
    "distances = []\n",
    "time100m = []\n",
    "for activity in activities:\n",
    "    if ((activity.name is not None) and (\"swim\" in activity.name.lower())):\n",
    "        s = activity.distance\n",
    "        t = (datetime.combine(date.min, activity.moving_time) - datetime.min).total_seconds()\n",
    "        \n",
    "        if (t/s/10 < 150) and (s > 0.8):\n",
    "            time100m += [t/s/10]\n",
    "            start_dates += [activity.start_time]\n",
    "            moving_times += [t]\n",
    "            distances += [s]\n",
    "\n",
    "\n",
    "fig = plt.figure(figsize=(12,5), dpi= 100, facecolor='w', edgecolor='k')\n",
    "plt.scatter(start_dates, time100m, c=distances, vmin=0.8, cmap=\"rainbow\")\n",
    "\n",
    "x_num = dates.date2num(start_dates)\n",
    "trend = np.polyfit(x_num, time100m, 1)\n",
    "fit = np.poly1d(trend)\n",
    "x_fit = np.linspace(x_num.min(), x_num.max())\n",
    "plt.plot(dates.num2date(x_fit), fit(x_fit), \"r--\")\n",
    "\n",
    "ax = plt.gca()\n",
    "plt.grid(visible=True, which='major', color='#666666', linestyle='-')\n",
    "plt.grid(visible=True, which='minor', color='#999999', linestyle='-', alpha=0.2)\n",
    "years = plt.matplotlib.dates.YearLocator()\n",
    "months = plt.matplotlib.dates.MonthLocator()\n",
    "# yearsFmt = plt.matplotlib.dates.DateFormatter('%Y')\n",
    "ax.xaxis.set_major_locator(years)\n",
    "ax.xaxis.set_minor_locator(months)\n",
    "# ax.xaxis.set_major_formatter(yearsFmt)\n",
    "\n",
    "plt.title(f\"Swim Time\\nRecorded Swims: {len(rows)}\")\n",
    "plt.colorbar(label=\"Total Distance / km\")\n",
    "plt.ylabel(\"Time per 100m (s)\")\n",
    "plt.ylim(min(time100m), 140)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "936772ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "# First 1km time\n",
    "\n",
    "start_dates = []\n",
    "moving_times = []\n",
    "distances = []\n",
    "time100m = []\n",
    "for activity in activities:\n",
    "    if ((activity.name is not None) and (\"swim\" in activity.name.lower())):\n",
    "#         s = activity.distance\n",
    "#         t = (datetime.combine(date.min, activity.moving_time) - datetime.min).total_seconds()\n",
    "        \n",
    "        laps = ActivityLaps.get_activity(garmin_act_db, activity.activity_id)\n",
    "        s = 0\n",
    "        t = 0\n",
    "        for lap in laps:\n",
    "            if (s < 1.0) and (lap.distance > 0.02):\n",
    "                s += lap.distance\n",
    "                t += (datetime.combine(date.min, lap.moving_time) - datetime.min).total_seconds()\n",
    "        \n",
    "        if (t/s/10 < 150) and (s > 0.8):\n",
    "            time100m += [t/s/10]\n",
    "            start_dates += [activity.start_time]\n",
    "            moving_times += [t]\n",
    "            distances += [s]\n",
    "\n",
    "\n",
    "fig = plt.figure(figsize=(12,5), dpi= 100, facecolor='w', edgecolor='k')\n",
    "plt.scatter(start_dates, time100m, c=distances, vmin=0.8, cmap=\"rainbow\")\n",
    "\n",
    "x_num = dates.date2num(start_dates)\n",
    "trend = np.polyfit(x_num, time100m, 1)\n",
    "fit = np.poly1d(trend)\n",
    "x_fit = np.linspace(x_num.min(), x_num.max())\n",
    "plt.plot(dates.num2date(x_fit), fit(x_fit), \"r--\")\n",
    "\n",
    "ax = plt.gca()\n",
    "plt.grid(visible=True, which='major', color='#666666', linestyle='-')\n",
    "plt.grid(visible=True, which='minor', color='#999999', linestyle='-', alpha=0.2)\n",
    "years = plt.matplotlib.dates.YearLocator()\n",
    "months = plt.matplotlib.dates.MonthLocator()\n",
    "# yearsFmt = plt.matplotlib.dates.DateFormatter('%Y')\n",
    "ax.xaxis.set_major_locator(years)\n",
    "ax.xaxis.set_minor_locator(months)\n",
    "# ax.xaxis.set_major_formatter(yearsFmt)\n",
    "\n",
    "plt.title(f\"Swim Time - laps until exceeding 1km\\nRecorded Swims: {len(rows)}\")\n",
    "plt.colorbar(label=\"Total Distance / km\")\n",
    "plt.ylabel(\"Time per 100m (s)\")\n",
    "plt.ylim(min(time100m), 140)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d1f45ee3",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Running\n",
    "\n",
    "start_dates = []\n",
    "moving_times = []\n",
    "distances = []\n",
    "time1000m = []\n",
    "for activity in activities:\n",
    "    if ((activity.name is not None) and (\"run\" in activity.name.lower())):\n",
    "        s = activity.distance\n",
    "        t = (datetime.combine(date.min, activity.moving_time) - datetime.min).total_seconds()\n",
    "        \n",
    "        if (210 < t/s < 480) and (s > 0.5):\n",
    "            time1000m += [t/s]\n",
    "            start_dates += [activity.start_time]\n",
    "            moving_times += [t]\n",
    "            distances += [s]\n",
    "\n",
    "\n",
    "fig = plt.figure(figsize=(12,5), dpi= 100, facecolor='w', edgecolor='k')\n",
    "plt.scatter(start_dates, time1000m, c=distances, norm=matplotlib.colors.LogNorm(), cmap=\"rainbow\")\n",
    "\n",
    "x_num = dates.date2num(start_dates)\n",
    "trend = np.polyfit(x_num, time1000m, 1)\n",
    "fit = np.poly1d(trend)\n",
    "x_fit = np.linspace(x_num.min(), x_num.max())\n",
    "plt.plot(dates.num2date(x_fit), fit(x_fit), \"r--\")\n",
    "\n",
    "ax = plt.gca()\n",
    "plt.grid(visible=True, which='major', color='#666666', linestyle='-')\n",
    "plt.grid(visible=True, which='minor', color='#999999', linestyle='-', alpha=0.2)\n",
    "years = plt.matplotlib.dates.YearLocator()\n",
    "months = plt.matplotlib.dates.MonthLocator()\n",
    "# yearsFmt = plt.matplotlib.dates.DateFormatter('%Y')\n",
    "ax.xaxis.set_major_locator(years)\n",
    "ax.xaxis.set_minor_locator(months)\n",
    "# ax.xaxis.set_major_formatter(yearsFmt)\n",
    "\n",
    "plt.title(\"Run Time\")\n",
    "plt.colorbar(label=\"Total Distance / km\")\n",
    "plt.ylabel(\"Time per km (s)\")\n",
    "plt.ylim(240, 480)\n",
    "plt.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (garmin)",
   "language": "python",
   "name": "garmin"
  },
  "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}