{"id":597,"date":"2022-12-23T09:46:29","date_gmt":"2022-12-23T01:46:29","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=597"},"modified":"2022-12-23T09:49:05","modified_gmt":"2022-12-23T01:49:05","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e4%ba%ba%e5%93%a1%e4%ba%82%e6%95%b8%e5%88%86%e7%b5%84%e5%8f%8a%e5%bd%99%e6%95%b4%e5%b0%8f%e7%b5%84%e6%88%90%e5%93%a1","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/597\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u4eba\u54e1\u4e82\u6578\u5206\u7d44\u53ca\u5f59\u6574\u5c0f\u7d44\u6210\u54e1"},"content":{"rendered":"\n

\u539f\u59cb\u7684\u554f\u984c\u70ba\u5c07\u5b78\u751f\u4e82\u6578\u5206\u6210A\u3001B\u3001C\u4e09\u7d44\uff1a<\/h3>\n\n\n\n
<\/th>\u59d3\u540d<\/th>\u7d44\u5225<\/th><\/tr><\/thead>
0<\/td>\u9ec3\u6587\u6b23<\/td>B<\/td><\/tr>
1<\/td>\u5f90\u7fe0\u6d0b<\/td>C<\/td><\/tr>
2<\/td>\u6797\u6b23\u8679<\/td>A<\/td><\/tr>
3<\/td>\u5433\u8a9e\u7fa4<\/td>B<\/td><\/tr>
4<\/td>\u8a79\u4fca\u5b8f<\/td>A<\/td><\/tr>
5<\/td>\u6797\u7d20\u5143<\/td>A<\/td><\/tr>
6<\/td>\u6d2a\u5049\u8aa0<\/td>B<\/td><\/tr>
7<\/td>\u9ec3\u7389\u5ef7<\/td>C<\/td><\/tr>
8<\/td>\u9ec3\u74ca\u745e<\/td>C<\/td><\/tr>
9<\/td>\u9673\u5955\u5b63<\/td>B<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u76ee\u6a19\u662f\u5206\u7d44\u5f8c\u7684\u5b78\u751f\uff0c\u65b0\u589e\u4e00\u6b04\u300c\u5c0f\u7d44\u6210\u54e1\u300d\uff1a<\/h3>\n\n\n\n
<\/th>\u59d3\u540d<\/th>\u7d44\u5225<\/th>\u5c0f\u7d44\u6210\u54e1<\/th><\/tr><\/thead>
0<\/td>\u9ec3\u6587\u6b23<\/td>B<\/td>[\u9ec3\u6587\u6b23, \u5433\u8a9e\u7fa4, \u6d2a\u5049\u8aa0, \u9673\u5955\u5b63]<\/td><\/tr>
1<\/td>\u5f90\u7fe0\u6d0b<\/td>C<\/td>[\u5f90\u7fe0\u6d0b, \u9ec3\u7389\u5ef7, \u9ec3\u74ca\u745e]<\/td><\/tr>
2<\/td>\u6797\u6b23\u8679<\/td>A<\/td>[\u6797\u6b23\u8679, \u8a79\u4fca\u5b8f, \u6797\u7d20\u5143]<\/td><\/tr>
3<\/td>\u5433\u8a9e\u7fa4<\/td>B<\/td>[\u9ec3\u6587\u6b23, \u5433\u8a9e\u7fa4, \u6d2a\u5049\u8aa0, \u9673\u5955\u5b63]<\/td><\/tr>
4<\/td>\u8a79\u4fca\u5b8f<\/td>A<\/td>[\u6797\u6b23\u8679, \u8a79\u4fca\u5b8f, \u6797\u7d20\u5143]<\/td><\/tr>
5<\/td>\u6797\u7d20\u5143<\/td>A<\/td>[\u6797\u6b23\u8679, \u8a79\u4fca\u5b8f, \u6797\u7d20\u5143]<\/td><\/tr>
6<\/td>\u6d2a\u5049\u8aa0<\/td>B<\/td>[\u9ec3\u6587\u6b23, \u5433\u8a9e\u7fa4, \u6d2a\u5049\u8aa0, \u9673\u5955\u5b63]<\/td><\/tr>
7<\/td>\u9ec3\u7389\u5ef7<\/td>C<\/td>[\u5f90\u7fe0\u6d0b, \u9ec3\u7389\u5ef7, \u9ec3\u74ca\u745e]<\/td><\/tr>
8<\/td>\u9ec3\u74ca\u745e<\/td>C<\/td>[\u5f90\u7fe0\u6d0b, \u9ec3\u7389\u5ef7, \u9ec3\u74ca\u745e]<\/td><\/tr>
9<\/td>\u9673\u5955\u5b63<\/td>B<\/td>[\u9ec3\u6587\u6b23, \u5433\u8a9e\u7fa4, \u6d2a\u5049\u8aa0, \u9673\u5955\u5b63]<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n
\nimport pandas as pd\nimport numpy as np\n\n# \u5148\u7528\u4e82\u6578\u5ee0\u751f\u7684\u59d3\u540d\u505a\u4e00\u500bDataframe\ndf = pd.DataFrame({'\u59d3\u540d':['\u9ec3\u6587\u6b23', '\u5f90\u7fe0\u6d0b', '\u6797\u6b23\u8679', '\u5433\u8a9e\u7fa4', \n                         '\u8a79\u4fca\u5b8f', '\u6797\u7d20\u5143', '\u6d2a\u5049\u8aa0', '\u9ec3\u7389\u5ef7', '\u9ec3\u74ca\u745e', '\u9673\u5955\u5b63'], \n                   })\n\n# \u6e96\u5099\u5c07\u6240\u6709\u7684\u5b78\u751f\u505aABC\u7684\u5206\u7d44\ngroup = 'ABC'\n\n# df\u65b0\u589e\u4e00\u500b\u300c\u7d44\u5225\u300d\u7684\u6b04\u4f4d\uff0c\u7531ABC\u4e82\u6578\u7522\u751f\uff0c\u9577\u5ea6\u70badf\ndf["\u7d44\u5225"] = np.random.choice(list(group), size=len(df))\ndf\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\n# \u5c07df\u4ee5\u7d44\u5225\u4f86\u5206\u985e\u5f8c\uff0c\u6240\u6709\u7684\u59d3\u540d\u8f49\u6210list\uff0c\u4e26\u628a\u9019\u500b\u5e8f\u5217\u7684\u547d\u540d\u6539\u6210\u300c\u5c0f\u7d44\u6210\u54e1\u300d\ns = df.groupby('\u7d44\u5225').\u59d3\u540d.agg(list).rename('\u5c0f\u7d44\u6210\u54e1')\nprint(type(s))\ns\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n
\n# \u5c07\u539f\u4f86\u7684df\u4e32\u63a5\u4e0a\u9762\u505a\u597d\u7684s\ndf = pd.merge(df, s, on='\u7d44\u5225', how='left')\ndf\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\u7684\u554f\u984c\u70ba\u5c07\u5b78\u751f\u4e82\u6578\u5206\u6210A\u3001B\u3001C\u4e09\u7d44\uff1a \u59d3\u540d \u7d44\u5225 0 \u9ec3\u6587\u6b23 B 1 \u5f90\u7fe0\u6d0b C 2 \u6797\u6b23\u8679 A 3 \u5433 […]<\/p>\n","protected":false},"author":1,"featured_media":601,"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":[222,224,7,8,9,221,219,220],"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\/9nepvsytoaw-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["choice<\/a>","groupby<\/a>","List<\/a>","Pandas<\/a>","Python<\/a>","random<\/a>","string<\/a>","\u4e82\u6578\u5206\u7d44<\/a>"],"unlinked":["choice<\/span>","groupby<\/span>","List<\/span>","Pandas<\/span>","Python<\/span>","random<\/span>","string<\/span>","\u4e82\u6578\u5206\u7d44<\/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 23 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 23 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 23 \u65e5 \u4e0a\u5348 9:46","modified":"Updated on 2022 \u5e74 12 \u6708 23 \u65e5 \u4e0a\u5348 9:49"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/597"}],"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=597"}],"version-history":[{"count":3,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"predecessor-version":[{"id":605,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/597\/revisions\/605"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/601"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}