{"id":531,"date":"2022-11-30T16:05:19","date_gmt":"2022-11-30T08:05:19","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=531"},"modified":"2022-11-30T16:05:21","modified_gmt":"2022-11-30T08:05:21","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e6%ac%84%e4%bd%8d%e9%83%a8%e4%bb%bd%e5%ad%97%e5%85%83%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\/531\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u6b04\u4f4d\u90e8\u4efd\u5b57\u5143\u7be9\u9078"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport pandas as pd\n\ndict = {'\u5b78\u5e74': {0: 108,\n  1: 108,\n  2: 108,\n  3: 108,\n  4: 108,\n  5: 108,\n  6: 108,\n  7: 108,\n  8: 108,\n  9: 108},\n '\u5b78\u671f': {0: 1, 1: 1, 2: 1, 3: 1, 4: 1, 5: 1, 6: 1, 7: 1, 8: 1, 9: 1},\n '\u958b\u8ab2\u7cfb\u6240': {0: '\u6cd5\u5f8b\u5b78\u7cfb',\n  1: '\u901a\u8b58\u7d44',\n  2: '\u96fb\u6a5f\u6240',\n  3: '\u96fb\u6a5f\u6240',\n  4: '\u96fb\u6a5f\u6240',\n  5: '\u96fb\u6a5f\u6240',\n  6: '\u96fb\u6a5f\u6240',\n  7: '\u5730\u8cea\u6240',\n  8: '\u5730\u8cea\u6240',\n  9: '\u5730\u8cea\u6240'},\n '\u8ab2\u865f': {0: 'A0263',\n  1: 'A0163',\n  2: 'A0134',\n  3: 'A0164',\n  4: 'A0238',\n  5: 'A0273',\n  6: 'A0431',\n  7: 'A0118',\n  8: 'A0149',\n  9: 'A0204'},\n '\u8ab2\u540d': {0: '\u8457\u4f5c\u6b0a\u8207\u50b3\u64ad\u6cd5\u898f',\n  1: '\u6c11\u6cd5\u50b5\u7de8\u7e3d\u8ad6',\n  2: '\u670d\u52d9\u5b78\u7fd2\u4e8c',\n  3: '\u4e9e\u6d32\u96fb\u5f71\u8207\u653f\u6cbb',\n  4: '\u7fbd\u7403(\u4e00)',\n  5: '\u904b\u52d5\u5c08\u9577\u8a13\u7df4\u5c08\u984c\u7814\u7a76',\n  6: '\u667a\u6167\u8ca1\u7522\u6b0a\u6cd5\u5c08\u984c\u7814\u7a76(\u4e09)',\n  7: '\u666e\u901a\u5316\u5b78\u4e19',\n  8: '\u82f1\u6587\u80fd\u529b\u6aa2\u5b9a',\n  9: '\u5c0e\u904a\u5be6\u52d9'},\n '\u5b78\u5206': {0: 0.5,\n  1: 3.0,\n  2: 1.0,\n  3: 3.0,\n  4: 3.0,\n  5: 3.0,\n  6: 3.0,\n  7: 0.0,\n  8: 2.0,\n  9: 0.0},\n '\u6559\u5e2b': {0: '\u4f59\u91c7\u84c9',\n  1: '\u5f35\u5a01\u5fb7',\n  2: '\u5468\u4f69\u82b8',\n  3: '\u6797\u4f73\u71d5',\n  4: '\u8521\u5049\u5a77',\n  5: '\u90ed\u7f8e\u6c11',\n  6: '\u694a\u535a\u4ec1',\n  7: '\u9ec3\u6a02\u739f',\n  8: '\u9673\u5b78\u5947',\n  9: '\u6797\u656c\u5cb3'},\n '\u4e0a\u8ab2\u6642\u9593': {0: '\u4e003\u4e004',\n  1: '\u4e8c5\u56db5\u56db6',\n  2: '\u4e8c10\u4e8c11',\n  3: '\u4e8c2\u4e8c3\u4e8c4',\n  4: '\u4e942\u4e943\u4e944',\n  5: '\u4e8c5\u4e8c6\u4e8c7',\n  6: '\u4e8c5\u4e8c6\u4e8c7',\n  7: '\u4e003\u4e004',\n  8: '\u4e005\u4e006',\n  9: '\u56db1\u56db2'},\n '\u4fee\u8ab2\u4eba\u6578': {0: 9, 1: 57, 2: 41, 3: 46, 4: 22, 5: 9, 6: 22, 7: 39, 8: 55, 9: 54},\n '\u5b78\u865f': {0: 'K00001',\n  1: 'K00002',\n  2: 'K00003',\n  3: 'K00004',\n  4: 'K00005',\n  5: 'K00006',\n  6: 'K00007',\n  7: 'K00008',\n  8: 'K00009',\n  9: 'K00010'},\n '\u4fee\u8ab2\u5b78\u751f\u90e8\u5225': {0: '\u5927\u5b78\u90e8',\n  1: '\u5927\u5b78\u90e8',\n  2: '\u5927\u5b78\u90e8',\n  3: '\u5927\u5b78\u90e8',\n  4: '\u5927\u5b78\u90e8',\n  5: '\u5927\u5b78\u90e8',\n  6: '\u5927\u5b78\u90e8',\n  7: '\u5927\u5b78\u90e8',\n  8: '\u5927\u5b78\u90e8',\n  9: '\u5927\u5b78\u90e8'},\n '\u4fee\u8ab2\u5b78\u751f\u7cfb\u6240': {0: '\u68ee\u6797\u74b0\u8cc7\u7cfb',\n  1: '\u901a\u8b58\u7d44',\n  2: '\u96fb\u6a5f\u6240',\n  3: '\u68ee\u6797\u74b0\u8cc7\u7cfb',\n  4: '\u96fb\u6a5f\u6240',\n  5: '\u96fb\u6a5f\u6240',\n  6: '\u96fb\u6a5f\u6240',\n  7: '\u6cd5\u5f8b\u7cfb',\n  8: '\u516c\u885b\u7cfb',\n  9: '\u5316\u5de5\u7cfb'},\n '\u5b78\u751f\u59d3\u540d': {0: '\u5f35\u4e2d\u9298',\n  1: '\u5289\u4fca\u6770',\n  2: '\u8a31\u54f2\u739f',\n  3: '\u5433\u6587\u82b8',\n  4: '\u6234\u4ef2\u539f',\n  5: '\u5f35\u745e\u559c',\n  6: '\u8b1d\u826f\u6728',\n  7: '\u6797\u5609\u7532',\n  8: '\u9673\u9e97\u82ac',\n  9: '\u6c88\u50b3\u82b1'}}\n\n# \u8a2d\u5047\u8981\u7be9\u9078\u5b78\u751f\u59d3\u540d\u4e2d\u542b\u6709\u4ee5\u4e0b\u95dc\u9375\u5b57\u7684\u8cc7\u6599\npattern = &#x5B;'\u9298', '\u50b3', '\u6de1', '\u6c5f', '\u9022', '\u7532', '\u4e2d', '\u539f', '\u6587', '\u5316']\n\ndf = pd.DataFrame(dict)\nprint(len(df))\nprint(df.columns)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"465\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152654-1024x465.jpg\" alt=\"\" class=\"wp-image-532\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152654-1024x465.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152654-300x136.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152654-768x349.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152654.jpg 1067w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nmylist = &#x5B;]\nfor name in df&#x5B;'\u5b78\u751f\u59d3\u540d']:\n    res = &quot;&quot;\n    for s in name:\n        if s in pattern and not s in res:\n            res += s\n    mylist.append(res)\n\ndf&#x5B;'\u95dc\u9375\u5b57'] = mylist\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"363\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152833-1024x363.jpg\" alt=\"\" class=\"wp-image-533\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152833-1024x363.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152833-300x106.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152833-768x272.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-152833.jpg 1121w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u5254\u9664\u300c\u95dc\u9375\u5b57\u300d\u6b04\u4f4d\u70ba\u7a7a\u503c\u8cc7\u6599\ndf&#x5B;~(df&#x5B;'\u95dc\u9375\u5b57']=='')]\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"215\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-153055-1024x215.jpg\" alt=\"\" class=\"wp-image-534\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-153055-1024x215.jpg 1024w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-153055-300x63.jpg 300w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-153055-768x161.jpg 768w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-30-153055.jpg 1072w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":536,"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,205,204,206],"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\/uiftyg8vuck-1-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\">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\">\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>","<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\">\u90e8\u4efd\u5b57\u5143<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">\u6b04\u4f4d<\/span>","<span class=\"advgb-post-tax-term\">\u7be9\u9078<\/span>","<span class=\"advgb-post-tax-term\">\u90e8\u4efd\u5b57\u5143<\/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 30 \u65e5","modified":"Updated on 2022 \u5e74 11 \u6708 30 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 11 \u6708 30 \u65e5 \u4e0b\u5348 4:05","modified":"Updated on 2022 \u5e74 11 \u6708 30 \u65e5 \u4e0b\u5348 4:05"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/531"}],"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=531"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":537,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/531\/revisions\/537"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/536"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}