{"id":725,"date":"2023-03-01T15:05:59","date_gmt":"2023-03-01T07:05:59","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=725"},"modified":"2023-03-01T15:06:01","modified_gmt":"2023-03-01T07:06:01","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-%e4%b8%ad%e6%96%87%e5%a7%93%e5%90%8d%e8%87%aa%e5%8b%95%e7%94%a2%e7%94%9f%e5%99%a8%ef%bc%8c%e6%ba%90%e8%87%aarichy-li","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/725\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: \u4e2d\u6587\u59d3\u540d\u81ea\u52d5\u7522\u751f\u5668\uff0c\u6e90\u81eaRichy Li"},"content":{"rendered":"\n<h2>\u672c\u6587\u59d3\u540d\u8cc7\u6599\u6e90\u81ea\u65bc\u300c\u4e2d\u6587\u59d3\u540d\u7522\u751f\u5668\u300d\u7db2\u7ad9\uff0c\u9023\u7d50\u5982\u4e0b\uff1a<\/h2>\n\n\n\n<p><a href=\"http:\/\/www.richyli.com\/name\/index.asp\" target=\"_blank\" rel=\"noreferrer noopener\">\u4e2d\u6587\u59d3\u540d\u7522\u751f\u5668<\/a><\/p>\n\n\n\n<p>\u9019\u500b\u7db2\u7ad9\u63d0\u4f9b\u4e86\u5f88\u68d2\u7684\u4e2d\u6587\u59d3\u540d\u81ea\u52d5\u7522\u751f\u7684\u8cc7\u6599\uff0c\u751a\u81f3\u4e00\u6b21\u6700\u591a\u80fd\u7522\u751f\u51fa2\u842c\u7b46\u4e2d\u6587\u59d3\u540d\uff0c<br>\u61c9\u8a72\u90fd\u7b26\u5408\u5927\u90e8\u4efd\u7684\u4f7f\u7528\u8005\u7684\u9700\u6c42\u4e86\u3002<\/p>\n\n\n\n<p>\u9019\u500b\u7db2\u7ad9\u5f88\u7279\u5225\u7684\u662f\uff0c\u6bcf\u6b21\u9023\u4e0a\u53bb\uff0c\u7db2\u9801\u5c31\u6703\u81ea\u52d5\u7522\u751f100\u7b46\u4e2d\u6587\u59d3\u540d\u3002<br>\u53ea\u8981\u91cd\u65b0\u6574\u7406\u4e00\u6b21\uff0c\u5c31\u6703\u7522\u751f100\u7b46\u4e2d\u6587\u59d3\u540d\uff0c\u900f\u904e\u9019\u6a23\u7684\u7db2\u7ad9\u7279\u6027\uff0c<br>\u6211\u89e3\u6790\u4e86\u7db2\u9801\uff0c\u5beb\u4e86\u4e00\u500b\u5c0f\u7a0b\u5f0f\u4f86\u4f9d\u9700\u6c42\u7522\u751f\u4e2d\u6587\u59d3\u540d\uff08\u4f9d100\u7684\u500d\u6578\u7522\u751f\uff09\u3002<\/p>\n\n\n\n<h1>\u9019\u88cf\u8981\u62dc\u8a17\u5927\u5bb6\u4e0d\u8981\u7528\u7a0b\u5f0f\u53bb\u9020\u6210\u7db2\u7ad9\u7684\u8ca0\u64d4!!<\/h1>\n\n\n\n<p>\u4ee5\u4e0b\u70ba\u7a0b\u5f0f\u78bc\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport requests\nimport pandas as pd\n\n# \u8a2d\u5b9atime\u70ba\u7372\u53d6\u4e2d\u6587\u59d3\u540d100\u7b46\u7684\u500d\u6578\u3002time=3\uff0c\u5c31\u662f300\u7b46\u7684\u610f\u601d\u3002\ntimes = 2\ncnames = &#x5B;]\nfor x in range(times):\n    url = 'http:\/\/www.richyli.com\/name\/index.asp'\n    r = requests.get(url)\n    r.encoding = 'big5'\n    \n    # \u5c07\u7db2\u9801\u4e2d\u7684\u8cc7\u6599\u4ee5\u5206\u884c\u7684\u65b9\u5f0f\u5b58\u6210\u6587\u5b57\u6a94\n    result = r.text.splitlines()\n    \n    # 114\u662f\u4e2d\u6587\u59d3\u540d\u958b\u59cb\u7684\u5217\uff0c\u627e\u5230\u6700\u5f8c\u4e00\u500b\u300c\u3001\u300d\uff0c\u8a2d\u5b9a\u6210\u70ba\u5b57\u4e32\u7684\u5207\u7247\u4f4d\u7f6e\u3002\n    char_index = result&#x5B;114].rfind(&quot;\u3001&quot;)\n    temp = result&#x5B;114]&#x5B;:char_index]\n    \n    # \u5c07temp\u7684100\u7b46\u59d3\u540d\u65b0\u589e\u5230cnames\u4e2d\n    cnames.append(temp)\n\n# \u5c07\u6bcf100\u7b46\u59d3\u540d\u7684list\u52a0\u4e00\u500b\u300c\u3001\u300d\uff0c\u518d\u7d44\u5408\u6210\u5b57\u4e32\u5b58\u5230my_names\u4e2d\nmy_names = &quot;\u3001&quot;.join(str(x) for x in cnames)\nprint(my_names)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"246\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143154-1024x246.jpg\" alt=\"\" class=\"wp-image-726\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143154-1024x246.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143154-300x72.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143154-768x184.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143154.jpg 1117w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u5c07\u4e0a\u9762\u7684\u59d3\u540d\u751f\u6210dataframe\ndf_name = pd.DataFrame(my_names.split('\u3001'), columns=&#x5B;'\u59d3\u540d'])\nprint(f'\u4e2d\u6587\u59d3\u540d\u7b46\u6578\uff1a{len(df_name)}')\ndf_name\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"182\" height=\"503\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143234.jpg\" alt=\"\" class=\"wp-image-727\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143234.jpg 182w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-143234-109x300.jpg 109w\" sizes=\"(max-width: 182px) 100vw, 182px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u8b80\u53d6111\u5b78\u5e74\u5ea6\u5927\u5c08\u6821\u9662\u4e00\u89bd\u8868- \u6559\u80b2\u90e8\nurl_s = 'https:\/\/ulist.moe.gov.tw\/Download\/StartDownload?FileName=ulistdepartmentlist_college.xlsx'\ndf_school = pd.read_excel(url_s, skiprows=1)\nprint(f'\u5927\u5c08\u6821\u9662\u7cfb\u6240\u6578\uff1a{len(df_school)}')\ndf_school.head()\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"331\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145223-1024x331.jpg\" alt=\"\" class=\"wp-image-728\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145223-1024x331.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145223-300x97.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145223-768x248.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145223.jpg 1102w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u96a8\u6a5f\u62bd\u53d610\u500b\u5b78\u6821\u3001\u7cfb\u6240\u548c\u59d3\u540d\u7d50\u5408\u5f8c\uff0c\u505a\u6210\u4e00\u500bdataframe\ndf = (pd.concat(&#x5B;df_school&#x5B;&#x5B;'\u5b78\u6821\u540d\u7a31', '\u7cfb\u6240\u540d\u7a31']]\n                 .sample(n=10).reset_index(drop=True),\n                 df_name.sample(n=10).reset_index(drop=True)], axis=1)\n     )\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"576\" height=\"398\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145539.jpg\" alt=\"\" class=\"wp-image-729\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145539.jpg 576w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-01-145539-300x207.jpg 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<p>\u4ee5\u4e0a\u5c31\u5b8c\u621010\u500b\u62bd\u6a23\u5b78\u6821\u3001\u7cfb\u6240\u53ca\u59d3\u540d\u7684\u7d44\u540d!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u59d3\u540d\u8cc7\u6599\u6e90\u81ea\u65bc\u300c\u4e2d\u6587\u59d3\u540d\u7522\u751f\u5668\u300d\u7db2\u7ad9\uff0c\u9023\u7d50\u5982\u4e0b\uff1a \u4e2d\u6587\u59d3\u540d\u7522\u751f\u5668 \u9019\u500b\u7db2\u7ad9\u63d0\u4f9b\u4e86\u5f88\u68d2\u7684\u4e2d\u6587\u59d3\u540d\u81ea\u52d5\u7522\u751f\u7684\u8cc7 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"categories":[4],"tags":[227,8,9,376,375],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/jchrnikx0tm-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">concat<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Pandas<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Python<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Richy Li<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">\u4e2d\u6587\u59d3\u540d\u81ea\u52d5\u7522\u751f\u5668<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">concat<\/span>","<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">Richy Li<\/span>","<span class=\"advgb-post-tax-term\">\u4e2d\u6587\u59d3\u540d\u81ea\u52d5\u7522\u751f\u5668<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2023 \u5e74 3 \u6708 1 \u65e5","modified":"Updated on 2023 \u5e74 3 \u6708 1 \u65e5"},"absolute_dates_time":{"created":"Posted on 2023 \u5e74 3 \u6708 1 \u65e5 \u4e0b\u5348 3:05","modified":"Updated on 2023 \u5e74 3 \u6708 1 \u65e5 \u4e0b\u5348 3:06"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/725"}],"collection":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/comments?post=725"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/725\/revisions"}],"predecessor-version":[{"id":731,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/725\/revisions\/731"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/730"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}