{"id":118017,"date":"2026-10-26T03:24:38","date_gmt":"2026-10-25T19:24:38","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/118017.html"},"modified":"2026-10-26T03:24:38","modified_gmt":"2026-10-25T19:24:38","slug":"%e5%a4%a7%e6%a8%a1%e5%9e%8b%e5%ad%a6%e4%b9%a0%e4%b9%8b%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90-%e9%9d%a2%e5%90%91%e5%a4%a7%e6%a8%a1%e5%9e%8b%e7%9a%84pandas-%e4%b8%8e-matplotlib%e5%9f%ba","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/118017.html","title":{"rendered":"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840"},"content":{"rendered":"<\/p>\n<p>\u6458\u8981&#xff1a;Pandas \u662f Python \u6570\u636e\u5904\u7406\u7684\u6838\u5fc3\u5e93&#xff0c;\u63d0\u4f9b Series&#xff08;\u4e00\u7ef4&#xff09;\u548c DataFrame&#xff08;\u4e8c\u7ef4&#xff09;\u4e24\u79cd\u6570\u636e\u7ed3\u6784&#xff0c;\u652f\u6301\u6570\u636e\u8bfb\u5199&#xff08;CSV\u3001JSON&#xff09;\u3001\u7d22\u5f15\u9009\u62e9&#xff08;loc\/iloc&#xff09;\u3001\u6570\u636e\u6e05\u6d17&#xff08;\u53bb\u91cd\u3001\u7f3a\u5931\u503c&#xff09;\u3001\u6570\u636e\u5408\u5e76&#xff08;merge\/concat&#xff09;\u3001\u5206\u7ec4\u805a\u5408&#xff08;groupby&#xff09;\u7b49\u5b8c\u6574\u7684\u6570\u636e\u5904\u7406\u80fd\u529b\u3002\u5728\u5927\u6a21\u578b\u5e94\u7528\u4e2d&#xff0c;Pandas \u8d2f\u7a7f\u8bc4\u6d4b\u96c6\u6784\u5efa\u3001\u6a21\u578b\u8f93\u51fa\u89e3\u6790\u3001badcase \u5206\u6790\u3001\u7ed3\u679c\u7edf\u8ba1\u5168\u6d41\u7a0b&#xff0c;\u662f\u6570\u636e\u5904\u7406\u7684\u9996\u9009\u5de5\u5177\u3002<\/p>\n<p>Matplotlib \u662f Python \u6700\u57fa\u7840\u7684\u53ef\u89c6\u5316\u5e93&#xff0c;\u5927\u6a21\u578b\u89d2\u8272\u53ea\u9700\u7b80\u8981\u4e86\u89e3&#xff0c;\u638c\u63e1\u6298\u7ebf\u56fe&#xff08;\u770b loss \u66f2\u7ebf&#xff09;\u3001\u76f4\u65b9\u56fe&#xff08;\u770b\u6570\u636e\u5206\u5e03&#xff09;\u3001\u67f1\u72b6\u56fe&#xff08;\u770b\u7c7b\u522b\u5206\u5e03&#xff09;\u4e09\u79cd\u6700\u5e38\u7528\u7684\u56fe\u5373\u53ef\u3002\u901a\u8fc7 df.plot() \u4e00\u884c\u51fa\u56fe&#xff0c;\u914d\u5408 savefig() \u4fdd\u5b58\u5b9e\u9a8c\u8bb0\u5f55&#xff0c;\u8db3\u4ee5\u6ee1\u8db3\u65e5\u5e38\u5206\u6790\u9700\u6c42\u3002<\/p>\n<p>\u4e24\u8005\u7ed3\u5408&#xff0c;\u6784\u6210\u5927\u6a21\u578b\u5e94\u7528\u5f00\u53d1\u4e2d\u300c\u6570\u636e\u5904\u7406 &#043; \u53ef\u89c6\u5316\u300d\u7684\u5b8c\u6574\u5de5\u5177\u94fe&#xff1a;Pandas \u8d1f\u8d23\u6570\u636e\u6e05\u6d17\u4e0e\u5206\u6790&#xff0c;Matplotlib \u8d1f\u8d23\u5feb\u901f\u53ef\u89c6\u5316&#xff0c;\u5171\u540c\u652f\u6491\u8bc4\u6d4b\u3001\u8c03\u8bd5\u3001\u5b9e\u9a8c\u8bb0\u5f55\u7b49\u6838\u5fc3\u5de5\u4f5c\u6d41\u3002<\/p>\n<p>\u76ee\u5f55<\/p>\n<p id=\"%E4%BA%8C%E3%80%81pandas%E5%9F%BA%E7%A1%80-toc\" style=\"margin-left:0px\">\u4e8c\u3001pandas\u57fa\u7840<\/p>\n<p id=\"2.1%20Pandas%20%E4%BB%8B%E7%BB%8D-toc\" style=\"margin-left:40px\">2.1 Pandas \u4ecb\u7ecd<\/p>\n<p id=\"2.1.1%20Pandas%20%E6%98%AF%E4%BB%80%E4%B9%88-toc\" style=\"margin-left:80px\">2.1.1 Pandas \u662f\u4ec0\u4e48<\/p>\n<p id=\"2.1.2%20Pandas%20%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84-toc\" style=\"margin-left:80px\">2.1.2 Pandas \u6570\u636e\u7ed3\u6784<\/p>\n<p id=\"2.1.3%20%E4%B8%BA%E4%BB%80%E4%B9%88%E5%A4%A7%E6%A8%A1%E5%9E%8B%E8%A7%92%E8%89%B2%E8%A6%81%E5%AD%A6%20Pandas-toc\" style=\"margin-left:80px\">2.1.3 \u4e3a\u4ec0\u4e48\u5927\u6a21\u578b\u89d2\u8272\u8981\u5b66 Pandas<\/p>\n<p id=\"2.2%20Series%20%E4%B8%8E%20DataFrame%20%E5%9F%BA%E7%A1%80-toc\" style=\"margin-left:40px\">2.2 Series \u4e0e DataFrame \u57fa\u7840<\/p>\n<p id=\"2.2.1%20%E5%88%9B%E5%BB%BA%E5%AF%B9%E8%B1%A1-toc\" style=\"margin-left:80px\">2.2.1 \u521b\u5efa\u5bf9\u8c61<\/p>\n<p id=\"2.2.2%20%E7%B4%A2%E5%BC%95%E4%B8%8E%E9%80%89%E6%8B%A9-toc\" style=\"margin-left:80px\">2.2.2 \u7d22\u5f15\u4e0e\u9009\u62e9<\/p>\n<p id=\"2.2.3%20%E8%B5%8B%E5%80%BC%E4%B8%8E%E6%96%B0%E5%A2%9E%E5%88%97-toc\" style=\"margin-left:80px\">2.2.3 \u8d4b\u503c\u4e0e\u65b0\u589e\u5217<\/p>\n<p id=\"2.2.4%20%E6%8E%92%E5%BA%8F-toc\" style=\"margin-left:80px\">2.2.4 \u6392\u5e8f<\/p>\n<p id=\"2.2.5%20%E9%87%8D%E5%91%BD%E5%90%8D%E4%B8%8E%E5%88%97%E6%93%8D%E4%BD%9C-toc\" style=\"margin-left:80px\">2.2.5 \u91cd\u547d\u540d\u4e0e\u5217\u64cd\u4f5c<\/p>\n<p id=\"2.2.6%20%E7%B1%BB%E5%9E%8B%E8%BD%AC%E6%8D%A2%20astype-toc\" style=\"margin-left:80px\">2.2.6 \u7c7b\u578b\u8f6c\u6362 astype<\/p>\n<p id=\"2.3%20%E6%95%B0%E6%8D%AE%E8%AF%BB%E5%86%99%EF%BC%88%E6%95%B0%E6%8D%AE%E8%BF%9B%E5%87%BA%EF%BC%89-toc\" style=\"margin-left:40px\">2.3 \u6570\u636e\u8bfb\u5199&#xff08;\u6570\u636e\u8fdb\u51fa&#xff09;<\/p>\n<p id=\"2.3.1%20%E6%A8%A1%E5%9E%8B%E8%BE%93%E5%87%BA%20%E2%86%92%20DataFrame-toc\" style=\"margin-left:80px\">2.3.1 \u6a21\u578b\u8f93\u51fa \u2192 DataFrame<\/p>\n<p id=\"2.3.2%20CSV-toc\" style=\"margin-left:80px\">2.3.2 CSV<\/p>\n<p id=\"2.3.3%20JSON-toc\" style=\"margin-left:80px\">2.3.3 JSON<\/p>\n<p id=\"2.3.4%20MySQL%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89-toc\" style=\"margin-left:80px\">2.3.4 MySQL&#xff08;\u4e86\u89e3&#xff09;<\/p>\n<p id=\"2.3.5%20%E4%B8%8E%20NumPy%20%2F%20PyTorch%20%E4%BA%92%E8%BD%AC-toc\" style=\"margin-left:80px\">2.3.5 \u4e0e NumPy \/ PyTorch \u4e92\u8f6c<\/p>\n<p id=\"2.4%20DataFrame%20%E8%BF%90%E7%AE%97-toc\" style=\"margin-left:40px\">2.4 DataFrame \u8fd0\u7b97<\/p>\n<p id=\"2.4.1%20%E9%80%BB%E8%BE%91%E8%BF%90%E7%AE%97-toc\" style=\"margin-left:80px\">2.4.1 \u903b\u8f91\u8fd0\u7b97<\/p>\n<p id=\"2.4.2%20%E7%BB%9F%E8%AE%A1%E8%BF%90%E7%AE%97-toc\" style=\"margin-left:80px\">2.4.2 \u7edf\u8ba1\u8fd0\u7b97<\/p>\n<p id=\"2.4.2.1%20describe%20%2F%20mean%20%2F%20std%20%2F%20sum-toc\" style=\"margin-left:80px\">2.4.2.1 describe \/ mean \/ std \/ sum<\/p>\n<p id=\"2.4.2.2%20value_counts-toc\" style=\"margin-left:80px\">2.4.2.2 value_counts<\/p>\n<p id=\"2.5%20%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86-toc\" style=\"margin-left:40px\">2.5 \u6570\u636e\u5904\u7406<\/p>\n<p id=\"2.5.1%20%E5%8E%BB%E9%87%8D%20drop_duplicates-toc\" style=\"margin-left:80px\">2.5.1 \u53bb\u91cd drop_duplicates<\/p>\n<p id=\"2.5.2%20%E6%B7%BB%E5%8A%A0%20%2F%20%E5%88%A0%E9%99%A4%E5%88%97-toc\" style=\"margin-left:80px\">2.5.2 \u6dfb\u52a0 \/ \u5220\u9664\u5217<\/p>\n<p id=\"2.5.3%20%E7%BC%BA%E5%A4%B1%E5%80%BC%E5%A4%84%E7%90%86-toc\" style=\"margin-left:80px\">2.5.3 \u7f3a\u5931\u503c\u5904\u7406<\/p>\n<p id=\"2.5.4%20%E6%95%B0%E6%8D%AE%E5%90%88%E5%B9%B6-toc\" style=\"margin-left:80px\">2.5.4 \u6570\u636e\u5408\u5e76<\/p>\n<p id=\"2.5.4.1%20merge%EF%BC%88%E9%94%AE%E8%BF%9E%E6%8E%A5%EF%BC%89-toc\" style=\"margin-left:80px\">2.5.4.1 merge&#xff08;\u952e\u8fde\u63a5&#xff09;<\/p>\n<p id=\"2.5.5%20%E6%95%B0%E6%8D%AE%E5%88%86%E7%BB%84%E4%B8%8E%E8%81%9A%E5%90%88-toc\" style=\"margin-left:80px\">2.5.5 \u6570\u636e\u5206\u7ec4\u4e0e\u805a\u5408<\/p>\n<p id=\"2.5.6%20%E6%96%87%E6%9C%AC%E5%A4%84%E7%90%86-toc\" style=\"margin-left:80px\">2.5.6 \u6587\u672c\u5904\u7406<\/p>\n<p id=\"2.5.7%20%E9%9A%8F%E6%9C%BA%E9%87%87%E6%A0%B7-toc\" style=\"margin-left:80px\">2.5.7 \u968f\u673a\u91c7\u6837<\/p>\n<p id=\"2.5.8%20%E6%97%B6%E9%97%B4%E5%BA%8F%E5%88%97%E5%9F%BA%E7%A1%80-toc\" style=\"margin-left:80px\">2.5.8 \u65f6\u95f4\u5e8f\u5217\u57fa\u7840<\/p>\n<p id=\"2.5.9%20%E9%80%8F%E8%A7%86%E8%A1%A8%E4%B8%8E%E4%BA%A4%E5%8F%89%E8%A1%A8%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89-toc\" style=\"margin-left:80px\">2.5.9 \u900f\u89c6\u8868\u4e0e\u4ea4\u53c9\u8868&#xff08;\u4e86\u89e3&#xff09;<\/p>\n<p id=\"2.6%20%E7%BB%BC%E5%90%88%E5%AE%9E%E6%88%98%E6%A1%88%E4%BE%8B-toc\" style=\"margin-left:40px\">2.6 \u7efc\u5408\u5b9e\u6218\u6848\u4f8b<\/p>\n<p id=\"2.6.1%20%E6%A8%A1%E5%9E%8B%E8%BE%93%E5%87%BA%E8%A7%A3%E6%9E%90%EF%BC%88JSON%20%E2%86%92%20DataFrame%EF%BC%89-toc\" style=\"margin-left:80px\">2.6.1 \u6a21\u578b\u8f93\u51fa\u89e3\u6790&#xff08;JSON \u2192 DataFrame&#xff09;<\/p>\n<p id=\"2.6.2%20%E8%AF%84%E6%B5%8B%E9%9B%86%E7%BB%9F%E8%AE%A1%EF%BC%88%E5%87%86%E7%A1%AE%E7%8E%87%E3%80%81badcase%EF%BC%89-toc\" style=\"margin-left:80px\">2.6.2 \u8bc4\u6d4b\u96c6\u7edf\u8ba1&#xff08;\u51c6\u786e\u7387\u3001badcase&#xff09;<\/p>\n<p id=\"2.6.3%20%E6%95%B0%E6%8D%AE%E6%B8%85%E6%B4%97%E4%B8%8E%E5%AF%BC%E5%87%BA-toc\" style=\"margin-left:80px\">2.6.3 \u6570\u636e\u6e05\u6d17\u4e0e\u5bfc\u51fa<\/p>\n<p id=\"%E4%B8%89%E3%80%81Matplotlib%20%E5%85%A5%E9%97%A8%EF%BC%88%E7%AE%80%E8%A6%81%E4%BA%86%E8%A7%A3%EF%BC%89%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0-toc\" style=\"margin-left:0px\">\u4e09\u3001Matplotlib \u5165\u95e8&#xff08;\u7b80\u8981\u4e86\u89e3&#xff09; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<p id=\"3.1%20Matplotlib%20%E4%BB%8B%E7%BB%8D-toc\" style=\"margin-left:40px\">3.1 Matplotlib \u4ecb\u7ecd<\/p>\n<p id=\"3.1.1%20Matplotlib%20%E6%98%AF%E4%BB%80%E4%B9%88-toc\" style=\"margin-left:80px\">3.1.1 Matplotlib \u662f\u4ec0\u4e48<\/p>\n<p id=\"3.1.2%20%E4%B8%BA%E4%BB%80%E4%B9%88%E5%A4%A7%E6%A8%A1%E5%9E%8B%E8%A7%92%E8%89%B2%E5%8F%AA%E9%9C%80%E7%AE%80%E8%A6%81%E4%BA%86%E8%A7%A3-toc\" style=\"margin-left:80px\">3.1.2 \u4e3a\u4ec0\u4e48\u5927\u6a21\u578b\u89d2\u8272\u53ea\u9700\u7b80\u8981\u4e86\u89e3<\/p>\n<p id=\"3.2%20%E5%A4%A7%E6%A8%A1%E5%9E%8B%E5%9C%BA%E6%99%AF%E4%B8%8B%E6%9C%80%E5%B8%B8%E7%94%A8%E7%9A%84%E5%9B%BE-toc\" style=\"margin-left:40px\">3.2 \u5927\u6a21\u578b\u573a\u666f\u4e0b\u6700\u5e38\u7528\u7684\u56fe<\/p>\n<p id=\"3.2.1%20loss%20%2F%20accuracy%20%E6%9B%B2%E7%BA%BF%EF%BC%88%E6%8A%98%E7%BA%BF%E5%9B%BE%EF%BC%89-toc\" style=\"margin-left:80px\">3.2.1 loss \/ accuracy \u66f2\u7ebf&#xff08;\u6298\u7ebf\u56fe&#xff09;<\/p>\n<p id=\"3.2.2%20%E6%95%B0%E6%8D%AE%E5%88%86%E5%B8%83%EF%BC%88%E7%9B%B4%E6%96%B9%E5%9B%BE%EF%BC%89-toc\" style=\"margin-left:80px\">3.2.2 \u6570\u636e\u5206\u5e03&#xff08;\u76f4\u65b9\u56fe&#xff09;<\/p>\n<p id=\"3.2.3%20%E7%B1%BB%E5%88%AB%E5%88%86%E5%B8%83%EF%BC%88%E6%9F%B1%E7%8A%B6%E5%9B%BE%EF%BC%89-toc\" style=\"margin-left:80px\">3.2.3 \u7c7b\u522b\u5206\u5e03&#xff08;\u67f1\u72b6\u56fe&#xff09;<\/p>\n<p id=\"3.2.4%20%E6%95%A3%E7%82%B9%E5%9B%BE%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89-toc\" style=\"margin-left:80px\">3.2.4 \u6563\u70b9\u56fe&#xff08;\u4e86\u89e3&#xff09;<\/p>\n<p id=\"3.2.5%20%E5%9B%BE%E8%A1%A8%E9%80%89%E6%8B%A9%E6%8C%87%E5%8D%97%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89-toc\" style=\"margin-left:80px\">3.2.5 \u56fe\u8868\u9009\u62e9\u6307\u5357&#xff08;\u4e86\u89e3&#xff09;<\/p>\n<p id=\"3.3%20%E5%9F%BA%E7%A1%80%E7%BB%98%E5%9B%BE%E5%8A%9F%E8%83%BD-toc\" style=\"margin-left:40px\">3.3 \u57fa\u7840\u7ed8\u56fe\u529f\u80fd<\/p>\n<p id=\"3.3.1%20%E4%B8%8E%20pandas%20%E8%81%94%E5%8A%A8%20df.plot()%C2%A0-toc\" style=\"margin-left:80px\">3.3.1 \u4e0e pandas \u8054\u52a8 df.plot()\u00a0<\/p>\n<p id=\"3.3.2%20%E4%B8%8E%20NumPy%20%E6%95%B0%E7%BB%84%E7%9B%B4%E6%8E%A5%E7%BB%98%E5%9B%BE%C2%A0-toc\" style=\"margin-left:80px\">3.3.2 \u4e0e NumPy \u6570\u7ec4\u76f4\u63a5\u7ed8\u56fe\u00a0<\/p>\n<p id=\"3.3.3%20pyplot%20%E9%A3%8E%E6%A0%BC%20plt.plot%20%2F%20scatter%20%2F%20hist-toc\" style=\"margin-left:80px\">3.3.3 pyplot \u98ce\u683c plt.plot \/ scatter \/ hist<\/p>\n<p id=\"3.3.4%20%E6%A0%87%E9%A2%98%E3%80%81%E5%9D%90%E6%A0%87%E8%BD%B4%E6%A0%87%E7%AD%BE%E3%80%81%E5%9B%BE%E4%BE%8B-toc\" style=\"margin-left:80px\">3.3.4 \u6807\u9898\u3001\u5750\u6807\u8f74\u6807\u7b7e\u3001\u56fe\u4f8b<\/p>\n<p id=\"3.3.5%20%E4%BF%9D%E5%AD%98%E5%9B%BE%E7%89%87%20savefig-toc\" style=\"margin-left:80px\">3.3.5 \u4fdd\u5b58\u56fe\u7247 savefig<\/p>\n<hr id=\"hr-toc\" \/>\n<h2>\u4e8c\u3001pandas\u57fa\u7840<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1886\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192435-6ade5773be470.png\" width=\"1432\" \/><\/p>\n<h3 id=\"2.1%20Pandas%20%E4%BB%8B%E7%BB%8D\">2.1 Pandas \u4ecb\u7ecd<\/h3>\n<h4 id=\"2.1.1%20Pandas%20%E6%98%AF%E4%BB%80%E4%B9%88\">2.1.1 Pandas \u662f\u4ec0\u4e48<\/h4>\n<p>Pandas \u662f Python \u6700\u6d41\u884c\u7684\u6570\u636e\u5206\u6790\u5e93&#xff0c;\u6838\u5fc3\u662f\u4e24\u79cd\u6570\u636e\u7ed3\u6784&#xff1a;Series&#xff08;\u4e00\u7ef4&#xff09;\u548c DataFrame&#xff08;\u4e8c\u7ef4&#xff09;\u3002\u5b83\u5efa\u7acb\u5728 NumPy \u4e4b\u4e0a&#xff0c;\u63d0\u4f9b\u4e86\u66f4\u5f3a\u5927\u7684\u6570\u636e\u64cd\u4f5c\u80fd\u529b\u3002<\/p>\n<p>\u4e00\u53e5\u8bdd\u7406\u89e3&#xff1a; Pandas \u8ba9 Python \u80fd\u50cf Excel \u4e00\u6837\u5904\u7406\u8868\u683c\u6570\u636e&#xff0c;\u4f46\u529f\u80fd\u66f4\u5f3a\u5927\u3001\u66f4\u7075\u6d3b\u3002<\/p>\n<p>\u6838\u5fc3\u80fd\u529b&#xff1a;<\/p>\n<table>\n<tr>\u80fd\u529b\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u6570\u636e\u8bfb\u5199<\/td>\n<td>CSV\u3001JSON\u3001Excel\u3001MySQL \u7b49<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u6e05\u6d17<\/td>\n<td>\u7f3a\u5931\u503c\u3001\u53bb\u91cd\u3001\u7c7b\u578b\u8f6c\u6362<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u7b5b\u9009<\/td>\n<td>\u6761\u4ef6\u7b5b\u9009\u3001\u6392\u5e8f\u3001\u5206\u7ec4<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u805a\u5408<\/td>\n<td>groupby\u3001\u900f\u89c6\u8868<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u5408\u5e76<\/td>\n<td>merge\u3001concat<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.1.2%20Pandas%20%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84\">2.1.2 Pandas \u6570\u636e\u7ed3\u6784<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"558\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192437-6ade577500749.png\" width=\"895\" \/><\/p>\n<h5 id=\"2.1.2.1%20Series%20%E5%AF%B9%E8%B1%A1\">2.1.2.1 Series \u5bf9\u8c61<\/h5>\n<p>Series \u662f Pandas \u7684\u4e00\u7ef4\u6570\u636e\u7ed3\u6784&#xff0c;\u7531\u7d22\u5f15&#xff08;index&#xff09;\u548c\u503c&#xff08;values&#xff09;\u7ec4\u6210\u3002\u53ef\u4ee5\u7406\u89e3\u4e3a&#034;\u5e26\u6807\u7b7e\u7684\u4e00\u7ef4\u6570\u7ec4&#034;\u3002<\/p>\n<h5 id=\"2.1.2.2%20DataFrame%20%E5%AF%B9%E8%B1%A1\">2.1.2.2 DataFrame \u5bf9\u8c61<\/h5>\n<p>DataFrame \u662f Pandas \u7684\u4e8c\u7ef4\u6570\u636e\u7ed3\u6784&#xff0c;\u7531\u884c\u7d22\u5f15&#xff08;index&#xff09;\u548c\u5217\u7d22\u5f15&#xff08;columns&#xff09;\u7ec4\u6210\u3002\u53ef\u4ee5\u7406\u89e3\u4e3a&#034;\u5e26\u6807\u7b7e\u7684\u4e8c\u7ef4\u8868\u683c&#034;\u3002<\/p>\n<h5 id=\"2.1.2.3%20%E4%B8%8E%20NumPy%20%E7%9A%84%E6%A0%B8%E5%BF%83%E5%8C%BA%E5%88%AB\">2.1.2.3 \u4e0e NumPy \u7684\u6838\u5fc3\u533a\u522b<\/h5>\n<table>\n<tr>\u7ef4\u5ea6NumPyPandas<\/tr>\n<tbody>\n<tr>\n<td>\u7ef4\u5ea6<\/td>\n<td>\u591a\u7ef4\u6570\u7ec4<\/td>\n<td>\u4e00\u7ef4 Series\u3001\u4e8c\u7ef4 DataFrame<\/td>\n<\/tr>\n<tr>\n<td>\u7d22\u5f15<\/td>\n<td>\u9690\u5f0f\u6574\u6570\u7d22\u5f15<\/td>\n<td>\u652f\u6301\u6807\u7b7e\u7d22\u5f15<\/td>\n<\/tr>\n<tr>\n<td>\u7c7b\u578b<\/td>\n<td>\u8981\u6c42\u7edf\u4e00 dtype<\/td>\n<td>\u5217\u95f4\u53ef\u4e0d\u540c dtype<\/td>\n<\/tr>\n<tr>\n<td>\u7f3a\u5931\u503c<\/td>\n<td>nan&#xff08;\u4ec5\u6d6e\u70b9&#xff09;<\/td>\n<td>None \/ NaN \/ NaT<\/td>\n<\/tr>\n<tr>\n<td>\u5217\u540d<\/td>\n<td>\u65e0<\/td>\n<td>\u6709\u5217\u540d<\/td>\n<\/tr>\n<tr>\n<td>\u5e94\u7528<\/td>\n<td>\u6570\u503c\u8ba1\u7b97<\/td>\n<td>\u6570\u636e\u5904\u7406<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.1.3%20%E4%B8%BA%E4%BB%80%E4%B9%88%E5%A4%A7%E6%A8%A1%E5%9E%8B%E8%A7%92%E8%89%B2%E8%A6%81%E5%AD%A6%20Pandas\">2.1.3 \u4e3a\u4ec0\u4e48\u5927\u6a21\u578b\u89d2\u8272\u8981\u5b66 Pandas<\/h4>\n<p>Pandas \u662f\u5927\u6a21\u578b\u5e94\u7528\u5f00\u53d1\u4e2d\u6570\u636e\u5904\u7406\u7684\u6838\u5fc3\u5de5\u5177&#xff0c;\u8d2f\u7a7f\u8bc4\u6d4b\u3001\u6e05\u6d17\u3001\u5206\u6790\u5168\u6d41\u7a0b\u3002<\/p>\n<p>\u5e94\u7528\u573a\u666f<\/p>\n<table>\n<tr>\u573a\u666f\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u6570\u636e\u6e05\u6d17<\/td>\n<td>\u6e05\u6d17\u8bad\u7ec3\u6570\u636e\u3001\u8bc4\u6d4b\u6570\u636e<\/td>\n<\/tr>\n<tr>\n<td>\u8bc4\u6d4b\u96c6<\/td>\n<td>\u6784\u5efa\u3001\u7ba1\u7406\u8bc4\u6d4b\u96c6<\/td>\n<\/tr>\n<tr>\n<td>badcase<\/td>\n<td>\u5206\u6790\u6a21\u578b\u9519\u8bef\u6848\u4f8b<\/td>\n<\/tr>\n<tr>\n<td>\u6a21\u578b\u8f93\u51fa\u89e3\u6790<\/td>\n<td>JSON \u2192 DataFrame&#xff0c;\u6279\u91cf\u5206\u6790<\/td>\n<\/tr>\n<tr>\n<td>\u7ed3\u679c\u7edf\u8ba1<\/td>\n<td>\u51c6\u786e\u7387\u3001\u53ec\u56de\u7387\u3001\u5206\u5e03\u7edf\u8ba1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 id=\"2.2%20Series%20%E4%B8%8E%20DataFrame%20%E5%9F%BA%E7%A1%80\">2.2 Series \u4e0e DataFrame \u57fa\u7840<\/h3>\n<h4 id=\"2.2.1%20%E5%88%9B%E5%BB%BA%E5%AF%B9%E8%B1%A1\">2.2.1 \u521b\u5efa\u5bf9\u8c61<\/h4>\n<p>Pandas \u652f\u6301\u4ece\u591a\u79cd\u6570\u636e\u6e90\u521b\u5efa Series \u548c DataFrame\u3002<\/p>\n<p># \u521b\u5efa Series \u548c DataFrame<\/p>\n<p>import pandas as pd<br \/>\nimport numpy as np<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; Series &#061;&#061;&#061;&#061;&#061;<br \/>\n# \u4ece\u5217\u8868<br \/>\ns1 &#061; pd.Series([1, 2, 3, 4, 5])<\/p>\n<p># \u4ece\u5b57\u5178<br \/>\ns2 &#061; pd.Series({&#034;a&#034;: 1, &#034;b&#034;: 2, &#034;c&#034;: 3})<\/p>\n<p># \u4ece ndarray<br \/>\ns3 &#061; pd.Series(np.array([10, 20, 30]))<\/p>\n<p># \u6307\u5b9a\u7d22\u5f15<br \/>\ns4 &#061; pd.Series([1, 2, 3], index&#061;[&#034;x&#034;, &#034;y&#034;, &#034;z&#034;])<\/p>\n<p>print(f&#034;\u4ece\u5217\u8868&#xff1a;\\\\n{s1}&#034;)<br \/>\nprint(f&#034;\\\\n\u4ece\u5b57\u5178&#xff1a;\\\\n{s2}&#034;)<br \/>\nprint(f&#034;\\\\n\u6307\u5b9a\u7d22\u5f15&#xff1a;\\\\n{s4}&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; DataFrame &#061;&#061;&#061;&#061;&#061;<br \/>\n# \u4ece\u5b57\u5178&#xff08;\u6700\u5e38\u89c1&#xff09;<br \/>\ndf1 &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;]<br \/>\n})<\/p>\n<p># \u4ece\u5217\u8868\u7684\u5b57\u5178<br \/>\ndf2 &#061; pd.DataFrame([<br \/>\n    {&#034;name&#034;: &#034;\u5f20\u4e09&#034;, &#034;age&#034;: 25},<br \/>\n    {&#034;name&#034;: &#034;\u674e\u56db&#034;, &#034;age&#034;: 30},<br \/>\n])<\/p>\n<p># \u4ece ndarray<br \/>\ndf3 &#061; pd.DataFrame(np.array([[1, 2], [3, 4]]), columns&#061;[&#034;A&#034;, &#034;B&#034;])<\/p>\n<p>print(f&#034;\\\\nDataFrame \u4ece\u5b57\u5178&#xff1a;\\\\n{df1}&#034;)<br \/>\nprint(f&#034;\\\\nDataFrame \u4ece\u5217\u8868\u7684\u5b57\u5178&#xff1a;\\\\n{df2}&#034;)<br \/>\nprint(f&#034;\\\\nDataFrame \u4ece ndarray&#xff1a;\\\\n{df3}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>pd.Series()<\/td>\n<td>\u521b\u5efa Series\u3002\u53c2\u6570\u4e3a\u6570\u636e&#xff0c;index \u6307\u5b9a\u7d22\u5f15<\/td>\n<\/tr>\n<tr>\n<td>pd.DataFrame()<\/td>\n<td>\u521b\u5efa DataFrame\u3002\u53c2\u6570\u4e3a\u5b57\u5178\u3001\u5217\u8868\u3001ndarray&#xff0c;columns \u6307\u5b9a\u5217\u540d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>Series \u4ece\u5217\u8868\u3001\u5b57\u5178\u3001ndarray \u521b\u5efa<\/p>\n<\/li>\n<li>\n<p>DataFrame \u4ece\u5b57\u5178&#xff08;\u6700\u5e38\u89c1&#xff09;\u3001\u5217\u8868\u7684\u5b57\u5178\u3001ndarray \u521b\u5efa<\/p>\n<\/li>\n<li>\n<p>columns \u6307\u5b9a\u5217\u540d<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.2.2%20%E7%B4%A2%E5%BC%95%E4%B8%8E%E9%80%89%E6%8B%A9\">2.2.2 \u7d22\u5f15\u4e0e\u9009\u62e9<\/h4>\n<h5 id=\"2.2.2.1%20loc%EF%BC%88%E6%A0%87%E7%AD%BE%E7%B4%A2%E5%BC%95%EF%BC%89\">2.2.2.1 loc&#xff08;\u6807\u7b7e\u7d22\u5f15&#xff09;<\/h5>\n<p>loc \u57fa\u4e8e\u6807\u7b7e\u7d22\u5f15&#xff0c;\u4f7f\u7528\u884c\u7d22\u5f15\u540d\u548c\u5217\u540d\u3002<\/p>\n<p># loc&#xff1a;\u6807\u7b7e\u7d22\u5f15<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;]<br \/>\n}, index&#061;[&#034;a&#034;, &#034;b&#034;, &#034;c&#034;])<\/p>\n<p># \u53d6\u5355\u884c<br \/>\nprint(f&#034;df.loc[&#039;a&#039;]&#xff1a;\\\\n{df.loc[&#039;a&#039;]}&#034;)<\/p>\n<p># \u53d6\u5355\u5217<br \/>\nprint(f&#034;\\\\ndf.loc[:, &#039;name&#039;]&#xff1a;\\\\n{df.loc[:, &#039;name&#039;]}&#034;)<\/p>\n<p># \u53d6\u5355\u503c<br \/>\nprint(f&#034;\\\\ndf.loc[&#039;a&#039;, &#039;name&#039;]&#xff1a;{df.loc[&#039;a&#039;, &#039;name&#039;]}&#034;)<\/p>\n<p># \u53d6\u591a\u884c\u591a\u5217<br \/>\nprint(f&#034;\\\\ndf.loc[&#039;a&#039;:&#039;b&#039;, [&#039;name&#039;, &#039;age&#039;]]&#xff1a;\\\\n{df.loc[&#039;a&#039;:&#039;b&#039;, [&#039;name&#039;, &#039;age&#039;]]}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u8bed\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.loc[\u884c\u6807\u7b7e]<\/td>\n<td>\u53d6\u884c<\/td>\n<\/tr>\n<tr>\n<td>df.loc[:, \u5217\u6807\u7b7e]<\/td>\n<td>\u53d6\u5217<\/td>\n<\/tr>\n<tr>\n<td>df.loc[\u884c\u6807\u7b7e, \u5217\u6807\u7b7e]<\/td>\n<td>\u53d6\u5355\u503c<\/td>\n<\/tr>\n<tr>\n<td>df.loc[\u884c\u6807\u7b7e\u5217\u8868, \u5217\u6807\u7b7e\u5217\u8868]<\/td>\n<td>\u53d6\u591a\u884c\u591a\u5217<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>loc \u57fa\u4e8e\u6807\u7b7e<\/p>\n<\/li>\n<li>\n<p>\u5207\u7247 &#039;a&#039;:&#039;b&#039; \u5305\u542b\u53f3\u7aef<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.2.2.2%20iloc%EF%BC%88%E4%BD%8D%E7%BD%AE%E7%B4%A2%E5%BC%95%EF%BC%89\">2.2.2.2 iloc&#xff08;\u4f4d\u7f6e\u7d22\u5f15&#xff09;<\/h5>\n<p>iloc \u57fa\u4e8e\u4f4d\u7f6e\u7d22\u5f15&#xff0c;\u4f7f\u7528\u6574\u6570\u4f4d\u7f6e\u3002<\/p>\n<p># iloc&#xff1a;\u4f4d\u7f6e\u7d22\u5f15<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;]<br \/>\n})<\/p>\n<p># \u53d6\u5355\u884c<br \/>\nprint(f&#034;df.iloc[0]&#xff1a;\\\\n{df.iloc[0]}&#034;)<\/p>\n<p># \u53d6\u5355\u5217<br \/>\nprint(f&#034;\\\\ndf.iloc[:, 0]&#xff1a;\\\\n{df.iloc[:, 0]}&#034;)<\/p>\n<p># \u53d6\u5355\u503c<br \/>\nprint(f&#034;\\\\ndf.iloc[0, 0]&#xff1a;{df.iloc[0, 0]}&#034;)<\/p>\n<p># \u53d6\u591a\u884c\u591a\u5217<br \/>\nprint(f&#034;\\\\ndf.iloc[0:2, 0:2]&#xff1a;\\\\n{df.iloc[0:2, 0:2]}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u8bed\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.iloc[\u884c\u4f4d\u7f6e]<\/td>\n<td>\u53d6\u884c<\/td>\n<\/tr>\n<tr>\n<td>df.iloc[:, \u5217\u4f4d\u7f6e]<\/td>\n<td>\u53d6\u5217<\/td>\n<\/tr>\n<tr>\n<td>df.iloc[\u884c\u4f4d\u7f6e, \u5217\u4f4d\u7f6e]<\/td>\n<td>\u53d6\u5355\u503c<\/td>\n<\/tr>\n<tr>\n<td>df.iloc[\u884c\u4f4d\u7f6e\u5207\u7247, \u5217\u4f4d\u7f6e\u5207\u7247]<\/td>\n<td>\u53d6\u591a\u884c\u591a\u5217<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>iloc \u57fa\u4e8e\u4f4d\u7f6e<\/p>\n<\/li>\n<li>\n<p>\u5207\u7247 0:2 \u4e0d\u542b\u53f3\u7aef<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.2.2.3%20%E5%B8%83%E5%B0%94%E7%B4%A2%E5%BC%95\">2.2.2.3 \u5e03\u5c14\u7d22\u5f15<\/h5>\n<p>\u5e03\u5c14\u7d22\u5f15\u7528\u6761\u4ef6\u8868\u8fbe\u5f0f\u7b5b\u9009\u6570\u636e&#xff0c;\u8fd4\u56de\u6ee1\u8db3\u6761\u4ef6\u7684\u884c\u3002<\/p>\n<p># \u5e03\u5c14\u7d22\u5f15<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;]<br \/>\n})<\/p>\n<p># \u5355\u6761\u4ef6<br \/>\nresult &#061; df[df[&#034;age&#034;] &gt; 26]<br \/>\nprint(f&#034;age &gt; 26&#xff1a;\\\\n{result}&#034;)<\/p>\n<p># \u591a\u6761\u4ef6<br \/>\nresult &#061; df[(df[&#034;age&#034;] &gt; 26) &amp; (df[&#034;city&#034;] &#061;&#061; &#034;\u4e0a\u6d77&#034;)]<br \/>\nprint(f&#034;\\\\nage &gt; 26 \u4e14 city &#061;&#061; \u4e0a\u6d77&#xff1a;\\\\n{result}&#034;)<\/p>\n<p># isin<br \/>\nresult &#061; df[df[&#034;city&#034;].isin([&#034;\u676d\u5dde&#034;, &#034;\u5317\u4eac&#034;])]<br \/>\nprint(f&#034;\\\\ncity in [\u676d\u5dde, \u5317\u4eac]&#xff1a;\\\\n{result}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u8bed\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df[\u6761\u4ef6]<\/td>\n<td>\u5e03\u5c14\u7d22\u5f15\u7b5b\u9009<\/td>\n<\/tr>\n<tr>\n<td>df[\u6761\u4ef61 &amp; \u6761\u4ef62]<\/td>\n<td>\u591a\u6761\u4ef6&#xff0c;\u7528 &amp; \u4e14\u52a0\u62ec\u53f7<\/td>\n<\/tr>\n<tr>\n<td>df[\u5217].isin(\u5217\u8868)<\/td>\n<td>\u5224\u65ad\u662f\u5426\u5728\u5217\u8868\u4e2d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u5e03\u5c14\u7d22\u5f15\u8fd4\u56de\u6ee1\u8db3\u6761\u4ef6\u7684\u884c<\/p>\n<\/li>\n<li>\n<p>\u591a\u6761\u4ef6\u7528 &amp;\u3001|&#xff0c;\u4e0d\u80fd\u7528 and\u3001or<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.2.2.4%20%E6%98%93%E9%94%99%E7%82%B9%EF%BC%9Aloc%20%E5%90%AB%E5%8F%B3%E7%AB%AF%EF%BC%8Ciloc%20%E4%B8%8D%E5%90%AB%E5%8F%B3%E7%AB%AF\">2.2.2.4 \u6613\u9519\u70b9&#xff1a;loc \u542b\u53f3\u7aef&#xff0c;iloc \u4e0d\u542b\u53f3\u7aef<\/h5>\n<p># \u9519\u8bef&#xff1a;\u4ee5\u4e3a loc \u548c iloc \u5207\u7247\u884c\u4e3a\u4e00\u81f4<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28]<br \/>\n}, index&#061;[&#034;a&#034;, &#034;b&#034;, &#034;c&#034;])<\/p>\n<p># loc&#xff1a;\u542b\u53f3\u7aef<br \/>\nprint(f&#034;loc[&#039;a&#039;:&#039;b&#039;]&#xff1a;\\\\n{df.loc[&#039;a&#039;:&#039;b&#039;]}&#034;)    # \u5305\u542b a \u548c b<\/p>\n<p># iloc&#xff1a;\u4e0d\u542b\u53f3\u7aef<br \/>\nprint(f&#034;\\\\niloc[0:2]&#xff1a;\\\\n{df.iloc[0:2]}&#034;)         # \u5305\u542b 0 \u548c 1&#xff0c;\u4e0d\u542b 2 <\/p>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u7d22\u5f15\u65b9\u5f0f\u5207\u7247\u884c\u4e3a<\/tr>\n<tbody>\n<tr>\n<td>loc<\/td>\n<td>\u542b\u53f3\u7aef<\/td>\n<\/tr>\n<tr>\n<td>iloc<\/td>\n<td>\u4e0d\u542b\u53f3\u7aef<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5 id=\"2.2.2.5%20%E6%98%93%E9%94%99%E7%82%B9%EF%BC%9A%E9%93%BE%E5%BC%8F%E8%B5%8B%E5%80%BC%20SettingWithCopy\">2.2.2.5 \u6613\u9519\u70b9&#xff1a;\u94fe\u5f0f\u8d4b\u503c SettingWithCopy<\/h5>\n<p># \u9519\u8bef&#xff1a;\u94fe\u5f0f\u8d4b\u503c<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28]<br \/>\n})<\/p>\n<p># \u94fe\u5f0f\u8d4b\u503c&#xff1a;\u5148\u7b5b\u9009&#xff0c;\u518d\u8d4b\u503c<br \/>\n# df[df[&#034;age&#034;] &gt; 26][&#034;age&#034;] &#061; 100 # SettingWithCopyWarning<\/p>\n<p># \u6b63\u786e&#xff1a;\u7528 .loc \u4e00\u6b65\u5230\u4f4d<br \/>\ndf.loc[df[&#034;age&#034;] &gt; 26, &#034;age&#034;] &#061; 100<br \/>\nprint(df) <\/p>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u94fe\u5f0f\u8d4b\u503c\u53ef\u80fd\u4fee\u6539\u7684\u662f\u526f\u672c&#xff0c;\u800c\u975e\u539f DataFrame<\/p>\n<\/li>\n<li>\n<p>\u7528 .loc[\u6761\u4ef6, \u5217] &#061; \u503c \u4e00\u6b65\u5230\u4f4d<\/p>\n<\/li>\n<li>\n<p>\u907f\u514d\u94fe\u5f0f\u8d4b\u503c<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.2.3%20%E8%B5%8B%E5%80%BC%E4%B8%8E%E6%96%B0%E5%A2%9E%E5%88%97\">2.2.3 \u8d4b\u503c\u4e0e\u65b0\u589e\u5217<\/h4>\n<p>Pandas \u652f\u6301\u76f4\u63a5\u8d4b\u503c\u65b0\u589e\u5217\u3001\u4fee\u6539\u5217\u503c\u3001\u6761\u4ef6\u8d4b\u503c\u3002<\/p>\n<p># \u8d4b\u503c\u4e0e\u65b0\u589e\u5217<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28]<br \/>\n})<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u65b0\u589e\u5217&#xff1a;\u5e38\u91cf &#061;&#061;&#061;&#061;&#061;<br \/>\ndf[&#034;city&#034;] &#061; &#034;\u676d\u5dde&#034;<br \/>\nprint(f&#034;\u65b0\u589e\u5e38\u91cf\u5217&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u65b0\u589e\u5217&#xff1a;\u8ba1\u7b97 &#061;&#061;&#061;&#061;&#061;<br \/>\ndf[&#034;age_plus_10&#034;] &#061; df[&#034;age&#034;] &#043; 10<br \/>\nprint(f&#034;\\\\n\u65b0\u589e\u8ba1\u7b97\u5217&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u65b0\u589e\u5217&#xff1a;\u6761\u4ef6\u8d4b\u503c &#061;&#061;&#061;&#061;&#061;<br \/>\ndf[&#034;is_adult&#034;] &#061; df[&#034;age&#034;] &gt;&#061; 18<br \/>\nprint(f&#034;\\\\n\u65b0\u589e\u6761\u4ef6\u5217&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u4fee\u6539\u5217\u503c &#061;&#061;&#061;&#061;&#061;<br \/>\ndf[&#034;age&#034;] &#061; df[&#034;age&#034;] &#043; 1<br \/>\nprint(f&#034;\\\\n\u4fee\u6539\u5217\u503c&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u5220\u9664\u5217 &#061;&#061;&#061;&#061;&#061;<br \/>\ndf &#061; df.drop(columns&#061;[&#034;age_plus_10&#034;])<br \/>\nprint(f&#034;\\\\n\u5220\u9664\u5217&#xff1a;\\\\n{df}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df[&#034;\u65b0\u5217&#034;] &#061; \u503c<\/td>\n<td>\u65b0\u589e\u5217\u6216\u4fee\u6539\u5217<\/td>\n<\/tr>\n<tr>\n<td>df.drop(columns&#061;[&#8230;])<\/td>\n<td>\u5220\u9664\u5217\u3002columns \u6307\u5b9a\u5217\u540d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u65b0\u589e\u5217\u76f4\u63a5\u8d4b\u503c<\/p>\n<\/li>\n<li>\n<p>\u6761\u4ef6\u8d4b\u503c\u7528\u5e03\u5c14\u8868\u8fbe\u5f0f<\/p>\n<\/li>\n<li>\n<p>drop \u8fd4\u56de\u65b0 DataFrame&#xff0c;\u4e0d\u4fee\u6539\u539f\u6570\u636e<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.2.4%20%E6%8E%92%E5%BA%8F\">2.2.4 \u6392\u5e8f<\/h4>\n<h3 id=\"2.2.4.1%20sort_values%20%2F%20sort_index%20%5BL3%5D\">2.2.4.1 sort_values \/ sort_index [L3]<\/h3>\n<p># \u6392\u5e8f<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28]<br \/>\n}, index&#061;[&#034;c&#034;, &#034;a&#034;, &#034;b&#034;])<\/p>\n<p># \u6309\u503c\u6392\u5e8f&#xff1a;\u9ed8\u8ba4\u5347\u5e8f<br \/>\nprint(f&#034;\u6309 age \u5347\u5e8f&#xff1a;\\\\n{df.sort_values(&#039;age&#039;)}&#034;)<\/p>\n<p># \u964d\u5e8f<br \/>\nprint(f&#034;\\\\n\u6309 age \u964d\u5e8f&#xff1a;\\\\n{df.sort_values(&#039;age&#039;, ascending&#061;False)}&#034;)<\/p>\n<p># \u6309\u7d22\u5f15\u6392\u5e8f<br \/>\nprint(f&#034;\\\\n\u6309\u7d22\u5f15\u6392\u5e8f&#xff1a;\\\\n{df.sort_index()}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.sort_values()<\/td>\n<td>\u6309\u503c\u6392\u5e8f\u3002by \u6307\u5b9a\u5217&#xff0c;ascending \u63a7\u5236\u5347\u964d\u5e8f<\/td>\n<\/tr>\n<tr>\n<td>df.sort_index()<\/td>\n<td>\u6309\u7d22\u5f15\u6392\u5e8f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u9ed8\u8ba4\u5347\u5e8f<\/p>\n<\/li>\n<li>\n<p>\u8fd4\u56de\u65b0 DataFrame&#xff0c;\u4e0d\u4fee\u6539\u539f\u6570\u636e<\/p>\n<\/li>\n<\/ul>\n<h3 id=\"2.2.4.2%20%E6%98%93%E9%94%99%E7%82%B9%EF%BC%9A%E9%BB%98%E8%AE%A4%E4%B8%8D%E5%8E%9F%E5%9C%B0%EF%BC%8C%E9%9C%80%20inplace%20%E6%88%96%E9%87%8D%E6%96%B0%E8%B5%8B%E5%80%BC%20%5BL2%5D\">2.2.4.2 \u6613\u9519\u70b9&#xff1a;\u9ed8\u8ba4\u4e0d\u539f\u5730&#xff0c;\u9700 inplace \u6216\u91cd\u65b0\u8d4b\u503c [L2]<\/h3>\n<p># \u9519\u8bef&#xff1a;\u4ee5\u4e3a\u6392\u5e8f\u4f1a\u4fee\u6539\u539f DataFrame<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({&#034;age&#034;: [30, 25, 28]})<\/p>\n<p>df.sort_values(&#034;age&#034;)    # \u8fd4\u56de\u65b0 DataFrame&#xff0c;\u539f df \u672a\u53d8<br \/>\nprint(f&#034;\u539f df&#xff1a;\\\\n{df}&#034;)    # \u987a\u5e8f\u672a\u53d8<\/p>\n<p># \u6b63\u786e&#xff1a;\u91cd\u65b0\u8d4b\u503c<br \/>\ndf &#061; df.sort_values(&#034;age&#034;)<br \/>\nprint(f&#034;\\\\n\u91cd\u65b0\u8d4b\u503c\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u6216\u4f7f\u7528 inplace<br \/>\ndf.sort_values(&#034;age&#034;, inplace&#061;True) <\/p>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>sort_values \u9ed8\u8ba4\u8fd4\u56de\u65b0 DataFrame<\/p>\n<\/li>\n<li>\n<p>\u9700\u91cd\u65b0\u8d4b\u503c\u6216 inplace&#061;True<\/p>\n<\/li>\n<li>\n<p>\u63a8\u8350\u91cd\u65b0\u8d4b\u503c<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.2.5%20%E9%87%8D%E5%91%BD%E5%90%8D%E4%B8%8E%E5%88%97%E6%93%8D%E4%BD%9C\">2.2.5 \u91cd\u547d\u540d\u4e0e\u5217\u64cd\u4f5c<\/h4>\n<p># \u91cd\u547d\u540d\u4e0e\u5217\u64cd\u4f5c<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;],<br \/>\n    &#034;age&#034;: [25, 30]<br \/>\n})<\/p>\n<p># \u65b9\u5f0f\u4e00&#xff1a;rename<br \/>\ndf1 &#061; df.rename(columns&#061;{&#034;name&#034;: &#034;\u59d3\u540d&#034;, &#034;age&#034;: &#034;\u5e74\u9f84&#034;})<br \/>\nprint(f&#034;rename&#xff1a;\\\\n{df1}&#034;)<\/p>\n<p># \u65b9\u5f0f\u4e8c&#xff1a;\u76f4\u63a5\u8d4b\u503c columns<br \/>\ndf2 &#061; df.copy()<br \/>\ndf2.columns &#061; [&#034;\u59d3\u540d&#034;, &#034;\u5e74\u9f84&#034;]<br \/>\nprint(f&#034;\\\\n\u76f4\u63a5\u8d4b\u503c columns&#xff1a;\\\\n{df2}&#034;)<\/p>\n<p># \u67e5\u770b\u5217\u540d<br \/>\nprint(f&#034;\\\\n\u5217\u540d&#xff1a;{df.columns.tolist()}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.rename()<\/td>\n<td>\u91cd\u547d\u540d\u3002columns \u6307\u5b9a\u5217\u6620\u5c04&#xff0c;index \u6307\u5b9a\u7d22\u5f15\u6620\u5c04<\/td>\n<\/tr>\n<tr>\n<td>df.columns<\/td>\n<td>\u5217\u540d&#xff0c;\u53ef\u8d4b\u503c\u4fee\u6539<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>rename \u8fd4\u56de\u65b0 DataFrame<\/p>\n<\/li>\n<li>\n<p>columns \u76f4\u63a5\u8d4b\u503c\u4fee\u6539<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.2.6%20%E7%B1%BB%E5%9E%8B%E8%BD%AC%E6%8D%A2%20astype\">2.2.6 \u7c7b\u578b\u8f6c\u6362 astype<\/h4>\n<p>astype() \u7528\u4e8e\u8f6c\u6362\u6570\u636e\u7c7b\u578b&#xff0c;\u8fd4\u56de\u65b0 DataFrame\u3002<\/p>\n<p># \u7c7b\u578b\u8f6c\u6362 astype<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;age&#034;: [&#034;25&#034;, &#034;30&#034;, &#034;28&#034;],<br \/>\n    &#034;score&#034;: [85.5, 92.3, 78.8]<br \/>\n})<\/p>\n<p>print(f&#034;\u539f\u59cb\u7c7b\u578b&#xff1a;\\\\n{df.dtypes}&#034;)<\/p>\n<p># \u5b57\u7b26\u4e32\u8f6c\u6574\u6570<br \/>\ndf[&#034;age&#034;] &#061; df[&#034;age&#034;].astype(int)<br \/>\nprint(f&#034;\\\\n\u8f6c\u6362\u540e\u7c7b\u578b&#xff1a;\\\\n{df.dtypes}&#034;)<\/p>\n<p># \u6d6e\u70b9\u8f6c\u6574\u6570<br \/>\ndf[&#034;score_int&#034;] &#061; df[&#034;score&#034;].astype(int)<br \/>\nprint(f&#034;\\\\n\u8f6c\u6362\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u8f6c\u4e3a category&#xff08;\u8282\u7701\u5185\u5b58&#xff09;<br \/>\ndf[&#034;age_cat&#034;] &#061; df[&#034;age&#034;].astype(&#034;category&#034;)<br \/>\nprint(f&#034;\\\\ncategory \u7c7b\u578b&#xff1a;{df[&#039;age_cat&#039;].dtype}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df[\u5217].astype()<\/td>\n<td>\u8f6c\u6362\u5217\u7c7b\u578b\u3002\u53c2\u6570\u4e3a\u76ee\u6807\u7c7b\u578b&#xff0c;\u5982 int\u3001float\u3001str\u3001category<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>astype \u8fd4\u56de\u65b0 Series&#xff0c;\u9700\u91cd\u65b0\u8d4b\u503c<\/p>\n<\/li>\n<li>\n<p>\u6d6e\u70b9\u8f6c\u6574\u6570\u4f1a\u622a\u65ad\u5c0f\u6570<\/p>\n<\/li>\n<li>\n<p>category \u7c7b\u578b\u8282\u7701\u5185\u5b58<\/p>\n<\/li>\n<\/ul>\n<h3 id=\"2.3%20%E6%95%B0%E6%8D%AE%E8%AF%BB%E5%86%99%EF%BC%88%E6%95%B0%E6%8D%AE%E8%BF%9B%E5%87%BA%EF%BC%89\">2.3 \u6570\u636e\u8bfb\u5199&#xff08;\u6570\u636e\u8fdb\u51fa&#xff09;<\/h3>\n<h4 id=\"2.3.1%20%E6%A8%A1%E5%9E%8B%E8%BE%93%E5%87%BA%20%E2%86%92%20DataFrame\">2.3.1 \u6a21\u578b\u8f93\u51fa \u2192 DataFrame<\/h4>\n<p>\u5927\u6a21\u578b\u8f93\u51fa\u901a\u5e38\u4e3a JSON \u683c\u5f0f&#xff08;\u5217\u8868\u7684\u5b57\u5178\u3001\u5d4c\u5957\u5b57\u5178&#xff09;&#xff0c;\u9700\u8f6c\u4e3a DataFrame \u8fdb\u884c\u5206\u6790\u3002\u8fd9\u662f\u5927\u6a21\u578b\u8bc4\u6d4b\u3001badcase \u5206\u6790\u7684\u7b2c\u4e00\u6b65\u3002<\/p>\n<h4 id=\"2.3.2%20CSV\">2.3.2 CSV<\/h4>\n<p>CSV \u662f\u6700\u5e38\u7528\u7684\u6570\u636e\u5b58\u50a8\u683c\u5f0f&#xff0c;Pandas \u63d0\u4f9b read_csv \u548c to_csv \u8bfb\u5199\u3002<\/p>\n<p># CSV \u8bfb\u5199<\/p>\n<p>import pandas as pd<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u5199\u5165 CSV &#061;&#061;&#061;&#061;&#061;<br \/>\ndf &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;]<br \/>\n})<\/p>\n<p>df.to_csv(&#034;data.csv&#034;, index&#061;False, encoding&#061;&#034;utf-8&#034;)<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u8bfb\u53d6 CSV &#061;&#061;&#061;&#061;&#061;<br \/>\ndf2 &#061; pd.read_csv(&#034;data.csv&#034;, encoding&#061;&#034;utf-8&#034;)<br \/>\nprint(f&#034;\\\\n\u8bfb\u53d6\u7ed3\u679c&#xff1a;\\\\n{df2}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.to_csv()<\/td>\n<td>\u5199\u5165 CSV\u3002index&#061;False \u4e0d\u5199\u7d22\u5f15&#xff0c;encoding \u6307\u5b9a\u7f16\u7801<\/td>\n<\/tr>\n<tr>\n<td>pd.read_csv()<\/td>\n<td>\u8bfb\u53d6 CSV\u3002encoding \u6307\u5b9a\u7f16\u7801&#xff0c;sep \u6307\u5b9a\u5206\u9694\u7b26<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5e38\u7528\u53c2\u6570&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>index<\/td>\n<td>\u662f\u5426\u5199\u5165\u7d22\u5f15&#xff0c;\u9ed8\u8ba4 True<\/td>\n<\/tr>\n<tr>\n<td>encoding<\/td>\n<td>\u7f16\u7801&#xff0c;\u5e38\u7528 utf-8\u3001gbk<\/td>\n<\/tr>\n<tr>\n<td>sep<\/td>\n<td>\u5206\u9694\u7b26&#xff0c;\u9ed8\u8ba4 ,<\/td>\n<\/tr>\n<tr>\n<td>header<\/td>\n<td>\u662f\u5426\u6709\u8868\u5934&#xff0c;\u9ed8\u8ba4 0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.3.3%20JSON\">2.3.3 JSON<\/h4>\n<p>JSON \u662f API \u548c\u6a21\u578b\u8f93\u51fa\u7684\u5e38\u89c1\u683c\u5f0f&#xff0c;Pandas \u652f\u6301\u8bfb\u5199\u3002<\/p>\n<p># JSON \u8bfb\u5199<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;],<br \/>\n    &#034;age&#034;: [25, 30]<br \/>\n})<\/p>\n<p># \u5199\u5165 JSON<br \/>\ndf.to_json(&#034;data.json&#034;, orient&#061;&#034;records&#034;, force_ascii&#061;False)<\/p>\n<p># \u8bfb\u53d6 JSON<br \/>\ndf2 &#061; pd.read_json(&#034;data.json&#034;)<br \/>\nprint(f&#034;\\\\n\u8bfb\u53d6\u7ed3\u679c&#xff1a;\\\\n{df2}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.to_json()<\/td>\n<td>\u5199\u5165 JSON\u3002orient \u6307\u5b9a\u65b9\u5411&#xff0c;force_ascii&#061;False \u4fdd\u7559\u4e2d\u6587<\/td>\n<\/tr>\n<tr>\n<td>pd.read_json()<\/td>\n<td>\u8bfb\u53d6 JSON<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>orient \u53c2\u6570&#xff1a;<\/p>\n<table>\n<tr>\u503c\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>&#034;records&#034;<\/td>\n<td>\u5217\u8868\u7684\u5b57\u5178&#xff08;\u63a8\u8350&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>&#034;index&#034;<\/td>\n<td>\u5b57\u5178\u7684\u5b57\u5178<\/td>\n<\/tr>\n<tr>\n<td>&#034;columns&#034;<\/td>\n<td>\u5217\u5bfc\u5411<\/td>\n<\/tr>\n<tr>\n<td>&#034;values&#034;<\/td>\n<td>\u4ec5\u503c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.3.4%20MySQL%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89\">2.3.4 MySQL&#xff08;\u4e86\u89e3&#xff09;<\/h4>\n<p>Pandas \u53ef\u4ee5\u8bfb\u5199 MySQL \u6570\u636e\u5e93&#xff0c;\u9700\u914d\u5408 sqlalchemy \u6216 pymysql\u3002<\/p>\n<p>\u5b9e\u9645\u9879\u76ee\u4e2d\u4f7f\u7528\u8f83\u5c11&#xff0c;\u4e86\u89e3\u5373\u53ef\u3002<\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>pd.read_sql()<\/td>\n<td>\u8bfb\u53d6 SQL \u67e5\u8be2\u7ed3\u679c<\/td>\n<\/tr>\n<tr>\n<td>df.to_sql()<\/td>\n<td>\u5199\u5165\u6570\u636e\u5e93\u8868<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.3.5%20%E4%B8%8E%20NumPy%20%2F%20PyTorch%20%E4%BA%92%E8%BD%AC\">2.3.5 \u4e0e NumPy \/ PyTorch \u4e92\u8f6c<\/h4>\n<h5 id=\"2.3.5.1%20.values%20%2F%20.to_numpy()\">2.3.5.1 .values \/ .to_numpy()<\/h5>\n<p>DataFrame \u548c Series \u53ef\u4ee5\u8f6c\u4e3a NumPy \u6570\u7ec4&#xff0c;\u7528\u4e8e\u6570\u503c\u8ba1\u7b97\u3002<\/p>\n<p># \u4e0e NumPy \u4e92\u8f6c<\/p>\n<p>import pandas as pd<br \/>\nimport numpy as np<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;score&#034;: [85.5, 92.3, 78.8]<br \/>\n})<\/p>\n<p># \u65b9\u5f0f\u4e00&#xff1a;.values<br \/>\narr1 &#061; df.values<br \/>\nprint(f&#034;.values&#xff1a;\\\\n{arr1}&#034;)<br \/>\nprint(f&#034;\u7c7b\u578b&#xff1a;{type(arr1)}&#xff0c;dtype&#xff1a;{arr1.dtype}&#034;)<\/p>\n<p># \u65b9\u5f0f\u4e8c&#xff1a;.to_numpy()&#xff08;\u63a8\u8350&#xff09;<br \/>\narr2 &#061; df.to_numpy()<br \/>\nprint(f&#034;\\\\n.to_numpy()&#xff1a;\\\\n{arr2}&#034;)<\/p>\n<p># Series \u8f6c NumPy<br \/>\ns &#061; df[&#034;age&#034;]<br \/>\narr3 &#061; s.to_numpy()<br \/>\nprint(f&#034;\\\\nSeries.to_numpy()&#xff1a;{arr3}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.values<\/td>\n<td>\u8fd4\u56de NumPy \u6570\u7ec4&#xff08;\u65e7\u7248&#xff0c;\u4e0d\u63a8\u8350&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>df.to_numpy()<\/td>\n<td>\u8fd4\u56de NumPy \u6570\u7ec4&#xff08;\u63a8\u8350&#xff09;\u3002dtype \u6307\u5b9a\u7c7b\u578b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>.to_numpy() \u662f\u63a8\u8350\u65b9\u6cd5&#xff0c;.values \u662f\u65e7\u7248<\/p>\n<\/li>\n<li>\n<p>\u6df7\u5408 dtype \u7684 DataFrame \u8f6c\u4e3a NumPy \u4f1a\u7edf\u4e00\u4e3a object \u6216 float<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.3.5.2%20%E4%B8%8E%20PyTorch%20%E5%AF%B9%E6%8E%A5%E5%89%8D%E7%9A%84%20dtype%20%E6%B3%A8%E6%84%8F\">2.3.5.2 \u4e0e PyTorch \u5bf9\u63a5\u524d\u7684 dtype \u6ce8\u610f<\/h5>\n<p>Pandas \u2192 NumPy \u2192 PyTorch \u662f\u5927\u6a21\u578b\u6570\u636e\u5904\u7406\u7684\u5e38\u89c1\u94fe\u8def\u3002\u5173\u952e\u6ce8\u610f&#xff1a;NumPy \u9ed8\u8ba4 float64&#xff0c;PyTorch \u9ed8\u8ba4 float32\u3002<\/p>\n<p># \u4e0e PyTorch \u5bf9\u63a5<\/p>\n<p>import pandas as pd<br \/>\nimport numpy as np<br \/>\nimport torch<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;age&#034;: [25, 30, 28],<br \/>\n    &#034;score&#034;: [85.5, 92.3, 78.8]<br \/>\n})<\/p>\n<p># \u95ee\u9898&#xff1a;\u9ed8\u8ba4 float64<br \/>\narr &#061; df.to_numpy()<br \/>\ntensor &#061; torch.from_numpy(arr)<br \/>\nprint(f&#034;\u9ed8\u8ba4 dtype&#xff1a;{tensor.dtype}&#034;)    # torch.float64<\/p>\n<p># \u6b63\u786e&#xff1a;\u663e\u5f0f\u8f6c float32<br \/>\narr &#061; df.to_numpy(dtype&#061;np.float32)<br \/>\ntensor &#061; torch.from_numpy(arr)<br \/>\nprint(f&#034;\u8f6c\u6362\u540e dtype&#xff1a;{tensor.dtype}&#034;)    # torch.float32 <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.to_numpy(dtype&#061;&#8230;)<\/td>\n<td>\u8f6c\u4e3a\u6307\u5b9a dtype \u7684 NumPy \u6570\u7ec4<\/td>\n<\/tr>\n<tr>\n<td>torch.from_numpy()<\/td>\n<td>NumPy \u6570\u7ec4\u8f6c PyTorch \u5f20\u91cf&#xff08;\u5171\u4eab\u5185\u5b58&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>NumPy \u9ed8\u8ba4 float64&#xff0c;PyTorch \u9ed8\u8ba4 float32<\/p>\n<\/li>\n<li>\n<p>\u5bf9\u63a5\u524d\u9700\u663e\u5f0f\u8f6c\u6362<\/p>\n<\/li>\n<li>\n<p>\u5927\u6a21\u578b\u4e2d\u7edf\u4e00\u4f7f\u7528 float32<\/p>\n<\/li>\n<\/ul>\n<h3 id=\"2.4%20DataFrame%20%E8%BF%90%E7%AE%97\">2.4 DataFrame \u8fd0\u7b97<\/h3>\n<h4 id=\"2.4.1%20%E9%80%BB%E8%BE%91%E8%BF%90%E7%AE%97\">2.4.1 \u903b\u8f91\u8fd0\u7b97<\/h4>\n<p>Pandas \u7684\u903b\u8f91\u8fd0\u7b97\u7528\u4e8e\u7ec4\u5408\u591a\u4e2a\u6761\u4ef6&#xff0c;\u8fd4\u56de\u5e03\u5c14 Series\u3002<\/p>\n<table>\n<tr>\u8fd0\u7b97\u7b26\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>&amp;<\/td>\n<td>\u4e0e&#xff08;and&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>|<\/td>\n<td>\u6216&#xff08;or&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>~<\/td>\n<td>\u975e&#xff08;not&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u6ce8\u610f&#xff1a; \u5fc5\u987b\u7528 &amp;\u3001|\u3001~&#xff0c;\u4e0d\u80fd\u7528 and\u3001or\u3001not&#xff1b;\u4e14\u6bcf\u4e2a\u6761\u4ef6\u5fc5\u987b\u52a0\u62ec\u53f7\u3002<\/p>\n<p># \u903b\u8f91\u8fd0\u7b97<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;, &#034;\u8d75\u516d&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28, 35],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;, &#034;\u4e0a\u6d77&#034;]<br \/>\n})<\/p>\n<p># \u4e0e&#xff1a;&amp;<br \/>\nresult &#061; df[(df[&#034;age&#034;] &gt; 26) &amp; (df[&#034;city&#034;] &#061;&#061; &#034;\u4e0a\u6d77&#034;)]<br \/>\n# result &#061; df[(df[&#034;age&#034;] &gt; 26) and (df[&#034;city&#034;] &#061;&#061; &#034;\u4e0a\u6d77&#034;)] # ValueError<br \/>\nprint(f&#034;age &gt; 26 \u4e14 city &#061;&#061; \u4e0a\u6d77&#xff1a;\\\\n{result}&#034;)<\/p>\n<p># \u6216&#xff1a;|<br \/>\nresult &#061; df[(df[&#034;age&#034;] &gt; 30) | (df[&#034;city&#034;] &#061;&#061; &#034;\u676d\u5dde&#034;)]<br \/>\nprint(f&#034;\\\\nage &gt; 30 \u6216 city &#061;&#061; \u676d\u5dde&#xff1a;\\\\n{result}&#034;)<\/p>\n<p># \u975e&#xff1a;~<br \/>\nresult &#061; df[~(df[&#034;city&#034;] &#061;&#061; &#034;\u4e0a\u6d77&#034;)]<br \/>\nprint(f&#034;\\\\ncity !&#061; \u4e0a\u6d77&#xff1a;\\\\n{result}&#034;) <\/p>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>&amp; \u4e0e\u3001| \u6216\u3001~ \u975e<\/p>\n<\/li>\n<li>\n<p>\u6bcf\u4e2a\u6761\u4ef6\u5fc5\u987b\u52a0\u62ec\u53f7<\/p>\n<\/li>\n<li>\n<p>\u4e0d\u80fd\u7528 and\u3001or\u3001not<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.4.2%20%E7%BB%9F%E8%AE%A1%E8%BF%90%E7%AE%97\">2.4.2 \u7edf\u8ba1\u8fd0\u7b97<\/h4>\n<h4 id=\"2.4.2.1%20describe%20%2F%20mean%20%2F%20std%20%2F%20sum\">2.4.2.1 describe \/ mean \/ std \/ sum<\/h4>\n<p>Pandas \u63d0\u4f9b\u5e38\u7528\u7edf\u8ba1\u51fd\u6570&#xff0c;\u53ef\u5bf9\u6574\u8868\u6216\u6307\u5b9a\u5217\u8ba1\u7b97\u3002<\/p>\n<p># \u7edf\u8ba1\u8fd0\u7b97<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;age&#034;: [25, 30, 28, 35, 22],<br \/>\n    &#034;score&#034;: [85.5, 92.3, 78.8, 88.0, 95.5]<br \/>\n})<\/p>\n<p># describe&#xff1a;\u7efc\u5408\u7edf\u8ba1<br \/>\nprint(f&#034;describe&#xff1a;\\\\n{df.describe()}&#034;)<\/p>\n<p># \u5355\u5217\u7edf\u8ba1<br \/>\nprint(f&#034;\\\\nage \u5747\u503c&#xff1a;{df[&#039;age&#039;].mean():.2f}&#034;)<br \/>\nprint(f&#034;age \u6807\u51c6\u5dee&#xff1a;{df[&#039;age&#039;].std():.2f}&#034;)<br \/>\nprint(f&#034;age \u6c42\u548c&#xff1a;{df[&#039;age&#039;].sum()}&#034;)<\/p>\n<p># \u6309\u5217\u7edf\u8ba1<br \/>\nprint(f&#034;\\\\n\u5404\u5217\u5747\u503c&#xff1a;\\\\n{df.mean()}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.describe()<\/td>\n<td>\u7efc\u5408\u7edf\u8ba1&#xff0c;\u8fd4\u56de\u8ba1\u6570\u3001\u5747\u503c\u3001\u6807\u51c6\u5dee\u3001\u5206\u4f4d\u6570<\/td>\n<\/tr>\n<tr>\n<td>df.mean()<\/td>\n<td>\u5747\u503c<\/td>\n<\/tr>\n<tr>\n<td>df.std()<\/td>\n<td>\u6807\u51c6\u5dee<\/td>\n<\/tr>\n<tr>\n<td>df.sum()<\/td>\n<td>\u6c42\u548c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>describe \u4e00\u6b21\u6027\u8f93\u51fa\u591a\u4e2a\u7edf\u8ba1\u91cf<\/p>\n<\/li>\n<li>\n<p>\u5355\u5217\u7edf\u8ba1\u7528 df[&#034;\u5217&#034;].\u65b9\u6cd5()<\/p>\n<\/li>\n<li>\n<p>\u6309\u5217\u7edf\u8ba1\u7528 df.\u65b9\u6cd5()<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.4.2.2%20value_counts\">2.4.2.2 value_counts<\/h4>\n<p>value_counts() \u7528\u4e8e\u7edf\u8ba1\u6bcf\u4e2a\u503c\u51fa\u73b0\u7684\u6b21\u6570&#xff0c;\u5e38\u7528\u4e8e\u5206\u7c7b\u6570\u636e\u5206\u5e03\u5206\u6790\u3002<\/p>\n<p># value_counts<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;]<br \/>\n})<\/p>\n<p># \u7edf\u8ba1\u9891\u6b21<br \/>\nprint(f&#034;value_counts&#xff1a;\\\\n{df[&#039;city&#039;].value_counts()}&#034;)<\/p>\n<p># \u8f6c\u4e3a\u6bd4\u4f8b<br \/>\nprint(f&#034;\\\\n\u6bd4\u4f8b&#xff1a;\\\\n{df[&#039;city&#039;].value_counts(normalize&#061;True)}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>Series.value_counts()<\/td>\n<td>\u7edf\u8ba1\u6bcf\u4e2a\u503c\u7684\u51fa\u73b0\u6b21\u6570\u3002normalize&#061;True \u8fd4\u56de\u6bd4\u4f8b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u9ed8\u8ba4\u6309\u9891\u6b21\u964d\u5e8f<\/p>\n<\/li>\n<li>\n<p>normalize&#061;True \u8fd4\u56de\u6bd4\u4f8b<\/p>\n<\/li>\n<li>\n<p>\u5e38\u7528\u4e8e\u5206\u7c7b\u6570\u636e\u5206\u5e03\u5206\u6790<\/p>\n<\/li>\n<\/ul>\n<h3 id=\"2.5%20%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86\">2.5 \u6570\u636e\u5904\u7406<\/h3>\n<h4 id=\"2.5.1%20%E5%8E%BB%E9%87%8D%20drop_duplicates\">2.5.1 \u53bb\u91cd drop_duplicates<\/h4>\n<p>drop_duplicates() \u7528\u4e8e\u53bb\u9664\u91cd\u590d\u884c&#xff0c;\u53ef\u6307\u5b9a\u5217\u6216\u5168\u90e8\u5217\u3002<\/p>\n<p># \u53bb\u91cd<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u5f20\u4e09&#034;, &#034;\u738b\u4e94&#034;, &#034;\u674e\u56db&#034;],<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u5317\u4eac&#034;, &#034;\u676d\u5dde&#034;, &#034;\u5317\u4eac&#034;, &#034;\u4e0a\u6d77&#034;]<br \/>\n})<\/p>\n<p># \u5168\u90e8\u5217\u53bb\u91cd<br \/>\nprint(f&#034;\u539f\u59cb\u6570\u636e&#xff1a;\\\\n{df}&#034;)<br \/>\nprint(f&#034;\\\\n\u5168\u90e8\u5217\u53bb\u91cd&#xff1a;\\\\n{df.drop_duplicates()}&#034;) # \u884cSeries\u5bf9\u8c61\u5b8c\u5168\u76f8\u540c\u624d\u4f1a\u53bb\u9664<\/p>\n<p># \u6309\u6307\u5b9a\u5217\u53bb\u91cd&#xff08;\u4fdd\u7559\u7b2c\u4e00\u6761&#xff09;<br \/>\nprint(f&#034;\\\\n\u6309 name \u53bb\u91cd&#xff1a;\\\\n{df.drop_duplicates(subset&#061;[&#039;name&#039;])}&#034;) # \u6307\u5b9a\u5217\u5bf9\u5e94\u5143\u7d20\u76f8\u540c\u5c31\u53bb\u9664<\/p>\n<p># \u6309\u6307\u5b9a\u5217\u53bb\u91cd&#xff08;\u4fdd\u7559\u6700\u540e\u4e00\u6761&#xff09;<br \/>\nprint(f&#034;\\\\n\u6309 name \u53bb\u91cd&#xff08;\u4fdd\u7559\u6700\u540e&#xff09;&#xff1a;\\\\n{df.drop_duplicates(subset&#061;[&#039;name&#039;], keep&#061;&#039;last&#039;)}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>subset<\/td>\n<td>\u6307\u5b9a\u5217&#xff0c;\u9ed8\u8ba4\u5168\u90e8\u5217<\/td>\n<\/tr>\n<tr>\n<td>keep<\/td>\n<td>&#039;first&#039;&#xff08;\u9ed8\u8ba4&#xff09;\u4fdd\u7559\u7b2c\u4e00\u6761&#xff0c;&#039;last&#039; \u4fdd\u7559\u6700\u540e\u4e00\u6761&#xff0c;False \u5168\u90e8\u5220\u9664<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u9ed8\u8ba4\u5168\u90e8\u5217\u53bb\u91cd<\/p>\n<\/li>\n<li>\n<p>subset \u6307\u5b9a\u53bb\u91cd\u5217<\/p>\n<\/li>\n<li>\n<p>keep \u63a7\u5236\u4fdd\u7559\u54ea\u6761<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.5.2%20%E6%B7%BB%E5%8A%A0%20%2F%20%E5%88%A0%E9%99%A4%E5%88%97\">2.5.2 \u6dfb\u52a0 \/ \u5220\u9664\u5217<\/h4>\n<p># \u6dfb\u52a0 \/ \u5220\u9664\u5217<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;age&#034;: [25, 30, 28]<br \/>\n})<\/p>\n<p># assign&#xff1a;\u65b0\u589e\u5217<br \/>\ndf1 &#061; df.assign(age_plus_10&#061;df[&#034;age&#034;] &#043; 10)<br \/>\nprint(f&#034;assign \u65b0\u589e\u5217&#xff1a;\\\\n{df1}&#034;)<\/p>\n<p># \u94fe\u5f0f assign<br \/>\ndf2 &#061; df.assign(<br \/>\n    age_plus_10&#061;df[&#034;age&#034;] &#043; 10,<br \/>\n    is_adult&#061;df[&#034;age&#034;] &gt;&#061; 18<br \/>\n)<br \/>\nprint(f&#034;\\\\n\u94fe\u5f0f assign&#xff1a;\\\\n{df2}&#034;)<\/p>\n<p># drop&#xff1a;\u5220\u9664\u5217<br \/>\ndf3 &#061; df.drop(columns&#061;[&#034;age&#034;])<br \/>\nprint(f&#034;\\\\ndrop \u5220\u9664\u5217&#xff1a;\\\\n{df3}&#034;)<\/p>\n<p># drop&#xff1a;\u5220\u9664\u884c<br \/>\ndf4 &#061; df.drop(index&#061;[0, 2])<br \/>\nprint(f&#034;\\\\ndrop \u5220\u9664\u884c&#xff1a;\\\\n{df4}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.assign()<\/td>\n<td>\u65b0\u589e\u5217\u3002\u53c2\u6570\u4e3a \u5217\u540d&#061;\u503c&#xff0c;\u8fd4\u56de\u65b0 DataFrame<\/td>\n<\/tr>\n<tr>\n<td>df.drop()<\/td>\n<td>\u5220\u9664\u5217\u6216\u884c\u3002columns \u6307\u5b9a\u5217&#xff0c;index \u6307\u5b9a\u884c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>assign \u8fd4\u56de\u65b0 DataFrame&#xff0c;\u53ef\u94fe\u5f0f\u8c03\u7528<\/p>\n<\/li>\n<li>\n<p>drop \u8fd4\u56de\u65b0 DataFrame<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.5.3%20%E7%BC%BA%E5%A4%B1%E5%80%BC%E5%A4%84%E7%90%86\">2.5.3 \u7f3a\u5931\u503c\u5904\u7406<\/h4>\n<p># \u7f3a\u5931\u503c\u5904\u7406<\/p>\n<p>import pandas as pd<br \/>\nimport numpy as np<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;, &#034;\u8d75\u516d&#034;],<br \/>\n    &#034;age&#034;: [25, np.nan, 28, 35],<br \/>\n    &#034;score&#034;: [85, 92, np.nan, 88]<br \/>\n})<\/p>\n<p>print(f&#034;\u539f\u59cb\u6570\u636e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># isnull&#xff1a;\u5224\u65ad\u7f3a\u5931<br \/>\nprint(f&#034;\\\\n\u662f\u5426\u7f3a\u5931&#xff1a;\\\\n{df.isnull()}&#034;)<\/p>\n<p># \u7edf\u8ba1\u7f3a\u5931\u6570<br \/>\nprint(f&#034;\\\\n\u7f3a\u5931\u6570&#xff1a;\\\\n{df.isnull().sum()}&#034;)<\/p>\n<p># dropna&#xff1a;\u5220\u9664\u7f3a\u5931\u884c<br \/>\nprint(f&#034;\\\\n\u5220\u9664\u7f3a\u5931\u884c&#xff1a;\\\\n{df.dropna()}&#034;)<\/p>\n<p># fillna&#xff1a;\u586b\u5145\u7f3a\u5931\u503c<br \/>\nprint(f&#034;\\\\n\u586b\u5145 0&#xff1a;\\\\n{df.fillna(0)}&#034;)<\/p>\n<p># \u7528\u5747\u503c\u586b\u5145<br \/>\nprint(f&#034;\\\\n\u7528\u5747\u503c\u586b\u5145&#xff1a;\\\\n{df.fillna(df.mean(numeric_only&#061;True))}&#034;)<\/p>\n<p>print(f&#034;\u539f\u59cb\u6570\u636e&#xff1a;\\\\n{df}&#034;) # \u4e0d\u4f1a\u4fee\u6539\u539f\u6570\u636e <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.isnull()<\/td>\n<td>\u5224\u65ad\u662f\u5426\u7f3a\u5931&#xff0c;\u8fd4\u56de\u5e03\u5c14 DataFrame<\/td>\n<\/tr>\n<tr>\n<td>df.dropna()<\/td>\n<td>\u5220\u9664\u7f3a\u5931\u503c\u3002axis \u6307\u5b9a\u8f74&#xff0c;how \u6307\u5b9a\u6761\u4ef6<\/td>\n<\/tr>\n<tr>\n<td>df.fillna()<\/td>\n<td>\u586b\u5145\u7f3a\u5931\u503c\u3002\u53c2\u6570\u4e3a\u586b\u5145\u503c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>isnull() \u8fd4\u56de\u5e03\u5c14 DataFrame<\/p>\n<\/li>\n<li>\n<p>dropna() \u5220\u9664\u542b\u7f3a\u5931\u503c\u7684\u884c<\/p>\n<\/li>\n<li>\n<p>fillna() \u586b\u5145\u7f3a\u5931\u503c<\/p>\n<\/li>\n<li>\n<p>\u4e0d\u4f1a\u4fee\u6539\u539f\u6570\u636e&#xff0c;\u8fd4\u56de\u65b0\u7684DataFrame\u5bf9\u8c61<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.5.4%20%E6%95%B0%E6%8D%AE%E5%90%88%E5%B9%B6\">2.5.4 \u6570\u636e\u5408\u5e76<\/h4>\n<h4 id=\"2.5.4.1%20merge%EF%BC%88%E9%94%AE%E8%BF%9E%E6%8E%A5%EF%BC%89\">2.5.4.1 merge&#xff08;\u952e\u8fde\u63a5&#xff09;<\/h4>\n<p>merge \u7528\u4e8e\u6309\u952e\u8fde\u63a5\u4e24\u4e2a DataFrame&#xff0c;\u7c7b\u4f3c SQL \u7684 JOIN\u3002<\/p>\n<p># merge&#xff1a;\u952e\u8fde\u63a5<\/p>\n<p>import pandas as pd<\/p>\n<p>df1 &#061; pd.DataFrame({<br \/>\n    &#034;id&#034;: [1, 2, 3],<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;]<br \/>\n})<\/p>\n<p>df2 &#061; pd.DataFrame({<br \/>\n    &#034;id&#034;: [2, 3, 4],<br \/>\n    &#034;score&#034;: [85, 92, 78]<br \/>\n})<\/p>\n<p># \u5185\u8fde\u63a5&#xff1a;\u53ea\u4fdd\u7559\u4e24\u8868\u90fd\u6709\u7684\u952e<br \/>\ninner &#061; pd.merge(df1, df2, on&#061;&#034;id&#034;, how&#061;&#034;inner&#034;)<br \/>\nprint(f&#034;\u5185\u8fde\u63a5&#xff1a;\\\\n{inner}&#034;)<\/p>\n<p># \u5de6\u8fde\u63a5&#xff1a;\u4fdd\u7559\u5de6\u8868\u6240\u6709\u952e<br \/>\nleft &#061; pd.merge(df1, df2, on&#061;&#034;id&#034;, how&#061;&#034;left&#034;)<br \/>\nprint(f&#034;\\\\n\u5de6\u8fde\u63a5&#xff1a;\\\\n{left}&#034;)<\/p>\n<p># \u5916\u8fde\u63a5&#xff1a;\u4fdd\u7559\u6240\u6709\u952e<br \/>\nouter &#061; pd.merge(df1, df2, on&#061;&#034;id&#034;, how&#061;&#034;outer&#034;)<br \/>\nprint(f&#034;\\\\n\u5916\u8fde\u63a5&#xff1a;\\\\n{outer}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>on<\/td>\n<td>\u8fde\u63a5\u952e&#xff0c;\u5217\u540d<\/td>\n<\/tr>\n<tr>\n<td>how<\/td>\n<td>\u8fde\u63a5\u65b9\u5f0f&#xff1a;inner\u3001left\u3001right\u3001outer<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>inner&#xff1a;\u53ea\u4fdd\u7559\u4e24\u8868\u90fd\u6709\u7684\u952e<\/p>\n<\/li>\n<li>\n<p>left&#xff1a;\u4fdd\u7559\u5de6\u8868\u6240\u6709\u952e<\/p>\n<\/li>\n<li>\n<p>outer&#xff1a;\u4fdd\u7559\u6240\u6709\u952e<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.5.4.2%20concat%EF%BC%88%E5%A0%86%E5%8F%A0%EF%BC%89\">2.5.4.2 concat&#xff08;\u5806\u53e0&#xff09;<\/h5>\n<p>concat \u7528\u4e8e\u5806\u53e0\u591a\u4e2a DataFrame&#xff0c;\u6cbf\u884c\u6216\u5217\u65b9\u5411\u3002<\/p>\n<p># concat&#xff1a;\u5806\u53e0<\/p>\n<p>import pandas as pd<\/p>\n<p>df1 &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;],<br \/>\n    &#034;age&#034;: [25, 30]<br \/>\n})<\/p>\n<p>df2 &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u738b\u4e94&#034;, &#034;\u8d75\u516d&#034;],<br \/>\n    &#034;age&#034;: [28, 35]<br \/>\n})<\/p>\n<p># \u6cbf\u884c\u5806\u53e0&#xff08;\u4e0a\u4e0b&#xff09;<br \/>\nrow_concat &#061; pd.concat([df1, df2], axis&#061;0, ignore_index&#061;True)<br \/>\nprint(f&#034;\u6cbf\u884c\u5806\u53e0&#xff1a;\\\\n{row_concat}&#034;)<\/p>\n<p># \u6cbf\u5217\u5806\u53e0&#xff08;\u5de6\u53f3&#xff09;<br \/>\ncol_concat &#061; pd.concat([df1, df2], axis&#061;1)<br \/>\nprint(f&#034;\\\\n\u6cbf\u5217\u5806\u53e0&#xff1a;\\\\n{col_concat}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>axis<\/td>\n<td>0 \u6cbf\u884c\u5806\u53e0&#xff0c;1 \u6cbf\u5217\u5806\u53e0<\/td>\n<\/tr>\n<tr>\n<td>ignore_index<\/td>\n<td>\u662f\u5426\u91cd\u7f6e\u7d22\u5f15<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>axis&#061;0 \u4e0a\u4e0b\u5806\u53e0<\/p>\n<\/li>\n<li>\n<p>axis&#061;1 \u5de6\u53f3\u5806\u53e0<\/p>\n<\/li>\n<li>\n<p>ignore_index&#061;True \u91cd\u7f6e\u7d22\u5f15<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.5.5%20%E6%95%B0%E6%8D%AE%E5%88%86%E7%BB%84%E4%B8%8E%E8%81%9A%E5%90%88\">2.5.5 \u6570\u636e\u5206\u7ec4\u4e0e\u805a\u5408<\/h4>\n<h5 id=\"2.5.5.1%20groupby%20%E5%9F%BA%E7%A1%80\">2.5.5.1 groupby \u57fa\u7840<\/h5>\n<p>groupby \u662f Pandas \u6700\u5f3a\u5927\u7684\u529f\u80fd\u4e4b\u4e00&#xff0c;\u7528\u4e8e\u6309\u67d0\u4e2a\u952e\u5206\u7ec4&#xff0c;\u7136\u540e\u5bf9\u6bcf\u7ec4\u505a\u805a\u5408\u8fd0\u7b97\u3002<\/p>\n<p>\u6838\u5fc3\u6d41\u7a0b&#xff1a; \u62c6\u5206&#xff08;split&#xff09;\u2192 \u5e94\u7528&#xff08;apply&#xff09;\u2192 \u5408\u5e76&#xff08;combine&#xff09;<\/p>\n<p># groupby \u57fa\u7840<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;, &#034;\u676d\u5dde&#034;],<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;, &#034;\u8d75\u516d&#034;, &#034;\u94b1\u4e03&#034;, &#034;\u5b59\u516b&#034;],<br \/>\n    &#034;score&#034;: [85, 92, 78, 88, 95, 90]<br \/>\n})<\/p>\n<p># \u6309 city \u5206\u7ec4&#xff0c;\u6c42 score \u5747\u503c<br \/>\ngrouped &#061; df.groupby(&#034;city&#034;)[&#034;score&#034;].mean()<br \/>\nprint(f&#034;\u6309 city \u5206\u7ec4\u6c42\u5747\u503c&#xff1a;\\\\n{grouped}&#034;)<\/p>\n<p># \u6309 city \u5206\u7ec4&#xff0c;\u6c42\u591a\u4e2a\u7edf\u8ba1\u91cf<br \/>\nprint(f&#034;\\\\n\u6309 city \u5206\u7ec4&#xff0c;\u591a\u4e2a\u7edf\u8ba1\u91cf&#xff1a;\\\\n{df.groupby(&#039;city&#039;)[&#039;score&#039;].agg([&#039;mean&#039;, &#039;max&#039;, &#039;min&#039;])}&#034;)<\/p>\n<p># \u6309 city \u5206\u7ec4&#xff0c;\u7edf\u8ba1\u4eba\u6570<br \/>\nprint(f&#034;\\\\n\u6309 city \u5206\u7ec4&#xff0c;\u7edf\u8ba1\u4eba\u6570&#xff1a;\\\\n{df.groupby(&#039;city&#039;).size()}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.groupby(&#034;\u5217&#034;)<\/td>\n<td>\u6309\u5217\u5206\u7ec4&#xff0c;\u8fd4\u56de GroupBy \u5bf9\u8c61<\/td>\n<\/tr>\n<tr>\n<td>.agg([&#8230;])<\/td>\n<td>\u591a\u4e2a\u805a\u5408\u51fd\u6570<\/td>\n<\/tr>\n<tr>\n<td>.size()<\/td>\n<td>\u7edf\u8ba1\u6bcf\u7ec4\u6570\u91cf<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>groupby \u8fd4\u56de GroupBy \u5bf9\u8c61&#xff0c;\u9700\u63a5\u805a\u5408\u51fd\u6570<\/p>\n<\/li>\n<li>\n<p>agg \u53ef\u4e00\u6b21\u8ba1\u7b97\u591a\u4e2a\u7edf\u8ba1\u91cf<\/p>\n<\/li>\n<li>\n<p>size \u7edf\u8ba1\u6bcf\u7ec4\u884c\u6570<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.5.5.2%20agg%20%E5%A4%9A%E8%81%9A%E5%90%88%C2%A0\">2.5.5.2 agg \u591a\u805a\u5408\u00a0<\/h5>\n<p>agg \u7528\u4e8e\u5bf9\u5206\u7ec4\u6570\u636e\u540c\u65f6\u5e94\u7528\u591a\u4e2a\u805a\u5408\u51fd\u6570\u3002<\/p>\n<p># agg \u591a\u805a\u5408<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;],<br \/>\n    &#034;score&#034;: [85, 92, 78, 88, 95],<br \/>\n    &#034;age&#034;: [25, 30, 28, 35, 22]<br \/>\n})<\/p>\n<p># \u591a\u4e2a\u805a\u5408\u51fd\u6570<br \/>\nresult &#061; df.groupby(&#034;city&#034;).agg({<br \/>\n    &#034;score&#034;: [&#034;mean&#034;, &#034;max&#034;, &#034;min&#034;],<br \/>\n    &#034;age&#034;: &#034;mean&#034;<br \/>\n})<br \/>\nprint(f&#034;\u591a\u805a\u5408&#xff1a;\\\\n{result}&#034;)<\/p>\n<p># \u547d\u540d\u805a\u5408&#xff08;\u63a8\u8350&#xff09;<br \/>\nresult2 &#061; df.groupby(&#034;city&#034;).agg(<br \/>\n    score_mean&#061;(&#034;score&#034;, &#034;mean&#034;),<br \/>\n    score_max&#061;(&#034;score&#034;, &#034;max&#034;),<br \/>\n    age_mean&#061;(&#034;age&#034;, &#034;mean&#034;)<br \/>\n)<br \/>\nprint(f&#034;\\\\n\u547d\u540d\u805a\u5408&#xff1a;\\\\n{result2}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>agg(\u5b57\u5178)<\/td>\n<td>\u5bf9\u4e0d\u540c\u5217\u5e94\u7528\u4e0d\u540c\u805a\u5408\u51fd\u6570<\/td>\n<\/tr>\n<tr>\n<td>agg(\u547d\u540d\u5143\u7ec4)<\/td>\n<td>\u547d\u540d\u805a\u5408&#xff0c;\u63a8\u8350<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u5b57\u5178\u5f62\u5f0f&#xff1a;{&#034;\u5217&#034;: [&#034;\u51fd\u65701&#034;, &#034;\u51fd\u65702&#034;]}<\/p>\n<\/li>\n<li>\n<p>\u547d\u540d\u805a\u5408&#xff1a;\u65b0\u5217\u540d&#061;(&#034;\u5217&#034;, &#034;\u51fd\u6570&#034;)<\/p>\n<\/li>\n<li>\n<p>\u547d\u540d\u805a\u5408\u66f4\u6e05\u6670<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.5.5.3%20reset_index%C2%A0\">2.5.5.3 reset_index\u00a0<\/h5>\n<p>groupby \u7684\u7ed3\u679c\u7d22\u5f15\u662f\u5206\u7ec4\u952e&#xff0c;\u7528 reset_index() \u53ef\u5c06\u5206\u7ec4\u952e\u8f6c\u4e3a\u5217\u3002<\/p>\n<p># reset_index<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;city&#034;: [&#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u676d\u5dde&#034;, &#034;\u4e0a\u6d77&#034;, &#034;\u5317\u4eac&#034;],<br \/>\n    &#034;score&#034;: [85, 92, 78, 88, 95]<br \/>\n})<\/p>\n<p># groupby \u7ed3\u679c&#xff1a;\u7d22\u5f15\u662f city<br \/>\ngrouped &#061; df.groupby(&#034;city&#034;)[&#034;score&#034;].mean()<br \/>\nprint(f&#034;\u672a reset_index&#xff1a;\\\\n{grouped}&#034;)<br \/>\nprint(f&#034;\u7d22\u5f15&#xff1a;{grouped.index.tolist()}&#034;)<\/p>\n<p># reset_index&#xff1a;\u7d22\u5f15\u8f6c\u4e3a\u5217<br \/>\ngrouped_reset &#061; grouped.reset_index()<br \/>\nprint(f&#034;\\\\nreset_index \u540e&#xff1a;\\\\n{grouped_reset}&#034;)<br \/>\nprint(f&#034;\u5217\u540d&#xff1a;{grouped_reset.columns.tolist()}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>.reset_index()<\/td>\n<td>\u5c06\u7d22\u5f15\u8f6c\u4e3a\u5217&#xff0c;\u8fd4\u56de\u65b0 DataFrame<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>groupby \u7ed3\u679c\u7d22\u5f15\u662f\u5206\u7ec4\u952e<\/p>\n<\/li>\n<li>\n<p>reset_index() \u5c06\u7d22\u5f15\u8f6c\u4e3a\u5217<\/p>\n<\/li>\n<li>\n<p>\u65b9\u4fbf\u540e\u7eed\u5904\u7406<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.5.6%20%E6%96%87%E6%9C%AC%E5%A4%84%E7%90%86\">2.5.6 \u6587\u672c\u5904\u7406<\/h4>\n<h5 id=\"2.5.6.1%20str%20%E8%AE%BF%E9%97%AE%E5%99%A8\">2.5.6.1 str \u8bbf\u95ee\u5668<\/h5>\n<p>str \u8bbf\u95ee\u5668\u7528\u4e8e\u5bf9\u5b57\u7b26\u4e32\u5217\u8fdb\u884c\u5411\u91cf\u5316\u64cd\u4f5c&#xff0c;\u5982\u5927\u5c0f\u5199\u3001\u66ff\u6362\u3001\u5207\u5206\u3002<\/p>\n<p># str \u8bbf\u95ee\u5668<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;, &#034;\u738b\u4e94&#034;],<br \/>\n    &#034;email&#034;: [&#034;ZhangSan&#064;example.com&#034;, &#034;LiSi&#064;test.com&#034;, &#034;WangWu&#064;demo.com&#034;]<br \/>\n})<\/p>\n<p># \u5927\u5199<br \/>\nprint(f&#034;\u5927\u5199&#xff1a;\\\\n{df[&#039;email&#039;].str.upper()}&#034;)<\/p>\n<p># \u5c0f\u5199<br \/>\nprint(f&#034;\\\\n\u5c0f\u5199&#xff1a;\\\\n{df[&#039;email&#039;].str.lower()}&#034;)<\/p>\n<p># \u5305\u542b\u5224\u65ad<br \/>\nprint(f&#034;\\\\n\u5305\u542b example&#xff1a;\\\\n{df[&#039;email&#039;].str.contains(&#039;example&#039;)}&#034;)<\/p>\n<p># \u66ff\u6362<br \/>\nprint(f&#034;\\\\n\u66ff\u6362&#xff1a;\\\\n{df[&#039;email&#039;].str.replace(&#039;.com&#039;, &#039;.cn&#039;)}&#034;)<\/p>\n<p># \u5207\u5206<br \/>\nprint(f&#034;\\\\n\u5207\u5206&#xff1a;\\\\n{df[&#039;email&#039;].str.split(&#039;&#064;&#039;)}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>.str.upper()<\/td>\n<td>\u8f6c\u5927\u5199<\/td>\n<\/tr>\n<tr>\n<td>.str.lower()<\/td>\n<td>\u8f6c\u5c0f\u5199<\/td>\n<\/tr>\n<tr>\n<td>.str.contains()<\/td>\n<td>\u5305\u542b\u5224\u65ad<\/td>\n<\/tr>\n<tr>\n<td>.str.replace()<\/td>\n<td>\u66ff\u6362<\/td>\n<\/tr>\n<tr>\n<td>.str.split()<\/td>\n<td>\u5207\u5206<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>str \u8bbf\u95ee\u5668\u7528\u4e8e\u5b57\u7b26\u4e32\u5217<\/p>\n<\/li>\n<li>\n<p>\u5411\u91cf\u5316\u64cd\u4f5c&#xff0c;\u6bd4 apply \u5feb<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.5.6.2%20apply%20%2F%20map%20%2F%20applymap%20%E5%8C%BA%E5%88%86\">2.5.6.2 apply \/ map \/ applymap \u533a\u5206<\/h5>\n<table>\n<tr>\u65b9\u6cd5\u4f5c\u7528\u5bf9\u8c61\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>apply<\/td>\n<td>\u884c\/\u5217<\/td>\n<td>\u5bf9\u6bcf\u884c\u6216\u6bcf\u5217\u5e94\u7528\u51fd\u6570<\/td>\n<\/tr>\n<tr>\n<td>map<\/td>\n<td>Series<\/td>\n<td>\u5bf9\u6bcf\u4e2a\u5143\u7d20\u5e94\u7528\u51fd\u6570<\/td>\n<\/tr>\n<tr>\n<td>applymap<\/td>\n<td>DataFrame<\/td>\n<td>\u5bf9\u6bcf\u4e2a\u5143\u7d20\u5e94\u7528\u51fd\u6570<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p># apply \/ map \/ applymap<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;name&#034;: [&#034;\u5f20\u4e09&#034;, &#034;\u674e\u56db&#034;],<br \/>\n    &#034;score&#034;: [85, 92]<br \/>\n})<\/p>\n<p># apply&#xff1a;\u5bf9\u5217\u5e94\u7528<br \/>\nprint(f&#034;apply \u5bf9\u5217&#xff1a;\\\\n{df[[&#039;score&#039;]].apply(lambda x: x.max())}&#034;)<\/p>\n<p># map&#xff1a;\u5bf9 Series \u6bcf\u4e2a\u5143\u7d20<br \/>\nprint(f&#034;\\\\nmap&#xff1a;\\\\n{df[&#039;name&#039;].map(lambda x: f&#039;\u5b66\u751f-{x}&#039;)}&#034;)<\/p>\n<p># applymap&#xff1a;\u5bf9 DataFrame \u6bcf\u4e2a\u5143\u7d20<br \/>\nprint(f&#034;\\\\napplymap&#xff1a;\\\\n{df.applymap(lambda x: str(x)&#043;&#034;test&#034;)}&#034;) <\/p>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>apply \u4f5c\u7528\u4e8e\u884c\/\u5217<\/p>\n<\/li>\n<li>\n<p>map \u4f5c\u7528\u4e8e Series \u5143\u7d20<\/p>\n<\/li>\n<li>\n<p>applymap \u4f5c\u7528\u4e8e DataFrame \u5143\u7d20<\/p>\n<\/li>\n<\/ul>\n<h5 id=\"2.5.6.3%20%E6%8B%86%E5%88%86%E5%88%97%20split%20%2F%20str.split\">2.5.6.3 \u62c6\u5206\u5217 split \/ str.split<\/h5>\n<p>str.split() \u7528\u4e8e\u62c6\u5206\u5b57\u7b26\u4e32\u5217&#xff0c;\u53ef\u914d\u5408 expand&#061;True \u62c6\u4e3a\u591a\u5217\u3002<\/p>\n<p># \u62c6\u5206\u5217<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;info&#034;: [&#034;\u5f20\u4e09-25-\u676d\u5dde&#034;, &#034;\u674e\u56db-30-\u4e0a\u6d77&#034;, &#034;\u738b\u4e94-28-\u5317\u4eac&#034;]<br \/>\n})<\/p>\n<p># \u62c6\u5206\u4e3a\u591a\u5217<br \/>\nsplit_df &#061; df[&#034;info&#034;].str.split(&#034;-&#034;, expand&#061;True)<br \/>\nsplit_df.columns &#061; [&#034;name&#034;, &#034;age&#034;, &#034;city&#034;]<br \/>\nprint(f&#034;\u62c6\u5206\u540e&#xff1a;\\\\n{split_df}&#034;)<\/p>\n<p># \u5408\u5e76\u5230\u539f DataFrame<br \/>\ndf &#061; pd.concat([df, split_df], axis&#061;1)<br \/>\nprint(f&#034;\\\\n\u5408\u5e76\u540e&#xff1a;\\\\n{df}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>str.split(sep)<\/td>\n<td>\u6309\u5206\u9694\u7b26\u62c6\u5206<\/td>\n<\/tr>\n<tr>\n<td>expand&#061;True<\/td>\n<td>\u62c6\u4e3a\u591a\u5217<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a; expand&#061;True \u62c6\u4e3a\u591a\u5217&#xff0c;\u5426\u5219\u8fd4\u56de\u5217\u8868\u3002<\/p>\n<h4 id=\"2.5.7%20%E9%9A%8F%E6%9C%BA%E9%87%87%E6%A0%B7\">2.5.7 \u968f\u673a\u91c7\u6837<\/h4>\n<p>sample() \u7528\u4e8e\u968f\u673a\u91c7\u6837&#xff0c;\u5e38\u7528\u4e8e\u6570\u636e\u96c6\u5212\u5206\u3001\u62bd\u6837\u5206\u6790\u3002<\/p>\n<p># \u968f\u673a\u91c7\u6837<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;id&#034;: range(1, 11),<br \/>\n    &#034;score&#034;: [85, 92, 78, 88, 95, 90, 82, 87, 91, 86]<br \/>\n})<\/p>\n<p># \u968f\u673a\u53d6 3 \u6761<br \/>\nprint(f&#034;\u968f\u673a\u53d6 3 \u6761&#xff1a;\\\\n{df.sample(n&#061;3, random_state&#061;42)}&#034;)<\/p>\n<p># \u968f\u673a\u53d6 30%<br \/>\nprint(f&#034;\\\\n\u968f\u673a\u53d6 30%&#xff1a;\\\\n{df.sample(frac&#061;0.3, random_state&#061;42)}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>n<\/td>\n<td>\u91c7\u6837\u6570\u91cf<\/td>\n<\/tr>\n<tr>\n<td>frac<\/td>\n<td>\u91c7\u6837\u6bd4\u4f8b<\/td>\n<\/tr>\n<tr>\n<td>random_state<\/td>\n<td>\u968f\u673a\u79cd\u5b50&#xff0c;\u4fdd\u8bc1\u53ef\u590d\u73b0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a; random_state \u4fdd\u8bc1\u7ed3\u679c\u53ef\u590d\u73b0\u3002<\/p>\n<h4 id=\"2.5.8%20%E6%97%B6%E9%97%B4%E5%BA%8F%E5%88%97%E5%9F%BA%E7%A1%80\">2.5.8 \u65f6\u95f4\u5e8f\u5217\u57fa\u7840<\/h4>\n<p>to_datetime() \u7528\u4e8e\u5c06\u5b57\u7b26\u4e32\u8f6c\u4e3a\u65f6\u95f4\u7c7b\u578b&#xff0c;dt \u8bbf\u95ee\u5668\u7528\u4e8e\u63d0\u53d6\u65f6\u95f4\u5c5e\u6027\u3002<\/p>\n<p># \u65f6\u95f4\u5e8f\u5217\u57fa\u7840<\/p>\n<p>import pandas as pd<\/p>\n<p>df &#061; pd.DataFrame({<br \/>\n    &#034;date&#034;: [&#034;2024-01-15&#034;, &#034;2024-02-20&#034;, &#034;2024-03-25&#034;],<br \/>\n    &#034;score&#034;: [85, 92, 78]<br \/>\n})<\/p>\n<p># \u8f6c\u4e3a\u65f6\u95f4\u7c7b\u578b<br \/>\ndf[&#034;date&#034;] &#061; pd.to_datetime(df[&#034;date&#034;])<br \/>\nprint(f&#034;\u8f6c\u6362\u540e\u7c7b\u578b&#xff1a;{df[&#039;date&#039;].dtype}&#034;)<\/p>\n<p># dt \u8bbf\u95ee\u5668<br \/>\ndf[&#034;year&#034;] &#061; df[&#034;date&#034;].dt.year<br \/>\ndf[&#034;month&#034;] &#061; df[&#034;date&#034;].dt.month<br \/>\ndf[&#034;day&#034;] &#061; df[&#034;date&#034;].dt.day<br \/>\nprint(f&#034;\\\\n\u63d0\u53d6\u5e74\u6708\u65e5&#xff1a;\\\\n{df}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>pd.to_datetime()<\/td>\n<td>\u8f6c\u4e3a\u65f6\u95f4\u7c7b\u578b<\/td>\n<\/tr>\n<tr>\n<td>.dt.year<\/td>\n<td>\u63d0\u53d6\u5e74\u4efd<\/td>\n<\/tr>\n<tr>\n<td>.dt.month<\/td>\n<td>\u63d0\u53d6\u6708\u4efd<\/td>\n<\/tr>\n<tr>\n<td>.dt.day<\/td>\n<td>\u63d0\u53d6\u65e5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 id=\"2.5.9%20%E9%80%8F%E8%A7%86%E8%A1%A8%E4%B8%8E%E4%BA%A4%E5%8F%89%E8%A1%A8%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89\">2.5.9 \u900f\u89c6\u8868\u4e0e\u4ea4\u53c9\u8868&#xff08;\u4e86\u89e3&#xff09;<\/h4>\n<table>\n<tr>\u6982\u5ff5\u8bf4\u660e\u7c7b\u6bd4<\/tr>\n<tbody>\n<tr>\n<td>\u900f\u89c6\u8868&#xff08;pivot_table&#xff09;<\/td>\n<td>\u5bf9\u6570\u636e\u8fdb\u884c\u591a\u7ef4\u6c47\u603b&#xff0c;\u53ef\u6307\u5b9a\u503c\u5217\u3001\u884c\u3001\u5217\u548c\u805a\u5408\u51fd\u6570<\/td>\n<td>\u7c7b\u4f3c Excel \u6570\u636e\u900f\u89c6\u8868<\/td>\n<\/tr>\n<tr>\n<td>\u4ea4\u53c9\u8868&#xff08;crosstab&#xff09;<\/td>\n<td>\u7edf\u8ba1\u4e24\u4e2a\u5206\u7c7b\u53d8\u91cf\u7684\u9891\u6b21&#xff0c;\u662f\u900f\u89c6\u8868\u7684\u7279\u4f8b<\/td>\n<td>\u7c7b\u4f3c\u5217\u8054\u8868<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"247\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192437-6ade57752c8f3.png\" width=\"388\" \/><\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"207\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192437-6ade577541ef8.png\" width=\"402\" \/><\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"202\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192437-6ade577555e91.png\" width=\"394\" \/><\/p>\n<\/p>\n<h3 id=\"2.6%20%E7%BB%BC%E5%90%88%E5%AE%9E%E6%88%98%E6%A1%88%E4%BE%8B\">2.6 \u7efc\u5408\u5b9e\u6218\u6848\u4f8b<\/h3>\n<h4 id=\"2.6.1%20%E6%A8%A1%E5%9E%8B%E8%BE%93%E5%87%BA%E8%A7%A3%E6%9E%90%EF%BC%88JSON%20%E2%86%92%20DataFrame%EF%BC%89\">2.6.1 \u6a21\u578b\u8f93\u51fa\u89e3\u6790&#xff08;JSON \u2192 DataFrame&#xff09;<\/h4>\n<p>\u8c03\u7528\u672c\u5730 Ollama \u6a21\u578b&#xff0c;\u83b7\u53d6 JSON \u8f93\u51fa&#xff0c;\u89e3\u6790\u4e3a DataFrame\u3002\u8fd9\u662f\u5927\u6a21\u578b\u5e94\u7528\u5f00\u53d1\u7684\u7b2c\u4e00\u6b65\u3002<\/p>\n<p># \u6a21\u578b\u8f93\u51fa\u89e3\u6790&#xff1a;JSON \u2192 DataFrame<\/p>\n<p>import httpx<br \/>\nimport json<br \/>\nimport pandas as pd<\/p>\n<p># \u8c03\u7528 Ollama<br \/>\ndef call_ollama(prompt):<br \/>\n    &#034;&#034;&#034;\u8c03\u7528\u672c\u5730 Ollama \u6a21\u578b&#034;&#034;&#034;<br \/>\n    response &#061; httpx.post(<br \/>\n        &#034;http:\/\/localhost:11434\/v1\/chat\/completions&#034;,<br \/>\n        headers&#061;{&#034;Authorization&#034;: &#034;Bearer ollama&#034;},<br \/>\n        json&#061;{<br \/>\n            &#034;model&#034;: &#034;qwen2.5:1.5b&#034;,<br \/>\n            &#034;messages&#034;: [{&#034;role&#034;: &#034;user&#034;, &#034;content&#034;: prompt}],<br \/>\n            &#034;stream&#034;: False<br \/>\n        },<br \/>\n        timeout&#061;60<br \/>\n    )<br \/>\n    return response.json()[&#034;choices&#034;][0][&#034;message&#034;][&#034;content&#034;]<\/p>\n<p># \u6279\u91cf\u8c03\u7528<br \/>\nprompts &#061; [<br \/>\n    &#034;\u7528\u4e00\u53e5\u8bdd\u4ecb\u7ecd Python&#034;,<br \/>\n    &#034;\u7528\u4e00\u53e5\u8bdd\u4ecb\u7ecd Java&#034;,<br \/>\n    &#034;\u7528\u4e00\u53e5\u8bdd\u4ecb\u7ecd Go&#034;,<br \/>\n]<\/p>\n<p>results &#061; []<br \/>\nfor i, prompt in enumerate(prompts):<br \/>\n    output &#061; call_ollama(prompt)<br \/>\n    results.append({<br \/>\n        &#034;id&#034;: i &#043; 1,<br \/>\n        &#034;prompt&#034;: prompt,<br \/>\n        &#034;output&#034;: output,<br \/>\n        &#034;length&#034;: len(output)<br \/>\n    })<\/p>\n<p># \u8f6c\u4e3a DataFrame<br \/>\ndf &#061; pd.DataFrame(results)<br \/>\nprint(f&#034;\u6a21\u578b\u8f93\u51fa&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u4fdd\u5b58<br \/>\ndf.to_csv(&#034;model_outputs.csv&#034;, index&#061;False, encoding&#061;&#034;utf-8&#034;)<br \/>\nprint(&#034;\\\\n\u5df2\u4fdd\u5b58 model_outputs.csv&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>httpx.post()<\/td>\n<td>\u53d1\u9001 POST \u8bf7\u6c42\u3002json \u53c2\u6570\u4f20\u9012\u8bf7\u6c42\u4f53<\/td>\n<\/tr>\n<tr>\n<td>response.json()<\/td>\n<td>\u89e3\u6790 JSON \u54cd\u5e94<\/td>\n<\/tr>\n<tr>\n<td>pd.DataFrame()<\/td>\n<td>\u4ece\u5217\u8868\u7684\u5b57\u5178\u521b\u5efa DataFrame<\/td>\n<\/tr>\n<tr>\n<td>df.to_csv()<\/td>\n<td>\u4fdd\u5b58\u4e3a CSV\u3002index&#061;False \u4e0d\u5199\u7d22\u5f15<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u8c03\u7528 Ollama \u83b7\u53d6\u6a21\u578b\u8f93\u51fa<\/p>\n<\/li>\n<li>\n<p>\u6279\u91cf\u8c03\u7528&#xff0c;\u6536\u96c6\u7ed3\u679c<\/p>\n<\/li>\n<li>\n<p>\u8f6c\u4e3a DataFrame&#xff0c;\u4fdd\u5b58<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.6.2%20%E8%AF%84%E6%B5%8B%E9%9B%86%E7%BB%9F%E8%AE%A1%EF%BC%88%E5%87%86%E7%A1%AE%E7%8E%87%E3%80%81badcase%EF%BC%89\">2.6.2 \u8bc4\u6d4b\u96c6\u7edf\u8ba1&#xff08;\u51c6\u786e\u7387\u3001badcase&#xff09;<\/h4>\n<p>\u6784\u5efa\u8bc4\u6d4b\u96c6&#xff0c;\u8c03\u7528\u6a21\u578b&#xff0c;\u7edf\u8ba1\u51c6\u786e\u7387&#xff0c;\u7b5b\u9009 badcase\u3002\u8fd9\u662f\u5927\u6a21\u578b\u8bc4\u6d4b\u7684\u6838\u5fc3\u6d41\u7a0b\u3002<\/p>\n<p># \u8bc4\u6d4b\u96c6\u7edf\u8ba1<\/p>\n<p>import httpx<br \/>\nimport json<br \/>\nimport pandas as pd<\/p>\n<p>def call_ollama(prompt):<br \/>\n    &#034;&#034;&#034;\u8c03\u7528\u672c\u5730 Ollama \u6a21\u578b&#034;&#034;&#034;<br \/>\n    response &#061; httpx.post(<br \/>\n        &#034;http:\/\/localhost:11434\/v1\/chat\/completions&#034;,<br \/>\n        headers&#061;{&#034;Authorization&#034;: &#034;Bearer ollama&#034;},<br \/>\n        json&#061;{<br \/>\n            &#034;model&#034;: &#034;qwen2.5:1.5b&#034;,<br \/>\n            &#034;messages&#034;: [<br \/>\n                {&#034;role&#034;: &#034;system&#034;, &#034;content&#034;: &#034;\u4f60\u662f\u4e00\u4e2a\u5206\u7c7b\u52a9\u624b&#xff0c;\u53ea\u56de\u7b54\u7c7b\u522b\u540d\u79f0\u3002&#034;},<br \/>\n                {&#034;role&#034;: &#034;user&#034;, &#034;content&#034;: prompt}<br \/>\n            ],<br \/>\n            &#034;stream&#034;: False<br \/>\n        },<br \/>\n        timeout&#061;60<br \/>\n    )<br \/>\n    return response.json()[&#034;choices&#034;][0][&#034;message&#034;][&#034;content&#034;].strip()<\/p>\n<p># \u8bc4\u6d4b\u96c6<br \/>\ntest_cases &#061; [<br \/>\n    {&#034;id&#034;: 1, &#034;text&#034;: &#034;\u4eca\u5929\u5929\u6c14\u771f\u597d&#034;, &#034;label&#034;: &#034;\u79ef\u6781&#034;},<br \/>\n    {&#034;id&#034;: 2, &#034;text&#034;: &#034;\u8fd9\u4e2a\u4ea7\u54c1\u592a\u5dee\u4e86&#034;, &#034;label&#034;: &#034;\u6d88\u6781&#034;},<br \/>\n    {&#034;id&#034;: 3, &#034;text&#034;: &#034;\u6211\u559c\u6b22\u8fd9\u4e2a\u7535\u5f71&#034;, &#034;label&#034;: &#034;\u79ef\u6781&#034;},<br \/>\n    {&#034;id&#034;: 4, &#034;text&#034;: &#034;\u670d\u52a1\u6001\u5ea6\u5f88\u5dee&#034;, &#034;label&#034;: &#034;\u6d88\u6781&#034;},<br \/>\n    {&#034;id&#034;: 5, &#034;text&#034;: &#034;\u4e00\u822c\u822c\u5427&#034;, &#034;label&#034;: &#034;\u4e2d\u6027&#034;},<br \/>\n]<\/p>\n<p># \u6279\u91cf\u8bc4\u6d4b<br \/>\nfor case in test_cases:<br \/>\n    prompt &#061; f&#034;\u5224\u65ad\u4ee5\u4e0b\u6587\u672c\u7684\u60c5\u611f&#xff08;\u79ef\u6781\/\u6d88\u6781\/\u4e2d\u6027&#xff09;&#xff1a;{case[&#039;text&#039;]}&#034;<br \/>\n    case[&#034;pred&#034;] &#061; call_ollama(prompt)<\/p>\n<p># \u8f6c\u4e3a DataFrame<br \/>\ndf &#061; pd.DataFrame(test_cases)<br \/>\nprint(f&#034;\u8bc4\u6d4b\u7ed3\u679c&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u7edf\u8ba1\u51c6\u786e\u7387<br \/>\ndf[&#034;correct&#034;] &#061; df[&#034;pred&#034;] &#061;&#061; df[&#034;label&#034;]<br \/>\naccuracy &#061; df[&#034;correct&#034;].mean()<br \/>\nprint(f&#034;\\\\n\u51c6\u786e\u7387&#xff1a;{accuracy:.2%}&#034;)<\/p>\n<p># \u7b5b\u9009 badcase<br \/>\nbadcases &#061; df[~df[&#034;correct&#034;]]<br \/>\nprint(f&#034;\\\\nbadcase&#xff1a;\\\\n{badcases}&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df[&#034;correct&#034;] &#061; df[&#034;pred&#034;] &#061;&#061; df[&#034;label&#034;]<\/td>\n<td>\u65b0\u589e\u5e03\u5c14\u5217<\/td>\n<\/tr>\n<tr>\n<td>df[&#034;correct&#034;].mean()<\/td>\n<td>\u8ba1\u7b97\u51c6\u786e\u7387<\/td>\n<\/tr>\n<tr>\n<td>df[~df[&#034;correct&#034;]]<\/td>\n<td>\u7b5b\u9009 badcase<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u6279\u91cf\u8c03\u7528\u6a21\u578b&#xff0c;\u6536\u96c6\u9884\u6d4b<\/p>\n<\/li>\n<li>\n<p>\u7edf\u8ba1\u51c6\u786e\u7387<\/p>\n<\/li>\n<li>\n<p>\u7b5b\u9009 badcase \u5206\u6790<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"2.6.3%20%E6%95%B0%E6%8D%AE%E6%B8%85%E6%B4%97%E4%B8%8E%E5%AF%BC%E5%87%BA\">2.6.3 \u6570\u636e\u6e05\u6d17\u4e0e\u5bfc\u51fa<\/h4>\n<p>\u5bf9\u6a21\u578b\u8f93\u51fa\u8fdb\u884c\u6570\u636e\u6e05\u6d17&#xff08;\u53bb\u91cd\u3001\u7f3a\u5931\u503c\u3001\u6587\u672c\u5904\u7406&#xff09;&#xff0c;\u7136\u540e\u5bfc\u51fa\u3002<\/p>\n<p># \u6570\u636e\u6e05\u6d17\u4e0e\u5bfc\u51fa<\/p>\n<p>import pandas as pd<br \/>\nimport numpy as np<\/p>\n<p># \u6a21\u62df\u6a21\u578b\u8f93\u51fa&#xff08;\u542b\u810f\u6570\u636e&#xff09;<br \/>\ndf &#061; pd.DataFrame({<br \/>\n    &#034;id&#034;: [1, 2, 3, 4, 5, 5],<br \/>\n    &#034;prompt&#034;: [&#034;\u4ecb\u7ecdPython&#034;, &#034;\u4ecb\u7ecdJava&#034;, &#034;\u4ecb\u7ecdGo&#034;, None, &#034;\u4ecb\u7ecdC&#043;&#043;&#034;, &#034;\u4ecb\u7ecdC&#043;&#043;&#034;],<br \/>\n    &#034;output&#034;: [&#034;Python\u662f\u4e00\u79cd&#8230;&#034;, &#034;Java\u662f\u4e00\u79cd&#8230;&#034;, None, &#034;Go\u662f\u4e00\u79cd&#8230;&#034;, &#034;C&#043;&#043;\u662f\u4e00\u79cd&#8230;&#034;, &#034;C&#043;&#043;\u662f\u4e00\u79cd&#8230;&#034;],<br \/>\n    &#034;score&#034;: [0.95, 0.87, 0.92, 0.88, np.nan, 0.88]<br \/>\n})<\/p>\n<p>print(f&#034;\u539f\u59cb\u6570\u636e&#xff1a;\\\\n{df}&#034;)<br \/>\nprint(f&#034;\\\\n\u7f3a\u5931\u503c&#xff1a;\\\\n{df.isnull().sum()}&#034;)<\/p>\n<p># \u53bb\u91cd<br \/>\ndf &#061; df.drop_duplicates(subset&#061;[&#034;prompt&#034;])<br \/>\nprint(f&#034;\\\\n\u53bb\u91cd\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u5220\u9664\u7f3a\u5931\u503c<br \/>\ndf &#061; df.dropna(subset&#061;[&#034;prompt&#034;, &#034;output&#034;])<br \/>\nprint(f&#034;\\\\n\u5220\u9664\u7f3a\u5931\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u586b\u5145\u7f3a\u5931\u503c<br \/>\ndf[&#034;score&#034;] &#061; df[&#034;score&#034;].fillna(df[&#034;score&#034;].mean())<br \/>\nprint(f&#034;\\\\n\u586b\u5145\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u6587\u672c\u5904\u7406&#xff1a;\u622a\u65ad\u8f93\u51fa<br \/>\ndf[&#034;output_short&#034;] &#061; df[&#034;output&#034;].str[:20]<br \/>\nprint(f&#034;\\\\n\u622a\u65ad\u540e&#xff1a;\\\\n{df}&#034;)<\/p>\n<p># \u5bfc\u51fa<br \/>\ndf.to_csv(&#034;cleaned_data.csv&#034;, index&#061;False, encoding&#061;&#034;utf-8&#034;)<br \/>\ndf.to_json(&#034;cleaned_data.json&#034;, orient&#061;&#034;records&#034;, force_ascii&#061;False)<br \/>\nprint(&#034;\\\\n\u5df2\u5bfc\u51fa cleaned_data.csv \u548c cleaned_data.json&#034;)<\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>df.drop_duplicates()<\/td>\n<td>\u53bb\u91cd<\/td>\n<\/tr>\n<tr>\n<td>df.dropna()<\/td>\n<td>\u5220\u9664\u7f3a\u5931\u503c<\/td>\n<\/tr>\n<tr>\n<td>df.fillna()<\/td>\n<td>\u586b\u5145\u7f3a\u5931\u503c<\/td>\n<\/tr>\n<tr>\n<td>df[&#034;\u5217&#034;].str[:20]<\/td>\n<td>\u6587\u672c\u622a\u65ad<\/td>\n<\/tr>\n<tr>\n<td>df.to_csv()<\/td>\n<td>\u5bfc\u51fa CSV<\/td>\n<\/tr>\n<tr>\n<td>df.to_json()<\/td>\n<td>\u5bfc\u51fa JSON<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u53bb\u91cd\u3001\u5220\u9664\u7f3a\u5931\u3001\u586b\u5145\u7f3a\u5931<\/p>\n<\/li>\n<li>\n<p>\u6587\u672c\u5904\u7406<\/p>\n<\/li>\n<li>\n<p>\u5bfc\u51fa\u4e3a CSV \/ JSON<\/p>\n<\/li>\n<\/ul>\n<h2 id=\"%E4%B8%89%E3%80%81Matplotlib%20%E5%85%A5%E9%97%A8%EF%BC%88%E7%AE%80%E8%A6%81%E4%BA%86%E8%A7%A3%EF%BC%89%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0%20%C2%A0\">\u4e09\u3001Matplotlib \u5165\u95e8&#xff08;\u7b80\u8981\u4e86\u89e3&#xff09;<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"710\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192437-6ade577569b94.png\" width=\"1206\" \/><\/p>\n<h3 id=\"3.1%20Matplotlib%20%E4%BB%8B%E7%BB%8D\">3.1 Matplotlib \u4ecb\u7ecd<\/h3>\n<h4 id=\"3.1.1%20Matplotlib%20%E6%98%AF%E4%BB%80%E4%B9%88\">3.1.1 Matplotlib \u662f\u4ec0\u4e48<\/h4>\n<p>Matplotlib \u662f Python \u6700\u57fa\u7840\u3001\u6700\u5e38\u7528\u7684\u6570\u636e\u53ef\u89c6\u5316\u5e93&#xff0c;\u7528\u4e8e\u7ed8\u5236\u5404\u79cd\u56fe\u8868&#xff08;\u6298\u7ebf\u56fe\u3001\u76f4\u65b9\u56fe\u3001\u67f1\u72b6\u56fe\u7b49&#xff09;\u3002<\/p>\n<p>\u4e00\u53e5\u8bdd\u7406\u89e3&#xff1a; Matplotlib \u8ba9 Python \u80fd\u50cf Excel \u4e00\u6837\u753b\u56fe&#xff0c;\u4f46\u66f4\u7075\u6d3b\u3001\u66f4\u53ef\u5b9a\u5236\u3002<\/p>\n<h4 id=\"3.1.2%20%E4%B8%BA%E4%BB%80%E4%B9%88%E5%A4%A7%E6%A8%A1%E5%9E%8B%E8%A7%92%E8%89%B2%E5%8F%AA%E9%9C%80%E7%AE%80%E8%A6%81%E4%BA%86%E8%A7%A3\">3.1.2 \u4e3a\u4ec0\u4e48\u5927\u6a21\u578b\u89d2\u8272\u53ea\u9700\u7b80\u8981\u4e86\u89e3<\/h4>\n<p>\u5927\u6a21\u578b\u5e94\u7528\u5f00\u53d1\u4e2d&#xff0c;\u53ef\u89c6\u5316\u4e0d\u662f\u6838\u5fc3\u5de5\u4f5c&#xff0c;\u4f46\u9700\u8981\u5feb\u901f\u51fa\u56fe\u8f85\u52a9\u5206\u6790\u3002<\/p>\n<p>\u5927\u6a21\u578b\u573a\u666f\u4e0b\u7684\u5178\u578b\u9700\u6c42<\/p>\n<table>\n<tr>\u9700\u6c42\u56fe\u8868\u7c7b\u578b\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u770b loss \u66f2\u7ebf<\/td>\n<td>\u6298\u7ebf\u56fe<\/td>\n<td>\u89c2\u5bdf\u8bad\u7ec3\u662f\u5426\u6536\u655b<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u6570\u636e\u5206\u5e03<\/td>\n<td>\u76f4\u65b9\u56fe<\/td>\n<td>\u89c2\u5bdf\u6570\u636e\u5206\u5e03\u662f\u5426\u5747\u5300<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u7c7b\u522b\u5206\u5e03<\/td>\n<td>\u67f1\u72b6\u56fe<\/td>\n<td>\u89c2\u5bdf\u7c7b\u522b\u662f\u5426\u5e73\u8861<\/td>\n<\/tr>\n<tr>\n<td>\u8bb0\u5f55\u5b9e\u9a8c<\/td>\n<td>\u4fdd\u5b58\u56fe\u7247<\/td>\n<td>\u4fdd\u5b58\u5230\u5b9e\u9a8c\u76ee\u5f55&#xff0c;\u4fbf\u4e8e\u5bf9\u6bd4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 id=\"3.2%20%E5%A4%A7%E6%A8%A1%E5%9E%8B%E5%9C%BA%E6%99%AF%E4%B8%8B%E6%9C%80%E5%B8%B8%E7%94%A8%E7%9A%84%E5%9B%BE\">3.2 \u5927\u6a21\u578b\u573a\u666f\u4e0b\u6700\u5e38\u7528\u7684\u56fe<\/h3>\n<h4 id=\"3.2.1%20loss%20%2F%20accuracy%20%E6%9B%B2%E7%BA%BF%EF%BC%88%E6%8A%98%E7%BA%BF%E5%9B%BE%EF%BC%89\">3.2.1 loss \/ accuracy \u66f2\u7ebf&#xff08;\u6298\u7ebf\u56fe&#xff09;<\/h4>\n<p>\u6298\u7ebf\u56fe\u7528\u4e8e\u5c55\u793a\u968f\u65f6\u95f4\u53d8\u5316\u7684\u8d8b\u52bf&#xff0c;\u662f\u5927\u6a21\u578b\u8bad\u7ec3\u4e2d\u6700\u5e38\u7528\u7684\u56fe\u3002\u901a\u8fc7 loss \u66f2\u7ebf\u5224\u65ad\u8bad\u7ec3\u662f\u5426\u6536\u655b\u3001\u662f\u5426\u8fc7\u62df\u5408\u3002<\/p>\n<table>\n<tr>\u573a\u666f\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u770b loss \u66f2\u7ebf<\/td>\n<td>\u5224\u65ad\u8bad\u7ec3\u662f\u5426\u6536\u655b<\/td>\n<\/tr>\n<tr>\n<td>\u770b accuracy \u66f2\u7ebf<\/td>\n<td>\u5224\u65ad\u6a21\u578b\u662f\u5426\u63d0\u5347<\/td>\n<\/tr>\n<tr>\n<td>\u5bf9\u6bd4\u591a\u6b21\u5b9e\u9a8c<\/td>\n<td>\u5bf9\u6bd4\u4e0d\u540c\u8d85\u53c2\u6570\u7684\u8bad\u7ec3\u6548\u679c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\n<p>X \u8f74&#xff1a;epoch&#xff08;\u8bad\u7ec3\u8f6e\u6b21&#xff09;<\/p>\n<\/li>\n<li>\n<p>Y \u8f74&#xff1a;loss&#xff08;\u635f\u5931\u503c&#xff09;<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;loss \u6301\u7eed\u4e0b\u964d\u5e76\u8d8b\u4e8e\u5e73\u7a33 \u2192 \u6536\u655b<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;loss \u5148\u964d\u540e\u5347 \u2192 \u8fc7\u62df\u5408<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.2.2%20%E6%95%B0%E6%8D%AE%E5%88%86%E5%B8%83%EF%BC%88%E7%9B%B4%E6%96%B9%E5%9B%BE%EF%BC%89\">3.2.2 \u6570\u636e\u5206\u5e03&#xff08;\u76f4\u65b9\u56fe&#xff09;<\/h4>\n<p>\u76f4\u65b9\u56fe\u7528\u4e8e\u5c55\u793a\u6570\u636e\u7684\u5206\u5e03\u60c5\u51b5&#xff0c;\u89c2\u5bdf\u6570\u636e\u662f\u5426\u5747\u5300\u3001\u662f\u5426\u504f\u659c\u3002<\/p>\n<table>\n<tr>\u573a\u666f\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u770b\u6570\u636e\u5206\u5e03<\/td>\n<td>\u89c2\u5bdf\u6570\u636e\u662f\u5426\u5747\u5300<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u957f\u5c3e\u5206\u5e03<\/td>\n<td>\u89c2\u5bdf\u662f\u5426\u5b58\u5728\u957f\u5c3e<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u6e05\u6d17\u524d<\/td>\n<td>\u5224\u65ad\u662f\u5426\u9700\u8981\u5f52\u4e00\u5316<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\n<p>X \u8f74&#xff1a;\u6570\u636e\u503c&#xff08;\u5206\u7bb1&#xff09;<\/p>\n<\/li>\n<li>\n<p>Y \u8f74&#xff1a;\u9891\u6b21<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;\u4e2d\u95f4\u9ad8\u4e24\u8fb9\u4f4e \u2192 \u6b63\u6001\u5206\u5e03<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;\u504f\u5de6\u6216\u504f\u53f3 \u2192 \u504f\u659c\u5206\u5e03<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.2.3%20%E7%B1%BB%E5%88%AB%E5%88%86%E5%B8%83%EF%BC%88%E6%9F%B1%E7%8A%B6%E5%9B%BE%EF%BC%89\">3.2.3 \u7c7b\u522b\u5206\u5e03&#xff08;\u67f1\u72b6\u56fe&#xff09;<\/h4>\n<p>\u67f1\u72b6\u56fe\u7528\u4e8e\u5c55\u793a\u4e0d\u540c\u7c7b\u522b\u7684\u6570\u91cf\u5bf9\u6bd4&#xff0c;\u89c2\u5bdf\u7c7b\u522b\u662f\u5426\u5e73\u8861\u3002<\/p>\n<table>\n<tr>\u573a\u666f\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u770b\u7c7b\u522b\u5206\u5e03<\/td>\n<td>\u89c2\u5bdf\u7c7b\u522b\u662f\u5426\u5e73\u8861<\/td>\n<\/tr>\n<tr>\n<td>badcase \u7edf\u8ba1<\/td>\n<td>\u7edf\u8ba1\u5404\u7c7b badcase \u6570\u91cf<\/td>\n<\/tr>\n<tr>\n<td>\u8bc4\u6d4b\u7ed3\u679c<\/td>\n<td>\u7edf\u8ba1\u5404\u6807\u7b7e\u7684\u51c6\u786e\u7387<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\n<p>X \u8f74&#xff1a;\u7c7b\u522b<\/p>\n<\/li>\n<li>\n<p>Y \u8f74&#xff1a;\u6570\u91cf<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;\u67f1\u5b50\u9ad8\u5ea6\u5dee\u5f02\u5927 \u2192 \u7c7b\u522b\u4e0d\u5e73\u8861<\/p>\n<\/li>\n<li>\n<p>\u5e94\u7528&#xff1a;badcase \u7edf\u8ba1\u3001\u8bc4\u6d4b\u7ed3\u679c\u5206\u6790<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.2.4%20%E6%95%A3%E7%82%B9%E5%9B%BE%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89\">3.2.4 \u6563\u70b9\u56fe&#xff08;\u4e86\u89e3&#xff09;<\/h4>\n<p>\u6563\u70b9\u56fe\u7528\u4e8e\u5c55\u793a\u4e24\u4e2a\u53d8\u91cf\u4e4b\u95f4\u7684\u5173\u7cfb&#xff0c;\u89c2\u5bdf\u662f\u5426\u5b58\u5728\u76f8\u5173\u6027\u3002<\/p>\n<table>\n<tr>\u573a\u666f\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>\u770b\u76f8\u5173\u6027<\/td>\n<td>\u89c2\u5bdf\u4e24\u4e2a\u53d8\u91cf\u662f\u5426\u76f8\u5173<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u805a\u7c7b<\/td>\n<td>\u89c2\u5bdf\u6570\u636e\u662f\u5426\u5206\u7fa4<\/td>\n<\/tr>\n<tr>\n<td>\u5f02\u5e38\u503c\u68c0\u6d4b<\/td>\n<td>\u89c2\u5bdf\u662f\u5426\u6709\u79bb\u7fa4\u70b9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\n<p>X \u8f74&#xff1a;\u53d8\u91cf 1<\/p>\n<\/li>\n<li>\n<p>Y \u8f74&#xff1a;\u53d8\u91cf 2<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;\u70b9\u5448\u4e0a\u5347\u8d8b\u52bf \u2192 \u6b63\u76f8\u5173<\/p>\n<\/li>\n<li>\n<p>\u5224\u65ad&#xff1a;\u70b9\u5206\u6563 \u2192 \u65e0\u76f8\u5173<\/p>\n<\/li>\n<\/ul>\n<p>\u8bf4\u660e&#xff1a; \u6563\u70b9\u56fe\u5728\u5927\u6a21\u578b\u573a\u666f\u4e2d\u8f83\u5c11\u7528&#xff0c;\u4e86\u89e3\u5373\u53ef\u3002<\/p>\n<h4 id=\"3.2.5%20%E5%9B%BE%E8%A1%A8%E9%80%89%E6%8B%A9%E6%8C%87%E5%8D%97%EF%BC%88%E4%BA%86%E8%A7%A3%EF%BC%89\">3.2.5 \u56fe\u8868\u9009\u62e9\u6307\u5357&#xff08;\u4e86\u89e3&#xff09;<\/h4>\n<p>\u6839\u636e\u5206\u6790\u76ee\u7684\u9009\u62e9\u5408\u9002\u7684\u56fe\u8868\u7c7b\u578b\u3002<\/p>\n<table>\n<tr>\u5206\u6790\u76ee\u7684\u63a8\u8350\u56fe\u8868\u793a\u4f8b<\/tr>\n<tbody>\n<tr>\n<td>\u770b\u8d8b\u52bf<\/td>\n<td>\u6298\u7ebf\u56fe<\/td>\n<td>loss \u66f2\u7ebf<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u5206\u5e03<\/td>\n<td>\u76f4\u65b9\u56fe<\/td>\n<td>\u6570\u636e\u5206\u5e03<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u5bf9\u6bd4<\/td>\n<td>\u67f1\u72b6\u56fe<\/td>\n<td>\u7c7b\u522b\u5206\u5e03<\/td>\n<\/tr>\n<tr>\n<td>\u770b\u5173\u7cfb<\/td>\n<td>\u6563\u70b9\u56fe<\/td>\n<td>\u76f8\u5173\u6027<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p id=\"%E5%A4%A7%E6%A8%A1%E5%9E%8B%E5%9C%BA%E6%99%AF%E9%80%9F%E6%9F%A5\">\u5927\u6a21\u578b\u573a\u666f\u901f\u67e5<\/p>\n<table>\n<tr>\u9700\u6c42\u56fe\u8868<\/tr>\n<tbody>\n<tr>\n<td>\u8bad\u7ec3\u662f\u5426\u6536\u655b<\/td>\n<td>\u6298\u7ebf\u56fe<\/td>\n<\/tr>\n<tr>\n<td>\u6570\u636e\u662f\u5426\u5747\u5300<\/td>\n<td>\u76f4\u65b9\u56fe<\/td>\n<\/tr>\n<tr>\n<td>\u7c7b\u522b\u662f\u5426\u5e73\u8861<\/td>\n<td>\u67f1\u72b6\u56fe<\/td>\n<\/tr>\n<tr>\n<td>\u53d8\u91cf\u662f\u5426\u76f8\u5173<\/td>\n<td>\u6563\u70b9\u56fe<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a; \u5927\u6a21\u578b\u89d2\u8272\u4e3b\u8981\u7528\u6298\u7ebf\u56fe\u3001\u76f4\u65b9\u56fe\u3001\u67f1\u72b6\u56fe&#xff0c;\u6563\u70b9\u56fe\u4e86\u89e3\u5373\u53ef\u3002<\/p>\n<\/p>\n<h3 id=\"3.3%20%E5%9F%BA%E7%A1%80%E7%BB%98%E5%9B%BE%E5%8A%9F%E8%83%BD\">3.3 \u57fa\u7840\u7ed8\u56fe\u529f\u80fd<\/h3>\n<h4 id=\"3.3.1%20%E4%B8%8E%20pandas%20%E8%81%94%E5%8A%A8%20df.plot()%C2%A0\">3.3.1 \u4e0e pandas \u8054\u52a8 df.plot()\u00a0<\/h4>\n<p>Pandas \u5185\u7f6e plot() \u65b9\u6cd5&#xff0c;\u57fa\u4e8e Matplotlib&#xff0c;\u53ef\u4e00\u884c\u4ee3\u7801\u51fa\u56fe&#xff0c;\u662f\u6700\u4fbf\u6377\u7684\u65b9\u5f0f\u3002<\/p>\n<p># \u4e0e pandas \u8054\u52a8 df.plot()<\/p>\n<p>import pandas as pd<br \/>\nimport matplotlib.pyplot as plt<\/p>\n<p># \u6a21\u62df\u8bad\u7ec3\u65e5\u5fd7<br \/>\ndf &#061; pd.DataFrame({<br \/>\n    &#034;epoch&#034;: [1, 2, 3, 4, 5, 6, 7, 8],<br \/>\n    &#034;loss&#034;: [1.0, 0.8, 0.6, 0.5, 0.4, 0.35, 0.33, 0.32],<br \/>\n    &#034;accuracy&#034;: [0.5, 0.6, 0.7, 0.75, 0.8, 0.83, 0.85, 0.86]<br \/>\n})<\/p>\n<p># \u6298\u7ebf\u56fe&#xff1a;loss \u66f2\u7ebf<br \/>\ndf.plot(x&#061;&#034;epoch&#034;, y&#061;&#034;loss&#034;, title&#061;&#034;Loss Curve&#034;)<br \/>\nplt.savefig(&#034;loss_curve.png&#034;)<br \/>\nplt.show()<\/p>\n<p># \u591a\u6761\u66f2\u7ebf<br \/>\ndf.plot(x&#061;&#034;epoch&#034;, y&#061;[&#034;loss&#034;, &#034;accuracy&#034;], title&#061;&#034;Training Metrics&#034;)<br \/>\nplt.show() <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>x<\/td>\n<td>X \u8f74\u5217\u540d<\/td>\n<\/tr>\n<tr>\n<td>y<\/td>\n<td>Y \u8f74\u5217\u540d&#xff08;\u53ef\u4e3a\u5217\u8868&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>kind<\/td>\n<td>\u56fe\u8868\u7c7b\u578b&#xff1a;line\u3001bar\u3001hist\u3001scatter<\/td>\n<\/tr>\n<tr>\n<td>title<\/td>\n<td>\u56fe\u8868\u6807\u9898<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>df.plot() \u4e00\u884c\u51fa\u56fe<\/p>\n<\/li>\n<li>\n<p>kind \u6307\u5b9a\u56fe\u8868\u7c7b\u578b<\/p>\n<\/li>\n<li>\n<p>\u8fd4\u56de Axes \u5bf9\u8c61&#xff0c;\u53ef\u7ee7\u7eed\u5b9a\u5236<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.3.2%20%E4%B8%8E%20NumPy%20%E6%95%B0%E7%BB%84%E7%9B%B4%E6%8E%A5%E7%BB%98%E5%9B%BE%C2%A0\">3.3.2 \u4e0e NumPy \u6570\u7ec4\u76f4\u63a5\u7ed8\u56fe\u00a0<\/h4>\n<p>Matplotlib \u53ef\u76f4\u63a5\u63a5\u6536 NumPy \u6570\u7ec4&#xff0c;\u65e0\u9700\u8f6c DataFrame\u3002<\/p>\n<p># \u4e0e NumPy \u6570\u7ec4\u76f4\u63a5\u7ed8\u56fe<\/p>\n<p>import numpy as np<br \/>\nimport matplotlib.pyplot as plt<\/p>\n<p># \u751f\u6210\u6570\u636e<br \/>\nx &#061; np.linspace(0, 10, 100)<br \/>\ny &#061; np.sin(x)<\/p>\n<p># \u76f4\u63a5\u7ed8\u56fe<br \/>\nplt.plot(x, y)<br \/>\nplt.title(&#034;Sin Wave&#034;)<br \/>\nplt.show()<\/p>\n<p># \u591a\u6761\u66f2\u7ebf<br \/>\ny2 &#061; np.cos(x)<br \/>\nplt.plot(x, y, label&#061;&#034;sin&#034;)<br \/>\nplt.plot(x, y2, label&#061;&#034;cos&#034;)<br \/>\nplt.legend()<br \/>\nplt.show() <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>x, y<\/td>\n<td>\u6570\u636e\u6570\u7ec4<\/td>\n<\/tr>\n<tr>\n<td>label<\/td>\n<td>\u66f2\u7ebf\u6807\u7b7e&#xff0c;\u7528\u4e8e\u56fe\u4f8b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a; Matplotlib \u53ef\u76f4\u63a5\u63a5\u6536 NumPy \u6570\u7ec4\u3002<\/p>\n<h4 id=\"3.3.3%20pyplot%20%E9%A3%8E%E6%A0%BC%20plt.plot%20%2F%20scatter%20%2F%20hist\">3.3.3 pyplot \u98ce\u683c plt.plot \/ scatter \/ hist<\/h4>\n<p>pyplot \u662f Matplotlib \u7684\u51fd\u6570\u5f0f\u63a5\u53e3&#xff0c;\u63d0\u4f9b plt.plot\u3001plt.scatter\u3001plt.hist \u7b49\u5feb\u6377\u65b9\u6cd5\u3002<\/p>\n<p># pyplot \u98ce\u683c<\/p>\n<p>import numpy as np<br \/>\nimport matplotlib.pyplot as plt<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u6298\u7ebf\u56fe &#061;&#061;&#061;&#061;&#061;<br \/>\nx &#061; np.linspace(0, 10, 100)<br \/>\nplt.plot(x, np.sin(x))<br \/>\nplt.title(&#034;Line Plot&#034;)<br \/>\nplt.show()<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u6563\u70b9\u56fe &#061;&#061;&#061;&#061;&#061;<br \/>\nx &#061; np.random.rand(50)<br \/>\ny &#061; np.random.rand(50)<br \/>\nplt.scatter(x, y)<br \/>\nplt.title(&#034;Scatter Plot&#034;)<br \/>\nplt.show()<\/p>\n<p># &#061;&#061;&#061;&#061;&#061; \u76f4\u65b9\u56fe &#061;&#061;&#061;&#061;&#061;<br \/>\ndata &#061; np.random.randn(1000)<br \/>\nplt.hist(data, bins&#061;30)<br \/>\nplt.title(&#034;Histogram&#034;)<br \/>\nplt.show() <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>plt.plot()<\/td>\n<td>\u6298\u7ebf\u56fe<\/td>\n<\/tr>\n<tr>\n<td>plt.scatter()<\/td>\n<td>\u6563\u70b9\u56fe<\/td>\n<\/tr>\n<tr>\n<td>plt.hist()<\/td>\n<td>\u76f4\u65b9\u56fe\u3002bins \u6307\u5b9a\u5206\u7bb1\u6570<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>plt.plot \u6298\u7ebf\u56fe<\/p>\n<\/li>\n<li>\n<p>plt.scatter \u6563\u70b9\u56fe<\/p>\n<\/li>\n<li>\n<p>plt.hist \u76f4\u65b9\u56fe<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.3.4%20%E6%A0%87%E9%A2%98%E3%80%81%E5%9D%90%E6%A0%87%E8%BD%B4%E6%A0%87%E7%AD%BE%E3%80%81%E5%9B%BE%E4%BE%8B\">3.3.4 \u6807\u9898\u3001\u5750\u6807\u8f74\u6807\u7b7e\u3001\u56fe\u4f8b<\/h4>\n<p>\u4e3a\u56fe\u8868\u6dfb\u52a0\u6807\u9898\u3001\u5750\u6807\u8f74\u6807\u7b7e\u3001\u56fe\u4f8b&#xff0c;\u4f7f\u56fe\u8868\u66f4\u6e05\u6670\u3002<\/p>\n<p># \u6807\u9898\u3001\u5750\u6807\u8f74\u6807\u7b7e\u3001\u56fe\u4f8b<\/p>\n<p>import numpy as np<br \/>\nimport matplotlib.pyplot as plt<\/p>\n<p>x &#061; np.linspace(0, 10, 100)<\/p>\n<p>plt.plot(x, np.sin(x), label&#061;&#034;sin&#034;)<br \/>\nplt.plot(x, np.cos(x), label&#061;&#034;cos&#034;)<\/p>\n<p># \u6807\u9898<br \/>\nplt.title(&#034;test&#034;)<\/p>\n<p># \u5750\u6807\u8f74\u6807\u7b7e<br \/>\nplt.xlabel(&#034;x&#034;)<br \/>\nplt.ylabel(&#034;y&#034;)<\/p>\n<p># \u56fe\u4f8b<br \/>\nplt.legend()<\/p>\n<p>plt.show() <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6cd5\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>plt.title()<\/td>\n<td>\u8bbe\u7f6e\u6807\u9898<\/td>\n<\/tr>\n<tr>\n<td>plt.xlabel()<\/td>\n<td>\u8bbe\u7f6e X \u8f74\u6807\u7b7e<\/td>\n<\/tr>\n<tr>\n<td>plt.ylabel()<\/td>\n<td>\u8bbe\u7f6e Y \u8f74\u6807\u7b7e<\/td>\n<\/tr>\n<tr>\n<td>plt.legend()<\/td>\n<td>\u663e\u793a\u56fe\u4f8b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>title \u6807\u9898<\/p>\n<\/li>\n<li>\n<p>xlabel \/ ylabel \u5750\u6807\u8f74\u6807\u7b7e<\/p>\n<\/li>\n<li>\n<p>legend \u56fe\u4f8b&#xff0c;\u9700\u5728 plot \u65f6\u6307\u5b9a label<\/p>\n<\/li>\n<\/ul>\n<h4 id=\"3.3.5%20%E4%BF%9D%E5%AD%98%E5%9B%BE%E7%89%87%20savefig\">3.3.5 \u4fdd\u5b58\u56fe\u7247 savefig<\/h4>\n<p>savefig() \u7528\u4e8e\u4fdd\u5b58\u56fe\u7247\u5230\u6587\u4ef6&#xff0c;\u5e38\u7528\u4e8e\u8bb0\u5f55\u5b9e\u9a8c\u3002<\/p>\n<p># \u4fdd\u5b58\u56fe\u7247<\/p>\n<p>import numpy as np<br \/>\nimport matplotlib.pyplot as plt<\/p>\n<p>x &#061; np.linspace(0, 10, 100)<\/p>\n<p>plt.plot(x, np.sin(x))<br \/>\nplt.title(&#034;Sin Wave&#034;)<\/p>\n<p># \u4fdd\u5b58\u56fe\u7247<br \/>\nplt.savefig(&#034;sin_wave.png&#034;, dpi&#061;150, bbox_inches&#061;&#034;tight&#034;)<br \/>\nprint(&#034;\u5df2\u4fdd\u5b58 sin_wave.png&#034;) <\/p>\n<p>\u65b9\u6cd5\u8bf4\u660e&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>fname<\/td>\n<td>\u6587\u4ef6\u540d&#xff0c;\u652f\u6301 PNG\u3001JPG\u3001PDF<\/td>\n<\/tr>\n<tr>\n<td>dpi<\/td>\n<td>\u5206\u8fa8\u7387&#xff0c;\u9ed8\u8ba4 100<\/td>\n<\/tr>\n<tr>\n<td>bbox_inches<\/td>\n<td>&#034;tight&#034; \u53bb\u9664\u591a\u4f59\u7a7a\u767d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u652f\u6301\u591a\u79cd\u683c\u5f0f&#xff1a;PNG\u3001JPG\u3001PDF\u3001SVG<\/p>\n<\/li>\n<li>\n<p>dpi \u63a7\u5236\u6e05\u6670\u5ea6<\/p>\n<\/li>\n<li>\n<p>bbox_inches&#061;&#034;tight&#034; \u53bb\u9664\u7a7a\u767d<\/p>\n<\/li>\n<\/ul><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6458\u8981&#xff1a;Pandas \u662f Python \u6570\u636e\u5904\u7406\u7684\u6838\u5fc3\u5e93&#xff0c;\u63d0\u4f9b Series&#xff08;\u4e00\u7ef4&#xff09;\u548c DataFrame&#xff08;\u4e8c\u7ef4&#xff09;\u4e24\u79cd\u6570\u636e\u7ed3\u6784&#xff0c;\u652f\u6301\u6570\u636e\u8bfb\u5199&#xff08;CSV\u3001JSON&#xff09;\u3001\u7d22\u5f15\u9009\u62e9&#xff08;loc\/iloc&#xff09;\u3001\u6570\u636e\u6e05\u6d17&#xff08;\u53bb\u91cd\u3001\u7f3a\u5931\u503c&#xff09;\u3001\u6570\u636e\u5408\u5e76&#xff08;merge\/concat&#xff09;\u3001\u5206\u7ec4\u805a\u5408&amp;#xf<\/p>\n","protected":false},"author":2,"featured_media":118011,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4278,371,801],"topic":[],"class_list":["post-118017","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-pandas","tag-371","tag-801"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/118017.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6458\u8981&#xff1a;Pandas \u662f Python \u6570\u636e\u5904\u7406\u7684\u6838\u5fc3\u5e93&#xff0c;\u63d0\u4f9b Series&#xff08;\u4e00\u7ef4&#xff09;\u548c DataFrame&#xff08;\u4e8c\u7ef4&#xff09;\u4e24\u79cd\u6570\u636e\u7ed3\u6784&#xff0c;\u652f\u6301\u6570\u636e\u8bfb\u5199&#xff08;CSV\u3001JSON&#xff09;\u3001\u7d22\u5f15\u9009\u62e9&#xff08;loc\/iloc&#xff09;\u3001\u6570\u636e\u6e05\u6d17&#xff08;\u53bb\u91cd\u3001\u7f3a\u5931\u503c&#xff09;\u3001\u6570\u636e\u5408\u5e76&#xff08;merge\/concat&#xff09;\u3001\u5206\u7ec4\u805a\u5408&amp;#xf\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/118017.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-25T19:24:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192435-6ade5773be470.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/118017.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/118017.html\",\"name\":\"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-10-25T19:24:38+00:00\",\"dateModified\":\"2026-10-25T19:24:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/118017.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/118017.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/118017.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/118017.html","og_locale":"zh_CN","og_type":"article","og_title":"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6458\u8981&#xff1a;Pandas \u662f Python \u6570\u636e\u5904\u7406\u7684\u6838\u5fc3\u5e93&#xff0c;\u63d0\u4f9b Series&#xff08;\u4e00\u7ef4&#xff09;\u548c DataFrame&#xff08;\u4e8c\u7ef4&#xff09;\u4e24\u79cd\u6570\u636e\u7ed3\u6784&#xff0c;\u652f\u6301\u6570\u636e\u8bfb\u5199&#xff08;CSV\u3001JSON&#xff09;\u3001\u7d22\u5f15\u9009\u62e9&#xff08;loc\/iloc&#xff09;\u3001\u6570\u636e\u6e05\u6d17&#xff08;\u53bb\u91cd\u3001\u7f3a\u5931\u503c&#xff09;\u3001\u6570\u636e\u5408\u5e76&#xff08;merge\/concat&#xff09;\u3001\u5206\u7ec4\u805a\u5408&amp;#xf","og_url":"https:\/\/www.wsisp.com\/helps\/118017.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-10-25T19:24:38+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261025192435-6ade5773be470.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"18 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/118017.html","url":"https:\/\/www.wsisp.com\/helps\/118017.html","name":"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-10-25T19:24:38+00:00","dateModified":"2026-10-25T19:24:38+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/118017.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/118017.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/118017.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u5927\u6a21\u578b\u5b66\u4e60\u4e4b\u6570\u636e\u5206\u6790\u2014\u2014\u9762\u5411\u5927\u6a21\u578b\u7684Pandas \u4e0e Matplotlib\u57fa\u7840"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/118017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=118017"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/118017\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/118011"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=118017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=118017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=118017"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=118017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}