Minor update to BW test page

Work towards lhcb-dpa/project#268. Link to lhcb-core/LHCbPR2HD!264 (merged). The updated webpages can be previewed here:

• hlt2 example
• spruce example

Addressing the following comments from @erodrigu :

Can we get a header with the slot and date, which identifies the thing, so say "Slot lhcb-head, 2023-08-15" or similar?

Now the start and end times are posted to the page so that one could know how long does the test take.

The really useful table contains lines such as

| 6.717 | 11.75475 | 38.215658 | 0.449216 | 32.157306 | 0.378001 |
|-------|----------|-----------|----------|-----------|----------|

We should really round those numbers to get something meaningful ;-).

Now all numbers in tables are rounded with 3 significant digits (some are 2 because the last digit is zero).

The table gives bandwidth in GB/s (good) but then the plots down in the page rather use MB/s. Better use GB/s everywhere (also in what gets posted via the GitLab bot, BTW).

Now use GB/s everywhere, also for the Gitlab feedback of the Sprucing throughput test. The x-axis of the BW plots now ranges in (-4. 0) (BW numbers are 0.x in terms of GB/s).

Use "s" for the unit of wall time, not "Sec". Again for consistency.

Done

Some other comments are already addressed before, some are not addressed yet and I put them in the description of the issue.

cc @rjhunter @lugrazet @nskidmor @abertoli

python/MooreTests/combine_rate_output.py

@@ -41,6 +41,20 @@ def _columns_per_line():
     }
 
 
+columns_to_format_stream = [
+    'Total Retention (%)', 'Rate (kHz)', 'Avg Total Event Size (kB)',
+    'Total Bandwidth (GB/s)', 'Avg DstData Size (kB)',
+    'DstData Bandwidth (GB/s)'
+]
+
+columns_to_format_line = [
+    'Total Retention (%)', 'Rate (kHz)', 'Exclusive Retention(%)',
+    'Exclusive Rate (kHz)', 'Avg Total Event Size (kB)',
+    'Total Bandwidth (GB/s)', 'Avg DstData Size (kB)',
+    'DstData Bandwidth (GB/s)'
+]
+
+
 def _sorted_df_by_retention(df):
     return df.sort_values(
         by=['Total Retention (%)'], ascending=False).reset_index(drop=True)
@@ -79,7 +93,9 @@ def rates_all_lines(stream_config, fname_helper):
                 styler = df.style.applymap(
                     highlight_vals, subset=[column], threshold=threshold)
 
-    html = styler.set_table_attributes("border=1").to_html()
+    html = styler.format(
+        '{:.3g}', subset=df.columns[df.columns!='Line']).set_table_attributes(
+            "border=1").to_html()
     with open(fname_helper.final_rate_table_all_lines_path("html"), 'w') as f:
         f.write(html)
 
@@ -115,7 +131,9 @@ def make_rate_table_row_per_line(stream_config, fname_helper):
             df = pd.read_csv(file, header=None)
             df.columns = _columns_per_line().keys()
             df = _sorted_df_by_retention(df)
-            f.write(df.to_html())
+            f.write(
+                df.style.format('{:.3g}', subset=df.columns[df.columns!='Line']).
+                set_table_attributes("border=1").to_html())
             f.write('</a>')
             f.write('<br/><br/>')
 
@@ -143,7 +161,9 @@ def make_rate_table_row_per_stream(stream_config, fname_helper):
         fname_helper.final_rate_table_all_streams_path(
             stream_config, ext="csv"))
 
-    html = df.to_html()
+    html = df.style.format(
+        '{:.3g}', subset=df.columns[df.columns!='Stream']).set_table_attributes(
+            "border=1").to_html()
     with open(
             fname_helper.final_rate_table_all_streams_path(
                 stream_config, ext="html"), 'w') as f: