{"id":2889,"date":"2024-11-28T22:30:33","date_gmt":"2024-11-28T14:30:33","guid":{"rendered":"http:\/\/viplao.com\/?p=2889"},"modified":"2024-11-28T22:30:33","modified_gmt":"2024-11-28T14:30:33","slug":"python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/","title":{"rendered":"PYTHON\u57fa\u7840\u6280\u80fd \u2013\u00a0Python\u63d0\u5347\u5de5\u4f5c\u6548\u7387\u76847\u4e2a\u5b9e\u7528\u79d8\u7c4d"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u6587\u7ae0\u76ee\u5f55<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E4%B8%80%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96%E6%96%87%E4%BB%B6%E6%93%8D%E4%BD%9C\" title=\"\u79d8\u7c4d\u4e00\uff1a\u81ea\u52a8\u5316\u6587\u4ef6\u64cd\u4f5c\">\u79d8\u7c4d\u4e00\uff1a\u81ea\u52a8\u5316\u6587\u4ef6\u64cd\u4f5c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E4%BA%8C%EF%BC%9A%E9%AB%98%E6%95%88%E7%9A%84%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86\" title=\"\u79d8\u7c4d\u4e8c\uff1a\u9ad8\u6548\u7684\u6570\u636e\u5904\u7406\">\u79d8\u7c4d\u4e8c\uff1a\u9ad8\u6548\u7684\u6570\u636e\u5904\u7406<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E4%B8%89%EF%BC%9A%E6%96%87%E6%9C%AC%E5%A4%84%E7%90%86%E5%88%A9%E5%99%A8_%E2%80%94%E2%80%94_%E6%AD%A3%E5%88%99%E8%A1%A8%E8%BE%BE%E5%BC%8F\" title=\"\u79d8\u7c4d\u4e09\uff1a\u6587\u672c\u5904\u7406\u5229\u5668 \u2014\u2014 \u6b63\u5219\u8868\u8fbe\u5f0f\">\u79d8\u7c4d\u4e09\uff1a\u6587\u672c\u5904\u7406\u5229\u5668 \u2014\u2014 \u6b63\u5219\u8868\u8fbe\u5f0f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E5%9B%9B%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96Excel%E6%93%8D%E4%BD%9C\" title=\"\u79d8\u7c4d\u56db\uff1a\u81ea\u52a8\u5316Excel\u64cd\u4f5c\">\u79d8\u7c4d\u56db\uff1a\u81ea\u52a8\u5316Excel\u64cd\u4f5c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E4%BA%94%EF%BC%9AWeb%E8%87%AA%E5%8A%A8%E5%8C%96%E7%88%AC%E8%99%AB\" title=\"\u79d8\u7c4d\u4e94\uff1aWeb\u81ea\u52a8\u5316\u722c\u866b\">\u79d8\u7c4d\u4e94\uff1aWeb\u81ea\u52a8\u5316\u722c\u866b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/#%E7%A7%98%E7%B1%8D%E5%85%AD%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96%E9%82%AE%E4%BB%B6%E5%8F%91%E9%80%81\" title=\"\u79d8\u7c4d\u516d\uff1a\u81ea\u52a8\u5316\u90ae\u4ef6\u53d1\u9001\">\u79d8\u7c4d\u516d\uff1a\u81ea\u52a8\u5316\u90ae\u4ef6\u53d1\u9001<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E4%B8%80%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96%E6%96%87%E4%BB%B6%E6%93%8D%E4%BD%9C\"><\/span><strong>\u79d8\u7c4d\u4e00\uff1a\u81ea\u52a8\u5316\u6587\u4ef6\u64cd\u4f5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5904\u7406\u5927\u91cf\u7684\u6587\u4ef6\u65f6\uff0c\u624b\u52a8\u64cd\u4f5c\u4e0d\u4ec5\u8017\u65f6\u8fd8\u5bb9\u6613\u51fa\u9519\u3002Python\u53ef\u4ee5\u5e2e\u4f60\u81ea\u52a8\u5b8c\u6210\u8fd9\u4e9b\u4efb\u52a1\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u6279\u91cf\u91cd\u547d\u540d\u6587\u4ef6<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import&nbsp;os<br><br>def&nbsp;rename_files(directory,&nbsp;prefix):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u6279\u91cf\u91cd\u547d\u540d\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u6587\u4ef6\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;directory:&nbsp;\u6587\u4ef6\u5939\u8def\u5f84<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;prefix:&nbsp;\u65b0\u7684\u6587\u4ef6\u540d\u524d\u7f00<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;files&nbsp;=&nbsp;os.listdir(directory)<br>&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;file&nbsp;in&nbsp;files:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ext&nbsp;=&nbsp;os.path.splitext(file)&#91;1]<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new_name&nbsp;=&nbsp;f\"{prefix}_{file}\"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;old_path&nbsp;=&nbsp;os.path.join(directory,&nbsp;file)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new_path&nbsp;=&nbsp;os.path.join(directory,&nbsp;new_name)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;os.rename(old_path,&nbsp;new_path)<br><br><em>#&nbsp;\u4f7f\u7528\u793a\u4f8b<\/em><br>rename_files(\"path\/to\/your\/directory\",&nbsp;\"new_prefix\")<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u6bb5\u4ee3\u7801\u5b9a\u4e49\u4e86\u4e00\u4e2a<code>rename_files<\/code>\u51fd\u6570\uff0c\u5b83\u63a5\u6536\u4e24\u4e2a\u53c2\u6570\u2014\u2014\u6587\u4ef6\u5939\u8def\u5f84\u548c\u65b0\u7684\u6587\u4ef6\u540d\u524d\u7f00\u3002\u51fd\u6570\u9996\u5148\u83b7\u53d6\u6307\u5b9a\u76ee\u5f55\u4e0b\u6240\u6709\u6587\u4ef6\u7684\u5217\u8868\uff0c\u7136\u540e\u904d\u5386\u6bcf\u4e2a\u6587\u4ef6\uff0c\u751f\u6210\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6\u540d\uff0c\u5e76\u4f7f\u7528<code>os.rename()<\/code>\u51fd\u6570\u91cd\u547d\u540d\u6587\u4ef6\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E4%BA%8C%EF%BC%9A%E9%AB%98%E6%95%88%E7%9A%84%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86\"><\/span><strong>\u79d8\u7c4d\u4e8c\uff1a\u9ad8\u6548\u7684\u6570\u636e\u5904\u7406<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Python\u4e2d\u7684Pandas\u5e93\u662f\u5904\u7406\u8868\u683c\u6570\u636e\u7684\u5f3a\u5927\u5de5\u5177\u3002\u5b66\u4f1a\u4f7f\u7528\u5b83\uff0c\u80fd\u6781\u5927\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u6e05\u6d17\u548c\u5206\u6790CSV\u6570\u636e<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import&nbsp;pandas&nbsp;as&nbsp;pd<br><br>def&nbsp;clean_data(file_path):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u6e05\u6d17\u5e76\u5206\u6790CSV\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;file_path:&nbsp;CSV\u6587\u4ef6\u8def\u5f84<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;df&nbsp;=&nbsp;pd.read_csv(file_path)<br>&nbsp;&nbsp;&nbsp;&nbsp;df.dropna(inplace=True)<br>&nbsp;&nbsp;&nbsp;&nbsp;print(df.head())<br>&nbsp;&nbsp;&nbsp;&nbsp;print(df.describe())<br><br><em>#&nbsp;\u4f7f\u7528\u793a\u4f8b<\/em><br>clean_data(\"path\/to\/your\/data.csv\")<\/code><\/pre>\n\n\n\n<p><strong>\u8f93\u51fa\u7ed3\u679c<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&nbsp;&nbsp;&nbsp;ColumnA&nbsp;&nbsp;ColumnB<br>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20<br>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;40<br>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;60<br>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;70&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;80<br>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ColumnA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ColumnB<br>count&nbsp;&nbsp;4.000000e+00&nbsp;&nbsp;4.000000e+00<br>mean&nbsp;&nbsp;&nbsp;5.000000e+01&nbsp;&nbsp;5.000000e+01<br>std&nbsp;&nbsp;&nbsp;&nbsp;2.969848e+01&nbsp;&nbsp;2.969848e+01<br>min&nbsp;&nbsp;&nbsp;&nbsp;1.000000e+01&nbsp;&nbsp;2.000000e+01<br>25%&nbsp;&nbsp;&nbsp;&nbsp;3.000000e+01&nbsp;&nbsp;4.000000e+01<br>50%&nbsp;&nbsp;&nbsp;&nbsp;5.000000e+01&nbsp;&nbsp;6.000000e+01<br>75%&nbsp;&nbsp;&nbsp;&nbsp;7.000000e+01&nbsp;&nbsp;8.000000e+01<br>max&nbsp;&nbsp;&nbsp;&nbsp;9.000000e+01&nbsp;&nbsp;1.000000e+02<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u91cc\u6211\u4eec\u4f7f\u7528Pandas\u5e93\u8bfb\u53d6\u4e86\u4e00\u4e2aCSV\u6587\u4ef6\uff0c\u5e76\u5220\u9664\u4e86\u5176\u4e2d\u542b\u6709\u7a7a\u503c\u7684\u884c\u3002\u63a5\u7740\u6253\u5370\u4e86\u6570\u636e\u6846\u7684\u524d\u51e0\u884c\u4ee5\u53ca\u63cf\u8ff0\u6027\u7edf\u8ba1\u4fe1\u606f\uff0c\u5e2e\u52a9\u6211\u4eec\u5feb\u901f\u4e86\u89e3\u6570\u636e\u7684\u57fa\u672c\u60c5\u51b5\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E4%B8%89%EF%BC%9A%E6%96%87%E6%9C%AC%E5%A4%84%E7%90%86%E5%88%A9%E5%99%A8_%E2%80%94%E2%80%94_%E6%AD%A3%E5%88%99%E8%A1%A8%E8%BE%BE%E5%BC%8F\"><\/span><strong>\u79d8\u7c4d\u4e09\uff1a\u6587\u672c\u5904\u7406\u5229\u5668 \u2014\u2014 \u6b63\u5219\u8868\u8fbe\u5f0f<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6b63\u5219\u8868\u8fbe\u5f0f\uff08Regular Expression\uff09\u662f\u4e00\u79cd\u5f3a\u5927\u7684\u6587\u672c\u5339\u914d\u5de5\u5177\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u5feb\u901f\u5904\u7406\u6587\u672c\u6570\u636e\u3002\u65e0\u8bba\u662f\u67e5\u627e\u7279\u5b9a\u6a21\u5f0f\u7684\u5b57\u7b26\u4e32\uff0c\u8fd8\u662f\u66ff\u6362\u67d0\u4e9b\u5185\u5bb9\uff0c\u6b63\u5219\u8868\u8fbe\u5f0f\u90fd\u662f\u4e00\u4e2a\u4e0d\u53ef\u6216\u7f3a\u7684\u5de5\u5177\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u63d0\u53d6\u90ae\u7bb1\u5730\u5740<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import&nbsp;re<br><br>def&nbsp;extract_emails(text):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u4ece\u6587\u672c\u4e2d\u63d0\u53d6\u6240\u6709\u90ae\u7bb1\u5730\u5740\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;text:&nbsp;\u5f85\u5904\u7406\u7684\u6587\u672c<br>&nbsp;&nbsp;&nbsp;&nbsp;:return:&nbsp;\u5339\u914d\u5230\u7684\u6240\u6709\u90ae\u7bb1\u5730\u5740\u5217\u8868<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;pattern&nbsp;=&nbsp;r'\\b&#91;A-Za-z0-9._%+-]+@&#91;A-Za-z0-9.-]+\\.&#91;A-Z|a-z]{2,}\\b'<br>&nbsp;&nbsp;&nbsp;&nbsp;emails&nbsp;=&nbsp;re.findall(pattern,&nbsp;text)<br>&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;emails<br><br><em>#&nbsp;\u793a\u4f8b\u6587\u672c<\/em><br>text&nbsp;=&nbsp;\"\"\"<br>Hello,&nbsp;my&nbsp;email&nbsp;is&nbsp;example@example.com&nbsp;and&nbsp;another&nbsp;one&nbsp;is&nbsp;test@example.org.<br>Feel&nbsp;free&nbsp;to&nbsp;contact&nbsp;me&nbsp;at&nbsp;john.doe@gmail.com.<br>\"\"\"<br><br><em>#&nbsp;\u63d0\u53d6\u90ae\u7bb1\u5730\u5740<\/em><br>emails&nbsp;=&nbsp;extract_emails(text)<br>print(emails)<\/code><\/pre>\n\n\n\n<p><strong>\u8f93\u51fa\u7ed3\u679c<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;'example@example.com',&nbsp;'test@example.org',&nbsp;'john.doe@gmail.com']<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u6bb5\u4ee3\u7801\u5b9a\u4e49\u4e86\u4e00\u4e2a<code>extract_emails<\/code>\u51fd\u6570\uff0c\u7528\u4e8e\u4ece\u7ed9\u5b9a\u6587\u672c\u4e2d\u63d0\u53d6\u6240\u6709\u7b26\u5408\u90ae\u7bb1\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u3002\u6211\u4eec\u4f7f\u7528\u4e86\u6b63\u5219\u8868\u8fbe\u5f0f<code>r'\\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Z|a-z]{2,}\\b'<\/code>\u6765\u5339\u914d\u90ae\u7bb1\u5730\u5740\uff0c\u5e76\u901a\u8fc7<code>re.findall()<\/code>\u51fd\u6570\u8fd4\u56de\u6240\u6709\u5339\u914d\u7684\u7ed3\u679c\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E5%9B%9B%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96Excel%E6%93%8D%E4%BD%9C\"><\/span><strong>\u79d8\u7c4d\u56db\uff1a\u81ea\u52a8\u5316Excel\u64cd\u4f5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5728\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u5904\u7406Excel\u8868\u683c\u3002\u4f7f\u7528Python\u7684<code>openpyxl<\/code>\u5e93\uff0c\u6211\u4eec\u53ef\u4ee5\u8f7b\u677e\u5730\u8bfb\u53d6\u3001\u4fee\u6539\u548c\u521b\u5efaExcel\u6587\u4ef6\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u8bfb\u53d6\u5e76\u4fee\u6539Excel\u8868\u683c<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from&nbsp;openpyxl&nbsp;import&nbsp;load_workbook<br><br>def&nbsp;modify_excel(file_path):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u8bfb\u53d6\u5e76\u4fee\u6539Excel\u6587\u4ef6\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;file_path:&nbsp;Excel\u6587\u4ef6\u8def\u5f84<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;wb&nbsp;=&nbsp;load_workbook(file_path)<br>&nbsp;&nbsp;&nbsp;&nbsp;ws&nbsp;=&nbsp;wb.active<br>&nbsp;&nbsp;&nbsp;&nbsp;ws&#91;'A1']&nbsp;=&nbsp;'Hello,&nbsp;Python!'<br>&nbsp;&nbsp;&nbsp;&nbsp;wb.save(file_path)<br><br><em>#&nbsp;\u4f7f\u7528\u793a\u4f8b<\/em><br>modify_excel('path\/to\/your\/excel.xlsx')<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u6bb5\u4ee3\u7801\u5b9a\u4e49\u4e86\u4e00\u4e2a<code>modify_excel<\/code>\u51fd\u6570\uff0c\u7528\u4e8e\u8bfb\u53d6\u5e76\u4fee\u6539Excel\u6587\u4ef6\u3002\u6211\u4eec\u9996\u5148\u4f7f\u7528<code>load_workbook()<\/code>\u51fd\u6570\u52a0\u8f7d\u6307\u5b9a\u8def\u5f84\u7684Excel\u6587\u4ef6\uff0c\u7136\u540e\u9009\u62e9\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868\uff08\u9ed8\u8ba4\u4e3a\u6d3b\u52a8\u5de5\u4f5c\u8868\uff09\uff0c\u4fee\u6539A1\u5355\u5143\u683c\u7684\u5185\u5bb9\uff0c\u5e76\u5c06\u4fee\u6539\u540e\u7684\u5de5\u4f5c\u7c3f\u4fdd\u5b58\u56de\u539f\u6587\u4ef6\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E4%BA%94%EF%BC%9AWeb%E8%87%AA%E5%8A%A8%E5%8C%96%E7%88%AC%E8%99%AB\"><\/span><strong>\u79d8\u7c4d\u4e94\uff1aWeb\u81ea\u52a8\u5316\u722c\u866b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5f88\u591a\u65f6\u5019\u6211\u4eec\u9700\u8981\u4ece\u7f51\u9875\u4e0a\u6293\u53d6\u6570\u636e\u3002Python\u7684<code>requests<\/code>\u548c<code>BeautifulSoup<\/code>\u5e93\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u8f7b\u677e\u5b9e\u73b0\u8fd9\u4e00\u76ee\u6807\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u722c\u53d6\u7f51\u9875\u5185\u5bb9<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import&nbsp;requests<br>from&nbsp;bs4&nbsp;import&nbsp;BeautifulSoup<br><br>def&nbsp;web_scraping(url):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u722c\u53d6\u6307\u5b9aURL\u7684\u7f51\u9875\u5185\u5bb9\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;url:&nbsp;\u76ee\u6807\u7f51\u9875\u7684URL<br>&nbsp;&nbsp;&nbsp;&nbsp;:return:&nbsp;\u89e3\u6790\u540e\u7684HTML\u5185\u5bb9<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;response&nbsp;=&nbsp;requests.get(url)<br>&nbsp;&nbsp;&nbsp;&nbsp;soup&nbsp;=&nbsp;BeautifulSoup(response.text,&nbsp;'html.parser')<br>&nbsp;&nbsp;&nbsp;&nbsp;title&nbsp;=&nbsp;soup.title.string<br>&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;title<br><br><em>#&nbsp;\u4f7f\u7528\u793a\u4f8b<\/em><br>url&nbsp;=&nbsp;'https:\/\/www.example.com'<br>title&nbsp;=&nbsp;web_scraping(url)<br>print(title)<\/code><\/pre>\n\n\n\n<p><strong>\u8f93\u51fa\u7ed3\u679c<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Example&nbsp;Domain<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u6bb5\u4ee3\u7801\u5b9a\u4e49\u4e86\u4e00\u4e2a<code>web_scraping<\/code>\u51fd\u6570\uff0c\u7528\u4e8e\u722c\u53d6\u6307\u5b9aURL\u7684\u7f51\u9875\u5185\u5bb9\u3002\u6211\u4eec\u4f7f\u7528<code>requests.get()<\/code>\u53d1\u9001HTTP\u8bf7\u6c42\uff0c\u7136\u540e\u4f7f\u7528<code>BeautifulSoup<\/code>\u89e3\u6790\u8fd4\u56de\u7684HTML\u5185\u5bb9\u3002\u6700\u540e\u63d0\u53d6\u9875\u9762\u7684\u6807\u9898\u5e76\u8fd4\u56de\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%98%E7%B1%8D%E5%85%AD%EF%BC%9A%E8%87%AA%E5%8A%A8%E5%8C%96%E9%82%AE%E4%BB%B6%E5%8F%91%E9%80%81\"><\/span><strong>\u79d8\u7c4d\u516d\uff1a\u81ea\u52a8\u5316\u90ae\u4ef6\u53d1\u9001<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5728\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u5e38\u5e38\u9700\u8981\u53d1\u9001\u4e00\u4e9b\u62a5\u544a\u6216\u901a\u77e5\u3002Python\u7684<code>smtplib<\/code>\u5e93\u53ef\u4ee5\u8ba9\u6211\u4eec\u8f7b\u677e\u5b9e\u73b0\u81ea\u52a8\u5316\u90ae\u4ef6\u53d1\u9001\u3002<\/p>\n\n\n\n<p><strong>\u793a\u4f8b\uff1a\u53d1\u9001\u90ae\u4ef6<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import&nbsp;smtplib<br>from&nbsp;email.mime.text&nbsp;import&nbsp;MIMEText<br><br>def&nbsp;send_email(subject,&nbsp;body,&nbsp;recipient):<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;\u53d1\u9001\u90ae\u4ef6\u3002<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;subject:&nbsp;\u90ae\u4ef6\u4e3b\u9898<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;body:&nbsp;\u90ae\u4ef6\u6b63\u6587<br>&nbsp;&nbsp;&nbsp;&nbsp;:param&nbsp;recipient:&nbsp;\u6536\u4ef6\u4eba\u90ae\u7bb1\u5730\u5740<br>&nbsp;&nbsp;&nbsp;&nbsp;\"\"\"<br>&nbsp;&nbsp;&nbsp;&nbsp;server&nbsp;=&nbsp;smtplib.SMTP('smtp.example.com',&nbsp;587)<br>&nbsp;&nbsp;&nbsp;&nbsp;server.starttls()<br>&nbsp;&nbsp;&nbsp;&nbsp;server.login('your_username',&nbsp;'your_password')<br>&nbsp;&nbsp;&nbsp;&nbsp;msg&nbsp;=&nbsp;MIMEText(body)<br>&nbsp;&nbsp;&nbsp;&nbsp;msg&#91;'Subject']&nbsp;=&nbsp;subject<br>&nbsp;&nbsp;&nbsp;&nbsp;msg&#91;'From']&nbsp;=&nbsp;'your_username@example.com'<br>&nbsp;&nbsp;&nbsp;&nbsp;msg&#91;'To']&nbsp;=&nbsp;recipient<br>&nbsp;&nbsp;&nbsp;&nbsp;server.sendmail('your_username@example.com',&nbsp;&#91;recipient],&nbsp;msg.as_string())<br>&nbsp;&nbsp;&nbsp;&nbsp;server.quit()<br><br><em>#&nbsp;\u4f7f\u7528\u793a\u4f8b<\/em><br>send_email('Hello&nbsp;from&nbsp;Python!',&nbsp;'This&nbsp;is&nbsp;a&nbsp;test&nbsp;email.',&nbsp;'recipient@example.com')<\/code><\/pre>\n\n\n\n<p><strong>\u4ee3\u7801\u89e3\u91ca<\/strong>\uff1a\u8fd9\u6bb5\u4ee3\u7801\u5b9a\u4e49\u4e86\u4e00\u4e2a<code>send_email<\/code>\u51fd\u6570\uff0c\u7528\u4e8e\u53d1\u9001\u90ae\u4ef6\u3002\u6211\u4eec\u9996\u5148\u521b\u5efa\u4e00\u4e2aSMTP\u8fde\u63a5\uff0c\u5e76\u4f7f\u7528<code>starttls()<\/code>\u548c<code>login()<\/code>\u65b9\u6cd5\u8fdb\u884c\u5b89\u5168\u8ba4\u8bc1\u3002\u63a5\u7740\u521b\u5efa\u4e00\u4e2a\u90ae\u4ef6\u5bf9\u8c61\uff0c\u8bbe\u7f6e\u90ae\u4ef6\u7684\u4e3b\u9898\u3001\u53d1\u4ef6\u4eba\u548c\u6536\u4ef6\u4eba\uff0c\u6700\u540e\u4f7f\u7528<code>sendmail()<\/code>\u65b9\u6cd5\u53d1\u9001\u90ae\u4ef6\uff0c\u5e76\u5173\u95ed\u8fde\u63a5\u3002<\/p>\n\n\n\n<p>\u4ee5\u4e0a\u5c31\u662f\u4eca\u5929\u7684\u516d\u4e2a\u79d8\u7c4d\u3002\u901a\u8fc7\u8fd9\u4e9b\u6280\u5de7\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230Python\u5728\u63d0\u9ad8\u5de5\u4f5c\u6548\u7387\u65b9\u9762\u7684\u5de8\u5927\u6f5c\u529b\u3002\u5e0c\u671b\u8fd9\u4e9b\u65b9\u6cd5\u80fd\u591f\u5e2e\u52a9\u4f60\u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\u66f4\u52a0\u9ad8\u6548\u5730\u5b8c\u6210\u4efb\u52a1\u3002\u656c\u8bf7\u671f\u5f85\u66f4\u591a\u5b9e\u7528\u6280\u5de7\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u79d8\u7c4d\u4e00\uff1a\u81ea\u52a8\u5316\u6587\u4ef6\u64cd\u4f5c \u5904\u7406\u5927\u91cf\u7684\u6587\u4ef6\u65f6\uff0c\u624b\u52a8\u64cd\u4f5c\u4e0d\u4ec5\u8017\u65f6\u8fd8\u5bb9\u6613\u51fa\u9519\u3002Python\u53ef\u4ee5\u5e2e\u4f60\u81ea\u52a8\u5b8c\u6210\u8fd9&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2024\/11\/28\/python%e5%9f%ba%e7%a1%80%e6%8a%80%e8%83%bd-python%e6%8f%90%e5%8d%87%e5%b7%a5%e4%bd%9c%e6%95%88%e7%8e%87%e7%9a%847%e4%b8%aa%e5%ae%9e%e7%94%a8%e7%a7%98%e7%b1%8d\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">PYTHON\u57fa\u7840\u6280\u80fd \u2013\u00a0Python\u63d0\u5347\u5de5\u4f5c\u6548\u7387\u76847\u4e2a\u5b9e\u7528\u79d8\u7c4d<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[28],"views":954,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2889"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=2889"}],"version-history":[{"count":1,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2889\/revisions"}],"predecessor-version":[{"id":2890,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2889\/revisions\/2890"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=2889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=2889"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=2889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}