1 import csv

     2 import re

     3 import math

     4 

     5 TC_RE = re.compile("(\d{2}) (\d{2}) (\d{2}) ?, ?(\d{2})")

     6 

     7 def conver_tc(tc_str):

     8     m = TC_RE.match(tc_str)

     9     if not m:

    10         return math.inf

    11     return int(m.group(1))*3600000 + int(m.group(2))*60000 + int(m.group(3)) * 1000 + int(m.group(4)) * 10

    12 

    13 if __name__ == "__main__":

    14     with open('timecodes_webinaire_fcpe.csv') as csvfilein, \

    15         open('timecodes_webinaire_fcpe_out.csv', 'w') as csvfileout:

    16         chap_reader = csv.DictReader(csvfilein, delimiter=';')

    17         chap_writer = csv.DictWriter(csvfileout, fieldnames=chap_reader.fieldnames, delimiter=';')

    18 

    19         chap_writer.writeheader()

    20         for row in chap_reader:

    21             if not row['START']:

    22                 next

    23             row['START'] = conver_tc(row['START'])

    24             row['END'] = conver_tc(row['END'])

    25             chap_writer.writerow(row)