Data Integration and Web Application Development in Python

Desklib provides solved assignments and past papers for students.

ICT 705

Table of Contents
Introduction.................................................................................................................................................3
Executive Summery.....................................................................................................................................4
Data & System integration component.......................................................................................................5
Screenshots.................................................................................................................................................7
Conclusion...................................................................................................................................................9
References...................................................................................................................................................9
Figure 1: read data......................................................................................................................................5
Figure 2: data cleaning................................................................................................................................6
Figure 3: data merging.................................................................................................................................6
Figure 4: REST API link.................................................................................................................................7
Figure 5: JSON data.....................................................................................................................................7
Figure 6: MAP UI..........................................................................................................................................7
Figure 7: Taking input from the user...........................................................................................................8
Figure 8: Displaying result...........................................................................................................................8

Introduction
This work is based on the implementation of the system and data integration and there are
several things that need to create and develop in this assignment. The programming language
which is used in this assignment is Python programming language. In the implementation of the
data and the system integration the Python programming language is the most important
language. In the execution of the data science the python programming language is the most
widely used programming language and this is to complete this data and system integration the
python programming language is used.

Executive Summery
This is a Python programming based assignment. There is several data source files are given in
this assignment brief and the developer need to read each and every data source files. In this
assignment the framework which is used is bottle. This is a web based application where two
input fields are given and the user has to enter the postal code and the type of services and
whenever the user will click on the find button then in the map that available office will be
display. There are one of the main functionality has been implemented which is map
integration.

Data & System integration component
There are basic three steps that need to be follow in order to complete the implementation of
the data and the system integration. One of the most and the first process is data reading and
second step is data cleaning and last but not the lease is data merging.
Data Read:
This is the first step of the data and the system integration. In the implementation of this
Python based programming language there are several CSV files are available and that files
need to be read by using the Python code.
Figure 1: read data
Data Clean:
This is the second step of the data and system integration. After reading the data the next step
is to remove the duplicate data from the data source files. If any duplicate entry found in the
data source file than the error will be generate.

Figure 2: data cleaning
Data Merging
This is the final step in the operation of the data and system integration. After removing each
and every duplicate entry the next step is to merge all data source files to read the data in a
very efficient way. There are data_integration.py file is created in this program.
Figure 3: data merging

Web Services:
The framework which is used to create this application is bottle and in the implementation of
the web based application the REST API has been successfully implemented. The port which is
used 8181 and each and everything will be run over this port.
Screenshots
Figure 4: REST API link
Figure 5: JSON data
Figure 6: MAP UI

Figure 7: Taking input from the user
Figure 8: Displaying result

Conclusion
The web based application has been successfully implemented and the program is successfully
working. There are several things that is implemented such as bottle framework, REST API and
many more. The server port is 8181 and the screenshots also enclosed to view the working of
the web based application.
References
 Rahm, E. and Do, H.H., 2000. Data cleaning: Problems and current approaches. IEEE
Data Eng. Bull., 23(4), pp.3-13.
 Lamburt, L., Koyfman, L. and Ponte, J., Verizon Laboratories Inc, 2002. Data merging
techniques. U.S. Patent 6,374,241.
 King, W.P., Kenny, T.W., Goodson, K.E., Cross, G., Despont, M., Dürig, U., Rothuizen,
H., Binnig, G.K. and Vettiger, P., 2001. Atomic force microscope cantilevers for
combined thermomechanical data writing and reading. Applied Physics Letters, 78(9),
pp.1300-1302.