check_pe_csv.py

#!/usr/bin/env python
"""
Creates a list of hosts from a CSV export of nodes

Usage: ./check_pe_csv path/to/csvfile
"""
import csv
import os
import sys

E_OK = 0

def main(csvfilename):

    with open(csvfilename) as cf:
        has_header = csv.Sniffer().has_header(cf.read(1024))
        cf.seek(0)

        reader = csv.reader(cf, delimiter=',', quotechar='"')
        if has_header: next(reader)

        hosts = sorted(set(map(lambda row: row[0], reader)))

    sys.stdout.write(os.linesep.join(hosts))
    sys.stdout.write(os.linesep)
    return E_OK

if __name__ == '__main__':
    exit(main(sys.argv[1]))