Series vs DataFrame relationship in Pandas - Practice Questions

Challenge - 5 Problems

❓ Predict Output

intermediate

Output of accessing a DataFrame column

What is the output type of the following code snippet?

Pandas

import pandas as pd

df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
result = type(df['A'])
print(result)

A <class 'list'>

B <class 'pandas.core.frame.DataFrame'>

C <class 'pandas.core.series.Series'>

D <class 'dict'>

💡 Hint

Accessing a single column from a DataFrame returns a Series.

When you select one column from a DataFrame using df['A'], it returns a Series object representing that column.

❓ Predict Output

intermediate

Shape of a Series vs DataFrame

What is the output of the following code?

Pandas

import pandas as pd

s = pd.Series([10, 20, 30])
df = pd.DataFrame({'X': [10, 20, 30]})
print(s.shape, df.shape)

A (3,) (3, 1)

B (3, 1) (3,)

C (1, 3) (1, 3)

D (3,) (1, 3)

💡 Hint

Series shape is one-dimensional, DataFrame shape is two-dimensional.

A Series has a shape with one dimension (number of elements), while a DataFrame has two dimensions (rows, columns).

❓ data_output

advanced

Creating a DataFrame from multiple Series

What is the resulting DataFrame when combining these Series?

Pandas

import pandas as pd

s1 = pd.Series([1, 2, 3], name='A')
s2 = pd.Series([4, 5, 6], name='B')
df = pd.concat([s1, s2], axis=1)
print(df)

A {'A': [1, 2, 3], 'B': [4, 5, 6]}

B

   A  B
0  1  4
1  2  5
2  3  6

C

0    1
1    2
2    3
0    4
1    5
2    6

D

A    1
B    4
A    2
B    5
A    3
B    6

💡 Hint

Concatenating Series along axis=1 creates columns in a DataFrame.

Using pd.concat with axis=1 stacks Series side by side as columns, forming a DataFrame.

🧠 Conceptual

advanced

Relationship between Series and DataFrame

Which statement best describes the relationship between a pandas Series and a DataFrame?

A A Series is a single column of data, and a DataFrame is a collection of Series sharing the same index.

B A Series is a two-dimensional table, and a DataFrame is a one-dimensional array.

C A Series and a DataFrame are completely unrelated data structures in pandas.

D A DataFrame is a single column of data, and a Series is a collection of DataFrames sharing the same index.

💡 Hint

Think about how columns relate to the whole table.

A DataFrame is like a table made of multiple Series (columns) that share the same index (row labels).

🔧 Debug

expert

Error when converting DataFrame column to Series

What error does the following code produce?

Pandas

import pandas as pd

df = pd.DataFrame({'A': [1, 2, 3]})
s = pd.Series(df['A'], index=[0, 1])

A TypeError: Cannot create a Series from a DataFrame column

B No error, s is a Series with length 3

C KeyError: 'A'

D ValueError: Length of passed values is 3, index implies 2

💡 Hint

Check if the index length matches the data length.

The error occurs because the Series constructor expects the index length to match the data length. Here, data has length 3 but index has length 2.

Practice

1.

What is a pandas.Series?

easy

A. A function to read CSV files

B. A table with multiple rows and columns

C. A method to plot graphs

D. A single labeled column of data

Solution

1. Step 1: Understand the definition of Series

   A Series in pandas is a one-dimensional labeled array, like a single column of data.

2. Step 2: Compare with other options

   Options A, B, and D describe file reading, DataFrame, and plotting, which are not Series.

3. Final Answer:

   A single labeled column of data -> Option D

4. Quick Check:

   Series = single column [OK]

Hint: Series is one column, DataFrame is many columns [OK]

Common Mistakes:

• Confusing Series with DataFrame
• Thinking Series is a function
• Mixing Series with plotting methods

2.

Which of the following is the correct way to get a Series from a DataFrame named df?

df = pd.DataFrame({"A": [1, 2], "B": [3, 4]})

easy

A. df["A"]

B. df.loc["A"]

C. df.iloc["A"]

D. df.get_series("A")

Solution

1. Step 1: Identify how to select a column as Series

   Using df["A"] selects the column labeled "A" as a Series.

2. Step 2: Check other options for correctness

   df.loc["A"] selects a row, df.iloc["A"] is invalid because iloc expects integer index, df.get_series() is not a pandas method.

3. Final Answer:

   df["A"] -> Option A

4. Quick Check:

   Column selection uses df["col"] [OK]

Hint: Use df["column_name"] to get a Series [OK]

Common Mistakes:

• Using loc with column name instead of row label
• Using iloc with string index
• Assuming get_series() exists

3.

What is the output of this code?

import pandas as pd

df = pd.DataFrame({"X": [10, 20], "Y": [30, 40]})
series = df["Y"]
print(type(series))

medium

A. <class 'pandas.core.frame.DataFrame'>

B. <class 'pandas.core.series.Series'>

C. <class 'list'>

D. TypeError

Solution

1. Step 1: Understand df["Y"] returns a Series

   Selecting a single column from a DataFrame returns a Series object.

2. Step 2: Check the printed type

   Printing type(series) shows <class 'pandas.core.series.Series'>.

3. Final Answer:

   <class 'pandas.core.series.Series'> -> Option B

4. Quick Check:

   Single column selection = Series type [OK]

Hint: df[column] returns Series, not DataFrame [OK]

Common Mistakes:

• Thinking df[column] returns DataFrame
• Confusing Series with list
• Expecting an error from this code

4.

Find the error in this code snippet:

import pandas as pd

df = pd.DataFrame({"A": [1, 2], "B": [3, 4]})
series = df.loc[:, "A"]
print(type(series))

medium

A. Using df.loc[:, "A"] returns a DataFrame, not Series

B. df.loc["A"] is the correct way to get Series

C. df.loc[:, "A"] returns a Series, no error here

D. df.loc[:, "A"] causes a syntax error

Solution

1. Step 1: Understand df.loc[:, "A"] selection

   df.loc[:, "A"] selects all rows and column "A", returning a Series.

2. Step 2: Check if this causes error

   This is valid syntax and returns a Series, so no error occurs.

3. Final Answer:

   df.loc[:, "A"] returns a Series, no error here -> Option C

4. Quick Check:

   df.loc with column label returns Series [OK]

Hint: df.loc[:, col] returns Series if col is single label [OK]

Common Mistakes:

• Thinking df.loc[:, col] returns DataFrame
• Confusing row and column selection
• Expecting syntax error on loc usage

5.

You have a DataFrame df with columns ['A', 'B', 'C']. You want to create a new DataFrame with only columns 'A' and 'C' as Series combined. Which code correctly does this?

hard

A. All of the above

B. new_df = df[["A", "C"]]

C. new_df = df.loc[:, ["A", "C"]]

D. new_df = pd.DataFrame({"A": df["A"], "C": df["C"]})

Solution

1. Step 1: Understand ways to select columns

   df[["A", "C"]] and df.loc[:, ["A", "C"]] both select columns as DataFrame.

2. Step 2: Creating DataFrame from Series

   pd.DataFrame({"A": df["A"], "C": df["C"]}) creates a new DataFrame from two Series.

3. Step 3: Check if all options are valid

   All three options produce a DataFrame with columns A and C.

4. Final Answer:

   All of the above -> Option A

5. Quick Check:

   Multiple ways to select columns as DataFrame [OK]

Hint: Selecting multiple columns: use list or dict of Series [OK]

Common Mistakes:

• Thinking only one method works
• Confusing Series with DataFrame in selection
• Using wrong syntax for multiple columns