Syrup Postcode

01_postcode.py

#!/usr/bin/env python

import csv
import json
import requests

def get_postcode(loc):
    payload = {'q':loc}
    res = requests.get('https://api.poesis.kr/post/search.php', params=payload)
    result = res.json()
    return '+'.join([c['code6'] for c in result['results']])

with open('input.csv') as csvfile:
    datareader = csv.reader(csvfile, delimiter=',', quotechar='|')
    for row in datareader:
        print(','.join(row) + ',' + get_postcode(row[1]))

02_reduce.py

#!/usr/bin/env python

import csv

with open('results.csv') as csvfile:
    datareader = csv.reader(csvfile, delimiter=',', quotechar='|')
    for row in datareader:
        postcodes = ''
        if 2 < len(row):
            postcodes += row[2]
        if 3 < len(row):
            postcodes += row[3]
        if 4 < len(row):
            postcodes += row[4]
        postcodes = reduce(lambda x, y: x if y in x else x + [y], postcodes.split('+'), [])
        print(row[0] + ',' + row[1] + ',' + '+'.join(postcodes))

input.csv

result.csv