Data Cleaning Exercises

Glossary

Pivot

Turning rows (entity, month, value) into one row per entity with a column per month.

Absent cells must stay missing; reported zeros stay 0. Declare the output columns and stop if a cell would receive two values.

Related: Row grain, Missing value (null)