PracticeProblemsProgram/solveTheProblemInSequence.py at master · CambridgeZ/PracticeProblemsProgram · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
import time
import xlwt
import random
import EndAnswering
import pandas as pd
def solveTheProblemInSequence(xl,df,ws1):# 顺序做题

    #从记录当中读取当一次结束的地方的题号
    serialnumber = 0  # 本题序号,
    with open('lastFinish.txt','r') as f:
        lastRecord = f.readline()  # 本题序号
    if(len(lastRecord)>0):
        serialnumber=int(lastRecord)

    totalnumber = 0  # 总的题目数量
    rightnumber = 0 #正确的题目数量
    wrongnumber = len(xl) #错误的题目数量
    flag = True
    numlist = []
    count = 0  #当前已经完成的题目数量的统计
    totalstarttime = time.time() #开始做题的时间
    while flag == True:
        for randomnumber in range(len(df)): #randomnumber为题目的序号
            if (df.values[randomnumber][1] < serialnumber):  # 实现顺序做题的功能，在退出后可以从上一次退出的地方继续做题
                continue
            listcontent1 = df.values[randomnumber] #读取题目的内容
            count += 1
            listcontent = []
            newanswer = ""
            for r in range(len(listcontent1)):
                listcontent.append(listcontent1[r])
            newlist = []
            chapter = listcontent[2]
            correctanswer = listcontent[8]
            correctcontent = []
            print("\n当前进度{}/{}".format(count, len(df)))
            answerindex = 0
            for t in correctanswer:
                if t == "A":
                    answerindex = 4
                elif t == "B":
                    answerindex = 5
                elif t == "C":
                    answerindex = 6
                elif t == "D":
                    answerindex = 7
                elif t == "E":
                    answerindex = 8
                correctcontent.append(listcontent[answerindex])
            for a in range(len(listcontent)):
                b = random.randint(4, 7)
                c = random.randint(4, 7)
                listcontent[b], listcontent[c] = listcontent[c], listcontent[b]
            newanswer = ""
            newanswer1 = ""
            for u in listcontent:
                if u in correctcontent:
                    w = listcontent.index(u)
                    if w == 4:
                        newanswer1 = "A"
                    elif w == 5:
                        newanswer1 = "B"
                    elif w == 6:
                        newanswer1 = "C"
                    elif w == 7:
                        newanswer1 = "D"
                    elif w == 8:
                        newanswer1 = "E"
                    newanswer += newanswer1
            print("目录:{} 题号:{} \n\n{}——{}\nA:{}\nB:{}\nC:{}\nD:{}".format(listcontent[0], listcontent[1],
                                                                              listcontent[9], listcontent[3],
                                                                              listcontent[4], listcontent[5],
                                                                              listcontent[6], listcontent[7]))
            newlist = listcontent[:8] + [newanswer] + [listcontent[9]]
            starttime = time.time()
            answer = input("请输入答案:")
            if len(answer) == 1 and len(newanswer) != 1 and answer != "?" and answer != " " and answer != "+1":
                answer = input("本题是多选题！请再次输入答案：")
            if len(answer) != 1 and len(newanswer) == 1 and answer != "?" and answer != " " and answer != "+1":
                answer = input("本题是单选题！请再次输入答案：")
            if answer == "+1":
                rightnumber += 1
                answer = input("请输入答案:")
            if answer == "?":
                print("提示:本题是", len(newanswer), "选题")
                answer = input("请再次输入答案：")
            endtime = time.time()
            usedtime = endtime - starttime  # 计算答题使用的时间

            if answer == newanswer or answer.upper() == newanswer:
                print("答案正确")
                totalnumber += len(newanswer)
                rightnumber += len(newanswer)
                print("当前正确率{:.2f}%".format(rightnumber / totalnumber * 100))
            elif answer == "":  # 退出
                check = input("你真的要退出吗，输入1退出：")
                if check == "1":
                    serialnumber = newlist[1]
                    recordOfFinishFilaname= './lastFinish.txt'
                    with open(recordOfFinishFilaname, 'w') as file_object:
                        file_object.write(str(serialnumber) + '\n')
                    flag = False
                    break
            elif str(answer) != str(newanswer):
                # 将错题保存到用于存放错题的excel文件当中
                wrongNumberRecordFileName = './错题记录.txt'
                with open(wrongNumberRecordFileName, 'a') as file_object:
                    file_object.write(str(listcontent[1]) + '\n')
                print("答案错误，本题答案是", newanswer)
                totalnumber += len(newanswer)
                wrongnumber += 1
                print("当前正确率{:.2f}%".format(rightnumber / totalnumber * 100))
                # for t in range(len(newlist)):
                #     if str(newlist[t]) != "nan":
                #         ws1.write(wrongnumber, t, newlist[t])
                #     else:
                #         ws1.write(wrongnumber, t, " ")
            print("本题用时{:.3f}s".format(usedtime))
        else:
            continue

    EndAnswering.EndAnswering(totalnumber, rightnumber, totalstarttime, count)

    wb2 = xlwt.Workbook()
    ws2 = wb2.add_sheet("Sheet1")
    ws2.write(0, 0, "目录")
    ws2.write(0, 1, "题号")
    ws2.write(0, 2, "章节")
    ws2.write(0, 3, "题干")
    ws2.write(0, 4, "选择A")
    ws2.write(0, 5, "选择B")
    ws2.write(0, 6, "选择C")
    ws2.write(0, 7, "选择D")
    ws2.write(0, 8, "答案")
    ws2.write(0, 9, "题型")
    md = pd.read_excel("/Users/mac/Desktop/题库程序/错题记录1.xls")
    for t in range(len(md)):
        listwrong = md.values[t]
        for i in range(len(listwrong)):
            if str(listwrong[7]) != "nan":
                ws2.write(t + 1, i, str(listwrong[i]))
    wb2.save("/Users/mac/Desktop/题库程序/错题记录2.xls")