Crime Analytics
![Crime Analytics](https://www.pangaeax.com/wp-content/uploads/2020/11/tingey-injury-law-firm-veNb0DDegzE-unsplash-scaled-1.jpg)
Alteryx helps you solve impossible problems!
Overview:
The data used here is downloaded from the free source entity regarding the crimes happening in UAE.
An additional Column was added: Gender (0-> Female, 1-> Male)
Business Challenge or Problem:
- Data Manipulation
- Prediction – What are the chances that the convict of the same gender will commit the same crime?
Working Solution:
Crime by Emirates- Input File
![](https://www.pangaeax.com/wp-content/uploads/2020/11/1-1-1024x480.png)
Types of Crime -Input File
![](https://www.pangaeax.com/wp-content/uploads/2020/11/2-2.png)
Each crime is allotted a score which helps in the calculation of black points
Emirates List -Input File
![](https://www.pangaeax.com/wp-content/uploads/2020/11/3-2.png)
Data Merging, Joining and Manipulation
![](https://www.pangaeax.com/wp-content/uploads/2020/11/4-1-1024x402.png)
- The input files have been merged together as it has the same format.
- The scores of emirate list and Type of crimes ae joined based on the keys-emirate and crime name respectively.
- Crime index- Denotes the number of black points which will be added to the account holder of the convict- is calculated by the value multiplied with the crime and emirate score and 100 to get the no of black points generated.
Prediction:
![](https://www.pangaeax.com/wp-content/uploads/2020/11/5.png)
Using boosted model,
The Target specified:
- Gender
Predictors specified:
- Type of crime
- Emirate
- Value and crime index
- Year
X predicts the % of chance of that gender committing the type of crime the next time.
![](https://www.pangaeax.com/wp-content/uploads/2020/11/6-1024x196.png)
For e.g., In the year 2000, a male committed crime against the firearms law in Abu Dhabi, and that led to 18 black points in his account. He is 51% likely to commit the same crime in future.
Get your data results fast and accelerate your business performance with the insights you need today.