{"id":561,"date":"2022-12-14T23:11:53","date_gmt":"2022-12-14T15:11:53","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=561"},"modified":"2022-12-14T23:13:50","modified_gmt":"2022-12-14T15:13:50","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-multiindex-%e5%a4%9a%e9%87%8d%e7%b4%a2%e5%bc%95%e7%b0%a1%e8%a6%81%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\/561\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas MultiIndex (\u591a\u91cd\u7d22\u5f15)\u7c21\u8981\u8aaa\u660e"},"content":{"rendered":"\n

\u8cc7\u6599\u7bc4\u4f8b\u662f\u7d22\u5f15\u5171\u6709\u56db\u5c64\uff080-3\u5c64)\uff0c\u5206\u5225\u70ba[‘\u5b78\u5e74’, ‘\u5b78\u671f’, ‘\u5b78\u5236’, ‘\u6027\u5225’]
\u5b78\u5e74\uff1a108, 109
\u5b78\u671f\uff1a1, 2
\u5b78\u5236\uff1a”\u535a\u58eb\u73ed”, “\u78a9\u58eb\u73ed”, “\u5927\u5b78\u90e8”
\u6027\u5225\uff1a”\u5973”, “\u7537”
\u5148\u770b\u4e00\u4e0b\u8cc7\u6599\u5728Excel\u4e2d\u7684\u986f\u793a\uff1a<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n
\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
\"\"<\/figure>\n\n\n\n
\u591a\u91cd\u7d22\u5f15\u7684\u6a23\u5b50\uff1a<\/p>\n\n\n
\ndf.index\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\u591a\u91cd\u7d22\u5f15\u7684\u540d\u5b57\u662fFrozenList<\/p>\n\n\n
\ndf.index.names\n<\/pre><\/div>\n\n\n
FrozenList([‘\u5b78\u5e74’, ‘\u5b78\u671f’, ‘\u5b78\u5236’, ‘\u6027\u5225’])<\/p>\n\n\n
\n# \u591a\u91cd\u7d22\u5f15\u7b2c0\u5c64\uff0c\u4e5f\u5c31\u662f"\u5b78\u5e74"\ndf.index.get_level_values(0)\n<\/pre><\/div>\n\n\n
Int64Index([108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 109,
109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109],
dtype=’int64′, name=’\u5b78\u5e74’)<\/p>\n\n\n
\n# \u591a\u91cd\u7d22\u5f15\u76f4\u63a5\u5e36\u5165"\u5b78\u5e74"\uff0c\u5f97\u5230\u7b2c0\u5c64\u7684\u7d22\u5f15\ndf.index.get_level_values('\u5b78\u5e74')\n<\/pre><\/div>\n\n\n
Int64Index([108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 109,
109, 109, 109, 109, 109, 109, 109, 109, 109, 109, 109],
dtype=’int64′, name=’\u5b78\u5e74’)<\/p>\n\n\n
\n# \u591a\u91cd\u7d22\u5f15\u7b2c1\u5c64\uff0c\u4e5f\u5c31\u662f"\u5b78\u671f"\ndf.index.get_level_values(1)\n<\/pre><\/div>\n\n\n
Int64Index([1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2,
2, 2],
dtype=’int64′, name=’\u5b78\u671f’)<\/p>\n\n\n
\n# \u591a\u91cd\u7d22\u5f15\u76f4\u63a5\u5e36\u5165"\u5b78\u671f"\uff0c\u5f97\u5230\u7b2c1\u5c64\u7684\u7d22\u5f15\ndf.index.get_level_values('\u5b78\u671f')\n<\/pre><\/div>\n\n\n
Int64Index([1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2,
2, 2],
dtype=’int64′, name=’\u5b78\u671f’)<\/p>\n\n\n\n
\u4ee5\u4e0b\u985e\u63a8\u7b2c2\u5c64\u662f”\u5b78\u5236”\uff0c\u7b2c3\u5c64\u662f”\u6027\u5225”<\/p>\n\n\n\n
\u591a\u91cd\u7d22\u5f15\u7be9\u9078\u8cc7\u6599<\/h2>\n\n\n\n
\u7b2c0\u5c64\u8cc7\u6599\uff0c\u4f8b\u5982108\u5b78\u5e74\u8cc7\u6599<\/h3>\n\n\n
\ndf.loc[(108)]\n#df.loc[108] #\u4e2d\u62ec\u865f\u88cf\u9762\u6c92\u6709\u5c0f\u62ec\u865f\u4e5f\u53ef\u4ee5\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\u7b2c1\u5c64\u8cc7\u6599\uff0c\u4f8b\u5982109\u5b78\u5e74\u7b2c2\u5b78\u671f\u8cc7\u6599<\/h3>\n\n\n
\ndf.loc[(109, 2)]\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\u7b2c2\u30013\u5c64\u8cc7\u6599\uff0c\u5c31\u4ee5\u4e0a\u5c0f\u62ec\u865f\u88cf\u9762\u518d\u628a”\u5b78\u5236”\u548c”\u6027\u5225”\u7684\u503c\u5e36\u9032\u53bb\u5c31\u53ef\u4ee5\u5f97\u5230\u3002<\/p>\n\n\n\n
\u591a\u91cd\u7d22\u5f15\u66f4\u6539\u4e0d\u540c\u7d22\u5f15\u5c64\u7684\u503c<\/h2>\n\n\n\n
\u5c07\u7b2c0\u5c64\u7d22\u5f15[108, 109]\u66f4\u6539\u70ba[2019, 2020]<\/h3>\n\n\n
\ndfcopy = df.copy()\ndfcopy.index = dfcopy.index.set_levels([2019, 2020] , level=0)\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
\"\"<\/figure>\n\n\n\n
\u5c07\u7b2c0\u5c64\u7d22\u5f15[108, 109]\u53ca\u7b2c1\u5c64\u7d22\u5f15[1, 2]\u5206\u5225\u66f4\u6539\u70ba[2019, 2020]\u8207[‘one’, ‘two’]<\/h3>\n\n\n
\ndfcopy = df.copy()\ndfcopy.index = dfcopy.index.set_levels([[2019, 2020], ['one', 'two']] , level=[0,1])\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
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
\u8cc7\u6599\u7bc4\u4f8b\u662f\u7d22\u5f15\u5171\u6709\u56db\u5c64\uff080-3\u5c64)\uff0c\u5206\u5225\u70ba[‘\u5b78\u5e74’, ‘\u5b78\u671f&#8217 […]<\/p>\n","protected":false},"author":1,"featured_media":570,"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,204],"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\/dkb6ejfluaa-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>","\u7be9\u9078<\/a>"],"unlinked":["MultiIndex<\/span>","Pandas<\/span>","Python<\/span>","\u7be9\u9078<\/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 14 \u65e5","modified":"Updated on 2022 \u5e74 12 \u6708 14 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 12 \u6708 14 \u65e5 \u4e0b\u5348 11:11","modified":"Updated on 2022 \u5e74 12 \u6708 14 \u65e5 \u4e0b\u5348 11:13"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/561"}],"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=561"}],"version-history":[{"count":3,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/561\/revisions"}],"predecessor-version":[{"id":572,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/561\/revisions\/572"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/570"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}