First, a little import:

import csv
from html import escape
import io

      

        
        
        
      

    

Now the building blocks - let's make one function to read CSV and another function to create HTML table:

def read_csv(path, column_names):
    with open(path, newline='') as f:
        # why newline='': see footnote at the end of https://docs.python.org/3/library/csv.html
        reader = csv.reader(f)
        for row in reader:
            record = {name: value for name, value in zip(column_names, row)}
            yield record

def html_table(records):
    # records is expected to be a list of dicts
    column_names = []
    # first detect all posible keys (field names) that are present in records
    for record in records:
        for name in record.keys():
            if name not in column_names:
                column_names.append(name)
    # create the HTML line by line
    lines = []
    lines.append('<table>\n')
    lines.append('  <tr>\n')
    for name in column_names:
        lines.append('    <th>{}</th>\n'.format(escape(name)))
    lines.append('  </tr>\n')
    for record in records:
        lines.append('  <tr>\n')
        for name in column_names:
            value = record.get(name, '')
            lines.append('    <td>{}</td>\n'.format(escape(value)))
        lines.append('  </tr>\n')
    lines.append('</table>')
    # join the lines to a single string and return it
    return ''.join(lines)

      

        
        
        
      

    

Now just put it together :)

records = list(read_csv('Crushers.csv', 'age week opp ACscr OPPscr location'.split()))

# Print first record to see whether we are loading correctly
print(records[0])
# Output:
# {'age': 'U13', 'week': '1', 'opp': 'Waterford', 'ACscr': '22', 'OPPscr': '36', 'location': 'Home'}

records = [r for r in records if r['age'] == 'U12']

print(html_table(records))
# Output:
# <table>
#   <tr>
#     <th>age</th>
#     <th>week</th>
#     <th>opp</th>
#     <th>ACscr</th>
#     <th>OPPscr</th>
#     <th>location</th>
#   </tr>
#   <tr>
#     <td>U12</td>
#     <td>1</td>
#     <td>Waterford</td>
#     <td>0</td>
#     <td>4</td>
#     <td>Home</td>
#   </tr>
#   <tr>
#     <td>U12</td>
#     <td>2</td>
#     <td>North Lakes</td>
#     <td>12</td>
#     <td>18</td>
#     <td>Away</td>
#   </tr>
#   ...
# </table>

      

        
        
        
      

    

A few notes:

• csv.reader
  
  works better than splitting strings because it also handles quoted values ​​and even quoted values ​​with newlines

• html.escape
  
  used to escape strings that may contain characters <
  
  or>
  
  

• it is often much easier to deal with dictation than with tuples

• usually CSV files contain a header (first row with column names) and can be easily loaded with ; but does not have a header (data starts from the very first line), so we ourselves in the function csv.DictReader

Crushers.csv

read_csv

read_csv
  
  

• Both functions read_csv
  
  and are html_table
  
  generic, so they can work on any data, the column names in them are not "hardcoded"

• yes you could have used pandas and instead :) But it's good to know how to do it without pandas if you need some customization. Or just as a programming exercise. to_html

read_csv

to_html