/b/ - Anon has 13 years of health data and one useful number

>be me
>40, unemployed, benefits, previous thread (>>/blog/a-new-life-in-an-old-town)
>want 15 kilos gone
>decide the problem is a data problem

>export 13 years of apple health
>export.xml
>1.2 GB
>5,514,737 lines
>2,604,971 records
>cannot open it
>cannot grep it without making coffee first
>cannot paste it anywhere, its three orders of magnitude past any context window worth paying for
>write 400 lines of python to turn it into two csv files
>thats the entire codebase
>nobody will ever run it but me

>check what the file is actually made of
>ActiveEnergyBurned 559,110
>HeartRate 436,550
>StepCount 175,987
>SleepAnalysis 41,136
>BodyMass 106
>the series the whole project is about is 106 records
>thirteen years
>eight weigh-ins a year
>four thousandths of one percent of the file is the point of the file
>the other 99.996% is a watch generating evidence that i exist

>also learn i bought the watch in september 2022
>not from a receipt
>from the shape of a hole in the data
>longxml.jpg

1/2

>>91461803

>then the sweating
>22 years of it
>not the i get warm easily kind
>the soaked through a shirt on a calm walk kind
>doctor puts me on a four week trial
>four weeks with no measurements is four weeks of vibes
>build a log
>day 1 fields: rating 0-10, temperature
>obvious design. sweating is heat. log the heat.

>day 3 the numbers say:
>warmest day = least sweaty day
>instrument visibly broken after three data points
>add walk length that evening
>day 4 breaks the new pattern immediately
>coldest day, shorter walk, worst rating yet
>it had rained
>hoodie instead of t-shirt AND humidity so sweat doesnt evaporate
>add weather as three clicks, not free text
>you can average a category, you cannot average a sentence

>best field is the fifth one: sweat onset in metres
>800m and it hasnt moved
>controlled for free because every walk starts on the same 1 km route i made in pokemon go
>accidental experimental protocol courtesy of a mobile game
>eleven days in: r = +0.65 walk length, r = -0.46 temperature
>the temperature one points the wrong way
>label it noise instead of quietly calling it a finding
>n=11, im not going to lie to myself in my own repo

>bonus rounds
>certain the watch sat on the charger on the 20th
>remembered the day and everything
>data says the 20th was fine, it was the 29th
>my memory attached a real event to the wrong day with total confidence
>then the script reports a night of 3.5 hours, 19:17 to 13:51
>it welded an evening doze, a charging gap and an afternoon nap into one catastrophic night
>not a bad night. not a night at all.
>working rule: the data beats my memory about WHEN, my memory beats the data about WHAT

>mfw the most disciplined repo on this machine has no application in it
>mfw its four python scripts and 150 KB of markdown
>mfw the markdown is the product

2/2

>>91461803

>1.2 GB of xml
>400 lines of python
>eleven days
just eat less
saved you a hard drive and a fortnight

>>91461803

>22 years of sweating
>solution: a spreadsheet
lmao
see a doctor anon
oh wait you did and you turned him into a csv too

sage
/b/ is not your diary
nobody asked for the correlation coefficients of your armpits

>>91461817

>the warmest day was the least sweaty day
O RLY
or you stayed inside on the warm day like a normal person
groundbreaking research anon
nobel committee has been notified

>>91461803

>unemployed
>no gym
>wants 15 kilos gone
get a gym membership
cut your calories in half
quit the nicotine while youre at it
there, i did your robots entire job in four lines and i didnt need a gigabyte to do it

>>91461803

>2,604,971 records
>106 of them matter
so you built a 1.2 GB machine for weighing yourself eight times a year
this is the single most tech worker post in the archive

no before pics
no after pics
no proof
didnt happen
post body or GTFO

>>91461817

>every walk starts on the same route i made in pokemon go
this is the only good line in the thread
and you did it by accident
eleven days of methodology and the rigor came from niantic

>>91461817

>the markdown is the product
anon you wrote a diary and called it engineering
congratulations on inventing the journal
they sell them at the store for 30 kr and they dont need a virtualenv

>>91461803

epic fail
2.6 million records and the finding is that walking makes you sweat
lurk moar
linking your blog at the bottom of a greentext doesnt make it a thread
in b4 next one is anon builds a dashboard for his own tears