Exam · Data analysis with Python: investigate and explain a dataset

Take the exam and earn your certificate.

A real, server-scored exam for this course. Score strictly above 80% to pass and get a genuine, verifiable certificate.

Before you start

We ask for your name and email first, the same as a PDF download, so we know you are here and your certificate can carry the right name.

We privately record your name, email and request IP for this exam request. Read the privacy notice and retention policy.

Visit Mickai on LinkedIn

Complete the security check before submitting.

Cloudflare Turnstile helps prevent automated submissions. How this check uses data.

You can retake the exam any time. Each attempt draws a fresh set of questions.

Written practice, ungraded

Write your response in your own notes, then compare it with the sample answer. This practice is separate from the scored exam and does not affect your certificate.

Practice 1

Explain the supplied raw-data problems on paper and why the question should precede cleaning.

Compare with a sample answer

The course raw file has exact duplicates, mixed-capital channel labels, mixed minutes and hours, the typed 999 placeholder, missing scores and dates still read as text. Begin with the like-for-like chat and email resolution-time question, because a written question stops the analysis drifting.

The sample enumerates supplied issues and the guiding question.

Practice 2

Give a paper cleaning plan that preserves raw evidence and does not turn missingness into invented answers.

Compare with a sample answer

Keep the raw file untouched. Drop exact exported copies, standardise channel case, set the typed 999 placeholder to missing before unit conversion, convert minutes to hours and leave missing scores missing. Log every decision with a count, then compare retained rows with present hours and scores.

The sample follows source decisions and count/missingness distinctions.

Practice 3

Explain why the overall channel gap and the two satisfaction shares need qualification.

Compare with a sample answer

Topic mixes differ: chat contains more quick login cases and email more slow deliveries, so compare within topic. The 0.84 chat share is among answered surveys; 0.61 is among all chat tickets. Name the denominator and response rate because people who answered may differ from nonrespondents. This is supplied fictional evidence, not a causal or real-service conclusion.

The sample retains confounding, answered/all denominators and response selection.

Practice 4

Describe a paper lookup audit and an honest month-count chart.

Compare with a sample answer

Use topic as the key, preserve tickets with a left join, validate that the lookup has one row per topic and inspect _merge and row counts. Exclude missing times deliberately when calculating target shares. For monthly count heights start the y-axis at zero and label June as only 1 to 14 June.

The sample retains lookup uniqueness, match diagnostics, missing-time denominator and partial period.

Practice 5

Explain the recorded within-topic bootstrap intervals and correlation limits without claiming a causal effect.

Compare with a sample answer

All within-topic intervals cross zero, so this sample cannot confirm their gap directions; delivery is particularly uncertain with only 11 chat tickets. A bootstrap approximates method coverage across repeated samples, not a 95% probability for a fixed interval. It cannot fix biased sampling or confounding. The supplied correlation is association, and the fictional generator mechanism is not evidence about real services.

The sample retains small-stratum uncertainty, interval interpretation and causation boundaries.

Practice 6

Give a paper review of the bad draft and a reproducibility/AI-briefing plan.

Compare with a sample answer

The unrestricted dropna removes timing-relevant tickets for missing scores; targets join by topic, not channel; resolved_on_time is an invented column. Preserve the raw generated file, log cleaning and pin the recorded environment, noting that a seed does not ensure all random methods repeat across Python versions. Share only schema and invented rows with an assistant. Recompute key numbers through an independent route, which is a cross-check rather than proof of the whole method.

The sample retains source defects and evidence/reproducibility limits.

About this exam

Is this exam graded?

Yes. Every question is scored on our server, never in your browser, and you need a score strictly above 80% to pass. The questions are a real, reviewed bank for this course, drawn fresh for each attempt.

Is it only multiple choice?

Yes. This is a multiple-choice knowledge assessment, with at least one question from each chapter in every attempt. Written exercises are separate practice and are not automatically scored. Passing does not establish practical professional competence or independently verify identity.

Is there a time limit?

Yes, 45 minutes, shown as a countdown once you start. If time runs out, whatever you have answered is submitted automatically.

Do I need to download the PDF first?

No. This course's full text is on its own page, so you can read it online and come straight here when you feel ready.

What do you do with my name and email?

We privately record your name, email, request IP, course and privacy acknowledgement for this request. Newsletter consent is separate and optional. See /privacy.html for storage and retention. A passed exam creates a server-stored named certificate. An email confirmation is not identity assurance.

Can I retake it if I fail?

Yes, straight away. Each attempt draws a fresh set of questions and shuffles the answer order, so it will not be identical to your last attempt, and an attempt can only be submitted once.

Is the certificate real?

It is a genuine, server-issued certificate with its own verification page and a unique ID, not a self-declared one. It records that you passed this course's exam on this date. It is not an accredited qualification, a professional licence or proof of employment.