dataclean.py 文件源码

def dataClean():

    if EdulistModel.table_exists() == False:
        EdulistModel.create_table()

    schools = SelectQuery(EdulistModel).select().where(EdulistModel.postcode == '')
    print(schools.count())
    for school in schools:
        # category = school.category
        print(school.postcode)
        # category = category.replace(' ', '')
        # category = category.replace('\t', '')
        # category = category.replace('\n', '')
        # category = category.replace('\r', '?')
        # print(category)
        # school.category = category
        # school.save()