Last active
February 26, 2026 22:08
-
-
Save aarongilly/66b41b91ae974c2545751256c1c95938 to your computer and use it in GitHub Desktop.
Fitness Test Analysis - CSIS 44613 Final
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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