A DataFrame 'df' has columns ['name', 'age', 'salary', 'department'] with rows indexed by employee ID. An analyst wants to view the 'name' and 'salary' columns for employees in the 'Engineering' department, sorted by salary in descending order. Which code accomplishes this?

df[df['department'] == 'Engineering'][['name', 'salary']].sort_values('salary', ascending=False)

df[['name', 'salary']].sort_values('salary', ascending=False)[df['department'] == 'Engineering']

df.loc[df['department'] == 'Engineering', ['name', 'salary']].sort_values('salary')

df.sort_values('salary', ascending=False)[['name', 'salary']][df['department'] == 'Engineering']

Python InstitutePCAD - Certified Associate in Data Analytics with Python

Domain 4Objective 1

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

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 1–5

1foundation · easy
Which Pandas method is used to convert the data type of a column, such as changing a column from object to float?
Select an answer first
2application · medium
A DataFrame 'df' has columns ['name', 'age', 'salary', 'department'] with rows indexed by employee ID. An analyst wants to view the 'name' and 'salary' columns for employees in the 'Engineering' department, sorted by salary in descending order. Which code accomplishes this?
Select an answer first
3foundation · easy
Which Pandas method is used to compute the standard deviation of a numeric column?
Select an answer first
4foundation · easy
Which Pandas locator is used to select data by position (integer-based indexing) rather than by label?
Select an answer first
5foundation · easy
Which Pandas function is used to combine two DataFrames by aligning them on a common column or index, similar to a SQL JOIN?
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 1)

Questions 1–5

Which Pandas method is used to convert the data type of a column, such as changing a column from object to float?

A DataFrame 'df' has columns ['name', 'age', 'salary', 'department'] with rows indexed by employee ID. An analyst wants to view the 'name' and 'salary' columns for employees in the 'Engineering' department, sorted by salary in descending order. Which code accomplishes this?

Which Pandas method is used to compute the standard deviation of a numeric column?

Which Pandas locator is used to select data by position (integer-based indexing) rather than by label?

Which Pandas function is used to combine two DataFrames by aligning them on a common column or index, similar to a SQL JOIN?

Keep studying — Data Analysis and Modeling