Incident Data Extraction and Analysis Tool:

• Tech Stack: Python, SQLite, Linux.
• GitHub URL: Project Link

Developed Python functions utilizing Python 3, SQL, regular expressions, and Linux command line tools for data extraction and reformatting from a CSV file hosted on a website.

Created functions to download incident data from police department website in the form of PDF files and extract fields such as Date/Time, Incident Number, Location, Nature, and Incident ORI.

Implemented SQLite database creation and data insertion functionalities, along with printing incident counts, to store and analyze the extracted data efficiently.