Embedded Files
Datasets
Datasets
We began by choosing datasets that would provide a comprehensive view of crime across South Australia from 2010 to 2024 from South Australia Police, including:
South Australia Crime Data: detailing types of crimes by suburb, covering offenses like property damage and assaults.
Family and Domestic Violence Data: providing records on domestic violence
Geographic Data: location data (for instance zip code, geographical map).
Click here for the Code and Datasets
Our datasets: datasets1, datasets 2
Cleaning and Joining Data
Cleaning and Joining Data
Null values and irrelevant rows were removed to ensure data accuracy. Records missing coordinates, particularly those outside South Australia, were excluded.
Data Transformation: Dates were standardized and converted into fiscal quarters and four-year periods to observe long-term trends. Crime data was aggregated by region (SA3 and SA4 areas), suburb, and year.
Integration: Family and Domestic Violence data was merged with general crime data using common attributes, such as location and fiscal period, to create a unified dataset for comparative analysis.
Analytical Methods
Analytical Methods
Crime Rate Calculation
For each suburb, crime rates were calculated by normalizing offense counts to the population. Property offense rates and person offense rates were analyzed separately.
Trend Analysis: Offense rates were compared over four-year periods to identify trends in specific types of crimes (e.g., theft, property damage, serious assault).
Cross-Referencing with Domestic Violence Data: Domestic violence incidents were cross-referenced with general crime rates, with a particular focus on serious assault cases, to observe any correlation and its intensity across the suburbs.
Page updated
Report abuse