{ "cells": [ { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "True\n" ] }, { "ename": "TypeError", "evalue": "'float' object is not subscriptable", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mTypeError\u001b[0m Traceback (most recent call last)", "Cell \u001b[1;32mIn[13], line 100\u001b[0m\n\u001b[0;32m 98\u001b[0m \u001b[38;5;28mprint\u001b[39m(data5[\u001b[38;5;241m2\u001b[39m][\u001b[38;5;241m0\u001b[39m][\u001b[38;5;241m0\u001b[39m]\u001b[38;5;241m<\u001b[39m\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mD\u001b[39m\u001b[38;5;124m'\u001b[39m)\n\u001b[0;32m 99\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mrange\u001b[39m(\u001b[38;5;28mlen\u001b[39m(data5)):\n\u001b[1;32m--> 100\u001b[0m \u001b[38;5;28mprint\u001b[39m(data5[\u001b[38;5;241m27\u001b[39m][\u001b[38;5;241m0\u001b[39m][\u001b[38;5;241m0\u001b[39m])\n\u001b[0;32m 101\u001b[0m \u001b[38;5;250m \u001b[39m\u001b[38;5;124;03m'''if data5[i][0][0] < 'D':\u001b[39;00m\n\u001b[0;32m 102\u001b[0m \u001b[38;5;124;03m \u001b[39;00m\n\u001b[0;32m 103\u001b[0m \u001b[38;5;124;03m to_m[ord(data5[i][0][0])-65][data5[i][1]][0] += data5[i][4]\u001b[39;00m\n\u001b[1;32m (...)\u001b[0m\n\u001b[0;32m 108\u001b[0m \u001b[38;5;124;03m else:\u001b[39;00m\n\u001b[0;32m 109\u001b[0m \u001b[38;5;124;03m to_m[ord(data5[i][0][0])-65][data5[i][1]][1] += data5[i][4]'''\u001b[39;00m\n", "\u001b[1;31mTypeError\u001b[0m: 'float' object is not subscriptable" ] } ], "source": [ "import pandas as pd\n", "import numpy as np\n", "import pandas as pd\n", "\n", "df = pd.read_excel('1.xlsx')\n", "#去掉表头并转换数据类型\n", "df = df.iloc[0:,2]\n", "#提取每块土地的面积数据\n", "data1 = df.values.tolist()\n", "area_A=[data1[_] for _ in range(len(data1))]\n", "\n", "df = pd.read_excel('1.xlsx',sheet_name=\"乡村种植的农作物\")\n", "#去掉表头并转换数据类型\n", "df = df.iloc[0:41,5:8]\n", "data2 = df.values.tolist()\n", "#去年每种植物的总产量\n", "\n", "\n", "df=pd.read_excel('2.xlsx',sheet_name=\"2023年统计的相关数据\")\n", "#去掉表头并转换数据类型\n", "df=df.iloc[0:107,7]\n", "data3=df.values.tolist()\n", "\n", "# 使用split方法通过 \"-\" 进行拆分\n", "\n", "\n", "#亩产信息ye[i][j][s]\n", "#种植成本c[i][j][s]\n", "df=pd.read_excel('2.xlsx',sheet_name=\"2023年统计的相关数据\")\n", "df=df.iloc[0:107,5:8]\n", "data4=df.values.tolist()\n", "\n", "T=7\n", "I=54\n", "J=41\n", "S=2\n", "ye=[[[0,0] for j in range(J) ]for i in range(I)]\n", "c=[[[0,0] for j in range(J) ]for i in range(I)]\n", "m0=[[[0,0] for j in range(J) ]for i in range(I)]\n", "for i in range(I):\n", " \n", " if i < 26:\n", " for k in range(15):\n", " ye[i][k][0] = data4[k][0]\n", " c[i][k][0] = data4[k][1]\n", " da,db=data4[k][2].split(\"-\")\n", " m0[i][k][0] = (float(da)+float(db))/2\n", " if 26<= i < 34:\n", " ye[i][15][0]=500\n", " c[i][15][0]=680\n", " m0[i][15][0] = 7\n", " for k in range(18):\n", " ye[i][16+k][0] = data4[46+k][0]\n", " c[i][16+k][0] = data4[46+k][1]\n", "\n", " da,db=data4[46+k][2].split(\"-\")\n", " m0[i][16+k][0] = (float(da)+float(db))/2\n", " for k in range(3):\n", " ye[i][34+k][1] = data4[82+k][0]\n", " c[i][34+k][1] = data4[82+k][1]\n", " \n", " da,db=data4[82+k][2].split(\"-\")\n", " m0[i][34+k][1] = (float(da)+float(db))/2\n", " if 35<= i < 50:\n", " for k in range(18):\n", " ye[i][16+k][0] = data4[64+k][0]\n", " c[i][16+k][0] = data4[64+k][1]\n", " \n", " da,db=data4[64+k][2].split(\"-\")\n", " m0[i][16+k][0] = (float(da)+float(db))/2\n", " for k in range(3):\n", " ye[i][37+k][1] = data4[85+k][0]\n", " c[i][37+k][1] = data4[85+k][1]\n", "\n", " da,db=data4[85+k][2].split(\"-\")\n", " m0[i][37+k][1] = (float(da)+float(db))/2\n", " if 51<= i < 66:\n", " for k in range(18): \n", " ye[i][16+k][0] = data4[64+k][0]\n", "

1周前