get_brand_master.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#

import sys,os,re
import time,datetime
import json,msgpack,yaml,csv
from pprint import pprint
import argparse
import dateutil.parser

from bs4 import BeautifulSoup
import urllib
from urllib2 import Request, urlopen, URLError, HTTPError
from pprint import pprint

def get_result(url):
    fp = urlopen(url); contents = fp.read(); fp.close();
    return contents

# params
api_key = "XXXXXX" # https://webservice.recruit.co.jp/register/index.html よりAPI KEY を取得して下さい。

# url info
base_url = "http://webservice.recruit.co.jp/carsensor/brand/v1/?key=%s&format=json"%(api_key)

##### main #####
res =  json.loads(get_result(base_url))
main = res["results"]["brand"]

filename = "brand_master.csv"
writecsv = csv.writer(file(filename, 'w'), lineterminator='\n')
writecsv.writerow(["country", "country_code", "name", "code"])

for jsn in main:
    country_name = jsn["country"]["name"]
    country_code = jsn["country"]["code"]
    name = jsn["name"]
    code = jsn["code"]
    writecsv.writerow([country_name.encode('utf-8'), country_code.encode('utf-8'), name.encode('utf-8'), code.encode('utf-8')])