Showing posts with label data. Show all posts
Showing posts with label data. Show all posts

Friday, March 07, 2014

Lil' Data

This is a different kind of post about Casper’s first three months. Less lovey-dovey. More facts and figures. Less cuddly, but easier to hold.

Since shortly after his birth I’ve been tracking Casper’s eating and excreting via the Baby Connect App for iOS. In the hospital we were asked to record this information on a piece of paper (like cavemen!) which the nurses would check periodically. We could not abide such prosaic data collection. Luckily I had researched baby tracking apps before my water broke (‘natch). When we were discharged we were asked to continue to record this information for a week primarily because Casper had lost almost 10% of his body weight since birth. And then… I kept tracking him. I have a hard time stopping data collection once it has begun. 

Data is often useful and fun!  (Yes, I said, "fun." #coolkid). I use Casper's data to gauge things like which boob he ate from last, just how bad the coming poop is likely to be and to extrapolate how much sleep I might get tonight. I've managed to extract a few fun facts that are great for shock value over brunch and which will most certainly be hurled at 13 year old Casper during one of our coming parent/son battles. Watch this space.

So.... On to the data! 


But first! Data caveats: I stopped my excel import on Feb 17 since I had to cut off at some point or keep reimporting forever -- this gave me exactly 3 months of data. I have not, however, stopped using the app (who could stop?) so the graphs from the app itself represent more data (most pictures were taken on the morning of Feb 24 when Casper was 14 weeks and 2 days old). I’ve also used the app data for some figures when adding up the numbers in the app proved easier than parsing the csv export.




So yes, data is fun. And I find all that follows to be fun but... data is also scary, especially in aggregate.


New parents, avert your eyes! I’m about to reveal the total number of diapers changed in just over 14 weeks of Casper’s life.



Total Diapers Changed: 785. (roughly 8 per day).
The fact that I see this number and think “huh, not too bad.” is evidence of the kind of crazy thinking inspired by postpartum hormones.

As you can see Casper has recently decided that pooping is super uncool. Sadly, every few days he's forced to debase himself (and the entire family) with a huge poo. This leads to much groaning by mom and dad. For each diaper Baby Connect gives you the option of recording quantity, color, "open air accident" and diaper leakage. We rarely used these features until February when we needed them for passive aggressive data collection purposes. ("Young man, this disgusting mess is going on your permanent record!").
 
Total poopy diapers awful enough for mom or dad to manually apply a “large” label: 22 (18 of which resulted in diaper leaks.)
I would have very much liked to include a mommy/daddy diaper off here but sadly my husband is much less of a data nerd than I. When he changes diapers (which he does a lot of including all of the 5am diaper changes) I’m left to do most of the recording on my own. Thus the “caretaker” log is riddled with data errors. Alas. Perhaps this is for the best lest we start comparing our diapering score and end up divorced. For what it’s worth all of the nursing has been done by me.


(click through for full size image)




Total time nursing: 224 hours 45min otherwise known as 9.36 DAYS of my life!


This stat shocked me much more than the diapers. To think that I have sat on the couch or the bed, boob in baby’s maw for almost a week and a half is amazing. Thank god for my iPhone. I have no idea what moms did while nursing before the invention of the smart phone. I know that the “right” answer here is “just gazed lovingly down at their baby.” But I suspect the REAL answer is “watched TV and tried not to die of boredom."


The app also makes it easy to remember which boob was offered to baby last so we consistently alternate to try for evenness, the baby could still show a preference for one boob over the other by eating longer on the favorite boob. Casper, however, shows no favorite loving both righty and lefty equally.


Longest amount of nursing in one day: 11/18 -- 338min (5 hours 38 mins).


I’m tempted to call this log user error -- certainly Casper could not have nursed as frequently as recorded here, especially since the data shows that he basically nursed from 8am until 6 pm with almost no pauses. And yet.... the more I stare at the excel the more I'm convinced that there is no error and my baby was just super into eating. For all his effort he likely didn't get much reward. My milk almost for sure had not come in yet so much of this was just time Casper was spending telling my body to hurry up and FEED ME!!!!!. A more average day in the first few weeks of Casper’s life involved 3 hours on the boob.
We never bothered to record Casper’s sleep. Considering how worried I was before he was born about never sleeping again this is, in retrospect, a bit strange. Perhaps I was too afraid to stare this data in the face. You can, however, use the data I have to extrapolate night time sleep blocks since upon waking Casper is always immediately changed then fed and (thank you to the baby gods) goes right back to sleep. This is how I know that we are regularly getting 7 hours sleep stretches in the past few weeks. This is also reflected in our eating intervals which show consistent growth over time. This data is especially encouraging when you consider that during the day Casper still eats every 90-120 minutes so almost all of the interval growth is due to extended nighttime sleeping.
One wonders what might influence the up and down nature of a baby's eating. Sure, doctors claim this is mostly due to "growth spurts" but shouldn't other possibilities be considered? Like, for example, is Casper influenced but the full moon (is he, in fact, a werewolf?!?!?) ?
Guess not.

After this exercise in data analysis I'm sure all readers are wondering exactly what the point of all this is. I’ll admit to a slight case of paranoia that someone might challenge me on my parenting skills and I’ll respond with data to back up the case. Look! I am, in fact, a good mom who totally feeds her child (this is never going to happen, and if it did a punch in the face would be a more valid response than, “But look at this excel graph I have!”). Mostly my data obsession is nonsensical. 
When my brother laughed out loud as I recorded information on my son's poops I could offer no clear reason to explain exactly why I am doing this (blog fodder?). Data collection has become religious. Data is comforting. It makes tangible what might otherwise be amorphous. The recording of facts its own sacrament. Like church, data offers comfort, direction, sometimes misdirection and often, indifference. Despite how important collecting data on Casper has felt I know that so much of what I have gathered here does not matter. And yet, I can't stop. The weight of existing data that isn’t being recorded often feels needlessly heavy. It implies importance for things that might actually be inconsequential.

Of course, nothing feels inconsequential when you have a baby. I know that Casper's every new discovery has already been discovered by every human baby to proceed him and yet a celebration still seems in order. This data shows what it's like to have a newborn. He poops. He eats. He pees. He sleeps. Nothing new. And yet his mom is mesmerized

Wednesday, January 12, 2011

Visualizing Facebook Relationships



(click through for larger (though still not really large enough) version)

I don't know why I felt compelled to do this but now that it is done I feel a strange peace.

Thursday, May 13, 2010

Geekery: Budgeting for South East Asia

Remember when I said that we'd be doing our tour of South East Asia at a cost of $70/day (for 2 people!)? Remember when you thought, "That's insanely cheap, there is simply no way that is possible."? Remember when I proved you wrong? No? Well get ready because the data is right here!

Picture it: the waves lapping at the shore, the sun sinking into the South China Sea, a brightly colored drink in a pretty glass adorned with an orchid, half naked children running like mutant 2 legged crabs through the surf, a stray dog shoving his head into your crotch...the tip tap tip tap of fingers on keyboard, a beautiful color-coaded spread sheet. You can take the manager out of the project but you can't take the project manager out of the girl.

Much to Geoff's constant annoyance I spent some small amount of each day in paradise entering our expenditures into a Google spreadsheet so that I could hopefully come home to the wonderful fun of proving myself right. I also spent a similar amount of time each day raising my eyebrows and quietly fuming when Geoff ordered a second gin and tonic because how will we ever stay on budget if you insist on $6 in cocktails every day? (Of course, I have to acknowledge that it was either $6 in cocktail costs or considerably more in hospital fees from when he eventually broke down and strangled my OCD, penny-pinching ass -- so really gin was the more budget friendly option).

Before we get into the exciting data, a few caveats. There are for sure errors in my data and I have this fear that some crazy internet person is going to comb through it and email me copious notes about all of my mistakes. This is obviously a paranoid fantasy because while there are FOR SURE tons of crazy people on the internet who would do this, I am almost positive that I have yet to attract enough internet stalkers to have to worry about the crazies coming after me just yet. I only wish I was popular enough to have to worry about someone (or even multiple someones) OCD-ing it up on my lunch costs. But just in case, let me state that there are errors in this data. This is because I often didn't have access to wifi and thus was unmotivated to touch the computer (You mean I won't be able to read about funny cats? I'm out.). This is also because even though I sometimes like to pretend that I have a super-human memory, I still forget things. This is also because sometimes I cheated. Here is a list of ways that I totally cheated on the budget:

  • I did not include flight costs. It is totally possible to recreate our trip using only buses and thus spending WAY less money but sometimes when you're on an overnight bus ride listening to the horn that the driver leans on once a minute as if to scream, "Wake up whitey, you're about to die!" You remember that you can totally afford a $50 plane ticket and that while, yes, this will totally screw the budget it might make up for that sin with a night of sleep and not being dead on the side of a highway in Vietnam.
  • I did not include souvenir or gift costs so my firends and family may never know exactly how cheap knock off tshirts are in Bangkok.
  • I did not include the cost of our scuba diving course because even though scuba diving in Thailand is shockingly cheap (we paid $278.43 each for the four day certification course with 4 dives) it cannot be done for $35/day/person and we had pre-approved that particular out of budget splurge. The budget and I thoroughly enjoyed the 4 days of free hotel room that came with the course.
  • For the last 13 days of our trip I threw the budget out the window. These days were by far the most expensive on our trip. We lived it up in hotels built for very discerning Japanese business men and/or families of Germans. We drank singapore slings made with top shelf gin. We took taxis because we were too lazy (and fancy) for public transit. Sometimes we got into a tuktuk without even arguing about the price which means we paid 5 times more then we needed to and we didn't even care. We were the Mr. Howel and Lovey of Thailand and it was grand. Geoff wanted to continue recording the budget during these days of excess just for the hilarious comparison factor but I had to insist that we not do this because when the budget is in play I simply cannot stop thinking about how much more awesome the data would look if I just had one less mai tai, one less foot massage, one less bag of cookies from the mini bar -- and really, who wants to live like that?

Ok, enough blathering on to the data!


Days In Budget: 71

Hotel: $1,165.38
Food + Drink: $2,229.07
Travel: $604.71
Visas: $225.00
Tourism: $640.54
Local Transport: $361.03

Total Spent: $5,302.14
Daily Average: $74.68


Ok, so obviously we went over budget. It is difficult (nay, impossible) for me to type that sentence without following it up with a list of excuses which is exactly what I will do in just a moment here but first I will own it. We went over budget. That's ok.

Because, you see, we didn't have to. We could have quite easily stayed on budget. There are scores of days (46 to be exact) in my little spreadsheet that are happily under budget. There is even one day (February 17th) where we spent $25.15 -- thanks in part to that free hotel room that we got from our scuba class but mostly to the fact that sitting on the beach don't cost a thing. The problem was that when we went over budget we partied like Scrooge McDuck (if Mr. McDuck had been partying in Asia and if, instead of a pool full of gold coins, he had a really awesome tour of the Vietnam countryside followed by 3 cocktails OR a fancy sleeping car for his 12 hour train ride OR some sweet Laos visas). What I'm saying is that when we figured that we were going over budget anyway we seemed to say "well the diet is screwed for today, might as well eat an entire cheesecake." (This is an attitude that I have also employed in a less metaphorical way with actual cheesecakes and actual diets). Our most expensive day in Asia (3/8/2010) was a major blow out -- $198.50 -- we went on a tour of Angkor Wat which not only meant playing for a tour guide ($27) but also going to breakfast and dinner at the pricey establishments that our tour guide is getting kick backs to drop us off at, but more important than all that (which alone would have resulted in a $85.50 day) we bought our Vietnam Visas which (including delivery fees) cost a whopping $113.


In addition to the pain of Visa costs which made us consider looking into boarder crossing coyote services we spent a lot on getting from one place to another. For a while I even considered pulling all travel costs out of the budget since they were painfully expensive and since after a few
Biere La Rues it was easy to convince yourself that travel wasn't part of a daily budget! And of course, there was the cheating. If we're not going to count flights why count pricey train rides or even cheap bus tickets?


I would also like to not count all of Cambodia. You'd think hotel rooms with bathroom walls that don't extend to the ceiling and towns covered with a thin layer of garbage would, if nothing else, be easy on the wallet but NOT SO! Since the country is much poorer then Thailand or Vietnam (Source) we kind of expected to live like kings -- but this was not to be. Part of the problem is that we spent a lot of time in Siem Reap visiting Angkor Wat and the surrounding ruins which are swarming with westerners and thus very expensive (ok, comparatively expensive... our average per day cost in Siem Reap was $81.92 which wouldn't even come close to covering our estimated cost of a night in our very own Brooklyn apartment (~$91)). The other part of the problem is that Cambodia is just hard and Geoff and I are comforted by the fancy. After a day of mourning the deaths of the past and turning away the legions of poor children we felt like we deserved some AC and our own bathroom. (Better people would probably feel like they too could do without but we are not better people).

Conversely we had been warned by many a traveler that Vietnam would be pricey but somehow it was by far our cheapest destination (possibly because we both would happily live off of $.50 Ban Mis made by an old lady on a scummy street corner). We scored in the north by visiting Hanoi and Halong Bay during the low season (downside: too cold to swim, upside: $6 rooms, uncrowded waters and not getting eaten by giant jellyfish). As far as I can tell the rest of the country is just always cheap. Our average hotel cost in Vietnam was $15.16 (compared to a trip-wide average of $17.66) and the hotels were markedly nicer than those in other countries -- we had AC, hot showers, complete bathroom walls, balconies AND CNN international! Over 22 days we had 24 meals that cost under $5. One day in Hue we had lunch for $.78 -- granted it was pho and coffee eaten while seated on a dirty curb but STILL! If you wanna live like a king Vietnam is highly recommended.

Ok, enough. I could continue to entertain you with the minutia of cost of traveling in South East Asia but I suspect that there are no readers left down here at the bottom of the page. If you're planning a trip of your own or if you're one of those elusive Random Access Babble super fans I'll happily (if a little wearily) send you a copy of the grand spreadsheet, just drop me and email.

Sunday, May 09, 2010

South East Asia by the Numbers