Data Integration Project: Python Implementation, Analysis, and Results

This project delves into data integration using Python, encompassing the merging of XML and CSV files. The project includes implementation of Restful Web Services to handle the data, and the use of mash ups to find the exact location of the store. The assignment uses python code for data integration and implementation of Restful Web Services. The project involves the parsing of XML data, merging it with CSV data, and creating a data structure. The project also includes the implementation of the store location which is retrieved from the XML and CSV files. The project also includes the use of map, to find the exact location of the store by its identification number. The code is designed to merge data, create a restful web service and display the store location using mash ups. The code also includes the explanation of the code and the implementation. The project provides a comprehensive overview of data integration techniques and their practical applications.

Programming Other-Python

Table of Contents
1. Code Explanation for data integration............................................................................................1
2. Restful Web Service explanation......................................................................................................2
3. Explanation of Mash up....................................................................................................................3
1. Code Explanation for data integration
1

Data merger can be used to merge, the xml and csv files. Using python, we merge the both
files, they are xml and csv files. To merge xml and csv, import element tree type, this type is an
object. This type is used for storing data structures. Xml file is parse. Here xml document is
taken as “store.xml”. Since, this element tree type is not secure against malicious information,
we have to parse the xml document. Element tree represents full xml document as the tree and an
element as a single node in the tree. Xml is passed into an element which is consider as root
element of the parsed tree. It also has the children nodes, which we can iterate. The xml file
contains list of data. We use if condition for selecting a specific data from the xml file. By
getting identification number for all the data the respective names and details of the
corresponding number will be printed.
Then we need to open the csv file named as “locations” which is taken as score file. By using
the score file reader we read the content of the location file. The location of the specified code is
displayed.
Process of merging
Implementation of data integration
Source code is attached here
2

2. Restful Web Service explanation
Restful web services deals with the output data source document. This source document is
produced from the data merging process. The output file Store_location.csv is obtained from
merging process. This csv file is recovered using python and it is named Store_location.phy. this
process recovers the information of the store location file.
Implementation of restful web services
3. Explanation of Mash up
This is used in finding the exact location of the store. Location can be found using map, once
we search with its id.
The details of the store details will be displayed when identification number is specified.
3

Location of the store direction is displayed
Implementation of mash up
4