In Pandas, what is the relationship between a DataFrame and a Series?

A Series is a two-dimensional version of a DataFrame.

A DataFrame is a collection of Series objects that share the same index.

A Series is a collection of DataFrames that share the same columns.

A DataFrame and a Series are unrelated and cannot be used together.

A DataFrame 'df' is in long format with columns ['date', 'city', 'metric', 'value'], where 'metric' contains 'temperature' and 'humidity'. An analyst wants to create a wide DataFrame with one row per date and city, and separate columns 'temperature' and 'humidity'. Which operation achieves this?

df.stack().unstack(level='metric')

df.pivot(index=['date', 'city'], columns='metric', values='value')

df.melt(id_vars=['date', 'city'], var_name='metric', value_name='value')

df.groupby(['date', 'city', 'metric'])['value'].sum().unstack()

Which Pandas method is used to select only the rows of a DataFrame that satisfy a given condition, such as all rows where a column value is greater than 10?

Boolean indexing with df[df['col'] > 10]

Python InstitutePCAD - Certified Associate in Data Analytics with Python

Domain 4Objective 1

Data Analysis with Pandas and NumPy PCAD-31 Practice Questions (Page 4)

Part of the Data Analysis and Modeling domain, which accounts for 18.8% of the PCAD-31 exam. Python Institute does not publish an official question count, but from its 60-minute exam (~25–40 total, ~5–5 in this domain), expect 3–3 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

12concepts

18.8%of the exam

Questions 16–20

16foundation · easy
In Pandas, what is the relationship between a DataFrame and a Series?
Select an answer first
17application · medium
A DataFrame 'df' is in long format with columns ['date', 'city', 'metric', 'value'], where 'metric' contains 'temperature' and 'humidity'. An analyst wants to create a wide DataFrame with one row per date and city, and separate columns 'temperature' and 'humidity'. Which operation achieves this?
Select an answer first
18foundation · easy
Which Pandas method is used to select only the rows of a DataFrame that satisfy a given condition, such as all rows where a column value is greater than 10?
Select an answer first
19foundation · easy
What is the result of the following NumPy broadcasting operation: np.array([1, 2, 3]) + 10?
Select an answer first
20foundation · easy
Which Pandas method is used to transform a DataFrame from a long format to a wide format by turning unique values in a column into separate columns?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PCAD-31

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Python Institute. “PCAD-31” is a trademark of its owner, used for identification only.

Data Analysis with Pandas and NumPy PCAD-31 Practice Questions (Page 4)

Questions 16–20

In Pandas, what is the relationship between a DataFrame and a Series?

A DataFrame 'df' is in long format with columns ['date', 'city', 'metric', 'value'], where 'metric' contains 'temperature' and 'humidity'. An analyst wants to create a wide DataFrame with one row per date and city, and separate columns 'temperature' and 'humidity'. Which operation achieves this?

Which Pandas method is used to select only the rows of a DataFrame that satisfy a given condition, such as all rows where a column value is greater than 10?

What is the result of the following NumPy broadcasting operation: np.array([1, 2, 3]) + 10?

Which Pandas method is used to transform a DataFrame from a long format to a wide format by turning unique values in a column into separate columns?

Keep studying — Data Analysis and Modeling