How Python And Selenium Are Used To Scrape Flight Prices?

1. How Python And Selenium Are Used To Scrape Flight Prices? In this blog, we will try to understand how to use Selenium and ChromeDriver to scrape Expedia airfare prices. Here, we will scrape Expedia data, one of the known and biggest Online Travel Agencies (OTA) in the world. You will require Python 3.5 version to scrape flight prices using Python. Selenium package: a well-known web browser automation package ChromeDriver: enables users to use a browser and carry out tasks. pandas package DateTime package Scraping Policy

2. Before we get to start with the Python script, let's have a look at the scraping strategy: Enter The Routes And Dates You Wish To Scrape Into A CSV File. You May Add As  Many Routes As You Like, But You Must Use The Names Of The Columns. Only Roundtrips Are Supported By The Scraper. Execute The Entire Code  Each Flight's Output Is A CSV File. The Date And Time Of The Scraping Will Be The  Name Of The File. The Scraper Will Automatically Identify All Flights On The Same Path And Place  Them In The Relevant Folder (The Name Of The Route). These would be the scraped routes as stated in the CSV file (the scraper automatically builds those folders):

3. Here, you can search various scraped information for Athens- Abu Dhabi routes: Each scrape sample for the Athens — Abu Dhabi route is represented by a single CSV file in the screenshot below. Its title is a representation of the scraper's execution date and time. Data Fields

4. The flight scraper will help you scrape the following data fields from Departure Time  Arrival Time  Duration  Airline  Layovers  Airplane Type  Arrival Airport Name  Price  Departure Coach  The Exact Time Of Scraping  Stops  If the flight isn't direct, the scraper will provide you with further information for every connection. Script To begin, import the necessary libraries, specify the chrome driver, and choose the round- trip type, as normal. # Selenuim imports from selenium import webdriver from selenium.webdriver.common.by import By from selenium.webdriver.common.keys import Keys import selenium.common.exceptions as selexcept # Pandas imports using Pandas for structuring our data

5. import pandas as pd from datetime import datetime import os.path import re import sys import glob # Time and date-time (mainly for using delays between clicks) import time # Change this to your own chromedriver path! chromedriver_path = 'Insert your own path' # This will open the Chrome window browser = webdriver.Chrome(executable_path=chromedriver_path) # Setting Round Trip type path return_ticket = "//label[@id='flight-type-roundtrip-label-hp-flight']" In the subsequent steps, you'll use Selenium tools to construct a few functions to find specific characteristics on the webpage. The titles of the functions suggest what they do. def ticket_chooser(ticket): try: ticket_type = browser.find_element_by_xpath(ticket) ticket_type.click() except Exception as e: pass def more_details(details): try:

