Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Java CSV file help Input A file named bandwidth.csv , containing the Bandwidth information for a set of Network Interfaces. A Network Interface is identified

Java CSV file help

Input

  • A file named bandwidth.csv, containing the Bandwidth information for a set of Network Interfaces. A Network Interface is identified by the couple [server, network interface name]
  • A file named netbitrate.csv, containing the Network Bit Rate registered for the same set of Network Interfaces over a period. A Network Interface is identified by the couple [server, network interface name]

You are asked to develop a small procedure that, given the two CSV files, calculates the Network Bandwidth Utilization for every line in the netbitrate.csv file. The Network Bandwidth Utilization of an interface is calculated as the Network Bit Rate divided by its Bandwidth. The procedure needs to print the results on the standard output according to the following format:

Timestamp | Server | Network Interface | Network bit rate / Bandwidth

Hint: Please ensure that your solution considers floating point numbers

File: bandwidth.csv

Server, InterfaceName, Bandwidth

server1,eth0,10

server1,eth1,20

server2,eth0,10

File: netbitrate.csv

Timestamp, Server, InterfaceName, NetBitRate

2019-07-08 21:53:27,server1,eth1,100

2019-07-06 23:10:54,server1,eth0,200

2019-05-10 03:36:22,server2,eth0,150

2019-01-14 13:14:51,server2,eth0,50

2019-05-01 19:47:33,server1,eth1,80

output:

image text in transcribed

2019-07-08 21:53:27 serveri ethi 5.0 2019-07-06 23:10:54 serverl etho 20.0 2019-05-10 03:36:22 server2 etho 15.0 2019-01-14 13:14:51 server2 etho 5.0 2019-05-01 19:47:33 serverl ethi 4.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL For Data Science Data Cleaning Wrangling And Analytics With Relational Databases

Authors: Antonio Badia

1st Edition

3030575918, 978-3030575915

More Books

Students also viewed these Databases questions