import csv


fname = 'odoo100-access.log'
data_grp = {}
with open(fname, 'r') as f_access, open(fname + '.csv', 'wb') as f_access_csv:
    access_csv = csv.DictWriter(f_access_csv, fieldnames=[
        'request_time', 'upstream_response_time', 'remote_address'])
    access_csv.writeheader()
    for line in f_access:
        items = line.split(' ')
        times = items[-3:-1]
        try:
            request_time = float(times[0])
            upstream_response_time = float(times[1])
            assert request_time != 0
            assert upstream_response_time != 0
        except (ValueError, AssertionError) as exc:
            continue
        data = {
            'request_time': request_time,
            'upstream_response_time': upstream_response_time,
            'remote_address': items[0],
        }
        access_csv.writerow(data)