python 银行数据分析整理

银行数据分析整理

#  银行明细整理
    def bankTrans():
        file_path = ".\\bk.xls"

        if os.path.exists(file_path):
            replace_excel(".", "bk.xls")
            os.unlink(file_path)

        file_path = ".\\bk.xlsx"
        total_list = readFromExcel(file_path)
        os.unlink(file_path)
        print("成功读取{}条数据".format(len(total_list)))

        a = input("请选择银行：\n 1.中国银行个人户\n 11.中国银行一般户\n 2.农业\n 3.工商\n 31.工商银行个人账户\n 4.建设\n 5.民生\n 6.北京农商\n ")
        if a == "1":
            print("你选择的是:中国银行个人户")
            new_list = cbPersonalBankProcessDo(total_list)
        if a == "11":
            print("你选择的是:中国银行一般户")
            new_list = cbBankProcessDo(total_list)
        if a == "2":
            print("你选择的是:农业银行")
            new_list = abcBankProcessDo(total_list)
        if a == "3":
            print("你选择的是:工商银行")
            new_list = icbcBankProcessDo(total_list)
        if a == "31":
            print("你选择的是:工商银行个人账户")
            new_list = icbcPersonalBankProcessDo(total_list)
        if a == "4":
            print("你选择的是:建设银行")
            new_list = ccbBankProcessDo(total_list)
        if a == "5":
            print("你选择的是:民生银行")
            new_list = cmbcBankProcessDo(total_list)
        if a == "6":
            print("你选择的是:北京农商银行")
            new_list = bjrcbBankProcessDo(total_list)

        print("--------银行交易明细格式转换--------\n")
        writeToExcel(".\\bkok.xlsx", new_list)