Project Overview:
Developed a Python application to search and display information about abandoned mines in Ontario based on user-specified search criteria. The program prompts the user to search by element or location and retrieves relevant information from GeologyOntario’s AMIS database.
Key Tasks and Accomplishments:
Excel Data Loading and Error Handling
- Implemented a function to load data from an Excel file using the Pandas library with error handling for file loading issues.
User Interaction and Input Validation
- Prompted users to choose between searching by element or location.
- Implemented input validation to ensure correct user selections and confirmation of search criteria.
Data Filtering and Display
- Utilized pandas to search for user-defined elements or locations within the dataset.
- Displayed matching results and provided informative feedback when no matches were found.
Search Logic with Lambda Functions
- Applied lambda functions to dynamically filter rows based on search criteria.
- Ensured efficient data processing and accurate results using flexible search parameters.
Technologies & Tools Used:
- Python
- Pandas for data manipulation
- OpenPyXL for Excel file handling
- OS Module for file path management
Skills Demonstrated:
- Python Programming for Data Analysis
- Excel File Handling and Data Manipulation
- User Input Validation and Error Handling
- Data Filtering and Search Logic
- Application Design and Flow Control