{"id":687,"date":"2021-01-13T19:51:47","date_gmt":"2021-01-13T11:51:47","guid":{"rendered":"https:\/\/yc-note.com\/?p=687"},"modified":"2021-01-14T11:34:41","modified_gmt":"2021-01-14T03:34:41","slug":"python-pandas-2","status":"publish","type":"post","link":"https:\/\/yc-note.com\/python\/python-pandas-2\/","title":{"rendered":"\u7406\u8ca1\u5c0f\u7a0b\u5f0f\u52d5\u624b\u5beb\uff01\u7528Python Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\uff5c\u3010Python\u7df4\u7fd2Day18\u3011"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"2240\" height=\"1260\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1.jpg\" alt=\"\" class=\"wp-image-688\" srcset=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1.jpg 2240w, https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1-768x432.jpg 768w, https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1-1536x864.jpg 1536w, https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1-2048x1152.jpg 2048w, https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/Python-1-1600x900.jpg 1600w\" sizes=\"(max-width: 2240px) 100vw, 2240px\" title=\"\"><\/figure>\n\n\n\n<p>\u9019\u500b\u7df4\u7fd2\u4f86\u81ea&lt;<a href=\"https:\/\/track.twshop4coupon.com\/track\/clicks\/4850\/c627c2bf9b0628dcfc88ec35dc2e9753743940c172e5e7e25826bf016f015f?t=https%3A%2F%2Fhahow.in%2Fcourses%2F5a2170d5a6d4a5001ec3148d%2Fmain\" class=\"rank-math-link\" target=\"_blank\" rel=\"noopener\">\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565<\/a>>\u7684\u7b2c\u4e00\u500b\u4f5c\u696d\uff1a\u5229\u7528<a href=\"https:\/\/yc-note.com\/python\/python-pandas\/\" class=\"rank-math-link\">Python Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda<\/a>\uff0c\u6211\u6709\u628a\u8001\u5e2b\u7684Demo\u7a0d\u5fae\u4fee\u6539\u7a0b\u5f0f\u9806\u5e8f\uff0c\u8b93\u81ea\u5df1\u5728\u4f7f\u7528\u4e0a\u66f4\u9806\u624b\u3002<\/p>\n\n\n\n<p>\u9019\u7bc7\u540c\u6642\u6703\u7528\u5230Pandas\u3001\u51fd\u5f0f\u3001\u8ff4\u5708\u7b49\u7b49\u6982\u5ff5\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_52 counter-hierarchy ez-toc-counter ez-toc-black ez-toc-container-direction\">\n<p class=\"ez-toc-title\">\u672c\u7bc7\u6587\u7ae0\u5167\u5bb9<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-650c04b979e0c\"><span class=\"\"><span 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><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-650c04b979e0c\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E8%AA%B2%E7%A8%8B%E4%BB%8B%E7%B4%B9%EF%BC%9A%E7%94%A8_Python_%E7%90%86%E8%B2%A1%EF%BC%9A%E6%89%93%E9%80%A0%E5%B0%8F%E8%B3%87%E6%97%8F%E9%81%B8%E8%82%A1%E7%AD%96%E7%95%A5\" title=\"\u8ab2\u7a0b\u4ecb\u7d39\uff1a\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565\">\u8ab2\u7a0b\u4ecb\u7d39\uff1a\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E9%A0%90%E6%B8%AC%E4%BA%BA%E7%94%9F%E8%B2%A1%E5%8B%99%E6%9B%B2%E7%B7%9A%E5%B0%8F%E7%A8%8B%E5%BC%8F\" title=\"\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\u5c0f\u7a0b\u5f0f\">\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\u5c0f\u7a0b\u5f0f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E7%B7%B4%E7%BF%92%EF%BC%9APython_Pandas%E9%A0%90%E6%B8%AC%E4%BA%BA%E7%94%9F%E8%B2%A1%E5%8B%99%E6%9B%B2%E7%B7%9A\" title=\"\u7df4\u7fd2\uff1aPython Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\">\u7df4\u7fd2\uff1aPython Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E7%A8%8B%E5%BC%8F%E8%A7%A3%E6%A7%8B\" title=\"\u7a0b\u5f0f\u89e3\u69cb\">\u7a0b\u5f0f\u89e3\u69cb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E5%88%9D%E5%A7%8B%E8%B3%87%E6%96%99%E8%A8%AD%E5%AE%9A\" title=\"\u521d\u59cb\u8cc7\u6599\u8a2d\u5b9a\">\u521d\u59cb\u8cc7\u6599\u8a2d\u5b9a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%9C%AA%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%AA%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\" title=\"\u672a\u8cb7\u623f\u3001\u672a\u6295\u8cc7\u60c5\u6cc1\">\u672a\u8cb7\u623f\u3001\u672a\u6295\u8cc7\u60c5\u6cc1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%9C%AA%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%89%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\" title=\"\u672a\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1\">\u672a\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%9C%89%E8%B2%B7%E6%88%BF%E3%80%81%E6%B2%92%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\" title=\"\u6709\u8cb7\u623f\u3001\u6c92\u6295\u8cc7\u60c5\u6cc1\">\u6709\u8cb7\u623f\u3001\u6c92\u6295\u8cc7\u60c5\u6cc1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%9C%89%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%89%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\" title=\"\u6709\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1\">\u6709\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%84%9F%E6%83%B3\" title=\"\u611f\u60f3\">\u611f\u60f3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E6%9C%AC%E6%AC%A1%E7%B7%B4%E7%BF%92%E6%AA%94%E8%88%87%E8%AA%B2%E7%A8%8B\" title=\"\u672c\u6b21\u7df4\u7fd2\u6a94\u8207\u8ab2\u7a0b\">\u672c\u6b21\u7df4\u7fd2\u6a94\u8207\u8ab2\u7a0b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/yc-note.com\/python\/python-pandas-2\/#%E3%80%90Python%E6%96%B0%E6%89%8B%E7%B7%B4%E7%BF%92%E3%80%91%E7%9B%B8%E9%97%9C%E6%96%87%E7%AB%A0\" title=\"\u3010Python\u65b0\u624b\u7df4\u7fd2\u3011\u76f8\u95dc\u6587\u7ae0\">\u3010Python\u65b0\u624b\u7df4\u7fd2\u3011\u76f8\u95dc\u6587\u7ae0<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AA%B2%E7%A8%8B%E4%BB%8B%E7%B4%B9%EF%BC%9A%E7%94%A8_Python_%E7%90%86%E8%B2%A1%EF%BC%9A%E6%89%93%E9%80%A0%E5%B0%8F%E8%B3%87%E6%97%8F%E9%81%B8%E8%82%A1%E7%AD%96%E7%95%A5\"><\/span>\u8ab2\u7a0b\u4ecb\u7d39\uff1a<a class=\"rank-math-link\" href=\"https:\/\/track.twshop4coupon.com\/track\/clicks\/4850\/c627c2bf9b0628dcfc88ec35dc2e9753743940c172e5e7e25826bf016f015f?t=https%3A%2F%2Fhahow.in%2Fcourses%2F5a2170d5a6d4a5001ec3148d%2Fmain\" target=\"_blank\" rel=\"noopener\">\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>&lt;<a href=\"https:\/\/track.twshop4coupon.com\/track\/clicks\/4850\/c627c2bf9b0628dcfc88ec35dc2e9753743940c172e5e7e25826bf016f015f?t=https%3A%2F%2Fhahow.in%2Fcourses%2F5a2170d5a6d4a5001ec3148d%2Fmain\" target=\"_blank\" rel=\"noopener\">\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565<\/a>>\u662f<a href=\"https:\/\/track.affclkr.com\/track\/clicks\/4850\/c627c2bf9b0628dcfc88ec35dc2e9753743940c172e5e7e25826bf016f015f\" class=\"rank-math-link\" target=\"_blank\" rel=\"noopener\"><strong>Hahow \u597d\u5b78\u6821<\/strong><\/a>\u4e2d\uff0c\u975e\u5e38\u71b1\u9580\u7684<strong>Python\u57fa\u790e\u8ab2\u7a0b<\/strong>\uff0c\u88e1\u9762\u9664\u4e86Python\u7684\u57fa\u790e\u6559\u5b78\u3001Pandas\u4ecb\u7d39\u3001\u7528\u6cd5\u4ee5\u5916\uff0c\u9084\u5305\u542b\u4e86\u8a31\u591a\u5c0f\u8cc7\u65cf\u61c9\u8a72\u6709\u7684\u7406\u8ca1\u89c0\u5ff5\u3002<\/p>\n\n\n\n<p>\u8001\u5e2b\u662fFinLab\u7684\u97d3\u627f\u4f51\uff0c\u6709\u8c50\u5bcc\u7684\u7a0b\u5f0f\u7d93\u9a57\uff0c\u6559\u5b78\u6df1\u5165\u6dfa\u51fa\uff0c\u7528\u8a5e\u767d\u8a71\uff0c\u5f88\u9069\u5408\u521d\u5b78\u8005\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%A0%90%E6%B8%AC%E4%BA%BA%E7%94%9F%E8%B2%A1%E5%8B%99%E6%9B%B2%E7%B7%9A%E5%B0%8F%E7%A8%8B%E5%BC%8F\"><\/span>\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\u5c0f\u7a0b\u5f0f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u9019\u500b\u5c0f\u7a0b\u5f0f\u7684\u7528\u9014\uff0c\u53ef\u4ee5\u8b93\u4f7f\u7528\u8005\u8f38\u5165\u57fa\u672c\u7684\u8ca1\u52d9\u8cc7\u6599\u5f8c\uff0c\u53bb\u8a08\u7b97\u5728\u4eba\u751f\u968e\u6bb5\u4e2d\uff0c\u6709\u7121\u6295\u8cc7\u3001\u6709\u7121\u8cb7\u623f\u5f8c\uff0c\u5283\u51fa\u500b\u4eba\u7684\u4eba\u751f\u8ca1\u7269\u66f2\u7dda\u3002<\/p>\n\n\n\n<p>\u96d6\u7136\u4e00\u76f4\u90fd\u77e5\u9053\u300c\u8907\u5229\u300d\u7684\u5f37\u5927\uff0c\u4f46\u81ea\u5df1\u89aa\u624b\u628a\u7a0b\u5f0f\u5beb\u51fa\u4f86\u3001\u4e00\u6b65\u4e00\u6b65\u8a08\u7b97\uff0c\u4e26\u4e14\u756b\u51fa\u8ca1\u52d9\u66f2\u7dda\u5f8c\uff0c\u767c\u73fe\u843d\u5dee\u771f\u7684\u597d\u5927\uff0c\u52a0\u5f37\u4e86\u5c0d\u65bc\u7406\u8ca1\u7684\u6025\u8feb\u5fc3\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u5c0d\u65bcPython\u6c92\u6709\u8208\u8da3\uff0c\u53ea\u662f\u60f3\u8981\u8dd1\u8dd1\u770b\u81ea\u5df1\u7684\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\uff0c\u53ef\u4ee5\u9ede\u4e0b\u9762\u7684\u9023\u7d50\uff0c\u88e1\u9762\u6709\u6211\u5beb\u597d\u7684\u7df4\u7fd2\u6a94\uff0c\u53ef\u4ee5\u76f4\u63a5\u53d6\u7528\u3002<\/p>\n\n\n\n<p>\u7df4\u7fd2\u6a94\uff1a<a href=\"https:\/\/colab.research.google.com\/drive\/1QvFbpfwJ9LQa8jmbz_osS-m10prhnpp3?usp=sharing\" class=\"rank-math-link\" target=\"_blank\" rel=\"noopener\">Day18(1\/11)\u5229\u7528Python Pandas\u9810\u6e2c\u500b\u4eba\u8ca1\u52d9\u66f2\u7dda<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"re\">\u4f7f\u7528\u65b9\u6cd5<\/h4>\n\n\n\n<ol><li>\u6253\u958b\u7df4\u7fd2\u6a94<\/li><li>\u8f38\u5165\u53f3\u624b\u908a\u7684\u521d\u59cb\u5316\u8cc7\u6599\u5de6\u908a\u6709\u5099\u8a3b\u53ef\u4ee5\u53c3\u8003<\/li><li>\u9078\u64c7\u9078\u55ae\u4e0a\u65b9\u7684\u300c\u57f7\u884c\u968e\u6bb5\uff3d\uff0c\u4e0b\u62c9\u5f8c\u9078\u64c7\u300c\u5168\u90e8\u57f7\u884c\u300d\u3002<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1362\" height=\"650\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/1610448140226.jpg\" alt=\"\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565 - \u7dda\u4e0a\u6559\u5b78\u8ab2\u7a0b - Hahow \u597d\u5b78\u6821\" class=\"wp-image-705\" srcset=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/1610448140226.jpg 1362w, https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/1610448140226-768x367.jpg 768w\" sizes=\"(max-width: 1362px) 100vw, 1362px\" title=\"\"><figcaption>\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565 &#8211; \u7dda\u4e0a\u6559\u5b78\u8ab2\u7a0b &#8211; Hahow \u597d\u5b78\u6821<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"re\">\u57f7\u884c\u7d50\u679c<\/h4>\n\n\n\n<p>\u6309\u4e0b\u57f7\u884c\u5f8c\uff0c\u7a0b\u5f0f\u6703\u958b\u59cb\u9023\u7dda\u3001\u4e26\u4e14\u4f9d\u64da\u57f7\u884c\u7a0b\u5f0f\u7247\u6bb5\uff0c\u6700\u5f8c\u62c9\u5230\u5e95\u4e0b\u5c31\u53ef\u4ee5\u770b\u5230\u66f2\u7dda\u5716\u548c90\u6b72\u6642\u7684\u91d1\u984d\u4e86\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"465\" height=\"297\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-13.png\" alt=\"\" class=\"wp-image-707\" title=\"\"><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%B7%B4%E7%BF%92%EF%BC%9APython_Pandas%E9%A0%90%E6%B8%AC%E4%BA%BA%E7%94%9F%E8%B2%A1%E5%8B%99%E6%9B%B2%E7%B7%9A\"><\/span>\u7df4\u7fd2\uff1aPython Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A8%8B%E5%BC%8F%E8%A7%A3%E6%A7%8B\"><\/span>\u7a0b\u5f0f\u89e3\u69cb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u9019\u500b\u7df4\u7fd2\u5f71\u7247\u6211\u91cd\u8907\u770b\u4e86\u5169\u6b21\uff0c\u4e00\u6b21\u662f\u7528\u901a\u52e4\u6642\u9593\uff0c\u5148\u7528\u300c\u770b\u300d\u7684\u65b9\u5f0f\uff0c\u7406\u89e3\u8001\u5e2b\u5728\u5f71\u7247\u5167\u7684\u908f\u8f2f\uff0c\u7b2c\u4e8c\u6b21\u624d\u8ddf\u8457\u6253\uff0c\u96e3\u6613\u5ea6\u4e0d\u9ad8\uff0c\u4f46\u9700\u8981\u4e00\u9ede\u7d30\u5fc3\u3002<\/p>\n\n\n\n<p>\u53e6\u5916\u56e0\u70ba\u4e2d\u6587\u8981\u4e00\u76f4\u63db\u8f38\u5165\u6cd5\uff0c\u6211\u628a<strong>\u8b8a\u6578\u540d\u7a31\u90fd\u6539\u6210\u82f1\u6587<\/strong>\u4e86\u3002<\/p>\n\n\n\n<ol><li>\u8a08\u7b97\u6bcf\u5e74\u7684\u6de8\u503c\uff1a\u6708\u85aa\u6263\u6389\u6bcf\u6708\u958b\u92b7*12<\/li><li>\u52a0\u7e3d\u5f8c\u53ef\u4ee5\u5f97\u5230\u300c\u672a\u8cb7\u623f\u3001\u672a\u6295\u8cc7\u300d\u7684\u4eba\u751f\u8ca1\u52d9\u7d50\u679c<\/li><li>\u8a08\u7b97\u6709\u6295\u8cc7\u7684\u60c5\u6cc1\uff1a\u5c07\u6de8\u503c\u6309\u7167\u6295\u8cc7\u6bd4\u4f8b\u3001\u9810\u4f30\u6295\u8cc7\u5831\u916c\u7387\uff0c\u8907\u5229\u52a0\u7e3d<\/li><li>\u8cb7\u623f\uff1a\u8a08\u7b97\u8cb7\u623f\u6210\u672c\u3001\u5229\u606f<\/li><li>\u623f\u79df\uff1a\u8cb7\u623f\u524d\u7684\u623f\u79df\u7e3d\u548c(\u623f\u79df*12*\u8cb7\u623f\u524d\u7684\u5e74\u6578)<\/li><li>\u8a08\u7b97\u8cb7\u623f\u5f8c\u6301\u7e8c\u6295\u8cc7\u7684\u60c5\u6cc1\uff1a\u7528\u540c\u6a23\u7684\u51fd\u5f0f\uff0c\u628a\u8cb7\u623f\u5f8c\u7684\u6de8\u984d\u505a\u6295\u8cc7\u8907\u5229\u8a08\u7b97<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9D%E5%A7%8B%E8%B3%87%E6%96%99%E8%A8%AD%E5%AE%9A\"><\/span>\u521d\u59cb\u8cc7\u6599\u8a2d\u5b9a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u9019\u88e1\u6a21\u64ec\u4e00\u500b29\u6b72\uff0c\u5de5\u4f5c\u5927\u7d04\u4e94\u5e74\u7684\u9752\u5e74\uff0c\u85aa\u6c3465K\u3001\u623f\u79df10K\u3001\u65e5\u5e38\u958b\u92b725K\uff0c\u4e26\u4ee5\u5b58\u5230100\u842c\u7576\u982d\u671f\u6b3e\uff0c\u5e0c\u671b30\u6b72\u8cb7\u623f\u70ba\u80cc\u666f\u3002<\/p>\n\n\n\n<p>\u8a08\u7b97\u6bcf\u5e74\u62ff\u6de8\u503c6\u6210\u505a\u6295\u8cc7\uff0c\u6295\u58315%\uff0c60\u6b72\u9000\u4f11\uff0c\u4e26\u4e14\u6d3b\u523090\u6b72\u4f86\u8a08\u7b97\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;#@title\\u00a0\\u8a2d\\u5b9a\\u521d\\u59cb\\u8cc7\\u6599&lt;br&gt;&lt;br&gt;#\\u521d\\u59cb\\u8cc7\\u6599(\\u55ae\\u4f4d\/\\u842c)&lt;br&gt;start_m\\u00a0=\\u00a0100\\u00a0#@param\\u00a0#\\u521d\\u59cb\\u5316\\u8cc7\\u91d1&lt;br&gt;monthly=6.5\\u00a0#@param\\u00a0#\\u6708\\u85aa&lt;br&gt;cost=2.5\\u00a0\\u00a0#@param\\u00a0\\u00a0#\\u6bcf\\u6708\\u82b1\\u8cbb(\\u4e0d\\u542b\\u623f\\u79df\\uff0c\\u5403\\u559d)&lt;br&gt;rent=1\\u00a0#@param\\u00a0#\\u623f\\u79df&lt;br&gt;rest_age=60\\u00a0#@param\\u00a0\\u00a0#\\u9000\\u4f11\\u5e74\\u9f61&lt;br&gt;time=range(29,90,1)\\u00a0#@param\\u00a0#\\u89c0\\u6e2c29-90\\u6b72&lt;br&gt;&lt;br&gt;#\\u6295\\u8cc7\\u8cc7\\u6599&lt;br&gt;inv_p=0.6\\u00a0#@param\\u00a0#\\u6295\\u8cc7\\u5360\\u6bd4&lt;br&gt;inv_year=1.05\\u00a0#@param\\u00a0\\u00a0#\\u6295\\u8cc7\\u5e74\\u5229\\u7387&lt;br&gt;&lt;br&gt;#\\u8cb7\\u623f\\u8cc7\\u6599&lt;br&gt;house_total=880\\u00a0#@param\\u00a0\\u00a0#\\u623f\\u5b50\\u7e3d\\u50f9&lt;br&gt;house_down=\\u00a0100\\u00a0#@param\\u00a0\\u00a0#\\u982d\\u671f\\u6b3e&lt;br&gt;buyhouse_age=30\\u00a0#@param\\u00a0\\u00a0#\\u8cb7\\u623f\\u5e74\\u7d00&lt;br&gt;house_int=1.31#@param\\u00a0\\u00a0\\u00a0#\\u5229\\u7387&lt;br&gt;house_year=30\\u00a0#@param\\u00a0\\u00a0#\\u8cb8\\u6b3e\\u5e74Python&quot;,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">#\u521d\u59cb\u8cc7\u6599(\u55ae\u4f4d\/\u842c)\nstart_m = 100  #\u521d\u59cb\u5316\u8cc7\u91d1\nmonthly=6.5 #\u6708\u85aa\ncost=2.5    #\u6bcf\u6708\u82b1\u8cbb(\u4e0d\u542b\u623f\u79df\uff0c\u5403\u559d)\nrent=1  #\u623f\u79df\nrest_age=60   #\u9000\u4f11\u5e74\u9f61\ntime=range(29,90,1) #@param #\u89c0\u6e2c29-90\u6b72\n\n#\u6295\u8cc7\u8cc7\u6599\ninv_p=0.6 #@param #\u6295\u8cc7\u5360\u6bd4\ninv_year=1.05 #@param  #\u6295\u8cc7\u5e74\u5229\u7387\n\n#\u8cb7\u623f\u8cc7\u6599\nhouse_total=880 #@param  #\u623f\u5b50\u7e3d\u50f9\nhouse_down= 100 #@param  #\u982d\u671f\u6b3e\nbuyhouse_age=30 #@param  #\u8cb7\u623f\u5e74\u7d00\nhouse_int=1.31#@param   #\u5229\u7387\nhouse_year=30 #@param  #\u8cb8\u6b3e\u5e74<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%AA%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%AA%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\"><\/span>\u672a\u8cb7\u623f\u3001\u672a\u6295\u8cc7\u60c5\u6cc1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7b97\u51fa\u6bcf\u5e74\u7684\u8ca1\u7522\u6de8\u984d\uff3b\u85aa\u6c34\uff0d\u958b\u92b7\uff3d\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;year_m=pd.Series(0,index=time)&lt;br&gt;year_m.iloc[0]=start_m\\u00a0#\\u7b2c\\u4e00\\u500b\\u6578\\u5b57\\u653e\\u5165\\u521d\\u59cb\\u8cc7\\u91d1&lt;br&gt;year_m.loc[:rest_age]+=monthly*12&lt;br&gt;year_m-=(cost+rent)*12Python&quot;,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">year_m=pd.Series(0,index=time)\nyear_m.iloc[0]=start_m #\u7b2c\u4e00\u500b\u6578\u5b57\u653e\u5165\u521d\u59cb\u8cc7\u91d1\nyear_m.loc[:rest_age]+=monthly*12\nyear_m-=(cost+rent)*12<\/pre><\/div>\n\n\n\n<p>\u9019\u88e1\u53ef\u4ee5\u770b\u5230\uff0c\u6bcf\u5e74\u7684\u6de8\u984d\u572829\u6b72\u6642\uff0c\u6709\u521d\u59cb\u5316\u7684\u5b58\u6b3e\uff0c\u63a5\u8457\u6bcf\u5e74\u7684\u6de8\u503c\u90fd\u76f8\u540c\uff0c\u4f46\u662f\u523060\u6b72(\u9000\u4f11\u5f8c)\u6703\u8b8a\u6210\u8ca0\u7684\uff0c\u56e0\u70ba\u6c92\u6709\u6536\u5165\u4e86\uff01\u958b\u92b7\u8b8a\u6210\u5403\u8001\u672c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"377\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-14.png\" alt=\"\" class=\"wp-image-708\" title=\"\"><\/figure>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">#\u7121\u6295\u8cc7\u7e3d\u8cc7\u7522\nno_house_m=year_m.cumsum()\nno_house_m.plot()<\/pre><\/div>\n\n\n\n<p>\u56e0\u6b64\uff0c\u5728\u6c92\u6709\u6295\u8cc7\u3001\u6c92\u6709\u8cb7\u623f\u7684\u60c5\u6cc1\u4e0b\uff0c\u4eba\u751f\u7684\u8ca1\u52d9\u66f2\u7dda\u5982\u4e0b\uff0c\u96d6\u713630-60\u6b72\u4e0d\u65b7\u6210\u9577(\u4e0d\u505c\u5132\u84c4\uff0c\u9019\u88e1\u5ffd\u7565\u6d3b\u5b58\u5229\u7387)\uff0c\u4f4660\u6b72\u958b\u59cb\u6d88\u8017\u5b58\u6b3e\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"381\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-15.png\" alt=\"\" class=\"wp-image-709\" title=\"\"><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%AA%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%89%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\"><\/span>\u672a\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8a08\u7b97\u6295\u8cc7\uff0c\u9019\u908a\u8001\u5e2b\u7528\u4e86\u4e00\u500b\u51fd\u5f0f\uff0c\u5305\u542b\u8907\u5229\u7684\u8a08\u7b97\u548c\u8ff4\u5708\uff0c\u5c07\u7d50\u679c\u4e00\u500b\u4e00\u500b\u50b3\u56de\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">def compound_inv(arr,inv_p,inv_year):\n  ret=[arr.iloc[0]] #\u5b9a\u7fa9\u4e00\u958b\u59cb\u7684\u9918\u984d(\u7b2c\u4e00\u5e74)\u8d77\u59cb\u91d1\u984d+\u5e74\u6de8\u984d\n  for v in arr[1:]: #\u5f9e\u7b2c\u4e00\u5e74\u958b\u59cb\u53d6\u6578\u5b57\uff0c\u5230\u7d50\u675f\n    ret.append(ret[-1]*inv_p*inv_year+ret[-1]*(1-inv_p)+v) #\u8ff4\u5708\u52a0\u7e3d(\u6de8\u503c*\u6295\u8cc7\u6bd4\u4f8b*)\n  return pd.Series(ret,time)  \n\nint_m=compound_inv(year_m,inv_p,inv_year) \nint_m.plot() #\u6709\u6295\u8cc7\u7121\u623f\u7684\u60c5\u6cc1\nno_house_m.plot() #\u7121\u6295\u8cc7\u7e3d\u8cc7\u7522<\/pre><\/div>\n\n\n\n<p>\u7d50\u679c\u5c31\u662f\uff0c30-60\u6b72\u958b\u59cb\u6295\u8cc7\uff0c\u4eba\u751f\u8ca1\u52d9\u6703\u7a69\u5b9a\u6309\u7167\u8907\u5229\u7684\u659c\u7387\u6210\u9577\uff0c\u5230\u4e8660\u6b72\u5f8c\uff0c\u6c92\u6709\u5de5\u4f5c\u85aa\u8cc7\u6536\u5165\uff0c\u4f46\u6295\u8cc7\u7372\u5229\u4ecd\u53ef\u4ee5\u652f\u4ed8\u958b\u92b7\u3001\u4e26\u4e14\u9084\u6709\u6de8\u984d\u7e7c\u7e8c\u6295\u8cc7(\u9322\u6efe\u9322\u7684\u6982\u5ff5)\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"381\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-16.png\" alt=\"\" class=\"wp-image-710\" title=\"\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%89%E8%B2%B7%E6%88%BF%E3%80%81%E6%B2%92%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\"><\/span>\u6709\u8cb7\u623f\u3001\u6c92\u6295\u8cc7\u60c5\u6cc1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u63a5\u8457\uff0c\u4f86\u5230<strong>\u8cb7\u623f<\/strong>\u7684\u90e8\u5206\u3002<\/p>\n\n\n\n<p>\u518d\u6c92\u6709\u5bcc\u7238\u7238\u5e6b\u52a9\u4e0b\uff0c\u7528\u5df2\u5b58\u7684100\u842c\u7576\u982d\u671f\u6b3e\uff0c\u5269\u4e0b\u7684\u6b3e\u9805\u7528\u9752\u5e74\u6210\u5bb6\u65b9\u6848(\u5229\u73871.31%)\u8a08\u7b97\u3001\u8cb8\u6b3e30\u5e74\uff0c\u8cfc\u8cb7\u65b0\u5317\u5e02\u7684\u7e3d\u50f9880\u842c\u7684\u4e2d\u53e4\u5c4b\u3002<\/p>\n\n\n\n<p>\u9996\u5148\u5148\u8a08\u7b97\u8cb7\u623f\u7684\u82b1\u8cbb\uff0c\u5efa\u7acb\u4e00\u500bSeries\uff0c\u653e\u5165\u6bcf\u5e74\u623f\u8cb8\u91d1\u984d\uff0c\u7b2c\u4e00\u5e74\u6703\u4ed8\u51fa\u982d\u671f\u6b3e100\u842c(\u6240\u4ee5\u7dda\u6700\u9ad8)\uff0c\u63a5\u8457\u662f\u6bcf\u5e74\u7684\u623f\u8cb8(\u623f\u8cb8\u9664\u4ee5\u8cb8\u6b3e\u5e74\u9650)\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">#\u8a08\u7b97\u8cb7\u623f\u82b1\u8cbb(\u4e0d\u542b\u5229\u606f)\nhouse_cost=pd.Series(0,index=time) #\u5efa\u7acb\u4e00\u500b\u6b04Series\uff0c\u653e\u6bcf\u5e74\u7684\u623f\u8cb8\u8cbb\u7528(\u672c\u91d1)\nhouse_cost[buyhouse_age]=house_down\nhouse_cost.loc[buyhouse_age:(buyhouse_age+house_year)]+=((house_total-house_down)\/house_year) #\u5f9e\u8cb7\u623f\u5e74\u958b\u59cb\uff0c\u5230\u8cb8\u6b3e\u7e73\u5b8c\u5e74\u7d00\uff1b\u653e\u5165\u7e3d\u50f9\/\u8cb8\u6b3e\u5e74\nhouse_cost.plot()<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"375\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-20.png\" alt=\"\" class=\"wp-image-721\" title=\"\"><\/figure>\n\n\n\n<p>\u63a5\u8457\u8a08\u7b97\u5be6\u969b\u7684\u501f\u6b3e\u9918\u984d\uff0c\u4e26\u4e14\u7528\u9019\u500b\u9918\u984d\u53bb\u8a08\u7b97\u6bcf\u5e74\u9700\u8981\u652f\u4ed8\u7684\u5229\u606f(\u56e0\u70ba\u5229\u606f\u6703\u8d8a\u4f86\u8d8a\u5c11)\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;need_pay=pd.Series(0,index=time)\\u00a0#\\u5efa\\u7acb\\u4e00\\u500b\\u6b04Series\\u4f86\\u653e\\u5be6\\u969b\\u6b20\\u6b3e&lt;br&gt;need_pay[buyhouse_age]=house_total\\u00a0#\\u5f9e\\u8cb7\\u623f\\u5e74\\u7d00\\u958b\\u59cb\\uff0c\\u80cc\\u623f\\u8cb8&lt;br&gt;need_pay=need_pay.cumsum()#\\u8a08\\u7b97\\u6b20\\u6b3e&lt;br&gt;need_pay=need_pay-house_cost.cumsum()\\u00a0#\\u4f9d\\u5e8f\\u6263\\u6389\\u6bcf\\u5e74\\u8cb8\\u6b3e&lt;br&gt;need_pay.plot()\\u00a0#\\u623f\\u8cb8\\u6708\\u4f86\\u8d8a\\u5c11&lt;br&gt;#print(need_pay)&lt;br&gt;&lt;br&gt;#\\u8a08\\u7b97\\u5229\\u606f&lt;br&gt;houseint=need_pay.shift().fillna(0)*house_int\/100&lt;br&gt;houseint.plot(secondary_y=True)\\u00a0#\\u6bcf\\u6708\\u5229\\u606f\\u4e5f\\u8d8a\\u4f86\\u8d8a\\u5c11Python&quot;,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">need_pay=pd.Series(0,index=time) #\u5efa\u7acb\u4e00\u500b\u6b04Series\u4f86\u653e\u5be6\u969b\u6b20\u6b3e\nneed_pay[buyhouse_age]=house_total #\u5f9e\u8cb7\u623f\u5e74\u7d00\u958b\u59cb\uff0c\u80cc\u623f\u8cb8\nneed_pay=need_pay.cumsum()#\u8a08\u7b97\u6b20\u6b3e\nneed_pay=need_pay-house_cost.cumsum() #\u4f9d\u5e8f\u6263\u6389\u6bcf\u5e74\u8cb8\u6b3e\nneed_pay.plot() #\u623f\u8cb8\u6708\u4f86\u8d8a\u5c11\n#print(need_pay)\n\n#\u8a08\u7b97\u5229\u606f\nhouseint=need_pay.shift().fillna(0)*house_int\/100\nhouseint.plot(secondary_y=True) #\u6bcf\u6708\u5229\u606f\u4e5f\u8d8a\u4f86\u8d8a\u5c11<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"394\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-21.png\" alt=\"\" class=\"wp-image-722\" title=\"\"><\/figure>\n\n\n\n<p>\u56e0\u70ba\u63a5\u4e0b\u4f86\u8981\u8a08\u7b97\u8cb7\u623f\u5f8c\u7684\u6bcf\u6708\u6de8\u984d\uff0c\u56e0\u6b64\u6263\u6389\u8cb7\u623f\u524d\u7e73\u4ea4\u7d66\u623f\u6771\u7684\u623f\u79df\uff0c\u4e26\u5728\u8cb7\u623f\u5f8c\u7684\u5e74\u7d00\u4e2d\uff0c\u90fd\u653e\u4e0a0\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;#\\u8a08\\u7b97\\u8981\\u7e73\\u7d66\\u623f\\u6771\\u5927\\u5927\\u7684\\u623f\\u79df&lt;br&gt;rent_year=pd.Series(rent*12,index=time)&lt;br&gt;rent_year.loc[buyhouse_age:]=0\\u00a0#\\u8cb7\\u623f\\u5f8c\\u90fd\\u662f0Python&quot;,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">#\u8a08\u7b97\u8981\u7e73\u7d66\u623f\u6771\u5927\u5927\u7684\u623f\u79df\nrent_year=pd.Series(rent*12,index=time)\nrent_year.loc[buyhouse_age:]=0 #\u8cb7\u623f\u5f8c\u90fd\u662f0<\/pre><\/div>\n\n\n\n<p>\u56e0\u6b64\uff0c\u6709\u8cb7\u623f\u3001\u4f46\u6c92\u6295\u8cc7\u60c5\u6cc1\u4e0b\uff0c\u500b\u4eba\u8ca1\u52d9\u66f2\u4e0b\u6703\u5982\u4e0b\u5716\uff0c\u8cb7\u623f\u524d\u6709\u521d\u59cb\u8cc7\u91d1100\u842c\uff0c\u63a5\u8457\u4ed8\u51fa\u982d\u671f\u6b3e\u3001\u958b\u59cb\u7e73\u623f\u8cb8\u3001\u540c\u6642\u589e\u52a0\u6de8\u984d\uff0c\u5230\u4e8660\u6b72\u9000\u4f11\u5f8c\uff0c\u958b\u59cb\u82b1\u904e\u53bb\u5b58\u6b3e\uff0c\u572880\u6b72\u524d\u5c31\u6703\u628a\u8001\u672c\u82b1\u5149\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"383\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-17.png\" alt=\"image-17\" class=\"wp-image-711\" title=\"\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%89%E8%B2%B7%E6%88%BF%E3%80%81%E6%9C%89%E6%8A%95%E8%B3%87%E6%83%85%E6%B3%81\"><\/span>\u6709\u8cb7\u623f\u3001\u6709\u6295\u8cc7\u60c5\u6cc1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u60f3\u8981\u8cb7\u623f\uff0c\u53c8\u4e0d\u60f3\u8001\u4e86\u8ca0\u50b5\u7684\u8a71\uff0c\u5c31\u8981\u958b\u59cb\u4e26\u671f\u6295\u8cc7\u3002<\/p>\n\n\n\n<p>\u9019\u90e8\u5206\u53ea\u8981\u628a\u525b\u525b\u8cb7\u623f\u5f8c\u7684\u6de8\u984d\uff0c\u653e\u5165\u524d\u9762\u5beb\u7684\u6295\u8cc7\u51fd\u5f0f(compound_inv)\u53bb\u8a08\u7b97\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">buyhoues_with_inv=compound_inv(buyhouse_year_m,inv_p,inv_year)<\/pre><\/div>\n\n\n\n<p>\u5728\u540c\u6a23\u62ff\u51fa\u6de8\u984d60%\u3001\u5e74\u5831\u916c\u73870.5\u60c5\u6cc1\u4e0b\uff0c\u96d6\u7136\u5b58\u6b3e\u4e0d\u5982\u6c92\u6709\u8cb7\u623f\u4e0a\u5347\u7684\u5feb(\u53ef\u652f\u914d\u6295\u8cc7\u91d1\u984d\u8f03\u5c11)\uff0c\u4f46\u9000\u4f11\u5f8c\u4ecd\u53ef\u4ee5\u7dad\u6301\u751f\u6d3b\u3001\u4eba\u751f\u5230\u76e1\u982d\u4ecd\u6709\u4e00\u7b46\u5b58\u6b3e\u5728\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"381\" height=\"252\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-18.png\" alt=\"\" class=\"wp-image-712\" title=\"\"><\/figure>\n\n\n\n<h4 class=\"re wp-block-heading\">\u5c07\u56db\u689d\u7dda\u540c\u6642\u5370\u51fa<\/h4>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">int_m.plot(color='red') #\u7d14\u6295\u8cc7\nbuyhoues_with_inv.plot(color='green') #\u6709\u623f\u6709\u6295\u8cc7\nbuyhouse_year_m.cumsum().plot(color='black') #\u6709\u623f\u6c92\u6295\u8cc7\nno_house_m.plot(color='blue') #\u6c92\u623f\u6c92\u6295\u8cc7\n\nprint(&quot;\u6240\u6709\u6de8\u984d\u62ff\u53bb\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a&quot;,round(int_m.loc[89],2),&quot;\u842c\u5143&quot;)\nprint(&quot;\u8cb7\u623f\uff0c\u5269\u4e0b\u7684\u9322\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a&quot;,round(buyhoues_with_inv.loc[89],2),&quot;\u842c\u5143&quot;)\nprint(&quot;\u8cb7\u623f\uff0c\u4f46\u4e0d\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a&quot;,round(buyhouse_year_m.cumsum()[89],2),&quot;\u842c\u5143&quot;)\nprint(&quot;\u6c92\u8cb7\u623f\uff0c\u4e5f\u4e0d\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a&quot;,round(no_house_m[89],2),&quot;\u842c\u5143&quot;)<\/pre><\/div>\n\n\n\n<p>\u628a\u56db\u689d\u4eba\u751f\u66f2\u7dda\u90fd\u5370\u51fa\uff0c\u4e26\u4e14\u7528\u4e0d\u540c\u984f\u8272\u6a19\u8a18\uff0c\u53e6\u5916\u540c\u6642\u4e5f\u7528\u5b57\u4e32\u986f\u793a\u5728\u4e0d\u540c\u60c5\u6cc1\u4e0b\uff0c90\u6b72\u6642\u7684\u5b58\u6b3e\u3002<\/p>\n\n\n\n<h4 class=\"re wp-block-heading\">\u57f7\u884c\u7d50\u679c<\/h4>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;lesser-dark&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;Python&quot;,&quot;modeName&quot;:&quot;python&quot;}\">\u6240\u6709\u6de8\u984d\u62ff\u53bb\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a 3144.11 \u842c\u5143\n\u8cb7\u623f\uff0c\u5269\u4e0b\u7684\u9322\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a 913.98 \u842c\u5143\n\u8cb7\u623f\uff0c\u4f46\u4e0d\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a -278.28 \u842c\u5143\n\u6c92\u8cb7\u623f\uff0c\u4e5f\u4e0d\u6295\u8cc7\uff0c90\u6b72\u6642\uff1a 34.0 \u842c\u5143<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"381\" height=\"248\" src=\"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/image-19.png\" alt=\"\" class=\"wp-image-713\" title=\"\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%84%9F%E6%83%B3\"><\/span>\u611f\u60f3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u9019\u500b\u8ca1\u52d9\u66f2\u7dda\uff0c\u662f\u5728\u6c92\u6709\u610f\u5916\u3001\u6c92\u6709\u5916\u529b\u56e0\u7d20\uff0c\u800c\u4e14\u81ea\u5f8b(\u5b58\u6b3e\u548c\u6295\u8cc7)\u7684\u60c5\u6cc1\u4e0b\uff0c\u5229\u7528Python\u5167\u7684\u8a08\u7b97\u529f\u80fd\u548cPandas\u7684\u53ef\u8996\u5316\u5de5\u5177\uff0c\u9810\u6e2c\u51fa\u6a21\u578b\u7c21\u55ae\u7684\u4eba\u751f\u66f2\u7dda\u3002<\/p>\n\n\n\n<p>\u7576\u7136\uff0c\u4eba\u751f\u4e0a\u6703\u6709\u5927\u5927\u5c0f\u5c0f\u6ce2\u6298\uff0c\u5404\u7a2e\u7684\u610f\u5916\u548c\u9a5a\u559c\uff0c\u9019\u500b\u9810\u6e2c\u66f2\u7dda\u53ef\u80fd\u4e0d\u6e96\u78ba\uff0c\u4f46\u5c55\u73fe\u51fa\u4f86\u7684\u90fd\u662f\u8981\u6211\u5011\u8d95\u7dca\u6295\u8cc7\uff0c\u4e0d\u8981\u60f3\u770b\u8907\u5229\u7684\u529b\u91cf\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%AC%E6%AC%A1%E7%B7%B4%E7%BF%92%E6%AA%94%E8%88%87%E8%AA%B2%E7%A8%8B\"><\/span>\u672c\u6b21\u7df4\u7fd2\u6a94\u8207\u8ab2\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u7df4\u7fd2\u6a94\uff1a<a href=\"https:\/\/colab.research.google.com\/drive\/1QvFbpfwJ9LQa8jmbz_osS-m10prhnpp3?usp=sharing\" target=\"_blank\" rel=\"noopener\">Day18(1\/11)\u5229\u7528Python Pandas\u9810\u6e2c\u500b\u4eba\u8ca1\u52d9\u66f2\u7dda<\/a><br>\u8ab2\u7a0b\uff1a<a class=\"rank-math-link\" href=\"https:\/\/track.twshop4coupon.com\/track\/clicks\/4850\/c627c2bf9b0628dcfc88ec35dc2e9753743940c172e5e7e25826bf016f015f?t=https%3A%2F%2Fhahow.in%2Fcourses%2F5a2170d5a6d4a5001ec3148d%2Fmain\" target=\"_blank\" rel=\"noopener\">\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E3%80%90Python%E6%96%B0%E6%89%8B%E7%B7%B4%E7%BF%92%E3%80%91%E7%9B%B8%E9%97%9C%E6%96%87%E7%AB%A0\"><\/span>\u3010Python\u65b0\u624b\u7df4\u7fd2\u3011\u76f8\u95dc\u6587\u7ae0<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p>\u3010Python\u65b0\u624b\u7df4\u7fd2\u3011\u7cfb\u5217\u6587\uff0c\u662f\u4e00\u500b<strong>\u884c\u92b7\u4eba\u5b78\u7fd2Python<\/strong>\u7684\u7b46\u8a18\uff0c\u5e0c\u671b\u53ef\u4ee5\u85c9\u7531\u7df4\u7fd2\u7a0b\u5f0f\uff0c\u8a13\u7df4\u66f4\u5f37\u5927\u7684\u908f\u8f2f\u601d\u8003\uff0c\u5982\u679c\u4f60\u4e5f\u5c0d\u9019\u584a\u6709\u8208\u8da3\uff0c\u9019\u4e9b\u6587\u7ae0\u6216\u8a31\u53ef\u4ee5\u5e6b\u52a9\u5230\u4f60\uff01\u4e5f\u6b61\u8fce\u4e00\u8d77\u4ea4\u6d41\u3002<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/python\/\" target=\"_blank\">\u884c\u92b7\u4eba\u7684Python\u7df4\u7fd290\u8a08\u756b-\u70ba\u4ec0\u9ebc\u8981\u5b78Python\uff1f<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/google-colab-python\/\" target=\"_blank\">Day0\uff1aGoogle Colab\u65b0\u624bPython\u958b\u767c\u74b0\u5883\u63a8\u85a6<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/digital-marketing\/seo\/python-2\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/digital-marketing\/seo\/python-2\/\" target=\"_blank\">Day1\uff1aPython\u8b8a\u6578\u8207\u8cc7\u6599\u578b\u614b<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/digital-marketing\/seo\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day2%ef%bc%9apython%e5%88%a4%e6%96%b7%e5%bc%8f%e8%88%87%e8%bf%b4%e5%9c%88%e6%b5%81%e7%a8%8b%e6%8e%a7%e5%88%b6\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/digital-marketing\/seo\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day2%ef%bc%9apython%e5%88%a4%e6%96%b7%e5%bc%8f%e8%88%87%e8%bf%b4%e5%9c%88%e6%b5%81%e7%a8%8b%e6%8e%a7%e5%88%b6\/\" target=\"_blank\">Day2\uff1aPython\u5224\u65b7\u5f0f\u8207\u8ff4\u5708(\u6d41\u7a0b\u63a7\u5236)<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/digital-marketing\/seo\/python-3\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/digital-marketing\/seo\/python-3\/\" target=\"_blank\">Day3\uff1aPython\u51fd\u5f0f \u5b9a\u7fa9\u3001\u547c\u53eb\u8207\u56de\u50b3<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day4%e8%bc%89%e5%85%a5python%e6%a8%a1%e7%b5%84%e8%88%87%e4%bd%bf%e7%94%a8\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day4%e8%bc%89%e5%85%a5python%e6%a8%a1%e7%b5%84%e8%88%87%e4%bd%bf%e7%94%a8\/\" target=\"_blank\">Day4\uff1a\u8f09\u5165Python\u6a21\u7d44\u8207\u4f7f\u7528<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day512-4python%e6%aa%94%e6%a1%88%e8%ae%80%e5%8f%96%e5%92%8c%e5%84%b2%e5%ad%98\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day512-4python%e6%aa%94%e6%a1%88%e8%ae%80%e5%8f%96%e5%92%8c%e5%84%b2%e5%ad%98\/\" target=\"_blank\">Day5\uff1aPython\u6a94\u6848\u8b80\u53d6\u548c\u5132\u5b58<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day6%ef%bc%9apython%e4%ba%82%e6%95%b8%e8%88%87%e7%b5%b1%e8%a8%88\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/%e3%80%90%e6%96%b0%e6%89%8bpython%e7%b7%b4%e7%bf%92%e3%80%91day6%ef%bc%9apython%e4%ba%82%e6%95%b8%e8%88%87%e7%b5%b1%e8%a8%88\/\" target=\"_blank\">Day6\uff1aPython\u4e82\u6578\u8207\u7d71\u8a08<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/pythonday7python-api\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/pythonday7python-api\/\" target=\"_blank\">Day7\uff1aPython API \u958b\u653e\u8cc7\u6599\u4e32\u63a5\uff0c\u6293\u53d6\u53f0\u5317\u5e02\u653f\u5e9c\u516c\u958b\u8cc7\u6599<\/a><a href=\"https:\/\/yc-note.com\/python\/pythonday7python-api\/\">\uff01<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/yc-note.com\/python\/python-4\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/python-4\/\" target=\"_blank\">Day8\uff1aPython\u5be6\u9ad4\u7269\u4ef6\u5efa\u7acb\u8207\u4f7f\u7528<\/a><br><a href=\"https:\/\/yc-note.com\/python\/python-5\/\" data-type=\"URL\" data-id=\"https:\/\/yc-note.com\/python\/python-5\/\" target=\"_blank\" rel=\"noreferrer noopener\">Day9\uff1aPython\u722c\u87f2\u5be6\u6230\uff01\u6293\u53d6PTT\u96fb\u5f71\u7248<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9019\u500b\u7df4\u7fd2\u4f86\u81ea<\u7528 Python \u7406\u8ca1\uff1a\u6253\u9020\u5c0f\u8cc7\u65cf\u9078\u80a1\u7b56\u7565>\u7684\u7b2c\u4e00\u500b\u4f5c\u696d\uff0c\u5229\u7528Python Pandas\u9810\u6e2c\u4eba\u751f\u8ca1\u52d9\u66f2\u7dda\uff0c\u6211\u6709\u628a\u8001\u5e2b\u7684Demo\u7a0d\u5fae\u4fee\u6539\u9806\u5e8f\uff0c\u8b93\u81ea\u5df1\u5728\u4f7f\u7528\u4e0a\u66f4\u9806\u624b\u3002\u9019\u7bc7\u540c\u6642\u6703\u7528\u5230Pandas\u3001\u51fd\u5f0f\u3001\u8ff4\u5708\u7b49\u7b49\u6982\u5ff5\u3002<\/p>\n","protected":false},"author":1,"featured_media":725,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":""},"categories":[34],"tags":[163,167,162,166,165],"jetpack_featured_media_url":"https:\/\/yc-note.com\/wp-content\/uploads\/2021\/01\/pexels-photo-4475523.jpeg","_links":{"self":[{"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/posts\/687"}],"collection":[{"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/comments?post=687"}],"version-history":[{"count":0,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/posts\/687\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/media\/725"}],"wp:attachment":[{"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/media?parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/categories?post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yc-note.com\/wp-json\/wp\/v2\/tags?post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}