6. details_type = browser.find_element_by_xpath(details) details_type.click() except Exception as e: pass def dep_country_chooser(dep_country): hp-flight']") fly_from = browser.find_element_by_xpath("//input[@id='flight-origin- time.sleep(3) fly_from.clear() time.sleep(3) fly_from.send_keys(' ' + dep_country) time.sleep(3) ) first_item = browser.find_element_by_xpath("//a[@id='aria-option-0']" time.sleep(3) first_item.click() def arrival_country_chooser(arrival_country): on-hp-flight']") fly_to = browser.find_element_by_xpath("//input[@id='flight-destinati time.sleep(3) fly_to.clear() time.sleep(3) fly_to.send_keys(' ' + arrival_country) time.sleep(3) ) first_item = browser.find_element_by_xpath("//a[@id='aria-option-0']" time.sleep(3) first_item.click() def dep_date_chooser(month, day, year): departing-hp-flight']") dep_date_button = browser.find_element_by_xpath("//input[@id='flight- dep_date_button.clear()

7. r)) dep_date_button.send_keys(str(month) + "/" + str(day) + "/" + str(yea def return_date_chooser(month, day, year): ht-returning-hp-flight']") return_date_button = browser.find_element_by_xpath("//input[@id='flig for i in range(11): return_date_button.send_keys(Keys.BACKSPACE) year)) return_date_button.send_keys(str(month) + "/" + str(day) + "/" + str( The following step is repeated for each row (flight) in the CSV routes file: def ProcessJourney(journeyDetails, i): ChooseFlight(journeyDetails, i) DataProcessing() AmendTimeAndDate() SaveDfToCsv(journeyDetails,i) It's time to get data from the internet and add it to the Pandas DataFrame. def DataProcessing(): global df df = df[0:0] number_element_to_ignore = 0 # departure times arture-time']") dep_times = browser.find_elements_by_xpath("//span[@data-test-id='dep dep_times_list = [value.text for value in dep_times] # arrival times ival-time']") arr_times = browser.find_elements_by_xpath("//span[@data-test-id='arr

8. arr_times_list = [value.text for value in arr_times] # airline name ine-name']") airlines = browser.find_elements_by_xpath("//span[@data-test-id='airl airlines_list = [value.text for value in airlines] # durations ation']") durations = browser.find_elements_by_xpath("//span[@data-test-id='dur durations_list = [value.text for value in durations] # stops ") stops = browser.find_elements_by_xpath("//span[@class='number-stops'] stops_list = [value.text for value in stops] # layovers ver-airport-stops']") layovers = browser.find_elements_by_xpath("//span[@data-test-id='layo layovers_list = [value.text for value in layovers] # prices g-price-dollars']") prices = browser.find_elements_by_xpath("//span[@data-test-id='listin price_list = [value.text for value in prices] hoose multiply by 2) # last flight to scrape according to the price differences (here we c last_flight_index = CheckLastFlightIndexByPrice(price_list, 2) #Genrate flight to igonre according to the last_flight_index bad_indexes = GenerateBadIndex(dep_times_list, last_flight_index) # delete the non relevant flights for i in range(len(bad_indexes)): dep_times_list.pop(int(bad_indexes[i]))

9. arr_times_list.pop(int(bad_indexes[i])) # Insert data to our DF for i in range(last_flight_index): try: df.loc[i, 'departure_time'] = dep_times_list[i] except Exception as e: pass try: df.loc[i, 'arrival_time'] = arr_times_list[i] except Exception as e: pass try: df.loc[i, 'airline'] = airlines_list[i] except Exception as e: pass try: df.loc[i, 'duration'] = durations_list[i] except Exception as e: pass try: df.loc[i, 'stops'] = stops_list[i] except Exception as e: pass try: df.loc[i, 'layovers'] = layovers_list[i] except Exception as e: pass try: df.loc[i, 'price'] = price_list[i] except Exception as e: pass try: # Adding flight details data bad_indexes, number_element_to_ignore) number_element_to_ignore = AddingFlightDetails(i, stops_list,

10. except Exception as e: pass Now, you can save the data in the required format such as CSV, JSON, etc. def GetPathForExcelsOutPut(journeyDetails,i): dep_arr_name = journeyDetails.at[i,'dep_country_chooser'] + "_" \journeyDetails.at [i,'arrival_country_chooser'] sampleTime = "sampleTime_" str(pd.to_datetime('today').strftime("%d/%m/%Y")).replace("/", "_") dep_date = str ("%02d" % journeyDetails.at[i,'dep_month']) "_" str("%02d" % journeyDetails.at[i,'dep_day']) "_" str(journeyDetails.at[i,'dep_year']) arr_date = str("%02d" % journeyDetails.at[i,' arr_month']) "_" str("%02d" % journeyDetails.at[i,'arr_day']) "_" str(journeyDetails.at[i,'arr_year']) conc_date = "depDate_" dep_date "_arrDate_" a rr_date data_path = "Insert your data results folder here (the Parent folder that contain the all automatic subdir that will be created)" folderPath = os.path.join(data_path,dep_arr_name, conc_date, 'sampleTime\\') return [folderPath, conc_date] def SaveDfToCsv(journeyDetails,i): checkPathExist(journeyDetails,i) [pathForDepArr Date, nameOfFolder] = GetPathForExcelsOutPut(journeyDetails,i) df['departure_date'] = GetDepartDateUsingFolderName(nameOfFolder) # send file path to function df['arrival_date'] = GetReturnDateUsingFolderName(nam eOfFolder) # send file path to function df.to_csv(str(GetPathForExcelsOutPut(journeyDetails,i )[0]) "_" dt.datetime.today().strftime('%y%m%d-%H%M%S') ".csv", index = False) For more details, regarding web scraping service of extracting flight price data using Python and Selenium, you can contact iWeb Scraping, today! Request for a quote!!!