Data Science - In Python, Practise data cleansing

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 5 and 6.

This lesson follows on from ‘Dataset cleansing in Python’ (part 1 & 2) and ‘Advanced data cleansing in Python’ (part 1 & 2) which are available from the effini TES shop.

This lesson allows learners to practise the skills covered in the Data Cleansing part of the analysis process in Python, specifically,

• how to rename variables
• how to drop unrequired rows and variables
• how to drop duplicates
• how to handle missing data and outliers

Lesson content,

A PowerPoint/PDF presentation, ‘Practise data cleansing in Python’
2 Jupyter notebooks:

‘practise_data_cleansing.ipynb’ (for learners)
‘practise_data_cleansing_with_answers.ipynb’ (for teachers)
Planning document with learning intentions and success criteria
For more information on the Data Science NPA, please see teachdata.science

This lesson has been created by effini in partnership with Data Education in Schools, The Data Lab and Data Skills for Work, with funding from the Scottish Government.

© 2022. This work is licensed under a CC BY-NC-SA 4.0 license.