{"id":1679,"date":"2023-05-03T08:33:07","date_gmt":"2023-05-03T00:33:07","guid":{"rendered":"http:\/\/viplao.com\/?p=1679"},"modified":"2023-05-03T08:42:45","modified_gmt":"2023-05-03T00:42:45","slug":"%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/","title":{"rendered":"\u8fd0\u7ef4\u5de5\u5177 \u2013 PYTHON \u65e5\u5e38\u6570\u636e\u5206\u6790 \u2013\u00a0EXCEL\u5e38\u7528\u9ad8\u7ea7\u51fd\u6570\u5904\u7406\u6280\u5de7"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u6587\u7ae0\u76ee\u5f55<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/#%E6%A1%88%E4%BE%8B01_%E6%89%B9%E9%87%8F%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\" title=\"\u6848\u4f8b01 \u6279\u91cf\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868\">\u6848\u4f8b01 \u6279\u91cf\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/#%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E4%B8%BA%E4%B8%80%E4%B8%AA%E5%B7%A5%E4%BD%9C%E7%B0%BF%E7%9A%84%E6%89%80%E6%9C%89%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\" title=\"\u4e3e\u4e00\u53cd\u4e09 \u4e3a\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u7684\u6240\u6709\u5de5\u4f5c\u8868\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868\">\u4e3e\u4e00\u53cd\u4e09 \u4e3a\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u7684\u6240\u6709\u5de5\u4f5c\u8868\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/#%E6%A1%88%E4%BE%8B02_%E4%BD%BF%E7%94%A8%E6%96%B9%E5%B7%AE%E5%88%86%E6%9E%90%E5%AF%B9%E6%AF%94%E6%95%B0%E6%8D%AE%E7%9A%84%E5%B7%AE%E5%BC%82\" title=\"\u6848\u4f8b02 \u4f7f\u7528\u65b9\u5dee\u5206\u6790\u5bf9\u6bd4\u6570\u636e\u7684\u5dee\u5f02\">\u6848\u4f8b02 \u4f7f\u7528\u65b9\u5dee\u5206\u6790\u5bf9\u6bd4\u6570\u636e\u7684\u5dee\u5f02<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/#%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E7%BB%98%E5%88%B6%E7%AE%B1%E5%BD%A2%E5%9B%BE%E8%AF%86%E5%88%AB%E5%BC%82%E5%B8%B8%E5%80%BC\" title=\"\u4e3e\u4e00\u53cd\u4e09 \u7ed8\u5236\u7bb1\u5f62\u56fe\u8bc6\u522b\u5f02\u5e38\u503c\">\u4e3e\u4e00\u53cd\u4e09 \u7ed8\u5236\u7bb1\u5f62\u56fe\u8bc6\u522b\u5f02\u5e38\u503c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/#%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E4%BD%BF%E7%94%A8%E8%87%AA%E5%AE%9A%E4%B9%89%E5%8C%BA%E9%97%B4%E7%BB%98%E5%88%B6%E7%9B%B4%E6%96%B9%E5%9B%BE\" title=\"\u4e3e\u4e00\u53cd\u4e09 \u4f7f\u7528\u81ea\u5b9a\u4e49\u533a\u95f4\u7ed8\u5236\u76f4\u65b9\u56fe\">\u4e3e\u4e00\u53cd\u4e09 \u4f7f\u7528\u81ea\u5b9a\u4e49\u533a\u95f4\u7ed8\u5236\u76f4\u65b9\u56fe<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\" id=\"%E6%A1%88%E4%BE%8B06-%E6%89%B9%E9%87%8F%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\"><span class=\"ez-toc-section\" id=\"%E6%A1%88%E4%BE%8B01_%E6%89%B9%E9%87%8F%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\"><\/span><strong>\u6848\u4f8b01 \u6279\u91cf\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u6279\u91cf\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u5546\u54c1\u9500\u552e\u8868\uff08\u6587\u4ef6\u5939\uff09<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"736\" height=\"203\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-3.png\" alt=\"\" class=\"wp-image-1680\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-3.png 736w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-3-300x83.png 300w\" sizes=\"(max-width: 736px) 100vw, 736px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>import os\nimport xlwings as xw\nimport pandas as pd\napp=xw.App(visible=True,add_book=False)\nfile_path=r'd:\\\\22\\\u5546\u54c1\u9500\u552e\u8868'\nfile_list=os.listdir(file_path)\nfor i in file_list:\n    if os.path.splitext(i)&#91;1]=='.xlsx':\n        workbook=app.books.open(file_path+'\\\\'+i)\n        for j in workbook.sheets:\n            values=j.range('A1').expand().options(pd.DataFrame).value\n            pivottable=pd.pivot_table(values,values='\u9500\u552e\u91d1\u989d' #\u6c47\u603b\u5b57\u6bb5\u4e3a\u9500\u552e\u91d1\u989d\n                                      ,index='\u9500\u552e\u5730\u533a'  #\u6307\u5b9a\u884c\u5b57\u6bb5\u4e3a\u9500\u552e\u5730\u533a\n                                      ,columns='\u9500\u552e\u5206\u90e8' #\u5217\u5b57\u6bb5\u4e3a\u9500\u552e\u5206\u90e8\n                                      ,aggfunc='sum' #\u6c47\u603b\u8ba1\u7b97\u65b9\u5f0f\u4e3a\u6c42\u548c\n                                      ,fill_value=0  #\u7f3a\u5931\u503c\u586b\u51450\n                                      ,margins=True #\u663e\u793a\u6c47\u603b\u884c\u5217\n                                      ,margins_name='\u603b\u8ba1'  #\u6570\u636e\u884c\u7684\u540d\u79f0\n                                     ) \n            j.range('J1').value=pivottable\n            j.autofit()\n        workbook.save()\n        workbook.close()\napp.quit() \n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89-%E4%B8%BA%E4%B8%80%E4%B8%AA%E5%B7%A5%E4%BD%9C%E7%B0%BF%E7%9A%84%E6%89%80%E6%9C%89%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\"><span class=\"ez-toc-section\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E4%B8%BA%E4%B8%80%E4%B8%AA%E5%B7%A5%E4%BD%9C%E7%B0%BF%E7%9A%84%E6%89%80%E6%9C%89%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%88%B6%E4%BD%9C%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\"><\/span><strong>\u4e3e\u4e00\u53cd\u4e09 \u4e3a\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u7684\u6240\u6709\u5de5\u4f5c\u8868\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u4e3a\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u7684\u6240\u6709\u5de5\u4f5c\u8868\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u5546\u54c1\u9500\u552e\u8868.xlsx<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>import os\nimport xlwings as xw\nimport pandas as pd\napp=xw.App(visible=True,add_book=False)\nworkbook=app.books.open(r'd:\\22\\\u5546\u54c1\u9500\u552e\u8868.xlsx')\nfor i in workbook.sheets:\n    values=i.range('A1').expand().options(pd.DataFrame).value\n    pivottable=pd.pivot_table(values,values='\u9500\u552e\u91d1\u989d' #\u6c47\u603b\u5b57\u6bb5\u4e3a\u9500\u552e\u91d1\u989d\n                              ,index='\u9500\u552e\u5730\u533a'  #\u6307\u5b9a\u884c\u5b57\u6bb5\u4e3a\u9500\u552e\u5730\u533a\n                              ,columns='\u9500\u552e\u5206\u90e8' #\u5217\u5b57\u6bb5\u4e3a\u9500\u552e\u5206\u90e8\n                              ,aggfunc='sum' #\u6c47\u603b\u8ba1\u7b97\u65b9\u5f0f\u4e3a\u6c42\u548c\n                              ,fill_value=0  #\u7f3a\u5931\u503c\u586b\u51450\n                              ,margins=True #\u663e\u793a\u6c47\u603b\u884c\u5217\n                              ,margins_name='\u603b\u8ba1'  #\u6570\u636e\u884c\u7684\u540d\u79f0\n                             ) \n    i.range('J1').value=pivottable\n    i.autofit()\nworkbook.save()\nworkbook.close()\napp.quit() \n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"%E6%A1%88%E4%BE%8B08-%E4%BD%BF%E7%94%A8%E6%96%B9%E5%B7%AE%E5%88%86%E6%9E%90%E5%AF%B9%E6%AF%94%E6%95%B0%E6%8D%AE%E7%9A%84%E5%B7%AE%E5%BC%82\"><span class=\"ez-toc-section\" id=\"%E6%A1%88%E4%BE%8B02_%E4%BD%BF%E7%94%A8%E6%96%B9%E5%B7%AE%E5%88%86%E6%9E%90%E5%AF%B9%E6%AF%94%E6%95%B0%E6%8D%AE%E7%9A%84%E5%B7%AE%E5%BC%82\"><\/span><strong>\u6848\u4f8b02 \u4f7f\u7528\u65b9\u5dee\u5206\u6790\u5bf9\u6bd4\u6570\u636e\u7684\u5dee\u5f02<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u4f7f\u7528\u65b9\u5dee\u5206\u6790\u5bf9\u6bd4\u6570\u636e\u7684\u5dee\u5f02.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u65b9\u5dee\u5206\u6790.xlsx<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"737\" height=\"311\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-5.png\" alt=\"\" class=\"wp-image-1682\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-5.png 737w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-5-300x127.png 300w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-5-711x300.png 711w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/figure>\n\n\n\n<p>\u5728Python\u4e2d\u505a\u65b9\u5dee\u5206\u6790\uff0c\u8981\u7528\u5230\u4e0e\u65b9\u5dee\u5206\u6790\u76f8\u5173\u7684statsmodels.formula.api\u6a21\u5757\u548cstatsmodels.stats.anova\u6a21\u5757\uff0c\u4ee5\u53caols()\u51fd\u6570\u548canova_lm()\u51fd\u6570\u3002\u4e0b\u9762\u4e00\u8d77\u6765\u770b\u770b\u5177\u4f53\u7684\u4ee3\u7801\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nfrom statsmodels.formula.api import ols  #\u5bfc\u5165\u65b9\u5dee\u5206\u6790\u7684\u6a21\u5757\nfrom statsmodels.stats.anova import anova_lm\nimport xlwings as xw\ndf=pd.read_excel(r'd:\\22\\\u65b9\u5dee\u5206\u6790.xlsx')\ndf=df&#91;&#91;'A\u578b\u53f7','B\u578b\u53f7','C\u578b\u53f7','D\u578b\u53f7','E\u578b\u53f7']]  #\u9009\u53d6ABCDE\u7684\u578b\u53f7\u7684\u5217\u4f5c\u4e3a\u5206\u6790\n\ndf_melt=df.melt() #\u5c06\u5217\u540d\u8f6c\u6362\u6210\u5217\u6570\u636e\ndf_melt.columns=&#91;'Treat','Value']  #\u91cd\u547d\u540d\u5217\u540d\n\ndf_describe=pd.DataFrame()\ndf_describe&#91;'A\u578b\u53f7']=df&#91;'A\u578b\u53f7'].describe()  #\u8ba1\u7b97A\u578b\u53f7\u7684\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\ndf_describe&#91;'B\u578b\u53f7']=df&#91;'B\u578b\u53f7'].describe()  #\u8ba1\u7b97A\u578b\u53f7\u7684\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\ndf_describe&#91;'C\u578b\u53f7']=df&#91;'C\u578b\u53f7'].describe()  #\u8ba1\u7b97A\u578b\u53f7\u7684\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\ndf_describe&#91;'D\u578b\u53f7']=df&#91;'D\u578b\u53f7'].describe()  #\u8ba1\u7b97A\u578b\u53f7\u7684\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\ndf_describe&#91;'E\u578b\u53f7']=df&#91;'E\u578b\u53f7'].describe()  #\u8ba1\u7b97A\u578b\u53f7\u7684\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\n\nprint(df_describe)\nmodel=ols('Value~C(Treat)',data=df_melt).fit()  #\u5bf9\u6837\u672c\u6570\u636e\u8fdb\u884c\u6700\u5c0f\u4e8c\u4e58\u73b0\u884c\u62df\u5408\u8ba1\u7b97\nanova_table=anova_lm(model,typ=3)  #\u5bf9\u6837\u672c\u8fdb\u884c\u65b9\u5dee\u5206\u6790\n\nprint(model)\nprint(anova_table)\napp=xw.App(visible=True,add_book=False)\nworkbook=app.books.open(r'C:\\Users\\Administrator\\Desktop\\22\\\u65b9\u5dee\u5206\u6790.xlsx')\nworksheet=workbook.sheets&#91;'\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790']  #\u9009\u4e2d\u5de5\u4f5c\u8868\u2018\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790\u2019\n\nworksheet.range('H2').value=df_describe.T  #\u5c06\u8ba1\u7b97\u51fa\u7684\u5e73\u5747\u503c\u3001\u6700\u5c0f\u503c\u3001\u6700\u5927\u503c\u7b49\u6570\u636exieru\nworksheet.range('H14').value='\u65b9\u5dee\u5206\u6790'\nworksheet.range('H15').value=anova_table #\u5c06\u65b9\u5dee\u5206\u6790\u7684\u7ed3\u679c\u5199\u5165\u5de5\u4f5c\u8868\n\nworkbook.save()\nworkbook.close()\napp.quit()\n\n<\/code><\/pre>\n\n\n\n<p>\u77e5\u8bc6\u5ef6\u4f38<\/p>\n\n\n\n<ul>\n<li>\u7b2c7\u884c\u4ee3\u7801\u4e2d\u7684melt()\u662fpandas\u6a21\u5757\u4e2dDataFrame\u5bf9\u8c61\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u5c06\u5217\u540d\u8f6c\u6362\u4e3a\u5217\u6570\u636e\uff0c\u6548\u679c\u5982\u4e0b\u56fe\u6240\u793a\uff0c\u4ee5\u6ee1\u8db3\u540e\u7eed\u4f7f\u7528\u7684ols()\u51fd\u6570\u5bf9\u6570\u636e\u7ed3\u6784\u7684\u8981\u6c42\u3002- \u7b2c10\uff5e14\u884c\u4ee3\u7801\u4e2d\u7684describe()\u662fpandas\u6a21\u5757\u4e2dDataFrame\u5bf9\u8c61\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u603b\u7ed3\u6570\u636e\u96c6\u5206\u5e03\u7684\u96c6\u4e2d\u8d8b\u52bf\uff0c\u751f\u6210\u63cf\u8ff0\u6027\u7edf\u8ba1\u6570\u636e\u3002\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u5982\u4e0b\u3002-<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"727\" height=\"174\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-6.png\" alt=\"\" class=\"wp-image-1683\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-6.png 727w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-6-300x72.png 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<p>\u7b2c15\u884c\u4ee3\u7801\u4e2d\u7684ols()\u662fstatsmodels.formula.api\u6a21\u5757\u4e2d\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u5bf9\u6570\u636e\u8fdb\u884c\u6700\u5c0f\u4e8c\u4e58\u7ebf\u6027\u62df\u5408\u8ba1\u7b97\u3002\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u5982\u4e0b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"578\" height=\"137\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-7.png\" alt=\"\" class=\"wp-image-1684\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-7.png 578w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-7-300x71.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/figure>\n\n\n\n<ul>\n<li>\u7b2c16\u884c\u4ee3\u7801\u4e2d\u7684anova_lm()\u662fstatsmodels.stats.anova\u6a21\u5757\u4e2d\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u5bf9\u6570\u636e\u8fdb\u884c\u65b9\u5dee\u5206\u6790\u5e76\u8f93\u51fa\u7ed3\u679c\u3002\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u5982\u4e0b\u3002<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"565\" height=\"238\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-8.png\" alt=\"\" class=\"wp-image-1685\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-8.png 565w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-8-300x126.png 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89-%E7%BB%98%E5%88%B6%E7%AE%B1%E5%BD%A2%E5%9B%BE%E8%AF%86%E5%88%AB%E5%BC%82%E5%B8%B8%E5%80%BC\"><span class=\"ez-toc-section\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E7%BB%98%E5%88%B6%E7%AE%B1%E5%BD%A2%E5%9B%BE%E8%AF%86%E5%88%AB%E5%BC%82%E5%B8%B8%E5%80%BC\"><\/span><strong>\u4e3e\u4e00\u53cd\u4e09 \u7ed8\u5236\u7bb1\u5f62\u56fe\u8bc6\u522b\u5f02\u5e38\u503c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u7ed8\u5236\u7bb1\u5f62\u56fe\u8bc6\u522b\u5f02\u5e38\u503c.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u65b9\u5dee\u5206\u6790.xlsx<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport matplotlib.pyplot as plt\nfrom statsmodels.formula.api import ols  #\u5bfc\u5165\u65b9\u5dee\u5206\u6790\u7684\u6a21\u5757\nfrom statsmodels.stats.anova import anova_lm\nimport xlwings as xw\ndf=pd.read_excel(r'd:\\\\22\\\u65b9\u5dee\u5206\u6790.xlsx')\ndf=df&#91;&#91;'A\u578b\u53f7','B\u578b\u53f7','C\u578b\u53f7','D\u578b\u53f7','E\u578b\u53f7']]  #\u9009\u53d6ABCDE\u7684\u578b\u53f7\u7684\u5217\u4f5c\u4e3a\u5206\u6790\nfigure=plt.figure()\nplt.rcParams&#91;'font.sans-serif']=&#91;'SimHei']\ndf.boxplot(grid=False)\napp=xw.App(visible=True,add_book=False)\nworkbook=app.books.open(r'C:\\Users\\Administrator\\Desktop\\22\\\u65b9\u5dee\u5206\u6790.xlsx')\nworksheet=workbook.sheets&#91;'\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790']  #\u9009\u4e2d\u5de5\u4f5c\u8868\u2018\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790\u2019\nworksheet.pictures.add(figure,name='\u56fe\u72471',update=True,left=500,top=10)\nworkbook.save('\u7bb1\u578b\u56fe.xlsx')\nworkbook.close()\napp.quit()\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"419\" height=\"250\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-9.png\" alt=\"\" class=\"wp-image-1686\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-9.png 419w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-9-300x179.png 300w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/figure>\n\n\n\n<p><strong>\u6848\u4f8b03 \u4f7f\u7528\u63cf\u8ff0\u7edf\u8ba1\u548c\u76f4\u65b9\u56fe\u5236\u5b9a\u76ee\u6807<\/strong><\/p>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u4f7f\u7528\u63cf\u8ff0\u7edf\u8ba1\u548c\u76f4\u65b9\u56fe\u5236\u5b9a\u76ee\u6807.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u63cf\u8ff0\u7edf\u8ba1.xlsx<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport matplotlib.pyplot as plt\nimport xlwings as xw\n#\u6784\u9020\u6708\u9500\u552e\u989d\u6570\u636e\u5217\ndf=pd.read_excel(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1.xlsx')\ndf.columns=&#91;'\u5e8f\u53f7','\u5458\u5de5\u59d3\u540d','\u6708\u9500\u552e\u989d'] #\u91cd\u547d\u540d\u6570\u636e\u5217\ndf=df.drop(columns=&#91;'\u5e8f\u53f7','\u5458\u5de5\u59d3\u540d'])  #\u5220\u9664\u5e8f\u53f7\u548c\u5458\u5de5\u59d3\u540d\u5217\n\ndf_describe=df.astype('float').describe()  #\u5bf9\u6708\u9500\u552e\u989d\u6570\u636e\u8fdb\u884c\u63cf\u8ff0\u6027\u7edf\u8ba1\ndf_cut=pd.cut(df&#91;'\u6708\u9500\u552e\u989d'],bins=7,precision=2)  #\u5c06\u6708\u9500\u552e\u989d\u5206\u62107\u4e2a\u533a\u95f4\ncut_count=df&#91;'\u6708\u9500\u552e\u989d'].groupby(df_cut).count()  #\u7edf\u8ba1\u5404\u533a\u95f4\u7684\u4e2a\u6570\n\ndf_all=pd.DataFrame()  #\u521b\u5efa\u4e00\u4e2a\u7a7a\u7684DateFrame\u7528\u4e8e\u6c47\u603b\u6570\u636e\ndf_all&#91;'\u8ba1\u6570']=cut_count\ndf_all_new=df_all.reset_index()  #\u5c06\u7d22\u5f15\u91cd\u7f6e\ndf_all_new&#91;'\u6708\u9500\u552e\u989d']=df_all_new&#91;'\u6708\u9500\u552e\u989d'].apply(lambda x:str(x)) #\u5c06\u6708\u9500\u552e\u989d\u8f6c\u6362\u6210\u5b57\u7b26\u4e32\u7c7b\u578b\n\n\n#\u7ed8\u56fe\nfig=plt.figure()  #\u521b\u5efa\u7ed8\u56fe\u7a97\u53e3\nplt.rcParams&#91;'font.sans-serif']=&#91;'SimHei'] #\u89e3\u51b3\u4e2d\u6587\u4e71\u7801\u95ee\u9898\nn,bins,patches=plt.hist(df&#91;'\u6708\u9500\u552e\u989d'],bins=7,edgecolor='black',linewidth=0.5)\nplt.xticks(bins)  #\u5c06\u76f4\u65b9\u56fex\u8f74\u7684\u523b\u5ea6\u6807\u7b7e\u8bbe\u7f6e\u4e3a\u5404\u533a\u95f4\u7684\u7aef\u70b9\u503c\nplt.title('\u6708\u5ea6\u9500\u552e\u989d\u9891\u7387\u5206\u6790')  #\u6807\u9898\nplt.xlabel('\u6708\u9500\u552e\u989d') #x\u8f74\u6807\u9898\nplt.ylabel('\u9891\u6570') #y\u8f74\u6807\u9898\n\n#\u5c06\u56fe\u653e\u8fdb\u8868\u91cc\napp=xw.App(visible=True,add_book=False)\nworkbook=app.books.open(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1.xlsx')\nworksheet=workbook.sheets&#91;'\u4e1a\u52a1\u5458\u9500\u552e\u989d\u7edf\u8ba1\u8868']  #\u9009\u4e2d\u5de5\u4f5c\u8868\u2018\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790\u2019\n\nworksheet.range('E2').value=df_describe  #\u5c06\u63cf\u8ff0\u6027\u7edf\u8ba1\u6570\u636e\u5199\u5165\u8868\u4e2d\nworksheet.range('H2').value=df_all_new  #\u5c06\u5206\u7c7b\u540e\u7684\u8868\u5199\u5165\u8868\u4e2d\n\nworksheet.pictures.add(fig,name='\u56fe\u72471',update=True,left=400,top=200)\nworksheet.autofit()\nworkbook.save(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1-\u76f4\u65b9\u56fe.xlsx')\nworkbook.close()\napp.quit()\n\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"444\" height=\"192\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-10.png\" alt=\"\" class=\"wp-image-1687\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-10.png 444w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-10-300x130.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"602\" height=\"348\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-11.png\" alt=\"\" class=\"wp-image-1688\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-11.png 602w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-11-300x173.png 300w, http:\/\/viplao.com\/wp-content\/uploads\/2023\/05\/image-11-519x300.png 519w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<p>\u63cf\u8ff0\u7edf\u8ba1\u6570\u636e\u4e2d\u51e0\u4e2a\u6bd4\u8f83\u91cd\u8981\u7684\u503c\u5206\u522b\u4e3a\u5e73\u5747\u503c\uff08mean\uff0919.194\u3001\u6807\u51c6\u5dee\uff08std\uff095.46\u3001\u4e2d\u4f4d\u6570\uff0850%\uff0918.09\u3001\u6700\u5c0f\u503c8.54\u3001\u6700\u5927\u503c32.56\u3002\u5728\u5de5\u4f5c\u7c3f\u4e2d\u8fd8\u53ef\u4ee5\u770b\u5230\u5982\u4e0b\u56fe\u6240\u793a\u7684\u76f4\u65b9\u56fe\uff0c\u6839\u636e\u76f4\u65b9\u56fe\u53ef\u4ee5\u770b\u51fa\uff0c\u6708\u9500\u552e\u989d\u57fa\u672c\u4e0a\u4ee518\u4e3a\u57fa\u6570\u5411\u4e24\u8fb9\u9012\u51cf\uff0c\u537318\u6700\u666e\u904d\u3002<\/p>\n\n\n\n<p>\u77e5\u8bc6\u5ef6\u4f38<\/p>\n\n\n\n<ul>\n<li>\u7b2c8\u884c\u4ee3\u7801\u4e2d\u7684cut()\u662fpandas\u6a21\u5757\u4e2d\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u5bf9\u6570\u636e\u8fdb\u884c\u79bb\u6563\u5316\u5904\u7406\uff0c\u4e5f\u5c31\u662f\u5c06\u6570\u636e\u4ece\u6700\u5927\u503c\u5230\u6700\u5c0f\u503c\u8fdb\u884c\u7b49\u8ddd\u5212\u5206\u3002\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u5982\u4e0b\u3002<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>df_cut=pd.cut(df&#91;'\u6708\u9500\u552e\u989d'],bins=7,precision=2)  \n\n<\/code><\/pre>\n\n\n\n<ul>\n<li>\u7b2c12\u884c\u4ee3\u7801\u4e2d\u7684reset_index()\u662fpandas\u6a21\u5757\u4e2dDataFrame\u5bf9\u8c61\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u91cd\u7f6eDataFrame\u5bf9\u8c61\u7684\u7d22\u5f15\u3002\u57283.5.1\u8282\u4e2d\u66fe\u7b80\u5355\u4ecb\u7ecd\u8fc7reset_index()\u51fd\u6570\u7684\u7528\u6cd5\uff0c\u8fd9\u91cc\u518d\u8be6\u7ec6\u4ecb\u7ecd\u4e00\u4e0b\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u3002<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>df_all_new=df_all.reset_index()  #\u5c06\u7d22\u5f15\u91cd\u7f6e<\/code><\/pre>\n\n\n\n<ul>\n<li>\u7b2c14\u884c\u4ee3\u7801\u4e2d\u7684figure()\u662fmatplotlib.pyplot\u6a21\u5757\u4e2d\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u521b\u5efa\u4e00\u4e2a\u7ed8\u56fe\u7a97\u53e3\u3002\u57283.7.2\u8282\u4e2d\u66fe\u4f7f\u7528\u8fc7figure()\u51fd\u6570\uff0c\u8fd9\u91cc\u518d\u8be6\u7ec6\u4ecb\u7ecd\u4e00\u4e0b\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u3002- \u7b2c16\u884c\u4ee3\u7801\u4e2d\u7684hist()\u662fMatplotlib\u6a21\u5757\u4e2d\u7684\u51fd\u6570\uff0c\u7528\u4e8e\u7ed8\u5236\u76f4\u65b9\u56fe\u3002\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u683c\u5f0f\u548c\u5e38\u7528\u53c2\u6570\u542b\u4e49\u5982\u4e0b\u3002<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>n,bins,patches=plt.hist(df&#91;'\u6708\u9500\u552e\u989d'],bins=7,edgecolor='black',linewidth=0.5)\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89-%E4%BD%BF%E7%94%A8%E8%87%AA%E5%AE%9A%E4%B9%89%E5%8C%BA%E9%97%B4%E7%BB%98%E5%88%B6%E7%9B%B4%E6%96%B9%E5%9B%BE\"><span class=\"ez-toc-section\" id=\"%E4%B8%BE%E4%B8%80%E5%8F%8D%E4%B8%89_%E4%BD%BF%E7%94%A8%E8%87%AA%E5%AE%9A%E4%B9%89%E5%8C%BA%E9%97%B4%E7%BB%98%E5%88%B6%E7%9B%B4%E6%96%B9%E5%9B%BE\"><\/span><strong>\u4e3e\u4e00\u53cd\u4e09 \u4f7f\u7528\u81ea\u5b9a\u4e49\u533a\u95f4\u7ed8\u5236\u76f4\u65b9\u56fe<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul>\n<li>\u4ee3\u7801\u6587\u4ef6\uff1a\u4f7f\u7528\u81ea\u5b9a\u4e49\u533a\u95f4\u7ed8\u5236\u76f4\u65b9\u56fe.py &#8211; \u6570\u636e\u6587\u4ef6\uff1a\u63cf\u8ff0\u7edf\u8ba1.xlsx<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport matplotlib.pyplot as plt\nimport xlwings as xw\n#\u6784\u9020\u6708\u9500\u552e\u989d\u6570\u636e\u5217\ndf=pd.read_excel(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1.xlsx')\ndf.columns=&#91;'\u5e8f\u53f7','\u5458\u5de5\u59d3\u540d','\u6708\u9500\u552e\u989d'] #\u91cd\u547d\u540d\u6570\u636e\u5217\ndf=df.drop(columns=&#91;'\u5e8f\u53f7','\u5458\u5de5\u59d3\u540d'])  #\u5220\u9664\u5e8f\u53f7\u548c\u5458\u5de5\u59d3\u540d\u5217\n\ndf_describe=df.astype('float').describe()  #\u5bf9\u6708\u9500\u552e\u989d\u6570\u636e\u8fdb\u884c\u63cf\u8ff0\u6027\u7edf\u8ba1\ndf_cut=pd.cut(df&#91;'\u6708\u9500\u552e\u989d'],bins=range(8,37,4))  #\u5c06\u6708\u9500\u552e\u989d\u5206\u62107\u4e2a\u533a\u95f4\ncut_count=df&#91;'\u6708\u9500\u552e\u989d'].groupby(df_cut).count()  #\u7edf\u8ba1\u5404\u533a\u95f4\u7684\u4e2a\u6570\n\ndf_all=pd.DataFrame()  #\u521b\u5efa\u4e00\u4e2a\u7a7a\u7684DateFrame\u7528\u4e8e\u6c47\u603b\u6570\u636e\ndf_all&#91;'\u8ba1\u6570']=cut_count\ndf_all_new=df_all.reset_index()  #\u5c06\u7d22\u5f15\u91cd\u7f6e\ndf_all_new&#91;'\u6708\u9500\u552e\u989d']=df_all_new&#91;'\u6708\u9500\u552e\u989d'].apply(lambda x:str(x)) #\u5c06\u6708\u9500\u552e\u989d\u8f6c\u6362\u6210\u5b57\u7b26\u4e32\u7c7b\u578b\n\n\n#\u7ed8\u56fe\nfig=plt.figure()  #\u521b\u5efa\u7ed8\u56fe\u7a97\u53e3\nplt.rcParams&#91;'font.sans-serif']=&#91;'SimHei'] #\u89e3\u51b3\u4e2d\u6587\u4e71\u7801\u95ee\u9898\nn,bins,patches=plt.hist(df&#91;'\u6708\u9500\u552e\u989d'],bins=range(8,37,4),edgecolor='black',linewidth=0.5)\nplt.xticks(bins)  #\u5c06\u76f4\u65b9\u56fex\u8f74\u7684\u523b\u5ea6\u6807\u7b7e\u8bbe\u7f6e\u4e3a\u5404\u533a\u95f4\u7684\u7aef\u70b9\u503c\nplt.title('\u6708\u5ea6\u9500\u552e\u989d\u9891\u7387\u5206\u6790')  #\u6807\u9898\nplt.xlabel('\u6708\u9500\u552e\u989d') #x\u8f74\u6807\u9898\nplt.ylabel('\u9891\u6570') #y\u8f74\u6807\u9898\n\n#\u5c06\u56fe\u653e\u8fdb\u8868\u91cc\napp=xw.App(visible=True,add_book=False)\nworkbook=app.books.open(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1.xlsx')\nworksheet=workbook.sheets&#91;'\u4e1a\u52a1\u5458\u9500\u552e\u989d\u7edf\u8ba1\u8868']  #\u9009\u4e2d\u5de5\u4f5c\u8868\u2018\u5355\u56e0\u7d20\u65b9\u5dee\u5206\u6790\u2019\n\nworksheet.range('E2').value=df_describe  #\u5c06\u63cf\u8ff0\u6027\u7edf\u8ba1\u6570\u636e\u5199\u5165\u8868\u4e2d\nworksheet.range('H2').value=df_all_new  #\u5c06\u5206\u7c7b\u540e\u7684\u8868\u5199\u5165\u8868\u4e2d\n\nworksheet.pictures.add(fig,name='\u56fe\u72471',update=True,left=400,top=200)\nworksheet.autofit()\nworkbook.save(r'C:\\Users\\Administrator\\Desktop\\22\\\u63cf\u8ff0\u7edf\u8ba1-\u76f4\u65b9\u56fe2.xlsx')\nworkbook.close()\napp.quit()\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6848\u4f8b01 \u6279\u91cf\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868 \u4e3e\u4e00\u53cd\u4e09 \u4e3a\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u7684\u6240\u6709\u5de5\u4f5c\u8868\u5236\u4f5c\u6570\u636e\u900f\u89c6\u8868 \u6848\u4f8b02 \u4f7f\u7528\u65b9\u5dee\u5206&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2023\/05\/03\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-python-%e6%97%a5%e5%b8%b8%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-excel%e5%b8%b8%e7%94%a8%e9%ab%98%e7%ba%a7%e5%87%bd%e6%95%b0%e5%a4%84\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">\u8fd0\u7ef4\u5de5\u5177 \u2013 PYTHON \u65e5\u5e38\u6570\u636e\u5206\u6790 \u2013\u00a0EXCEL\u5e38\u7528\u9ad8\u7ea7\u51fd\u6570\u5904\u7406\u6280\u5de7<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"views":563,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1679"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=1679"}],"version-history":[{"count":3,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1679\/revisions"}],"predecessor-version":[{"id":1693,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1679\/revisions\/1693"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=1679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=1679"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=1679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}