import googlemaps
from datetime import datetime

gmaps = googlemaps.Client(key='VLASTNI_API_KEY')

fromP="Purkyňova 115"
now = datetime(2019, 9, 9, 17, 0)

results=[]
N=0

with open("obce.csv") as f:
    for line_terminated in f:
        line = line_terminated.rstrip('\n')
        directions_result = gmaps.distance_matrix(line+", Jihomoravský kraj", fromP, mode="driving", departure_time=now, language="cs")
        #print(directions_result)
        N=N+1
        try:                                
            duration=directions_result['rows'][0]['elements'][0]['duration']
            distance=directions_result['rows'][0]['elements'][0]['distance']
            results.append({'from': line, 'to': fromP, 'duration': duration['text'], 'durationTime': duration['value'], 'distance': distance['text']})  
            #print(line + " to " + fromP + " is " + duration['text'])
        except:
            pass
        
        #if N == 5: break

#now = datetime.now()
#directions_result = gmaps.directions("Ořešínská", fromP, mode="transit", departure_time=now)
#print(directions_result)


newlist = sorted(results, key=lambda k: k['durationTime'])

print("To " + fromP + " from")

for res in newlist:
    #print(res['from'] + " it takes " + res["duration"])
    print("%s;%s;%s;%s;%s" % (res["from"], res["to"], res["duration"], res["durationTime"], res["distance"]))