{"id":3540,"date":"2025-06-28T08:14:03","date_gmt":"2025-06-28T00:14:03","guid":{"rendered":"http:\/\/viplao.com\/?p=3540"},"modified":"2025-06-28T13:39:40","modified_gmt":"2025-06-28T05:39:40","slug":"%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/","title":{"rendered":"\u3010Python10\u5e74\u7ecf\u9a8c\u603b\u7ed3\u3011\u7b2c\u56db\u8bfe \u7535\u5546\u5e73\u53f0\u9500\u552e\u6570\u636e\u5206\u6790\u5b9e\u8df5\u5206\u89e3 \u2013\u00a0\u6570\u636e\u805a\u5408\uff08Data Aggregation\uff09"},"content":{"rendered":"\n<p>\u5e38\u89c1\u7528\u7684\u6570\u636e\u805a\u5408\u573a\u666f\uff1a<\/p>\n\n\n\n<p>\u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf<br>\u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf<br>\u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4<br>\u6309\u7528\u6237\u5206\u5c42\uff08VIP\/\u666e\u901a\uff09\u7edf\u8ba1\u8d2d\u4e70\u529b<br>\u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7<br>\u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0<br>\u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570<br>\u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d<br>\u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316<br>\u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6211\u4eec\u5c06\u5c55\u793a\u5982\u4f55\u8fdb\u884c\u8fd9\u4e9b\u5e38\u89c1\u7684\u6570\u636e\u805a\u5408\u4efb\u52a1\u3002\u5047\u8bbe\u6211\u4eec\u6709\u4e00\u4e2a\u5305\u542b\u9500\u552e\u8ba2\u5355\u6570\u636e\u7684DataFrame\uff0c\u5e76\u9010\u6b65\u5e94\u7528\u8fd9\u4e9b\u805a\u5408\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p>\u9996\u5148\uff0c\u8ba9\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u793a\u4f8bDataFrame\u6765\u6a21\u62df\u539f\u59cb\u6570\u636e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport numpy as np\n\n# \u521b\u5efa\u793a\u4f8bDataFrame\ndata = {\n    'order_id': &#91;1, 2, 3, 4, 5, 6, 7, 8, 9, 10],\n    'product_id': &#91;'A001', 'B002', 'D004', 'E005', 'F006', 'G007', 'H008', 'I009', 'J010', 'K011'],\n    'category_code': &#91;'C1', 'C2', 'C1', 'C3', 'C4', 'C5', 'C6', 'C7', 'C1', 'C2'],\n    'amount': &#91;100.00, 200.00, 300.00, 400.00, 500.00, 600.00, 700.00, 800.00, 900.00, 1000.00],\n    'original_price': &#91;120.00, 220.00, 320.00, 420.00, 520.00, 620.00, 720.00, 820.00, 920.00, 1020.00],\n    'quantity': &#91;1, 2, 1, 1, 2, 1, 1, 2, 1, 2],\n    'order_date': &#91;\n        '2025-06-01 10:00:00', '2025-06-01 12:00:00', '2025-06-02 14:00:00',\n        '2025-06-03 16:00:00', '2025-06-04 18:00:00', '2025-06-05 20:00:00',\n        '2025-06-06 22:00:00', '2025-06-07 10:00:00', '2025-06-08 12:00:00',\n        '2025-06-09 14:00:00'\n    ],\n    'customer_id': &#91;101, 102, 103, 104, 105, 106, 107, 108, 101, 102],\n    'promotion': &#91;False, True, False, True, False, True, False, True, False, True],\n    'region': &#91;'Beijing', 'Shanghai', 'Guangzhou', 'Shenzhen', 'Hangzhou', 'Chengdu', 'Nanjing', 'Wuhan', 'Beijing', 'Shanghai'],\n    'channel': &#91;'Online', 'Offline', 'Online', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online'],\n    'hour': &#91;10, 12, 14, 16, 18, 20, 22, 10, 12, 14],\n    'brand': &#91;'BrandA', 'BrandB', 'BrandA', 'BrandC', 'BrandB', 'BrandD', 'BrandA', 'BrandC', 'BrandB', 'BrandD'],\n    'inventory_days': &#91;30, 45, 30, 60, 45, 60, 30, 60, 45, 60],\n    'membership_level': &#91;'VIP', 'Normal', 'Normal', 'VIP', 'Normal', 'Normal', 'VIP', 'Normal', 'VIP', 'Normal']\n}\n\ndf = pd.DataFrame(data)\nprint(\"\u539f\u59cb\u6570\u636e:\")\nprint(df)<\/code><\/pre>\n\n\n\n<p>\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u9010\u4e2a\u5904\u7406\u4e0a\u8ff0\u63d0\u5230\u7684\u6570\u636e\u805a\u5408\u4efb\u52a1\u3002<\/p>\n\n\n\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\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#1_%E6%8C%89%E6%9C%88%E4%BB%BD%E7%BB%9F%E8%AE%A1%E9%94%80%E5%94%AE%E9%A2%9D%E4%B8%8E%E8%AE%A2%E5%8D%95%E9%87%8F\" title=\"1. \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\">1. \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf<\/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\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#2_%E6%8C%89%E5%93%81%E7%B1%BB%E7%BB%9F%E8%AE%A1%E5%B9%B3%E5%9D%87%E5%94%AE%E4%BB%B7%E4%B8%8E%E9%94%80%E9%87%8F\" title=\"2. \u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\">2. \u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf<\/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\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#3_%E6%8C%89%E5%9C%B0%E5%8C%BA%E6%B1%87%E6%80%BB%E9%94%80%E5%94%AE%E9%A2%9D%E5%8D%A0%E6%AF%94\" title=\"3. \u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4\">3. \u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#4_%E6%8C%89%E7%94%A8%E6%88%B7%E5%88%86%E5%B1%82%EF%BC%88VIP%E6%99%AE%E9%80%9A%EF%BC%89%E7%BB%9F%E8%AE%A1%E8%B4%AD%E4%B9%B0%E5%8A%9B\" title=\"4. \u6309\u7528\u6237\u5206\u5c42\uff08VIP\/\u666e\u901a\uff09\u7edf\u8ba1\u8d2d\u4e70\u529b\">4. \u6309\u7528\u6237\u5206\u5c42\uff08VIP\/\u666e\u901a\uff09\u7edf\u8ba1\u8d2d\u4e70\u529b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#5_%E6%8C%89%E6%B8%A0%E9%81%93%E7%BB%9F%E8%AE%A1%E8%BD%AC%E5%8C%96%E7%8E%87%E4%B8%8E%E5%AE%A2%E5%8D%95%E4%BB%B7\" title=\"5. \u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7\">5. \u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#6_%E6%8C%89%E5%B0%8F%E6%97%B6%E7%B2%92%E5%BA%A6%E7%BB%9F%E8%AE%A1%E8%AE%BF%E9%97%AE%E4%B8%8B%E5%8D%95%E9%AB%98%E5%B3%B0\" title=\"6. \u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0\">6. \u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#7_%E6%8C%89SKU%E7%BB%9F%E8%AE%A1%E5%BA%93%E5%AD%98%E5%91%A8%E8%BD%AC%E5%A4%A9%E6%95%B0\" title=\"7. \u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570\">7. \u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#8_%E6%8C%89%E4%BF%83%E9%94%80%E6%B4%BB%E5%8A%A8%E7%BB%9F%E8%AE%A1%E5%8F%82%E4%B8%8E%E4%BA%BA%E6%95%B0%E4%B8%8E%E6%88%90%E4%BA%A4%E9%A2%9D\" title=\"8. \u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d\">8. \u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#9_%E6%8C%89%E5%93%81%E7%89%8C%E7%BB%9F%E8%AE%A1%E5%B8%82%E5%9C%BA%E4%BB%BD%E9%A2%9D%E5%8F%98%E5%8C%96\" title=\"9. \u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316\">9. \u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/#10_%E6%8C%89%E4%BC%9A%E5%91%98%E7%AD%89%E7%BA%A7%E7%BB%9F%E8%AE%A1%E5%A4%8D%E8%B4%AD%E7%8E%87\" title=\"10. \u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387\">10. \u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%E6%8C%89%E6%9C%88%E4%BB%BD%E7%BB%9F%E8%AE%A1%E9%94%80%E5%94%AE%E9%A2%9D%E4%B8%8E%E8%AE%A2%E5%8D%95%E9%87%8F\"><\/span>1. \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u8f6c\u6362order_date\u4e3a\u65e5\u671f\u683c\u5f0f\ndf&#91;'order_date'] = pd.to_datetime(df&#91;'order_date'])\n\n# \u63d0\u53d6\u5e74\u3001\u6708\ndf&#91;'year_month'] = df&#91;'order_date'].dt.to_period('M')\n\n# \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\nmonthly_sales = df.groupby('year_month').agg({\n    'amount': 'sum',\n    'order_id': 'count'\n}).reset_index()\n\nmonthly_sales.rename(columns={'amount': 'total_sales', 'order_id': 'order_count'}, inplace=True)\n\nprint(\"\\n\u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\u540e:\")\nprint(monthly_sales)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%E6%8C%89%E5%93%81%E7%B1%BB%E7%BB%9F%E8%AE%A1%E5%B9%B3%E5%9D%87%E5%94%AE%E4%BB%B7%E4%B8%8E%E9%94%80%E9%87%8F\"><\/span>2. \u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\ncategory_stats = df.groupby('category_code').agg({\n    'amount': 'mean',\n    'quantity': 'sum'\n}).reset_index()\n\ncategory_stats.rename(columns={'amount': 'avg_sale_price', 'quantity': 'total_quantity_sold'}, inplace=True)\n\nprint(\"\\n\u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\u540e:\")\nprint(category_stats)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_%E6%8C%89%E5%9C%B0%E5%8C%BA%E6%B1%87%E6%80%BB%E9%94%80%E5%94%AE%E9%A2%9D%E5%8D%A0%E6%AF%94\"><\/span>3. \u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\nregion_sales = df.groupby('region')&#91;'amount'].sum().reset_index()\n\n# \u8ba1\u7b97\u9500\u552e\u989d\u5360\u6bd4\nregion_sales&#91;'sales_percentage'] = (region_sales&#91;'amount'] \/ region_sales&#91;'amount'].sum()) * 100\n\nprint(\"\\n\u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4\u540e:\")\nprint(region_sales)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_%E6%8C%89%E7%94%A8%E6%88%B7%E5%88%86%E5%B1%82%EF%BC%88VIP%E6%99%AE%E9%80%9A%EF%BC%89%E7%BB%9F%E8%AE%A1%E8%B4%AD%E4%B9%B0%E5%8A%9B\"><\/span>4. \u6309\u7528\u6237\u5206\u5c42\uff08VIP\/\u666e\u901a\uff09\u7edf\u8ba1\u8d2d\u4e70\u529b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u7528\u6237\u5206\u5c42\u7edf\u8ba1\u8d2d\u4e70\u529b\nuser_purchase_power = df.groupby('membership_level')&#91;'amount'].sum().reset_index()\n\nprint(\"\\n\u6309\u7528\u6237\u5206\u5c42\u7edf\u8ba1\u8d2d\u4e70\u529b\u540e:\")\nprint(user_purchase_power)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_%E6%8C%89%E6%B8%A0%E9%81%93%E7%BB%9F%E8%AE%A1%E8%BD%AC%E5%8C%96%E7%8E%87%E4%B8%8E%E5%AE%A2%E5%8D%95%E4%BB%B7\"><\/span>5. \u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5047\u8bbe\u6211\u4eec\u8fd8\u6709\u4e00\u4e2a\u8bbf\u95ee\u8bb0\u5f55\u7684DataFrame\uff0c\u7528\u4e8e\u8ba1\u7b97\u8f6c\u5316\u7387\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u521b\u5efa\u8bbf\u95ee\u8bb0\u5f55\u7684DataFrame\nvisit_data = {\n    'customer_id': &#91;101, 102, 103, 104, 105, 106, 107, 108, 101, 102, 103, 104, 105, 106, 107, 108],\n    'visits': &#91;10, 20, 15, 25, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80, 85],\n    'channel': &#91;'Online', 'Offline', 'Online', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online']\n}\ndf_visits = pd.DataFrame(visit_data)\n\n# \u5408\u5e76\u8ba2\u5355\u548c\u8bbf\u95ee\u6570\u636e\nmerged_df = pd.merge(df, df_visits, on=&#91;'customer_id', 'channel'], how='right')\n\n# \u586b\u5145\u7f3a\u5931\u7684\u8ba2\u5355\u91d1\u989d\u4e3a0\nmerged_df&#91;'amount'].fillna(0, inplace=True)\n\n# \u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7\nchannel_stats = merged_df.groupby('channel').agg({\n    'amount': 'sum',\n    'visits': 'sum',\n    'order_id': 'count'\n}).reset_index()\n\nchannel_stats&#91;'conversion_rate'] = (channel_stats&#91;'order_id'] \/ channel_stats&#91;'visits']) * 100\nchannel_stats&#91;'average_order_value'] = channel_stats&#91;'amount'] \/ channel_stats&#91;'order_id']\n\nprint(\"\\n\u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7\u540e:\")\nprint(channel_stats)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_%E6%8C%89%E5%B0%8F%E6%97%B6%E7%B2%92%E5%BA%A6%E7%BB%9F%E8%AE%A1%E8%AE%BF%E9%97%AE%E4%B8%8B%E5%8D%95%E9%AB%98%E5%B3%B0\"><\/span>6. \u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5047\u8bbe\u6211\u4eec\u5df2\u7ecf\u6709\u4e86\u5408\u5e76\u540e\u7684\u8ba2\u5355\u548c\u8bbf\u95ee\u6570\u636e\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0\nhourly_peak = merged_df.groupby('hour').agg({\n    'amount': 'sum',\n    'visits': 'sum',\n    'order_id': 'count'\n}).reset_index()\n\nhourly_peak.rename(columns={'amount': 'total_sales', 'visits': 'total_visits', 'order_id': 'order_count'}, inplace=True)\n\nprint(\"\\n\u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0\u540e:\")\nprint(hourly_peak)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_%E6%8C%89SKU%E7%BB%9F%E8%AE%A1%E5%BA%93%E5%AD%98%E5%91%A8%E8%BD%AC%E5%A4%A9%E6%95%B0\"><\/span>7. \u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570\nsku_inventory = df.groupby('product_id')&#91;'inventory_days'].mean().reset_index()\n\nprint(\"\\n\u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570\u540e:\")\nprint(sku_inventory)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_%E6%8C%89%E4%BF%83%E9%94%80%E6%B4%BB%E5%8A%A8%E7%BB%9F%E8%AE%A1%E5%8F%82%E4%B8%8E%E4%BA%BA%E6%95%B0%E4%B8%8E%E6%88%90%E4%BA%A4%E9%A2%9D\"><\/span>8. \u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d\npromotion_stats = df.groupby('promotion').agg({\n    'customer_id': 'nunique',\n    'amount': 'sum'\n}).reset_index()\n\npromotion_stats.rename(columns={'customer_id': 'participant_count', 'amount': 'total_sales'}, inplace=True)\n\nprint(\"\\n\u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d\u540e:\")\nprint(promotion_stats)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9_%E6%8C%89%E5%93%81%E7%89%8C%E7%BB%9F%E8%AE%A1%E5%B8%82%E5%9C%BA%E4%BB%BD%E9%A2%9D%E5%8F%98%E5%8C%96\"><\/span>9. \u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316\nbrand_share = df.groupby('brand')&#91;'amount'].sum().reset_index()\n\n# \u8ba1\u7b97\u5e02\u573a\u4efd\u989d\nbrand_share&#91;'market_share'] = (brand_share&#91;'amount'] \/ brand_share&#91;'amount'].sum()) * 100\n\nprint(\"\\n\u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316\u540e:\")\nprint(brand_share)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10_%E6%8C%89%E4%BC%9A%E5%91%98%E7%AD%89%E7%BA%A7%E7%BB%9F%E8%AE%A1%E5%A4%8D%E8%B4%AD%E7%8E%87\"><\/span>10. \u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387\nrepurchase_rate = df.groupby(&#91;'customer_id', 'membership_level']).size().ge(2).groupby('membership_level').mean().reset_index()\n\nrepurchase_rate.rename(columns={0: 'repurchase_rate'}, inplace=True)\n\nprint(\"\\n\u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387\u540e:\")\nprint(repurchase_rate)<\/code><\/pre>\n\n\n\n<p>\u7efc\u5408\u4ee5\u4e0a\u6b65\u9aa4\uff0c\u6700\u7ec8\u7684\u805a\u5408\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u8fd9\u6bb5\u4ee3\u7801\u5c55\u793a\u4e86\u4ece\u539f\u59cb\u6570\u636e\u5230\u7ecf\u8fc7\u5168\u9762\u805a\u5408\u7684\u6570\u636e\u7684\u8fc7\u7a0b\u3002\u4f60\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u9700\u6c42\u8c03\u6574\u6bcf\u4e00\u6b65\u7684\u64cd\u4f5c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\r\nimport numpy as np\r\n\r\n# \u521b\u5efa\u793a\u4f8bDataFrame\r\ndata = {\r\n    'order_id': &#91;1, 2, 3, 4, 5, 6, 7, 8, 9, 10],\r\n    'product_id': &#91;'A001', 'B002', 'D004', 'E005', 'F006', 'G007', 'H008', 'I009', 'J010', 'K011'],\r\n    'category_code': &#91;'C1', 'C2', 'C1', 'C3', 'C4', 'C5', 'C6', 'C7', 'C1', 'C2'],\r\n    'amount': &#91;100.00, 200.00, 300.00, 400.00, 500.00, 600.00, 700.00, 800.00, 900.00, 1000.00],\r\n    'original_price': &#91;120.00, 220.00, 320.00, 420.00, 520.00, 620.00, 720.00, 820.00, 920.00, 1020.00],\r\n    'quantity': &#91;1, 2, 1, 1, 2, 1, 1, 2, 1, 2],\r\n    'order_date': &#91;\r\n        '2025-06-01 10:00:00', '2025-06-01 12:00:00', '2025-06-02 14:00:00',\r\n        '2025-06-03 16:00:00', '2025-06-04 18:00:00', '2025-06-05 20:00:00',\r\n        '2025-06-06 22:00:00', '2025-06-07 10:00:00', '2025-06-08 12:00:00',\r\n        '2025-06-09 14:00:00'\r\n    ],\r\n    'customer_id': &#91;101, 102, 103, 104, 105, 106, 107, 108, 101, 102],\r\n    'promotion': &#91;False, True, False, True, False, True, False, True, False, True],\r\n    'region': &#91;'Beijing', 'Shanghai', 'Guangzhou', 'Shenzhen', 'Hangzhou', 'Chengdu', 'Nanjing', 'Wuhan', 'Beijing', 'Shanghai'],\r\n    'channel': &#91;'Online', 'Offline', 'Online', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online'],\r\n    'hour': &#91;10, 12, 14, 16, 18, 20, 22, 10, 12, 14],\r\n    'brand': &#91;'BrandA', 'BrandB', 'BrandA', 'BrandC', 'BrandB', 'BrandD', 'BrandA', 'BrandC', 'BrandB', 'BrandD'],\r\n    'inventory_days': &#91;30, 45, 30, 60, 45, 60, 30, 60, 45, 60],\r\n    'membership_level': &#91;'VIP', 'Normal', 'Normal', 'VIP', 'Normal', 'Normal', 'VIP', 'Normal', 'VIP', 'Normal']\r\n}\r\n\r\ndf = pd.DataFrame(data)\r\n\r\n# \u8f6c\u6362order_date\u4e3a\u65e5\u671f\u683c\u5f0f\r\ndf&#91;'order_date'] = pd.to_datetime(df&#91;'order_date'])\r\n\r\n# \u63d0\u53d6\u5e74\u3001\u6708\r\ndf&#91;'year_month'] = df&#91;'order_date'].dt.to_period('M')\r\n\r\n# \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\r\nmonthly_sales = df.groupby('year_month').agg({\r\n    'amount': 'sum',\r\n    'order_id': 'count'\r\n}).reset_index()\r\n\r\nmonthly_sales.rename(columns={'amount': 'total_sales', 'order_id': 'order_count'}, inplace=True)\r\n\r\n# \u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\r\ncategory_stats = df.groupby('category_code').agg({\r\n    'amount': 'mean',\r\n    'quantity': 'sum'\r\n}).reset_index()\r\n\r\ncategory_stats.rename(columns={'amount': 'avg_sale_price', 'quantity': 'total_quantity_sold'}, inplace=True)\r\n\r\n# \u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4\r\nregion_sales = df.groupby('region')&#91;'amount'].sum().reset_index()\r\nregion_sales&#91;'sales_percentage'] = (region_sales&#91;'amount'] \/ region_sales&#91;'amount'].sum()) * 100\r\n\r\n# \u6309\u7528\u6237\u5206\u5c42\u7edf\u8ba1\u8d2d\u4e70\u529b\r\nuser_purchase_power = df.groupby('membership_level')&#91;'amount'].sum().reset_index()\r\n\r\n# \u521b\u5efa\u8bbf\u95ee\u8bb0\u5f55\u7684DataFrame\r\nvisit_data = {\r\n    'customer_id': &#91;101, 102, 103, 104, 105, 106, 107, 108, 101, 102, 103, 104, 105, 106, 107, 108],\r\n    'visits': &#91;10, 20, 15, 25, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80, 85],\r\n    'channel': &#91;'Online', 'Offline', 'Online', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online', 'Offline', 'Online']\r\n}\r\ndf_visits = pd.DataFrame(visit_data)\r\n\r\n# \u5408\u5e76\u8ba2\u5355\u548c\u8bbf\u95ee\u6570\u636e\r\nmerged_df = pd.merge(df, df_visits, on=&#91;'customer_id', 'channel'], how='right')\r\nmerged_df&#91;'amount'].fillna(0, inplace=True)\r\n\r\n# \u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7\r\nchannel_stats = merged_df.groupby('channel').agg({\r\n    'amount': 'sum',\r\n    'visits': 'sum',\r\n    'order_id': 'count'\r\n}).reset_index()\r\n\r\nchannel_stats&#91;'conversion_rate'] = (channel_stats&#91;'order_id'] \/ channel_stats&#91;'visits']) * 100\r\nchannel_stats&#91;'average_order_value'] = channel_stats&#91;'amount'] \/ channel_stats&#91;'order_id']\r\n\r\n# \u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0\r\nhourly_peak = merged_df.groupby('hour').agg({\r\n    'amount': 'sum',\r\n    'visits': 'sum',\r\n    'order_id': 'count'\r\n}).reset_index()\r\n\r\nhourly_peak.rename(columns={'amount': 'total_sales', 'visits': 'total_visits', 'order_id': 'order_count'}, inplace=True)\r\n\r\n# \u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570\r\nsku_inventory = df.groupby('product_id')&#91;'inventory_days'].mean().reset_index()\r\n\r\n# \u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d\r\npromotion_stats = df.groupby('promotion').agg({\r\n    'customer_id': 'nunique',\r\n    'amount': 'sum'\r\n}).reset_index()\r\n\r\npromotion_stats.rename(columns={'customer_id': 'participant_count', 'amount': 'total_sales'}, inplace=True)\r\n\r\n# \u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316\r\nbrand_share = df.groupby('brand')&#91;'amount'].sum().reset_index()\r\nbrand_share&#91;'market_share'] = (brand_share&#91;'amount'] \/ brand_share&#91;'amount'].sum()) * 100\r\n\r\n# \u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387\r\nrepurchase_rate = df.groupby(&#91;'customer_id', 'membership_level']).size().ge(2).groupby('membership_level').mean().reset_index()\r\nrepurchase_rate.rename(columns={0: 'repurchase_rate'}, inplace=True)\r\n\r\nprint(\"\u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\u540e:\")\r\nprint(monthly_sales)\r\nprint(\"\\n\u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\u540e:\")\r\nprint(category_stats)\r\nprint(\"\\n\u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4\u540e:\")\r\nprint(region_sales)\r\nprint(\"\\n\u6309\u7528\u6237\u5206\u5c42\u7edf\u8ba1\u8d2d\u4e70\u529b\u540e:\")\r\nprint(user_purchase_power)\r\nprint(\"\\n\u6309\u6e20\u9053\u7edf\u8ba1\u8f6c\u5316\u7387\u4e0e\u5ba2\u5355\u4ef7\u540e:\")\r\nprint(channel_stats)\r\nprint(\"\\n\u6309\u5c0f\u65f6\u7c92\u5ea6\u7edf\u8ba1\u8bbf\u95ee\/\u4e0b\u5355\u9ad8\u5cf0\u540e:\")\r\nprint(hourly_peak)\r\nprint(\"\\n\u6309SKU\u7edf\u8ba1\u5e93\u5b58\u5468\u8f6c\u5929\u6570\u540e:\")\r\nprint(sku_inventory)\r\nprint(\"\\n\u6309\u4fc3\u9500\u6d3b\u52a8\u7edf\u8ba1\u53c2\u4e0e\u4eba\u6570\u4e0e\u6210\u4ea4\u989d\u540e:\")\r\nprint(promotion_stats)\r\nprint(\"\\n\u6309\u54c1\u724c\u7edf\u8ba1\u5e02\u573a\u4efd\u989d\u53d8\u5316\u540e:\")\r\nprint(brand_share)\r\nprint(\"\\n\u6309\u4f1a\u5458\u7b49\u7ea7\u7edf\u8ba1\u590d\u8d2d\u7387\u540e:\")\r\nprint(repurchase_rate)\r\n\r\n\r\n\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5e38\u89c1\u7528\u7684\u6570\u636e\u805a\u5408\u573a\u666f\uff1a \u6309\u6708\u4efd\u7edf\u8ba1\u9500\u552e\u989d\u4e0e\u8ba2\u5355\u91cf\u6309\u54c1\u7c7b\u7edf\u8ba1\u5e73\u5747\u552e\u4ef7\u4e0e\u9500\u91cf\u6309\u5730\u533a\u6c47\u603b\u9500\u552e\u989d\u5360\u6bd4\u6309\u7528\u6237\u5206&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2025\/06\/28\/%e3%80%90python%e5%ae%9e%e8%b7%b5%e7%bb%8f%e9%aa%8c%e3%80%91%e7%94%b5%e5%95%86%e5%b9%b3%e5%8f%b0%e9%94%80%e5%94%ae%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%ae%9e%e8%b7%b5%e5%88%86%e8%a7%a3-2\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">\u3010Python10\u5e74\u7ecf\u9a8c\u603b\u7ed3\u3011\u7b2c\u56db\u8bfe \u7535\u5546\u5e73\u53f0\u9500\u552e\u6570\u636e\u5206\u6790\u5b9e\u8df5\u5206\u89e3 \u2013\u00a0\u6570\u636e\u805a\u5408\uff08Data Aggregation\uff09<\/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":748,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/3540"}],"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=3540"}],"version-history":[{"count":2,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/3540\/revisions"}],"predecessor-version":[{"id":3562,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/3540\/revisions\/3562"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=3540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=3540"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=3540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}