{"id":607,"date":"2022-12-30T10:17:45","date_gmt":"2022-12-30T02:17:45","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=607"},"modified":"2022-12-30T10:17:47","modified_gmt":"2022-12-30T02:17:47","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-pipe-%e5%8f%8a-get_dummies-%e7%af%84%e4%be%8b","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/607\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas pipe \u53ca get_dummies \u7bc4\u4f8b"},"content":{"rendered":"\n

\u539f\u59cb\u8cc7\u6599\uff1a<\/h3>\n\n\n\n
<\/th>\u6b66\u529f\u7c21\u6b77<\/th><\/tr><\/thead>
\u4e00\u71c8\u5927\u5e2b<\/td>\u4e00\u967d\u6307\uff0c\u5148\u5929\u529f\uff0c\u4e5d\u9670\u771f\u7d93<\/td><\/tr>
\u694a\u904e<\/td>\u5168\u771f\u528d\u6cd5\uff0c\u5f48\u6307\u795e\u901a\uff0c\u4e5d\u9670\u771f\u7d93\uff0c\u9eef\u7136\u92b7\u9b42\u638c<\/td><\/tr>
\u738b\u91cd\u967d<\/td>\u5168\u771f\u528d\u6cd5\uff0c\u5148\u5929\u529f\uff0c\u4e00\u967d\u6307<\/td><\/tr>
\u9ec3\u85e5\u5e2b<\/td>\u843d\u82f1\u795e\u528d\u638c\uff0c\u5f48\u6307\u795e\u901a<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u5c07\u6b66\u529f\u7c21\u6b77\u4e2d\u6709\u5b78\u904e\u7684\u6a19\u793a\u70ba\u300c1\u300d\uff0c\u6c92\u5b78\u904e\u7684\u6a19\u793a\u70ba\u300c0\u300d\u3002<\/h3>\n\n\n\n

\u9810\u671f\u7d50\u679c\uff1a<\/h3>\n\n\n\n
<\/th>\u6b66\u529f\u7c21\u6b77<\/th>\u4e00\u967d\u6307<\/th>\u4e5d\u9670\u771f\u7d93<\/th>\u5148\u5929\u529f<\/th>\u5168\u771f\u528d\u6cd5<\/th>\u5f48\u6307\u795e\u901a<\/th>\u843d\u82f1\u795e\u528d\u638c<\/th>\u9eef\u7136\u92b7\u9b42\u638c<\/th><\/tr><\/thead>
\u4e00\u71c8\u5927\u5e2b<\/td>\u4e00\u967d\u6307\uff0c\u5148\u5929\u529f\uff0c\u4e5d\u9670\u771f\u7d93<\/td>1<\/td>1<\/td>1<\/td>0<\/td>0<\/td>0<\/td>0<\/td><\/tr>
\u694a\u904e<\/td>\u5168\u771f\u528d\u6cd5\uff0c\u5f48\u6307\u795e\u901a\uff0c\u4e5d\u9670\u771f\u7d93\uff0c\u9eef\u7136\u92b7\u9b42\u638c<\/td>0<\/td>1<\/td>0<\/td>1<\/td>1<\/td>0<\/td>1<\/td><\/tr>
\u738b\u91cd\u967d<\/td>\u5168\u771f\u528d\u6cd5\uff0c\u5148\u5929\u529f\uff0c\u4e00\u967d\u6307<\/td>1<\/td>0<\/td>1<\/td>1<\/td>0<\/td>0<\/td>0<\/td><\/tr>
\u9ec3\u85e5\u5e2b<\/td>\u843d\u82f1\u795e\u528d\u638c\uff0c\u5f48\u6307\u795e\u901a<\/td>0<\/td>0<\/td>0<\/td>0<\/td>1<\/td>1<\/td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n
\nimport pandas as pd\ndf = pd.DataFrame({'\u6b66\u529f\u7c21\u6b77': {'\u694a\u904e': '\u5168\u771f\u528d\u6cd5\uff0c\u5f48\u6307\u795e\u901a\uff0c\u4e5d\u9670\u771f\u7d93\uff0c\u9eef\u7136\u92b7\u9b42\u638c',\n  '\u9ec3\u85e5\u5e2b': '\u843d\u82f1\u795e\u528d\u638c\uff0c\u5f48\u6307\u795e\u901a',\n  '\u738b\u91cd\u967d': '\u5168\u771f\u528d\u6cd5\uff0c\u5148\u5929\u529f\uff0c\u4e00\u967d\u6307',\n  '\u4e00\u71c8\u5927\u5e2b': '\u4e00\u967d\u6307\uff0c\u5148\u5929\u529f\uff0c\u4e5d\u9670\u771f\u7d93'}}\n  )\n\ndf\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\n# pandas explode \u914d\u5408 pipe \u53ca get_dummies\u5f8c\u7684\u72c0\u6cc1\ndf['\u6b66\u529f\u7c21\u6b77'].str.split('\uff0c').explode().pipe(pd.get_dummies)\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\n# \u6700\u7d42\u7a0b\u5f0f\u4ee5\u4eba\u7269 groupby \u5f8c\uff0c\u5c0d\u6240\u6709\u7684\u6b66\u529f\u505a\u52a0\u7e3d\u5f97\u5230\u7d50\u679c\ndf.join(df['\u6b66\u529f\u7c21\u6b77'].str.split('\uff0c').explode().pipe(pd.get_dummies).groupby(level=0).sum())\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\u9019\u6a23\u5c31\u5b8c\u6210\u6211\u5011\u7684\u76ee\u6a19\u4e86!!<\/p>\n","protected":false},"excerpt":{"rendered":"
\u539f\u59cb\u8cc7\u6599\uff1a \u6b66\u529f\u7c21\u6b77 \u4e00\u71c8\u5927\u5e2b \u4e00\u967d\u6307\uff0c\u5148\u5929\u529f\uff0c\u4e5d\u9670\u771f\u7d93 \u694a\u904e \u5168\u771f\u528d\u6cd5\uff0c\u5f48\u6307\u795e\u901a\uff0c\u4e5d\u9670\u771f\u7d93\uff0c\u9eef\u7136\u92b7\u9b42\u638c \u738b\u91cd […]<\/p>\n","protected":false},"author":1,"featured_media":611,"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":[218,226,224,8,225,9],"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\/pnwf0vjfmro-300x164.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["explode<\/a>","get_dummies<\/a>","groupby<\/a>","Pandas<\/a>","pipe<\/a>","Python<\/a>"],"unlinked":["explode<\/span>","get_dummies<\/span>","groupby<\/span>","Pandas<\/span>","pipe<\/span>","Python<\/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 30 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 30 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 30 \u65e5 \u4e0a\u5348 10:17","modified":"Updated on 2022 \u5e74 12 \u6708 30 \u65e5 \u4e0a\u5348 10:17"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/607"}],"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=607"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":612,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/607\/revisions\/612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/611"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}