Skip to content

Latest commit

 

History

History
38 lines (27 loc) · 2.29 KB

README.md

File metadata and controls

38 lines (27 loc) · 2.29 KB
Raw

Taipei-City-Fire-Department-Data-Processing

This is the code work fully composed by Ting-Wei Wu to support and accelerate taipei city fire department information analysis

1. Excel VBA work for weekly and monthly report analysis

  • month_fire_event_depart_time_analysis.txt: Calculate the average departure time for every fire divisions in Taipei City monthly.
  • month_service.txt: Analysis of different public service such as snake, bee capturing etc monthly.
  • week_fire_event_analysis.txt: Analysis of fire events and phone calls analysis.
  • week_fire_post.txt: Analysis of public service associated with fire events weekly.

2. day folder: python scraping with selenium:

  • Use day.ipynb or daily-event-processing.ipynb to do online scraping from fire department database every day. Record every event's time, divisions, and event contents.
  • Import utils.py for weekday processing; Import utils-weekend.py for weekend processing.

3. week folder: python downloads with selenium and os:

  • Automatically download excel files and file manipulation in os for excel vba work.
  • Scrape the service event of fire divisions by cell phone call for the satisfaction survey purposes.

4. month folder: python scraping with selenium:

  • Use month.ipynb to record monthly fire rescue events with dispatch, travel and arrival time for tracking and improvements.

5. rescue folder: python scraping with selenium:

  • Manage daily event departure time calculation of each divisions for rescue events.

6. html_scraping folder: python scraping with selenium:

  • Consecutive Checking with availability of url links on Taipei City Fire Department homepage and subpages.

7. disable folder: python pandas and selenium:

  • Automatically input all information of people with disability into the personnel database.

8. weather_analysis folder: python pandas

  • Data processing to find relations between weather condition and personal refusal to hospital delivery when rescued.

9. locate folder: python pandas and selenium

  • Automatic validation for vague city address collected in dispatch system by searching on website of Taipei City Department of Civil Affairs.