Python Programming: Data Integration and Mashup

This Python programming assignment explores data integration techniques using XML and CSV files. It demonstrates the implementation of a RESTful web service to retrieve data from the merged file and utilizes a mashup approach to display store locations on a map using their identification numbers. The assignment includes code explanations, process descriptions, and a sample source code for reference.

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