1.背景
受人所托,帮忙写56份民主生活会谈话意见和建议,不得有大量重复。最近在用python搬砖,于是想到了自动生成。
2.准备工作
既然是写意见和建议,就应该有各种评价,于是我首先建立了一个评价库。
3.读取评价库
在这里由于xlrd模块升级了,读取不了.xlsx文件:
pandas无法打开.xlsx文件,xlrd.biffh.XLRDError: Excel xlsx file; not supported
因此降级重装:
pip uninstall xlrd
pip install xlrd==1.2.0
workbook = xlrd.open_workbook('mark.xls')
print('worksheets is %s' % workbook.sheet_names())
sheet1 = workbook.sheet_by_name(u'Sheet1')
AMOUNT = 31
PERSON_AMOUNT = 56
personal = []
work = []
others = []
expectation = []
for i in range(1, AMOUNT):
personal.append(sheet1.cell(i, 0).value)
work.append(sheet1.cell(i, 1).value)
others.append(sheet1.cell(i, 2).value)
for i in range(1, AMOUNT+3):
expectation.append(sheet1.cell(i, 3).value)
4.生成评价
固定评价句式,生成随机数,随机组装
eva = []
for i in range(PERSON_AMOUNT):
random_1 = (random.randint(0, AMOUNT-2))
random_2 = (random.randint(0, AMOUNT-2))
random_3 = (random.randint(0, AMOUNT-2))
random_4 = (random.randint(0, AMOUNT-2+3))
evaluation = "***同志" + str(personal[random_1]) + ",在工作上 " + str(work[random_2]) + ",为人处世" + str(
others[random_3]) + ", 经过这一次谈话,希望在今后的工作中" + str(expectation[random_4])
print(evaluation)
eva.append(evaluation)
5.结果
6.后记
我大概搞了一下词汇库,四种参数,理论大约可以组装30^4的不完全重复评价,easy。