数据清洗过程中对字段类型的处理

def empty_deal_cnt(data):
    '''
    空表示没有,非空表示有
    :param data:
    :return:
    '''
    if isNone(data):
        data = 0
    else:
        try:
            data = int(data)
        except Exception as e:
            data = 0
    return data

def cmp_years(date):
    year = 0
    if isNone(date):
        year = 0
    else:
        try:
            year = datetime.datetime.now().year - float(str(date)[:4])
        except Exception as e:
            year = 0
    return year
 def isNone(d):
    return (d is None or d == 'None' or
            d == '?' or
            d == '' or
            d == 'NULL' or
            d == 'null')


def empty_deal(data):
    '''
    空表示没有,非空表示有
    :param data:
    :return:
    '''
    if isNone(data):
        data = 0
    else:
        data = data
    return data