Advertisement
Guest User

Untitled

a guest
May 24th, 2015
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. with open(tabelaEstatisticas, 'rU') as stat_csv, open(tabelaNomesAeroportos, 'rU') as dest_csv:
  2. stat_reader = list(csv.DictReader(stat_csv))
  3. dest_reader = list(csv.reader(dest_csv))
  4. id_dict = {elem['DEST_AIRPORT_ID']: [] for elem in stat_reader}
  5. pair_list = []
  6. graph = ([], [])
  7. for line in stat_reader:
  8. if line["ARR_DELAY_NEW"] != "":
  9. id_dict[line['DEST_AIRPORT_ID']].append(float(line["ARR_DELAY_NEW"]))
  10. for elem in id_dict:
  11. for linha in dest_reader:
  12. if linha[0] == elem:
  13. pair_list.append((linha[1].split(": ")[0], sum(id_dict[elem])/len(id_dict[elem])))
  14. print sorted(pair_list, key=lambda x: x[1])
  15. for i in sorted(pair_list, key=lambda x: x[1]):
  16. graph[0].append(i[0])
  17. graph[1].append(i[1])
  18. print graph
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement