Last year Splunker, Ed Hunsinger, wrote a great post titled, “Go Splunk Yourself“, in which he shows how he’s using Splunk to track data from devices including a Fitbit, a Nike Fuelband, a Basis Band, and a Garmin GPS watch to name just a few!
Like Ed, I use a number of tracking devices and I use Splunk to analyse the data they produce. Recently – as my friends and colleagues will tell you – I’ve taken this concept of self-tracking to the next level. This has included purchasing both a blood sugar and a blood pressure monitor.
After a few weeks collecting the data I’ve uncovered some interesting trends. If you’re interested what I’ve found or how you can do this at home, read on.
- A basic understanding of Splunk
- Splunk installed and running (free download here)
- Microsoft Excel installed
- Access to blood sugar / pressure devices
Step 1: Purchasing the Devices
The great thing about buying tracking devices is that you can spend a lot of money, very quickly. For this experiment I wanted to keep costs down and opted for entry level kit. Here’s the equipment I bought:
Step 2: Recording the Data
With simplicity in mind I used a very manual data entry process. I created two CSV files to input blood pressure and glucose respectively. In column A I included a timestamp with a minute granularity. I did this as it was simple to log, but highly precise for the level of my analysis.
You can download my CSV templates here:
Step 3: Indexing the CSVs
In Splunk I navigated to: “Settings” > “Data Inputs” > “Files & Directories” > “New”
Then I found and selected the CSV and clicked “Data Preview”. The timestamps looked good and I hit “Save”.
On the next screen, I set the source as: “Continuously index data from a file or directory this Splunk instance can access”. This means every time I save a new measurement Splunk automatically reads and indexes the change.
Altering the other fields on this page from the default, like “source”, may be useful but completely optional.
Step 4: Splunking the data
If everything has worked properly you should be able to see the fields extracted from the data correctly when running a search:
Now for the fun to begin…
Step 5: Start searching yourself
Looking at my pulse over time:
source="/bloodpressure.csv" | timechart avg(Pulse)
Great! But what does this mean? To add some context to the data I began by looking at what was considered a “normal” resting pulse. For this I used the reference ranges on the Mayo Clinic site – a max pulse = 100 and a min = 60. Of course, these should only be used as guides. To visualise this information I ran the search:
source="/bloodpressure.csv" | eval pulseMax = 100 | eval pulseMin = 60 | timechart avg(Pulse) avg(pulseMax) avg(pulseMin)
Looking at the chart above you can clearly see my pulse is regularly below the “normal” values. I attribute this to my fitness level but it will certainly be something to discuss with my doctor next time I visit for a checkup.
What about changes in blood pressure over time?
source="/bloodpressure.csv" | timechart avg(Systolic) avg(Diastolic)
Perhaps as expected, Systolic and Diastolic measurements correlate well. There are some spikes in Systolic readings, whereas my Diastolic measurements are fairly smooth. If you’re interested in learning more about these measurements for analysis, this site provides a great introduction.
Step 6: Life-logging
I plan on adding further context to this data by including other life logging devices.
Like my Fitbit data, for example. Does more steps during the day have a noticeable impact on blood pressure readings taken each evening?
Other things like travel. Working for Splunk I’m fortunate to travel to different parts of the world but travelling through airports is stressful and staying in hotels can make it hard to eat well. If I compare my Foursquare checkins to blood data I can test wether distance travelled directly impacts upon my blood pressure and blood glucose readings.
I’ll keep you posted.