A data analyst has a DataFrame with columns 'department', 'salary', and 'years_of_experience'. The analyst wants to find the department with the highest average salary, but only for employees with more than 5 years of experience. Which sequence should be used?

Filter rows where years_of_experience > 5, then group by 'department', compute mean salary, sort descending, and take the first row.

Sort the DataFrame by salary descending, then filter to years_of_experience > 5, and take the first row.

Group by 'department', compute mean salary, then filter the grouped result to years_of_experience > 5.

Use df.nlargest(1, 'salary') on the entire DataFrame, then filter to years_of_experience > 5.

GIAC Python Coder

Domain 4Objective 1

Data Analysis with Python GPYC Practice Questions (Page 1)

Part of the Data Analysis domain, which makes up ~9% of our current practice bank. GIAC (SANS) does not publish an official question count, but from its 120-minute exam (~50–80 total, ~5–7 in this domain), expect 5–7 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

5concepts

Questions 1–5

1foundation · easy
Which pandas method computes the correlation between columns in a DataFrame?
Select an answer first
2expert · hard
A data analyst has a DataFrame with columns 'department', 'salary', and 'years_of_experience'. The analyst wants to find the department with the highest average salary, but only for employees with more than 5 years of experience. Which sequence should be used?
Select an answer first
3foundation · easy
Which pandas function is specifically designed to read a JSON file into a DataFrame?
Select an answer first
4foundation · easy
Which Matplotlib function is used to create a simple line plot?
Select an answer first
5foundation · easy
Which pandas method groups rows by one or more columns and allows you to apply aggregation functions?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to GPYC

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 GIAC (SANS). “GPYC” is a trademark of its owner, used for identification only.

Data Analysis with Python GPYC Practice Questions (Page 1)

Questions 1–5

Which pandas method computes the correlation between columns in a DataFrame?

A data analyst has a DataFrame with columns 'department', 'salary', and 'years_of_experience'. The analyst wants to find the department with the highest average salary, but only for employees with more than 5 years of experience. Which sequence should be used?

Which pandas function is specifically designed to read a JSON file into a DataFrame?

Which Matplotlib function is used to create a simple line plot?

Which pandas method groups rows by one or more columns and allows you to apply aggregation functions?

Keep studying — Data Analysis