{"id":4218,"date":"2026-03-01T10:09:54","date_gmt":"2026-03-01T02:09:54","guid":{"rendered":"http:\/\/viplao.com\/?p=4218"},"modified":"2026-03-01T10:09:56","modified_gmt":"2026-03-01T02:09:56","slug":"%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/","title":{"rendered":"\u6570\u636e\u6280\u80fd\uff08SKILLS\uff09 \uff1aDay 3\uff1a\u63cf\u8ff0\u6027\u7edf\u8ba1\u4e0e\u6838\u5fc3\u6307\u6807\u5206\u6790"},"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' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E8%AF%BE%E7%A8%8B%E7%9B%AE%E6%A0%87\" title=\"\u8bfe\u7a0b\u76ee\u6807\">\u8bfe\u7a0b\u76ee\u6807<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%A0%B8%E5%BF%83Skills\" title=\"\u6838\u5fc3Skills\">\u6838\u5fc3Skills<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E8%AF%BE%E4%BB%B6%E5%86%85%E5%AE%B9%E4%B8%8E%E4%BB%A3%E7%A0%81\" title=\"\u8bfe\u4ef6\u5185\u5bb9\u4e0e\u4ee3\u7801\">\u8bfe\u4ef6\u5185\u5bb9\u4e0e\u4ee3\u7801<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A41%EF%BC%9A%E5%AF%BC%E5%85%A5%E5%BA%93%E4%B8%8E%E6%95%B0%E6%8D%AE\" title=\"\u6b65\u9aa41\uff1a\u5bfc\u5165\u5e93\u4e0e\u6570\u636e\">\u6b65\u9aa41\uff1a\u5bfc\u5165\u5e93\u4e0e\u6570\u636e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A42%EF%BC%9A%E8%AE%A1%E7%AE%97%E7%94%B5%E5%95%86%E6%A0%B8%E5%BF%83%E4%B8%9A%E5%8A%A1%E6%8C%87%E6%A0%87\" title=\"\u6b65\u9aa42\uff1a\u8ba1\u7b97\u7535\u5546\u6838\u5fc3\u4e1a\u52a1\u6307\u6807\">\u6b65\u9aa42\uff1a\u8ba1\u7b97\u7535\u5546\u6838\u5fc3\u4e1a\u52a1\u6307\u6807<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A43%EF%BC%9A%E9%94%80%E5%94%AE%E8%B6%8B%E5%8A%BF%E5%88%86%E6%9E%90%EF%BC%88%E6%8C%89%E6%97%B6%E9%97%B4%EF%BC%89\" title=\"\u6b65\u9aa43\uff1a\u9500\u552e\u8d8b\u52bf\u5206\u6790\uff08\u6309\u65f6\u95f4\uff09\">\u6b65\u9aa43\uff1a\u9500\u552e\u8d8b\u52bf\u5206\u6790\uff08\u6309\u65f6\u95f4\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A44%EF%BC%9A%E5%95%86%E5%93%81%E7%BB%B4%E5%BA%A6%E5%88%86%E6%9E%90\" title=\"\u6b65\u9aa44\uff1a\u5546\u54c1\u7ef4\u5ea6\u5206\u6790\">\u6b65\u9aa44\uff1a\u5546\u54c1\u7ef4\u5ea6\u5206\u6790<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A45%EF%BC%9A%E7%94%A8%E6%88%B7%E7%BB%B4%E5%BA%A6%E5%88%86%E6%9E%90\" title=\"\u6b65\u9aa45\uff1a\u7528\u6237\u7ef4\u5ea6\u5206\u6790\">\u6b65\u9aa45\uff1a\u7528\u6237\u7ef4\u5ea6\u5206\u6790<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A46%EF%BC%9A%E4%BA%A4%E5%8F%89%E5%88%86%E6%9E%90%E4%B8%8E%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\" title=\"\u6b65\u9aa46\uff1a\u4ea4\u53c9\u5206\u6790\u4e0e\u6570\u636e\u900f\u89c6\u8868\">\u6b65\u9aa46\uff1a\u4ea4\u53c9\u5206\u6790\u4e0e\u6570\u636e\u900f\u89c6\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A47%EF%BC%9A%E7%BB%93%E6%9E%84%E5%88%86%E6%9E%90%E4%B8%8E%E8%B4%A1%E7%8C%AE%E5%BA%A6%E5%88%86%E6%9E%90%EF%BC%88%E5%B8%95%E7%B4%AF%E6%89%98%E5%88%86%E6%9E%90%EF%BC%89\" title=\"\u6b65\u9aa47\uff1a\u7ed3\u6784\u5206\u6790\u4e0e\u8d21\u732e\u5ea6\u5206\u6790\uff08\u5e15\u7d2f\u6258\u5206\u6790\uff09\">\u6b65\u9aa47\uff1a\u7ed3\u6784\u5206\u6790\u4e0e\u8d21\u732e\u5ea6\u5206\u6790\uff08\u5e15\u7d2f\u6258\u5206\u6790\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%AD%A5%E9%AA%A48%EF%BC%9A%E7%94%9F%E6%88%90%E7%AE%80%E6%98%93%E5%88%86%E6%9E%90%E6%8A%A5%E5%91%8A\" title=\"\u6b65\u9aa48\uff1a\u751f\u6210\u7b80\u6613\u5206\u6790\u62a5\u544a\">\u6b65\u9aa48\uff1a\u751f\u6210\u7b80\u6613\u5206\u6790\u62a5\u544a<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E6%9C%AC%E6%97%A5%E8%A6%81%E7%82%B9%E6%80%BB%E7%BB%93\" title=\"\u672c\u65e5\u8981\u70b9\u603b\u7ed3\">\u672c\u65e5\u8981\u70b9\u603b\u7ed3<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/#%E8%AF%BE%E7%A8%8B%E6%80%BB%E7%BB%93%E4%B8%8E%E5%90%8E%E7%BB%AD%E9%A2%84%E5%91%8A\" title=\"\u8bfe\u7a0b\u603b\u7ed3\u4e0e\u540e\u7eed\u9884\u544a\">\u8bfe\u7a0b\u603b\u7ed3\u4e0e\u540e\u7eed\u9884\u544a<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%BE%E7%A8%8B%E7%9B%AE%E6%A0%87\"><\/span><strong>\u8bfe\u7a0b\u76ee\u6807<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol>\n<li>\u638c\u63e1\u7535\u5546\u6838\u5fc3\u4e1a\u52a1\u6307\u6807\u7684\u8ba1\u7b97\u4e0e\u89e3\u8bfb\u3002<\/li>\n\n\n\n<li>\u5b66\u4e60\u4f7f\u7528\u5206\u7ec4\u805a\u5408\u8fdb\u884c\u591a\u7ef4\u6570\u636e\u5206\u6790\u3002<\/li>\n\n\n\n<li>\u5b8c\u6210\u9500\u552e\u3001\u7528\u6237\u3001\u5546\u54c1\u7ef4\u5ea6\u7684\u57fa\u7840\u5206\u6790\u62a5\u544a\u3002<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%A0%B8%E5%BF%83Skills\"><\/span><strong>\u6838\u5fc3Skills<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>\u6307\u6807\u8ba1\u7b97<\/strong>\uff1aGMV\u3001\u5ba2\u5355\u4ef7\u3001\u8f6c\u5316\u7387\u7b49<\/li>\n\n\n\n<li><strong>\u5206\u7ec4\u805a\u5408<\/strong>\uff1a<code>groupby<\/code>\u3001<code>pivot_table<\/code><\/li>\n\n\n\n<li><strong>\u591a\u7ef4\u5ea6\u5206\u6790<\/strong>\uff1a\u7ed3\u6784\u5206\u6790\u3001\u5bf9\u6bd4\u5206\u6790\u3001\u8d8b\u52bf\u5206\u6790<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%BE%E4%BB%B6%E5%86%85%E5%AE%B9%E4%B8%8E%E4%BB%A3%E7%A0%81\"><\/span><strong>\u8bfe\u4ef6\u5185\u5bb9\u4e0e\u4ee3\u7801<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A41%EF%BC%9A%E5%AF%BC%E5%85%A5%E5%BA%93%E4%B8%8E%E6%95%B0%E6%8D%AE\"><\/span><strong>\u6b65\u9aa41\uff1a\u5bfc\u5165\u5e93\u4e0e\u6570\u636e<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code># \u4ee3\u7801\u6587\u4ef6\uff1aday3_descriptive_analysis.ipynb\nimport pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\nimport seaborn as sns\nplt.style.use('seaborn-v0_8-darkgrid')\n\n# \u8bfb\u53d6\u6e05\u6d17\u540e\u7684\u6570\u636e\ndf = pd.read_csv('cleaned_orders.csv', encoding='utf-8')\n# \u786e\u4fdd\u65e5\u671f\u683c\u5f0f\nif 'order_date' in df.columns:\n    df&#91;'order_date'] = pd.to_datetime(df&#91;'order_date'])\nprint(f\"&gt;&gt;&gt; \u6570\u636e\u52a0\u8f7d\u6210\u529f\uff01\u5f62\u72b6: {df.shape}\")\ndisplay(df.head())\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A42%EF%BC%9A%E8%AE%A1%E7%AE%97%E7%94%B5%E5%95%86%E6%A0%B8%E5%BF%83%E4%B8%9A%E5%8A%A1%E6%8C%87%E6%A0%87\"><\/span><strong>\u6b65\u9aa42\uff1a\u8ba1\u7b97\u7535\u5546\u6838\u5fc3\u4e1a\u52a1\u6307\u6807<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa41\uff1a\u8ba1\u7b97\u6838\u5fc3\u7535\u5546\u4e1a\u52a1\u6307\u6807\u3011\")\nprint(\"=\"*70)\n# \u5047\u8bbe\u6570\u636e\u65f6\u95f4\u8303\u56f4\nstart_date = df&#91;'order_date'].min()\nend_date = df&#91;'order_date'].max()\ndays = (end_date - start_date).days + 1\n\n# 1. \u603b\u9500\u552e\u989d (GMV)\ntotal_gmv = df&#91;'total_amount'].sum()\nprint(f\"1. \u603b\u9500\u552e\u989d(GMV): \u00a5{total_gmv:,.2f}\")\n\n# 2. \u603b\u8ba2\u5355\u6570\ntotal_orders = df&#91;'order_id'].nunique()\nprint(f\"2. \u603b\u8ba2\u5355\u6570: {total_orders:,}\")\n\n# 3. \u603b\u7528\u6237\u6570\ntotal_users = df&#91;'user_id'].nunique()\nprint(f\"3. \u603b\u7528\u6237\u6570: {total_users:,}\")\n\n# 4. \u5ba2\u5355\u4ef7 (Average Order Value)\naov = total_gmv \/ total_orders if total_orders &gt; 0 else 0\nprint(f\"4. \u5ba2\u5355\u4ef7(AOV): \u00a5{aov:,.2f}\")\n\n# 5. \u4eba\u5747\u8ba2\u5355\u6570 (\u8ba2\u5355\u9891\u6b21)\norders_per_user = total_orders \/ total_users if total_users &gt; 0 else 0\nprint(f\"5. \u4eba\u5747\u8ba2\u5355\u6570: {orders_per_user:.2f}\")\n\n# 6. \u65e5\u5747\u9500\u552e\u989d\ndaily_gmv = total_gmv \/ days\nprint(f\"6. \u65e5\u5747\u9500\u552e\u989d: \u00a5{daily_gmv:,.2f}\")\n\n# 7. \u65e5\u5747\u8ba2\u5355\u6570\ndaily_orders = total_orders \/ days\nprint(f\"7. \u65e5\u5747\u8ba2\u5355\u6570: {daily_orders:.2f}\")\n\n# 8. \u6c47\u603b\u8f93\u51fa\nsummary_dict = {\n    '\u6307\u6807': &#91;'\u603b\u9500\u552e\u989d(GMV)', '\u603b\u8ba2\u5355\u6570', '\u603b\u7528\u6237\u6570', '\u5ba2\u5355\u4ef7(AOV)', '\u4eba\u5747\u8ba2\u5355\u6570', '\u65e5\u5747\u9500\u552e\u989d', '\u65e5\u5747\u8ba2\u5355\u6570', '\u6570\u636e\u5468\u671f(\u5929)'],\n    '\u6570\u503c': &#91;f'\u00a5{total_gmv:,.2f}', f'{total_orders:,}', f'{total_users:,}', f'\u00a5{aov:,.2f}',\n            f'{orders_per_user:.2f}', f'\u00a5{daily_gmv:,.2f}', f'{daily_orders:.2f}', f'{days}']\n}\nsummary_df = pd.DataFrame(summary_dict)\nprint(\"\\n&gt;&gt;&gt; \u6838\u5fc3\u6307\u6807\u6c47\u603b\u8868:\")\ndisplay(summary_df)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A43%EF%BC%9A%E9%94%80%E5%94%AE%E8%B6%8B%E5%8A%BF%E5%88%86%E6%9E%90%EF%BC%88%E6%8C%89%E6%97%B6%E9%97%B4%EF%BC%89\"><\/span><strong>\u6b65\u9aa43\uff1a\u9500\u552e\u8d8b\u52bf\u5206\u6790\uff08\u6309\u65f6\u95f4\uff09<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa42\uff1a\u9500\u552e\u8d8b\u52bf\u5206\u6790 (\u6309\u65e5\/\u6708)\u3011\")\nprint(\"=\"*70)\n# \u6309\u65e5\u805a\u5408\u9500\u552e\u989d\u548c\u8ba2\u5355\u6570\ndaily_sales = df.groupby(df&#91;'order_date'].dt.date).agg({\n    'total_amount': 'sum',\n    'order_id': 'nunique',\n    'user_id': 'nunique'\n}).rename(columns={'total_amount': 'daily_gmv', 'order_id': 'order_count', 'user_id': 'user_count'})\n\nprint(\"&gt;&gt;&gt; \u6bcf\u65e5\u9500\u552e\u6570\u636e\u524d5\u5929:\")\ndisplay(daily_sales.head())\n\n# \u7ed8\u5236\u8d8b\u52bf\u56fe\nfig, axes = plt.subplots(2, 1, figsize=(14, 10))\n# GMV\u8d8b\u52bf\naxes&#91;0].plot(daily_sales.index, daily_sales&#91;'daily_gmv'], marker='o', linewidth=2, color='royalblue')\naxes&#91;0].set_title('\u6bcf\u65e5\u9500\u552e\u989d(GMV)\u8d8b\u52bf', fontsize=15)\naxes&#91;0].set_ylabel('\u9500\u552e\u989d (\u5143)', fontsize=12)\naxes&#91;0].grid(True, alpha=0.3)\n# \u8ba2\u5355\u6570\u8d8b\u52bf\naxes&#91;1].plot(daily_sales.index, daily_sales&#91;'order_count'], marker='s', linewidth=2, color='coral')\naxes&#91;1].set_title('\u6bcf\u65e5\u8ba2\u5355\u6570\u8d8b\u52bf', fontsize=15)\naxes&#91;1].set_xlabel('\u65e5\u671f', fontsize=12)\naxes&#91;1].set_ylabel('\u8ba2\u5355\u6570', fontsize=12)\naxes&#91;1].grid(True, alpha=0.3)\nplt.tight_layout()\nplt.show()\n\n# \u6309\u6708\u805a\u5408\ndf&#91;'order_month'] = df&#91;'order_date'].dt.to_period('M')  # \u751f\u6210\u20182023-10\u2019\u683c\u5f0f\nmonthly_sales = df.groupby('order_month').agg({\n    'total_amount': 'sum',\n    'order_id': 'nunique',\n    'user_id': 'nunique'\n}).rename(columns={'total_amount': 'monthly_gmv', 'order_id': 'order_count', 'user_id': 'user_count'})\nprint(\"&gt;&gt;&gt; \u6708\u5ea6\u9500\u552e\u6570\u636e:\")\ndisplay(monthly_sales)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A44%EF%BC%9A%E5%95%86%E5%93%81%E7%BB%B4%E5%BA%A6%E5%88%86%E6%9E%90\"><\/span><strong>\u6b65\u9aa44\uff1a\u5546\u54c1\u7ef4\u5ea6\u5206\u6790<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa43\uff1a\u5546\u54c1\u7ef4\u5ea6\u5206\u6790\u3011\")\nprint(\"=\"*70)\n# 1. \u5546\u54c1\u9500\u552e\u989d\u6392\u540d\nproduct_sales = df.groupby('product_id').agg({\n    'total_amount': 'sum',\n    'quantity': 'sum',\n    'order_id': 'nunique'\n}).rename(columns={'total_amount': 'sales_amount', 'quantity': 'sales_volume', 'order_id': 'order_count'})\n\nproduct_sales = product_sales.sort_values('sales_amount', ascending=False)\nprint(\"&gt;&gt;&gt; \u5546\u54c1\u9500\u552e\u989dTop 10:\")\ndisplay(product_sales.head(10))\n\n# 2. \u5546\u54c1\u7c7b\u522b\u5206\u6790\ncategory_analysis = df.groupby('category').agg({\n    'total_amount': 'sum',\n    'order_id': 'nunique',\n    'gross_profit': 'sum'\n}).rename(columns={'total_amount': 'category_gmv', 'order_id': 'order_count', 'gross_profit': 'total_profit'})\ncategory_analysis&#91;'gmv_share'] = (category_analysis&#91;'category_gmv'] \/ category_analysis&#91;'category_gmv'].sum() * 100).round(2)\ncategory_analysis = category_analysis.sort_values('category_gmv', ascending=False)\nprint(\"&gt;&gt;&gt; \u5546\u54c1\u7c7b\u522b\u8d21\u732e\u5206\u6790:\")\ndisplay(category_analysis)\n\n# 3. \u7ed8\u5236\u7c7b\u522b\u9500\u552e\u989d\u5360\u6bd4\u997c\u56fe\nplt.figure(figsize=(10, 8))\nplt.pie(category_analysis&#91;'category_gmv'], labels=category_analysis.index,\n        autopct='%1.1f%%', startangle=90, colors=sns.color_palette('Set3'))\nplt.title('\u5404\u5546\u54c1\u7c7b\u522b\u9500\u552e\u989d\u5360\u6bd4', fontsize=16)\nplt.show()\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A45%EF%BC%9A%E7%94%A8%E6%88%B7%E7%BB%B4%E5%BA%A6%E5%88%86%E6%9E%90\"><\/span><strong>\u6b65\u9aa45\uff1a\u7528\u6237\u7ef4\u5ea6\u5206\u6790<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa44\uff1a\u7528\u6237\u7ef4\u5ea6\u5206\u6790\u3011\")\nprint(\"=\"*70)\n# 1. \u7528\u6237\u6d88\u8d39\u91d1\u989d\u5206\u5e03\nuser_spending = df.groupby('user_id').agg({\n    'total_amount': 'sum',\n    'order_id': 'nunique',\n    'order_date': lambda x: (x.max() - x.min()).days if len(x) &gt; 1 else 0  # \u8d2d\u4e70\u8de8\u5ea6\n}).rename(columns={'total_amount': 'user_lifetime_value', 'order_id': 'purchase_count', 'order_date': 'purchase_span_days'})\n\nprint(\"&gt;&gt;&gt; \u7528\u6237\u6d88\u8d39\u884c\u4e3a\u7edf\u8ba1\u63cf\u8ff0:\")\ndisplay(user_spending.describe())\n\n# 2. RFM\u6a21\u578b\u7b80\u5316\u7248\uff1a\u8ba1\u7b97\u6bcf\u4e2a\u7528\u6237\u7684\u6700\u8fd1\u8d2d\u4e70\u65f6\u95f4(R)\u3001\u8d2d\u4e70\u9891\u6b21(F)\u3001\u6d88\u8d39\u91d1\u989d(M)\n# \u5047\u8bbe\u5206\u6790\u65e5\u671f\u4e3a\u6570\u636e\u6700\u540e\u4e00\u5929\nanalysis_date = df&#91;'order_date'].max()\nrfm_data = df.groupby('user_id').agg({\n    'order_date': lambda x: (analysis_date - x.max()).days,  # R: \u6700\u8fd1\u4e00\u6b21\u8d2d\u4e70\u8ddd\u4eca\u5929\u6570\n    'order_id': 'nunique',                                   # F: \u8d2d\u4e70\u6b21\u6570\n    'total_amount': 'sum'                                    # M: \u603b\u6d88\u8d39\u91d1\u989d\n}).rename(columns={'order_date': 'recency', 'order_id': 'frequency', 'total_amount': 'monetary'})\n\nprint(\"&gt;&gt;&gt; \u7528\u6237RFM\u6570\u636e\u524d10\u884c:\")\ndisplay(rfm_data.head(10))\n\n# 3. \u7528\u6237\u57ce\u5e02\u5206\u5e03\nuser_city_dist = df.groupby('city').agg({\n    'user_id': 'nunique',\n    'total_amount': 'sum'\n}).rename(columns={'user_id': 'user_count', 'total_amount': 'city_gmv'}).sort_values('city_gmv', ascending=False)\nprint(\"&gt;&gt;&gt; \u7528\u6237\u57ce\u5e02\u5206\u5e03\u4e0e\u8d21\u732e:\")\ndisplay(user_city_dist)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A46%EF%BC%9A%E4%BA%A4%E5%8F%89%E5%88%86%E6%9E%90%E4%B8%8E%E6%95%B0%E6%8D%AE%E9%80%8F%E8%A7%86%E8%A1%A8\"><\/span><strong>\u6b65\u9aa46\uff1a\u4ea4\u53c9\u5206\u6790\u4e0e\u6570\u636e\u900f\u89c6\u8868<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa45\uff1a\u4ea4\u53c9\u5206\u6790\u4e0e\u6570\u636e\u900f\u89c6\u8868\u3011\")\nprint(\"=\"*70)\n# 1. \u4f7f\u7528 groupby \u8fdb\u884c\u591a\u7ef4\u5ea6\u4ea4\u53c9\n# \u4f8b\u5982\uff1a\u67e5\u770b\u5404\u57ce\u5e02\u3001\u5404\u5546\u54c1\u7c7b\u522b\u7684\u9500\u552e\u989d\ncross_city_category = df.groupby(&#91;'city', 'category'])&#91;'total_amount'].sum().unstack(fill_value=0)\nprint(\"&gt;&gt;&gt; \u5404\u57ce\u5e02 x \u5404\u5546\u54c1\u7c7b\u522b \u9500\u552e\u989d\u4ea4\u53c9\u8868 (\u90e8\u5206):\")\ndisplay(cross_city_category.head())\n\n# 2. \u4f7f\u7528 pivot_table \u8fdb\u884c\u66f4\u7075\u6d3b\u7684\u5206\u6790\n# \u8ba1\u7b97\u6bcf\u4e2a\u57ce\u5e02\u6bcf\u6708\u7684\u8ba2\u5355\u6570\npivot_monthly_city = pd.pivot_table(df,\n                                     values='order_id',\n                                     index=df&#91;'order_date'].dt.to_period('M'),\n                                     columns='city',\n                                     aggfunc='count',\n                                     fill_value=0)\nprint(\"&gt;&gt;&gt; \u6570\u636e\u900f\u89c6\u8868\uff1a\u5404\u57ce\u5e02\u6bcf\u6708\u8ba2\u5355\u6570\")\ndisplay(pivot_monthly_city)\n\n# 3. \u8ba1\u7b97\u6bcf\u4e2a\u7528\u6237\u5728\u4e0d\u540c\u7c7b\u522b\u7684\u6d88\u8d39\u91d1\u989d\u5360\u6bd4\uff08\u7528\u6237-\u7c7b\u522b\u77e9\u9635\uff09\nuser_category_pivot = pd.pivot_table(df,\n                                      values='total_amount',\n                                      index='user_id',\n                                      columns='category',\n                                      aggfunc='sum',\n                                      fill_value=0)\nprint(\"&gt;&gt;&gt; \u7528\u6237-\u5546\u54c1\u7c7b\u522b\u6d88\u8d39\u77e9\u9635 (\u524d5\u4e2a\u7528\u6237):\")\ndisplay(user_category_pivot.head())\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A47%EF%BC%9A%E7%BB%93%E6%9E%84%E5%88%86%E6%9E%90%E4%B8%8E%E8%B4%A1%E7%8C%AE%E5%BA%A6%E5%88%86%E6%9E%90%EF%BC%88%E5%B8%95%E7%B4%AF%E6%89%98%E5%88%86%E6%9E%90%EF%BC%89\"><\/span><strong>\u6b65\u9aa47\uff1a\u7ed3\u6784\u5206\u6790\u4e0e\u8d21\u732e\u5ea6\u5206\u6790\uff08\u5e15\u7d2f\u6258\u5206\u6790\uff09<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa46\uff1a\u7ed3\u6784\u5206\u6790\u4e0e\u5e15\u7d2f\u6258\u5206\u6790\u3011\")\nprint(\"=\"*70)\n# 1. \u5546\u54c1\u9500\u552e\u989d\u7684\u5e15\u7d2f\u6258\u5206\u6790 (\u4e8c\u516b\u6cd5\u5219)\nproduct_sales_sorted = product_sales.sort_values('sales_amount', ascending=False)\nproduct_sales_sorted&#91;'cumulative_sales'] = product_sales_sorted&#91;'sales_amount'].cumsum()\nproduct_sales_sorted&#91;'cumulative_percentage'] = (product_sales_sorted&#91;'cumulative_sales'] \/ product_sales_sorted&#91;'sales_amount'].sum() * 100).round(2)\n\nprint(\"&gt;&gt;&gt; \u5546\u54c1\u9500\u552e\u989d\u5e15\u7d2f\u6258\u5206\u6790 (Top 20\u5546\u54c1):\")\ndisplay(product_sales_sorted.head(20)&#91;&#91;'sales_amount', 'cumulative_sales', 'cumulative_percentage']])\n\n# \u627e\u51fa\u8d21\u732e80%\u9500\u552e\u989d\u7684\u5546\u54c1\ntop_80_percent = product_sales_sorted&#91;product_sales_sorted&#91;'cumulative_percentage'] &lt;= 80]\nprint(f\"&gt;&gt;&gt; \u8d21\u732e80%\u9500\u552e\u989d\u7684\u5546\u54c1\u6570\u91cf: {len(top_80_percent)} \/ {len(product_sales_sorted)}\")\nprint(f\"&gt;&gt;&gt; \u8fd9\u4e9b\u5546\u54c1\u5360\u603b\u5546\u54c1\u6570\u7684\u6bd4\u4f8b: {len(top_80_percent)\/len(product_sales_sorted)*100:.1f}%\")\n\n# 2. \u53ef\u89c6\u5316\u5e15\u7d2f\u6258\u56fe\nfig, ax1 = plt.subplots(figsize=(12, 6))\nax1.bar(range(len(product_sales_sorted.head(20))), product_sales_sorted.head(20)&#91;'sales_amount'], color='skyblue', label='\u9500\u552e\u989d')\nax1.set_xlabel('\u5546\u54c1 (\u6309\u9500\u552e\u989d\u964d\u5e8f\u6392\u5217)')\nax1.set_ylabel('\u9500\u552e\u989d (\u5143)', color='skyblue')\nax1.tick_params(axis='y', labelcolor='skyblue')\nax2 = ax1.twinx()\nax2.plot(range(len(product_sales_sorted.head(20))), product_sales_sorted.head(20)&#91;'cumulative_percentage'],\n         color='orange', marker='o', linewidth=2, label='\u7d2f\u8ba1\u5360\u6bd4')\nax2.set_ylabel('\u7d2f\u8ba1\u9500\u552e\u989d\u5360\u6bd4 (%)', color='orange')\nax2.tick_params(axis='y', labelcolor='orange')\nax2.axhline(y=80, color='red', linestyle='--', linewidth=1, label='80% \u7ebf')\nplt.title('\u5546\u54c1\u9500\u552e\u989d\u5e15\u7d2f\u6258\u56fe (Top 20)', fontsize=15)\nfig.legend(loc='upper left', bbox_to_anchor=(0.1, 0.9))\nplt.tight_layout()\nplt.show()\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A48%EF%BC%9A%E7%94%9F%E6%88%90%E7%AE%80%E6%98%93%E5%88%86%E6%9E%90%E6%8A%A5%E5%91%8A\"><\/span><strong>\u6b65\u9aa48\uff1a\u751f\u6210\u7b80\u6613\u5206\u6790\u62a5\u544a<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>print(\"=\"*70)\nprint(\"\u3010\u6b65\u9aa47\uff1a\u751f\u6210\u7b80\u6613\u5206\u6790\u62a5\u544a\u6458\u8981\u3011\")\nprint(\"=\"*70)\nreport_lines = &#91;]\nreport_lines.append(\"=\"*50)\nreport_lines.append(\"        \u7535\u5546\u8fd0\u8425\u6570\u636e\u7b80\u6613\u5206\u6790\u62a5\u544a\")\nreport_lines.append(\"=\"*50)\nreport_lines.append(f\"\u5206\u6790\u5468\u671f: {start_date.date()} \u81f3 {end_date.date()} (\u5171{days}\u5929)\")\nreport_lines.append(f\"\u603b\u9500\u552e\u989d(GMV): \u00a5{total_gmv:,.2f}\")\nreport_lines.append(f\"\u603b\u8ba2\u5355\u6570: {total_orders:,} | \u603b\u7528\u6237\u6570: {total_users:,}\")\nreport_lines.append(f\"\u5ba2\u5355\u4ef7(AOV): \u00a5{aov:,.2f} | \u4eba\u5747\u8ba2\u5355\u6570: {orders_per_user:.2f}\")\nreport_lines.append(\"-\"*50)\nreport_lines.append(\"\u3010\u5546\u54c1\u7ef4\u5ea6\u3011\")\ntop_category = category_analysis.index\nreport_lines.append(f\"  \u9500\u552e\u989d\u6700\u9ad8\u7684\u7c7b\u522b: {top_category} (\u00a5{category_analysis.loc&#91;top_category, 'category_gmv']:,.2f})\")\ntop_product = product_sales.index\nreport_lines.append(f\"  \u9500\u552e\u989d\u6700\u9ad8\u7684\u5355\u54c1: {top_product} (\u00a5{product_sales.loc&#91;top_product, 'sales_amount']:,.2f})\")\nreport_lines.append(\"-\"*50)\nreport_lines.append(\"\u3010\u7528\u6237\u7ef4\u5ea6\u3011\")\navg_user_value = user_spending&#91;'user_lifetime_value'].mean()\nreport_lines.append(f\"  \u7528\u6237\u5e73\u5747\u751f\u547d\u5468\u671f\u4ef7\u503c(LTV): \u00a5{avg_user_value:,.2f}\")\ntop_city = user_city_dist.index\nreport_lines.append(f\"  \u8d21\u732e\u6700\u5927\u7684\u57ce\u5e02: {top_city} (\u7528\u6237\u6570: {user_city_dist.loc&#91;top_city, 'user_count']:,})\")\nreport_lines.append(\"-\"*50)\nreport_lines.append(\"\u3010\u5173\u952e\u53d1\u73b0\u3011\")\nreport_lines.append(f\"  1. {top_category} \u662f\u6838\u5fc3\u9500\u552e\u54c1\u7c7b\uff0c\u8d21\u732e\u4e86 {category_analysis.loc&#91;top_category, 'gmv_share']}% \u7684GMV\u3002\")\nreport_lines.append(f\"  2. \u5934\u90e8{len(top_80_percent)}\u4e2a\u5546\u54c1\u8d21\u732e\u4e8680%\u7684\u9500\u552e\u989d\u3002\")\nreport_lines.append(\"=\"*50)\n\nfor line in report_lines:\n    print(line)\n\n# \u53ef\u9009\uff1a\u5c06\u62a5\u544a\u4fdd\u5b58\u4e3a\u6587\u672c\u6587\u4ef6\nwith open('daily_analysis_report.txt', 'w', encoding='utf-8') as f:\n    f.write('\\n'.join(report_lines))\nprint(\"&gt;&gt;&gt; \u5206\u6790\u62a5\u544a\u5df2\u4fdd\u5b58\u81f3 'daily_analysis_report.txt'\")\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%AC%E6%97%A5%E8%A6%81%E7%82%B9%E6%80%BB%E7%BB%93\"><\/span><strong>\u672c\u65e5\u8981\u70b9\u603b\u7ed3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol>\n<li><strong>\u6838\u5fc3\u6307\u6807<\/strong>\uff1aGMV\u3001\u8ba2\u5355\u6570\u3001\u7528\u6237\u6570\u3001\u5ba2\u5355\u4ef7(AOV)\u3001\u4eba\u5747\u8ba2\u5355\u6570\u662f\u7535\u5546\u5206\u6790\u57fa\u77f3\u3002<\/li>\n\n\n\n<li><strong>\u8d8b\u52bf\u5206\u6790<\/strong>\uff1a\u6309\u65e5\u3001\u5468\u3001\u6708\u805a\u5408\u6570\u636e\uff0c\u4f7f\u7528\u6298\u7ebf\u56fe\u89c2\u5bdf\u4e1a\u52a1\u8d70\u52bf\u3002<\/li>\n\n\n\n<li><strong>\u7ef4\u5ea6\u62c6\u5206<\/strong>\uff1a\u4ece\u5546\u54c1\uff08\u54c1\u7c7b\u3001\u5355\u54c1\uff09\u3001\u7528\u6237\uff08\u57ce\u5e02\u3001\u4ef7\u503c\uff09\u3001\u65f6\u95f4\u7b49\u591a\u4e2a\u7ef4\u5ea6\u5207\u5165\u5206\u6790\u3002<\/li>\n\n\n\n<li><strong>\u5206\u7ec4\u805a\u5408<\/strong>\uff1a<code>df.groupby()<\/code>&nbsp;\u662f\u7ef4\u5ea6\u5206\u6790\u7684\u7075\u9b42\uff0c\u53ef\u914d\u5408\u591a\u79cd\u805a\u5408\u51fd\u6570\u3002<\/li>\n\n\n\n<li><strong>\u4ea4\u53c9\u5206\u6790<\/strong>\uff1a<code>pd.pivot_table()<\/code>&nbsp;\u529f\u80fd\u5f3a\u5927\uff0c\u53ef\u8f7b\u677e\u5236\u4f5c\u591a\u7ef4\u4ea4\u53c9\u62a5\u8868\u3002<\/li>\n\n\n\n<li><strong>\u7ed3\u6784\u5206\u6790<\/strong>\uff1a\u5e15\u7d2f\u6258\u56fe\uff08\u4e8c\u516b\u5206\u6790\uff09\u5e2e\u52a9\u8bc6\u522b\u6838\u5fc3\u8d21\u732e\u5546\u54c1\/\u7528\u6237\u3002<\/li>\n\n\n\n<li><strong>\u62a5\u544a\u8f93\u51fa<\/strong>\uff1a\u5c06\u5206\u6790\u7ed3\u679c\u63d0\u70bc\u6210\u7b80\u6d01\u660e\u4e86\u7684\u6587\u5b57\u62a5\u544a\uff0c\u662f\u6570\u636e\u5de5\u4f5c\u7684\u6700\u7ec8\u4ef7\u503c\u4f53\u73b0\u3002<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%BE%E7%A8%8B%E6%80%BB%E7%BB%93%E4%B8%8E%E5%90%8E%E7%BB%AD%E9%A2%84%E5%91%8A\"><\/span><strong>\u8bfe\u7a0b\u603b\u7ed3\u4e0e\u540e\u7eed\u9884\u544a<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>\u7b2c1-3\u5929<\/strong>\u6211\u4eec\u6784\u5efa\u4e86\u7535\u5546\u6570\u636e\u5206\u6790\u7684<strong>\u57fa\u7840\u5de5\u4f5c\u6d41<\/strong>\uff1a<\/p>\n\n\n\n<ol>\n<li><strong>Day1 \u83b7\u53d6<\/strong>\uff1a\u642d\u5efa\u73af\u5883\uff0c\u4ece\u6587\u4ef6\u83b7\u53d6\u539f\u59cb\u6570\u636e\u3002<\/li>\n\n\n\n<li><strong>Day2 \u6e05\u6d17<\/strong>\uff1a\u5904\u7406\u810f\u6570\u636e\uff0c\u4e3a\u5206\u6790\u51c6\u5907\u597d\u201c\u5e72\u51c0\u98df\u6750\u201d\u3002<\/li>\n\n\n\n<li><strong>Day3 \u5206\u6790<\/strong>\uff1a\u8ba1\u7b97\u6838\u5fc3\u6307\u6807\uff0c\u8fdb\u884c\u591a\u7ef4\u5ea6\u63cf\u8ff0\u6027\u5206\u6790\uff0c\u4ea7\u51fa\u521d\u6b65\u6d1e\u5bdf\u3002<\/li>\n<\/ol>\n\n\n\n<p><strong>\u5173\u952e\u51fd\u6570\u4e0e\u7248\u672c<\/strong>\uff1a<\/p>\n\n\n\n<ul>\n<li><strong>Pandas<\/strong>&nbsp;(<code>pd.read_csv<\/code>,&nbsp;<code>pd.read_excel<\/code>,&nbsp;<code>df.groupby<\/code>,&nbsp;<code>pd.pivot_table<\/code>,&nbsp;<code>pd.merge<\/code>,&nbsp;<code>pd.cut<\/code>)<\/li>\n\n\n\n<li><strong>NumPy<\/strong>&nbsp;(\u57fa\u7840\u6570\u503c\u8ba1\u7b97)<\/li>\n\n\n\n<li><strong>Matplotlib\/Seaborn<\/strong>&nbsp;(<code>plt.plot<\/code>,&nbsp;<code>plt.pie<\/code>,&nbsp;<code>plt.bar<\/code>,&nbsp;<code>sns.set_style<\/code>)<\/li>\n\n\n\n<li><strong>Scikit-learn<\/strong>&nbsp;(<code>MinMaxScaler<\/code>,&nbsp;<code>StandardScaler<\/code>&nbsp;&#8211; \u7528\u4e8e\u6807\u51c6\u5316)<\/li>\n\n\n\n<li><strong>\u5efa\u8bae\u7248\u672c<\/strong>\uff1apandas&gt;=1.3.0, numpy&gt;=1.20.0, matplotlib&gt;=3.4.0, scikit-learn&gt;=0.24.0<\/li>\n<\/ul>\n\n\n\n<p><strong>\u8fd0\u884c\u8bf4\u660e<\/strong>\uff1a<\/p>\n\n\n\n<ol>\n<li>\u786e\u4fdd\u5df2\u5b89\u88c5Python\uff08&gt;=3.7\uff09\u548cJupyter Notebook\u3002<\/li>\n\n\n\n<li>\u6309\u987a\u5e8f\u6267\u884c\u6bcf\u65e5\u7684\u4ee3\u7801\u5355\u5143\u683c\u3002<\/li>\n\n\n\n<li>\u6848\u4f8b\u6570\u636e\u811a\u672c\u5df2\u5305\u542b\u5728\u4ee3\u7801\u4e2d\uff0c\u9996\u6b21\u8fd0\u884c\u65f6\u4f1a\u81ea\u52a8\u751f\u6210\u793a\u4f8bCSV\u548cExcel\u6587\u4ef6\u3002<\/li>\n\n\n\n<li>\u6240\u6709\u8f93\u51fa\u6587\u4ef6\uff08\u5982<code>cleaned_orders.csv<\/code>\u3001<code>daily_analysis_report.txt<\/code>\uff09\u5c06\u4fdd\u5b58\u5728\u5f53\u524d\u5de5\u4f5c\u76ee\u5f55\u3002<\/li>\n<\/ol>\n\n\n\n<p><strong>\u540e\u7eed\u8bfe\u7a0b\u9884\u544a<\/strong>\uff1a<\/p>\n\n\n\n<ul>\n<li><strong>\u7b2c4-6\u5929<\/strong>\uff1a\u6df1\u5165\u53ef\u89c6\u5316\u4e0e\u63a2\u7d22\u6027\u6570\u636e\u5206\u6790\uff08EDA\uff09<\/li>\n\n\n\n<li><strong>\u7b2c7-9\u5929<\/strong>\uff1a\u6d41\u91cf\u4e0e\u8f6c\u5316\u6f0f\u6597\u5206\u6790<\/li>\n\n\n\n<li><strong>\u7b2c10-15\u5929<\/strong>\uff1a\u7528\u6237\u884c\u4e3a\u5206\u6790\u4e0eRFM\u6a21\u578b\u5b9e\u6218<\/li>\n\n\n\n<li><strong>\u7b2c16-24\u5929<\/strong>\uff1a\u9500\u552e\u9884\u6d4b\u4e0e\u5e93\u5b58\u5206\u6790\u6a21\u578b<\/li>\n\n\n\n<li><strong>\u7b2c25-30\u5929<\/strong>\uff1a\u642d\u5efa\u81ea\u52a8\u5316\u62a5\u8868\u7cfb\u7edf\u4e0e\u9879\u76ee\u6574\u5408<\/li>\n<\/ul>\n\n\n\n<p>\u901a\u8fc7\u8fd93\u5929\u7684\u5b66\u4e60\uff0c\u60a8\u5df2\u7ecf\u638c\u63e1\u4e86\u7535\u5546\u6570\u636e\u5206\u6790\u7684<strong>\u5b8c\u6574\u57fa\u7840\u6d41\u7a0b<\/strong>\uff0c\u5e76\u80fd\u591f\u72ec\u7acb\u5b8c\u6210\u4ece\u6570\u636e\u83b7\u53d6\u5230\u751f\u6210\u57fa\u7840\u5206\u6790\u62a5\u544a\u7684\u5168\u8fc7\u7a0b\u3002\u63a5\u4e0b\u6765\u7684\u8bfe\u7a0b\u5c06\u5728\u6b64\u57fa\u7840\u4e0a\uff0c\u5411\u66f4\u6df1\u5ea6\u7684\u5206\u6790\u548c\u66f4\u81ea\u52a8\u5316\u7684\u5e94\u7528\u8fc8\u8fdb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bfe\u7a0b\u76ee\u6807 \u6838\u5fc3Skills \u8bfe\u4ef6\u5185\u5bb9\u4e0e\u4ee3\u7801 \u6b65\u9aa41\uff1a\u5bfc\u5165\u5e93\u4e0e\u6570\u636e \u6b65\u9aa42\uff1a\u8ba1\u7b97\u7535\u5546\u6838\u5fc3\u4e1a\u52a1\u6307\u6807 \u6b65\u9aa4&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2026\/03\/01\/%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9aday-3%ef%bc%9a%e6%8f%8f%e8%bf%b0%e6%80%a7%e7%bb%9f%e8%ae%a1%e4%b8%8e%e6%a0%b8%e5%bf%83%e6%8c%87%e6%a0%87%e5%88%86%e6%9e%90\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">\u6570\u636e\u6280\u80fd\uff08SKILLS\uff09 \uff1aDay 3\uff1a\u63cf\u8ff0\u6027\u7edf\u8ba1\u4e0e\u6838\u5fc3\u6307\u6807\u5206\u6790<\/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":[28],"views":166,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4218"}],"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=4218"}],"version-history":[{"count":2,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4218\/revisions"}],"predecessor-version":[{"id":4221,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4218\/revisions\/4221"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=4218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=4218"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=4218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}