def courseExamQuestionGenerator(self, course_path_info):
self.excel_reader.filepath = course_path_info.examquestion_source_xlsx_filepath
self.excel_reader.sheet_scope_indexes = [0]
# 定义一个question对象
#self.excel_reader.column_scope_names = [u'题目内容', u'选项A', u'选项B', u'选项C', u'选项D', u'选项E', u'答案',u'试题编号',u'题型名称',u'试题类别',u'难度', u'标注知识点']
self.excel_reader.column_scope_names = QuestionInformation.column_head_dict
QuestionInformation.resetColumnValue()
excel_content_rows = self.excel_reader.readFile()
self.exam_info.initByRows(excel_content_rows)
# 语料用的文件
self.createCorpusFile(course_path_info)
# 生成excel试题文件, 正式跑的时候，不用该方法
if self.isTest:
self.createExcelFile()
def createGoodResult2Excel4PersonCheck(self, course_path_info_list):
"""
# 将好的结果输出excel，让人工进行审核
:param course_path_info:
:return:
"""
# 将知识点和试题关联起来
column_data_list = []
column_data_list.append(QuestionInformation.getGoodCorrelationData())
exam_index = 1
for course_path_info in course_path_info_list:
course = course_path_info.course
if not self.exam_info.examquestion_dict.__contains__(course):
continue
exam_question_list = self.exam_info.examquestion_dict.get(course)
for exam_question in exam_question_list:
knowledge_list = exam_question.knowledge_list
k_index = 1
for k in knowledge_list:
if isinstance(k, str):
if len(k.strip()) == 0:
continue
kname = k
kscore = u''
else:
if k.score < 0.45:
continue
kscore = k.score
kname = k.text
kscore = u'{}%'.format(round(kscore * 100, 2))
row = []
if k_index == 1:
exam_index_unicode = UnicodeConvertor.numToUnicode(
exam_index)
row.append(exam_index_unicode)
row.append(exam_question.getOnlyContentAndAnswer())
else:
row.append(u'')
row.append(u'')
row.append(kname)
row.append(kscore)
row.append(u'')
row.append(u'')
row.append(u'')
column_data_list.append(row)
k_index += 1
exam_index += 1
# 一个课程完
# 一组课程完
sheet_datas = {}
sheet_datas['sheet1'] = column_data_list
ExcelWriter.writeExcelFile(
course_path_info_list[0].correlation_good_xls_filepath,
sheet_datas)
print 'Excel文件：{}已生成'.format(
course_path_info_list[0].course.coursebase_name)
def __init__(self):
"""
定义变量
"""
self.excel_reader = ExcelReader.ExcelReader()
self.course_info = None
self.exam_info = QuestionInformation.ExamquestionDictionary()
self.rootpath = u'./../../data/course-knowledge-machine/20181122-200plus'
self.isTest = False