combine tables

[joelsmit]

I need your help in creating a table; I have 2 tables that show an average of 5 minutes, one of throughput and another of # of IOPS (operations per second).

time throughput [KB/s]
==================================
11:25:27 - 11:30:27 20180
11:30:27 - 11:35:27 31130
11:35:27 - 11:40:27 24189

time IOPS
=================
11:25:31 - 11:30:31 121
11:30:31 - 11:35:31 142
11:35:31 - 11:40:31 117

I want to combine those two in order to calculate the average OP size. However, the time is off by a few seconds
Therefore, I would like to get rid of the seconds and get just hour and minutes into the table

it needs to do the following:

A. get rid of the seconds
B. put all 3 columns in one table
C. add a 4th column that will divide throughput by IOPS to get the OP size

end result


time IOPS throughput[KB/s] OP_size[KB]
===============================================
11:25 - 11:30 121 20180 167
11:30 - 11:35 142 31130 219
11:35 - 11:40 117 24189 207

Any input would be highly appreciated

[BashBedlam]

Can we assume that we are starting off with the data in neat little lists like this:

iops = [
	['11:25:31', '11:30:31', 121],
	['11:30:31', '11:35:31', 142],
	['11:35:31', '11:40:31', 117]]

or are we reading the information from a file? Or....?