How to Scrape Fire Bureau website via regular expression and importing the data into SQLite?
In the website of Fire Bureau of Taichung City Government, it is showing the real-time reporting cases with the info such as location, time, and status. In this session, we are going to study on how to gran this information via Python and store the data into the database of SQLite.
Target Website:
Tool:
- Python
- SQLite
Steps
- Go through the structure of website: When you inspect the website, you can see the information of case located in the tag of <tr>.
2. I am designing a pattern based on the regular expression to extract the key elements.
