农产品信息智能推荐平台(7)
整理数据
整理在网站上得到的气温降水以及农作物的数据,将其与原来的数据合并。
path='D:\项目实训--农产品\农产品数据\农作物产量气温降水/'
files=os.listdir(path)
nian=[2017,2018,2019]
for t in range(len(files)):
workbook = xlrd.open_workbook(files[t][0:9] + 'xls')
newbook = copy(workbook)
newsheet = newbook.get_sheet(0)
newsheet2 = newbook.get_sheet(1)
newsheet3 = newbook.get_sheet(2)
for j in range(len(nian)):
newsheet.write(18 + j, 0, nian[j])
newsheet2.write(18 + j, 0, nian[j])
newsheet3.write(18 + j, 0, nian[j])
newbook.save(files[t][0:9] + 'xls')
for i in range(0,3):
shuju1 = pd.read_excel(str(2017 + i) + '气温.xls')
shuju2 = pd.read_excel(str(2017 + i) + '降水.xls')
shuju3 = pd.read_excel(str(2017 + i) + '产量.xls')
print(shuju3)
m=0
for t in range(len(files)):
if i==2 and files[t][1:3]=="莱芜":
continue
else:
workbook = xlrd.open_workbook(files[t][0:9] + 'xls')
sheet = workbook.sheet_by_index(0)
sheet2 = workbook.sheet_by_index(1)
sheet3 = workbook.sheet_by_index(2)
nongzuowu = []
qiwen = []
jiangshui = []
sj3 = shuju3.values
sj1 = shuju1.values
sj2 = shuju2.values
for j in range(0, 13):
qiwen.append(sj1[7 + m][2 + j])
jiangshui.append((sj2[7 + m][2 + j]))
for j in range(0, 9):
nongzuowu.append(sj3[11 + m][2 + j])
newbook = copy(workbook)
newsheet = newbook.get_sheet(0)
newsheet2 = newbook.get_sheet(1)
newsheet3 = newbook.get_sheet(2)
for j in range(len(nongzuowu)):
newsheet.write(18 + i, 1 + j, nongzuowu[j])
for j in range(len(qiwen)):
newsheet2.write(18 + i, 1 + j, qiwen[j])
for j in range(len(jiangshui)):
newsheet3.write(18 + i, 1 + j, jiangshui[j])
newbook.save(files[t][0:9] + 'xls')
m+=1
结果都增加了2017,2018,2019年的数据,以济南为例,如图: