I'm working on a word problem for some python homework, and I've been tasked with writing a script that is responsible for calculating the Network Bandwidth Utilization for every line in a csv file. At a high level, i'm curious to know if there is a universal calculation that is used to derive this value.
Now, to dive more specific into the data set I'm using to calculate the values from. There are two CSV files at hand, one is named 'bandwidth.csv' and the other is 'netbitrate.csv'. I've taken a screenshot of the files here: https://imgur.com/a/f6nvmot (they are very small files for the sake of this exercise, 6 & 20 lines each, respectively).
Additionally, I'll include the files below:
---bandwith.csv--- Server,InterfaceName,Bandwidth server1,eth0,20 server1,eth1,40 server2,eth0,80 server3,eth0,5 server3,eth1,10 server4,eth0,160
---netbitrate.csv--- Timestamp,Server,InterfaceName,NetBitRate 2019-05-07 19:17:23,server1,eth0,1000 2019-03-30 19:41:33,server4,eth0,200 2019-06-18 07:38:11,server1,eth0,100 2019-03-08 08:29:38,server3,eth1,80 2019-04-21 04:50:41,server3,eth1,500 2019-04-06 06:28:31,server4,eth0,660 2019-05-02 08:33:40,server1,eth1,1000 2019-06-06 06:02:10,server2,eth0,1000 2019-02-28 20:16:54,server4,eth0,1000 2019-04-05 23:57:00,server2,eth0,500 2019-04-21 23:31:19,server1,eth0,400 2019-06-24 09:49:58,server3,eth1,80 2019-04-04 10:34:24,server1,eth1,1000 2019-06-14 15:13:36,server2,eth0,660 2019-02-13 19:19:49,server4,eth0,800 2019-02-03 19:03:03,server4,eth0,1000 2019-01-07 00:49:05,server3,eth1,100 2019-05-08 13:14:21,server1,eth0,500 2019-03-23 23:36:03,server1,eth1,100 2019-02-06 14:44:09,server2,eth0,100 So now that you see the data I'm working with across these two files, my question is how should i go about crafting the calculation that would give me the Network Bandwidth Utilization for each line of the 'netbitrate.csv' file.
If you have any questions or would like me to clear anything up for you, please let me know!
cheers.
No comments:
Post a Comment