DataFrame structure (index, columns, values) in Data Analysis Python - Step-by-Step Execution

Concept Flow - DataFrame structure (index, columns, values)

Create DataFrame

↓

Set Index (row labels)

↓

Set Columns (column labels)

↓

Fill Values (data cells)

↓

DataFrame Ready for Use

This flow shows how a DataFrame is built step-by-step: first created, then rows get labels (index), columns get labels, and finally the data values fill the cells.

Execution Sample

Data Analysis Python

import pandas as pd

data = {'Name': ['Alice', 'Bob'], 'Age': [25, 30]}
df = pd.DataFrame(data)
print(df)

This code creates a DataFrame from a dictionary and prints its structure showing index, columns, and values.

Execution Table

Step	Action	Index	Columns	Values
1	Create DataFrame from dict	[0, 1]	['Name', 'Age']	[['Alice', 25], ['Bob', 30]]
2	Print DataFrame	[0, 1]	['Name', 'Age']	[['Alice', 25], ['Bob', 30]]
3	End	[0, 1]	['Name', 'Age']	[['Alice', 25], ['Bob', 30]]

💡 DataFrame created with default index 0,1; columns 'Name' and 'Age'; values filled from dictionary.

Variable Tracker

Variable	Start	After 1	Final
df.index	None	RangeIndex(start=0, stop=2, step=1)	RangeIndex(start=0, stop=2, step=1)
df.columns	None	Index(['Name', 'Age'], dtype='object')	Index(['Name', 'Age'], dtype='object')
df.values	None	[['Alice' 25] ['Bob' 30]]	[['Alice' 25] ['Bob' 30]]

Key Moments - 2 Insights

Why does the DataFrame have index values 0 and 1?

Because when creating from a dictionary without specifying index, pandas assigns default integer index starting at 0, as shown in execution_table step 1.

Are the columns 'Name' and 'Age' part of the data or labels?

They are column labels, not data values. The values are inside the cells under these columns, as seen in execution_table columns and values.

Visual Quiz - 3 Questions

Look at the execution_table at step 1, what are the column labels of the DataFrame?

A ['Name', 'Age']

B [0, 1]

C ['Alice', 'Bob']

D [25, 30]

💡 Hint

Check the 'Columns' column in execution_table row with Step 1.

At which step does the DataFrame get its values filled?

A Step 3

B Step 2

C Step 1

D Values are never filled

💡 Hint

Look at the 'Values' column in execution_table; values appear at Step 1.

If we specify index=['a', 'b'] when creating the DataFrame, how would df.index change?

A [0, 1]

B ['a', 'b']

C ['Name', 'Age']

D ['Alice', 'Bob']

💡 Hint

Refer to variable_tracker for df.index values and how index labels are assigned.

Concept Snapshot

DataFrame structure:
- Index: row labels (default 0,1,...)
- Columns: column labels (from data keys)
- Values: data cells under columns
Create with pd.DataFrame(data), index optional
Access with df.index, df.columns, df.values

Full Transcript

A DataFrame is like a table with rows and columns. When you create it from a dictionary, pandas sets default row labels called index (0,1,2...) and column labels from the dictionary keys. The data fills the cells under these columns. You can see the index with df.index, columns with df.columns, and the actual data with df.values. This example shows a DataFrame with two rows labeled 0 and 1, columns 'Name' and 'Age', and values for Alice and Bob.

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