def __get_offset(datetime_index):

    local = pytz.timezone('Europe/Lisbon')
    dt = datetime_index
    offset = [local.utcoffset(dt[x], is_dst=True).seconds / 3600 for x in range(dt.__len__())]
    return offset