📊 Methodology
Data Sources:
• Flood Control Data: DPWH Flood Control Projects Database
• DIME Data: Department of Budget and Management - Digital Information for Monitoring and Evaluation
Analysis Process:
• Extracted top 50 contractors by number of flood control projects
• Used fuzzy string matching to find contractor names across databases (accounting for variations in naming conventions)
• Filtered DIME projects to exclude flood-related infrastructure to show diversification
• Calculated total project counts and budget allocations