Please complete the following two tasks and create a presentation.
Using the datasets in /data, map the ratio of UPRNs to the total sum of all crimes in November 2025 for Lewisham’s wards.
Calculate the correlation of total crime and 2025 Indices of Multiple Deprivation in London at LSOA level for November 2025.
In the presentation, you should: • Detail the methodology including the applications used • Present your results • Argue for or against this approach to mapping crimes • Suggest improvements
For Task 1, your presentation should show the following maps: • Count of UPRNs per ward • Count of crimes per ward • Ratio of UPRNs to crimes per ward
Additionally, you should present the following tables: • Counts of different types of crimes per ward • Ratios of UPRNs to different types of crimes per ward
For Task 2, it is up to you how you want to present the results, but a mapping element is expected.
• UPRN lookup dataset (November 2025): lewisham_uprn_lookup.csv • Lewisham ward boundaries (December 2025): ward boundaries folder • London LSOA boundaries (2021): lsoa boundaries folder • MPS crime data at LSOA level: MPS LSOA Level Crime (most recent 24 months).csv • MPS crime data at ward level: MPS Ward Level Crime (most recent 24 months).csv • 2025 Indices of Multiple Deprivation: File_1_IoD2025_Index_of_Multiple_Deprivation.xlsx