python随笔

1、读取excel
import xlrd
data = xlrd.open_workbook(r’0804.xlsx’,encoding_override=“utf-8”)
table = data.sheets()[0] # 打开第一张表
nrows = table.nrows # 获取表的行数
for i in range(nrows-1): # 循环逐行打印
PROPERTY_VALUE=str(table.row_values(i)[0])

2、写入.xls
import xlwt
wbk = xlwt.Workbook()
sheet = wbk.add_sheet(‘sheet 1’)
sheet.write(i, 3, CONTENT)
wbk.save(‘GLKY数据校验0804.xls’)

3、json操作
import json
with open(input_file, ‘r’, encoding=‘utf-8’) as rd:
data_dict = json.load(rd)
#处理 同义词 中的 ”无“
data_dict=no_in_data(data_dict)
with open(output_file, ‘w’, encoding=‘utf-8’) as wt:
new_data_dict1 = get_new_data_dict(data_dict)
new_data_dict = get_last_dict(new_data_dict1)
json.dump(new_data_dict, wt, indent=4, ensure_ascii=False)

#预处理 ”同义词“=”无“
def no_in_data(data_dict):
keys=list(data_dict.keys())
for key in keys:
try:
listtmp=data_dict[key][‘同义词’]
for i in range(len(listtmp)):
if listtmp[i]==“无”:
listtmp.pop(i)
data_dict[key][‘同义词’]=listtmp
except:
pass
data_dict=delete_repeat_key(data_dict)
return data_dict