Pandas: Drop a level from a multi-level column index

Let us understand with the help of an example:

Here, we are creating column wise multilevel index one below another, for this purpose, we have MultiIndex.from_tuples() method.

# Importing pandas package
import pandas as pd

# Creating multilevel index
index = pd.MultiIndex.from_tuples([('Vitamin A','Sources'),
                                   ('Vitamin C', 'Sources'),
                                   ('Vitamin D','Sources')])

# Creating a multilevel index DataFrame 
# with columns = multilevel indexes
df = pd.DataFrame([['Papaya','Orange','Oily Fish'],
                  ['Watermelon','Blackcurrent','Red meat'],
                   ['Mango','Kale','egg yolks']], columns=index)

# Display multilevel DataFrame
print("Multilevel DataFrame:\n",df)

Output:

Now we will drop a level of columns from this Multiindex DataFrame.

# Dropping a level of column where column 
# is sources i.e., level=1
df.columns = df.columns.droplevel(1)

# Display modified DataFrame
print("Modified DataFrame:\n",df)

Output: