As part of our hand editing of the TED talk data we had to retrieve missing information for, luckily, a small subset of the speakers. This meant Kinnaird splitting off two CSVs, one for the TED main event speakers and one for the other TED-sponsored event speakers, and then me trudging row by row and cell by cell, working back and forth between the CSV and a web page. Copy and pasted and two CSVs filled in. Yes.

Then it was time to fold these filled in rows back into the main CSVs from whence they came. Each smaller CSV had between 15 and 20 rows, so it didn’t seem like a task worthy of firing up a Python session and writing something in pandas to replace the rows with missing information with the filled-in rows.

I started doing the work by hand: copy a row from the missing.csv and paste it below the matching row in the speakers.csv and then deleting the matched row. Oi! Sure it was only 17 rows, but, still, there has to be a somewhat faster way!

So I decided to merge the two files using cat and then simply finding the dupes in Easy CSV Editor and deleting the row with missing data. Semi-automated?

Found note

Found with the date 26 July 2016:

Books/master notes for a class on “Folklore and Psychology” as well as, looking backwards, perhaps the same thing for Louisiana Folklore. The idea being that the book would also be interactive with questions and guided experiences as well as case studies.

Splitting Wood

As I continue to observe the maelstrom of negativity and falsehoods that is Facebook, I still want to make notes about things that happen. And I want to be able to share those notes. And then I remember that I have this blog, which is what web logs, or blogs, were supposed to be before they turned into self-publishing platforms and the key to modern success.

I am not yet decided on how much I want to reclaim this particular domain — my own name (jl.o) — or some other space where I don’t feel responsible for hosting certain pages which have become mainstays, seemingly, on the web. On the one hand, this was once my “everything that doesn’t have any other place to go goes here” space. And a chunk of that stuff was about my daughter when she was young, but then the internet got creepy and I shifted from talking about her in what I now understood was probably an all too public forum. At the same time, as blogs “came of age” and became vehicles for the blossoming of personalities, some of whom became celebrities — e.g., John Gruber or Merlin Mann — I became increasingly concerned about “managing my brand.” That this blog was a space for me to demonstrate my professional abilities and to discuss professional interests.

And then I started tracking my experiments with computational matters and suddenly this thing got popular. Other people wanting to experiment with Python and/or with thinking about texts as data were searching for things and they found a post of two of mine that was helpful and they must have told people about them because suddenly this thing had something of a readership. It freaked me out so much that I froze like the proverbial deer in headlights and stopped publishing.

And now those pages that people found useful then are still being found useful, but I haven’t tracked my voyage, and discoveries, since then, and now it feels all weird to come back to this, especially since I have Evernote for web capture and Bear for everything else, including capturing all those stray thoughts that shoot through my head like neutrinos making their way across the solar system. But both of those applications somewhat obscure where your data is — in order, I think, to make sure you don’t mess with it outside the app and possibly corrupt the sync process.

There is, I think, something remarkably re-assuring about writing all my notes in plain text — structured with some version of markdown — and storing them in plain files or in a widely-known data structure like SQL. An ideal format, to my mind, would be something like FoldingText as the UI and MySQL on the backend with a blog an easy offshoot and one simply tags, or otherwise indicates which posts are public — it would have to be a choice each and every time.

Part of all this is, I admit, in addition to a response to the way matters are developing on Facebook but also my own preference not to give over my data to someone else so that they can then monetize it. That is, by using Facebook to stay in touch with family and friends, instead of other means, I’m allowing the company to profit from my relationships. That was acceptable, to some degree, when it was a happier place, but now I find that the dark side has emerged, and it has me not only walking away from the platform, but also considering walking away from some relationships.

So, this is not only about taking a break from at least one form of social media, but also about re-focusing my own energies and making my writing my own and finding positive places in which to publish it.

I did this thinking, by the way, while splitting wood, using a maul and wedge given to me by my stepfather and an old hatchet I had lying around the house. There’s no better time to focus then when trying to follow the grain of a log, especially when you find you’ve driven a wedge into an unsplittable natural joint in the wood:

IMG 0612

The whispy shadows of hair in the lower left are my child, still finding her way into this blog, who took this photo for me as I stood nearby, somewhat hunched over and breathing hard …

… I guess I need to split more wood.