Why DataFrame creation matters in Pandas - Challenge Your Understanding

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output shape of this DataFrame?

Consider the following code creating a DataFrame from a dictionary of lists. What is the shape (rows, columns) of the resulting DataFrame?

Pandas

import pandas as pd
data = {'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}
df = pd.DataFrame(data)
print(df.shape)

A (2, 3)

B (3, 2)

C (3, 3)

D (9, 3)

💡 Hint

Each key in the dictionary becomes a column, and each list item becomes a row.

The DataFrame has 3 columns (A, B, C) and 3 rows because each list has 3 elements.

❓ data_output

intermediate

What is the DataFrame content after creation?

Given this code, what is the content of the DataFrame?

Pandas

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

A

Name  Age
1  Alice  25
2  Bob    30

B

   Name  Age
0  Alice   25
1    Bob   30

C

   Name  Age
1  Alice   25
2    Bob   30

D

Name  Age
0  Alice  25
1  Bob    30

💡 Hint

Default index starts at 0 and increments by 1.

The DataFrame shows two rows with index 0 and 1, columns 'Name' and 'Age'.

🔧 Debug

advanced

Why does this DataFrame creation raise an error?

Look at this code snippet. Why does it raise an error?

Pandas

import pandas as pd
data = {'A': [1, 2], 'B': [3, 4, 5]}
df = pd.DataFrame(data)

A ValueError because columns have different length lists

B SyntaxError due to missing colon

C TypeError because dictionary keys are not strings

D No error, DataFrame created successfully

💡 Hint

All columns must have the same number of elements.

The lists for columns 'A' and 'B' have different lengths (2 and 3), causing a ValueError.

🧠 Conceptual

advanced

Why is DataFrame creation method important for performance?

Which statement best explains why the method of creating a DataFrame matters for performance?

A DataFrame creation speed depends only on the number of columns, not rows.

B All DataFrame creation methods have the same performance because pandas optimizes automatically.

C Creating a DataFrame from a CSV file is always faster than from any Python data structure.

D Creating a DataFrame from a list of dictionaries is slower than from a dictionary of lists because of internal data alignment.

💡 Hint

Think about how pandas aligns data internally when creating from different structures.

Creating from a list of dicts requires pandas to align keys for each row, which is slower than creating from dict of lists where columns are aligned directly.

🚀 Application

expert

Which code produces a DataFrame with a MultiIndex?

Choose the code snippet that creates a DataFrame with a MultiIndex on rows.

A

import pandas as pd
index = pd.MultiIndex.from_tuples([('a', 1), ('a', 2)])
data = {'value': [10, 20]}
df = pd.DataFrame(data, index=index)

B

import pandas as pd
data = {('A', 1): [10, 20], ('A', 2): [30, 40]}
df = pd.DataFrame(data)

C

import pandas as pd
data = {'A': [10, 20], 'B': [30, 40]}
df = pd.DataFrame(data)
df.set_index(['A', 'B'], inplace=True)

D

import pandas as pd
data = {'A': [10, 20], 'B': [30, 40]}
df = pd.DataFrame(data)
df.index = ['a', 'b']

💡 Hint

MultiIndex is created explicitly using pandas MultiIndex class.

Option A uses pd.MultiIndex.from_tuples to create a MultiIndex and passes it as index to the DataFrame.