import\s+pandas\s+as\s+pd\nimport\s+os\nimport\s+re\nfrom\s+openpyxl\s+import\s+Workbook\n\noutput_folder\s+=\s+'F:/自动验单数据/验本数据/'\noutput_file\s+=\s+None\n\nfor\s+filename\s+in\s+os.listdir(folder_path):\n\tif\s+re.match(file_format,\s+filename):\n\t\tdate_str\s+=\s+filename[11:19]\n\t\tfile_path\s+=\s+os.path.join(folder_path,\s+filename)\n\t\tyb_data\s+=\s+pd.read_csv(file_path,\s+dtype=object,\s+usecols=['发验机构',\s+'上下行','发验时间'])\n\t\tdata\s+=\s+yb_data[((yb_data['机构']\s+==\s+'21506')\s+&\s+(yb_data['地市']\s+==\s+'扬州市')\s+&\s+(yb_data['上下行']\s+==\s+'上行'))]\n\t\tfile_name\s+=\s+date_str\s+'+\s+'验本数据.xlsx'\n\t\t\n\t\tif\s+output_file\s+is\s+None:\n\t\t\toutput_file\s+=\s+os.path.join(output_folder,\s+file_name)\n\t\t\tdata.to_excel(output_file,\s+index=False)\n\t\telse:\n\t\t\twriter\s+=\s+pd.ExcelWriter(output_file,\s+mode='a',\s+engine='openpyxl')\n\t\t\twriter.book\s+=\s+Workbook()\n\t\t\twriter.sheets\s+=\s+{ws.title:\s+ws\s+for\s+ws\s+in\s+writer.book.worksheets}\n\t\t\tdata.to_excel(writer,\s+index=False,\s+header=False,\s+startrow=writer.sheets['Sheet1'].max_row)\n\t\t\twriter.save()\n\nprint('匹配完成!')

Python pandas: 合并多个 CSV 文件到一个 Excel 文件 (修复 AttributeError)

原文地址: https://www.cveoy.top/t/topic/pZKk 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录