Category Archives: What I’ve been reading lately

Time Tracking and the Reality of Self Care

Everyone likes to talk about the importance of self care. I did a podcast episode on it last fall. I think where we are in the discourse on this is that what we call self care for some people we call indulgence for others, and this is tied to class and race. For some reason pedicures seem to be the thing people talk about the most. That isn’t at all appealing to me, and speaking of class and race problems, pedicures are also a gold standard for those.

What I call “self care” is usually a not all that fun thing to do. Getting exercise or going out to professional networking events aren’t necessarily fun, but you rarely regret having done it. Self care is about creating an appealing life for yourself, but with the recognition that creating long-term happiness requires a lot of day-to-day unhappiness and sacrifice. The reality of this struck me about six weeks ago when I did a 168 hours time tracking project, as described by Laura Vanderkam. She’s a prolific writer and has four kids, so she knows about making use of time. I read her book I Know How She Does It last summer and expected to disagree with it. I’d been a devotee of Cal Newport and Deep Work for some time, but the ideals of that book are hard for me to work right now, and I was spending a lot of time feeling bad about myself because of that. Basically the two are saying the same thing: figure out what you need/want to happen, and make the time to do it. But I Know How She Does It is about looking at the entire tapestry of your life and figuring out where things go, and not feeling bad about how it looks. You can work a lot, spend a lot of time with your kids, and sleep a lot, but it takes some thought to see how things are going and what needs to happen to improve it.

The way she has people does this is to fill out a spreadsheet with your entire week in 15 minute increments, and then track how much time you spend on each thing. For instance, the week of March 28 I got approximately 7.8 hours of sleep on average per night. Not bad! I spend about 4.5 hours a day on average with my kids, though with a lot more of that on the weekends, and some at 3 in the morning. On the other hand, I only spent 4.5 hours total the whole week doing what I would characterize as truly relaxing. My other non-work time was (that week) doing an 8K race, going out for a pre-race dinner, doing yoga, attending a book group, pumping milk (4.25 hours), shopping, podcast recording, and many other things. It was a weird week, but showed me I could get a lot done in a week that made an interesting life. I did this for another week as well, and got similar results, but managed to not fill out the whole thing. It was a good exercise to make sure that I was thinking about what way I was using the next 15 minutes.

And that, right there, is the crux. You can’t do everything. If you want to work out for 15 minutes, you can’t spend that 15 minutes cleaning. If you want to read for 15 minutes, you can’t write during that same time. You can listen to an audiobook while cleaning, or write while commuting by train, etc. But mostly, you have to pick what to do. Looking at that tapestry of a week you have to figure out what to sacrifice to make something else happen. And with kids or other care taking responsibilities, you often don’t get to pick–your plans can change in a moment. I meant to write this post weeks ago, but kept postponing because other things came up. Today I am procrastinating on another project, so I decided to spend my 15 minutes writing. I’ve sacrificed another opportunity, but in acknowledging that I can also acknowledge that what you do shapes your life, and you should choose when you can.

I live in a dense urban environment surrounded by apartments, taxis, etc., but I happen to live in a house with a wonderful backyard where we grow vegetables, fruit, and flowers in addition to a lawn I mow with a manual push mower. It’s winter now, but we still manage to find some joy in the garden with my “visual interest” plantings that may more signal lack of weeding. (I have a 5 month old, it’s hard to keep up).

I’ve been reading a lot about rural life and farming lately. Various things converged to make this happen. Anyway, there’s a lot of writing about the contentment that comes in connection to land and place, even if it appears to outsiders to constrict choice. I’ve never really read Wendell Berry before, but I’m going to start, because I think he has a lot of value to say about life in rural areas that comes from a more useful point of view than the bloviating in political discourse.

I don’t think technology entrepreneurs need to farmsplain rural life to people who live there, who aren’t all the same and don’t think all the same.

Review of Using OpenRefine by Ruben Verborgh and Max De Wilde

Using OpenrefineUsing Openrefine by Ruben Verborgh

My rating: 4 of 5 stars

Disclosure: the publisher of this book provided me with a free copy in exchange for a review. The opinions expressed in the review are my own.

While OpenRefine is an extremely useful “power tool for messy data”, its power can be difficult to master without a great deal of trial and error on the part of the user. Part of this stems from the evolving nature of the tool. It began life as Freebase Gridworks, with the purpose of cleaning up data in order to run it against linked data in Freebase. When the Freebase parent organization was acquired by Google, they rebranded the tool as Google Refine, but as Google’s priorities shifted, they stopped working on the tool and it became the open source OpenRefine. This legacy means that the tool has many pieces created by different people for different purposes. While there is quite a lot of good documentation out there on the OpenRefine site and elsewhere, this book puts it together in a easy to follow format. Like a lot of OpenRefine documentation, it is a series of “recipes” that explain how to do one specific task, but is written with the cover to cover reader in mind as well. The Google produced tutorial videos have similar coverage, but the book is more in depth, and has the advantage for readers coming from the cultural institution side of using a museum data set for examples. Another advantage is that the authors of the book have a particular interest in named entity recognition (part of the book covers the tool that one of them produced), which is particularly helpful for more abstract data sets with cultural data.

Using OpenRefine is useful for beginner or intermediate users of OpenRefine. As someone who has used OpenRefine for awhile and written about its use in libraries, this was more helpful than I expected initially, since there were pieces of functionality I’d not yet encountered in experimentation or documentation so far. My one criticism is that much of the book promises a complete explanation in the appendix of regular expressions and the Google Refine Expression Language that powers the software, but I found that the GREL documentation was less useful than I hoped, though I still learned from it. I would have preferred if that section had been earlier in the book. That aside, I would recommend this book to anyone who has been using OpenRefine or thinking about using it, and additionally for library and museum professional development collections.

View all my reviews