Creating DataFrame from list of lists in Pandas - Quick Revision & Summary

Recall & Review

beginner

What is a DataFrame in pandas?

A DataFrame is a table-like data structure in pandas that stores data in rows and columns, similar to a spreadsheet or SQL table.

beginner

How do you create a DataFrame from a list of lists?

You pass the list of lists to the pandas.DataFrame() function. Each inner list becomes a row in the DataFrame.

beginner

Why might you want to specify column names when creating a DataFrame from a list of lists?

Specifying column names helps you identify what each column represents, making the data easier to understand and work with.

intermediate

What happens if the inner lists have different lengths when creating a DataFrame?

pandas will fill missing values with NaN (Not a Number) to keep the DataFrame rectangular (same number of columns in each row).

beginner

Show a simple code example to create a DataFrame from a list of lists with column names.

import pandas as pd

data = [[1, 'Alice'], [2, 'Bob'], [3, 'Charlie']]
df = pd.DataFrame(data, columns=['ID', 'Name'])
print(df)

What does each inner list represent when creating a DataFrame from a list of lists?

A An index label

B A column in the DataFrame

C A DataFrame itself

D A row in the DataFrame

Each inner list corresponds to one row in the DataFrame.

Which pandas function is used to create a DataFrame from a list of lists?

A pd.DataFrame()

B pd.Series()

C pd.array()

D pd.list()

pd.DataFrame() creates a DataFrame from various data structures including list of lists.

What will pandas fill in if inner lists have different lengths?

A 0

B Empty string

C NaN

D Raises an error

pandas fills missing values with NaN to keep the DataFrame rectangular.

How can you name the columns when creating a DataFrame from a list of lists?

A Using the 'index' parameter

B Using the 'columns' parameter

C Using the 'names' parameter

D You cannot name columns at creation

The 'columns' parameter lets you specify column names.

What type of data structure is a list of lists?

A A nested list

B A dictionary

C A flat list

D A tuple

A list of lists is a nested list where each element is itself a list.

Explain how to create a pandas DataFrame from a list of lists and why you might want to specify column names.

Think about how rows and columns relate to the list structure.

What happens if the inner lists have different lengths when creating a DataFrame? How does pandas handle this?

Consider how pandas keeps the table shape consistent.