A survey data cleaner

The problem

Clean a messy survey export with free-text answers, inconsistent categories, invalid dates and duplicates, and produce a tidy long table ready for analysis.

Requirements

Technologies

Step by step

  1. Profile the raw export: types, missing values and odd answers.
  2. Write the cleaning steps as functions and chain them with pipe.
  3. Reshape to long format and summarise each question.
  4. Write a cleaning log with the row count after each step.

Expected result

A tidy dataset and a cleaning log that explains every change.

How it is evaluated

Ways to improve it