农产品信息智能推荐平台(7)

最新推荐文章于 2024-10-09 20:00:13 发布

qq_44873362

最新推荐文章于 2024-10-09 20:00:13 发布

阅读量92

点赞数

本文链接：https://blog.csdn.net/qq_44873362/article/details/118863359

版权

农产品信息智能推荐平台(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