Sorting MultiIndex in Pandas - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the MultiIndex DataFrame by its index.

Pandas

sorted_df = df.[1]()

Drag options to blanks, or click blank then click option'

Asort_values

Bsort_index

Corder_by

Darrange

Attempts:

3 left

💡 Hint

Common Mistakes

Using sort_values() instead of sort_index()

Trying to use order_by() which is not a pandas method

The sort_index() method sorts a DataFrame by its index, which is needed for MultiIndex sorting.

2fill in blank

medium

Complete the code to sort the MultiIndex DataFrame by the second level of the index.

Pandas

sorted_df = df.sort_index(level=[1])

Drag options to blanks, or click blank then click option'

A1

B0

C2

D'first'

Attempts:

3 left

💡 Hint

Common Mistakes

Using level=0 which sorts by the first level

Using a string 'first' which is not a valid level

Index levels start at 0, so level 1 is the second level of the MultiIndex.

3fill in blank

hard

Fix the error in the code to sort the MultiIndex DataFrame in descending order.

Pandas

sorted_df = df.sort_index(ascending=[1])

Drag options to blanks, or click blank then click option'

ATrue

BNone

C'descending'

DFalse

Attempts:

3 left

💡 Hint

Common Mistakes

Using a string 'descending' instead of a boolean

Using True which sorts ascending

To sort in descending order, set ascending=False.

4fill in blank

hard

Fill both blanks to sort the MultiIndex DataFrame by the first level in descending order.

Pandas

sorted_df = df.sort_index(level=[1], ascending=[2])

Drag options to blanks, or click blank then click option'

A0

B1

CFalse

DTrue

Attempts:

3 left

💡 Hint

Common Mistakes

Using level=1 instead of 0

Using ascending=True which sorts ascending

Level 0 is the first index level, and ascending=False sorts descending.

5fill in blank

hard

Fill all three blanks to sort the MultiIndex DataFrame by both levels, first ascending then descending.

Pandas

sorted_df = df.sort_index(level=[[1], [2]], ascending=[[3], False])

Drag options to blanks, or click blank then click option'

A0

B1

CTrue

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong level numbers

Using ascending=False for both levels

Sort by level 0 ascending (True), then level 1 descending (False).