Output

:: loading settings :: url = jar:file:/opt/spark/jars/ivy-2.5.1.jar!/org/apache/ivy/core/settings/ivysettings.xml
/opt/spark/python/lib/pyspark.zip/pyspark/sql/dataframe.py:169: UserWarning: DataFrame.sql_ctx is an internal property, and will be removed in future releases. Use DataFrame.sparkSession instead.
Total number of flight routes: 83148
Top 10 Longest Flight Routes:
+--------------+--------------+------------+--------------+--------+
|Source_Airport|   Source_City|Dest_Airport|     Dest_City|distance|
+--------------+--------------+------------+--------------+--------+
|           HNL|  Honolulu, HI|         ATL|   Atlanta, GA|  4502.0|
|           JFK|  New York, NY|         HNL|  Honolulu, HI|  4983.0|
|           HNL|  Honolulu, HI|         JFK|  New York, NY|  4983.0|
|           HNL|  Honolulu, HI|         DTW|   Detroit, MI|  4475.0|
|           EWR|    Newark, NJ|         HNL|  Honolulu, HI|  4963.0|
|           EWR|    Newark, NJ|         HNL|  Honolulu, HI|  4962.0|
|           IAD|Washington, DC|         HNL|  Honolulu, HI|  4817.0|
|           ATL|   Atlanta, GA|         HNL|  Honolulu, HI|  4502.0|
|           HNL|  Honolulu, HI|         IAD|Washington, DC|  4817.0|
|           HNL|  Honolulu, HI|         EWR|    Newark, NJ|  4962.0|
+--------------+--------------+------------+--------------+--------+

/opt/spark/python/lib/pyspark.zip/pyspark/sql/dataframe.py:148: UserWarning: DataFrame constructor is internal. Do not directly use it.
Airport with Highest Degree Vertex:
+-------+-----------+------+
|Airport|       City|degree|
+-------+-----------+------+
|    ATL|Atlanta, GA|  9354|
+-------+-----------+------+

Top 10 Most Important Airports (PageRank):
+-------+--------------------+-------------------+
|Airport|                City|           pagerank|
+-------+--------------------+-------------------+
|    BQN|       Aguadilla, PR|0.28991149043585734|
|    ABE|Allentown/Bethleh...| 0.4054864727496218|
|    LNK|         Lincoln, NE|0.29461890593862766|
|    BZN|         Bozeman, MT| 0.5510501048916558|
|    XNA|    Fayetteville, AR|   0.74776839633187|
|    CMI|Champaign/Urbana, IL|0.28784815794464125|
|    PDX|        Portland, OR|  3.005542707502135|
|    SRQ|Sarasota/Bradento...| 0.5416108830845003|
|    HLN|          Helena, MT| 0.2346834019910451|
|    AMA|        Amarillo, TX| 0.5114045217026542|
+-------+--------------------+-------------------+

Top 10 Cheapest Routes:
+--------------+--------------------+------------+--------------------+--------+----+
|Source_Airport|         Source_City|Dest_Airport|           Dest_City|distance|cost|
+--------------+--------------------+------------+--------------------+--------+----+
|           OGG|         Kahului, HI|         LIH|           Lihue, HI|   202.0| 0.0|
|           ORF|         Norfolk, VA|         DFW|Dallas/Fort Worth...|  1212.0| 0.0|
|           CMH|        Columbus, OH|         EWR|          Newark, NJ|   462.0| 0.0|
|           XNA|    Fayetteville, AR|         ORD|         Chicago, IL|   522.0| 0.0|
|           DEN|          Denver, CO|         ASE|           Aspen, CO|   125.0| 0.0|
|           AMA|        Amarillo, TX|         PHX|         Phoenix, AZ|   602.0| 0.0|
|           SEA|         Seattle, WA|         ATL|         Atlanta, GA|  2182.0| 0.0|
|           PBI|West Palm Beach/P...|         EWR|          Newark, NJ|  1024.0| 0.0|
|           ORD|         Chicago, IL|         MSY|     New Orleans, LA|   837.0| 0.0|
|           ORD|         Chicago, IL|         DFW|Dallas/Fort Worth...|   802.0| 0.0|
+--------------+--------------------+------------+--------------------+--------+----+