Selecting columns by name in Pandas - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the column 'Age' from the DataFrame df.

Pandas

age_column = df[[1]]

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

A'age'

Bdf['Age']

CAge

D'Age'

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to use quotes around the column name.

Using the variable name without quotes.

Trying to select the column without brackets.

To select a column by name in pandas, you use the column name as a string inside square brackets.

2fill in blank

medium

Complete the code to select multiple columns 'Name' and 'Salary' from the DataFrame df.

Pandas

selected_columns = df[[1]]

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

A('Name', 'Salary')

B['Name', 'Salary']

C'Name', 'Salary'

D{'Name', 'Salary'}

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tuple or set instead of a list.

Not using brackets around the list.

Passing column names as a single string.

To select multiple columns, pass a list of column names inside the brackets.

3fill in blank

hard

Fix the error in the code to select the 'City' column from df.

Pandas

city = df.[1]

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

ACity

B'City'

Ccity

D['City']

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes inside dot notation.

Using brackets with dot notation.

Using lowercase when column name is capitalized.

When using dot notation to select a column, use the exact column name without quotes.

4fill in blank

hard

Fill both blanks to select columns 'Height' and 'Weight' from df and assign to new_df.

Pandas

new_df = df[[1]]
print(new_df.columns[[2]])

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

A['Height', 'Weight']

B['Height', 'Weight', 'Age']

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tuple or set instead of a list for columns.

Using wrong index to access columns.

Including extra columns in the list.

Use a list of column names to select multiple columns. Index 0 accesses the first column name.

5fill in blank

hard

Fill all three blanks to create a dictionary with column names as keys and their data types as values.

Pandas

col_types = [1]: df[[2]].dtype for [3] in df.columns}

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

Acol

Dcolumn

Attempts:

3 left

💡 Hint

Common Mistakes

Using different variable names in different blanks.

Not using the variable to select the column.

Using df.columns directly as key.

Use a dictionary comprehension with a variable iterating over df.columns. The variable is used as key and to select the column.