affected_bentos.py

date_bentos = {}

""" format of csv being processed is 
Affected Bentos,Incident Date
app1a;app1b;app1c;app1d;app1e;app1f,3/18/2020
app1d,3/16/2020
app1a;app1b;app1c;app1d;app1f,3/17/2020
app1a;app1b;app1c;app1d;app1e;app1f;app2a;app2b,3/16/2020
app1c,3/13/2020
app1c,3/16/2020 
"""

with open("bento-date.csv", 'r') as file_in:
    i=0
    # line = app1a;app1b;app1c;app1d;app1e;app1f,3/18/2020
    for line in file_in:
        # skip csv header
        if i==0:
            i+=1 
            continue
        
        incident = line.split(',') # incident = ['app1a;app1b;app1c;app1d;app1e;app1f','3/18/2020']

        
        affected_bentos = incident[0].split(';') #affected_bentos = ['app1a','app1b',...'app1f']
        date = incident[1].replace('\n','') # date = 3/17/2020

        for bento in affected_bentos:
            print(date+","+bento)