Data Science - Combining Datasets

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

This lesson covers how to combine datasets, specifically,

• what we mean by combining datasets
• to add rows to a dataset by appending
• to add columns to a dataset by joining
• understand common types of joins

Lesson content,

A PowerPoint/PDF presentation, ‘Combining datasets’
Excel/PDF Question workbook on ‘Combining datasets’ (for learners)
Excel/PDF Answers workbook on ‘Combining datasets’ (for teachers)
Planning document with learning intentions and success criteria

For more information on the Data Science NPA, please see teachdata.science

If you have any questions or feedback please email lessons@effini.com

This lesson has been created by effini in partnership with The Data Lab.

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