{"id":519,"date":"2022-11-17T17:36:29","date_gmt":"2022-11-17T09:36:29","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=519"},"modified":"2022-11-30T15:36:42","modified_gmt":"2022-11-30T07:36:42","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e5%a4%9a%e6%ac%84%e4%bd%8d%e3%80%81%e5%a4%9a%e6%a2%9d%e4%bb%b6%e7%af%a9%e9%81%b8","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/519\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u591a\u6b04\u4f4d\u3001\u591a\u689d\u4ef6\u7be9\u9078"},"content":{"rendered":"\n<p>\u4ee5\u4e0b\u7684\u8ab2\u7a0b\u7684\u8ab2\u540d\u4f86\u81ea\u516c\u958b\u8cc7\u6599\uff0c\u4f46\u6559\u5e2b\u3001\u5b78\u751f\u59d3\u540d\u53ca\u5176\u4ed6\u6b04\u4f4d\u5747\u70ba\u865b\u69cb\u8cc7\u6599\uff08\u4eba\u540d\u70ba\u4e82\u6578\u7522\u751f\uff09\u3002<\/p>\n\n\n\n<p>\u5047\u8a2d\u6211\u5011\u6709\u4e00\u500bExcel\u8cc7\u6599\u6a94\uff0c\u8a18\u9304\u4e86\u5b78\u6821\u7684\u512a\u826f\u8ab2\u7a0b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"882\" height=\"478\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170857.jpg\" alt=\"\" class=\"wp-image-520\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170857.jpg 882w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170857-300x163.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170857-768x416.jpg 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<p>\u6211\u5011\u60f3\u5f9e\u6240\u6709\u5b78\u751f\u7684\u9078\u8ab2\u8cc7\u6599\u4e2d\u4e86\u89e3\u9078\u4fee\u512a\u826f\u8ab2\u7a0b\u7684\u5b78\u751f\u8cc7\u6599\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"942\" height=\"675\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170933.jpg\" alt=\"\" class=\"wp-image-521\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170933.jpg 942w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170933-300x215.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-170933-768x550.jpg 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport pandas as pd\nLocation = '0000_\u7bc4\u4f8b_\u512a\u826f\u8ab2\u7a0b_\u5b78\u751f\u9078\u8ab2.xlsx'\ndf1 = pd.read_excel(Location, sheet_name='\u7bc4\u4f8b\u512a\u826f\u8ab2\u7a0b')\nprint(len(df1))\nprint(df1.columns)\ndf1.head()\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"275\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171317.jpg\" alt=\"\" class=\"wp-image-522\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171317.jpg 945w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171317-300x87.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171317-768x223.jpg 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf2 = pd.read_excel(Location, sheet_name='\u7bc4\u4f8b\u5b78\u751f\u9078\u8ab2')\nprint(len(df2))\nprint(df2.columns)\ndf2.head()\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1021\" height=\"300\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171519.jpg\" alt=\"\" class=\"wp-image-523\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171519.jpg 1021w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171519-300x88.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171519-768x226.jpg 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e00\u7a2e\u65b9\u6cd5\ndf = pd.merge(df2, df1&#x5B;&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u8ab2\u865f']], on=&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u8ab2\u865f'])\nprint(len(df))\nprint(df.columns)\ndf.head()\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1023\" height=\"312\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171737.jpg\" alt=\"\" class=\"wp-image-524\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171737.jpg 1023w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171737-300x91.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171737-768x234.jpg 768w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e8c\u7a2e\u65b9\u6cd5\ndf = df2&#x5B;df2.set_index(&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u8ab2\u865f']).index.isin(df1.set_index(&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u8ab2\u865f']).index)]\nprint(len(df))\ndf.head()\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"301\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171959-1024x301.jpg\" alt=\"\" class=\"wp-image-525\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171959-1024x301.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171959-300x88.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171959-768x226.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-17-171959.jpg 1027w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u7684\u8ab2\u7a0b\u7684\u8ab2\u540d\u4f86\u81ea\u516c\u958b\u8cc7\u6599\uff0c\u4f46\u6559\u5e2b\u3001\u5b78\u751f\u59d3\u540d\u53ca\u5176\u4ed6\u6b04\u4f4d\u5747\u70ba\u865b\u69cb\u8cc7\u6599\uff08\u4eba\u540d\u70ba\u4e82\u6578\u7522\u751f\uff09\u3002 \u5047\u8a2d\u6211\u5011\u6709\u4e00\u500bExc [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":526,"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":"","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":"","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":[201,8,202,203,204],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/hgzxkqaibbq-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\">csv<\/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\">\u591a\u689d\u4ef6<\/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\">\u591a\u6b04\u4f4d<\/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\">\u7be9\u9078<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">csv<\/span>","<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">\u591a\u689d\u4ef6<\/span>","<span class=\"advgb-post-tax-term\">\u591a\u6b04\u4f4d<\/span>","<span class=\"advgb-post-tax-term\">\u7be9\u9078<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 11 \u6708 17 \u65e5","modified":"Updated on 2022 \u5e74 11 \u6708 30 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 11 \u6708 17 \u65e5 \u4e0b\u5348 5:36","modified":"Updated on 2022 \u5e74 11 \u6708 30 \u65e5 \u4e0b\u5348 3:36"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/519"}],"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=519"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/519\/revisions"}],"predecessor-version":[{"id":527,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/519\/revisions\/527"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/526"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}