Thursday, June 25, 2020

How much do I have to walk to burn off my Guinness calories?

 Welcome file
This was a real question I had. Fortunately, its pretty simple algebra and I know how to do that so lets start with gathering a couple of numbers.
  1. How many calories do I burn per minute by walking? 7.7 I walk quite vigorously
    • 230/30=7.7230/30=7.7 Calories per minute
  2. How many calories do I take in per ounce of Guinness? 10.4 It might be 10.5 but this is what I got
    • 125/12=10.4125/12=10.4 Calories per ounce
Now we know every minute I walk burns 7.7 calories and every ounce of Guinness I drink gains me 10.4 calories. So the next question is how many minutes do I have to walk to burn off 1 ounce of Guinness. More math.
  • 10.4/7.7=1.3510.4/7.7=1.35 minutes (1 minute 21 seconds) walked to burn 1 ounce of Guinness Calories
So the closest bar to me (shouts to DD Peckers) is ~20 mins in one direction. How many Guinness can I have to break even by walking there and back. (Its unfortunately not very many)
Given a Guinness is 20 oz (imperial pint) and my walk to and from the bar is ~40 mins:
  • 407.7/10.4/20=1.4840*7.7/10.4/20=1.48 Guinness
Visualized as:
%matplotlib notebook
import matplotlib.pyplot as plt
plt.plot([[7.7*40] for x in range(100)], linewidth=1, label='random')
plt.plot([[x*10.4] for x in range(100)], linewidth=1, label='random')
plt.scatter([7.7*40/10.4], [7.7*40])
plt.annotate("Break even point", (30, 310))
plt.show()


The orange line in this case is the increase of calories per ounce drank and the blue line is a constant of calories burned if I walk vigorously for 40 mins. The intersection gives us the amount of ounces it takes to equal the number of calories I burned walking 40 mins. Which shows x as 29.6 ounces divided by 20 is 1.48 Guinness.

I wish my story problems as a kid were as interesting as this, but alas they were not, so here we are making up my own.

Monday, May 11, 2020

5 Million Step Man

Another year of Chuck does Data Science. For the 2019 year, I challenged myself to walk 5 million steps for the year which broke down to ~13000 steps per day. Crushed the goal and ended up going over 6 million steps for the year (6098464 to be exact) which was ~16000. Calculating that 2000 steps is a mile for me, I walked about 3050 miles. You see a pretty major dip in the number of steps in November because I strained my calf playing basketball during the early part of the month.

For the data visualizations this year I mostly worked on using the GPS data to get some interesting stats from the year. For instance, the number of times I walked the same routes. By far my favorite route is the Chuck route which I only got to do once, but is fun to look at. Below are a breakdown of step stats from the year and a link to the visualizations.

Total steps for the year: 6,098,464
Average steps per day: 16,708
Average steps per week: 117,278
Average steps per month: 508,205
Most steps in a month: 604,290 (August)
Least steps in a month: 318,127 (November)
Most steps in a day: 37,687
Least steps in a day: 1,123
Percentage of days meeting goal of 13000 steps: 297/365 81%
Sunday Steps Total (Avg):        734,654 (14,128)
Monday Steps Total (Avg):       943,700 (18,148)
Tuesday Steps Total (Avg):       996,785 (18,807)
Wednesday Steps Total (Avg)909,695 (17,494)
Thursday Steps Total (Avg):     950,875 (18,286)
Friday Steps Total (Avg):          822,101 (15,810)
Saturday Steps Total (Avg):      740,654 (14,243)
Most walked route: Bar Walk (300 times)


Data visualization can be found here.
Disclaimer: May not work well on mobile.