\nimport pandas as pd\nimport numpy as np\nyear = [108, 109]\nsemester = [1, 2]\nacademic = ['\u535a\u58eb\u73ed', '\u78a9\u58eb\u73ed', '\u5927\u5b78\u90e8']\ngender = ['\u5973', '\u7537']\nindex = pd.MultiIndex.from_product([year, semester, academic, gender],\n names=['\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225'])\ndf = pd.DataFrame(np.random.randint(300,size=(24,1)),index=index,columns=["\u5b78\u751f\u4eba\u6578"])\ndf\n<\/pre><\/div>\n\n\n\u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a<\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-135105.jpg\")
<\/figure>\n\n\n\n\u591a\u63a5\u4e0b\u4f86\u5148\u628a\u591a\u91cd\u7d22\u5f15\u53d6\u6d88\u5f8c\uff0c\u8907\u88fd\u6210dfcopy<\/p>\n\n\n
\ndfcopy = df.reset_index()\ndfcopy\n<\/pre><\/div>\n\n\n \u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a <\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-135353.jpg\")
<\/figure>\n\n\n\npandas\u662f\u6709\u4e00\u500b\u6392\u5e8f\u7684\u51fd\u6578sort_values\uff0c\u4f46\u6392\u5e8f\u7684\u503c\u53ea\u80fd\u9078\u7531\u5c0f\u5230\u5927\uff0c\u6216\u7531\u5927\u5230\u5c0f\u3002
\u5047\u8a2d\u6211\u5011\u5e0c\u671b\u8cc7\u6599\u7684\u6392\u5e8f\u503c\u5982\u4e0b\uff1a
\u5b78\u5e74\uff1a108, 109
\u5b78\u671f\uff1a1, 2
\u5b78\u5236\uff1a”\u5927\u5b78\u90e8”, “\u78a9\u58eb\u73ed”, “\u535a\u58eb\u73ed”
\u6027\u5225\uff1a”\u7537”, “\u5973”<\/p>\n\n\n\n
\u5148\u4f86\u770b\u4e00\u4e0bsort_values\u7684\u6392\u5e8f\u65b9\u5f0f\uff1a<\/p>\n\n\n
\ndfcopy.sort_values(['\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225'], ascending=[True, True, True, False])\n<\/pre><\/div>\n\n\n\u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a<\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-140330.jpg\")
<\/figure>\n\n\n\n\u6392\u5e8f\u7684\u7d50\u679c\uff0c\u5b78\u5e74\u3001\u5b78\u671f\u3001\u6027\u5225\u9019\u4e09\u500b\u6b04\u4f4d\u7684\u503c\u90fd\u525b\u597d\u80fd\u7528\u5167\u5b9a\u7684\u6392\u5e8f\u6392\u597d\u9806\u5e8f\uff0c
\u4f46\u504f\u504f\u5b78\u5236\u7684\u6392\u5e8f\u4e0d\u5982\u9810\u671f\u3002
\u5b78\u5236\u7531\u5c0f\u5230\u5927\u7684\u6392\u5e8f\uff1a”\u535a\u58eb\u73ed”, “\u5927\u5b78\u90e8”, “\u78a9\u58eb\u73ed”
\u5b78\u5236\u7531\u5927\u5230\u5c0f\u7684\u6392\u5e8f\uff1a”\u78a9\u58eb\u73ed”, “\u5927\u5b78\u90e8”, “\u535a\u58eb\u73ed”<\/p>\n\n\n\n
\u4f46\u6211\u5011\u8981\u7684\u6392\u5e8f\u662f\u9019\u6a23\uff1a”\u5927\u5b78\u90e8”, “\u78a9\u58eb\u73ed”, “\u535a\u58eb\u73ed”<\/p>\n\n\n\n
\u4ee5\u6b64\u7bc4\u4f8b\u800c\u8a00\uff0c
\u6211\u5011\u5f88\u78ba\u5b9a\u5b78\u5e74\u3001\u5b78\u671f\u90fd\u662f\u6578\u5b57\uff0c\u53ef\u4ee5\u5f88\u5bb9\u6613\u63a7\u5236\u6392\u5e8f\u3002<\/p>\n\n\n\n
\u5047\u8a2d\u5b78\u5236\u3001\u6027\u5225\u6211\u5011\u8981\u81ea\u8a02\u6392\u5e8f\uff0c
\u6211\u5011\u5c31\u628a\u90192\u500b\u6b04\u4f4d\u5148\u8f49\u6210\u985e\u5225\u5f8c\uff0c\u4f9d\u81ea\u8a02\u9700\u6c42\u6392\u5e8f\uff1a<\/p>\n\n\n
\ndfcopy['\u5b78\u5236'] = pd.Categorical(dfcopy['\u5b78\u5236'], ["\u5927\u5b78\u90e8", "\u78a9\u58eb\u73ed", "\u535a\u58eb\u73ed"])\ndfcopy['\u6027\u5225'] = pd.Categorical(dfcopy['\u6027\u5225'], ["\u7537", "\u5973"])\n\ndfcopy.sort_values(['\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225'])\n<\/pre><\/div>\n\n\n\u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a<\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-142110.jpg\")
<\/figure>\n\n\n\ndfcopy = dfcopy.sort_values(['\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225']).reset_index(drop=True)\ndfcopy\n<\/pre><\/div>\n\n\n\u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a<\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-143150.jpg\")
<\/figure>\n\n\n\n\u6700\u5f8c\u7684\u7d50\u679c\uff0c\u53ef\u4ee5\u518d\u9084\u539f\u6210MultiIndex\u3002<\/p>\n\n\n
\ndfcopy = dfcopy.set_index(['\u5b78\u5e74', '\u5b78\u671f', '\u5b78\u5236', '\u6027\u5225'])\ndfcopy\n<\/pre><\/div>\n\n\n\u8f38\u51fa\u7d50\u679c\u592a\u9577\uff0c\u53ea\u622a\u5716\u4e00\u90e8\u4efd\uff1a<\/p>\n\n\n\n![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/12\/Screenshot-2022-12-16-143350.jpg\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"\u7bc4\u4f8b\u8cc7\u6599\u5982\u4e0b\uff1a \u5b78\u5e74\uff1a108, 109\u5b78\u671f\uff1a1, 2\u5b78\u5236\uff1a”\u535a\u58eb\u73ed”, “ […]<\/p>\n","protected":false},"author":1,"featured_media":581,"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":[215,8,9,205,216],"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\/27lrat-dsz4-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["MultiIndex<\/a>","Pandas<\/a>","Python<\/a>","\u6b04\u4f4d<\/a>","\u81ea\u8a02\u6392\u5e8f<\/a>"],"unlinked":["MultiIndex<\/span>","Pandas<\/span>","Python<\/span>","\u6b04\u4f4d<\/span>","\u81ea\u8a02\u6392\u5e8f<\/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 19 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 19 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 19 \u65e5 \u4e0a\u5348 10:53","modified":"Updated on 2022 \u5e74 12 \u6708 19 \u65e5 \u4e0a\u5348 10:53"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/574"}],"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=574"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/574\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/574\/revisions\/582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/581"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}