NEO4J ASSIGNMENT || PYTHON CODE || DATA ANALYTICS || PANDAS

Data You will find in the folder of this assignment three Excel files: - airports: contains information about airports worldwide. - airlines: contains information about airlines worldwide. - routes: contains information about air routes between airports worldwide Task 1 [50 points] Using your favorite programming or scripting language, write code that uses the three provided Excel files and generates a Neo4j Cypher script (list of commands) that builds a graph where: 1. the nodes are all the airports with attributes: - IATA code of the airport (example, ORD for Chicago O’Hare Airport, DEL for Indira Gandhi International Airport, DOH for Doha’s Hamad International Airport, etc.) - The city and country where the airport is located 2. the edges are the air routes between airports. Each edge must have the attribute: - code of the airline operating that route (e.g., AA for American Airlines, AC for Air Canada, etc.) Notice that you might have multiple edges between two given nodes (if there are several flights between them) Task 2 [100 points] Once the Cypher script from Task 1 is working properly, write the 10 Cypher queries that give the following information from the graph built in Task 1: