ip_per_tenant.py

#!/usr/bin/env python

import pprint

f = open('./foo', 'r')

counts = {}
for line in f.readlines():
    tenant_id = line.split('|')[3].strip()
    if line.split('|')[3].strip() not in counts.keys():
        counts[tenant_id] = {'public_ips': 0,
                             'vms': 0}

    counts[tenant_id]['vms'] = counts[tenant_id]['vms'] + 1
    if ' 67.' in line.split('|')[7] or ' 173.' in line.split('|')[7] or ' 208.' in line.split('|')[7]:
        counts[tenant_id]['public_ips'] = counts[tenant_id]['public_ips'] + 1

pp = pprint.PrettyPrinter(depth=6)

pp.pprint(counts)