ChallengeConstructionPYTHON+20 XP

Reusable Data Quality: Target 8

Scenario

You are a data professional working with construction data. Prepare a reliable reusable result from site_jobs for a review.

Question

Keep values at or above 8. Print a summary with records (the count) and total (their sum). Put your calculation in a function named analyse and call it with the provided values.

Your task

Inspect the provided data and column names
Keep values at or above 8. Print a summary with records (the count) and total (their sum). Put your calculation in a function named analyse and call it with the provided values.
Run your code and compare the result

Model evaluationData ScienceProblem solving

Read the simple theory: Model evaluation

Data Science · Problem Solving & Regression — question 26 of 30

Finish all 30 to earn a certificate

1. Choose your dataset

Pick an industry and a size. Your code and results change to match.

IndustrySize

📓 DataPro notebookextension-real-world-construction-advanced-real-world__Data_Science-6.ipynbFileEditViewRunKernel: Python 3

[md]

Reusable Data Quality: Target 8

Keep values at or above 8. Print a summary with records (the count) and total (their sum). Put your calculation in a function named analyse and call it with the provided values.

In [1]:

Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].

python editorsite_jobs

Snippets

💡 Explain my whole code, line by line (hover any word in the editor for a tip)

🌈 In short — no coding words

📂 Opens the "site_jobs" table→✅ Shows you the answer

Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.

Start typing to see suggestions. Press Enter to use one. Red marks show the line to fix. Drag a bottom corner horizontally and vertically to resize.

Type your code here ↓Tap or click inside the box to start

✍️ Tap here to type

Dataset & schema

site_jobs

IndustryDataset size

The tiny starter data. Bigger data scrolls.

Fields

job_id	site	workers
J1	Bridge	10
J2	School	6
J3	Bridge	14
J4	Road	8

Construction practice data only.

attempts: 0

▶ Output terminal

$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

5 left

Keeps qualifying values
Calculates the requested result
Prints the result
Defines a reusable function
Runs the function