Dropping columns and rows in Pandas - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to drop the column named 'Age' from the DataFrame df.

Pandas

df = df.drop([1], axis=1)

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

A'Age', axis=1

B'age'

C'Age'

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong column name with incorrect case.

Not specifying axis=1 when dropping a column.

To drop a column by name, pass the column name as a string and set axis=1.

2fill in blank

medium

Complete the code to drop the row with index label 3 from the DataFrame df.

Pandas

df = df.drop([1], axis=0)

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

A3

B'3'

C'index=3'

Ddf.index[3]

Attempts:

3 left

💡 Hint

Common Mistakes

Passing the index as a string instead of an integer.

Confusing axis=0 and axis=1.

To drop a row by index label, pass the label as an integer and use axis=0 (rows).

3fill in blank

hard

Fix the error in the code to drop the column 'Salary' from df.

Pandas

df.drop([1], axis=1, inplace=True)

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

A['Salary']

BSalary

C'salary'

D'Salary'

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the column name.

Using wrong case for the column name.

The column name must be a string matching exactly the column label. Use 'Salary'.

4fill in blank

hard

Fill both blanks to create a dictionary comprehension that maps words to their lengths only if the length is greater than 3.

Pandas

{word: [1] for word in words if [2]

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

Alen(word)

Blen(word) > 3

Cword

Dword > 3

Attempts:

3 left

💡 Hint

Common Mistakes

Using the word itself as the value instead of its length.

Using the word in the condition instead of its length.

The dictionary maps each word to its length (len(word)) only if the length is greater than 3 (len(word) > 3).

5fill in blank

hard

Fill all three blanks to create a dictionary comprehension that maps uppercase words to their counts only if the count is greater than 0.

Pandas

{ [1]: [2] for [3] in data.items() if [2] > 0 }

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

Ak.upper()

Bv

Ck

Ddata

Attempts:

3 left

💡 Hint

Common Mistakes

Using data instead of k or v in the comprehension.

Not converting keys to uppercase.

The dictionary maps uppercase keys (k.upper()) to their values (v) only if the value is greater than 0. The loop variable is k.