Programming Problem 1
Data Engineering and Presentation
In this programming problem you will need to develop code which can read data from a given dataset, perform. some statistical analysis of the data and visualise the results of this analysis.
The datasets are provided in files targetA.csv and targetB.csv. Both files are on Moodle, in the section ‘Coursework’ .
These files contain data from network monitoring traffic from a real-time audio-video application. The data represents information on RTP (Real Time Protocol) packets – the actual meaning of each column in the dataset is given in the file data_description.pdf on the Moodle page.
Your task is to write python code that performs the following functions:
- The code should read the contents of both datasets and make these available in python data structures of your choice (list, dictionary, dataframe, numpy array…) [20%]
- The code should plot the following graphs, using the data in targetA.csv file: [20%]
. Graph1: sequence numbers overtime. In this graph time values (from column B) should be on the x-axis, and the sequence numbers should be on they-axis. The sequence numbers can be found in column G of the datasets.
. Graph2: probabilities of packet lengths. You will notice that packets listed in the targetA.csv file take one of a limited number of possible packet lengths (packet length is given in column F). For this graph you can create a scatterplot, use a bar chart, or use other standard plots. The x-axis should contain the possible packet lengths, and they-axis should contain the calculated probability of that particular packet length over the whole packet set.
- The code should calculate and print the following values, using the data in
targetA.csv file: the mean, the mode and the standard deviation of packet length [20%]
- The code should be able to plot the distribution of the packet lengths using the data in targetA.csv file – both the cumulative distribution function and the probability density function [20%]
- The code should calculate and plot the delay between each packet departure time at node A (time in column B in targetA.csv) and the arrival time at node B (time in column B in targetB.csv), OR vice versa (B→A). Each packet is uniquely identified by the sequence number, which is given in column G of each dataset, so the delay needs to be calculated by subtracting the arrival and departure times for eachpacket, where packet is uniquely identified by its sequence number. The packet delays should all be plotted on a single graph. [20%]
NOTE: You will notice that the two spreadsheets have different number or entries (rows).
Programming Problem 2
Development of a student database using Object Oriented Programming
This programming problem requires you to develop code for processing data for a group of students in a University class. The student ID numbers, student names, and home addresses for 10 students is available in document student_data.txt, which is available on the Moodle page.
Your code should read this file, extract the data from the file and should complete the following specification:
- the code should be able to read the .txt file and allocate the data from that file to objects. [10%]
- the code should be able to print any of the individual data for any of the students [10%]
- the code should be able to:
o add data for a new student,
o remove a student from the dataset,
o modify any data for any of the students in the data set.
All these options should be provided to the user of the program, via a simple menu. [20%]
- The code should be able to read separate data files gradesprogramming.txt and gradesdigital.txt where grades in a module for the students arestored and to store the grades in the main data file [20%]
- The code should be able to calculate the average grade from all module grades for each of the students [10%]
- The code should be able to plot the distribution of the grades for both modules –
both the cumulative distribution function and the probability density function [20%]
- The code should be able to store the entire with the grade modules in an external file - .txt, .csv, or any other file type can be used to do this. [10%]
NOTE: pleasedon’t use any database software to solve this problem. Object-oriented programming must be used for this problem, and if you wish you can use any python libraries for this.