1. What is the primary purpose of the pandas library?
A. Working with unstructured multimedia data
B. Creating and manipulating structured tabular data
C. Building machine learning models
D. Visualizing neural networks

Correct answer: B.

2. Which pandas object is one-dimensional and enforces a homogeneous data type?
A. DataFrame
B. Index
C. Series
D. Panel

Correct answer: C.

3. How can a pd.Series be best compared to an Excel structure?
A. Entire worksheet
B. Row
C. Column
D. Pivot table

Correct answer: C.

4. Which object in pandas represents labels for rows or columns?
A. Series
B. DataFrame
C. Index
D. ndarray

Correct answer: C.

5. What happens if no index is provided when creating a pd.Series?
A. An error is raised
B. A random index is created
C. A RangeIndex starting at 0 is created
D. Index values must be inferred manually

Correct answer: C.

6. Which argument is used to explicitly set the data type of a pd.Series?
A. type=
B. data_type=
C. dtype=
D. astype=

Correct answer: C.

7. What is the default value of the name attribute of a pd.Series if not provided?
A. Empty string
B. Undefined
C. None
D. "Series"

Correct answer: C.

8. Which structure allows heterogeneous column data types?
A. Series
B. Index
C. ndarray
D. DataFrame

Correct answer: D.

9. When constructing a DataFrame from a dictionary, what do the dictionary keys represent?
A. Row labels
B. Index levels
C. Column labels
D. Data types

Correct answer: C.

10. Which attribute returns the number of rows in a pd.Series?
A. size
B. shape
C. len()
D. index

Correct answer: B.

11. What does the pd.Series.shape attribute return?
A. An integer
B. A list
C. A one-element tuple
D. A two-element tuple

Correct answer: C.

12. Which attribute of a DataFrame returns a Series of column data types?
A. dtype
B. dtypes
C. types
D. schema

Correct answer: B.

13. What does len(df) return for a DataFrame?
A. Number of columns
B. Total number of elements
C. Number of rows
D. Size of memory used

Correct answer: C.

14. In basic DataFrame selection using df["a"], what is returned?
A. A DataFrame
B. A scalar
C. A NumPy array
D. A Series

Correct answer: D.

15. What does df[["a"]] return?
A. A Series
B. A DataFrame
C. A scalar
D. A NumPy array

Correct answer: B.

16. When using [] with a Series that has a non-default integer index, selection is done by:
A. Position
B. Order of insertion
C. Label
D. Data type

Correct answer: C.

17. Which method should be used for explicit position-based selection in a Series?
A. loc
B. at
C. iloc
D. ix

Correct answer: C.

18. What does ser.iloc[1] return?
A. All rows with label 1
B. The value at position 1
C. A slice of the Series
D. A DataFrame

Correct answer: B.

19. How many indexers are required when using DataFrame.iloc?
A. One
B. Two
C. Three
D. Unlimited

Correct answer: B.

20. What does df.iloc[:, 0] return?
A. First row
B. First column as a Series
C. First column as a DataFrame
D. Entire DataFrame

Correct answer: B.

21. Which method performs label-based selection in a Series?
A. iloc
B. at
C. loc
D. take

Correct answer: C.

22. What is a key difference between slicing with loc and iloc?
A. loc excludes the stop value
B. iloc includes labels
C. loc includes the stop label
D. iloc works only with strings

Correct answer: C.

23. Which operation may raise a KeyError when using loc?
A. Slicing with ordered unique labels
B. Selecting existing labels
C. Slicing with non-unique unordered labels
D. Selecting with lists

Correct answer: C.

24. In a DataFrame, df.loc["Jack", :] selects:
A. All rows named Jack
B. All columns named Jack
C. All columns for the row labeled Jack
D. Only numeric columns

Correct answer: C.

1. What is the output of this code?

import pandas as pd
s = pd.Series([1, 2, 3], index=['a', 'b', 'c'])
print(s.reindex(['c', 'a', 'd']))

A. Series with values [3, 1, NaN]
B. Series with values [3, 1]
C. KeyError
D. Series with values [1, 3, NaN]

Correct answer: A.

2. What does this code produce?

import pandas as pd
df = pd.DataFrame({'a': [1, 2], 'b': [3, 4]})
print(df.assign(c=lambda x: x['a'] + x['b'])['c'].iloc[1])

A. 3
B. 4
C. 5
D. 6

Correct answer: C.

3. What is the result?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
df.loc[df['a'] > 1, 'a'] = 0
print(df['a'].tolist())

A. [1, 2, 3]
B. [1, 0, 0]
C. [0, 0, 0]
D. [1, 2, 0]

Correct answer: B.

4. What does this output?

