{"id":109,"date":"2022-01-13T11:30:13","date_gmt":"2022-01-13T03:30:13","guid":{"rendered":"http:\/\/homeyk.com\/?p=109"},"modified":"2024-07-07T19:18:54","modified_gmt":"2024-07-07T11:18:54","slug":"%e6%8f%90%e5%8f%96%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/homeyk.com\/?p=109","title":{"rendered":"python | \u5b9e\u4f8b\u4e4b\u4ece\u6c47\u603b\u8868\u683c\u4e2d\u968f\u673a\u63d0\u53d6\u503c\uff0c\u5339\u914d\u5ea6\u9ad8\u7684\u503c\u4e0d\u91cd\u590d\u63d0\u53d6"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"><em>'''\nEXCEL\u4e2d\u6309\u7167\u8868\u5934\u968f\u673a\u9009\u62e9\u8868\u5934\u4e0b\u7684\u503c\n\u5229\u7528\u5143\u7ec4\u67e5\u91cd\uff0c\u786e\u4fdd\u6240\u53d6\u503c\u4e0d\u91cd\u590d\n'''\n<\/em>import os.path\nimport openpyxl\nimport random\nimport datetime\nfrom fuzzywuzzy import process\n\nfile_add = \"E:\\\\hwang\\\\pyproject\\\\weekmenu\\\\hz\\\\\u6c47\u603b\u8868\u683c.xlsx\"\nroot = \"C:\\\\Users\\\\kc\\\\Desktop\"\nwm = openpyxl.load_workbook(file_add)\nws = wm.active\nxlsx_new = openpyxl.Workbook()\nsheet = xlsx_new.active\n\n# \u83b7\u53d6\u8868\u5934\u5217\u8868\ncount = 0\nlist = []\nfor cell in ws[1]:\n    list.append(cell.value)\nfor i in range(len(list)):\n    print(f\"{count+1} -> {list[i]}\")\n    count += 1\n\nnow_time = datetime.datetime.today().strftime('%Y-%m-%d')\n# \u8d4b\u503c\u5230\u65b0\u7684\u5de5\u4f5c\u8868\u4e2d\nfor x in range(4, 7):\n    print(f\"{list[x]}\u7684\u7ed3\u679c\u662f\uff1a\")\n    menutuple = {}\n    sht = xlsx_new.create_sheet(title=list[x])   #\n\n    for j in range(1, 21):\n        row_random = random.randint(1, ws.max_row)\n        item1 = ws.cell(row=row_random, column=x + 1).value\n        count = 0\n        extrat = process.extractOne(item1, menutuple.values()) #\u5339\u914d\u5ea6\n\n        # \u5339\u914d\u503c \u5927\u4e8e60\u7684\u60c5\u51b5\n        if extrat!=None :\n            while extrat[1] > 80:  # \u786e\u4fdd\u83dc\u5355\u4e0d\u76f8\u4f3c\n                row_random = random.randint(1, ws.max_row)\n                item1 = ws.cell(row=row_random, column=x+1).value\n                extrat = process.extractOne(item1, menutuple.values())\n                print(item1, \"while\",extrat)\n\n        menutuple[j] = item1\n        print(f\"{j}\uff1a{menutuple[j]}    ---->\u539f\u4e3a{ws.cell(row=row_random,column=2).value}\u83dc\u5355\\n\")\n\n        sht.cell(row=j + 1, column=1, value=ws.cell(row=row_random,column=2).value)\n        sht.cell(row=j+1,column=2,value=j) # \u5217\u503c\n        sht.cell(row=1,column=3,value=list[x]) # \u7b2c\u4e00\u884c\n        sht.cell(row=1, column=1, value=now_time)  # \u7ed9A1\u8d4b\u503c\u5f53\u524d\u65f6\u95f4\n        sht.cell(row=j+1, column=3, value=item1)\n\n        sheet.cell(row=j+1,column=1,value=j) # \u5217\u503c\n        sheet.cell(row=1,column=x-2,value=list[x]) # \u7b2c\u4e00\u884c\n        sheet.cell(row=j+1, column=x-2, value=item1)\n        sheet.cell(row=1, column=1, value=now_time)  # \u7ed9A1\u8d4b\u503c\u5f53\u524d\u65f6\u95f4\nsheet.title = f\"{now_time}\"\nnew_name = os.path.join(root, \"\u968f\u673a\u7ed3\u679c\"+now_time+\".xlsx\")\nxlsx_new.save(new_name)\n\n\n\u7ed3\u679c\u9884\u89c8\uff1a\n2022-01-12\t\u5927\u8364\t\u5c0f\u8364\t\u7d20\u83dc\n1\t\u8089\u7247\u7096\u9999\u83c7\u5e72\t\u82b1\u83dc\u7092\u8089\t\u84b2\u74dc\u867e\u76ae\u5c11\u8bb8\n2\t\u7ea2\u70e7\u8d21\u4e38\t\u897f\u7ea2\u67ff\u7092\u9e21\u86cb\t\u7ea2\u70e7\u6bdb\u828b\n3\t\u6728\u8033\u7092\u8089\t\u8089\u4e1d\u7ea2\u841d\u535c\u7092\u9999\u5e72\t\u7ea2\u70e7\u51ac\u74dc\n4\t\u9ec4\u8c46\u7096\u732a\u8e44\t\u7ea2\u70e7\u571f\u8c46\t\u897f\u7ea2\u67ff\u7092\u86cb\n5\t\u9171\u5c11\u8bb8\u8089\t\u8089\u672b\u9e21\u86cb\u7fb9\t\u8089\u672b\u5357\u74dc\n6\t\u83dc\u5e72\u5c11\u8bb8\u8089\t\"\u849c\u82d7\u7092\u9999\u5e72\u7ea2\u841d\u535c\u5c11\u8bb8\"\t\u7ea2\u70e7\u8c46\u8150\u5e72\n7\t\"\u9e4c\u9e51\u86cb\u91d1\u9488\u83c7\u5343\u5f20\"\t\u7092\u8c46\u82bd\t\u82b1\u83dc\u7092\u8089\n8\t\u7ea2\u70e7\u9e21\u7fc5\u6839\t\u7ea2\u70e7\u8c46\u8150\t\u7092\u9752\u83dc\n9\t\u9e21\u7c73\u82b1\t\u4ed4\u6392\u7096\u9ec4\u74dc\t\u7092\u5305\u5fc3\u83dc\n10\t\u7ea2\u70e7\u9e21\u5757\t\u8089\u4e1d\u5305\u5fc3\u83dc\t\u7ea2\u70e7\u65e5\u672c\u5357\u74dc\n11\t\u5c71\u73cd\u8089\u4e38\u8089\u672b\t\u8089\u4e1d\u5343\u5f20\u7092\u82b9\u83dc\t\u83dc\u751f\u7092\u8089\n12\t\u7ea2\u70e7\u9e21\u8089\t\u849c\u82d7\u7092\u8c46\u8150\u5e72\t\u7092\u5927\u767d\u83dc\n13\t\u69a8\u83dc\u7092\u8089\t\u5364\u8377\u5170\u8c46\t\u9752\u6912\u7092\u5343\u5f20\n14\t\u6392\u85d5\u7096\u6392\u9aa8\t\u4ed4\u6392\u7096\u6d77\u5e26\u4e1d\t\u8089\u7247\u7092\u51ac\u74dc\n15\t\u5c0f\u9165\u8089\t\u96ea\u83dc\u571f\u8c46\u8089\u672b\t\u85d5\u4e1d\u7092\u8089\n16\t\u9e2d\u8089\u7096\u7b0b\u5e72\t\u5343\u5f20\u7092\u841d\u535c\u4e1d\t\u6cb9\u6ce1\u7c89\u4e1d\n17\t\u7ea2\u70e7\u9e21\u7fc5\u5c16\t\u867e\u76ae\u5c11\u8bb8\u84b2\u74dc\t\u83dc\u751f\u5c11\u8bb8\u9ec4\u74dc\n18\t\u7ea2\u70e7\u9999\u80a0\t\u65e5\u672c\u5357\u74dc\u8089\u672b\t\u7092\u85d5\u4e1d\n19\t\u7ea2\u70e7\u8089\u5c0f\u6cb9\u6ce1\t\u4ed4\u6392\u7096\u85d5\u5757\t\u6392\u9aa8\u7096\u9ec4\u74dc\u5757\n20\t\u5343\u5f20\u8089\u4e1d\u7ea2\u841d\u535c\u5c11\u8bb8\t\u8089\u672b\u65e5\u672c\u5357\u74dc\t\u7092\u897f\u846b\u82a6\n\n\n\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8221;&#8217; EXCEL\u4e2d\u6309\u7167\u8868\u5934\u968f\u673a\u9009\u62e9\u8868\u5934\u4e0b\u7684\u503c \u5229\u7528\u5143\u7ec4\u67e5\u91cd\uff0c\u786e\u4fdd\u6240\u53d6\u503c\u4e0d\u91cd\u590d &#8221;&#8217; import os.path import openpyxl import random import datetime from fuzzywuzzy import process file_add = &#8220;E:&hellip;<\/p>\n<p> <a class=\"more-link\" href=\"http:\/\/homeyk.com\/?p=109\">\u7ee7\u7eed\u9605\u8bfb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[15,16],"_links":{"self":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/109"}],"collection":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=109"}],"version-history":[{"count":1,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":155,"href":"http:\/\/homeyk.com\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions\/155"}],"wp:attachment":[{"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/homeyk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}