02 - Bar clusters plot Smart index vs Crime index

Timestamp

12/01/2024

Data Source

• Smart City Dataset: This Kaggle-sourced dataset focuses on the integration of IoT sensors and advanced technologies in urban hubs, shaping the future of data and automation in city living.
• Crime Dataset: Derived from Eurostat's EU-SILC, this dataset details the occurrence of crime, violence, or vandalism across various urbanization settings, providing valuable insights into safety and security trends.

Datasets

• Smart city dataset
• Crime score dataset
• Download the final dataset

Protocol

1. Merged the two datasets
2. Eliminated unnecessary columns
3. Added a new column "Part of Europe"
4. Indexes average performed between the city of the same country and kept only the capital (if present otherwise one of the biggest).
5. Normalized smart score values and crime index values with a minmax scaler
6. Graph settings:
   • x_axis : Country
   • y_axis : Smart_Mobility,Smart_Environment,Smart_Government,Smart_Economy,Smart_People,Smart_Living,SmartCity_Index,crime_index
   • filter : Part of Europe
7. Divided the graph in 4 quadrants to enhance some patterns in the data.