My-2024-Garmin-Data-Analysis-

Garmin Fitness Data Analysis

SUMMARY

Purpose: This is a personal data-driven case study that analyzes my Garmin fitness data to uncover trends in activity, sleep, calorie burn, and stress. Results: Activity levels peak in the summer, with September being the most active month (highest intensity minutes, floors climbed, and calories burned) and March the least active. Step count peaked in May, likely due to the transition from winter to more outdoor hiking. Resting heart rate strongly correlates (0.73) with training intensity, but anaerobic activities like mountain biking cause sustained high heart rates despite lower recorded intensity minutes. September had the highest calorie burn, with stair climbing contributing significantly. Best sleep occurred in June, while August had the worst. However, there was no clear connection found between high activity and reduced sleep quality. Stress was highest in October but also peaks in January and February, while September was the least stressful month. Stress levels appear to follow a cyclical monthly pattern of rising and falling. Conclusion: The data suggests maintaining winter activity, balancing high-intensity workouts for recovery, and monitoring heart rate and stress levels for better long-term fitness and well-being.

QUESTIONS

ACTIVITY

CALORIES

SLEEP

STRESS

DATA SOURCE

The data was obtained from my personal Garmin profile, collected through a Garmin smartwatch worn daily. It was exported from Garmin Connect and contains various health and fitness metrics for analysis. Data Categories & Variables Activity: Steps taken, floors climbed, intensity minutes, total active time. Calories: Total daily calories burned, resting vs. active calorie expenditure. Heart Rate: Resting heart rate (RHR), heart rate trends over time. Sleep: Total sleep duration, bedtime, wake time. Stress: Daily stress level based on heart rate variability (HRV). Time & Date: Data timestamps for analyzing trends by day, week, and month. Data Limitations

Cleaning Process

Dates are standardized to “Month YYYY” across all datasets. Units were removed where needed (e.g., “bpm” in heart rate data). Aggregated properly (e.g., stress = monthly average, calories = monthly sum). Time converted to minutes in sleep data.No empty or weird values (everything should be readable and structured). Key Processing Functions Standardizing Dates def format_month_year(date_series, add_year=True): if add_year: date_series = date_series + “ 2024” return pd.to_datetime(date_series, errors=”coerce”).dt.strftime(“%B %Y”)

Converting & Aggregating Data def convert_to_numeric(df, columns): df[columns] = df[columns].apply(pd.to_numeric, errors=”coerce”) return df.groupby(“date”, as_index=False).sum()

Processing CSV Files Efficiently def process_csv(filename, cleaning_function): file_path = os.path.join(DATA_FOLDER, filename) if os.path.exists(file_path): df = pd.read_csv(file_path, dtype=str) df = cleaning_function(df) df.to_csv(os.path.join(CLEANED_FOLDER, filename), index=False).


📊 RESULTS

Activity Analysis:

How do my total activity levels (steps, floors climbed, intensity minutes) change by month?

What was my most active month? Least active?

How consistent have I been with my workout frequency?

Mountain biking as a major factor

September 2024: Highest training intensity & highest max HR.

November as a recovery period

Max HR peaks align with training intensity

Monthly Activity Trends

Monthly Step Count

Monthly Step Count

Resting Heart Rate vs. Training Intensity

Resting Heart Rate vs. Training Intensity

Calorie Analysis:

Which month do I burn the most calories?

Is there a strong correlation between intensity minutes and calorie burn?

Does increased activity lead to improved sleep quality, or does excessive exercise negatively impact sleep?

Does stair climbing (floors climbed) contribute more to calorie burn than regular steps?

Monthly Calorie Burn

Monthly Calorie Burn

Intensity Minutes vs Calories Burned

Intensity Minutes vs Calories Burned

Impact of Stair Climbing on Calories Burned

Impact of Stair Climbing on Calories Burned

Impact of Activity on Sleep Duration

Impact of Activity on Sleep Duration

Sleep Analysis:

How has my sleep duration changed over time?

Do my best sleep nights coincide with more or less physical activity? Weak correlation (0.037) between training intensity and sleep duration—meaning more activity does not strongly predict better sleep.

Is there a relationship between high-intensity activity and reduced sleep?

Monthly Sleep Duration

Monthly Sleep Duration

Stress Levels vs. Sleep Duration

Stress Levels vs. Sleep Duration

Physical Activity vs Sleep Duration

Physical Activity vs Sleep Duration

Stress Analysis:

Which months or seasons show the highest and lowest stress levels?

Does physical activity (steps, intensity minutes, floors climbed) correlate with lower stress levels?

Do my highest stress weeks align with changes in physical activity, sleep, or heart rate?

Is there a correlation between high-intensity training and higher/lower stress?

Stress Levels by Month

Monthly Stress

Resting Heart Rate vs Stress

Resting Heart Rate vs Stress

Training Intensity vs Stress

Training Intensity vs Stress


Conclusion:

This Garmin analysis revealed clear seasonal trends, strong fitness levels, and the relationship between intense training, recovery, and stress. The patterns uncovered here are not only useful for personal reflection but also demonstrate how wearable data can guide health decisions.

Action Steps:

All analysis was done in Python using open-source tools and is fully reproducible.