all_banks_ips/get_ips.py

import socket
from tempfile import NamedTemporaryFile
import shutil
import csv


def get_ips(row):
    try:
        addrs = list(set([str(i[4][0]) for i in socket.getaddrinfo(row[0], row[1], socket.AF_INET)]))
        print row[0] + ' has ips: ' + ','.join(addrs)
        if len(row) == 3:
            row.append(addrs)
        elif len(row) == 4:
            row[3] = addrs
    except:
        if len(row) == 3:
            row.append('')
    finally:
        return row


filename = 'acs_url.csv'
tempfile = NamedTemporaryFile(delete=False)

with open(filename, 'rb') as csvFile, tempfile:
    reader = csv.reader(csvFile, delimiter=',', quotechar='"')
    writer = csv.writer(tempfile, delimiter=',', quoting=csv.QUOTE_ALL)
    for row in reader:
        writer.writerow(get_ips(row))

shutil.move(tempfile.name, filename)