# for i in sheet_data: # i['iataCode'] = (search.iata_check(i)) #print(sheet_data[0]['city']) # # for i in sheet_data: # data.put(i) # for i in sheet_data: # i['iataCode'] = search.iata_check(i) # # pprint(sheet_data) # # for i in sheet_data: # data.put(i) for i in sheet_data: flight_data = flight.flight_get(i) flight_price = flight_data['data'][0]['price'] sheet_price = i['lowestPrice'] flight_from_city = flight_data['data'][0]['cityCodeFrom'] flight_from_airport = flight_data['data'][0]['flyFrom'] flight_to_city = flight_data['data'][0]['cityCodeTo'] flight_to_airport = flight_data['data'][0]['flyTo'] flight_route = flight_data['data'][0]['route'] flight_outbound_date = flight_route[0]['local_departure'].split('T')[0] flight_inbound_date = flight_route[len(flight_route) - 1]['local_departure'].split('T')[0]