{"id":788,"date":"2023-04-25T11:00:03","date_gmt":"2023-04-25T03:00:03","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=788"},"modified":"2023-04-25T11:08:09","modified_gmt":"2023-04-25T03:08:09","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-pivot_table-%e7%af%84%e4%be%8b%e8%aa%aa%e6%98%8e","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/788\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas pivot_table \u7bc4\u4f8b\u8aaa\u660e"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport pandas as pd\nimport numpy as np\n\n# Create multi-index for year, semester, academic, and gender\nyear = &#x5B;109, 110]\nsemester = &#x5B;1, 2]\nacademic = &#x5B;'\u78a9\u58eb\u73ed', '\u5927\u5b78\u90e8']\ngender = &#x5B;'\u7537', '\u5973']\nindex = pd.MultiIndex.from_product(&#x5B;year, semester, academic, gender],\n                           names=&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225'])\n\n# Create DataFrame with random values and multi-index\ndf = pd.DataFrame(np.random.randint(300,size=(len(year)*len(semester)*len(academic)*len(gender)\n                                              ,1)),index=index,columns=&#x5B;&quot;\u5b78\u751f\u4eba\u6578&quot;])\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"266\" height=\"575\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-102943.jpg\" alt=\"\" class=\"wp-image-789\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-102943.jpg 266w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-102943-139x300.jpg 139w\" sizes=\"(max-width: 266px) 100vw, 266px\" \/><\/figure>\n\n\n\n<h3>\u7b2c\u4e00\u500b\u7bc4\u4f8b<\/h3>\n\n\n\n<p>\u5c07\u6027\u5225\u7684\u8b8a\u6578\u5411\u53f3\u5ef6\u5c55\u6210\u70ba\u5bec\u8868\u683c\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf1 = pd.pivot_table(df, values=&#x5B;'\u5b78\u751f\u4eba\u6578'], columns=&#x5B;'\u6027\u5225'], index=&#x5B;'\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236']).reset_index()\ndf1\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"255\" height=\"332\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103131.jpg\" alt=\"\" class=\"wp-image-790\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103131.jpg 255w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103131-230x300.jpg 230w\" sizes=\"(max-width: 255px) 100vw, 255px\" \/><\/figure>\n\n\n\n<p>\u5148\u770b\u4e00\u4e0b\u6b04\u4f4d\u540d\u7a31\u662fMultiIndex\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf1.columns\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"271\" height=\"127\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103337.jpg\" alt=\"\" class=\"wp-image-791\"\/><\/figure>\n\n\n\n<p>\u5c07MultiIndex\u6b04\u540d\u7d50\u5408\u6210\u5b57\u4e32\u5f8c\u505a\u70ba\u65b0\u6b04\u540d<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf1.columns = &#x5B;''.join(tup) for tup in df1.columns]\ndf1\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"332\" height=\"286\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103627.jpg\" alt=\"\" class=\"wp-image-792\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103627.jpg 332w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103627-300x258.jpg 300w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/figure>\n\n\n\n<h3>\u7b2c\u4e8c\u500b\u7bc4\u4f8b<\/h3>\n\n\n\n<p>\u5c07\u5b78\u5236\u3001\u6027\u5225\u7684\u8b8a\u6578\u5411\u53f3\u5ef6\u5c55\u6210\u70ba\u5bec\u8868\u683c\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf2 = pd.pivot_table(df, values=&#x5B;'\u5b78\u751f\u4eba\u6578'], columns=&#x5B; '\u5b78\u5236', '\u6027\u5225'], index=&#x5B;'\u5b78\u5e74', '\u5b78\u671f']).reset_index()\ndf2\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"276\" height=\"236\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-103912.jpg\" alt=\"\" class=\"wp-image-793\"\/><\/figure>\n\n\n\n<p>\u5148\u770b\u4e00\u4e0b\u6b04\u4f4d\u540d\u7a31\u662f\u4e09\u5c64\u7684MultiIndex\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf2.columns\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"338\" height=\"153\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104048.jpg\" alt=\"\" class=\"wp-image-794\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104048.jpg 338w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104048-300x136.jpg 300w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/figure>\n\n\n\n<p>\u4e00\u6a23\u5c07MultiIndex\u6b04\u540d\u7d50\u5408\u6210\u5b57\u4e32\u5f8c\u505a\u70ba\u65b0\u6b04\u540d<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf2.columns = &#x5B;''.join(tup) for tup in df2.columns]\ndf2\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"595\" height=\"167\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104324.jpg\" alt=\"\" class=\"wp-image-795\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104324.jpg 595w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/Screenshot-2023-04-25-104324-300x84.jpg 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u7b2c\u4e00\u500b\u7bc4\u4f8b \u5c07\u6027\u5225\u7684\u8b8a\u6578\u5411\u53f3\u5ef6\u5c55\u6210\u70ba\u5bec\u8868\u683c\uff1a \u5148\u770b\u4e00\u4e0b\u6b04\u4f4d\u540d\u7a31\u662fMultiIndex\uff1a \u5c07MultiIndex [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":797,"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":"default","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":"default","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,397,9,398],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/04\/caspar-camille-rubin-0qvBNep1Y04-unsplash-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\">pivot_table<\/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\">\u5bec\u8868\u683c<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">pivot_table<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">\u5bec\u8868\u683c<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2023 \u5e74 4 \u6708 25 \u65e5","modified":"Updated on 2023 \u5e74 4 \u6708 25 \u65e5"},"absolute_dates_time":{"created":"Posted on 2023 \u5e74 4 \u6708 25 \u65e5 \u4e0a\u5348 11:00","modified":"Updated on 2023 \u5e74 4 \u6708 25 \u65e5 \u4e0a\u5348 11:08"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/788"}],"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=788"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/788\/revisions"}],"predecessor-version":[{"id":796,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/788\/revisions\/796"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/797"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}