Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with open(tabelaEstatisticas, 'rU') as stat_csv, open(tabelaNomesAeroportos, 'rU') as dest_csv:
- stat_reader = list(csv.DictReader(stat_csv))
- dest_reader = list(csv.reader(dest_csv))
- id_dict = {elem['DEST_AIRPORT_ID']: [] for elem in stat_reader}
- pair_list = []
- graph = ([], [])
- for line in stat_reader:
- if line["ARR_DELAY_NEW"] != "":
- id_dict[line['DEST_AIRPORT_ID']].append(float(line["ARR_DELAY_NEW"]))
- for elem in id_dict:
- for linha in dest_reader:
- if linha[0] == elem:
- pair_list.append((linha[1].split(": ")[0], sum(id_dict[elem])/len(id_dict[elem])))
- print sorted(pair_list, key=lambda x: x[1])
- for i in sorted(pair_list, key=lambda x: x[1]):
- graph[0].append(i[0])
- graph[1].append(i[1])
- print graph
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement