层次化索引
- 在一个轴上拥有两个或者两个以上的索引
- 使用loc语句进行访问
- loc里面接受tuple,如loc[(a,b),:]
auction_id | cat_id | property | buy_mount | day | ||
cat1 | user_id | |||||
50022520 | 786295544 | 41098319944 | 50014866 | 21458:86755362;13023209:3593274;10984217:21985... | 2 | 20140919 |
28 | 532110457 | 17916191097 | 50011993 | 21458:11399317;1628862:3251296;21475:137325;16... | 1 | 20131011 |
50014815 | 249013725 | 21896936223 | 50012461 | 21458:30992;1628665:92012;1628665:3233938;1628... | 1 | 20131011 |
917056007 | 12515996043 | 50018831 | 21458:15841995;21956:3494076;27000458:59723383... | 2 | 20141023 | |
50008168 | 444069173 | 20487688075 | 50013636 | 21458:30992;13658074:3323064;1628665:3233941;1... | 1 | 20141103 |
auction_id | cat_id | property | buy_mount | day | |
user_id | |||||
475046636 | 10368360710 | 203527 | 22724:40168;22729:40278;21458:21817;2770200:24... | 1 | 20121101 |
532110457 | 17916191097 | 50011993 | 21458:11399317;1628862:3251296;21475:137325;16... | 1 | 20131011 |
auction_id | cat_id | ||
cat1 | user_id | ||
28 | 532110457 | 17916191097 | 50011993 |
475046636 | 10368360710 | 203527 |
auction_id | cat_id | property | buy_mount | day | ||
cat1 | user_id | |||||
28 | 532110457 | 17916191097 | 50011993 | 21458:11399317;1628862:3251296;21475:137325;16... | 1 | 20131011 |
82830661 | 19948600790 | 50013874 | 21458:11580;21475:137325 | 1 | 20121101 | |
475046636 | 10368360710 | 203527 | 22724:40168;22729:40278;21458:21817;2770200:24... | 1 | 20121101 | |
38 | 734147966 | 15307958346 | 50018202 | 21458:3270827;7361532:28710594;7397093:7536994... | 2 | 20121101 |
28 | 377550424 | 15771663914 | 50015841 | 1628665:3233941;1628665:3233942;3914866:11580;... | 1 | 20121123 |
530850018 | 22058239899 | 50024147 | 21458:205007542;43307470:5543413;2339128:62147... | 1 | 20140210 | |
749507708 | 19171641742 | 50018860 | 21458:3602856;1628665:3233941;1628665:3233942;... | 1 | 20140210 | |
38 | 469517728 | 8232924597 | 211122 | 21458:21782;36786:42781029;13023102:6999219;22... | 6 | 20140502 |
28 | 938309370 | 14149079479 | 50023669 | 21458:4204704;11820090:105550653;11644036:2861... | 1 | 20120819 |
14466144 | 17610665576 | 50011993 | 21458:104000;21475:137325 | 1 | 20130327 | |
38 | 177724549 | 14228645401 | 50018824 | 21475:108284;6933666:96059;33595:16453265;2145... | 1 | 20130327 |
28 | 659020106 | 40484992676 | 50011993 | 21458:16162126;13023209:10551667;122218042:605... | 1 | 20140813 |
18100946 | 38451267766 | 121540027 | 21458:215485914;125501489:19689726;11945782:78... | 1 | 20140911 | |
262519726 | 19051046285 | 121398041 | 11666049:40203;21458:3961150;17472269:13302841... | 1 | 20140703 | |
115566151 | 14778919435 | 50013187 | 1628665:3233938;1628665:29796;1628665:133527;1... | 1 | 20140113 | |
1714403831 | 22443564698 | 50014129 | 21458:57737100;12102318:7282254;11945782:78135... | 1 | 20131106 | |
38 | 1970876909 | 20197969079 | 211122 | 6940834:29865;21458:3270820;1629375:3253542;32... | 1 | 20141017 |
28 | 113473924 | 15486726090 | 50014250 | 21458:30015090;1633959:43047819;1627584:28619;... | 1 | 20120905 |
348660284 | 10896577394 | 50014250 | 1628665:29796;1628665:108579;1627584:11580;116... | 1 | 20130525 | |
38 | 151915451 | 17305821144 | 211122 | 21458:21782;36786:42781029;6933553:3313169;130... | 2 | 20140104 |
28 | 745002413 | 36815797313 | 50023645 | 1628665:82340;21475:11488282;21458:56610575;49... | 1 | 20140104 |
654037597 | 13775864723 | 50011993 | 21458:116116655;1633959:3276615;1628862:50276;... | 1 | 20130513 | |
38 | 277279277 | 18024521052 | 211122 | 21458:33516;33480:3238774;2653417:7353464;3359... | 12 | 20130513 |
28 | 1721792494 | 36154660054 | 50008845 | 21458:3400531;5653832:7049425;13023209:7049425... | 1 | 20140312 |
56549058 | 26930668292 | 50003700 | 21458:3351431;123273479:31526;1628665:3233941;... | 1 | 20140312 | |
696527486 | 37269469522 | 50011993 | 21458:118564374;13023209:547499553;122218042:3... | 1 | 20140718 | |
643153890 | 17954181229 | 50003700 | 123273479:41376163;21475:135183931;1628665:323... | 1 | 20140718 | |
1097191176 | 39095838474 | 50015841 | 1628665:3233941;1628665:3233942;1628665:323393... | 1 | 20150203 | |
669370290 | 40584762520 | 121540027 | 21458:215485914;125501489:598926205;11945782:7... | 1 | 20141026 | |
371153601 | 19893996909 | 251725 | 26318:52993;1627584:30689;11684888:104528258;2... | 1 | 20121013 | |
... | ... | ... | ... | ... | ... | |
173729389 | 13926583575 | 50012474 | 21458:123482676;13023209:598168191;15673795:59... | 1 | 20140501 | |
129479111 | 39677605554 | 50013187 | 1628665:3233938;1628665:82340;1628665:29793;21... | 2 | 20141229 | |
788572516 | 18991044719 | 121466040 | 1628665:29784;1628665:29793;6907553:40595450;1... | 2 | 20141129 | |
1031198213 | 22309900818 | 50011993 | 21458:113001124;13023209:52138064;29183816:568... | 1 | 20141129 | |
860528533 | 14620263044 | 50011993 | 21458:115601688;1633959:138499706;1628862:3241... | 1 | 20130925 | |
1614610402 | 17337612618 | 50016010 | 21458:30992;3989588:31285;3998392:40870415;399... | 1 | 20131223 | |
696020002 | 23953356568 | 50011993 | 21458:34865735;1633959:3334315;1628862:33255;3... | 1 | 20130523 | |
626575260 | 38862644631 | 50011993 | 122218042:21671;21475:135183931;1628861:21671;... | 2 | 20140625 | |
2139869403 | 40339820434 | 50011993 | 122218042:117201278;21475:135183931;1628861:21... | 1 | 20141210 | |
49369084 | 37942071105 | 50013190 | 21458:211472372;44818245:223495732;1628665:323... | 1 | 20140615 | |
128447452 | 37728960808 | 50023670 | 21458:3482061;29121644:299472011;1628665:32339... | 1 | 20140615 | |
1768157748 | 24644048682 | 50024150 | 21458:8244918;122277639:14934675;11688815:2167... | 2 | 20141115 | |
45914430 | 16066366006 | 50014129 | NaN | 1 | 20130331 | |
1372572 | 16915013171 | 50008845 | 21458:30992;1628665:3233941;1628665:3233942;16... | 1 | 20130327 | |
167288532 | 18836766607 | 50012788 | 2112993:29274;122277833:104377;1628665:3233941... | 1 | 20140913 | |
2183330808 | 19704833222 | 50011993 | 21458:119679150;13023209:4067094;122218042:216... | 1 | 20140913 | |
113446171 | 37455013590 | 50023663 | 11760865:6120557;21458:3314841;122277597:2054;... | 1 | 20140831 | |
522850986 | 18220260582 | 122678023 | 21458:91312408;138253785:653822445;135925585:1... | 1 | 20140831 | |
2212582093 | 16684531006 | 50006095 | 21458:3532516;8088680:4482698;1628665:3233941;... | 1 | 20150205 | |
326432534 | 40599422228 | 50012428 | 1628665:3233941;1628665:29790;1628665:3233936;... | 1 | 20150110 | |
2074613684 | 40798454555 | 203319 | 122217795:29277;134943792:29774;134943792:2977... | 1 | 20141108 | |
797710454 | 18176728510 | 50013177 | 1628665:3233941;1628665:3233942;1628665:323393... | 1 | 20130107 | |
68515755 | 13953276547 | 50012788 | 21458:12376977;2112993:32075;1628665:92012;162... | 1 | 20130729 | |
801784345 | 17629938386 | 50023670 | 21458:3550980;29154281:231350353;11684888:1045... | 1 | 20130729 | |
38 | 1957645413 | 36768778465 | 121448033 | 6940834:29865;1628149:137593;21475:114226;2275... | 1 | 20140815 |
28 | 816394377 | 19835118833 | 50003700 | 24448:73774385;6725953:48332;22044:30715;80047... | 1 | 20130912 |
164859586 | 15842319049 | 50012479 | NaN | 1 | 20130912 | |
119149466 | 26396292642 | 50008875 | 21458:30992;11684888:104528258;21475:11488282;... | 1 | 20130912 | |
82915321 | 12766532512 | 50011993 | 21475:137325;1628665:3233937;1628665:29798;162... | 1 | 20131008 | |
758305789 | 20177445814 | 50018860 | 21458:3602856;1628665:29784;1628665:3233941;73... | 1 | 20131008 |
8166 rows × 5 columns