#!/usr/bin/python
import re

text_file = open("out.log.txt", "r")
log = text_file.read()
text_file.close()

rate = []
time = []

pat_rate = re.compile(r'Avg. requests/s: (?P<rate1>[0-9,\.]+) OK, (?P<rate2>[0-9,\.]+) Total')
pat_time = re.compile(r'Stats collected in (?P<time1>[0-9,\.]+) seconds')

for line in log.splitlines():
    res = pat_rate.search(line)
    if res is not None:
        rate.append(res.groups('rate1')[0])
print(rate)

for line in log.splitlines():
    res = pat_time.search(line)
    if res is not None:
        time.append(res.groups('time1')[0])
print(time)

text_file = open("rates.csv", "w")
text_file.write('Add,Delete\n')
text_file.write('{0},{1}\n'.format(rate[0], rate[1]))
text_file.close()

text_file = open("times.csv", "w")
text_file.write('Add,Delete\n')
text_file.write('{0},{1}\n'.format(time[0], time[1]))
text_file.close()