DataFrame structure (index, columns, values) in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the index in a DataFrame?

The index is like the row labels in a DataFrame. It helps identify each row uniquely, similar to how house numbers identify houses on a street.

beginner

What do columns represent in a DataFrame?

Columns are the named categories or features in a DataFrame. Think of them as the labels on a spreadsheet's vertical sections that describe what data each column holds.

beginner

What are the values in a DataFrame?

Values are the actual data stored inside the DataFrame cells, arranged by rows and columns. They are like the contents inside each cell of a spreadsheet.

beginner

How can you access the index of a DataFrame in Python?

You can access the index using df.index, where df is your DataFrame variable.

beginner

How do you get the column names of a DataFrame?

Use df.columns to get a list of all column names in the DataFrame.

What does the index in a DataFrame represent?

A Column names

B Row labels

C Data values

D Data types

The index represents the row labels that uniquely identify each row.

Which attribute gives you the column names of a DataFrame?

A df.columns

B df.index

C df.values

D df.data

df.columns returns the column names of the DataFrame.

What type of data does df.values return?

A Data types of columns

B Column names

C Row labels

D Underlying data as a 2D array

df.values returns the actual data in the DataFrame as a 2D array.

If you want to see the row labels of a DataFrame, which command do you use?

A df.index

B df.head()

C df.values

D df.columns

df.index shows the row labels (index) of the DataFrame.

Which part of a DataFrame is similar to the headers in a spreadsheet?

A Index

B Values

C Columns

D Cells

Columns are like headers in a spreadsheet that describe each data category.

Explain the three main parts of a DataFrame: index, columns, and values.

Think about how a spreadsheet is organized.

How would you access the index and columns of a DataFrame in Python?

Remember the attributes of a DataFrame object.

Practice

1. Which part of a DataFrame represents the labels for the rows?

easy

A. Values

B. Columns

C. Index

D. Cells

Solution

1. Step 1: Understand DataFrame parts

   A DataFrame has three main parts: index (row labels), columns (column names), and values (data).

2. Step 2: Identify row labels

   The row labels are called the index, which helps identify each row uniquely.

3. Final Answer:

   Index -> Option C

4. Quick Check:

   Row labels = Index [OK]

Hint: Rows are labeled by the index in a DataFrame [OK]

Common Mistakes:

• Confusing columns with index
• Thinking values are labels
• Mixing cells with index

2. Which of the following is the correct way to get the column names of a DataFrame named df?

easy

A. df.columns

B. df.index

C. df.values

D. df.names

Solution

1. Step 1: Recall DataFrame attributes

   To get column names, use the columns attribute of the DataFrame.

2. Step 2: Match correct syntax

   The correct syntax is df.columns. Other options refer to rows or data.

3. Final Answer:

   df.columns -> Option A

4. Quick Check:

   Columns = df.columns [OK]

Hint: Use df.columns to get column names quickly [OK]

Common Mistakes:

• Using df.index for columns
• Trying df.names which doesn't exist
• Using df.values for columns

3. Given the DataFrame df below:

   A  B  C
0  1  4  7
1  2  5  8
2  3  6  9

What will df.values[1, 2] return?

medium

A. 5

B. 2

C. 6

D. 8

Solution

1. Step 1: Understand DataFrame values and indexing

   df.values returns the data as a 2D array. The first index is the row, the second is the column.

2. Step 2: Locate the value at row 1, column 2

   Row 1 is the second row: [2, 5, 8]. Column 2 is the third column, value 8.

3. Final Answer:

   8 -> Option D

4. Quick Check:

   df.values[1, 2] = 8 [OK]

Hint: Remember indexing starts at 0 for rows and columns [OK]

Common Mistakes:

• Mixing row and column indexes
• Using df.iloc instead of df.values
• Off-by-one errors in indexing

4. What is wrong with this code to get the row labels of a DataFrame df?

row_labels = df.values

medium

A. It returns an empty list

B. It returns the data values, not the row labels

C. It returns the column names instead

D. It causes a syntax error

Solution

1. Step 1: Understand what df.values returns

   df.values returns the data inside the DataFrame as a numpy array, not the row labels.

2. Step 2: Identify correct attribute for row labels

   Row labels are stored in df.index, not df.values.

3. Final Answer:

   It returns the data values, not the row labels -> Option B

4. Quick Check:

   df.values ≠ row labels [OK]

Hint: Use df.index for rows, not df.values [OK]

Common Mistakes:

• Confusing df.values with df.index
• Expecting df.values to give labels
• Using wrong attribute names

5. You have a DataFrame df with custom row labels ["a", "b", "c"] and columns ["X", "Y"]. Which code correctly extracts the data values as a 2D array?

hard

A. df.values

B. df.index

C. df.columns

D. df.data

Solution

1. Step 1: Recall DataFrame parts

   Index holds row labels, columns hold column names, and values hold the actual data.

2. Step 2: Identify correct attribute for data values

   To get the data as a 2D array, use df.values. Other options do not return data values.

3. Final Answer:

   df.values -> Option A

4. Quick Check:

   Data values = df.values [OK]

Hint: Use df.values to get data regardless of labels [OK]

Common Mistakes:

• Using df.index or df.columns for data
• Trying df.data which doesn't exist
• Confusing labels with values