I'm able to recreate the 2nd table by creating an index using df.map(lamda x: x.startswith(""), then recreating a DataFrame with the series. I suppose I could loop through and append to the DataFrame, however I feel like there should be a much smarter method to doing this.
–
ast4Oct 25 '12 at 16:09