What is Pandas - Practice Questions & Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the Purpose of Pandas

What is the main purpose of the Pandas library in data science?

A To build machine learning models

B To create interactive web pages

C To manipulate and analyze data easily

D To design computer graphics

💡 Hint

Think about what you do with tables of data in Python.

Pandas is mainly used to handle and analyze data in tables, making data science tasks easier.

❓ Predict Output

intermediate

Pandas DataFrame Creation Output

What will be the output of this code?

Pandas

import pandas as pd

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

A

   A  B
0  1  3
1  2  4

B Error: DataFrame not defined

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

D [[1, 3], [2, 4]]

💡 Hint

Look at how DataFrame prints tabular data.

The DataFrame shows columns A and B with their values in rows indexed 0 and 1.

❓ data_output

advanced

Selecting Data from a DataFrame

Given the DataFrame below, what is the output of df['B'][1]?

Pandas

import pandas as pd

df = pd.DataFrame({'A': [10, 20, 30], 'B': [100, 200, 300]})

A 100

B KeyError

C 30

D 200

💡 Hint

Remember that df['B'] selects column B, then [1] selects the second row.

Column B has values [100, 200, 300]. Index 1 is the second value, 200.

❓ visualization

advanced

Plotting with Pandas

What type of plot will this code produce?

Pandas

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame({'x': [1, 2, 3], 'y': [4, 5, 6]})
df.plot(x='x', y='y', kind='bar')
plt.show()

A A bar chart showing y values for each x

B A line chart connecting points (x, y)

C A scatter plot of x vs y

D A pie chart of y values

💡 Hint

The kind='bar' argument controls the plot type.

The code creates a bar chart with x on the horizontal axis and y as bar heights.

🔧 Debug

expert

Error Identification in Pandas Code

What error will this code raise?

Pandas

import pandas as pd

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

A TypeError

B KeyError

C IndexError

D No error, prints empty column

💡 Hint

Check if column 'C' exists in the DataFrame.

Accessing a non-existent column 'C' raises a KeyError in Pandas.