{"id":550,"date":"2022-12-09T11:12:53","date_gmt":"2022-12-09T03:12:53","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=550"},"modified":"2022-12-09T11:13:33","modified_gmt":"2022-12-09T03:13:33","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e6%ac%84%e4%bd%8d%e5%85%a7%e5%ae%b9%e7%b0%a1%e5%96%ae%e5%88%86%e9%a1%9e","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/550\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u6b04\u4f4d\u5167\u5bb9\u7c21\u55ae\u5206\u985e"},"content":{"rendered":"\n<p>\u7b2c\u4e00\u500b\u7bc4\u4f8b\uff1a\u628a\u5927\u5b78\u5206\u985e\u70ba\u300c\u516c\u7acb\u300d\u8207\u300c\u79c1\u7acb\u300d\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nmydict = {'\u5b78\u6821\u540d\u7a31': {0: '\u570b\u7acb\u653f\u6cbb\u5927\u5b78',\n  1: '\u570b\u7acb\u81fa\u7063\u5927\u5b78',\n  2: '\u570b\u7acb\u81fa\u5317\u6559\u80b2\u5927\u5b78',\n  3: '\u81fa\u5317\u5e02\u7acb\u5927\u5b78',\n  4: '\u570b\u7acb\u81fa\u7063\u79d1\u6280\u5927\u5b78',\n  5: '\u6771\u5433\u5927\u5b78',\n  6: '\u4e2d\u570b\u6587\u5316\u5927\u5b78',\n  7: '\u4e16\u65b0\u5927\u5b78',\n  8: '\u9298\u50b3\u5927\u5b78',\n  9: '\u5be6\u8e10\u5927\u5b78',\n  10: '\u5927\u540c\u5927\u5b78',\n  11: '\u81fa\u5317\u91ab\u5b78\u5927\u5b78'}}\n\ndf = pd.DataFrame(mydict)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"192\" height=\"465\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-102829.jpg\" alt=\"\" class=\"wp-image-551\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-102829.jpg 192w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-102829-124x300.jpg 124w\" sizes=\"(max-width: 192px) 100vw, 192px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport numpy as np\n# \u7b2c\u4e00\u7a2e\u5beb\u6cd5\ndf&#x5B;'\u5b78\u6821\u5206\u985e'] = np.where(df&#x5B;'\u5b78\u6821\u540d\u7a31'].str.contains('\u570b\u7acb|\u5e02\u7acb'), '\u516c\u7acb', '\u79c1\u7acb')\n\n# \u7b2c\u4e8c\u7a2e\u5beb\u6cd5\ndf&#x5B;'\u5b78\u6821\u5206\u985e'] = np.where(df&#x5B;'\u5b78\u6821\u540d\u7a31'].str.contains('|'.join(&#x5B;'\u570b\u7acb','\u5e02\u7acb'])), '\u516c\u7acb', '\u79c1\u7acb')\n\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"248\" height=\"470\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-103913.jpg\" alt=\"\" class=\"wp-image-552\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-103913.jpg 248w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-103913-158x300.jpg 158w\" sizes=\"(max-width: 248px) 100vw, 248px\" \/><\/figure>\n\n\n\n<p>\u7b2c\u4e8c\u500b\u7bc4\u4f8b\uff1a\u628a\u6559\u80b2\u7a0b\u5ea6\u5340\u5206\u70ba\u300c\u9ad8\u4e2d\u300d\u53ca\u300c\u975e\u9ad8\u4e2d\u300d<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nmydict = {'\u5b78\u6b77': {0: '\u570b\u5c0f', 1: '\u570b\u4e2d', 2: '\u5c08\u79d1', 3: '\u9ad8\u4e2d', 4: '\u5927\u5b78'}}\ndf = pd.DataFrame(mydict)\ndf\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"87\" height=\"230\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-105001.jpg\" alt=\"\" class=\"wp-image-553\"\/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e00\u7a2e\u5beb\u6cd5\ndf&#x5B;'\u6559\u80b2\u7a0b\u5ea6'] = df&#x5B;'\u5b78\u6b77'].where(df&#x5B;'\u5b78\u6b77'].eq('\u9ad8\u4e2d'), '\u975e\u9ad8\u4e2d')\n\n# \u7b2c\u4e8c\u7a2e\u5beb\u6cd5\ntarget = {'\u9ad8\u4e2d':'\u9ad8\u4e2d'}\ndf&#x5B;'\u6559\u80b2\u7a0b\u5ea6'] = df&#x5B;'\u5b78\u6b77'].map(target).fillna('\u975e\u9ad8\u4e2d')\n\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"148\" height=\"220\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-09-105547.jpg\" alt=\"\" class=\"wp-image-554\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u7b2c\u4e00\u500b\u7bc4\u4f8b\uff1a\u628a\u5927\u5b78\u5206\u985e\u70ba\u300c\u516c\u7acb\u300d\u8207\u300c\u79c1\u7acb\u300d\uff1a \u7b2c\u4e8c\u500b\u7bc4\u4f8b\uff1a\u628a\u6559\u80b2\u7a0b\u5ea6\u5340\u5206\u70ba\u300c\u9ad8\u4e2d\u300d\u53ca\u300c\u975e\u9ad8\u4e2d\u300d<\/p>\n","protected":false},"author":1,"featured_media":556,"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":[8,9,213,214],"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\/12\/uo0pvm-qnhi-200x300.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\">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\">\u5206\u985e<\/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\">\u6b04\u4f4d\u5167\u5bb9<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">\u5206\u985e<\/span>","<span class=\"advgb-post-tax-term\">\u6b04\u4f4d\u5167\u5bb9<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 12 \u6708 9 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 9 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 9 \u65e5 \u4e0a\u5348 11:12","modified":"Updated on 2022 \u5e74 12 \u6708 9 \u65e5 \u4e0a\u5348 11:13"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/550"}],"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=550"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/550\/revisions"}],"predecessor-version":[{"id":558,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/550\/revisions\/558"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/556"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}