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 itertools

# 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'), quoting=csv.QUOTE_NONNUMERIC)
csv_writer.writerow(["Source", "Target", "Weight"])

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