
        
        
            
                
                
                    index = [("A", "alice"), ("A", "bob"),
         ("A", "cathy"), ("B", "david"),
         ("B", "eric")]

multi_index = pd.MultiIndex.from_tuples(index)
multi_index
                
            
            MultiIndex([('A', 'alice'),
            ('A',   'bob'),
            ('A', 'cathy'),
            ('B', 'david'),
            ('B',  'eric')])

To create a MultiIndex DataFrame, pass multi_index directly into the DataFrame constructor:


        
        
            
                
                
                    df = pd.DataFrame({"a":[2,3,4,5,6]}, index=multi_index)
df
                
            
                        a
A  alice    2
   bob      3
   cathy    4
B  david    5
   eric     6

Using arrays

To create a Multi-Index from arrays:


        
        
            
                
                
                    numbers = [3,3,4]
letters = ["A","B","C"]
multi_index = pd.MultiIndex.from_arrays([numbers, letters])
multi_index
                
            
            MultiIndex([(3, 'A'),
            (3, 'B'),
            (4, 'C')])

To create a MultiIndex DataFrame, pass multi_index directly into the DataFrame constructor:


        
        
            
                
                
                    df = pd.DataFrame({"a":range(3)}, index=multi_index)
df
                
            
                  a
3  A  0
   B  1
4  C  2

Using Cartesian products

To create a MultiIndex using the Cartesian product of two lists:


        
        
            
                
                
                    numbers = [3,4,5]
letters = ["A","B"]
multi_index = pd.MultiIndex.from_product([numbers, letters])
multi_index
                
            
            MultiIndex([(3, 'A'),
            (3, 'B'),
            (4, 'A'),
            (4, 'B'),
            (5, 'A'),
            (5, 'B')])

To create a MultiIndex DataFrame, pass multi_index directly into the DataFrame constructor:


        
        
            
                
                
                    df = pd.DataFrame({"a":range(6)}, index=multi_index)
df
                
            
                  a
3  A  0
   B  1
4  A  2
   B  3
5  A  4
   B  5

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!