Recent Posts

  1. Developing Python on Vertica

    Fri 05 July 2019

    Vertica is a very powerful analytics database, and we can easily extend functionality now by building in Python functions. This is great and all, so here I'll focus on setting up a development environment for building a simple UDx.

    The documentation from Vertica is not super specific, so this may …

  2. Wisdom

    Mon 01 July 2019

    This month I turn 30 years old and what a wild ride it has been! I am very grateful for everyone who has been with me for my journey, and am hopeful of many adventures to come.

  3. Welcome Abel Francis

    Mon 22 April 2019

    Abel Francis was born in the afternoon of April 22nd, 2019, at nearly nine pounds!

    Mom and baby are happy and healthy, here's the little man shortly after birth:

    Olson loves his little brother, seen here at a little over a month old:

  4. Boston Marathon 2019

    Mon 15 April 2019

    What a day! Congrats to all the finishers. I count myself very grateful to be at the start line of this one, with my wife at 39 weeks pregnant. Didn't have the run that I had hoped out there, wrote some checks that my legs couldn't cash with a first …

  5. Writing LaTeX in Atom

    Fri 20 July 2018

    Atom is a code editor. The defaults try to "complete" words from your writing, and don't highlight spelling. After many months of using a code editor to write, it's clear that I've gone backwards and I should at least be using spell checking!

    These two settings vastly improve the latex …

  6. Tricks for coercing Pandas into parquet

    Tue 29 May 2018

    For coercing pandas date times (stored as numpy datetime):

    for col in df.columns[df.dtypes == np.dtype('<M8[ns]')]:
        # https://stackoverflow.com/questions/32827169/python-reduce-precision-pandas-timestamp-dataframe
        # apply(lambda x: x.replace(microsecond=0))
        df[col] = df[col].values.astype('datetime64[s]')
    

    For coercing python datetime (here, a datetime.date, there …

  7. How to groupby in Pandas with a missing group

    Wed 25 April 2018

    This is a note intended for my future self. Here’s how to do it:

    1. Have a list of the values that you expect for each group.
    2. Iterate over that list, and look up the values using .loc.

    Say I want to group by months, but not all of the …

  8. Boston 2018

    Mon 16 April 2018

    This was an incredible experience.

    The crowds were just amazing, and seeing my son Olson at mile 6 in the rain and cold was amazing. With the weather, Olson on my mind, and the huge crowds, parts of the race were very emotional.

    At about mile 11-13, I sped up …

Page 1 / 28 »