Python Institute PCED - Certified Entry-Level Data Analyst with Python - PCED-30-02 Exam Practice Test

A script attempts to divide two numbers using / and //. The values are 7 and 2. The developer wants to understand the difference between true division and floor division. What are the results respectively?

You are reviewing a report that compares the number of weekly client meetings and project completion rates across teams. The table below summarizes the data for each team:

Which statement best describes the data shown above? Select the best answer.

You are working with city names entered by users. These names may contain inconsistent capitalization and unwanted spaces.
To standardize the data, you want to:
- Remove any leading or trailing whitespace, and
- Capitalize the first letter of each word (e.g., convert "new york" to "New York").
For example:
" New york " → "New York"
"lOS ANGELES" → "Los Angeles"
You are given a variable citythat contains the raw input.
Which line of code correctly updates the value of cleaned_cityto apply the required transformation? Select the best answer.

How do the analysis and visualization stages of the data lifecycle typically work together?

A list is defined as [1, 2, 3]. The programmer uses the method .append([4, 5]). What will the resulting list look like after execution?

You have a list of test scores, where each entry includes a student name and a score. Some students appear more than once. You want to compute the average score for each student and store the results in a dictionary. Here's the partial code block:

Which code correctly replaces the # MISSING CODE comment to calculate the average score for each student? Select the best answer.