Creating DataFrame from dictionary in Pandas - Visual Walkthrough

Concept Flow - Creating DataFrame from dictionary

Start with dictionary

↓

Pass dictionary to pd.DataFrame()

↓

pandas creates columns from keys

↓

Rows created from values

↓

DataFrame object ready to use

We start with a dictionary where keys are column names and values are lists of data. Passing it to pd.DataFrame() creates a table with columns and rows.

Execution Sample

Pandas

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 with two columns: Name and Age, then prints it.

Execution Table

Step	Action	Dictionary State	DataFrame State	Output
1	Define dictionary 'data'	{'Name': ['Alice', 'Bob'], 'Age': [25, 30]}	None	No output
2	Call pd.DataFrame(data)	Same	DataFrame with columns 'Name' and 'Age', 2 rows	No output
3	Print df	Same	Same	Name Age 0 Alice 25 1 Bob 30

💡 DataFrame created and printed successfully

Variable Tracker

Variable	Start	After pd.DataFrame()	Final
data	{'Name': ['Alice', 'Bob'], 'Age': [25, 30]}	Same	Same
df	None	DataFrame with 2 rows and 2 columns	Same

Key Moments - 2 Insights

Why do the dictionary keys become column names in the DataFrame?

Because pandas uses the dictionary keys as column headers when creating the DataFrame, as shown in execution_table step 2.

What happens if the lists in the dictionary have different lengths?

pandas will raise an error because all columns must have the same number of rows. This is not shown here but is important to remember.

Visual Quiz - 3 Questions

Look at the execution_table at step 3, what does the DataFrame output show?

A An error message

B A list of dictionary keys

C A table with columns 'Name' and 'Age' and two rows with Alice and Bob

D An empty DataFrame

💡 Hint

Refer to the Output column in execution_table row 3

At which step is the DataFrame object created?

A Step 1

B Step 2

C Step 3

D After printing

💡 Hint

Check the DataFrame State column in execution_table

If the 'Age' list had 3 values but 'Name' had 2, what would happen?

A pandas would raise an error

B DataFrame would ignore extra values

C DataFrame would fill missing values with NaN

D DataFrame would duplicate last value

💡 Hint

See key_moments about list length mismatch

Concept Snapshot

Create DataFrame from dict:
- Use pd.DataFrame(dictionary)
- Keys become columns
- Values (lists) become rows
- All lists must be same length
- Result is a table-like DataFrame

Full Transcript

We start with a dictionary where keys are column names and values are lists of data. Passing this dictionary to pandas' DataFrame function creates a table with columns named after the keys and rows from the lists. The code example shows creating a DataFrame with columns 'Name' and 'Age' and two rows. The execution table traces defining the dictionary, creating the DataFrame, and printing it. Variables 'data' and 'df' are tracked through the steps. Key moments clarify why keys become columns and the importance of equal list lengths. The quiz tests understanding of the output, creation step, and error on mismatched list lengths.