import csv
import re
#import time

with open('resDataset.csv', 'r') as csv_f:
    csv_r = csv.reader(csv_f)

    p1 = re.compile(r'(.*?)Singapore [0-9]{6,6}')
    p2 = re.compile(r'(·){2,2}.+')

    next(csv_r)

    with open('editedR.csv', 'w', newline='') as csv_f2:
        writer = csv.writer(csv_f2)
        writer.writerow(['ResName','Rating','Address','GoodFor','Time','Price'])

        for line in csv_r:
            m1 = p1.match(line[2])
            n_addr = m1.group()
            print(n_addr)

            m2 = p2.match(line[5])
            n_price = m2.group()
            print(n_price)

            writer.writerow([line[0], line[1], n_addr, line[3], line[4], n_price])


    csv_f2.close()
csv_f.close()