Python | Pandas MultiIndex.to_frame()

Last Updated : 24 Dec, 2018

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas MultiIndex.to_frame() function create a DataFrame with the levels of the MultiIndex as columns.

Syntax: MultiIndex.to_frame(index=True)

Parameters :
index : Set the index of the returned DataFrame as the original MultiIndex.

Returns : DataFrame : a DataFrame containing the original MultiIndex data.

Example #1: Use MultiIndex.to_frame() function to construct a dataframe using the MultiIndex levels as the column and index.

   # importing pandas as pd 
import pandas as pd 
  
# Create the MultiIndex 
midx = pd.MultiIndex.from_tuples([(10, 'Ten'), (10, 'Twenty'),  
                                  (20, 'Ten'), (20, 'Twenty')],  
                                        names =['Num', 'Char']) 
  
# Print the MultiIndex 
print(midx) 
 
  

Output :

Now let’s construct the dataframe from the MultiIndex.

   # Construct the DataFrame 
midx.to_frame(index = True)

Output :

As we can see in the output, the function has constructed the Dataframe using the MultiIndex. Notice the index of the dataframe is constructed using the levels of the MultiIndex.

Example #2: Use MultiIndex.to_frame() function to construct a DataFrame using the MultiIndex. Do not use the MultiIndex levels to construct the index of the Dataframe.

   # importing pandas as pd 
import pandas as pd 
  
# Create the MultiIndex 
midx = pd.MultiIndex.from_tuples([(10, 'Ten'), (10, 'Twenty'),   
                                  (20, 'Ten'), (20, 'Twenty')],  
                                        names =['Num', 'Char']) 
  
# Print the MultiIndex 
print(midx) 
 
  

Output :

Now let’s create a dataframe using the midx MultiIndex.

   # Create Dataframe with new index values. 
midx.to_frame(index = False)

Output :

As we can see in the output, the function has returned a DataFrame having different index value.

Python | Pandas DataFrame.set_index()

Shubham__Ranjan

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Python | Pandas Index.to_frame()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas Index.to_frame() function create a dataFrame from the given index with a column

2 min read

Python | Pandas MultiIndex.from_tuples()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.from_tuples() function is used to convert list of tuples to MultiInd

2 min read

Python | Pandas MultiIndex.set_labels()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.Pandas MultiIndex.set_labels() function set new labels on MultiIndex. Defaults to retur

2 min read

Python | Pandas MultiIndex.levshape

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.levshape attribute outputs a tuple containing the length of each lev

2 min read

Python | Pandas DataFrame.set_index()

Pandas DataFrame.set_index() method sets one or more columns as the index of a DataFrame. It can accept single or multiple column names and is useful for modifying or adding new indices to your DataFrame. By doing so, you can enhance data retrieval, indexing, and merging tasks. Syntax: DataFrame.set

3 min read

Python | Pandas MultiIndex.to_hierarchical()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.to_hierarchical() function return a MultiIndex reshaped to conform t

2 min read

Python | Pandas MultiIndex.from_arrays()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.from_arrays() function is used to convert arrays into MultiIndex. It

2 min read

Python | Pandas MultiIndex.droplevel()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.droplevel() function return Index with requested level removed. If M

2 min read

Python | Pandas MultiIndex.from_product()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.from_product() function make a MultiIndex from the cartesian product

2 min read

Python | Pandas MultiIndex.reorder_levels()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas MultiIndex.reorder_levels() function is used to rearrange levels using input or

2 min read