Search where people are moving in Germany

citysearch.py

# coding: utf-8

# requires: pattern http://www.clips.ua.ac.be/pages/pattern
from pattern.web import *
import csv
import sys

# yeah I know
reload(sys) 
sys.setdefaultencoding("utf-8")

# engine = Google(license='XXX', throttle=2.0)
#engine = Twitter(license=None)
engine = Bing()


phrase = '"von %s nach %s gezogen"'
cities = ["Berlin", "Hamburg", "München", "Köln", "Frankfurt am Main", "Stuttgart", "Düsseldorf", "Dortmund", "Essen", "Bremen", "Leipzig", "Dresden", "Hannover", "Nürnberg", "Duisburg", "Bochum", "Wuppertal", "Bonn", "Bielefeld", "Mannheim", "Karlsruhe", "Münster", "Wiesbaden", "Augsburg", "Aachen", "Mönchengladbach", "Gelsenkirchen", "Braunschweig", "Chemnitz", "Kiel"]

csv_writer = csv.writer(open("cities.csv", 'wb'), delimiter="\t", quoting=csv.QUOTE_NONNUMERIC)

csv_writer.writerow(["Source", "Target", "Weight"])

for i in cities:
	for j in cities:
		results = engine.search(phrase % (i,j), type=SEARCH)
		csv_writer.writerow([i, j, results.total])