Python Pandas & Openpyxl: 处理 Excel 文件并追加数据

import\u0020pandas\u0020as\u0020pd\nimport\u0020os\nimport\u0020re\nfrom\u0020openpyxl\u0020import\u0020Workbook\n\noutput_folder\u0020=\u0020'F:/\u00e8\u00a1\u00a0\u00e5\u008d\u00a0\u00e6\u00a0\u009c\u00e5\u008f\u00b7\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e6\u0095\u00b0/\u00e9\u00a0\u00a4\u00e6\u00a0\u009c\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e6\u0095\u00b0/'\noutput_file\u0020=\u0020None\n\nfor\u0020filename\u0020in\u0020os.listdir(folder_path):\n\t\u0020if\u0020re.match(file_format, filename):\n\t\u0020 \u0020date_str\u0020=\u0020filename[11:19]\n\t\u0020 \u0020file_path\u0020=\u0020os.path.join(folder_path, filename)\n\t\u0020 \u0020yb_data\u0020=\u0020pd.read_csv(file_path, dtype=object, usecols=['\u00e5\u008f\u00b7\u00e9\u00a0\u00a4\u00e6\u0095\u00b0\u00e6\u0095\u00b0\u00e6\u0095\u00b0\u00e6\u008d\u00ae', '\u00e4\u00e0\u00a0\u00e4\u00b8\u008a\u00e8\u00a1\u00a0\u00e6\u0095\u00b0\u00e6\u008d\u00ae', '\u00e5\u008f\u00b7\u00e9\u00a0\u00a4\u00e6\u0095\u00b0\u00e6\u0095\u00b0\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e6\u0095\u00b0\u00e6\u0095\u00b0\u00e6\u008d\u00ae'])\n\t\u0020 \u0020data\u0020=\u0020yb_data[((yb_data['\u00e6\u0095\u00b0\u00e6\u008d\u00ae']\u0020==\u0020'21506')\u0020&\u0020(yb_data['\u00e5\u009c\u00b0\u00e5\u00b8\u0082']\u0020==\u0020'\u00e6\u00a1\u00a0\u00e5\u008d\u00a0\u00e5\u00b7\u00e5\u0088\u0087\u00e5\u00b8\u0082')\u0020&\u0020(yb_data['\u00e4\u00e0\u00a0\u00e4\u00b8\u008a\u00e8\u00a1\u00a0\u00e6\u0095\u00b0\u00e6\u008d\u00ae']\u0020==\u0020'\u00e4\u00e0\u00a0\u00e4\u00b8\u008a\u00e8\u00a1\u00a0\u00e6\u0095\u00b0\u00e6\u008d\u00ae'))]\n\t\u0020 \u0020file_name\u0020=\u0020date_str\u0020+\u0020'\u00e9\u00a0\u00a4\u00e6\u00a0\u009c\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e6\u0095\u00b0\u00e6\u008d\u00ae.xlsx'\n\n\t\u0020 \u0020if\u0020output_file\u0020is\u0020None:\n\t\u0020 \u0020output_file\u0020=\u0020os.path.join(output_folder, file_name)\n\t\u0020 \u0020data.to_excel(output_file, index=False)\n\t\u0020 \u0020else:\n\t\u0020 \u0020with\u0020pd.ExcelWriter(output_file, mode='a', engine='openpyxl')\u0020as\u0020writer:\n\t\u0020 \u0020writer.book\u0020=\u0020Workbook()\n\t\u0020 \u0020writer.sheets\u0020=\u0020{ws.title: ws\u0020for\u0020ws\u0020in\u0020writer.book.worksheets}\n\t\u0020 \u0020data.to_excel(writer, index=False, header=False, startrow=writer.sheets["\u00e5\u00b8\u0088\u00e6\u0096\u00871"].max_row)\n\t\u0020 \u0020writer.save()\n\nprint('\u00e6\u0095\u00b0\u00e6\u008d\u00ae\u00e5\u00ae\u009e\u00e6\u008f\u00ad\u00e5\u008d\u00a0\u00e6\u0095\u00b0!\u0027)