{"id":4214,"date":"2026-03-01T10:03:05","date_gmt":"2026-03-01T02:03:05","guid":{"rendered":"http:\/\/viplao.com\/?p=4214"},"modified":"2026-03-01T10:03:07","modified_gmt":"2026-03-01T02:03:07","slug":"%e6%95%b0%e6%8d%ae%e6%8a%80%e8%83%bd%ef%bc%88skills%ef%bc%89-%ef%bc%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80","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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/","title":{"rendered":"\u6570\u636e\u6280\u80fd\uff08Skills\uff09 \uff1a\u7b2c1\u5929\uff1a\u73af\u5883\u642d\u5efa\u4e0e\u6570\u636e\u83b7\u53d6\u57fa\u7840"},"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-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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A41%EF%BC%9A%E7%8E%AF%E5%A2%83%E5%87%86%E5%A4%87%E4%B8%8E%E5%BA%93%E5%AE%89%E8%A3%85\" title=\"\u6b65\u9aa41\uff1a\u73af\u5883\u51c6\u5907\u4e0e\u5e93\u5b89\u88c5\">\u6b65\u9aa41\uff1a\u73af\u5883\u51c6\u5907\u4e0e\u5e93\u5b89\u88c5<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A42%EF%BC%9A%E5%88%9B%E5%BB%BAJupyter_Notebook%E5%B9%B6%E5%AF%BC%E5%85%A5%E5%BA%93\" title=\"\u6b65\u9aa42\uff1a\u521b\u5efaJupyter Notebook\u5e76\u5bfc\u5165\u5e93\">\u6b65\u9aa42\uff1a\u521b\u5efaJupyter Notebook\u5e76\u5bfc\u5165\u5e93<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A43%EF%BC%9A%E4%BB%8ECSV%E6%96%87%E4%BB%B6%E8%AF%BB%E5%8F%96%E8%AE%A2%E5%8D%95%E6%95%B0%E6%8D%AE\" title=\"\u6b65\u9aa43\uff1a\u4eceCSV\u6587\u4ef6\u8bfb\u53d6\u8ba2\u5355\u6570\u636e\">\u6b65\u9aa43\uff1a\u4eceCSV\u6587\u4ef6\u8bfb\u53d6\u8ba2\u5355\u6570\u636e<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A44%EF%BC%9A%E4%BB%8EExcel%E6%96%87%E4%BB%B6%E8%AF%BB%E5%8F%96%E5%95%86%E5%93%81%E4%BF%A1%E6%81%AF\" title=\"\u6b65\u9aa44\uff1a\u4eceExcel\u6587\u4ef6\u8bfb\u53d6\u5546\u54c1\u4fe1\u606f\">\u6b65\u9aa44\uff1a\u4eceExcel\u6587\u4ef6\u8bfb\u53d6\u5546\u54c1\u4fe1\u606f<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A45%EF%BC%9A%E6%95%B0%E6%8D%AE%E6%A6%82%E8%A7%88%E4%B8%8E%E5%9F%BA%E6%9C%AC%E4%BF%A1%E6%81%AF%E6%9F%A5%E7%9C%8B\" title=\"\u6b65\u9aa45\uff1a\u6570\u636e\u6982\u89c8\u4e0e\u57fa\u672c\u4fe1\u606f\u67e5\u770b\">\u6b65\u9aa45\uff1a\u6570\u636e\u6982\u89c8\u4e0e\u57fa\u672c\u4fe1\u606f\u67e5\u770b<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A46%EF%BC%9A%E7%AE%80%E5%8D%95%E6%95%B0%E6%8D%AE%E7%AD%9B%E9%80%89%E4%B8%8E%E6%8E%92%E5%BA%8F\" title=\"\u6b65\u9aa46\uff1a\u7b80\u5355\u6570\u636e\u7b5b\u9009\u4e0e\u6392\u5e8f\">\u6b65\u9aa46\uff1a\u7b80\u5355\u6570\u636e\u7b5b\u9009\u4e0e\u6392\u5e8f<\/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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A47%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%90%88%E5%B9%B6%EF%BC%88%E5%85%B3%E8%81%94%E8%AE%A2%E5%8D%95%E4%B8%8E%E5%95%86%E5%93%81%EF%BC%89\" title=\"\u6b65\u9aa47\uff1a\u6570\u636e\u5408\u5e76\uff08\u5173\u8054\u8ba2\u5355\u4e0e\u5546\u54c1\uff09\">\u6b65\u9aa47\uff1a\u6570\u636e\u5408\u5e76\uff08\u5173\u8054\u8ba2\u5355\u4e0e\u5546\u54c1\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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A48%EF%BC%9A%E5%9F%BA%E7%A1%80%E5%8F%AF%E8%A7%86%E5%8C%96_%E2%80%93_%E9%94%80%E5%94%AE%E7%B1%BB%E5%88%AB%E5%88%86%E5%B8%83\" title=\"\u6b65\u9aa48\uff1a\u57fa\u7840\u53ef\u89c6\u5316 &#8211; \u9500\u552e\u7c7b\u522b\u5206\u5e03\">\u6b65\u9aa48\uff1a\u57fa\u7840\u53ef\u89c6\u5316 &#8211; \u9500\u552e\u7c7b\u522b\u5206\u5e03<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%E6%AD%A5%E9%AA%A49%EF%BC%9A%E4%BF%9D%E5%AD%98%E5%A4%84%E7%90%86%E7%BB%93%E6%9E%9C\" title=\"\u6b65\u9aa49\uff1a\u4fdd\u5b58\u5904\u7406\u7ed3\u679c\">\u6b65\u9aa49\uff1a\u4fdd\u5b58\u5904\u7406\u7ed3\u679c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/#%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><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"f67e1120\"><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\u63e1Python\u6570\u636e\u5206\u6790\u57fa\u7840\u73af\u5883\u7684\u642d\u5efa\u3002<\/li>\n\n\n\n<li>\u5b66\u4e60\u4ece\u591a\u79cd\u6570\u636e\u6e90\uff08Excel\u3001CSV\u3001\u6570\u636e\u5e93\uff09\u83b7\u53d6\u7535\u5546\u8fd0\u8425\u6570\u636e\u3002<\/li>\n\n\n\n<li>\u5b8c\u6210\u7b2c\u4e00\u4e2a\u6570\u636e\u8bfb\u53d6\u4e0e\u9884\u89c8\u7684\u5b9e\u6218\u6848\u4f8b\u3002<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"0d232210\"><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>\u73af\u5883\u914d\u7f6e<\/strong>\uff1aPython\u3001Jupyter Notebook\u3001\u6838\u5fc3\u5e93\u5b89\u88c5<\/li>\n\n\n\n<li><strong>\u6570\u636e\u83b7\u53d6<\/strong>\uff1a\u4f7f\u7528Pandas\u8bfb\u53d6\u7ed3\u6784\u5316\u6587\u4ef6<\/li>\n\n\n\n<li><strong>\u6570\u636e\u9884\u89c8<\/strong>\uff1a\u6570\u636e\u6982\u89c8\u3001\u4fe1\u606f\u67e5\u770b\u3001\u57fa\u7840\u7edf\u8ba1<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"03d9da23\"><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\" id=\"da894476\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A41%EF%BC%9A%E7%8E%AF%E5%A2%83%E5%87%86%E5%A4%87%E4%B8%8E%E5%BA%93%E5%AE%89%E8%A3%85\"><\/span><strong>\u6b65\u9aa41\uff1a\u73af\u5883\u51c6\u5907\u4e0e\u5e93\u5b89\u88c5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"VVDJN\" class=\"wp-block-code\"><code># \u8bfe\u4ef6\u6ce8\u91ca\uff1a\u672c\u90e8\u5206\u4e3a\u73af\u5883\u51c6\u5907\uff0c\u5b66\u5458\u9700\u63d0\u524d\u5b89\u88c5Anaconda\u6216Miniconda\n# \u4ee5\u4e0b\u4ee3\u7801\u4e3a\u5e93\u5b89\u88c5\u547d\u4ee4\uff0c\u5728\u7ec8\u7aef(Terminal)\u6216\u547d\u4ee4\u63d0\u793a\u7b26(CMD)\u4e2d\u6267\u884c\uff0c\u975ePython\u811a\u672c\n\n# \u5b89\u88c5\u6838\u5fc3\u6570\u636e\u5206\u6790\u5e93\n# pip install pandas numpy matplotlib seaborn jupyter -i https:\/\/pypi.tuna.tsinghua.edu.cn\/simple\n\n# \u5b89\u88c5\u6570\u636e\u5e93\u8fde\u63a5\u5e93\uff08\u53ef\u9009\uff0c\u6839\u636e\u540e\u7eed\u8bfe\u7a0b\u9700\u8981\uff09\n# pip install pymysql sqlalchemy openpyxl xlrd -i https:\/\/pypi.tuna.tsinghua.edu.cn\/simple<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"40071cb0\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A42%EF%BC%9A%E5%88%9B%E5%BB%BAJupyter_Notebook%E5%B9%B6%E5%AF%BC%E5%85%A5%E5%BA%93\"><\/span><strong>\u6b65\u9aa42\uff1a\u521b\u5efaJupyter Notebook\u5e76\u5bfc\u5165\u5e93<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"vn9PN\" class=\"wp-block-code\"><code># \u4ee3\u7801\u6587\u4ef6\uff1aday1_data_acquisition.ipynb\n# \u6848\u4f8b\u6570\u636e\u6587\u4ef6\uff1a\u9700\u51c6\u5907 `sample_orders.csv` \u548c `product_info.xlsx`\n\n# 1. \u5bfc\u5165\u5fc5\u5907\u5e93\nimport pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\nimport seaborn as sns\nimport warnings\nwarnings.filterwarnings('ignore')  # \u5ffd\u7565\u8b66\u544a\u4fe1\u606f\n\n# \u8bbe\u7f6e\u4e2d\u6587\u663e\u793a\u548c\u56fe\u5f62\u6837\u5f0f\nplt.rcParams&#91;'font.sans-serif'] = &#91;'SimHei', 'Microsoft YaHei']  # \u7528\u6765\u6b63\u5e38\u663e\u793a\u4e2d\u6587\u6807\u7b7e\nplt.rcParams&#91;'axes.unicode_minus'] = False  # \u7528\u6765\u6b63\u5e38\u663e\u793a\u8d1f\u53f7\nsns.set_style(\"whitegrid\")\nprint(\"&gt;&gt;&gt; \u6838\u5fc3\u5e93\u5bfc\u5165\u6210\u529f\uff01\")<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"dfb293bb\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A43%EF%BC%9A%E4%BB%8ECSV%E6%96%87%E4%BB%B6%E8%AF%BB%E5%8F%96%E8%AE%A2%E5%8D%95%E6%95%B0%E6%8D%AE\"><\/span><strong>\u6b65\u9aa43\uff1a\u4eceCSV\u6587\u4ef6\u8bfb\u53d6\u8ba2\u5355\u6570\u636e<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"MQSKx\" class=\"wp-block-code\"><code># 2. \u4eceCSV\u6587\u4ef6\u8bfb\u53d6\u7535\u5546\u8ba2\u5355\u6570\u636e\n# \u5047\u8bbe `sample_orders.csv` \u6587\u4ef6\u5185\u5bb9\u793a\u4f8b\uff1a\n# order_id,user_id,order_date,product_id,quantity,unit_price,city,category\n# 1001,201,2023-10-01,P001,2,299.9,\u5317\u4eac,\u7535\u5b50\u4ea7\u54c1\n# 1002,202,2023-10-01,P002,1,1599.0,\u4e0a\u6d77,\u5bb6\u7528\u7535\u5668\n# ...\u66f4\u591a\u8bb0\u5f55...\n\ntry:\n    df_orders = pd.read_csv('sample_orders.csv', encoding='utf-8')\n    print(f\"&gt;&gt;&gt; \u8ba2\u5355\u6570\u636e\u8bfb\u53d6\u6210\u529f\uff01\u5171 {df_orders.shape&#91;0]} \u884c\uff0c{df_orders.shape&#91;1]} \u5217\u3002\")\n    print(\"&gt;&gt;&gt; \u6570\u636e\u524d5\u884c\u9884\u89c8\uff1a\")\n    display(df_orders.head())  # \u5728Jupyter\u4e2d\u4f18\u96c5\u663e\u793a\uff0c\u4e5f\u53ef\u7528 print(df_orders.head())\nexcept FileNotFoundError:\n    print(\"&gt;&gt;&gt; \u6587\u4ef6\u672a\u627e\u5230\uff0c\u6b63\u5728\u521b\u5efa\u793a\u4f8b\u6570\u636e...\")\n    # \u751f\u6210\u6a21\u62df\u8ba2\u5355\u6570\u636e\u4f9b\u7ec3\u4e60\n    np.random.seed(42)\n    num_orders = 1000\n    data = {\n        'order_id': range(1000, 1000 + num_orders),\n        'user_id': np.random.randint(200, 500, num_orders),\n        'order_date': pd.date_range('2023-10-01', periods=num_orders, freq='H').strftime('%Y-%m-%d'),\n        'product_id': &#91;'P' + str(i).zfill(3) for i in np.random.randint(1, 20, num_orders)],\n        'quantity': np.random.randint(1, 5, num_orders),\n        'unit_price': np.round(np.random.uniform(50, 2000, num_orders), 2),\n        'city': np.random.choice(&#91;'\u5317\u4eac', '\u4e0a\u6d77', '\u5e7f\u5dde', '\u6df1\u5733', '\u676d\u5dde', '\u6210\u90fd'], num_orders),\n        'category': np.random.choice(&#91;'\u7535\u5b50\u4ea7\u54c1', '\u5bb6\u7528\u7535\u5668', '\u670d\u88c5\u670d\u9970', '\u7f8e\u5986\u4e2a\u62a4', '\u98df\u54c1\u751f\u9c9c'], num_orders)\n    }\n    df_orders = pd.DataFrame(data)\n    df_orders&#91;'total_amount'] = df_orders&#91;'quantity'] * df_orders&#91;'unit_price']  # \u8ba1\u7b97\u8ba2\u5355\u91d1\u989d\n    df_orders.to_csv('sample_orders.csv', index=False, encoding='utf-8')\n    print(f\"&gt;&gt;&gt; \u793a\u4f8b\u8ba2\u5355\u6570\u636e\u5df2\u751f\u6210\u5e76\u4fdd\u5b58\uff01\u5171 {df_orders.shape&#91;0]} \u884c\u3002\")\n    display(df_orders.head())<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"0ac686b5\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A44%EF%BC%9A%E4%BB%8EExcel%E6%96%87%E4%BB%B6%E8%AF%BB%E5%8F%96%E5%95%86%E5%93%81%E4%BF%A1%E6%81%AF\"><\/span><strong>\u6b65\u9aa44\uff1a\u4eceExcel\u6587\u4ef6\u8bfb\u53d6\u5546\u54c1\u4fe1\u606f<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"jxqli\" class=\"wp-block-code\"><code># 3. \u4eceExcel\u6587\u4ef6\u8bfb\u53d6\u5546\u54c1\u4fe1\u606f\n# \u5047\u8bbe `product_info.xlsx` \u6587\u4ef6\u6709\u4e00\u4e2a\u540d\u4e3a `Products` \u7684\u5de5\u4f5c\u8868\ntry:\n    df_products = pd.read_excel('product_info.xlsx', sheet_name='Products')\n    print(f\"&gt;&gt;&gt; \u5546\u54c1\u4fe1\u606f\u8bfb\u53d6\u6210\u529f\uff01\u5171 {df_products.shape&#91;0]} \u884c\u3002\")\n    display(df_products.head())\nexcept FileNotFoundError:\n    print(\"&gt;&gt;&gt; Excel\u6587\u4ef6\u672a\u627e\u5230\uff0c\u6b63\u5728\u521b\u5efa\u793a\u4f8b\u5546\u54c1\u6570\u636e...\")\n    # \u751f\u6210\u6a21\u62df\u5546\u54c1\u6570\u636e\n    product_data = {\n        'product_id': &#91;'P' + str(i).zfill(3) for i in range(1, 21)],\n        'product_name': &#91;f'\u5546\u54c1_{i}' for i in range(1, 21)],\n        'cost_price': np.round(np.random.uniform(30, 1500, 20), 2),\n        'brand': np.random.choice(&#91;'\u54c1\u724cA', '\u54c1\u724cB', '\u54c1\u724cC', '\u54c1\u724cD'], 20),\n        'warehouse': np.random.choice(&#91;'\u534e\u5317\u4ed3', '\u534e\u4e1c\u4ed3', '\u534e\u5357\u4ed3'], 20)\n    }\n    df_products = pd.DataFrame(product_data)\n    # \u4fdd\u5b58\u4e3aExcel\u6587\u4ef6\uff0c\u9700\u8981 openpyxl \u5e93\n    df_products.to_excel('product_info.xlsx', sheet_name='Products', index=False)\n    print(\"&gt;&gt;&gt; \u793a\u4f8b\u5546\u54c1\u6570\u636e\u5df2\u751f\u6210\u5e76\u4fdd\u5b58\uff01\")\n    display(df_products.head())<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"39dd386d\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A45%EF%BC%9A%E6%95%B0%E6%8D%AE%E6%A6%82%E8%A7%88%E4%B8%8E%E5%9F%BA%E6%9C%AC%E4%BF%A1%E6%81%AF%E6%9F%A5%E7%9C%8B\"><\/span><strong>\u6b65\u9aa45\uff1a\u6570\u636e\u6982\u89c8\u4e0e\u57fa\u672c\u4fe1\u606f\u67e5\u770b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"eID5b\" class=\"wp-block-code\"><code># 4. \u6570\u636e\u57fa\u7840\u63a2\u67e5 - \u8ba2\u5355\u6570\u636e\nprint(\"=\"*50)\nprint(\"\u3010\u8ba2\u5355\u6570\u636e\u6982\u89c8\u3011\")\nprint(\"=\"*50)\nprint(\"1. \u6570\u636e\u5f62\u72b6 (\u884c\u6570, \u5217\u6570):\", df_orders.shape)\nprint(\"\\n2. \u5217\u540d\u4e0e\u6570\u636e\u7c7b\u578b:\")\nprint(df_orders.dtypes)\nprint(\"\\n3. \u57fa\u672c\u4fe1\u606f (\u5305\u542b\u975e\u7a7a\u503c\u8ba1\u6570):\")\ndf_orders.info()\nprint(\"\\n4. \u6570\u503c\u578b\u5b57\u6bb5\u7684\u7edf\u8ba1\u63cf\u8ff0 (\u5747\u503c\u3001\u6807\u51c6\u5dee\u3001\u5206\u4f4d\u6570\u7b49):\")\ndisplay(df_orders.describe())\nprint(\"\\n5. \u67e5\u770b\u662f\u5426\u5b58\u5728\u7f3a\u5931\u503c:\")\nprint(df_orders.isnull().sum())<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"ec498e4b\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A46%EF%BC%9A%E7%AE%80%E5%8D%95%E6%95%B0%E6%8D%AE%E7%AD%9B%E9%80%89%E4%B8%8E%E6%8E%92%E5%BA%8F\"><\/span><strong>\u6b65\u9aa46\uff1a\u7b80\u5355\u6570\u636e\u7b5b\u9009\u4e0e\u6392\u5e8f<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"VIRU9\" class=\"wp-block-code\"><code># 5. \u6570\u636e\u521d\u6b65\u64cd\u4f5c\u5b9e\u6218\nprint(\"=\"*50)\nprint(\"\u3010\u5b9e\u6218\u64cd\u4f5c\uff1a\u6570\u636e\u7b5b\u9009\u4e0e\u6392\u5e8f\u3011\")\nprint(\"=\"*50)\n# a) \u7b5b\u9009\u7279\u5b9a\u57ce\u5e02\u7684\u8ba2\u5355\uff0c\u4f8b\u5982\u4e0a\u6d77\norders_shanghai = df_orders&#91;df_orders&#91;'city'] == '\u4e0a\u6d77']\nprint(f\"&gt;&gt;&gt; \u4e0a\u6d77\u7684\u8ba2\u5355\u5171\u6709 {orders_shanghai.shape&#91;0]} \u7b14\u3002\")\ndisplay(orders_shanghai.head())\n\n# b) \u7b5b\u9009\u91d1\u989d\u5927\u4e8e1000\u7684\u8ba2\u5355\nhigh_value_orders = df_orders&#91;df_orders&#91;'total_amount'] &gt; 1000]\nprint(f\"&gt;&gt;&gt; \u91d1\u989d\u5927\u4e8e1000\u7684\u9ad8\u4ef7\u503c\u8ba2\u5355\u6709 {high_value_orders.shape&#91;0]} \u7b14\u3002\")\n\n# c) \u6309\u8ba2\u5355\u91d1\u989d\u964d\u5e8f\u6392\u5217\uff0c\u67e5\u770bTop 10\ntop10_orders = df_orders.sort_values(by='total_amount', ascending=False).head(10)\nprint(\"&gt;&gt;&gt; \u8ba2\u5355\u91d1\u989dTop 10:\")\ndisplay(top10_orders&#91;&#91;'order_id', 'user_id', 'total_amount', 'city', 'category']])\n\n# d) \u6309\u5546\u54c1\u7c7b\u522b\u7edf\u8ba1\u8ba2\u5355\u6570\u91cf\ncategory_order_count = df_orders&#91;'category'].value_counts()\nprint(\"&gt;&gt;&gt; \u5404\u5546\u54c1\u7c7b\u522b\u8ba2\u5355\u6570\u91cf\u5206\u5e03:\")\nprint(category_order_count)<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"78879954\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A47%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%90%88%E5%B9%B6%EF%BC%88%E5%85%B3%E8%81%94%E8%AE%A2%E5%8D%95%E4%B8%8E%E5%95%86%E5%93%81%EF%BC%89\"><\/span><strong>\u6b65\u9aa47\uff1a\u6570\u636e\u5408\u5e76\uff08\u5173\u8054\u8ba2\u5355\u4e0e\u5546\u54c1\uff09<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"M9kf5\" class=\"wp-block-code\"><code># 6. \u6570\u636e\u5408\u5e76\uff1a\u5c06\u8ba2\u5355\u6570\u636e\u4e0e\u5546\u54c1\u4fe1\u606f\u5173\u8054\nprint(\"=\"*50)\nprint(\"\u3010\u5b9e\u6218\u64cd\u4f5c\uff1a\u6570\u636e\u5408\u5e76\u3011\")\nprint(\"=\"*50)\n# \u4f7f\u7528 product_id \u4f5c\u4e3a\u952e\uff0c\u8fdb\u884c\u5de6\u8fde\u63a5\uff0c\u4fdd\u7559\u6240\u6709\u8ba2\u5355\u8bb0\u5f55\ndf_merged = pd.merge(df_orders, df_products, on='product_id', how='left')\nprint(f\"&gt;&gt;&gt; \u5408\u5e76\u540e\u7684\u6570\u636e\u5f62\u72b6: {df_merged.shape}\")\nprint(\"&gt;&gt;&gt; \u5408\u5e76\u540e\u6570\u636e\u5217\u540d:\", df_merged.columns.tolist())\ndisplay(df_merged.head())\n\n# \u8ba1\u7b97\u6bdb\u5229\u6da6 (\u5047\u8bbe total_amount \u662f\u9500\u552e\u989d)\ndf_merged&#91;'gross_profit'] = df_merged&#91;'total_amount'] - (df_merged&#91;'cost_price'] * df_merged&#91;'quantity'])\nprint(\"&gt;&gt;&gt; \u5df2\u8ba1\u7b97\u6bdb\u5229\u6da6\uff0c\u524d5\u884c\u6570\u636e:\")\ndisplay(df_merged&#91;&#91;'order_id', 'product_id', 'total_amount', 'cost_price', 'quantity', 'gross_profit']].head())<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5b9bc41f\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A48%EF%BC%9A%E5%9F%BA%E7%A1%80%E5%8F%AF%E8%A7%86%E5%8C%96_%E2%80%93_%E9%94%80%E5%94%AE%E7%B1%BB%E5%88%AB%E5%88%86%E5%B8%83\"><\/span><strong>\u6b65\u9aa48\uff1a\u57fa\u7840\u53ef\u89c6\u5316 &#8211; \u9500\u552e\u7c7b\u522b\u5206\u5e03<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"yh8cG\" class=\"wp-block-code\"><code># 7. \u57fa\u7840\u6570\u636e\u53ef\u89c6\u5316\nprint(\"=\"*50)\nprint(\"\u3010\u5b9e\u6218\u64cd\u4f5c\uff1a\u57fa\u7840\u53ef\u89c6\u5316\u3011\")\nprint(\"=\"*50)\n# \u7ed8\u5236\u8ba2\u5355\u7c7b\u522b\u7684\u67f1\u72b6\u56fe\nplt.figure(figsize=(10, 6))\ncategory_order_count.plot(kind='bar', color='skyblue', edgecolor='black')\nplt.title('\u5404\u5546\u54c1\u7c7b\u522b\u8ba2\u5355\u6570\u91cf\u5206\u5e03', fontsize=15)\nplt.xlabel('\u5546\u54c1\u7c7b\u522b', fontsize=12)\nplt.ylabel('\u8ba2\u5355\u6570\u91cf', fontsize=12)\nplt.xticks(rotation=45)  # \u65cb\u8f6cx\u8f74\u6807\u7b7e\nplt.tight_layout()\nplt.show()\n\n# \u7ed8\u5236\u57ce\u5e02\u9500\u552e\u989d\u997c\u56fe\ncity_sales = df_orders.groupby('city')&#91;'total_amount'].sum().sort_values(ascending=False)\nplt.figure(figsize=(8, 8))\nplt.pie(city_sales.values, labels=city_sales.index, autopct='%1.1f%%', startangle=90, colors=sns.color_palette('pastel'))\nplt.title('\u5404\u57ce\u5e02\u9500\u552e\u989d\u5360\u6bd4', fontsize=15)\nplt.show()<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"ded3864f\"><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A49%EF%BC%9A%E4%BF%9D%E5%AD%98%E5%A4%84%E7%90%86%E7%BB%93%E6%9E%9C\"><\/span><strong>\u6b65\u9aa49\uff1a\u4fdd\u5b58\u5904\u7406\u7ed3\u679c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre id=\"NXd7b\" class=\"wp-block-code\"><code># 8. \u5c06\u5904\u7406\u540e\u7684\u6570\u636e\u4fdd\u5b58\u4e3a\u65b0\u6587\u4ef6\ndf_merged.to_csv('processed_orders_with_profit.csv', index=False, encoding='utf-8')\nprint(\"&gt;&gt;&gt; \u5904\u7406\u540e\u7684\u5408\u5e76\u6570\u636e\u5df2\u4fdd\u5b58\u4e3a 'processed_orders_with_profit.csv'\")<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"8486eb9d\"><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>\u73af\u5883\u662f\u6839\u57fa<\/strong>\uff1a\u6210\u529f\u914d\u7f6ePython\u3001Jupyter\u53caPandas\u7b49\u5e93\u662f\u7b2c\u4e00\u6b65\u3002<\/li>\n\n\n\n<li><code><strong>pd.read_csv()<\/strong><\/code><strong> <\/strong><strong>\u548c<\/strong><strong> <\/strong><code><strong>pd.read_excel()<\/strong><\/code> \u662f\u8bfb\u53d6\u672c\u5730\u6587\u4ef6\u6700\u5e38\u7528\u7684\u51fd\u6570\u3002<\/li>\n\n\n\n<li><strong>\u6570\u636e\u9884\u89c8\u56db\u677f\u65a7<\/strong>\uff1a<code>.head()<\/code>\u3001<code>.info()<\/code>\u3001<code>.describe()<\/code>\u3001<code>.isnull().sum()<\/code>\u3002<\/li>\n\n\n\n<li><strong>\u6570\u636e\u7b5b\u9009<\/strong>\uff1a\u4f7f\u7528\u5e03\u5c14\u7d22\u5f15 <code>df[df['\u5217\u540d'] &gt; \u503c]<\/code>\u3002<\/li>\n\n\n\n<li><strong>\u6570\u636e\u6392\u5e8f<\/strong>\uff1a<code>.sort_values()<\/code>\u3002<\/li>\n\n\n\n<li><strong>\u6570\u636e\u5408\u5e76<\/strong>\uff1a<code>pd.merge()<\/code> \u5b9e\u73b0\u7c7b\u4f3cSQL\u7684JOIN\u64cd\u4f5c\u3002<\/li>\n\n\n\n<li><strong>\u521d\u6b65\u53ef\u89c6\u5316<\/strong>\uff1aPandas\u5185\u7f6e\u7684 <code>.plot()<\/code> \u65b9\u6cd5\u5feb\u901f\u7ed8\u56fe\u3002<\/li>\n<\/ol>\n\n\n\n<p id=\"ud3adb031\"><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bfe\u7a0b\u76ee\u6807 \u6838\u5fc3Skills \u8bfe\u4ef6\u5185\u5bb9\u4e0e\u4ee3\u7801 \u6b65\u9aa41\uff1a\u73af\u5883\u51c6\u5907\u4e0e\u5e93\u5b89\u88c5 \u6b65\u9aa42\uff1a\u521b\u5efaJupyter N&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%9a%e7%ac%ac1%e5%a4%a9%ef%bc%9a%e7%8e%af%e5%a2%83%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%95%b0%e6%8d%ae%e8%8e%b7%e5%8f%96%e5%9f%ba%e7%a1%80\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">\u6570\u636e\u6280\u80fd\uff08Skills\uff09 \uff1a\u7b2c1\u5929\uff1a\u73af\u5883\u642d\u5efa\u4e0e\u6570\u636e\u83b7\u53d6\u57fa\u7840<\/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":141,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4214"}],"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=4214"}],"version-history":[{"count":1,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4214\/revisions"}],"predecessor-version":[{"id":4215,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/4214\/revisions\/4215"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=4214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=4214"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=4214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}