The export that went wrong
A club leader exports a list to send to the trip company. The file has repeated rows, a column of home phone numbers nobody asked for, and a comma that split one name in two.
Moving data is simple. Moving it well takes care.
Key words
| Word | What it means |
|---|---|
| Import | read data from a file into a system |
| Export | save data out of a system as a file |
| Redundant data | data that is repeated or not needed |
| Delimiter | the mark that splits values in a file, such as a comma |
| Data minimisation | sharing only the data that is needed |
| Personal data | data about a living person who can be identified |
The cells students fill in are left blank in this preview.
By the end of this lesson
Note
I can import and export data in a standard form and keep it within the law.
Starter
Have a go
Starter
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.
Review, then standardise for the move
First review the data. What does it hold? Who owns it? What must the receiver get?
Then standardise it. Fix quality problems. Use the format the receiver expects. Remove redundant data: repeated rows and columns nobody needs.
Try it: remove the redundant data
select distinct pupil_id, name, form, note
from pupil_export
order by pupil_id;
-- Repeated Ada is gone. The phone column was left out on purpose.
Check
Have a go
Check
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.