So I wanted to know how much time I spend at work. I have Google track my every step trough android’s location history and I am sitting on a proper treasure of personal data. Also, I am an advertisment product, but that’s besides the point.
Sooo, I pulled my location data from location history takeout, started Jupyter notebook and read my location history into a pandas dataframe.
Now we have a list of activities with their durations. How do we map them to work / home / other? Let’s take a look at a histogram of lattitudes and londitudes of the time after I started working at the current position and plot it in 2D.
That’s to far away, I must have traveled to different places. Let’s just zoom into Amsterdam.
Ok, it seems most of my activities are logged at three locations, a quick check confirms those are my work and the two places I’ve lived at. Let’s label activities that fit into the area around my work:
Etc. for home and other.
Now we can use these labels to see how I’ve spent September 2016:
I’ve spent a lot of time at work this September. Let’s see how much of overtime I usually do:
It seems I do a lot of overtime. I should probably get a hobby.
So what is my effective hourly rate? What part of hours I work do I get paid for?
I average 9.45 hours at work per day so my effective hourly rate is 85.7% of my actual hourly rate.
So there you have it! If there is enough interest I will also publish the notebook.