File size: 2,277 Bytes
eb51ab4
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73

================================================================================
DATA PREPROCESSING REPORT
Generated: 2025-12-13 05:37:32
================================================================================

INPUT FILES:
-----------
βœ“ resourceoptimization23.csv β†’ 30 districts loaded
βœ“ equipment_dataset.csv β†’ 36 equipment types loaded

OUTPUT FILES:
------------
βœ“ districts_master.csv β†’ 30 rows Γ— 22 columns
βœ“ equipment_inventory.csv β†’ 36 rows

COMPUTED FEATURES:
-----------------
βœ“ Latitude & Longitude (geographic coordinates)
βœ“ Infrastructure_Score (0-1 scale)
βœ“ Vulnerability_Index (0-1 scale)  
βœ“ Historical_Risk_Score (0-1 scale)
βœ“ Population_Exposure_Index (0-1 scale)
βœ“ Is_Coastal (binary flag)
βœ“ SDRF_Utilization_Rate

DATA QUALITY:
------------
βœ“ Missing values: Handled
βœ“ Duplicates: Removed (0 found)
βœ“ Data types: Validated
βœ“ Coordinates: All 30 districts mapped

DISTRICT STATISTICS:
-------------------
β€’ Coastal districts: 8
β€’ Inland districts: 22
β€’ High vulnerability districts: 1
β€’ Low infrastructure districts: 22

TOP 5 MOST VULNERABLE DISTRICTS:
-------------------------------
     District  Vulnerability_Index Flood_Zone
   Kendrapara                0.800 Flood Zone
       Ganjam                0.638 Flood Zone
     Balasore                0.625 Flood Zone
         Puri                0.600 Flood Zone
Jagatsinghpur                0.587 Flood Zone

TOP 5 BEST INFRASTRUCTURE:
-------------------------
  District  Infrastructure_Score  Cyclone_Shelters
   Cuttack                 0.993                80
    Ganjam                 0.946               100
      Puri                 0.920                95
   Khordha                 0.898                75
Kendrapara                 0.879               110

RESOURCE CONSTRAINTS (from equipment data):
------------------------------------------
β€’ Total shelters available: 814
β€’ Total equipment items: 132682
β€’ High priority equipment types: 19

NEXT STEPS:
----------
1. Use districts_master.csv in your API
2. Update ResourceOptimizer to load this file
3. Run optimization endpoint: POST /optimize/resources
4. Verify risk scores and allocations

================================================================================