{"id":583,"date":"2022-12-20T09:18:06","date_gmt":"2022-12-20T01:18:06","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=583"},"modified":"2022-12-20T09:18:07","modified_gmt":"2022-12-20T01:18:07","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e5%88%86%e7%b5%84%e8%a8%88%e7%ae%97%e6%ac%84%e4%bd%8d%e8%b3%87%e6%96%99","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/583\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u5206\u7d44\u8a08\u7b97\u6b04\u4f4d\u8cc7\u6599"},"content":{"rendered":"\n<h3>\u672c\u6587\u4f86\u81ea\u65bcithelp\u7684\u767c\u554f\uff1a<br><a rel=\"noreferrer noopener\" href=\"https:\/\/ithelp.ithome.com.tw\/questions\/10206115#_=_\" target=\"_blank\"><\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/ithelp.ithome.com.tw\/questions\/10206115#_=_\" target=\"_blank\">https:\/\/ithelp.ithome.com.tw\/questions\/10206115#_=_<\/a><\/h3>\n\n\n\n<p>\u4e00\u5e74\u591a\u4ee5\u524d\u81ea\u5df1\u4e5f\u8a66\u8457\u5beb\u4e86\u4e8c\u7a2e\u8ff4\u5708\u65b9\u5f0f\u7684\u89e3\u7b54\uff0c\u6700\u8fd1\u53c8\u518d\u60f3\u8d77\u9019\u500b\u89e3\u7b54\u3002<br>\u4e4b\u524d\u7684\u8ff4\u5708\u7a0b\u5f0f\uff0c\u8acb\u76f4\u63a5\u53c3\u8003\u4ee5\u4e0a\u7684\u9023\u7d50\uff0c\u672c\u6587\u4e0d\u518d\u91cd\u8907\u3002<\/p>\n\n\n\n<p>\u9019\u6b21\u8a66\u8457\u4e0d\u7528\u8ff4\u5708\u7684\u65b9\u5f0f\u518d\u5beb\u4e00\u6b21\u89e3\u7b54\u3002<\/p>\n\n\n\n<p>\u539f\u59cb\u8cc7\u6599\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><\/th><th>GROUP<\/th><th>GOAT<\/th><th>TYPE<\/th><th>TIME<\/th><\/tr><\/thead><tbody><tr><td>0<\/td><td>R<\/td><td>15\/10<\/td><td>A\/B<\/td><td>2<\/td><\/tr><tr><td>1<\/td><td>W<\/td><td>10\/7\/11<\/td><td>A\/B\/B<\/td><td>3<\/td><\/tr><tr><td>2<\/td><td>W<\/td><td>9<\/td><td>A<\/td><td>2<\/td><\/tr><tr><td>3<\/td><td>R<\/td><td>12<\/td><td>B<\/td><td>2<\/td><\/tr><tr><td>4<\/td><td>R<\/td><td>8\/13<\/td><td>B\/A<\/td><td>3<\/td><\/tr><tr><td>5<\/td><td>W<\/td><td>10<\/td><td>B<\/td><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u8a08\u7b97\u689d\u4ef6\u5982\u4e0b\uff1a<\/p>\n\n\n\n<ul><li>(GROUP = &#8216;R&#8217;) &amp; (GROUP = &#8216;A&#8217;)\uff0cRESULT = GOAT * TIME * 0.3<\/li><li>(GROUP = &#8216;R&#8217;) &amp; (GROUP = &#8216;B&#8217;)\uff0cRESULT = GOAT * TIME * 0.5<\/li><li>(GROUP = &#8216;W&#8217;) &amp; (GROUP = &#8216;A&#8217;)\uff0cRESULT = GOAT * TIME * 0.4<\/li><li>(GROUP = &#8216;W&#8217;) &amp; (GROUP = &#8216;B&#8217;)\uff0cRESULT = GOAT * TIME * 0.3<\/li><\/ul>\n\n\n\n<p>\u9810\u671f\u6700\u5f8c\u7d50\u679c\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><\/th><th>GROUP<\/th><th>GOAT<\/th><th>TYPE<\/th><th>TIME<\/th><th>RESULT<\/th><\/tr><\/thead><tbody><tr><td>0<\/td><td>R<\/td><td>15\/10<\/td><td>A\/B<\/td><td>2<\/td><td>9.0\/10.0<\/td><\/tr><tr><td>1<\/td><td>W<\/td><td>10\/7\/11<\/td><td>A\/B\/B<\/td><td>3<\/td><td>12.0\/6.3\/9.9<\/td><\/tr><tr><td>2<\/td><td>W<\/td><td>9<\/td><td>A<\/td><td>2<\/td><td>7.2<\/td><\/tr><tr><td>3<\/td><td>R<\/td><td>12<\/td><td>B<\/td><td>2<\/td><td>12.0<\/td><\/tr><tr><td>4<\/td><td>R<\/td><td>8\/13<\/td><td>B\/A<\/td><td>3<\/td><td>12.0\/11.7<\/td><\/tr><tr><td>5<\/td><td>W<\/td><td>10<\/td><td>B<\/td><td>2<\/td><td>6.0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u9019\u6b21\u6539\u5beb\u7684\u7a0b\u5f0f\u5982\u4e0b\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport pandas as pd\nimport numpy as np\n\ndf = pd.DataFrame(\n    {\n      'GROUP':   &#x5B;'R','W','W','R','R','W'],\n      'GOAT':    &#x5B;'15\/10','10\/7\/11','9','12','8\/13','10'],\n      'TYPE':    &#x5B;'A\/B','A\/B\/B','A','B','B\/A','B'],\n      'TIME': &#x5B;2,3,2,2,3,2]\n    }\n)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"280\" height=\"253\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163024.jpg\" alt=\"\" class=\"wp-image-585\"\/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u5148\u8907\u88fd\u4e00\u500bdfcopy\u4f86\u505a\u904b\u7b97\ndfcopy = df.copy()\ndfcopy&#x5B;'GOAT'] = dfcopy&#x5B;'GOAT'].str.split('\/')\ndfcopy&#x5B;'TYPE'] = dfcopy&#x5B;'TYPE'].str.split('\/')\ndfcopy\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"300\" height=\"253\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163201.jpg\" alt=\"\" class=\"wp-image-586\"\/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u78ba\u8a8d\u4e00\u4e0b\u6b04\u4f4d\u503c\u7684\u985e\u578b\ndfcopy.info()\n<\/pre><\/div>\n\n\n<p>&lt;class &#8216;pandas.core.frame.DataFrame&#8217;&gt;<br>RangeIndex: 10 entries, 0 to 9<br>Data columns (total 5 columns):<br>Column Non-Null Count Dtype<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>0 index 10 non-null int64<br>1 GROUP 10 non-null object<br>2 GOAT 10 non-null object<br>3 TYPE 10 non-null object<br>4 TIME 10 non-null int64<br>dtypes: int64(2), object(3)<br>memory usage: 528.0+ bytes<\/p>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u958b\u59cb\u6545\u904b\u7b97\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndfcopy.loc&#x5B;(dfcopy&#x5B;'GROUP'] == 'R') &amp; (dfcopy&#x5B;'TYPE'] == 'A'), 'RESULT'] = dfcopy&#x5B;'GOAT'].astype(int) * dfcopy&#x5B;'TIME'] * 0.3\ndfcopy.loc&#x5B;(dfcopy&#x5B;'GROUP'] == 'R') &amp; (dfcopy&#x5B;'TYPE'] == 'B'), 'RESULT'] = dfcopy&#x5B;'GOAT'].astype(int) * dfcopy&#x5B;'TIME'] * 0.5\ndfcopy.loc&#x5B;(dfcopy&#x5B;'GROUP'] == 'W') &amp; (dfcopy&#x5B;'TYPE'] == 'A'), 'RESULT'] = dfcopy&#x5B;'GOAT'].astype(int) * dfcopy&#x5B;'TIME'] * 0.4\ndfcopy.loc&#x5B;(dfcopy&#x5B;'GROUP'] == 'W') &amp; (dfcopy&#x5B;'TYPE'] == 'B'), 'RESULT'] = dfcopy&#x5B;'GOAT'].astype(int) * dfcopy&#x5B;'TIME'] * 0.3\ndfcopy\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"382\" height=\"390\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163657.jpg\" alt=\"\" class=\"wp-image-589\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163657.jpg 382w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163657-294x300.jpg 294w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndfcopy&#x5B;'RESULT'] = dfcopy&#x5B;'RESULT'].replace('', np.nan)\n\n# \u5c07explode\u5f8c\u7684\u8cc7\u6599\u9084\u539f\u6210\u540c\u4e00\u500bindex\ndf&#x5B;'RESULT'] = (dfcopy.groupby('index', as_index=True)\n                  .agg({'RESULT': lambda x: x.dropna().tolist()})\n)\ndf&#x5B;'RESULT']\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"267\" height=\"162\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163811.jpg\" alt=\"\" class=\"wp-image-590\"\/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u5c07list\u8f49\u63db\u6210string\ndf&#x5B;'RESULT'] = &#x5B;'\/'.join(map(str, l)) for l in df&#x5B;'RESULT']]\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"382\" height=\"256\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163909.jpg\" alt=\"\" class=\"wp-image-591\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163909.jpg 382w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-19-163909-300x201.jpg 300w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4f86\u81ea\u65bcithelp\u7684\u767c\u554f\uff1ahttps:\/\/ithelp.ithome.com.tw\/questions\/1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":595,"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,7,8,9,219,217],"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\/exskjmg-_vi-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\">explode<\/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\">List<\/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\">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\">string<\/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\u7d44\u8a08\u7b97<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">explode<\/span>","<span class=\"advgb-post-tax-term\">List<\/span>","<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">string<\/span>","<span class=\"advgb-post-tax-term\">\u5206\u7d44\u8a08\u7b97<\/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 20 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 20 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 20 \u65e5 \u4e0a\u5348 9:18","modified":"Updated on 2022 \u5e74 12 \u6708 20 \u65e5 \u4e0a\u5348 9:18"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/583"}],"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=583"}],"version-history":[{"count":5,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/583\/revisions"}],"predecessor-version":[{"id":594,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/583\/revisions\/594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/595"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}