import pandas as pd
s = pd.Series([10, 20, 30], index=[2, 0, 1])
print(s.sort_index().iloc[0])

A. 10
B. 20
C. 30
D. IndexError

Correct answer: B.

5. What is returned?

import pandas as pd
df = pd.DataFrame({'a': [1, 1, 2]})
print(df['a'].value_counts().loc[1])

A. 1
B. 2
C. 3
D. KeyError

Correct answer: B.

6. What does this code output?

import pandas as pd
s = pd.Series([1, 2, 3])
print(s.map({1: 'a', 2: 'b'}).isna().sum())

A. 0
B. 1
C. 2
D. 3

Correct answer: B.

7. What is the result?

import pandas as pd
df = pd.DataFrame({'a': [1, None, 3]})
print(df['a'].astype('Int64').isna().sum())

A. 0
B. 1
C. 2
D. Raises error

Correct answer: B.

8. What does this produce?

import pandas as pd
df = pd.DataFrame({'a': [1, 2], 'b': [3, 4]})
print(df.filter(regex='a').shape)

A. (1, 2)
B. (2, 1)
C. (2, 2)
D. (1, 1)

Correct answer: B.

9. What is printed?

import pandas as pd
s = pd.Series(['1', '2', '3'])
print(s.str.cat(sep='-'))

A. 1-2-3
B. ['1-2-3']
C. Series
D. Error

Correct answer: A.

10. What does this code return?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.sample(n=1).shape)

A. (3, 1)
B. (1, 3)
C. (1, 1)
D. Depends on random seed

Correct answer: C.

11. What is the result?

import pandas as pd
s = pd.Series([1, 2, 3, 4])
print(s.rolling(2).sum().iloc[-1])

A. 4
B. 5
C. 6
D. NaN

Correct answer: B.

12. What does this output?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.eval('b = a * 2').shape)

A. (3, 1)
B. (3, 2)
C. (1, 3)
D. Error

Correct answer: B.

13. What is returned?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.query('a % 2 == 0')['a'].iloc[0])

A. 1
B. 2
C. 3
D. KeyError

Correct answer: B.

14. What does this code output?

import pandas as pd
s = pd.Series([1, 2, 3])
print(s.to_frame().shape)

A. (1, 3)
B. (3, 1)
C. (3, 3)
D. (1, 1)

Correct answer: B.

15. What is the result?

import pandas as pd
df = pd.DataFrame({'a': [1, 2]})
print(df.T.shape)

A. (2, 1)
B. (1, 2)
C. (2, 2)
D. (1, 1)

Correct answer: B.

16. What does this print?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.shift(1)['a'].isna().sum())

A. 0
B. 1
C. 2
D. 3

Correct answer: B.

17. What is the output?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.duplicated().any())

A. True
B. False
C. None
D. Error

Correct answer: B.

18. What does this code return?

import pandas as pd
s = pd.Series([3, 1, 2])
print(s.rank().tolist())

A. [3, 1, 2]
B. [1, 2, 3]
C. [3.0, 1.0, 2.0]
D. [3.0, 1.0, 2.0] sorted

Correct answer: C.

19. What is printed?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.memory_usage(deep=True).iloc[1] > 0)

A. True
B. False
C. None
D. Error

Correct answer: A.

20. What does this produce?

import pandas as pd
df = pd.DataFrame({'a': [1, 2, 3]})
print(df.select_dtypes(include='int').shape)

A. (3, 0)
B. (0, 1)
C. (3, 1)
D. (1, 3)

Correct answer: C.

I have sent you some real and important questions based on my reading of the book "Pandas Cookbook 2025".

A great app for building and programming desktop, Android, and Telegram bots using only prompts

Just send what you want and it will design everything for you and the possibility to make money from your app 👍

🛑 Popular #SQL interview question.

How would you answer it?

https://t.me/DataAnalyticsX

👩‍💻 FREE 2026 IT Learning Kits Giveaway

🔥Whether you're preparing for #Cisco #AWS #PMP #Python #Excel #Google #Microsoft #AI or any other in-demand certification – SPOTO has got you covered!

🎁 Explore Our FREE Study Resources
·IT Certs E-book : https://bit.ly/3YvSMHL
·IT exams skill Test : https://bit.ly/4r4VHnd
·Python, ITIL, PMP, Excel, Cyber Security, cloud, SQL Courses : https://bit.ly/4qNWl8r
·Free AI online preparation material and support tools : https://bit.ly/4qKiKTN

🔗 Need IT Certs Exam Help？ contact: wa.link/dm4kyz
📲 Join IT Study Group for insider tips & expert support:
https://chat.whatsapp.com/BEQ9WrfLnpg1SgzGQw69oM