:: 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: 64639
Top 10 Longest Flight Routes:
+--------------+-----------+------------+---------+--------+
|Source_Airport|Source_City|Dest_Airport|Dest_City|duration|
+--------------+-----------+------------+---------+--------+
|       Chennai|    Chennai|   Bangalore|Bangalore|    2990|
|     Bangalore|  Bangalore|     Chennai|  Chennai|    2865|
|       Chennai|    Chennai|   Bangalore|Bangalore|    2825|
|       Chennai|    Chennai|   Bangalore|Bangalore|    2750|
|       Chennai|    Chennai|     Kolkata|  Kolkata|    2670|
|     Hyderabad|  Hyderabad|     Kolkata|  Kolkata|    2520|
|     Bangalore|  Bangalore|   Hyderabad|Hyderabad|    2510|
+--------------+-----------+------------+---------+--------+

/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|
+-------+------+------+
| Mumbai|Mumbai| 25814|
+-------+------+------+

Top 10 Most Important Airports (PageRank):
+---------+---------+------------------+
|  Airport|     City|          pagerank|
+---------+---------+------------------+
|   Mumbai|   Mumbai| 1.177578663733893|
|  Kolkata|  Kolkata|1.1058404462806701|
|    Delhi|    Delhi| 1.061646105421074|
|Bangalore|Bangalore|0.9578667085188407|
|Hyderabad|Hyderabad|0.8702698857831558|
|  Chennai|  Chennai|0.8267981902623668|
+---------+---------+------------------+

Cheapest Unique Routes:
+--------------+-----------+------------+---------+--------+----+
|Source_Airport|Source_City|Dest_Airport|Dest_City|duration|cost|
+--------------+-----------+------------+---------+--------+----+
|Chennai       |Chennai    |Hyderabad   |Hyderabad|530     |1116|
|Chennai       |Chennai    |Bangalore   |Bangalore|50      |1457|
|Hyderabad     |Hyderabad  |Chennai     |Chennai  |500     |1558|
|Bangalore     |Bangalore  |Chennai     |Chennai  |60      |1619|
|Bangalore     |Bangalore  |Hyderabad   |Hyderabad|275     |1711|
|Hyderabad     |Hyderabad  |Bangalore   |Bangalore|435     |1773|
|Chennai       |Chennai    |Mumbai      |Mumbai   |525     |1848|
|Mumbai        |Mumbai     |Chennai     |Chennai  |260     |1909|
|Delhi         |Delhi      |Chennai     |Chennai  |415     |2018|
|Delhi         |Delhi      |Hyderabad   |Hyderabad|140     |2042|
|Chennai       |Chennai    |Delhi       |Delhi    |320     |2072|
|Hyderabad     |Hyderabad  |Kolkata     |Kolkata  |325     |2077|
|Mumbai        |Mumbai     |Bangalore   |Bangalore|975     |2095|
|Mumbai        |Mumbai     |Hyderabad   |Hyderabad|785     |2126|
|Bangalore     |Bangalore  |Mumbai      |Mumbai   |105     |2172|
|Hyderabad     |Hyderabad  |Delhi       |Delhi    |135     |2222|
|Hyderabad     |Hyderabad  |Mumbai      |Mumbai   |580     |2273|
|Delhi         |Delhi      |Mumbai      |Mumbai   |130     |2304|
|Mumbai        |Mumbai     |Delhi       |Delhi    |550     |2359|
|Chennai       |Chennai    |Kolkata     |Kolkata  |375     |2383|
|Kolkata       |Kolkata    |Hyderabad   |Hyderabad|370     |2460|
|Delhi         |Delhi      |Kolkata     |Kolkata  |1015    |2505|
|Bangalore     |Bangalore  |Delhi       |Delhi    |430     |2750|
|Mumbai        |Mumbai     |Kolkata     |Kolkata  |395     |2863|
|Kolkata       |Kolkata    |Chennai     |Chennai  |145     |2996|
|Kolkata       |Kolkata    |Delhi       |Delhi    |325     |3024|
|Bangalore     |Bangalore  |Kolkata     |Kolkata  |380     |3056|
|Delhi         |Delhi      |Bangalore   |Bangalore|445     |3121|
|Kolkata       |Kolkata    |Mumbai      |Mumbai   |425     |3413|
|Kolkata       |Kolkata    |Bangalore   |Bangalore|310     |3500|
+--------------+-----------+------------+---------+--------+----+