shop_closed

import csv
import datetime

def main():
    file = open("SqlDataset.csv")
    current = datetime.date.today()
    testdate = datetime.date(2021,9,18)
    csvreader = csv.reader(file)
    header = next(csvreader)

    count = 0
    shop_ids = []
    rows = []
    #Get all shop ids
    for row in csvreader:
        rows.append(row)
        if(int(row[0]) not in shop_ids):
            shop_ids.append(int(row[0]))

    for shop in shop_ids:
        for row in rows:
            if(row[1]=="clsd" and row[0] == shop):
                lower_range = datetime.date(int(row[2][0:4]), int(row[2][5:7]),int(row[2][8:]))
                upper_range = current
                if(row[3] != "NULL"):
                    upper_range = datetime.date(int(row[3][0:4]), int(row[3][5:7]),int(row[3][8:]))
                if(testdate >= lower_range and testdate <= upper_range):
                    difference = upper_range - testdate
                    if(difference.days > 30):
                        count += 1
    file.close()
    print(count)
main()