Skip to content

Instantly share code, notes, and snippets.

View smaroukis's full-sized avatar

Spencer Maroukis smaroukis

View GitHub Profile
def col_to_int(col):
"""Converts excel COL to INT (zero indexed)"""
if len(col) == 1:
return ord(col.upper()) - ord('A')
if len(col) == 2:
n_alphabet = 26
return (col_to_int(col[0])+1)*n_alphabet+col_to_int(col[1])
# for DateTimeIndexed DataFrames
for name, group in df.groupby([lambda x: x.date(), 'Some Feature']):
# within groupby object
# for dropping duplicate indices (sometimes a problem with DateTimeIndices)
group=group[~group.index.duplicated(keep = 'first')]