Data Integration Project: XML, CSV, and Geolocation for Clinic Data

This project focuses on the integration of data from XML and CSV files to locate clinic data. The project utilizes Python, including the use of the petl package for ETL pipelines to clean and merge data. The system includes data cleaning, RESTful web services, and mashups to provide a user interface for searching clinic locations using geolocation. The solution involves converting XML to CSV, merging the files, and implementing a search function to find clinic addresses. The implementation uses Python scripts and integrates the data to display clinic locations on a map. The project's core components are data cleaning and merging, the use of RESTful web services for data communication, and mashups for combining data from multiple sources. The project demonstrates the practical application of data integration techniques, showcasing how to combine disparate data sources to create a functional system for locating clinic services. The report includes detailed code explanations and running instructions, along with figures illustrating the merging process, RESTful web services, and the search interface.