smaroukis

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])

smaroukis

# 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')]