Skip to content

Instantly share code, notes, and snippets.

@aarongilly
Last active February 26, 2026 22:08
Show Gist options
  • Select an option

  • Save aarongilly/66b41b91ae974c2545751256c1c95938 to your computer and use it in GitHub Desktop.

Select an option

Save aarongilly/66b41b91ae974c2545751256c1c95938 to your computer and use it in GitHub Desktop.
Fitness Test Analysis - CSIS 44613 Final
Data for my final project in NW Missouri State University course CSIS 44613 "Data Visualization. Data from my own life, compiled over the course of 3 years.
For more information, see:
- https://aarongilly.com/Pages/Data-Journal
- https://aarongilly.com/Columns/379
This table describes the `fitness_test_dataset` gist CSV contents.
| FIELD | UNIT | SOURCE | DESCRIPTION |
| -------------------------- | -------------- | ------------ | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| Date | date | Calendar | Date of Fitness Test |
| Quarter | Year & quarter | Calendar | Associated Quarter |
| 1.5 Mile Pace | min/mi | Fitness Test | 1 mile pace sustained over 1.5 miles |
| Times Worked Out | count | data journal | Dedicated workout count |
| Times Eaten Out | count | data journal | Paid for a meal not sourced from the grocery store |
| Tracked Pains | count | data journal | Times I took some form of medication for some form of acute pain |
| Strength Workouts | count | data journal | Dedicated strength training workouts (e.g. barbell training, isolation exercises) |
| Cardio Workouts | count | data journal | Dedicated cardiovascular workouts (e.g. jogs, long walks) |
| Mobility Workouts | count | data journal | Dedicated mobility workouts (e.g. yoga, stretching) |
| Est VO2 Max | mL/kg/min | apple health | V02 Max estimated by my Apple Watch |
| Walk/Run Dist (mi) | mi | apple health | Distances estimated by my Apple Watch |
| Arms (sets) | sets | hevy | Arm-based lifting sets completed |
| Back (sets) | sets | hevy | Back-based lifting sets completed |
| Chest (sets) | sets | hevy | Chest-based lifting sets completed |
| Core (sets) | sets | hevy | Dedicated core work sets completed. |
| Legs (sets) | sets | hevy | Leg-based sets completed |
| Shoulders (sets) | sets | hevy | Shoulder-based sets completed |
| Whole Body (sets) | sets | hevy | Whole-body-type sets completed (e.g. plyometrics, cleans, etc) |
| Resting HR | bpm | oura | Heart Rate during sleep, as measured by Oura Ring |
| Net Workouts Less Eat Outs | none | data journal | The number of workouts tracked minus the number of times tracked eating out |
| Aesthetic Score | none | Fitness Test | Subjective rating based on time of test |
| Biometric Score | none | Fitness Test | Formula applied to Fitness test results focusing on events related to this facet of health, compared to associated goals and fitness standards |
| Mobility Score | none | Fitness Test | Formula applied to Fitness test results focusing on events related to this facet of health, compared to associated goals and fitness standards |
| Cardio Score | none | Fitness Test | Formula applied to Fitness test results focusing on events related to this facet of health, compared to associated goals and fitness standards |
| Strength Score | none | Fitness Test | Formula applied to Fitness test results focusing on events related to this facet of health, compared to associated goals and fitness standards |
| Overall Fitness Score | none | Fitness Test | Sum of the 5 above scores, for a total possible of 50 points |
Date,Qtr,Aesthetic Score,Biometric Score,Mobility Score,Cardio Score,Strength Score,Overall Fitness Score,Arms (sets),Back (sets),Chest (sets),Shoulders (sets),Whole body (sets),Core (sets),Legs (sets),Walk/Run Dist (mi),1.5 mile run pace (min/mi),Est VO2 Ave (apple health),Resting HR (bpm),Tracked Pains,Times Worked Out,Times Eaten Out,Net Workouts Less Eat Outs,Strength Workouts,Cardio Workouts,Mobility Workouts
2025-12-31,2025-Q4,8,6.6,7.2,5.9,5.6,6.6,26,35,33,32,7,,69,485.61,9.57,44.5,57.4,3,36,43,-7,15,15,6
2025-10-01,2025-Q3,8,5.8,6.8,6,6.6,6.6,26,27,51,38,3,,59,592.05,8.83,43.2,58.3,8,47,50,-3,14,31,2
2025-07-02,2025-Q2,8,7.8,8,8,6.8,7.7,25,34,69,35,,3,82,595.08,9.73,46.9,59.7,9,44,63,-19,16,23,5
2025-04-01,2025-Q1,8,6.3,9,6,6.6,7.2,30,33,76,75,2,,97,478.76,9.28,45.7,62.7,24,61,42,19,35,20,6
2024-12-29,2024-Q4,7,6.3,8.3,7,7,7.1,11,24,18,4,5,1,23,490.26,10.25,45,61.3,15,28,49,-21,20,6,2
2024-09-30,2024-Q3,8,6.8,6.5,5,5.4,6.3,12,3,6,10,1,,16,654.86,9.43,45.7,57.4,3,74,58,16,44,27,3
2024-07-07,2024-Q2,8,7.2,7.3,7,6.4,7.2,33,48,43,23,11,2,54,627.75,9.2,44.8,58.6,12,61,43,18,34,23,4
2024-04-06,2024-Q1,7,8.5,7,7,5.2,6.9,105,121,107,74,22,8,117,509.48,9.42,43.5,61,9,59,44,15,30,18,11
2023-12-17,2023-Q4,6,6.8,7.3,7,6,6.6,43,118,112,118,20,2,107,585.27,9.3,43.8,59.2,9,50,41,9,24,24,2
2023-10-10,2023-Q3,6,6.5,7.4,7,5,6.4,24,115,69,123,24,6,129,511.01,9.77,41.4,60.3,12,36,37,-1,25,9,2
2023-07-17,2023-Q2,6,6.8,7.7,6,4.2,6.1,113,85,45,64,5,26,64,571.26,10,46.4,59.8,57,30,29,1,20,8,2
2023-02-27,2023-Q1,6,6.3,6.3,6,2.6,5.4,89,74,89,87,15,4,105,464.37,9.75,43.6,63.9,11,36,26,10,25,9,2
2022-11-27,2022-Q4,8,4.8,7.9,6,5,6.3,27,67,56,71,16,1,107,404.16,10.1,41.7,63.9,30,33,27,6,22,8,3
2022-08-21,2022-Q3,8,5.8,6.7,5,4.4,6,9,15,15,17,5,,24,417.93,11.03,40,60.8,64,15,28,-13,7,6,2
2022-04-01,2022-Q2,8,3.5,4.2,3,3.4,4.4,16,31,40,35,9,,42,494.16,10.1,40.1,61.1,23,19,27,-8,11,6,2
2022-01-01,2022-Q1,8,4.8,7.9,5,6.4,6.4,20,46,30,44,10,,48,384.02,10.1,42,63.7,28,22,27,-5,12,8,2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment