BusraNur_Orhan_Question1&2&3&4&5.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "BusraNur-Orhan-Question1&2&3.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyOUXLsIqyjhbw2t6pueTaz+",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/busranurorhan/Complete-Python-3-Bootcamp/blob/master/BusraNur_Orhan_Question1%262%263%264%265.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "n0dDTM-reUPp",
        "outputId": "49d1f214-4d9a-4ebc-c2a1-be173090655a"
      },
      "source": [
        "\n",
        "!apt-get update\n",
        "!apt-get install openjdk-8-jdk-headless -qq > /dev/null\n",
        "import os\n",
        "os.environ[\"JAVA_HOME\"] = \"/usr/lib/jvm/java-8-openjdk-amd64\"\n",
        "!update-alternatives --set java /usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java\n",
        "!java -version\n",
        "!pip install pyspark"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\r0% [Working]\r            \rHit:1 https://cloud.r-project.org/bin/linux/ubuntu bionic-cran40/ InRelease\n",
            "\r0% [Connecting to archive.ubuntu.com] [Connecting to security.ubuntu.com (91.18\r                                                                               \rIgn:2 https://developer.download.nvidia.com/compute/cuda/repos/ubuntu1804/x86_64  InRelease\n",
            "\r0% [Connecting to archive.ubuntu.com] [Waiting for headers] [Connecting to ppa.\r0% [1 InRelease gpgv 3,626 B] [Connecting to archive.ubuntu.com] [Waiting for h\r                                                                               \rIgn:3 https://developer.download.nvidia.com/compute/machine-learning/repos/ubuntu1804/x86_64  InRelease\n",
            "\r0% [1 InRelease gpgv 3,626 B] [Connecting to archive.ubuntu.com] [Waiting for h\r                                                                               \rHit:4 https://developer.download.nvidia.com/compute/cuda/repos/ubuntu1804/x86_64  Release\n",
            "\r0% [1 InRelease gpgv 3,626 B] [Connecting to archive.ubuntu.com] [Waiting for h\r                                                                               \rGet:5 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]\n",
            "Hit:6 https://developer.download.nvidia.com/compute/machine-learning/repos/ubuntu1804/x86_64  Release\n",
            "Hit:7 http://ppa.launchpad.net/c2d4u.team/c2d4u4.0+/ubuntu bionic InRelease\n",
            "Hit:8 http://archive.ubuntu.com/ubuntu bionic InRelease\n",
            "Hit:9 http://ppa.launchpad.net/cran/libgit2/ubuntu bionic InRelease\n",
            "Get:10 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]\n",
            "Hit:13 http://ppa.launchpad.net/deadsnakes/ppa/ubuntu bionic InRelease\n",
            "Get:14 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]\n",
            "Hit:15 http://ppa.launchpad.net/graphics-drivers/ppa/ubuntu bionic InRelease\n",
            "Fetched 252 kB in 3s (97.1 kB/s)\n",
            "Reading package lists... Done\n",
            "openjdk version \"1.8.0_292\"\n",
            "OpenJDK Runtime Environment (build 1.8.0_292-8u292-b10-0ubuntu1~18.04-b10)\n",
            "OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)\n",
            "Requirement already satisfied: pyspark in /usr/local/lib/python3.7/dist-packages (3.1.2)\n",
            "Requirement already satisfied: py4j==0.10.9 in /usr/local/lib/python3.7/dist-packages (from pyspark) (0.10.9)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UDbTBozsAWi9"
      },
      "source": [
        "#You can find Question-1 answer below"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 370
        },
        "id": "F8x_BT1F8gp-",
        "outputId": "da659a51-95f0-4add-ddc8-b1357089bfbc"
      },
      "source": [
        "from pyspark import SparkContext\n",
        "from geopy import distance\n",
        "import geopy.distance\n",
        "sc = SparkContext.getOrCreate()\n",
        "CapitalsRDD = sc.textFile('Capitals.txt')\n",
        "#CapitalsRDD.take(4)\n",
        "\n",
        "def splitAndTake(line):\n",
        "  arr = line.split(\"\\t\")\n",
        "  countryCapital = arr[1] + \"-\" + arr[2]\n",
        "  enlem = float(arr[3].replace(\",\",\".\"))\n",
        "  boylam = float(arr[4].replace(\",\",\".\"))\n",
        "\n",
        "  return (countryCapital,enlem,boylam)\n",
        "\n",
        " \n",
        "CapitalsRDD = CapitalsRDD.map(lambda x: splitAndTake(x))\n",
        "#CapitalsRDD = CapitalsRDD.filter(lambda y : 'Saint Martin -Marigot ' in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda y : 'Nauru -Yaren ' not in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda z : 'Tokelau -Nukunonu ' not in z)\n",
        "#CapitalsRDD.collect()\n",
        "\n",
        "\n",
        "\n",
        "CapitalsRDD2 = CapitalsRDD.cartesian(CapitalsRDD)\n",
        "CapitalsRDD2 = CapitalsRDD2.map(lambda a : (a[0][0],a[1][0],geopy.distance.great_circle((a[0][1],a[0][2]),(a[1][1],a[1][2])).km ))\n",
        "CapitalsRDD2 = CapitalsRDD2.filter(lambda b : b[2] > 0.0)\n",
        "CapitalsRDD2 = CapitalsRDD2.sortBy(lambda c : c[2], ascending=True)\n",
        "CapitalsRDD2.collect()"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "error",
          "ename": "KeyboardInterrupt",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-2-7e4de7fce184>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0mgeopy\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mdistance\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mgeopy\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdistance\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m \u001b[0msc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mSparkContext\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgetOrCreate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m \u001b[0mCapitalsRDD\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msc\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtextFile\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Capitals.txt'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m \u001b[0;31m#CapitalsRDD.take(4)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pyspark/context.py\u001b[0m in \u001b[0;36mgetOrCreate\u001b[0;34m(cls, conf)\u001b[0m\n\u001b[1;32m    382\u001b[0m         \u001b[0;32mwith\u001b[0m \u001b[0mSparkContext\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_lock\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    383\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mSparkContext\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_active_spark_context\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 384\u001b[0;31m                 \u001b[0mSparkContext\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mconf\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mconf\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mSparkConf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    385\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mSparkContext\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_active_spark_context\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    386\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pyspark/context.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, master, appName, sparkHome, pyFiles, environment, batchSize, serializer, conf, gateway, jsc, profiler_cls)\u001b[0m\n\u001b[1;32m    145\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    146\u001b[0m             self._do_init(master, appName, sparkHome, pyFiles, environment, batchSize, serializer,\n\u001b[0;32m--> 147\u001b[0;31m                           conf, jsc, profiler_cls)\n\u001b[0m\u001b[1;32m    148\u001b[0m         \u001b[0;32mexcept\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    149\u001b[0m             \u001b[0;31m# If an error occurs, clean up in order to allow future SparkContext creation:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pyspark/context.py\u001b[0m in \u001b[0;36m_do_init\u001b[0;34m(self, master, appName, sparkHome, pyFiles, environment, batchSize, serializer, conf, jsc, profiler_cls)\u001b[0m\n\u001b[1;32m    209\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jsc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mjsc\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_initialize_context\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_conf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jconf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    210\u001b[0m         \u001b[0;31m# Reset the SparkConf to the one actually used by the SparkContext in JVM.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 211\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_conf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mSparkConf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_jconf\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jsc\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    212\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    213\u001b[0m         \u001b[0;31m# Create a single Accumulator in Java that we'll send all our updates through;\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36m__call__\u001b[0;34m(self, *args)\u001b[0m\n\u001b[1;32m   1301\u001b[0m             \u001b[0mproto\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mEND_COMMAND_PART\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1302\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1303\u001b[0;31m         \u001b[0manswer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgateway_client\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1304\u001b[0m         return_value = get_return_value(\n\u001b[1;32m   1305\u001b[0m             answer, self.gateway_client, self.target_id, self.name)\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36msend_command\u001b[0;34m(self, command, retry, binary)\u001b[0m\n\u001b[1;32m   1031\u001b[0m         \u001b[0mconnection\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_connection\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1032\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1033\u001b[0;31m             \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mconnection\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1034\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mbinary\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1035\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mresponse\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_create_connection_guard\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mconnection\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36msend_command\u001b[0;34m(self, command)\u001b[0m\n\u001b[1;32m   1198\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1199\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1200\u001b[0;31m             \u001b[0manswer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msmart_decode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstream\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreadline\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1201\u001b[0m             \u001b[0mlogger\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdebug\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Answer received: {0}\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0manswer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1202\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0manswer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstartswith\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mproto\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mRETURN_MESSAGE\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/lib/python3.7/socket.py\u001b[0m in \u001b[0;36mreadinto\u001b[0;34m(self, b)\u001b[0m\n\u001b[1;32m    587\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    588\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 589\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrecv_into\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    590\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    591\u001b[0m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_timeout_occurred\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9y6PeeDoAjiC"
      },
      "source": [
        "#You can find Question-2 answer below"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DqydRH9mhYzu",
        "outputId": "f96765e0-0d53-4fad-a24f-fa4211ef536e"
      },
      "source": [
        "from pyspark import SparkContext\n",
        "from geopy import distance\n",
        "import geopy.distance\n",
        "sc = SparkContext.getOrCreate()\n",
        "CapitalsRDD = sc.textFile('Capitals.txt')\n",
        "#CapitalsRDD.take(4)\n",
        "\n",
        "def splitAndTake(line):\n",
        "  arr = line.split(\"\\t\")\n",
        "  countryCapital = arr[1] + \"-\" + arr[2]\n",
        "  enlem = float(arr[3].replace(\",\",\".\"))\n",
        "  boylam = float(arr[4].replace(\",\",\".\"))\n",
        "\n",
        "  return (countryCapital,enlem,boylam)\n",
        "\n",
        " \n",
        "CapitalsRDD = CapitalsRDD.map(lambda x: splitAndTake(x))\n",
        "#CapitalsRDD = CapitalsRDD.filter(lambda y : 'Saint Martin -Marigot ' in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda y : 'Nauru -Yaren ' not in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda z : 'Tokelau -Nukunonu ' not in z)\n",
        "#CapitalsRDD.collect()\n",
        "\n",
        "\n",
        "\n",
        "CapitalsRDD2 = CapitalsRDD.cartesian(CapitalsRDD)\n",
        "CapitalsRDD2 = CapitalsRDD2.map(lambda a : (a[0][0],a[1][0],geopy.distance.great_circle((a[0][1],a[0][2]),(a[1][1],a[1][2])).km ))\n",
        "CapitalsRDD2 = CapitalsRDD2.filter(lambda b : b[2] > 0.0)\n",
        "CapitalsRDD2 = CapitalsRDD2.sortBy(lambda c : c[2], ascending=False)\n",
        "CapitalsRDD2.collect()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Paraguay -Asunción ', 'Taiwan -Taipei ', 19927.085430148745),\n",
              " ('Taiwan -Taipei ', 'Paraguay -Asunción ', 19927.085430148745),\n",
              " ('Bahrain -Manama ', 'Pitcairn -Adamstown ', 19870.208402369823),\n",
              " ('Pitcairn -Adamstown ', 'Bahrain -Manama ', 19870.208402369823),\n",
              " ('New Zealand -Wellington ', 'Spain -Madrid ', 19854.803331639705),\n",
              " ('Spain -Madrid ', 'New Zealand -Wellington ', 19854.8033316397),\n",
              " ('Pitcairn -Adamstown ', 'Qatar -Doha ', 19850.4269358751),\n",
              " ('Qatar -Doha ', 'Pitcairn -Adamstown ', 19850.4269358751),\n",
              " ('Niger -Niamey ', 'Wallis and Futuna -Mata-Utu ', 19827.313399776238),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Niger -Niamey ', 19827.313399776238),\n",
              " ('Colombia -Bogotá ', 'Indonesia -Jakarta ', 19809.564876990044),\n",
              " ('Indonesia -Jakarta ', 'Colombia -Bogotá ', 19809.564876990044),\n",
              " ('Cambodia -Phnom Penh ', 'Peru -Lima ', 19796.259929457545),\n",
              " ('Peru -Lima ', 'Cambodia -Phnom Penh ', 19796.259929457545),\n",
              " ('Norfolk Island -Kingston ',\n",
              "  'Western Sahara -El Aaiún ',\n",
              "  19775.670462214403),\n",
              " ('Western Sahara -El Aaiún ',\n",
              "  'Norfolk Island -Kingston ',\n",
              "  19775.670462214403),\n",
              " ('Cocos Islands -West Island ', 'Costa Rica -San José ', 19748.407679706135),\n",
              " ('Costa Rica -San José ', 'Cocos Islands -West Island ', 19748.407679706135),\n",
              " ('Ecuador -Quito ', 'Singapore -Singapore ', 19726.449733827427),\n",
              " ('Singapore -Singapore ', 'Ecuador -Quito ', 19726.449733827427),\n",
              " ('East Timor -Dili ', 'Suriname -Paramaribo ', 19705.063006969733),\n",
              " ('Suriname -Paramaribo ', 'East Timor -Dili ', 19705.063006969733),\n",
              " ('French Polynesia -Papeete ', 'Sudan -Khartoum ', 19701.150023073773),\n",
              " ('Sudan -Khartoum ', 'French Polynesia -Papeete ', 19701.150023073773),\n",
              " ('Pitcairn -Adamstown ', 'Saudi Arabia -Riyadh ', 19691.569283795518),\n",
              " ('Saudi Arabia -Riyadh ', 'Pitcairn -Adamstown ', 19691.569283795518),\n",
              " ('Ecuador -Quito ', 'Malaysia -Kuala Lumpur ', 19690.69681773388),\n",
              " ('Malaysia -Kuala Lumpur ', 'Ecuador -Quito ', 19690.69681773388),\n",
              " ('Peru -Lima ', 'Thailand -Bangkok ', 19686.748318634036),\n",
              " ('Thailand -Bangkok ', 'Peru -Lima ', 19686.748318634036),\n",
              " ('Cocos Islands -West Island ', 'Nicaragua -Managua ', 19681.37167948839),\n",
              " ('Nicaragua -Managua ', 'Cocos Islands -West Island ', 19681.37167948839),\n",
              " ('Ghana -Accra ', 'Tuvalu -Funafuti ', 19679.165568630753),\n",
              " ('Tuvalu -Funafuti ', 'Ghana -Accra ', 19679.165568630753),\n",
              " ('Togo -Lomé ', 'Tuvalu -Funafuti ', 19669.197047843198),\n",
              " ('Tuvalu -Funafuti ', 'Togo -Lomé ', 19669.197047843198),\n",
              " ('Bolivia -Sucre ', 'Hong Kong -Hong Kong ', 19647.632390368028),\n",
              " ('Hong Kong -Hong Kong ', 'Bolivia -Sucre ', 19647.632390368028),\n",
              " ('Bolivia -Sucre ', 'Macao -Macao ', 19641.50957142248),\n",
              " ('Macao -Macao ', 'Bolivia -Sucre ', 19641.50957142248),\n",
              " ('South Korea -Seoul ', 'Uruguay -Montevideo ', 19599.57852061687),\n",
              " ('Uruguay -Montevideo ', 'South Korea -Seoul ', 19599.57852061687),\n",
              " ('Burkina Faso -Ouagadougou ', 'Tuvalu -Funafuti ', 19579.83703546156),\n",
              " ('Tuvalu -Funafuti ', 'Burkina Faso -Ouagadougou ', 19579.83703546156),\n",
              " ('Benin -Porto-Novo ', 'Tuvalu -Funafuti ', 19577.218692644656),\n",
              " ('Tuvalu -Funafuti ', 'Benin -Porto-Novo ', 19577.218692644656),\n",
              " ('New Zealand -Wellington ', 'Portugal -Lisbon ', 19576.367815827987),\n",
              " ('Portugal -Lisbon ', 'New Zealand -Wellington ', 19576.367815827987),\n",
              " ('East Timor -Dili ', 'Guyana -Georgetown ', 19559.882885001774),\n",
              " ('Guyana -Georgetown ', 'East Timor -Dili ', 19559.882885001774),\n",
              " ('Pitcairn -Adamstown ',\n",
              "  'United Arab Emirates -Abu Dhabi ',\n",
              "  19558.92094049567),\n",
              " ('United Arab Emirates -Abu Dhabi ',\n",
              "  'Pitcairn -Adamstown ',\n",
              "  19558.92094049567),\n",
              " ('Mauritania -Nouakchott ', 'Vanuatu -Port Vila ', 19558.399879202756),\n",
              " ('Vanuatu -Port Vila ', 'Mauritania -Nouakchott ', 19558.399879202756),\n",
              " ('East Timor -Dili ', 'French Guiana -Cayenne ', 19549.62659362711),\n",
              " ('French Guiana -Cayenne ', 'East Timor -Dili ', 19549.62659362711),\n",
              " ('Cocos Islands -West Island ', 'Honduras -Tegucigalpa ', 19529.299652093003),\n",
              " ('Honduras -Tegucigalpa ', 'Cocos Islands -West Island ', 19529.299652093003),\n",
              " ('North Korea -Pyongyang ', 'Uruguay -Montevideo ', 19517.926803808627),\n",
              " ('Uruguay -Montevideo ', 'North Korea -Pyongyang ', 19517.926803808627),\n",
              " ('Kuwait -Kuwait City ', 'Pitcairn -Adamstown ', 19500.693750187773),\n",
              " ('Pitcairn -Adamstown ', 'Kuwait -Kuwait City ', 19500.693750187773),\n",
              " ('Aruba -Oranjestad ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19492.571618048973),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Aruba -Oranjestad ',\n",
              "  19492.571618048973),\n",
              " ('Ivory Coast -Yamoussoukro ', 'Tuvalu -Funafuti ', 19487.514912612543),\n",
              " ('Tuvalu -Funafuti ', 'Ivory Coast -Yamoussoukro ', 19487.514912612543),\n",
              " ('Mauritania -Nouakchott ', 'New Caledonia -Noumea ', 19484.19520168055),\n",
              " ('New Caledonia -Noumea ', 'Mauritania -Nouakchott ', 19484.19520168055),\n",
              " ('Cocos Islands -West Island ', 'Panama -Panama City ', 19481.963532842372),\n",
              " ('Panama -Panama City ', 'Cocos Islands -West Island ', 19481.963532842372),\n",
              " ('Nigeria -Abuja ', 'Samoa -Apia ', 19479.556511485498),\n",
              " ('Samoa -Apia ', 'Nigeria -Abuja ', 19479.556511485498),\n",
              " ('Western Sahara -El Aaiún ', 'New Caledonia -Noumea ', 19471.398515884724),\n",
              " ('New Caledonia -Noumea ', 'Western Sahara -El Aaiún ', 19471.39851588472),\n",
              " ('Guinea-Bissau -Bissau ', 'Solomon Islands -Honiara ', 19458.82632858907),\n",
              " ('Solomon Islands -Honiara ', 'Guinea-Bissau -Bissau ', 19458.82632858907),\n",
              " ('Gibraltar -Gibraltar ', 'New Zealand -Wellington ', 19442.34954271799),\n",
              " ('New Zealand -Wellington ', 'Gibraltar -Gibraltar ', 19442.34954271799),\n",
              " ('Andorra -Andorra la Vella ',\n",
              "  'New Zealand -Wellington ',\n",
              "  19441.203241261803),\n",
              " ('New Zealand -Wellington ',\n",
              "  'Andorra -Andorra la Vella ',\n",
              "  19441.203241261803),\n",
              " ('Argentina -Buenos Aires ', 'South Korea -Seoul ', 19431.93051779307),\n",
              " ('South Korea -Seoul ', 'Argentina -Buenos Aires ', 19431.93051779307),\n",
              " ('Gambia -Banjul ', 'Solomon Islands -Honiara ', 19429.652629427357),\n",
              " ('Solomon Islands -Honiara ', 'Gambia -Banjul ', 19429.652629427357),\n",
              " ('Burkina Faso -Ouagadougou ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  19425.251859662792),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Burkina Faso -Ouagadougou ',\n",
              "  19425.251859662792),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Panama -Panama City ',\n",
              "  19423.43089168526),\n",
              " ('Panama -Panama City ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19423.43089168526),\n",
              " ('American Samoa -Pago Pago ', 'Nigeria -Abuja ', 19402.851292970026),\n",
              " ('Nigeria -Abuja ', 'American Samoa -Pago Pago ', 19402.851292970026),\n",
              " ('Argentina -Buenos Aires ', 'North Korea -Pyongyang ', 19401.515334995285),\n",
              " ('North Korea -Pyongyang ', 'Argentina -Buenos Aires ', 19401.515334995285),\n",
              " ('Nigeria -Abuja ', 'Wallis and Futuna -Mata-Utu ', 19400.621756174685),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Nigeria -Abuja ', 19400.621756174685),\n",
              " ('Niger -Niamey ', 'Tuvalu -Funafuti ', 19375.29016854089),\n",
              " ('Tuvalu -Funafuti ', 'Niger -Niamey ', 19375.29016854089),\n",
              " ('Burkina Faso -Ouagadougou ', 'Fiji -Suva ', 19373.511373966838),\n",
              " ('Fiji -Suva ', 'Burkina Faso -Ouagadougou ', 19373.511373966838),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Colombia -Bogotá ',\n",
              "  19368.530586350236),\n",
              " ('Colombia -Bogotá ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19368.530586350236),\n",
              " ('Fiji -Suva ', 'Niger -Niamey ', 19367.739605002927),\n",
              " ('Niger -Niamey ', 'Fiji -Suva ', 19367.739605002927),\n",
              " ('Senegal -Dakar ', 'Solomon Islands -Honiara ', 19365.055728363466),\n",
              " ('Solomon Islands -Honiara ', 'Senegal -Dakar ', 19365.055728363466),\n",
              " ('Laos -Vientiane ', 'Peru -Lima ', 19354.533117774015),\n",
              " ('Peru -Lima ', 'Laos -Vientiane ', 19354.533117774015),\n",
              " ('Niger -Niamey ', 'Samoa -Apia ', 19352.93995251567),\n",
              " ('Samoa -Apia ', 'Niger -Niamey ', 19352.93995251567),\n",
              " ('American Samoa -Pago Pago ', \"Chad -N'Djamena \", 19348.55602771611),\n",
              " (\"Chad -N'Djamena \", 'American Samoa -Pago Pago ', 19348.55602771611),\n",
              " ('El Salvador -San Salvador ',\n",
              "  'Cocos Islands -West Island ',\n",
              "  19341.948913564218),\n",
              " ('Cocos Islands -West Island ',\n",
              "  'El Salvador -San Salvador ',\n",
              "  19341.948913564214),\n",
              " ('Mali -Bamako ', 'Vanuatu -Port Vila ', 19325.98666597226),\n",
              " ('Vanuatu -Port Vila ', 'Mali -Bamako ', 19325.98666597226),\n",
              " ('Colombia -Bogotá ', 'Singapore -Singapore ', 19319.92334989313),\n",
              " ('Singapore -Singapore ', 'Colombia -Bogotá ', 19319.92334989313),\n",
              " ('Guinea -Conakry ', 'Solomon Islands -Honiara ', 19316.38872010435),\n",
              " ('Solomon Islands -Honiara ', 'Guinea -Conakry ', 19316.38872010435),\n",
              " ('Senegal -Dakar ', 'Vanuatu -Port Vila ', 19313.416164756483),\n",
              " ('Vanuatu -Port Vila ', 'Senegal -Dakar ', 19313.416164756483),\n",
              " ('Gambia -Banjul ', 'Vanuatu -Port Vila ', 19306.77135857316),\n",
              " ('Vanuatu -Port Vila ', 'Gambia -Banjul ', 19306.77135857316),\n",
              " ('Cape Verde -Praia ', 'Solomon Islands -Honiara ', 19297.251751384996),\n",
              " ('Solomon Islands -Honiara ', 'Cape Verde -Praia ', 19297.251751384996),\n",
              " ('Morocco -Rabat ', 'Norfolk Island -Kingston ', 19275.712848880197),\n",
              " ('Norfolk Island -Kingston ', 'Morocco -Rabat ', 19275.712848880197),\n",
              " ('Argentina -Buenos Aires ', 'China -Beijing ', 19266.610623268833),\n",
              " ('China -Beijing ', 'Argentina -Buenos Aires ', 19266.610623268833),\n",
              " ('Sierra Leone -Freetown ', 'Solomon Islands -Honiara ', 19258.616545346442),\n",
              " ('Solomon Islands -Honiara ', 'Sierra Leone -Freetown ', 19258.616545346442),\n",
              " ('Barbados -Bridgetown ', 'East Timor -Dili ', 19256.20551744218),\n",
              " ('East Timor -Dili ', 'Barbados -Bridgetown ', 19256.20551744218),\n",
              " (\"Chad -N'Djamena \", 'Samoa -Apia ', 19252.86555607498),\n",
              " ('Samoa -Apia ', \"Chad -N'Djamena \", 19252.86555607498),\n",
              " ('Benin -Porto-Novo ', 'Wallis and Futuna -Mata-Utu ', 19249.282013428117),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Benin -Porto-Novo ', 19249.282013428117),\n",
              " ('Indonesia -Jakarta ', 'Panama -Panama City ', 19248.05773750547),\n",
              " ('Panama -Panama City ', 'Indonesia -Jakarta ', 19248.05773750547),\n",
              " ('Guinea-Bissau -Bissau ', 'Vanuatu -Port Vila ', 19238.294241624666),\n",
              " ('Vanuatu -Port Vila ', 'Guinea-Bissau -Bissau ', 19238.294241624666),\n",
              " ('Aruba -Oranjestad ', 'Indonesia -Jakarta ', 19234.51038445833),\n",
              " ('Indonesia -Jakarta ', 'Aruba -Oranjestad ', 19234.51038445833),\n",
              " ('American Samoa -Pago Pago ', 'Niger -Niamey ', 19234.34513449889),\n",
              " ('Niger -Niamey ', 'American Samoa -Pago Pago ', 19234.34513449889),\n",
              " ('East Timor -Dili ',\n",
              "  'Trinidad and Tobago -Port of Spain ',\n",
              "  19203.238045383587),\n",
              " ('Trinidad and Tobago -Port of Spain ',\n",
              "  'East Timor -Dili ',\n",
              "  19203.238045383587),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Venezuela -Caracas ',\n",
              "  19201.54023462513),\n",
              " ('Venezuela -Caracas ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19201.54023462513),\n",
              " ('Cayman Islands -George Town ',\n",
              "  'Cocos Islands -West Island ',\n",
              "  19199.00455861504),\n",
              " ('Cocos Islands -West Island ',\n",
              "  'Cayman Islands -George Town ',\n",
              "  19199.00455861504),\n",
              " ('Morocco -Rabat ', 'New Zealand -Wellington ', 19193.34505181727),\n",
              " ('New Zealand -Wellington ', 'Morocco -Rabat ', 19193.34505181727),\n",
              " ('Belize -Belmopan ', 'Cocos Islands -West Island ', 19189.58615449094),\n",
              " ('Cocos Islands -West Island ', 'Belize -Belmopan ', 19189.58615449094),\n",
              " ('Bolivia -Sucre ', 'Philippines -Manila ', 19188.385604417566),\n",
              " ('Philippines -Manila ', 'Bolivia -Sucre ', 19188.385604417566),\n",
              " ('Indonesia -Jakarta ', 'Venezuela -Caracas ', 19177.21476837516),\n",
              " ('Venezuela -Caracas ', 'Indonesia -Jakarta ', 19177.21476837516),\n",
              " ('Cocos Islands -West Island ',\n",
              "  'Guatemala -New Guatemala ',\n",
              "  19175.753075852637),\n",
              " ('Guatemala -New Guatemala ',\n",
              "  'Cocos Islands -West Island ',\n",
              "  19175.753075852637),\n",
              " ('Togo -Lomé ', 'Wallis and Futuna -Mata-Utu ', 19170.91583344567),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Togo -Lomé ', 19170.91583344567),\n",
              " ('China -Beijing ', 'Uruguay -Montevideo ', 19149.556214478078),\n",
              " ('Uruguay -Montevideo ', 'China -Beijing ', 19149.556214478078),\n",
              " ('Algeria -Algiers ', 'New Zealand -Wellington ', 19141.667728535765),\n",
              " ('New Zealand -Wellington ', 'Algeria -Algiers ', 19141.667728535765),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Jamaica -Kingston ',\n",
              "  19131.274052239933),\n",
              " ('Jamaica -Kingston ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19131.274052239933),\n",
              " ('East Timor -Dili ', \"Grenada -St. George's \", 19124.88701932149),\n",
              " (\"Grenada -St. George's \", 'East Timor -Dili ', 19124.88701932149),\n",
              " ('Niger -Niamey ', \"Tonga -Nuku'alofa \", 19121.072767644688),\n",
              " (\"Tonga -Nuku'alofa \", 'Niger -Niamey ', 19121.072767644684),\n",
              " ('Oman -Muscat ', 'Pitcairn -Adamstown ', 19120.053358075136),\n",
              " ('Pitcairn -Adamstown ', 'Oman -Muscat ', 19120.053358075136),\n",
              " ('Hong Kong -Hong Kong ', 'Paraguay -Asunción ', 19116.43930615003),\n",
              " ('Paraguay -Asunción ', 'Hong Kong -Hong Kong ', 19116.43930615003),\n",
              " ('East Timor -Dili ',\n",
              "  'Saint Vincent and the Grenadines -Kingstown ',\n",
              "  19114.509710524286),\n",
              " ('Saint Vincent and the Grenadines -Kingstown ',\n",
              "  'East Timor -Dili ',\n",
              "  19114.509710524286),\n",
              " ('Mali -Bamako ', 'Tuvalu -Funafuti ', 19105.063137275425),\n",
              " ('Tuvalu -Funafuti ', 'Mali -Bamako ', 19105.063137275425),\n",
              " ('Jersey -Saint Helier ', 'New Zealand -Wellington ', 19103.553994923794),\n",
              " ('New Zealand -Wellington ', 'Jersey -Saint Helier ', 19103.553994923794),\n",
              " ('Nigeria -Abuja ', 'Tuvalu -Funafuti ', 19102.118430526596),\n",
              " ('Tuvalu -Funafuti ', 'Nigeria -Abuja ', 19102.118430526596),\n",
              " ('Fiji -Suva ', 'Mali -Bamako ', 19093.793204566995),\n",
              " ('Mali -Bamako ', 'Fiji -Suva ', 19093.793204566995),\n",
              " ('Ivory Coast -Yamoussoukro ', 'Kiribati -South Tarawa ', 19088.532199886533),\n",
              " ('Kiribati -South Tarawa ', 'Ivory Coast -Yamoussoukro ', 19088.532199886533),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Haiti -Port-au-Prince ',\n",
              "  19087.436916558556),\n",
              " ('Haiti -Port-au-Prince ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19087.436916558556),\n",
              " ('Ecuador -Quito ', 'Indonesia -Jakarta ', 19083.452568801535),\n",
              " ('Indonesia -Jakarta ', 'Ecuador -Quito ', 19083.452568801535),\n",
              " ('Guernsey -St Peter Port ', 'New Zealand -Wellington ', 19083.009500137217),\n",
              " ('New Zealand -Wellington ', 'Guernsey -St Peter Port ', 19083.009500137217),\n",
              " ('Guinea -Conakry ', 'Vanuatu -Port Vila ', 19079.183857297474),\n",
              " ('Vanuatu -Port Vila ', 'Guinea -Conakry ', 19079.183857297474),\n",
              " (\"Chad -N'Djamena \", 'Niue -Alofi ', 19077.55699016777),\n",
              " ('Niue -Alofi ', \"Chad -N'Djamena \", 19077.55699016777),\n",
              " ('East Timor -Dili ', 'Saint Lucia -Castries ', 19076.871943994367),\n",
              " ('Saint Lucia -Castries ', 'East Timor -Dili ', 19076.871943994367),\n",
              " ('New Caledonia -Noumea ', 'Senegal -Dakar ', 19076.442458545655),\n",
              " ('Senegal -Dakar ', 'New Caledonia -Noumea ', 19076.442458545655),\n",
              " ('Eritrea -Asmara ', 'French Polynesia -Papeete ', 19076.257868229997),\n",
              " ('French Polynesia -Papeete ', 'Eritrea -Asmara ', 19076.257868229997),\n",
              " ('Jamaica -Kingston ', 'Cocos Islands -West Island ', 19070.735151948105),\n",
              " ('Cocos Islands -West Island ', 'Jamaica -Kingston ', 19070.7351519481),\n",
              " ('Kiribati -South Tarawa ', 'Liberia -Monrovia ', 19068.60238473354),\n",
              " ('Liberia -Monrovia ', 'Kiribati -South Tarawa ', 19068.60238473354),\n",
              " ('Chile -Santiago ', 'China -Beijing ', 19062.0655596821),\n",
              " ('China -Beijing ', 'Chile -Santiago ', 19062.0655596821),\n",
              " ('Bolivia -Sucre ', 'Vietnam -Hanoi ', 19059.511821120726),\n",
              " ('Vietnam -Hanoi ', 'Bolivia -Sucre ', 19059.511821120726),\n",
              " ('Macao -Macao ', 'Paraguay -Asunción ', 19054.770078185742),\n",
              " ('Paraguay -Asunción ', 'Macao -Macao ', 19054.770078185742),\n",
              " ('Brazil -Brasília ', 'Palau -Melekeok ', 19053.52565731195),\n",
              " ('Palau -Melekeok ', 'Brazil -Brasília ', 19053.52565731195),\n",
              " ('Ghana -Accra ', 'Wallis and Futuna -Mata-Utu ', 19049.712689045067),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Ghana -Accra ', 19049.712689045067),\n",
              " ('Bolivia -Sucre ', 'Taiwan -Taipei ', 19047.070071205693),\n",
              " ('Taiwan -Taipei ', 'Bolivia -Sucre ', 19047.070071205693),\n",
              " ('Colombia -Bogotá ', 'Malaysia -Kuala Lumpur ', 19033.537965551597),\n",
              " ('Malaysia -Kuala Lumpur ', 'Colombia -Bogotá ', 19033.537965551597),\n",
              " ('East Timor -Dili ', 'Martinique -Fort-de-France ', 19027.618875718556),\n",
              " ('Martinique -Fort-de-France ', 'East Timor -Dili ', 19027.618875718556),\n",
              " ('Malaysia -Kuala Lumpur ', 'Peru -Lima ', 19015.494123759687),\n",
              " ('Peru -Lima ', 'Malaysia -Kuala Lumpur ', 19015.494123759687),\n",
              " ('Gibraltar -Gibraltar ', 'Norfolk Island -Kingston ', 19009.17858206889),\n",
              " ('Norfolk Island -Kingston ', 'Gibraltar -Gibraltar ', 19009.17858206889),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Dominican Republic -Santo Domingo ',\n",
              "  19003.11289506692),\n",
              " ('Dominican Republic -Santo Domingo ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  19003.11289506692),\n",
              " ('Benin -Porto-Novo ', 'Samoa -Apia ', 18993.621115689464),\n",
              " ('Samoa -Apia ', 'Benin -Porto-Novo ', 18993.621115689464),\n",
              " ('France -Paris ', 'New Zealand -Wellington ', 18986.64448147206),\n",
              " ('New Zealand -Wellington ', 'France -Paris ', 18986.64448147206),\n",
              " ('Gambia -Banjul ', 'New Caledonia -Noumea ', 18982.02461500152),\n",
              " ('New Caledonia -Noumea ', 'Gambia -Banjul ', 18982.02461500152),\n",
              " ('Marshall Islands -Majuro ', 'Saint Helena -Jamestown ', 18981.663220279203),\n",
              " ('Saint Helena -Jamestown ', 'Marshall Islands -Majuro ', 18981.663220279203),\n",
              " ('Sierra Leone -Freetown ', 'Vanuatu -Port Vila ', 18972.9868013257),\n",
              " ('Vanuatu -Port Vila ', 'Sierra Leone -Freetown ', 18972.9868013257),\n",
              " ('Peru -Lima ', 'Vietnam -Hanoi ', 18970.88259614048),\n",
              " ('Vietnam -Hanoi ', 'Peru -Lima ', 18970.88259614048),\n",
              " ('Niger -Niamey ', 'Niue -Alofi ', 18964.550294823184),\n",
              " ('Niue -Alofi ', 'Niger -Niamey ', 18964.550294823184),\n",
              " ('Mauritania -Nouakchott ', 'Solomon Islands -Honiara ', 18956.786475556422),\n",
              " ('Solomon Islands -Honiara ', 'Mauritania -Nouakchott ', 18956.786475556422),\n",
              " ('Vanuatu -Port Vila ', 'Western Sahara -El Aaiún ', 18955.01262973486),\n",
              " ('Western Sahara -El Aaiún ', 'Vanuatu -Port Vila ', 18955.01262973486),\n",
              " ('Iraq -Baghdad ', 'Pitcairn -Adamstown ', 18952.2906994287),\n",
              " ('Pitcairn -Adamstown ', 'Iraq -Baghdad ', 18952.2906994287),\n",
              " ('Argentina -Buenos Aires ', 'Taiwan -Taipei ', 18952.054783273885),\n",
              " ('Taiwan -Taipei ', 'Argentina -Buenos Aires ', 18952.054783273885),\n",
              " ('Dominica -Roseau ', 'East Timor -Dili ', 18950.100112959015),\n",
              " ('East Timor -Dili ', 'Dominica -Roseau ', 18950.100112959015),\n",
              " ('Burkina Faso -Ouagadougou ', 'Samoa -Apia ', 18945.797578525304),\n",
              " ('Samoa -Apia ', 'Burkina Faso -Ouagadougou ', 18945.797578525304),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Costa Rica -San José ',\n",
              "  18945.574495029025),\n",
              " ('Costa Rica -San José ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18945.574495029025),\n",
              " ('Monaco -Monaco ', 'New Zealand -Wellington ', 18945.294897498323),\n",
              " ('New Zealand -Wellington ', 'Monaco -Monaco ', 18945.294897498323),\n",
              " ('Liberia -Monrovia ', 'Solomon Islands -Honiara ', 18938.57822514029),\n",
              " ('Solomon Islands -Honiara ', 'Liberia -Monrovia ', 18938.57822514029),\n",
              " ('Ghana -Accra ', 'Kiribati -South Tarawa ', 18937.814055237544),\n",
              " ('Kiribati -South Tarawa ', 'Ghana -Accra ', 18937.814055237544),\n",
              " ('Norfolk Island -Kingston ', 'Portugal -Lisbon ', 18907.219411740036),\n",
              " ('Portugal -Lisbon ', 'Norfolk Island -Kingston ', 18907.219411740036),\n",
              " ('Taiwan -Taipei ', 'Uruguay -Montevideo ', 18905.38317600958),\n",
              " ('Uruguay -Montevideo ', 'Taiwan -Taipei ', 18905.38317600958),\n",
              " ('Equatorial Guinea -Malabo ', 'Samoa -Apia ', 18892.644794695087),\n",
              " ('Samoa -Apia ', 'Equatorial Guinea -Malabo ', 18892.644794695087),\n",
              " ('Myanmar -Nay Pyi Taw ', 'Peru -Lima ', 18888.60787160386),\n",
              " ('Peru -Lima ', 'Myanmar -Nay Pyi Taw ', 18888.60787160386),\n",
              " ('Liberia -Monrovia ', 'Tuvalu -Funafuti ', 18886.326258698944),\n",
              " ('Tuvalu -Funafuti ', 'Liberia -Monrovia ', 18886.326258698944),\n",
              " ('American Samoa -Pago Pago ', 'Benin -Porto-Novo ', 18881.780100532033),\n",
              " ('Benin -Porto-Novo ', 'American Samoa -Pago Pago ', 18881.780100532033),\n",
              " ('Nigeria -Abuja ', 'Niue -Alofi ', 18869.52707980633),\n",
              " ('Niue -Alofi ', 'Nigeria -Abuja ', 18869.52707980633),\n",
              " ('East Timor -Dili ', 'Guadeloupe -Basse-Terre ', 18869.49213780642),\n",
              " ('Guadeloupe -Basse-Terre ', 'East Timor -Dili ', 18869.49213780642),\n",
              " ('Samoa -Apia ', 'Togo -Lomé ', 18865.685711657025),\n",
              " ('Togo -Lomé ', 'Samoa -Apia ', 18865.685711657025),\n",
              " (\"Chad -N'Djamena \", 'Cook Islands -Avarua ', 18862.91792392341),\n",
              " ('Cook Islands -Avarua ', \"Chad -N'Djamena \", 18862.91792392341),\n",
              " ('Cameroon -Yaoundé ', 'Samoa -Apia ', 18850.265682365192),\n",
              " ('Samoa -Apia ', 'Cameroon -Yaoundé ', 18850.265682365192),\n",
              " ('Falkland Islands -Stanley ', 'Mongolia -Ulan Bator ', 18843.773581091467),\n",
              " ('Mongolia -Ulan Bator ', 'Falkland Islands -Stanley ', 18843.773581091467),\n",
              " ('American Samoa -Pago Pago ',\n",
              "  'Equatorial Guinea -Malabo ',\n",
              "  18842.843243753825),\n",
              " ('Equatorial Guinea -Malabo ',\n",
              "  'American Samoa -Pago Pago ',\n",
              "  18842.843243753825),\n",
              " ('Guinea-Bissau -Bissau ', 'New Caledonia -Noumea ', 18836.024585644634),\n",
              " ('New Caledonia -Noumea ', 'Guinea-Bissau -Bissau ', 18836.02458564463),\n",
              " ('Cape Verde -Praia ', 'Papua New Guinea -Port Moresby ', 18833.7524423953),\n",
              " ('Papua New Guinea -Port Moresby ', 'Cape Verde -Praia ', 18833.7524423953),\n",
              " ('Cameroon -Yaoundé ', 'American Samoa -Pago Pago ', 18832.260495493818),\n",
              " ('American Samoa -Pago Pago ', 'Cameroon -Yaoundé ', 18832.260495493814),\n",
              " ('Burkina Faso -Ouagadougou ', \"Tonga -Nuku'alofa \", 18831.08697931443),\n",
              " (\"Tonga -Nuku'alofa \", 'Burkina Faso -Ouagadougou ', 18831.08697931443),\n",
              " ('Equatorial Guinea -Malabo ', 'Tuvalu -Funafuti ', 18829.889242576133),\n",
              " ('Tuvalu -Funafuti ', 'Equatorial Guinea -Malabo ', 18829.889242576133),\n",
              " ('New Zealand -Wellington ', 'Switzerland -Berne ', 18826.084561052397),\n",
              " ('Switzerland -Berne ', 'New Zealand -Wellington ', 18826.084561052397),\n",
              " ('Iran -Tehran ', 'Pitcairn -Adamstown ', 18825.307733796686),\n",
              " ('Pitcairn -Adamstown ', 'Iran -Tehran ', 18825.307733796686),\n",
              " ('American Samoa -Pago Pago ',\n",
              "  'Burkina Faso -Ouagadougou ',\n",
              "  18824.355628461628),\n",
              " ('Burkina Faso -Ouagadougou ',\n",
              "  'American Samoa -Pago Pago ',\n",
              "  18824.355628461628),\n",
              " ('Equatorial Guinea -Malabo ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  18824.09754969689),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Equatorial Guinea -Malabo ',\n",
              "  18824.09754969689),\n",
              " ('Brazil -Brasília ', 'Philippines -Manila ', 18817.986587676467),\n",
              " ('Philippines -Manila ', 'Brazil -Brasília ', 18817.986587676467),\n",
              " ('Paraguay -Asunción ', 'Philippines -Manila ', 18816.6515219723),\n",
              " ('Philippines -Manila ', 'Paraguay -Asunción ', 18816.6515219723),\n",
              " ('Peru -Lima ', 'Singapore -Singapore ', 18815.83532443507),\n",
              " ('Singapore -Singapore ', 'Peru -Lima ', 18815.83532443507),\n",
              " ('New Zealand -Wellington ', 'United Kingdom -London ', 18814.288660624734),\n",
              " ('United Kingdom -London ', 'New Zealand -Wellington ', 18814.288660624734),\n",
              " ('Panama -Panama City ', 'Singapore -Singapore ', 18812.59628265387),\n",
              " ('Singapore -Singapore ', 'Panama -Panama City ', 18812.59628265387),\n",
              " ('Mali -Bamako ', 'New Caledonia -Noumea ', 18794.11069638867),\n",
              " ('New Caledonia -Noumea ', 'Mali -Bamako ', 18794.11069638867),\n",
              " ('Cocos Islands -West Island ', 'Cuba -Havana ', 18792.37468280159),\n",
              " ('Cuba -Havana ', 'Cocos Islands -West Island ', 18792.37468280159),\n",
              " (\"Chad -N'Djamena \", 'Wallis and Futuna -Mata-Utu ', 18792.26851275026),\n",
              " ('Wallis and Futuna -Mata-Utu ', \"Chad -N'Djamena \", 18792.26851275026),\n",
              " ('Ivory Coast -Yamoussoukro ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  18786.432876444702),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Ivory Coast -Yamoussoukro ',\n",
              "  18786.432876444702),\n",
              " ('Pitcairn -Adamstown ', 'Yemen -Sanaa ', 18782.445940895588),\n",
              " ('Yemen -Sanaa ', 'Pitcairn -Adamstown ', 18782.445940895588),\n",
              " ('Kiribati -South Tarawa ', 'Togo -Lomé ', 18780.30889601517),\n",
              " ('Togo -Lomé ', 'Kiribati -South Tarawa ', 18780.30889601517),\n",
              " ('Sao Tome and Principe -São Tomé ', 'Tuvalu -Funafuti ', 18780.26604065749),\n",
              " ('Tuvalu -Funafuti ', 'Sao Tome and Principe -São Tomé ', 18780.26604065749),\n",
              " ('East Timor -Dili ', 'Montserrat -Plymouth ', 18777.205440937854),\n",
              " ('Montserrat -Plymouth ', 'East Timor -Dili ', 18777.205440937854),\n",
              " ('Burkina Faso -Ouagadougou ', 'Vanuatu -Port Vila ', 18773.39130772149),\n",
              " ('Vanuatu -Port Vila ', 'Burkina Faso -Ouagadougou ', 18773.39130772149),\n",
              " ('Cayman Islands -George Town ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18771.934654886252),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Cayman Islands -George Town ',\n",
              "  18771.934654886252),\n",
              " (\"Antigua and Barbuda -St. John's \", 'East Timor -Dili ', 18769.45837225117),\n",
              " ('East Timor -Dili ', \"Antigua and Barbuda -St. John's \", 18769.45837225117),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Puerto Rico -San Juan ',\n",
              "  18757.67221989708),\n",
              " ('Puerto Rico -San Juan ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18757.67221989708),\n",
              " ('American Samoa -Pago Pago ', 'Togo -Lomé ', 18749.58548344603),\n",
              " ('Togo -Lomé ', 'American Samoa -Pago Pago ', 18749.58548344603),\n",
              " ('Christmas Island -The Settlement ', 'Ecuador -Quito ', 18743.05260357229),\n",
              " ('Ecuador -Quito ', 'Christmas Island -The Settlement ', 18743.05260357229),\n",
              " ('Costa Rica -San José ', 'Indonesia -Jakarta ', 18742.92334007321),\n",
              " ('Indonesia -Jakarta ', 'Costa Rica -San José ', 18742.92334007321),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Turks and Caicos Islands -Cockburn Town ',\n",
              "  18741.481935579748),\n",
              " ('Turks and Caicos Islands -Cockburn Town ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18741.481935579748),\n",
              " ('Liberia -Monrovia ', 'Vanuatu -Port Vila ', 18740.570322771768),\n",
              " ('Vanuatu -Port Vila ', 'Liberia -Monrovia ', 18740.570322771768),\n",
              " ('Luxembourg -Luxembourg ', 'New Zealand -Wellington ', 18737.291785344634),\n",
              " ('New Zealand -Wellington ', 'Luxembourg -Luxembourg ', 18737.291785344634),\n",
              " ('Mauritania -Nouakchott ', 'Norfolk Island -Kingston ', 18731.952656787827),\n",
              " ('Norfolk Island -Kingston ', 'Mauritania -Nouakchott ', 18731.952656787827),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Mali -Bamako ', 18731.42099955832),\n",
              " ('Mali -Bamako ', 'Wallis and Futuna -Mata-Utu ', 18731.420999558315),\n",
              " ('Bolivia -Sucre ', 'Laos -Vientiane ', 18729.815736156692),\n",
              " ('Laos -Vientiane ', 'Bolivia -Sucre ', 18729.815736156692),\n",
              " ('Kiribati -South Tarawa ', 'Sierra Leone -Freetown ', 18725.275580282847),\n",
              " ('Sierra Leone -Freetown ', 'Kiribati -South Tarawa ', 18725.275580282847),\n",
              " ('Belgium -Brussels ', 'New Zealand -Wellington ', 18723.19604076249),\n",
              " ('New Zealand -Wellington ', 'Belgium -Brussels ', 18723.19604076249),\n",
              " ('Cape Verde -Praia ', 'Vanuatu -Port Vila ', 18715.24284214897),\n",
              " ('Vanuatu -Port Vila ', 'Cape Verde -Praia ', 18715.24284214897),\n",
              " ('Ghana -Accra ', 'Samoa -Apia ', 18712.145943208183),\n",
              " ('Samoa -Apia ', 'Ghana -Accra ', 18712.145943208183),\n",
              " ('Ethiopia -Addis Ababa ', 'French Polynesia -Papeete ', 18709.5992731658),\n",
              " ('French Polynesia -Papeete ', 'Ethiopia -Addis Ababa ', 18709.5992731658),\n",
              " ('Cocos Islands -West Island ', 'Colombia -Bogotá ', 18709.23346791851),\n",
              " ('Colombia -Bogotá ', 'Cocos Islands -West Island ', 18709.23346791851),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Nicaragua -Managua ',\n",
              "  18700.481005392212),\n",
              " ('Nicaragua -Managua ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18700.481005392212),\n",
              " ('Cambodia -Phnom Penh ', 'Ecuador -Quito ', 18699.257469795746),\n",
              " ('Ecuador -Quito ', 'Cambodia -Phnom Penh ', 18699.257469795746),\n",
              " ('Chile -Santiago ', 'Macao -Macao ', 18697.089952420632),\n",
              " ('Macao -Macao ', 'Chile -Santiago ', 18697.089952420632),\n",
              " ('Fiji -Suva ', 'Ivory Coast -Yamoussoukro ', 18693.412507042907),\n",
              " ('Ivory Coast -Yamoussoukro ', 'Fiji -Suva ', 18693.412507042907),\n",
              " ('East Timor -Dili ',\n",
              "  'Saint Kitts and Nevis -Basseterre ',\n",
              "  18692.389912401915),\n",
              " ('Saint Kitts and Nevis -Basseterre ',\n",
              "  'East Timor -Dili ',\n",
              "  18692.389912401915),\n",
              " ('Chile -Santiago ', 'Hong Kong -Hong Kong ', 18686.62618497169),\n",
              " ('Hong Kong -Hong Kong ', 'Chile -Santiago ', 18686.62618497169),\n",
              " ('Cape Verde -Praia ', 'New Caledonia -Noumea ', 18684.86514997219),\n",
              " ('New Caledonia -Noumea ', 'Cape Verde -Praia ', 18684.86514997219),\n",
              " ('Liechtenstein -Vaduz ', 'New Zealand -Wellington ', 18675.40940000771),\n",
              " ('New Zealand -Wellington ', 'Liechtenstein -Vaduz ', 18675.40940000771),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  18674.806819049976),\n",
              " ('U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18674.806819049976),\n",
              " ('Bolivia -Sucre ', 'Cambodia -Phnom Penh ', 18674.524755262224),\n",
              " ('Cambodia -Phnom Penh ', 'Bolivia -Sucre ', 18674.524755262224),\n",
              " ('Ireland -Dublin ', 'New Zealand -Wellington ', 18674.113563825027),\n",
              " ('New Zealand -Wellington ', 'Ireland -Dublin ', 18674.113563825027),\n",
              " ('Cameroon -Yaoundé ', 'Wallis and Futuna -Mata-Utu ', 18670.488343462603),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Cameroon -Yaoundé ', 18670.488343462603),\n",
              " ('Malaysia -Kuala Lumpur ', 'Panama -Panama City ', 18659.667130792273),\n",
              " ('Panama -Panama City ', 'Malaysia -Kuala Lumpur ', 18659.66713079227),\n",
              " ('Cocos Islands -West Island ', 'Haiti -Port-au-Prince ', 18654.101651490135),\n",
              " ('Haiti -Port-au-Prince ', 'Cocos Islands -West Island ', 18654.101651490135),\n",
              " ('Mali -Bamako ', 'Solomon Islands -Honiara ', 18652.413661114646),\n",
              " ('Solomon Islands -Honiara ', 'Mali -Bamako ', 18652.413661114646),\n",
              " ('Sierra Leone -Freetown ', 'Tuvalu -Funafuti ', 18649.293176687544),\n",
              " ('Tuvalu -Funafuti ', 'Sierra Leone -Freetown ', 18649.293176687544),\n",
              " ('Fiji -Suva ', 'Togo -Lomé ', 18647.35710743836),\n",
              " ('Togo -Lomé ', 'Fiji -Suva ', 18647.35710743836),\n",
              " ('Indonesia -Jakarta ', 'Jamaica -Kingston ', 18645.92502782224),\n",
              " ('Jamaica -Kingston ', 'Indonesia -Jakarta ', 18645.92502782224),\n",
              " ('Benin -Porto-Novo ', 'Fiji -Suva ', 18644.471691038827),\n",
              " ('Fiji -Suva ', 'Benin -Porto-Novo ', 18644.471691038827),\n",
              " ('British Virgin Islands -Road Town ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18643.894860060314),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'British Virgin Islands -Road Town ',\n",
              "  18643.894860060314),\n",
              " ('Nigeria -Abuja ', \"Tonga -Nuku'alofa \", 18643.72151083565),\n",
              " (\"Tonga -Nuku'alofa \", 'Nigeria -Abuja ', 18643.72151083565),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'Trinidad and Tobago -Port of Spain ',\n",
              "  18643.517529368593),\n",
              " ('Trinidad and Tobago -Port of Spain ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18643.51752936859),\n",
              " ('Haiti -Port-au-Prince ', 'Indonesia -Jakarta ', 18641.272482515975),\n",
              " ('Indonesia -Jakarta ', 'Haiti -Port-au-Prince ', 18641.272482515975),\n",
              " ('Benin -Porto-Novo ', 'Kiribati -South Tarawa ', 18637.3730718045),\n",
              " ('Kiribati -South Tarawa ', 'Benin -Porto-Novo ', 18637.3730718045),\n",
              " ('East Timor -Dili ', 'Saint Barthélemy -Gustavia ', 18634.151541273364),\n",
              " ('Saint Barthélemy -Gustavia ', 'East Timor -Dili ', 18634.151541273364),\n",
              " ('East Timor -Dili ', 'Venezuela -Caracas ', 18633.20046516391),\n",
              " ('Venezuela -Caracas ', 'East Timor -Dili ', 18633.20046516391),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  \"Grenada -St. George's \",\n",
              "  18632.282453921278),\n",
              " (\"Grenada -St. George's \",\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18632.282453921278),\n",
              " ('China -Beijing ', 'Falkland Islands -Stanley ', 18631.5215910303),\n",
              " ('Falkland Islands -Stanley ', 'China -Beijing ', 18631.5215910303),\n",
              " ('Brazil -Brasília ', 'Guam -Hagåtña ', 18627.395064261153),\n",
              " ('Guam -Hagåtña ', 'Brazil -Brasília ', 18627.395064261153),\n",
              " ('Egypt -Cairo ', 'French Polynesia -Papeete ', 18619.360809988593),\n",
              " ('French Polynesia -Papeete ', 'Egypt -Cairo ', 18619.360809988593),\n",
              " ('Ivory Coast -Yamoussoukro ', 'Vanuatu -Port Vila ', 18617.41567720476),\n",
              " ('Vanuatu -Port Vila ', 'Ivory Coast -Yamoussoukro ', 18617.41567720476),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Trinidad and Tobago -Port of Spain ',\n",
              "  18615.678407148014),\n",
              " ('Trinidad and Tobago -Port of Spain ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18615.678407148014),\n",
              " ('Fiji -Suva ', 'Nigeria -Abuja ', 18611.82581906341),\n",
              " ('Nigeria -Abuja ', 'Fiji -Suva ', 18611.82581906341),\n",
              " ('Fiji -Suva ', 'Ghana -Accra ', 18608.508536466055),\n",
              " ('Ghana -Accra ', 'Fiji -Suva ', 18608.508536466055),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'Dominican Republic -Santo Domingo ',\n",
              "  18606.26598220898),\n",
              " ('Dominican Republic -Santo Domingo ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18606.265982208977),\n",
              " (\"Grenada -St. George's \", 'Indonesia -Jakarta ', 18605.182625903097),\n",
              " ('Indonesia -Jakarta ', \"Grenada -St. George's \", 18605.182625903097),\n",
              " ('East Timor -Dili ', 'Saint Martin -Marigot ', 18603.784319226543),\n",
              " ('Saint Martin -Marigot ', 'East Timor -Dili ', 18603.784319226543),\n",
              " ('Guinea -Conakry ', 'Kiribati -South Tarawa ', 18599.175752978794),\n",
              " ('Kiribati -South Tarawa ', 'Guinea -Conakry ', 18599.175752978794),\n",
              " ('New Zealand -Wellington ', 'Tunisia -Tunis ', 18598.74563457637),\n",
              " ('Tunisia -Tunis ', 'New Zealand -Wellington ', 18598.74563457637),\n",
              " ('Guinea -Conakry ', 'New Caledonia -Noumea ', 18598.41100475459),\n",
              " ('New Caledonia -Noumea ', 'Guinea -Conakry ', 18598.41100475459),\n",
              " ('Guinea -Conakry ', 'Tuvalu -Funafuti ', 18597.320529287506),\n",
              " ('Tuvalu -Funafuti ', 'Guinea -Conakry ', 18597.320529287506),\n",
              " ('American Samoa -Pago Pago ', 'Ghana -Accra ', 18593.646688233424),\n",
              " ('Ghana -Accra ', 'American Samoa -Pago Pago ', 18593.646688233424),\n",
              " ('Anguilla -The Valley ', 'East Timor -Dili ', 18592.87961428517),\n",
              " ('East Timor -Dili ', 'Anguilla -The Valley ', 18592.87961428517),\n",
              " ('Chile -Santiago ', 'Vietnam -Hanoi ', 18589.28756851499),\n",
              " ('Vietnam -Hanoi ', 'Chile -Santiago ', 18589.287568514985),\n",
              " ('Aruba -Oranjestad ', 'Cocos Islands -West Island ', 18586.26759775528),\n",
              " ('Cocos Islands -West Island ', 'Aruba -Oranjestad ', 18586.26759775528),\n",
              " ('Isle of Man -Douglas ', 'New Zealand -Wellington ', 18584.096082732318),\n",
              " ('New Zealand -Wellington ', 'Isle of Man -Douglas ', 18584.096082732318),\n",
              " ('Paraguay -Asunción ', 'South Korea -Seoul ', 18582.62549353993),\n",
              " ('South Korea -Seoul ', 'Paraguay -Asunción ', 18582.62549353993),\n",
              " ('Falkland Islands -Stanley ', 'North Korea -Pyongyang ', 18578.938408589212),\n",
              " ('North Korea -Pyongyang ', 'Falkland Islands -Stanley ', 18578.938408589212),\n",
              " ('Japan -Edo ', 'Uruguay -Montevideo ', 18573.49942762694),\n",
              " ('Uruguay -Montevideo ', 'Japan -Edo ', 18573.49942762694),\n",
              " ('Cook Islands -Avarua ', 'Sudan -Khartoum ', 18572.555062328847),\n",
              " ('Sudan -Khartoum ', 'Cook Islands -Avarua ', 18572.555062328847),\n",
              " ('Burkina Faso -Ouagadougou ', 'Niue -Alofi ', 18567.645455127542),\n",
              " ('Niue -Alofi ', 'Burkina Faso -Ouagadougou ', 18567.645455127542),\n",
              " ('Netherlands -Amsterdam ', 'New Zealand -Wellington ', 18565.79836308644),\n",
              " ('New Zealand -Wellington ', 'Netherlands -Amsterdam ', 18565.79836308644),\n",
              " ('Gabon -Libreville ', 'Tuvalu -Funafuti ', 18562.970499237777),\n",
              " ('Tuvalu -Funafuti ', 'Gabon -Libreville ', 18562.970499237777),\n",
              " ('Cameroon -Yaoundé ', 'Tuvalu -Funafuti ', 18557.70104168898),\n",
              " ('Tuvalu -Funafuti ', 'Cameroon -Yaoundé ', 18557.70104168898),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Saint Vincent and the Grenadines -Kingstown ',\n",
              "  18557.281963134657),\n",
              " ('Saint Vincent and the Grenadines -Kingstown ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18557.281963134657),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Honduras -Tegucigalpa ',\n",
              "  18556.908193084866),\n",
              " ('Honduras -Tegucigalpa ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18556.908193084866),\n",
              " ('Morocco -Rabat ', 'New Caledonia -Noumea ', 18555.270383003273),\n",
              " ('New Caledonia -Noumea ', 'Morocco -Rabat ', 18555.270383003273),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Colombia -Bogotá ', 18554.459507396594),\n",
              " ('Colombia -Bogotá ', 'Brunei -Bandar Seri Begawan ', 18554.459507396594),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Saint Kitts and Nevis -Basseterre ',\n",
              "  18549.96359395134),\n",
              " ('Saint Kitts and Nevis -Basseterre ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18549.96359395134),\n",
              " ('Brazil -Brasília ', 'Northern Mariana Islands -Saipan ', 18548.1417633528),\n",
              " ('Northern Mariana Islands -Saipan ', 'Brazil -Brasília ', 18548.1417633528),\n",
              " ('New Zealand -Wellington ', 'Vatican -Vatican ', 18546.74931985687),\n",
              " ('Vatican -Vatican ', 'New Zealand -Wellington ', 18546.74931985687),\n",
              " ('Cocos Islands -West Island ', 'Ecuador -Quito ', 18544.535321394666),\n",
              " ('Ecuador -Quito ', 'Cocos Islands -West Island ', 18544.535321394666),\n",
              " ('Italy -Rome ', 'New Zealand -Wellington ', 18544.206355934446),\n",
              " ('New Zealand -Wellington ', 'Italy -Rome ', 18544.206355934446),\n",
              " ('Cook Islands -Avarua ', 'Libya -Tripoli ', 18543.553444402263),\n",
              " ('Libya -Tripoli ', 'Cook Islands -Avarua ', 18543.553444402263),\n",
              " ('New Zealand -Wellington ', 'San Marino -San Marino ', 18542.481210350896),\n",
              " ('San Marino -San Marino ', 'New Zealand -Wellington ', 18542.481210350896),\n",
              " ('Sao Tome and Principe -São Tomé ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  18541.209511127694),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Sao Tome and Principe -São Tomé ',\n",
              "  18541.209511127694),\n",
              " ('Norfolk Island -Kingston ', 'Spain -Madrid ', 18541.055288390868),\n",
              " ('Spain -Madrid ', 'Norfolk Island -Kingston ', 18541.055288390868),\n",
              " ('Cook Islands -Avarua ', 'Egypt -Cairo ', 18536.507923211935),\n",
              " ('Egypt -Cairo ', 'Cook Islands -Avarua ', 18536.507923211935),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Saint Martin -Marigot ',\n",
              "  18535.85862323727),\n",
              " ('Saint Martin -Marigot ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18535.85862323727),\n",
              " (\"Chad -N'Djamena \", \"Tonga -Nuku'alofa \", 18534.230700402637),\n",
              " (\"Tonga -Nuku'alofa \", \"Chad -N'Djamena \", 18534.230700402637),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Montserrat -Plymouth ',\n",
              "  18531.76996330664),\n",
              " ('Montserrat -Plymouth ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18531.76996330664),\n",
              " ('French Polynesia -Papeete ', 'Yemen -Sanaa ', 18526.025519286697),\n",
              " ('Yemen -Sanaa ', 'French Polynesia -Papeete ', 18526.025519286697),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Saint Barthélemy -Gustavia ',\n",
              "  18525.74894512477),\n",
              " ('Saint Barthélemy -Gustavia ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18525.74894512477),\n",
              " ('Anguilla -The Valley ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18524.82008604113),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Anguilla -The Valley ',\n",
              "  18524.82008604113),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Guadeloupe -Basse-Terre ',\n",
              "  18518.32564907366),\n",
              " ('Guadeloupe -Basse-Terre ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18518.32564907366),\n",
              " ('American Samoa -Pago Pago ',\n",
              "  'Central African Republic -Bangui ',\n",
              "  18517.094559560624),\n",
              " ('Central African Republic -Bangui ',\n",
              "  'American Samoa -Pago Pago ',\n",
              "  18517.094559560624),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Saint Lucia -Castries ',\n",
              "  18515.212615615656),\n",
              " ('Saint Lucia -Castries ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18515.212615615656),\n",
              " ('Gabon -Libreville ', 'Samoa -Apia ', 18514.631639726667),\n",
              " ('Samoa -Apia ', 'Gabon -Libreville ', 18514.631639726667),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Dominica -Roseau ',\n",
              "  18512.653266902107),\n",
              " ('Dominica -Roseau ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18512.653266902107),\n",
              " ('Chile -Santiago ', 'Taiwan -Taipei ', 18510.26290003742),\n",
              " ('Taiwan -Taipei ', 'Chile -Santiago ', 18510.26290003742),\n",
              " ('Brazil -Brasília ', 'Taiwan -Taipei ', 18510.18831022871),\n",
              " ('Taiwan -Taipei ', 'Brazil -Brasília ', 18510.18831022871),\n",
              " ('Ecuador -Quito ', 'Thailand -Bangkok ', 18507.890493450057),\n",
              " ('Thailand -Bangkok ', 'Ecuador -Quito ', 18507.890493450057),\n",
              " ('Liberia -Monrovia ', 'Marshall Islands -Majuro ', 18506.69885066144),\n",
              " ('Marshall Islands -Majuro ', 'Liberia -Monrovia ', 18506.69885066144),\n",
              " ('Samoa -Apia ', 'Sao Tome and Principe -São Tomé ', 18506.032899790287),\n",
              " ('Sao Tome and Principe -São Tomé ', 'Samoa -Apia ', 18506.032899790287),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Martinique -Fort-de-France ',\n",
              "  18503.70487208246),\n",
              " ('Martinique -Fort-de-France ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18503.70487208246),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Guyana -Georgetown ', 18502.20454071364),\n",
              " ('Guyana -Georgetown ', 'Brunei -Bandar Seri Begawan ', 18502.20454071364),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'Saint Vincent and the Grenadines -Kingstown ',\n",
              "  18496.984304187128),\n",
              " ('Saint Vincent and the Grenadines -Kingstown ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18496.984304187128),\n",
              " ('Djibouti -Djibouti ', 'French Polynesia -Papeete ', 18495.954334780858),\n",
              " ('French Polynesia -Papeete ', 'Djibouti -Djibouti ', 18495.954334780858),\n",
              " ('Fiji -Suva ', 'Mauritania -Nouakchott ', 18491.53810072931),\n",
              " ('Mauritania -Nouakchott ', 'Fiji -Suva ', 18491.53810072931),\n",
              " ('Costa Rica -San José ', 'Singapore -Singapore ', 18489.62359648839),\n",
              " ('Singapore -Singapore ', 'Costa Rica -San José ', 18489.62359648839),\n",
              " ('New Caledonia -Noumea ', 'Sierra Leone -Freetown ', 18480.265160910385),\n",
              " ('Sierra Leone -Freetown ', 'New Caledonia -Noumea ', 18480.265160910385),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Peru -Lima ', 18479.982205885106),\n",
              " ('Peru -Lima ', 'Brunei -Bandar Seri Begawan ', 18479.982205885106),\n",
              " (\"Antigua and Barbuda -St. John's \",\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18476.959582760315),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  \"Antigua and Barbuda -St. John's \",\n",
              "  18476.959582760315),\n",
              " ('Kiribati -South Tarawa ',\n",
              "  'Sao Tome and Principe -São Tomé ',\n",
              "  18475.057858069325),\n",
              " ('Sao Tome and Principe -São Tomé ',\n",
              "  'Kiribati -South Tarawa ',\n",
              "  18475.057858069325),\n",
              " ('American Samoa -Pago Pago ', 'Gabon -Libreville ', 18470.52722308443),\n",
              " ('Gabon -Libreville ', 'American Samoa -Pago Pago ', 18470.52722308443),\n",
              " ('Central African Republic -Bangui ', 'Samoa -Apia ', 18469.302468139904),\n",
              " ('Samoa -Apia ', 'Central African Republic -Bangui ', 18469.302468139904),\n",
              " ('Libya -Tripoli ', \"Tonga -Nuku'alofa \", 18468.058420489248),\n",
              " (\"Tonga -Nuku'alofa \", 'Libya -Tripoli ', 18468.058420489248),\n",
              " ('Niger -Niamey ', 'Vanuatu -Port Vila ', 18466.24613593585),\n",
              " ('Vanuatu -Port Vila ', 'Niger -Niamey ', 18466.24613593585),\n",
              " ('Argentina -Buenos Aires ', 'Hong Kong -Hong Kong ', 18464.44161442968),\n",
              " ('Hong Kong -Hong Kong ', 'Argentina -Buenos Aires ', 18464.44161442968),\n",
              " ('British Virgin Islands -Road Town ',\n",
              "  'East Timor -Dili ',\n",
              "  18461.93619900695),\n",
              " ('East Timor -Dili ',\n",
              "  'British Virgin Islands -Road Town ',\n",
              "  18461.93619900695),\n",
              " ('Fiji -Suva ', 'Western Sahara -El Aaiún ', 18457.058163701215),\n",
              " ('Western Sahara -El Aaiún ', 'Fiji -Suva ', 18457.058163701215),\n",
              " ('Kiribati -South Tarawa ', 'Mali -Bamako ', 18456.84938712921),\n",
              " ('Mali -Bamako ', 'Kiribati -South Tarawa ', 18456.84938712921),\n",
              " ('North Korea -Pyongyang ', 'Paraguay -Asunción ', 18455.761298347603),\n",
              " ('Paraguay -Asunción ', 'North Korea -Pyongyang ', 18455.761298347603),\n",
              " ('Bahamas -Nassau ', 'Cocos Islands -West Island ', 18454.949333905974),\n",
              " ('Cocos Islands -West Island ', 'Bahamas -Nassau ', 18454.949333905974),\n",
              " ('Gabon -Libreville ', 'Wallis and Futuna -Mata-Utu ', 18453.817089041368),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Gabon -Libreville ', 18453.817089041364),\n",
              " ('Jordan -Amman ', 'Pitcairn -Adamstown ', 18453.574923983877),\n",
              " ('Pitcairn -Adamstown ', 'Jordan -Amman ', 18453.574923983877),\n",
              " ('Indonesia -Jakarta ', 'Puerto Rico -San Juan ', 18452.849177719083),\n",
              " ('Puerto Rico -San Juan ', 'Indonesia -Jakarta ', 18452.849177719083),\n",
              " ('Bolivia -Sucre ', 'Brunei -Bandar Seri Begawan ', 18448.210793461614),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Bolivia -Sucre ', 18448.210793461614),\n",
              " ('Libya -Tripoli ', 'Niue -Alofi ', 18447.52311311478),\n",
              " ('Niue -Alofi ', 'Libya -Tripoli ', 18447.52311311478),\n",
              " ('East Timor -Dili ',\n",
              "  'U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  18444.070535126117),\n",
              " ('U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  'East Timor -Dili ',\n",
              "  18444.070535126117),\n",
              " ('Eritrea -Asmara ', 'Pitcairn -Adamstown ', 18440.76444489435),\n",
              " ('Pitcairn -Adamstown ', 'Eritrea -Asmara ', 18440.76444489435),\n",
              " ('American Samoa -Pago Pago ',\n",
              "  'Sao Tome and Principe -São Tomé ',\n",
              "  18439.48475181674),\n",
              " ('Sao Tome and Principe -São Tomé ',\n",
              "  'American Samoa -Pago Pago ',\n",
              "  18439.48475181674),\n",
              " ('Cocos Islands -West Island ',\n",
              "  'Dominican Republic -Santo Domingo ',\n",
              "  18435.680254221275),\n",
              " ('Dominican Republic -Santo Domingo ',\n",
              "  'Cocos Islands -West Island ',\n",
              "  18435.680254221275),\n",
              " ('Indonesia -Jakarta ', 'Nicaragua -Managua ', 18434.271321649998),\n",
              " ('Nicaragua -Managua ', 'Indonesia -Jakarta ', 18434.271321649998),\n",
              " ('French Guiana -Cayenne ', 'Palau -Melekeok ', 18432.417020678182),\n",
              " ('Palau -Melekeok ', 'French Guiana -Cayenne ', 18432.417020678182),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Ecuador -Quito ', 18430.237854089122),\n",
              " ('Ecuador -Quito ', 'Brunei -Bandar Seri Begawan ', 18430.237854089122),\n",
              " ('Indonesia -Jakarta ', 'Saint Lucia -Castries ', 18429.779726156055),\n",
              " ('Saint Lucia -Castries ', 'Indonesia -Jakarta ', 18429.779726156055),\n",
              " ('Costa Rica -San José ', 'Malaysia -Kuala Lumpur ', 18427.49454946237),\n",
              " ('Malaysia -Kuala Lumpur ', 'Costa Rica -San José ', 18427.49454946237),\n",
              " ('Argentina -Buenos Aires ', 'Macao -Macao ', 18426.90778333736),\n",
              " ('Macao -Macao ', 'Argentina -Buenos Aires ', 18426.90778333736),\n",
              " ('Ivory Coast -Yamoussoukro ',\n",
              "  'Marshall Islands -Majuro ',\n",
              "  18424.64133766696),\n",
              " ('Marshall Islands -Majuro ',\n",
              "  'Ivory Coast -Yamoussoukro ',\n",
              "  18424.64133766696),\n",
              " ('Macao -Macao ', 'Peru -Lima ', 18422.686376078047),\n",
              " ('Peru -Lima ', 'Macao -Macao ', 18422.686376078047),\n",
              " ('Chile -Santiago ', 'North Korea -Pyongyang ', 18422.319759828013),\n",
              " ('North Korea -Pyongyang ', 'Chile -Santiago ', 18422.319759828013),\n",
              " ('Benin -Porto-Novo ', 'Niue -Alofi ', 18401.000162399683),\n",
              " ('Niue -Alofi ', 'Benin -Porto-Novo ', 18401.000162399683),\n",
              " ('Falkland Islands -Stanley ', 'South Korea -Seoul ', 18399.030800650868),\n",
              " ('South Korea -Seoul ', 'Falkland Islands -Stanley ', 18399.030800650864),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  18398.495499200642),\n",
              " ('U.S. Virgin Islands -Charlotte Amalie ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18398.495499200642),\n",
              " ('Indonesia -Jakarta ', 'Martinique -Fort-de-France ', 18398.283264718393),\n",
              " ('Martinique -Fort-de-France ', 'Indonesia -Jakarta ', 18398.283264718393),\n",
              " ('Pitcairn -Adamstown ', 'Syria -Damascus ', 18398.093766523216),\n",
              " ('Syria -Damascus ', 'Pitcairn -Adamstown ', 18398.093766523216),\n",
              " ('Fiji -Suva ', 'Guinea -Conakry ', 18395.665265593358),\n",
              " ('Guinea -Conakry ', 'Fiji -Suva ', 18395.665265593358),\n",
              " ('Chile -Santiago ', 'Mongolia -Ulan Bator ', 18395.13440566146),\n",
              " ('Mongolia -Ulan Bator ', 'Chile -Santiago ', 18395.13440566146),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Suriname -Paramaribo ', 18387.80953040417),\n",
              " ('Suriname -Paramaribo ', 'Brunei -Bandar Seri Begawan ', 18387.80953040417),\n",
              " ('Barbados -Bridgetown ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18387.68890859897),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Barbados -Bridgetown ',\n",
              "  18387.68890859897),\n",
              " ('Bolivia -Sucre ', 'Thailand -Bangkok ', 18387.45728196912),\n",
              " ('Thailand -Bangkok ', 'Bolivia -Sucre ', 18387.45728196912),\n",
              " ('Kiribati -South Tarawa ', 'Saint Helena -Jamestown ', 18384.317116981092),\n",
              " ('Saint Helena -Jamestown ', 'Kiribati -South Tarawa ', 18384.317116981092),\n",
              " ('Indonesia -Jakarta ', 'Dominica -Roseau ', 18381.71026294626),\n",
              " ('Dominica -Roseau ', 'Indonesia -Jakarta ', 18381.710262946257),\n",
              " ('Burkina Faso -Ouagadougou ', 'Kiribati -South Tarawa ', 18375.583018609712),\n",
              " ('Kiribati -South Tarawa ', 'Burkina Faso -Ouagadougou ', 18375.583018609712),\n",
              " ('Pitcairn -Adamstown ', 'Turkmenistan -Ashkhabad ', 18374.597588887904),\n",
              " ('Turkmenistan -Ashkhabad ', 'Pitcairn -Adamstown ', 18374.597588887904),\n",
              " ('British Virgin Islands -Road Town ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18372.47989691249),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'British Virgin Islands -Road Town ',\n",
              "  18372.47989691249),\n",
              " ('Benin -Porto-Novo ', \"Tonga -Nuku'alofa \", 18371.188567244808),\n",
              " (\"Tonga -Nuku'alofa \", 'Benin -Porto-Novo ', 18371.188567244808),\n",
              " ('Algeria -Algiers ', 'Norfolk Island -Kingston ', 18371.185994537398),\n",
              " ('Norfolk Island -Kingston ', 'Algeria -Algiers ', 18371.185994537398),\n",
              " ('Argentina -Buenos Aires ', 'Japan -Edo ', 18370.161743417168),\n",
              " ('Japan -Edo ', 'Argentina -Buenos Aires ', 18370.161743417164),\n",
              " ('Cocos Islands -West Island ',\n",
              "  'Turks and Caicos Islands -Cockburn Town ',\n",
              "  18369.89976992137),\n",
              " ('Turks and Caicos Islands -Cockburn Town ',\n",
              "  'Cocos Islands -West Island ',\n",
              "  18369.89976992137),\n",
              " ('Hong Kong -Hong Kong ', 'Peru -Lima ', 18369.77393131013),\n",
              " ('Peru -Lima ', 'Hong Kong -Hong Kong ', 18369.77393131013),\n",
              " ('Ivory Coast -Yamoussoukro ',\n",
              "  'Solomon Islands -Honiara ',\n",
              "  18363.78647678329),\n",
              " ('Solomon Islands -Honiara ',\n",
              "  'Ivory Coast -Yamoussoukro ',\n",
              "  18363.78647678329),\n",
              " ('Christmas Island -The Settlement ', 'Cuba -Havana ', 18362.916363786786),\n",
              " ('Cuba -Havana ', 'Christmas Island -The Settlement ', 18362.916363786786),\n",
              " ('Indonesia -Jakarta ', 'Guadeloupe -Basse-Terre ', 18361.836261185745),\n",
              " ('Guadeloupe -Basse-Terre ', 'Indonesia -Jakarta ', 18361.83626118574),\n",
              " ('Fiji -Suva ', 'Liberia -Monrovia ', 18360.59140614096),\n",
              " ('Liberia -Monrovia ', 'Fiji -Suva ', 18360.59140614096),\n",
              " ('Mali -Bamako ', \"Tonga -Nuku'alofa \", 18360.14715738053),\n",
              " (\"Tonga -Nuku'alofa \", 'Mali -Bamako ', 18360.14715738053),\n",
              " ('Fiji -Suva ', 'Sierra Leone -Freetown ', 18358.699226120825),\n",
              " ('Sierra Leone -Freetown ', 'Fiji -Suva ', 18358.699226120825),\n",
              " ('Chile -Santiago ', 'South Korea -Seoul ', 18358.17779848032),\n",
              " ('South Korea -Seoul ', 'Chile -Santiago ', 18358.17779848032),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'El Salvador -San Salvador ',\n",
              "  18358.16822653026),\n",
              " ('El Salvador -San Salvador ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18358.16822653026),\n",
              " ('Guyana -Georgetown ', 'Indonesia -Jakarta ', 18357.80139911773),\n",
              " ('Indonesia -Jakarta ', 'Guyana -Georgetown ', 18357.80139911773),\n",
              " ('Djibouti -Djibouti ', 'Pitcairn -Adamstown ', 18356.445090239406),\n",
              " ('Pitcairn -Adamstown ', 'Djibouti -Djibouti ', 18356.445090239406),\n",
              " ('Bahamas -Nassau ', 'Christmas Island -The Settlement ', 18356.316544816964),\n",
              " ('Christmas Island -The Settlement ', 'Bahamas -Nassau ', 18356.316544816964),\n",
              " ('Guinea-Bissau -Bissau ', 'Tuvalu -Funafuti ', 18354.802931492937),\n",
              " ('Tuvalu -Funafuti ', 'Guinea-Bissau -Bissau ', 18354.802931492937),\n",
              " ('Fiji -Suva ', 'Guinea-Bissau -Bissau ', 18354.360655095952),\n",
              " ('Guinea-Bissau -Bissau ', 'Fiji -Suva ', 18354.360655095952),\n",
              " ('Singapore -Singapore ', 'Venezuela -Caracas ', 18351.492364510075),\n",
              " ('Venezuela -Caracas ', 'Singapore -Singapore ', 18351.492364510075),\n",
              " ('Indonesia -Jakarta ', 'Montserrat -Plymouth ', 18347.806899002557),\n",
              " ('Montserrat -Plymouth ', 'Indonesia -Jakarta ', 18347.806899002557),\n",
              " ('New Zealand -Wellington ', 'Slovenia -Ljubljana ', 18347.4634156307),\n",
              " ('Slovenia -Ljubljana ', 'New Zealand -Wellington ', 18347.4634156307),\n",
              " ('Barbados -Bridgetown ', 'Indonesia -Jakarta ', 18346.71785568853),\n",
              " ('Indonesia -Jakarta ', 'Barbados -Bridgetown ', 18346.71785568853),\n",
              " ('Ivory Coast -Yamoussoukro ', 'Samoa -Apia ', 18345.23346446972),\n",
              " ('Samoa -Apia ', 'Ivory Coast -Yamoussoukro ', 18345.23346446972),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'Saint Kitts and Nevis -Basseterre ',\n",
              "  18341.781631399772),\n",
              " ('Saint Kitts and Nevis -Basseterre ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18341.781631399772),\n",
              " ('East Timor -Dili ', 'Puerto Rico -San Juan ', 18340.614047279156),\n",
              " ('Puerto Rico -San Juan ', 'East Timor -Dili ', 18340.614047279156),\n",
              " ('Aruba -Oranjestad ', 'Singapore -Singapore ', 18337.481700428765),\n",
              " ('Singapore -Singapore ', 'Aruba -Oranjestad ', 18337.481700428765),\n",
              " ('Hong Kong -Hong Kong ', 'Uruguay -Montevideo ', 18333.150125674303),\n",
              " ('Uruguay -Montevideo ', 'Hong Kong -Hong Kong ', 18333.150125674303),\n",
              " ('Burkina Faso -Ouagadougou ', 'New Caledonia -Noumea ', 18331.730174151675),\n",
              " ('New Caledonia -Noumea ', 'Burkina Faso -Ouagadougou ', 18331.730174151675),\n",
              " ('Ghana -Accra ', 'Marshall Islands -Majuro ', 18326.49477211315),\n",
              " ('Marshall Islands -Majuro ', 'Ghana -Accra ', 18326.49477211315),\n",
              " ('Fiji -Suva ', 'Gambia -Banjul ', 18326.385973351575),\n",
              " ('Gambia -Banjul ', 'Fiji -Suva ', 18326.385973351575),\n",
              " ('Norfolk Island -Kingston ', 'Senegal -Dakar ', 18324.29997790429),\n",
              " ('Senegal -Dakar ', 'Norfolk Island -Kingston ', 18324.29997790429),\n",
              " ('Cameroon -Yaoundé ', 'Niue -Alofi ', 18318.8354640318),\n",
              " ('Niue -Alofi ', 'Cameroon -Yaoundé ', 18318.8354640318),\n",
              " ('French Polynesia -Papeete ', 'Jordan -Amman ', 18317.30393892893),\n",
              " ('Jordan -Amman ', 'French Polynesia -Papeete ', 18317.30393892893),\n",
              " ('Lebanon -Beirut ', 'Pitcairn -Adamstown ', 18312.921617398497),\n",
              " ('Pitcairn -Adamstown ', 'Lebanon -Beirut ', 18312.921617398497),\n",
              " ('Azerbaijan -Baku ', 'Pitcairn -Adamstown ', 18312.718084960274),\n",
              " ('Pitcairn -Adamstown ', 'Azerbaijan -Baku ', 18312.718084960274),\n",
              " ('Cayman Islands -George Town ', 'Indonesia -Jakarta ', 18310.39709090257),\n",
              " ('Indonesia -Jakarta ', 'Cayman Islands -George Town ', 18310.39709090257),\n",
              " ('Equatorial Guinea -Malabo ', 'Niue -Alofi ', 18306.870653455422),\n",
              " ('Niue -Alofi ', 'Equatorial Guinea -Malabo ', 18306.870653455422),\n",
              " ('Indonesia -Jakarta ',\n",
              "  'Turks and Caicos Islands -Cockburn Town ',\n",
              "  18305.655910008907),\n",
              " ('Turks and Caicos Islands -Cockburn Town ',\n",
              "  'Indonesia -Jakarta ',\n",
              "  18305.655910008907),\n",
              " ('Togo -Lomé ', \"Tonga -Nuku'alofa \", 18304.047343234288),\n",
              " (\"Tonga -Nuku'alofa \", 'Togo -Lomé ', 18304.047343234288),\n",
              " ('Indonesia -Jakarta ', 'Saint Martin -Marigot ', 18302.660688421427),\n",
              " ('Saint Martin -Marigot ', 'Indonesia -Jakarta ', 18302.660688421427),\n",
              " ('Indonesia -Jakarta ', 'Saint Barthélemy -Gustavia ', 18300.74126192471),\n",
              " ('Saint Barthélemy -Gustavia ', 'Indonesia -Jakarta ', 18300.74126192471),\n",
              " ('China -Beijing ', 'Paraguay -Asunción ', 18298.42740725337),\n",
              " ('Paraguay -Asunción ', 'China -Beijing ', 18298.42740725337),\n",
              " ('Macao -Macao ', 'Uruguay -Montevideo ', 18290.922805006143),\n",
              " ('Uruguay -Montevideo ', 'Macao -Macao ', 18290.922805006143),\n",
              " ('Cook Islands -Avarua ', 'Malta -Valletta ', 18290.032500840385),\n",
              " ('Malta -Valletta ', 'Cook Islands -Avarua ', 18290.032500840385),\n",
              " (\"Antigua and Barbuda -St. John's \",\n",
              "  'Indonesia -Jakarta ',\n",
              "  18288.674903373918),\n",
              " ('Indonesia -Jakarta ',\n",
              "  \"Antigua and Barbuda -St. John's \",\n",
              "  18288.674903373918),\n",
              " ('Anguilla -The Valley ', 'Indonesia -Jakarta ', 18288.643565584458),\n",
              " ('Indonesia -Jakarta ', 'Anguilla -The Valley ', 18288.643565584458),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Venezuela -Caracas ', 18287.451217259626),\n",
              " ('Venezuela -Caracas ', 'Brunei -Bandar Seri Begawan ', 18287.451217259626),\n",
              " ('Niue -Alofi ', 'Togo -Lomé ', 18287.161918056536),\n",
              " ('Togo -Lomé ', 'Niue -Alofi ', 18287.161918056536),\n",
              " ('New Zealand -Wellington ', 'Western Sahara -El Aaiún ', 18283.035119253553),\n",
              " ('Western Sahara -El Aaiún ', 'New Zealand -Wellington ', 18283.035119253553),\n",
              " ('Gibraltar -Gibraltar ', 'New Caledonia -Noumea ', 18282.84003796873),\n",
              " ('New Caledonia -Noumea ', 'Gibraltar -Gibraltar ', 18282.840037968726),\n",
              " ('Belize -Belmopan ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18281.128627723516),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Belize -Belmopan ',\n",
              "  18281.128627723516),\n",
              " ('Fiji -Suva ', 'Senegal -Dakar ', 18279.1512657717),\n",
              " ('Senegal -Dakar ', 'Fiji -Suva ', 18279.1512657717),\n",
              " ('Algeria -Algiers ', \"Tonga -Nuku'alofa \", 18269.92471335346),\n",
              " (\"Tonga -Nuku'alofa \", 'Algeria -Algiers ', 18269.92471335346),\n",
              " ('Guinea-Bissau -Bissau ', 'Kiribati -South Tarawa ', 18268.8196154444),\n",
              " ('Kiribati -South Tarawa ', 'Guinea-Bissau -Bissau ', 18268.8196154444),\n",
              " ('Paraguay -Asunción ', 'Vietnam -Hanoi ', 18261.902148976325),\n",
              " ('Vietnam -Hanoi ', 'Paraguay -Asunción ', 18261.902148976325),\n",
              " ('Armenia -Yerevan ', 'Pitcairn -Adamstown ', 18261.727201090678),\n",
              " ('Pitcairn -Adamstown ', 'Armenia -Yerevan ', 18261.727201090674),\n",
              " (\"Chad -N'Djamena \", 'French Polynesia -Papeete ', 18255.403427026755),\n",
              " ('French Polynesia -Papeete ', \"Chad -N'Djamena \", 18255.403427026755),\n",
              " ('Aruba -Oranjestad ', 'East Timor -Dili ', 18254.344575914776),\n",
              " ('East Timor -Dili ', 'Aruba -Oranjestad ', 18254.344575914776),\n",
              " ('Mali -Bamako ', 'Samoa -Apia ', 18253.841539067656),\n",
              " ('Samoa -Apia ', 'Mali -Bamako ', 18253.841539067656),\n",
              " ('Honduras -Tegucigalpa ', 'Indonesia -Jakarta ', 18246.006178519103),\n",
              " ('Indonesia -Jakarta ', 'Honduras -Tegucigalpa ', 18246.006178519103),\n",
              " ('Papua New Guinea -Port Moresby ', 'Senegal -Dakar ', 18244.589394827668),\n",
              " ('Senegal -Dakar ', 'Papua New Guinea -Port Moresby ', 18244.589394827668),\n",
              " ('Croatia -Zagreb ', 'New Zealand -Wellington ', 18240.236832557723),\n",
              " ('New Zealand -Wellington ', 'Croatia -Zagreb ', 18240.236832557723),\n",
              " (\"Chad -N'Djamena \", 'Tuvalu -Funafuti ', 18236.27828666283),\n",
              " ('Tuvalu -Funafuti ', \"Chad -N'Djamena \", 18236.27828666283),\n",
              " ('Brunei -Bandar Seri Begawan ',\n",
              "  'Trinidad and Tobago -Port of Spain ',\n",
              "  18235.909319593302),\n",
              " ('Trinidad and Tobago -Port of Spain ',\n",
              "  'Brunei -Bandar Seri Begawan ',\n",
              "  18235.909319593302),\n",
              " ('Liberia -Monrovia ', 'Wallis and Futuna -Mata-Utu ', 18235.10582802981),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Liberia -Monrovia ', 18235.10582802981),\n",
              " ('Cocos Islands -West Island ', 'Venezuela -Caracas ', 18228.552553407215),\n",
              " ('Venezuela -Caracas ', 'Cocos Islands -West Island ', 18228.552553407215),\n",
              " ('Brunei -Bandar Seri Begawan ',\n",
              "  'French Guiana -Cayenne ',\n",
              "  18226.239957438705),\n",
              " ('French Guiana -Cayenne ',\n",
              "  'Brunei -Bandar Seri Begawan ',\n",
              "  18226.239957438705),\n",
              " ('American Samoa -Pago Pago ',\n",
              "  'Ivory Coast -Yamoussoukro ',\n",
              "  18219.586847608483),\n",
              " ('Ivory Coast -Yamoussoukro ',\n",
              "  'American Samoa -Pago Pago ',\n",
              "  18219.586847608483),\n",
              " ('Gambia -Banjul ', 'Norfolk Island -Kingston ', 18218.084913501694),\n",
              " ('Norfolk Island -Kingston ', 'Gambia -Banjul ', 18218.084913501694),\n",
              " ('Liberia -Monrovia ', 'New Caledonia -Noumea ', 18214.043702588675),\n",
              " ('New Caledonia -Noumea ', 'Liberia -Monrovia ', 18214.043702588675),\n",
              " ('Cambodia -Phnom Penh ', 'Colombia -Bogotá ', 18213.69111928526),\n",
              " ('Colombia -Bogotá ', 'Cambodia -Phnom Penh ', 18213.69111928526),\n",
              " ('Czech Republic -Prague ', 'New Zealand -Wellington ', 18211.225664257323),\n",
              " ('New Zealand -Wellington ', 'Czech Republic -Prague ', 18211.225664257323),\n",
              " ('Marshall Islands -Majuro ', 'Sierra Leone -Freetown ', 18209.97367723402),\n",
              " ('Sierra Leone -Freetown ', 'Marshall Islands -Majuro ', 18209.97367723402),\n",
              " ('Gambia -Banjul ', 'Tuvalu -Funafuti ', 18209.27282669763),\n",
              " ('Tuvalu -Funafuti ', 'Gambia -Banjul ', 18209.27282669763),\n",
              " ('Malta -Valletta ', 'New Zealand -Wellington ', 18203.582218458527),\n",
              " ('New Zealand -Wellington ', 'Malta -Valletta ', 18203.582218458527),\n",
              " ('Ghana -Accra ', \"Tonga -Nuku'alofa \", 18201.845336466577),\n",
              " (\"Tonga -Nuku'alofa \", 'Ghana -Accra ', 18201.845336466577),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Guatemala -New Guatemala ',\n",
              "  18196.88460885259),\n",
              " ('Guatemala -New Guatemala ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18196.88460885259),\n",
              " (\"Tonga -Nuku'alofa \", 'Tunisia -Tunis ', 18194.853780631933),\n",
              " ('Tunisia -Tunis ', \"Tonga -Nuku'alofa \", 18194.853780631933),\n",
              " ('Christmas Island -The Settlement ',\n",
              "  'Guyana -Georgetown ',\n",
              "  18193.863313313832),\n",
              " ('Guyana -Georgetown ',\n",
              "  'Christmas Island -The Settlement ',\n",
              "  18193.863313313832),\n",
              " ('Gambia -Banjul ', 'Papua New Guinea -Port Moresby ', 18190.53337494614),\n",
              " ('Papua New Guinea -Port Moresby ', 'Gambia -Banjul ', 18190.53337494614),\n",
              " ('Marshall Islands -Majuro ', 'Togo -Lomé ', 18183.852719546092),\n",
              " ('Togo -Lomé ', 'Marshall Islands -Majuro ', 18183.852719546092),\n",
              " ('Morocco -Rabat ', \"Tonga -Nuku'alofa \", 18183.65784745171),\n",
              " (\"Tonga -Nuku'alofa \", 'Morocco -Rabat ', 18183.65784745171),\n",
              " ('Ghana -Accra ', 'Vanuatu -Port Vila ', 18174.59062336488),\n",
              " ('Vanuatu -Port Vila ', 'Ghana -Accra ', 18174.59062336488),\n",
              " ('Fiji -Suva ', 'Morocco -Rabat ', 18174.462199606773),\n",
              " ('Morocco -Rabat ', 'Fiji -Suva ', 18174.462199606773),\n",
              " ('Palau -Melekeok ', 'Suriname -Paramaribo ', 18174.019062795895),\n",
              " ('Suriname -Paramaribo ', 'Palau -Melekeok ', 18174.019062795895),\n",
              " ('Gabon -Libreville ', 'Kiribati -South Tarawa ', 18173.902706384422),\n",
              " ('Kiribati -South Tarawa ', 'Gabon -Libreville ', 18173.902706384422),\n",
              " ('Equatorial Guinea -Malabo ', 'Kiribati -South Tarawa ', 18170.581819937346),\n",
              " ('Kiribati -South Tarawa ', 'Equatorial Guinea -Malabo ', 18170.581819937346),\n",
              " ('Chile -Santiago ', 'Laos -Vientiane ', 18166.019483342938),\n",
              " ('Laos -Vientiane ', 'Chile -Santiago ', 18166.019483342938),\n",
              " ('Bangladesh -Dhaka ', 'Peru -Lima ', 18159.8683874791),\n",
              " ('Peru -Lima ', 'Bangladesh -Dhaka ', 18159.8683874791),\n",
              " ('Austria -Vienna ', 'New Zealand -Wellington ', 18152.901740027),\n",
              " ('New Zealand -Wellington ', 'Austria -Vienna ', 18152.901740027),\n",
              " ('Nicaragua -Managua ', 'Singapore -Singapore ', 18152.079640715398),\n",
              " ('Singapore -Singapore ', 'Nicaragua -Managua ', 18152.079640715398),\n",
              " ('French Polynesia -Papeete ', 'Saudi Arabia -Riyadh ', 18149.259867266097),\n",
              " ('Saudi Arabia -Riyadh ', 'French Polynesia -Papeete ', 18149.259867266093),\n",
              " ('Ghana -Accra ', 'Niue -Alofi ', 18145.91926936274),\n",
              " ('Niue -Alofi ', 'Ghana -Accra ', 18145.91926936274),\n",
              " ('Mali -Bamako ', 'Norfolk Island -Kingston ', 18144.51321912628),\n",
              " ('Norfolk Island -Kingston ', 'Mali -Bamako ', 18144.51321912628),\n",
              " ('French Polynesia -Papeete ', 'Syria -Damascus ', 18144.473605361905),\n",
              " ('Syria -Damascus ', 'French Polynesia -Papeete ', 18144.473605361905),\n",
              " ('Morocco -Rabat ', 'Vanuatu -Port Vila ', 18141.680579939202),\n",
              " ('Vanuatu -Port Vila ', 'Morocco -Rabat ', 18141.680579939202),\n",
              " ('Central African Republic -Bangui ', 'Niue -Alofi ', 18139.758769645483),\n",
              " ('Niue -Alofi ', 'Central African Republic -Bangui ', 18139.758769645483),\n",
              " ('New Caledonia -Noumea ', 'Portugal -Lisbon ', 18139.550028672482),\n",
              " ('Portugal -Lisbon ', 'New Caledonia -Noumea ', 18139.550028672482),\n",
              " ('Libya -Tripoli ', 'New Zealand -Wellington ', 18138.954575870088),\n",
              " ('New Zealand -Wellington ', 'Libya -Tripoli ', 18138.954575870088),\n",
              " ('Germany -Berlin ', 'New Zealand -Wellington ', 18137.735840583962),\n",
              " ('New Zealand -Wellington ', 'Germany -Berlin ', 18137.735840583962),\n",
              " ('American Samoa -Pago Pago ', 'Mali -Bamako ', 18136.018629512746),\n",
              " ('Mali -Bamako ', 'American Samoa -Pago Pago ', 18136.018629512746),\n",
              " ('Central African Republic -Bangui ',\n",
              "  'Cook Islands -Avarua ',\n",
              "  18132.819427138416),\n",
              " ('Cook Islands -Avarua ',\n",
              "  'Central African Republic -Bangui ',\n",
              "  18132.819427138416),\n",
              " ('Cocos Islands -West Island ', 'Mexico -Mexico City ', 18128.3986431337),\n",
              " ('Mexico -Mexico City ', 'Cocos Islands -West Island ', 18128.3986431337),\n",
              " ('French Polynesia -Papeete ', 'Lebanon -Beirut ', 18127.443637235145),\n",
              " ('Lebanon -Beirut ', 'French Polynesia -Papeete ', 18127.443637235145),\n",
              " ('Marshall Islands -Majuro ',\n",
              "  'Sao Tome and Principe -São Tomé ',\n",
              "  18122.599249334853),\n",
              " ('Sao Tome and Principe -São Tomé ',\n",
              "  'Marshall Islands -Majuro ',\n",
              "  18122.599249334853),\n",
              " ('Malta -Valletta ', \"Tonga -Nuku'alofa \", 18121.05141117906),\n",
              " (\"Tonga -Nuku'alofa \", 'Malta -Valletta ', 18121.05141117906),\n",
              " ('Cook Islands -Avarua ', 'Greece -Athens ', 18120.34398864099),\n",
              " ('Greece -Athens ', 'Cook Islands -Avarua ', 18120.34398864099),\n",
              " ('Central African Republic -Bangui ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  18119.36424169025),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Central African Republic -Bangui ',\n",
              "  18119.36424169025),\n",
              " ('Guinea-Bissau -Bissau ',\n",
              "  'Papua New Guinea -Port Moresby ',\n",
              "  18114.571495997818),\n",
              " ('Papua New Guinea -Port Moresby ',\n",
              "  'Guinea-Bissau -Bissau ',\n",
              "  18114.571495997818),\n",
              " ('Togo -Lomé ', 'Vanuatu -Port Vila ', 18112.641331747254),\n",
              " ('Vanuatu -Port Vila ', 'Togo -Lomé ', 18112.641331747254),\n",
              " (\"Chad -N'Djamena \", 'Fiji -Suva ', 18112.582667201514),\n",
              " ('Fiji -Suva ', \"Chad -N'Djamena \", 18112.582667201514),\n",
              " ('Australia -Canberra ', 'Western Sahara -El Aaiún ', 18111.81102386355),\n",
              " ('Western Sahara -El Aaiún ', 'Australia -Canberra ', 18111.81102386355),\n",
              " ('Georgia -Tbilisi ', 'Pitcairn -Adamstown ', 18108.990179054323),\n",
              " ('Pitcairn -Adamstown ', 'Georgia -Tbilisi ', 18108.990179054323),\n",
              " ('Malaysia -Kuala Lumpur ', 'Nicaragua -Managua ', 18103.819685514867),\n",
              " ('Nicaragua -Managua ', 'Malaysia -Kuala Lumpur ', 18103.819685514867),\n",
              " ('New Zealand -Wellington ', 'Slovakia -Bratislava ', 18101.913994170372),\n",
              " ('Slovakia -Bratislava ', 'New Zealand -Wellington ', 18101.913994170372),\n",
              " ('Liberia -Monrovia ', 'Micronesia -Palikir ', 18101.70371006262),\n",
              " ('Micronesia -Palikir ', 'Liberia -Monrovia ', 18101.70371006262),\n",
              " ('Egypt -Cairo ', 'Pitcairn -Adamstown ', 18097.51158267096),\n",
              " ('Pitcairn -Adamstown ', 'Egypt -Cairo ', 18097.51158267096),\n",
              " ('Argentina -Buenos Aires ', 'Mongolia -Ulan Bator ', 18097.071963606373),\n",
              " ('Mongolia -Ulan Bator ', 'Argentina -Buenos Aires ', 18097.071963606373),\n",
              " ('Cook Islands -Avarua ', 'Nigeria -Abuja ', 18095.973147428384),\n",
              " ('Nigeria -Abuja ', 'Cook Islands -Avarua ', 18095.973147428384),\n",
              " ('New Caledonia -Noumea ', 'Niger -Niamey ', 18095.559252359442),\n",
              " ('Niger -Niamey ', 'New Caledonia -Noumea ', 18095.559252359442),\n",
              " ('Malta -Valletta ', 'Niue -Alofi ', 18092.925645810334),\n",
              " ('Niue -Alofi ', 'Malta -Valletta ', 18092.925645810334),\n",
              " ('Israel -Jerusalem ', 'Cook Islands -Avarua ', 18092.085062945298),\n",
              " ('Palestinian Territory -East Jerusalem ',\n",
              "  'Cook Islands -Avarua ',\n",
              "  18092.085062945298),\n",
              " ('Cook Islands -Avarua ', 'Israel -Jerusalem ', 18092.085062945294),\n",
              " ('Cook Islands -Avarua ',\n",
              "  'Palestinian Territory -East Jerusalem ',\n",
              "  18092.085062945294),\n",
              " ('Brunei -Bandar Seri Begawan ',\n",
              "  \"Grenada -St. George's \",\n",
              "  18089.906610967704),\n",
              " (\"Grenada -St. George's \",\n",
              "  'Brunei -Bandar Seri Begawan ',\n",
              "  18089.906610967704),\n",
              " ('Ivory Coast -Yamoussoukro ', \"Tonga -Nuku'alofa \", 18089.6378397944),\n",
              " (\"Tonga -Nuku'alofa \", 'Ivory Coast -Yamoussoukro ', 18089.6378397944),\n",
              " ('Andorra -Andorra la Vella ',\n",
              "  'Norfolk Island -Kingston ',\n",
              "  18087.90630180066),\n",
              " ('Norfolk Island -Kingston ',\n",
              "  'Andorra -Andorra la Vella ',\n",
              "  18087.90630180066),\n",
              " ('French Polynesia -Papeete ', 'Uganda -Kampala ', 18087.046088626044),\n",
              " ('Uganda -Kampala ', 'French Polynesia -Papeete ', 18087.046088626044),\n",
              " ('Guinea -Conakry ', 'Marshall Islands -Majuro ', 18082.850990565083),\n",
              " ('Marshall Islands -Majuro ', 'Guinea -Conakry ', 18082.850990565083),\n",
              " ('Kiribati -South Tarawa ', 'Niger -Niamey ', 18082.222637230905),\n",
              " ('Niger -Niamey ', 'Kiribati -South Tarawa ', 18082.222637230905),\n",
              " ('Ivory Coast -Yamoussoukro ', 'New Caledonia -Noumea ', 18081.28348676715),\n",
              " ('New Caledonia -Noumea ', 'Ivory Coast -Yamoussoukro ', 18081.28348676715),\n",
              " ('Senegal -Dakar ', 'Tuvalu -Funafuti ', 18079.33350882516),\n",
              " ('Tuvalu -Funafuti ', 'Senegal -Dakar ', 18079.33350882516),\n",
              " ('Sierra Leone -Freetown ',\n",
              "  'Wallis and Futuna -Mata-Utu ',\n",
              "  18078.094096500838),\n",
              " ('Wallis and Futuna -Mata-Utu ',\n",
              "  'Sierra Leone -Freetown ',\n",
              "  18078.094096500838),\n",
              " ('Gibraltar -Gibraltar ', \"Tonga -Nuku'alofa \", 18077.154941734047),\n",
              " (\"Tonga -Nuku'alofa \", 'Gibraltar -Gibraltar ', 18077.154941734047),\n",
              " ('Cyprus -Nicosia ', 'Pitcairn -Adamstown ', 18073.11786497291),\n",
              " ('Pitcairn -Adamstown ', 'Cyprus -Nicosia ', 18073.11786497291),\n",
              " ('El Salvador -San Salvador ', 'Indonesia -Jakarta ', 18072.81475916678),\n",
              " ('Indonesia -Jakarta ', 'El Salvador -San Salvador ', 18072.81475916678),\n",
              " (\"Tonga -Nuku'alofa \", 'Western Sahara -El Aaiún ', 18071.9828029352),\n",
              " ('Western Sahara -El Aaiún ', \"Tonga -Nuku'alofa \", 18071.9828029352),\n",
              " ('New Zealand -Wellington ',\n",
              "  'Bosnia and Herzegovina -Sarajevo ',\n",
              "  18070.068019973303),\n",
              " ('Bosnia and Herzegovina -Sarajevo ',\n",
              "  'New Zealand -Wellington ',\n",
              "  18070.0680199733),\n",
              " ('Guinea-Bissau -Bissau ', 'Norfolk Island -Kingston ', 18068.2016727049),\n",
              " ('Norfolk Island -Kingston ', 'Guinea-Bissau -Bissau ', 18068.2016727049),\n",
              " ('Gambia -Banjul ', 'Kiribati -South Tarawa ', 18062.69255620284),\n",
              " ('Kiribati -South Tarawa ', 'Gambia -Banjul ', 18062.69255620284),\n",
              " ('Bolivia -Sucre ', 'Myanmar -Nay Pyi Taw ', 18062.47653707283),\n",
              " ('Myanmar -Nay Pyi Taw ', 'Bolivia -Sucre ', 18062.47653707283),\n",
              " ('Guinea -Conakry ', 'Wallis and Futuna -Mata-Utu ', 18062.444482027204),\n",
              " ('Wallis and Futuna -Mata-Utu ', 'Guinea -Conakry ', 18062.444482027204),\n",
              " ('Central African Republic -Bangui ',\n",
              "  'French Polynesia -Papeete ',\n",
              "  18061.08408745484),\n",
              " ('French Polynesia -Papeete ',\n",
              "  'Central African Republic -Bangui ',\n",
              "  18061.08408745484),\n",
              " ('Mauritania -Nouakchott ', 'Tuvalu -Funafuti ', 18060.911290649994),\n",
              " ('Tuvalu -Funafuti ', 'Mauritania -Nouakchott ', 18060.911290649994),\n",
              " ('Equatorial Guinea -Malabo ', 'Fiji -Suva ', 18058.84129878464),\n",
              " ('Fiji -Suva ', 'Equatorial Guinea -Malabo ', 18058.84129878464),\n",
              " ('Benin -Porto-Novo ', 'Marshall Islands -Majuro ', 18057.38046264014),\n",
              " ('Marshall Islands -Majuro ', 'Benin -Porto-Novo ', 18057.38046264014),\n",
              " ('Cocos Islands -West Island ', 'Puerto Rico -San Juan ', 18056.07365090289),\n",
              " ('Puerto Rico -San Juan ', 'Cocos Islands -West Island ', 18056.07365090289),\n",
              " ('Micronesia -Palikir ', 'Sierra Leone -Freetown ', 18054.700746212417),\n",
              " ('Sierra Leone -Freetown ', 'Micronesia -Palikir ', 18054.700746212417),\n",
              " ('Australia -Canberra ', 'Portugal -Lisbon ', 18051.901360562748),\n",
              " ('Portugal -Lisbon ', 'Australia -Canberra ', 18051.901360562748),\n",
              " ('Cape Verde -Praia ', 'Norfolk Island -Kingston ', 18051.721889339507),\n",
              " ('Norfolk Island -Kingston ', 'Cape Verde -Praia ', 18051.721889339507),\n",
              " ('Cook Islands -Avarua ', 'Jordan -Amman ', 18050.483692889746),\n",
              " ('Jordan -Amman ', 'Cook Islands -Avarua ', 18050.483692889746),\n",
              " ('Aruba -Oranjestad ', 'Malaysia -Kuala Lumpur ', 18048.18239520135),\n",
              " ('Malaysia -Kuala Lumpur ', 'Aruba -Oranjestad ', 18048.18239520135),\n",
              " ('Peru -Lima ', 'Philippines -Manila ', 18046.29753034609),\n",
              " ('Philippines -Manila ', 'Peru -Lima ', 18046.29753034609),\n",
              " ('French Polynesia -Papeete ', 'Israel -Jerusalem ', 18042.503346154168),\n",
              " ('Israel -Jerusalem ', 'French Polynesia -Papeete ', 18042.503346154168),\n",
              " ('French Polynesia -Papeete ',\n",
              "  'Palestinian Territory -East Jerusalem ',\n",
              "  18042.503346154168),\n",
              " ('Palestinian Territory -East Jerusalem ',\n",
              "  'French Polynesia -Papeete ',\n",
              "  18042.503346154168),\n",
              " ('Malaysia -Kuala Lumpur ', 'Venezuela -Caracas ', 18040.78046338491),\n",
              " ('Venezuela -Caracas ', 'Malaysia -Kuala Lumpur ', 18040.78046338491),\n",
              " ('Niue -Alofi ', 'Tunisia -Tunis ', 18040.27088680238),\n",
              " ('Tunisia -Tunis ', 'Niue -Alofi ', 18040.27088680238),\n",
              " ('Ecuador -Quito ', 'Laos -Vientiane ', 18038.71800829),\n",
              " ('Laos -Vientiane ', 'Ecuador -Quito ', 18038.71800829),\n",
              " ('Kiribati -South Tarawa ', 'Nigeria -Abuja ', 18035.768781652525),\n",
              " ('Nigeria -Abuja ', 'Kiribati -South Tarawa ', 18035.768781652525),\n",
              " ('Equatorial Guinea -Malabo ', \"Tonga -Nuku'alofa \", 18035.229242224803),\n",
              " (\"Tonga -Nuku'alofa \", 'Equatorial Guinea -Malabo ', 18035.229242224803),\n",
              " ('Cyprus -Nicosia ', 'French Polynesia -Papeete ', 18032.17756577646),\n",
              " ('French Polynesia -Papeete ', 'Cyprus -Nicosia ', 18032.17756577646),\n",
              " ('Indonesia -Jakarta ', 'Suriname -Paramaribo ', 18026.660947501103),\n",
              " ('Suriname -Paramaribo ', 'Indonesia -Jakarta ', 18026.660947501103),\n",
              " ('Cook Islands -Avarua ', 'Tunisia -Tunis ', 18026.173288060505),\n",
              " ('Tunisia -Tunis ', 'Cook Islands -Avarua ', 18026.173288060505),\n",
              " ('Benin -Porto-Novo ', 'Vanuatu -Port Vila ', 18025.087601849416),\n",
              " ('Vanuatu -Port Vila ', 'Benin -Porto-Novo ', 18025.087601849416),\n",
              " ('Bhutan -Thimphu ', 'Chile -Santiago ', 18015.99693049243),\n",
              " ('Chile -Santiago ', 'Bhutan -Thimphu ', 18015.99693049243),\n",
              " ('Chile -Santiago ', 'Myanmar -Nay Pyi Taw ', 18006.253945175835),\n",
              " ('Myanmar -Nay Pyi Taw ', 'Chile -Santiago ', 18006.253945175835),\n",
              " ('Dominican Republic -Santo Domingo ',\n",
              "  'East Timor -Dili ',\n",
              "  18004.62805164434),\n",
              " ('East Timor -Dili ',\n",
              "  'Dominican Republic -Santo Domingo ',\n",
              "  18004.62805164434),\n",
              " ('Cook Islands -Avarua ', 'Cyprus -Nicosia ', 18001.77498448836),\n",
              " ('Cyprus -Nicosia ', 'Cook Islands -Avarua ', 18001.77498448836),\n",
              " ('Brazil -Brasília ', 'Hong Kong -Hong Kong ', 18000.188279761973),\n",
              " ('Hong Kong -Hong Kong ', 'Brazil -Brasília ', 18000.188279761973),\n",
              " ('Japan -Edo ', 'Paraguay -Asunción ', 17997.4545524586),\n",
              " ('Paraguay -Asunción ', 'Japan -Edo ', 17997.4545524586),\n",
              " ('Aruba -Oranjestad ', 'Brunei -Bandar Seri Begawan ', 17997.147510450774),\n",
              " ('Brunei -Bandar Seri Begawan ', 'Aruba -Oranjestad ', 17997.147510450774),\n",
              " ('Mongolia -Ulan Bator ', 'Uruguay -Montevideo ', 17995.068818473144),\n",
              " ('Uruguay -Montevideo ', 'Mongolia -Ulan Bator ', 17995.068818473144),\n",
              " ('Micronesia -Palikir ', 'Saint Helena -Jamestown ', 17994.040305307695),\n",
              " ('Saint Helena -Jamestown ', 'Micronesia -Palikir ', 17994.040305307695),\n",
              " ('Montenegro -Podgorica ', 'New Zealand -Wellington ', 17990.951092708478),\n",
              " ('New Zealand -Wellington ', 'Montenegro -Podgorica ', 17990.951092708478),\n",
              " ('Fiji -Suva ', 'Gibraltar -Gibraltar ', 17979.284743601882),\n",
              " ('Gibraltar -Gibraltar ', 'Fiji -Suva ', 17979.284743601882),\n",
              " ('Hungary -Budapest ', 'New Zealand -Wellington ', 17977.780739063208),\n",
              " ('New Zealand -Wellington ', 'Hungary -Budapest ', 17977.780739063208),\n",
              " ('Guinea -Conakry ', 'Micronesia -Palikir ', 17973.774642881788),\n",
              " ('Micronesia -Palikir ', 'Guinea -Conakry ', 17973.774642881788),\n",
              " ('Burkina Faso -Ouagadougou ',\n",
              "  'Solomon Islands -Honiara ',\n",
              "  17967.238337654864),\n",
              " ('Solomon Islands -Honiara ',\n",
              "  'Burkina Faso -Ouagadougou ',\n",
              "  17967.238337654864),\n",
              " ...]"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Y_BjhukI8ep4"
      },
      "source": [
        "# You can find Question-3 Answer below"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "nuLNWMJGA3Tf",
        "outputId": "4af0bea4-166c-4975-e8f4-c715eb2c14c9"
      },
      "source": [
        "from pyspark import SparkContext\n",
        "sc = SparkContext.getOrCreate()\n",
        "from itertools import combinations\n",
        "\n",
        "LotteryRDD = sc.textFile('Lottery.txt')\n",
        "# LotteryRDD.take(1)\n",
        "\n",
        "def splitAndTake(line):\n",
        "  arr = line.split(\"rakamlarNumaraSirasi\")\n",
        "  \n",
        "  lot = []\n",
        "  for a in arr:\n",
        "      b = a[4:30]\n",
        "      c =b.split(\"-\")\n",
        "      if (len(c) > 4):         \n",
        "          lot.append(c)\n",
        "  return lot \n",
        "\n",
        "def comb(satir):\n",
        "   comblist = []\n",
        "   comb = combinations(satir,3)\n",
        "   comblist.append(list(comb))\n",
        "\n",
        "   return comblist\n",
        "\n",
        "\n",
        "def bno(k,m,l):\n",
        "  \n",
        "    bno =k+l+m\n",
        "  \n",
        "    return (bno,1)\n",
        "\n",
        "\n",
        "LotteryRDD = LotteryRDD.flatMap(lambda x : splitAndTake(x) )\n",
        "LotteryRDD = LotteryRDD.flatMap(lambda y : comb(y) )\n",
        "LotteryRDD = LotteryRDD.flatMap(lambda z : z )\n",
        "LotteryRDD = LotteryRDD.map(lambda t : bno(t[0],t[1],t[2]) )\n",
        "LotteryRDD = LotteryRDD.reduceByKey(lambda f,g : f+g )\n",
        "LotteryRDD = LotteryRDD.sortBy(lambda p : p[1], ascending=False )\n",
        "\n",
        "LotteryRDD.collect()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(' 37  4 38 ', 12),\n",
              " (' 18  4 38 ', 12),\n",
              " (' 36  4 41 ', 11),\n",
              " (' 29  4 32 ', 11),\n",
              " (' 20  4 38 ', 11),\n",
              " (' 25  4 30 ', 11),\n",
              " (' 39  4 40 ', 10),\n",
              " (' 23  4 30 ', 10),\n",
              " (' 23  4 39 ', 10),\n",
              " (' 26  4 32 ', 10),\n",
              " (' 21  4 26 ', 10),\n",
              " (' 32  4 42 ', 10),\n",
              " (' 26  4 38 ', 9),\n",
              " (' 28  4 32 ', 9),\n",
              " (' 28  4 29 ', 9),\n",
              " (' 27  4 39 ', 9),\n",
              " (' 25  4 26 ', 9),\n",
              " (' 27  4 38 ', 9),\n",
              " (' 25  4 38 ', 9),\n",
              " (' 40  4 41 ', 9),\n",
              " (' 28  4 38 ', 9),\n",
              " (' 30  4 39 ', 9),\n",
              " (' 25  4 32 ', 9),\n",
              " (' 35  4 38 ', 9),\n",
              " (' 25  4 29 ', 9),\n",
              " (' 22  4 23 ', 9),\n",
              " ('11  4 40 ', 8),\n",
              " (' 18  4 41 ', 8),\n",
              " (' 38  4 41 ', 8),\n",
              " ('12  4 41 ', 8),\n",
              " (' 28  4 30 ', 8),\n",
              " ('11  4 16 ', 8),\n",
              " (' 22  4 34 ', 8),\n",
              " (' 39  4 41 ', 8),\n",
              " (' 23  4 40 ', 8),\n",
              " (' 26  4 40 ', 8),\n",
              " (' 17  4 20 ', 8),\n",
              " ('10  4 13 ', 8),\n",
              " (' 17  4 18 ', 8),\n",
              " (' 21  4 32 ', 8),\n",
              " ('01  4 26 ', 8),\n",
              " (' 30  4 40 ', 8),\n",
              " (' 20  4 30 ', 8),\n",
              " (' 20  4 28 ', 8),\n",
              " (' 21  4 37 ', 8),\n",
              " (' 16  4 36 ', 8),\n",
              " (' 24  4 29 ', 8),\n",
              " (' 29  4 38 ', 8),\n",
              " (' 34  4 38 ', 8),\n",
              " (' 25  4 31 ', 8),\n",
              " (' 26  4 27 ', 8),\n",
              " ('10  4 16 ', 8),\n",
              " (' 25  4 28 ', 8),\n",
              " (' 17  4 21 ', 8),\n",
              " ('12  4 32 ', 8),\n",
              " (' 36  4 39 ', 8),\n",
              " ('11  4 41 ', 7),\n",
              " ('14  4 32 ', 7),\n",
              " (' 21  4 24 ', 7),\n",
              " (' 22  4 30 ', 7),\n",
              " ('12  4 46 ', 7),\n",
              " ('10  4 38 ', 7),\n",
              " (' 29  4 39 ', 7),\n",
              " (' 26  4 31 ', 7),\n",
              " ('12  4 26 ', 7),\n",
              " (' 34  4 40 ', 7),\n",
              " (' 15  4 18 ', 7),\n",
              " (' 20  4 36 ', 7),\n",
              " (' 22  4 35 ', 7),\n",
              " (' 23  4 35 ', 7),\n",
              " (' 18  4 32 ', 7),\n",
              " (' 18  4 37 ', 7),\n",
              " (' 26  4 39 ', 7),\n",
              " ('11  4 18 ', 7),\n",
              " (' 32  4 43 ', 7),\n",
              " (' 16  4 38 ', 7),\n",
              " ('12  4 19 ', 7),\n",
              " (' 22  4 29 ', 7),\n",
              " (' 29  4 34 ', 7),\n",
              " (' 23  4 41 ', 7),\n",
              " (' 25  4 40 ', 7),\n",
              " (' 30  4 31 ', 7),\n",
              " (' 35  4 39 ', 7),\n",
              " (' 23  4 26 ', 7),\n",
              " ('12  4 18 ', 7),\n",
              " (' 29  4 30 ', 7),\n",
              " (' 19  4 42 ', 7),\n",
              " (' 21  4 39 ', 7),\n",
              " (' 30  4 36 ', 7),\n",
              " ('04  4 40 ', 7),\n",
              " (' 22  4 33 ', 6),\n",
              " (' 22  4 39 ', 6),\n",
              " (' 33  4 39 ', 6),\n",
              " ('11  4 30 ', 6),\n",
              " (' 32  4 41 ', 6),\n",
              " (' 32  4 33 ', 6),\n",
              " (' 21  4 27 ', 6),\n",
              " (' 16  4 28 ', 6),\n",
              " (' 21  4 28 ', 6),\n",
              " ('12  4 39 ', 6),\n",
              " (' 35  4 37 ', 6),\n",
              " (' 28  4 39 ', 6),\n",
              " ('12  4 16 ', 6),\n",
              " (' 19  4 30 ', 6),\n",
              " ('12  4 13 ', 6),\n",
              " (' 31  4 41 ', 6),\n",
              " (' 39  4 42 ', 6),\n",
              " (' 18  3 31 ', 6),\n",
              " (' 14  4 40 ', 6),\n",
              " (' 31  4 35 ', 6),\n",
              " ('10  4 33 ', 6),\n",
              " ('10  4 44 ', 6),\n",
              " (' 15  4 27 ', 6),\n",
              " (' 18  3 26 ', 6),\n",
              " (' 17  4 26 ', 6),\n",
              " (' 33  4 36 ', 6),\n",
              " (' 31  4 32 ', 6),\n",
              " (' 36  4 37 ', 6),\n",
              " (' 18  4 21 ', 6),\n",
              " (' 20  4 37 ', 6),\n",
              " (' 14  4 20 ', 6),\n",
              " ('01  4 35 ', 6),\n",
              " (' 25  4 35 ', 6),\n",
              " ('01  4 24 ', 6),\n",
              " ('01  4 03 ', 6),\n",
              " ('02  4 03 ', 6),\n",
              " ('04  4 15 ', 6),\n",
              " ('04  4 30 ', 6),\n",
              " ('13  4 22 ', 6),\n",
              " (' 18  4 36 ', 6),\n",
              " (' 36  4 44 ', 6),\n",
              " ('12  4 34 ', 6),\n",
              " (' 25  4 34 ', 6),\n",
              " (' 21  4 22 ', 6),\n",
              " ('10  4 12 ', 6),\n",
              " (' 25  3 28 ', 6),\n",
              " (' 16  4 23 ', 6),\n",
              " (' 23  4 36 ', 6),\n",
              " ('13  4 28 ', 6),\n",
              " (' 24  4 34 ', 6),\n",
              " (' 27  3 30 ', 6),\n",
              " (' 25  4 41 ', 6),\n",
              " (' 30  4 45 ', 6),\n",
              " (' 40  4 42 ', 6),\n",
              " (' 25  4 33 ', 6),\n",
              " (' 38  4 40 ', 6),\n",
              " (' 27  4 36 ', 6),\n",
              " (' 20  4 34 ', 6),\n",
              " ('11  4 28 ', 6),\n",
              " (' 35  4 36 ', 6),\n",
              " (' 34  4 36 ', 6),\n",
              " (' 21  4 40 ', 6),\n",
              " (' 28  4 34 ', 6),\n",
              " (' 13  4 18 ', 6),\n",
              " (' 18  4 24 ', 6),\n",
              " (' 30  4 35 ', 6),\n",
              " (' 14  4 34 ', 6),\n",
              " (' 13  4 16 ', 6),\n",
              " (' 16  4 17 ', 6),\n",
              " (' 25  4 42 ', 6),\n",
              " (' 32  4 37 ', 6),\n",
              " (' 33  4 37 ', 6),\n",
              " (' 16  4 26 ', 6),\n",
              " (' 35  4 40 ', 6),\n",
              " ('05  4 18 ', 6),\n",
              " ('01  4 05 ', 6),\n",
              " ('04  4 09 ', 6),\n",
              " ('04  4 25 ', 6),\n",
              " ('22  4 39 ', 5),\n",
              " ('13  4 39 ', 5),\n",
              " (' 22  4 38 ', 5),\n",
              " ('14  4 28 ', 5),\n",
              " ('14  4 38 ', 5),\n",
              " (' 32  4 46 ', 5),\n",
              " (' 35  4 42 ', 5),\n",
              " (' 15  3 28 ', 5),\n",
              " (' 34  4 39 ', 5),\n",
              " (' 26  4 34 ', 5),\n",
              " ('17  4 21 ', 5),\n",
              " ('17  4 30 ', 5),\n",
              " (' 24  4 30 ', 5),\n",
              " (' 20  3 28 ', 5),\n",
              " (' 23  4 28 ', 5),\n",
              " ('10  4 18 ', 5),\n",
              " ('11  4 35 ', 5),\n",
              " (' 16  4 27 ', 5),\n",
              " (' 40  4 45 ', 5),\n",
              " (' 27  3 35 ', 5),\n",
              " (' 24  4 41 ', 5),\n",
              " ('12  4 30 ', 5),\n",
              " (' 30  4 38 ', 5),\n",
              " (' 27  4 32 ', 5),\n",
              " ('10  4 25 ', 5),\n",
              " (' 20  4 26 ', 5),\n",
              " (' 26  4 28 ', 5),\n",
              " (' 24  4 26 ', 5),\n",
              " (' 34  4 42 ', 5),\n",
              " ('12  4 17 ', 5),\n",
              " (' 31  4 36 ', 5),\n",
              " (' 22  4 40 ', 5),\n",
              " (' 13  4 39 ', 5),\n",
              " (' 19  4 31 ', 5),\n",
              " (' 31  4 43 ', 5),\n",
              " (' 30  4 33 ', 5),\n",
              " (' 18  4 34 ', 5),\n",
              " (' 15  4 38 ', 5),\n",
              " (' 25  3 27 ', 5),\n",
              " (' 26  4 36 ', 5),\n",
              " (' 19  4 24 ', 5),\n",
              " ('10  3 12 ', 5),\n",
              " (' 15  4 16 ', 5),\n",
              " (' 30  4 37 ', 5),\n",
              " (' 26  4 29 ', 5),\n",
              " (' 13  4 33 ', 5),\n",
              " (' 24  3 25 ', 5),\n",
              " (' 12  4 25 ', 5),\n",
              " (' 17  4 31 ', 5),\n",
              " (' 23  4 33 ', 5),\n",
              " (' 17  3 18 ', 5),\n",
              " (' 19  4 39 ', 5),\n",
              " (' 20  4 29 ', 5),\n",
              " (' 32  4 39 ', 5),\n",
              " (' 18  4 26 ', 5),\n",
              " (' 32  4 47 ', 5),\n",
              " ('01  4 27 ', 5),\n",
              " ('01  4 29 ', 5),\n",
              " (' 29  4 46 ', 5),\n",
              " ('04  4 22 ', 5),\n",
              " ('01  4 42 ', 5),\n",
              " ('02  4 33 ', 5),\n",
              " ('05  4 14 ', 5),\n",
              " (' 09  4 38 ', 5),\n",
              " ('04  4 14 ', 5),\n",
              " (' 09  4 25 ', 5),\n",
              " ('02  4 38 ', 5),\n",
              " ('06  4 20 ', 5),\n",
              " ('03  4 08 ', 5),\n",
              " ('13  4 33 ', 5),\n",
              " (' 30  4 41 ', 5),\n",
              " (' 32  4 38 ', 5),\n",
              " ('18  4 32 ', 5),\n",
              " (' 28  4 33 ', 5),\n",
              " ('15  4 23 ', 5),\n",
              " (' 32  4 34 ', 5),\n",
              " ('17  4 22 ', 5),\n",
              " (' 21  4 30 ', 5),\n",
              " (' 22  4 24 ', 5),\n",
              " ('1  24  21 ', 5),\n",
              " (' 21  32  26 ', 5),\n",
              " (' 14  3 27 ', 5),\n",
              " ('12  4 36 ', 5),\n",
              " (' 36  4 43 ', 5),\n",
              " (' 15  4 40 ', 5),\n",
              " (' 33  4 40 ', 5),\n",
              " (' 27  3 28 ', 5),\n",
              " (' 34  4 35 ', 5),\n",
              " (' 13  4 30 ', 5),\n",
              " ('14  4 15 ', 5),\n",
              " ('12  4 40 ', 5),\n",
              " (' 29  4 33 ', 5),\n",
              " (' 27  4 40 ', 5),\n",
              " (' 21  4 33 ', 5),\n",
              " (' 26  4 33 ', 5),\n",
              " ('22  4 23 ', 5),\n",
              " (' 24  4 25 ', 5),\n",
              " ('2  22  18 ', 5),\n",
              " (' 13  4 26 ', 5),\n",
              " (' 26  4 46 ', 5),\n",
              " (' 27  4 46 ', 5),\n",
              " (' 16  4 31 ', 5),\n",
              " (' 25  4 36 ', 5),\n",
              " (' 28  4 36 ', 5),\n",
              " ('10  4 32 ', 5),\n",
              " ('10  4 26 ', 5),\n",
              " ('10  4 41 ', 5),\n",
              " (' 36  4 45 ', 5),\n",
              " (' 41  4 43 ', 5),\n",
              " (' 26  3 29 ', 5),\n",
              " (' 24  4 33 ', 5),\n",
              " (' 22  4 25 ', 5),\n",
              " (' 30  4 42 ', 5),\n",
              " (' 13  4 32 ', 5),\n",
              " (' 36  4 40 ', 5),\n",
              " (' 11  4 26 ', 5),\n",
              " (' 16  4 33 ', 5),\n",
              " ('10  4 34 ', 5),\n",
              " ('11  4 17 ', 5),\n",
              " (' 16  4 44 ', 5),\n",
              " (' 19  4 26 ', 5),\n",
              " (' 18  4 28 ', 5),\n",
              " (' 31  4 34 ', 5),\n",
              " (' 25  4 37 ', 5),\n",
              " (' 45  4 47 ', 5),\n",
              " (' 39  4 44 ', 5),\n",
              " (' 18  4 23 ', 5),\n",
              " (' 18  4 20 ', 5),\n",
              " (' 30  4 32 ', 5),\n",
              " (' 34  4 37 ', 5),\n",
              " (' 16  4 32 ', 5),\n",
              " ('05  4 38 ', 5),\n",
              " ('01  4 18 ', 5),\n",
              " ('01  4 17 ', 5),\n",
              " (' 14  4 38 ', 5),\n",
              " ('04  4 16 ', 5),\n",
              " ('04  4 20 ', 5),\n",
              " ('01  4 20 ', 5),\n",
              " ('01  4 39 ', 5),\n",
              " ('04  4 17 ', 5),\n",
              " (' 14  4 31 ', 5),\n",
              " ('01  4 28 ', 5),\n",
              " (' 14  43 27 ', 4),\n",
              " ('4  27  14 ', 4),\n",
              " (' 26  4 37 ', 4),\n",
              " (' 37  4 39 ', 4),\n",
              " (' 38  4 39 ', 4),\n",
              " (' 18  4 40 ', 4),\n",
              " (' 28  4 41 ', 4),\n",
              " (' 29  4 43 ', 4),\n",
              " ('19  4 41 ', 4),\n",
              " (' 33  4 46 ', 4),\n",
              " ('14  4 33 ', 4),\n",
              " ('14  4 35 ', 4),\n",
              " (' 17  4 28 ', 4),\n",
              " (' 17  4 33 ', 4),\n",
              " ('15  4 30 ', 4),\n",
              " ('14  4 21 ', 4),\n",
              " (' 27  4 35 ', 4),\n",
              " (' 27  4 42 ', 4),\n",
              " ('11  4 36 ', 4),\n",
              " (' 18  4 44 ', 4),\n",
              " (' 36  4 38 ', 4),\n",
              " (' 21  4 38 ', 4),\n",
              " ('7  22  21 ', 4),\n",
              " ('22  4 25 ', 4),\n",
              " ('15  4 37 ', 4),\n",
              " ('12  4 35 ', 4),\n",
              " (' 35  4 41 ', 4),\n",
              " ('10  4 21 ', 4),\n",
              " ('10  4 37 ', 4),\n",
              " ('1  48 21 ', 4),\n",
              " (' 20  3 25 ', 4),\n",
              " (' 14  34  19 ', 4),\n",
              " ('2  27  7 ', 4),\n",
              " (' 18  4 35 ', 4),\n",
              " (' 15  4 33 ', 4),\n",
              " (' 27  35  30 ', 4),\n",
              " (' 28  3 30 ', 4),\n",
              " ('7  21  15 ', 4),\n",
              " ('1  39  3 ', 4),\n",
              " (' 22  4 41 ', 4),\n",
              " (' 34  4 41 ', 4),\n",
              " ('14  4 34 ', 4),\n",
              " (' 19  3 28 ', 4),\n",
              " (' 13  4 41 ', 4),\n",
              " ('18  4 25 ', 4),\n",
              " ('14  4 26 ', 4),\n",
              " ('17  4 29 ', 4),\n",
              " (' 25  31  29 ', 4),\n",
              " (' 27  40  38 ', 4),\n",
              " (' 32  4 36 ', 4),\n",
              " (' 25  4 27 ', 4),\n",
              " ('7  16  15 ', 4),\n",
              " ('13  4 21 ', 4),\n",
              " ('8  17  12 ', 4),\n",
              " ('1  13  6 ', 4),\n",
              " (' 18  4 22 ', 4),\n",
              " ('11  4 13 ', 4),\n",
              " ('11  4 14 ', 4),\n",
              " (' 13  4 38 ', 4),\n",
              " (' 20  4 45 ', 4),\n",
              " (' 28  4 45 ', 4),\n",
              " (' 18  38  28 ', 4),\n",
              " ('1  21  11 ', 4),\n",
              " (' 30  4 44 ', 4),\n",
              " (' 22  4 46 ', 4),\n",
              " (' 14  24  16 ', 4),\n",
              " (' 24  3 27 ', 4),\n",
              " ('11  4 34 ', 4),\n",
              " (' 16  4 40 ', 4),\n",
              " ('10  4 15 ', 4),\n",
              " ('14  3 26 ', 4),\n",
              " ('17  4 34 ', 4),\n",
              " ('13  4 31 ', 4),\n",
              " (' 29  38  37 ', 4),\n",
              " (' 22  30  23 ', 4),\n",
              " ('10  12  11 ', 4),\n",
              " (' 24  4 32 ', 4),\n",
              " (' 24  4 43 ', 4),\n",
              " ('10  24  12 ', 4),\n",
              " (' 12  3 24 ', 4),\n",
              " (' 18  3 33 ', 4),\n",
              " (' 26  4 30 ', 4),\n",
              " (' 28  4 37 ', 4),\n",
              " (' 26  4 42 ', 4),\n",
              " ('10  26  12 ', 4),\n",
              " (' 12  26  23 ', 4),\n",
              " (' 12  4 26 ', 4),\n",
              " (' 20  4 32 ', 4),\n",
              " (' 32  4 40 ', 4),\n",
              " (' 31  4 40 ', 4),\n",
              " ('13  4 24 ', 4),\n",
              " (' 20  4 40 ', 4),\n",
              " (' 18  3 24 ', 4),\n",
              " ('17  4 35 ', 4),\n",
              " ('5  48\" 47 ', 4),\n",
              " ('13  4 41 ', 4),\n",
              " (' 30  4 34 ', 4),\n",
              " ('14  4 36 ', 4),\n",
              " (' 29  4 41 ', 4),\n",
              " (' 22  4 28 ', 4),\n",
              " (' 16  4 18 ', 4),\n",
              " (' 23  4 29 ', 4),\n",
              " (' 29  4 37 ', 4),\n",
              " (' 19  4 34 ', 4),\n",
              " (' 31  4 42 ', 4),\n",
              " (' 24  4 28 ', 4),\n",
              " ('01  4 02 ', 4),\n",
              " ('01  4 13 ', 4),\n",
              " ('04  4 32 ', 4),\n",
              " ('04  4 23 ', 4),\n",
              " ('01  4 38 ', 4),\n",
              " ('01  26  11 ', 4),\n",
              " ('01  4 11 ', 4),\n",
              " ('02  33  03 ', 4),\n",
              " ('01  4 15 ', 4),\n",
              " ('05  4 22 ', 4),\n",
              " ('05  4 29 ', 4),\n",
              " ('01  4 25 ', 4),\n",
              " (' 22  4 37 ', 4),\n",
              " (' 07  4 32 ', 4),\n",
              " ('02  4 23 ', 4),\n",
              " (' 09  4 22 ', 4),\n",
              " ('02  4 16 ', 4),\n",
              " ('05  4 25 ', 4),\n",
              " ('04  4 36 ', 4),\n",
              " ('02  4 31 ', 4),\n",
              " ('7  16  11 ', 4),\n",
              " (' 14  31  30 ', 4),\n",
              " ('2  30  25 ', 4),\n",
              " ('5  29  11 ', 4),\n",
              " ('18  4 29 ', 4),\n",
              " (' 29  43  32 ', 4),\n",
              " (' 13  30  25 ', 4),\n",
              " (' 33  4 41 ', 4),\n",
              " ('5  38  11 ', 4),\n",
              " (' 20  4 39 ', 4),\n",
              " ('15  4 16 ', 4),\n",
              " (' 16  4 21 ', 4),\n",
              " (' 21  30  22 ', 4),\n",
              " (' 28  3 32 ', 4),\n",
              " ('8  28  16 ', 4),\n",
              " ('7  17  16 ', 4),\n",
              " (' 20  4 41 ', 4),\n",
              " (' 21  30  24 ', 4),\n",
              " (' 12  4 43 ', 4),\n",
              " (' 21  48 32 ', 4),\n",
              " (' 25  3 31 ', 4),\n",
              " (' 20  3 27 ', 4),\n",
              " ('3  40  8 ', 4),\n",
              " ('10  38  18 ', 4),\n",
              " (' 16  4 29 ', 4),\n",
              " (' 16  4 39 ', 4),\n",
              " (' 17  46 42 ', 4),\n",
              " (' 23  4 25 ', 4),\n",
              " ('11  3 19 ', 4),\n",
              " ('12  4 31 ', 4),\n",
              " (' 13  4 31 ', 4),\n",
              " ('7  32  25 ', 4),\n",
              " (' 29  39  35 ', 4),\n",
              " (' 29  4 31 ', 4),\n",
              " (' 27  4 30 ', 4),\n",
              " ('19  4 36 ', 4),\n",
              " (' 29  4 36 ', 4),\n",
              " ('7  28  17 ', 4),\n",
              " (' 27  4 33 ', 4),\n",
              " ('1  16  6 ', 4),\n",
              " (' 25  3 33 ', 4),\n",
              " ('12  4 24 ', 4),\n",
              " (' 20  4 24 ', 4),\n",
              " ('10  4 36 ', 4),\n",
              " ('15  3 18 ', 4),\n",
              " (' 19  31  30 ', 4),\n",
              " (' 38  4 43 ', 4),\n",
              " (' 26  4 41 ', 4),\n",
              " ('11  4 20 ', 4),\n",
              " (' 16  4 20 ', 4),\n",
              " ('15  4 25 ', 4),\n",
              " (' 20  4 25 ', 4),\n",
              " ('10  3 24 ', 4),\n",
              " ('15  4 45 ', 4),\n",
              " (' 43  4 44 ', 4),\n",
              " (' 21  3 27 ', 4),\n",
              " ('17  4 23 ', 4),\n",
              " ('12  4 21 ', 4),\n",
              " ('12  4 33 ', 4),\n",
              " (' 19  4 33 ', 4),\n",
              " (' 18  24  21 ', 4),\n",
              " (' 11  3 12 ', 4),\n",
              " ('16  4 30 ', 4),\n",
              " ('13  3 27 ', 4),\n",
              " ('11  3 18 ', 4),\n",
              " ('11  4 26 ', 4),\n",
              " ('1  19  6 ', 4),\n",
              " ('18  4 20 ', 4),\n",
              " (' 21  4 25 ', 4),\n",
              " (' 31  4 39 ', 4),\n",
              " ('12  4 22 ', 4),\n",
              " ('12  4 29 ', 4),\n",
              " (' 19  4 32 ', 4),\n",
              " (' 27  4 31 ', 4),\n",
              " (' 23  4 27 ', 4),\n",
              " (' 17  31  26 ', 4),\n",
              " ('10  4 39 ', 4),\n",
              " (' 28  4 42 ', 4),\n",
              " ('14  4 25 ', 4),\n",
              " (' 15  4 39 ', 4),\n",
              " (' 18  4 29 ', 4),\n",
              " (' 17  37  20 ', 4),\n",
              " (' 17  3 26 ', 4),\n",
              " ('1  20  9 ', 4),\n",
              " (' 15  4 34 ', 4),\n",
              " (' 17  20  18 ', 4),\n",
              " (' 20  3 26 ', 4),\n",
              " (' 18  4 25 ', 4),\n",
              " ('13  4 19 ', 4),\n",
              " (' 20  4 22 ', 4),\n",
              " ('13  4 23 ', 4),\n",
              " (' 31  4 44 ', 4),\n",
              " ('12  4 28 ', 4),\n",
              " (' 23  4 31 ', 4),\n",
              " (' 21  4 41 ', 4),\n",
              " ('01  4 16 ', 4),\n",
              " ('01  4 07 ', 4),\n",
              " ('04  4 38 ', 4),\n",
              " (' 08  4 17 ', 4),\n",
              " ('05  4 07 ', 4),\n",
              " ('03  4 30 ', 4),\n",
              " ('07  4 22 ', 4),\n",
              " ('04  4 12 ', 4),\n",
              " ('01  4 22 ', 4),\n",
              " ('03  4 40 ', 4),\n",
              " ('03  4 09 ', 4),\n",
              " (' 33  4 42 ', 4),\n",
              " ('03  4 38 ', 4),\n",
              " ('04  22  09 ', 4),\n",
              " ('04  4 33 ', 4),\n",
              " (' 15  4 31 ', 4),\n",
              " ('02  4 15 ', 4),\n",
              " (' 19  4 23 ', 4),\n",
              " ('03  4 11 ', 4),\n",
              " ('03  4 18 ', 4),\n",
              " ('02  4 32 ', 4),\n",
              " ('04  4 39 ', 4),\n",
              " ('05  4 45 ', 4),\n",
              " ('03  4 34 ', 4),\n",
              " ('03  4 13 ', 4),\n",
              " (' 14  27  23 ', 3),\n",
              " ('2  30  14 ', 3),\n",
              " (' 8  36\" 14 ', 3),\n",
              " ('3  41  36 ', 3),\n",
              " ('3  47 41 ', 3),\n",
              " ('4  18  16 ', 3),\n",
              " (' 15  18  16 ', 3),\n",
              " ('5  24  11 ', 3),\n",
              " ('22  4 26 ', 3),\n",
              " (' 37  39  38 ', 3),\n",
              " (' 33  4 38 ', 3),\n",
              " ('14  4 41 ', 3),\n",
              " (' 21  3 33 ', 3),\n",
              " ('1  23  18 ', 3),\n",
              " (' 17  4 35 ', 3),\n",
              " ('1  4  2 ', 3),\n",
              " ('1  12  2 ', 3),\n",
              " ('3  10  5 ', 3),\n",
              " ('3  22  10 ', 3),\n",
              " (' 23  39  30 ', 3),\n",
              " (' 13  38 34 ', 3),\n",
              " ('14  4 42 ', 3),\n",
              " ('11  36  18 ', 3),\n",
              " ('11  4 38 ', 3),\n",
              " ('11  4 44 ', 3),\n",
              " ('15  4 21 ', 3),\n",
              " ('15  4 38 ', 3),\n",
              " ('2  27  13 ', 3),\n",
              " (' 21  33  22 ', 3),\n",
              " (' 21  33  30 ', 3),\n",
              " (' 11  24  13 ', 3),\n",
              " (' 20  36  28 ', 3),\n",
              " ('12  4 27 ', 3),\n",
              " (' 39  4 47 ', 3),\n",
              " (' 27  32  29 ', 3),\n",
              " (' 25  32  26 ', 3),\n",
              " (' 21  43  37 ', 3),\n",
              " (' 35  4 43 ', 3),\n",
              " (' 37  4 43 ', 3),\n",
              " (' 13  33  16 ', 3),\n",
              " (' 17  41  31 ', 3),\n",
              " (' 31  41  32 ', 3),\n",
              " ('10  4 43 ', 3),\n",
              " (' 21  29  24 ', 3),\n",
              " (' 20  28  25 ', 3),\n",
              " (' 25  31  28 ', 3),\n",
              " ('19  4 28 ', 3),\n",
              " ('10  4 27 ', 3),\n",
              " ('11  4 27 ', 3),\n",
              " (' 16  4 35 ', 3),\n",
              " ('12  4 23 ', 3),\n",
              " (' 23  4 43 ', 3),\n",
              " ('2  38\" 14 ', 3),\n",
              " ('1  22  20 ', 3),\n",
              " ('13  4 29 ', 3),\n",
              " ('8  44 36 ', 3),\n",
              " (' 11  13  12 ', 3),\n",
              " (' 13  47 37 ', 3),\n",
              " ('11  4 15 ', 3),\n",
              " ('2  22  3 ', 3),\n",
              " ('2  19  13 ', 3),\n",
              " ('2  35  10 ', 3),\n",
              " ('3  16  10 ', 3),\n",
              " ('6  29  21 ', 3),\n",
              " ('20  4 37 ', 3),\n",
              " (' 23  41  39 ', 3),\n",
              " (' 36  41  38 ', 3),\n",
              " ('19  4 40 ', 3),\n",
              " (' 12  25  22 ', 3),\n",
              " ('17  4 19 ', 3),\n",
              " (' 17  26  25 ', 3),\n",
              " (' 26  46 28 ', 3),\n",
              " (' 15  28  24 ', 3),\n",
              " ('12  41  13 ', 3),\n",
              " ('12  31  30 ', 3),\n",
              " ('2  33  19 ', 3),\n",
              " ('9  49 32 ', 3),\n",
              " ('1  23  9 ', 3),\n",
              " ('1  30  23 ', 3),\n",
              " (' 15  4 32 ', 3),\n",
              " (' 10  47 26 ', 3),\n",
              " ('17  4 31 ', 3),\n",
              " (' 31  4 33 ', 3),\n",
              " ('6  46\" 8 ', 3),\n",
              " ('17  4 40 ', 3),\n",
              " (' 27  4 29 ', 3),\n",
              " ('7  17  12 ', 3),\n",
              " (' 18  26  23 ', 3),\n",
              " ('10  4 29 ', 3),\n",
              " (' 16  4 25 ', 3),\n",
              " ('5  29  19 ', 3),\n",
              " (' 28  4 31 ', 3),\n",
              " ('9  45 11 ', 3),\n",
              " ('9  40  31 ', 3),\n",
              " ('8  27  12 ', 3),\n",
              " ('8  27  17 ', 3),\n",
              " (' 12  27  17 ', 3),\n",
              " ('22  4 40 ', 3),\n",
              " (' 23  4 24 ', 3),\n",
              " (' 24  4 40 ', 3),\n",
              " ('6  36  19 ', 3),\n",
              " (' 13  26  15 ', 3),\n",
              " ('5  39  38 ', 3),\n",
              " ('21  4 26 ', 3),\n",
              " ('21  4 27 ', 3),\n",
              " ('21  4 39 ', 3),\n",
              " ('1  46 14 ', 3),\n",
              " ('1  46 40 ', 3),\n",
              " (' 14  32  19 ', 3),\n",
              " (' 9  18  15 ', 3),\n",
              " ('4  36 21 ', 3),\n",
              " (' 25  33  30 ', 3),\n",
              " ('5  34  12 ', 3),\n",
              " (' 17  4 24 ', 3),\n",
              " ('1  39  26 ', 3),\n",
              " ('2  32  22 ', 3),\n",
              " (' 12  4 16 ', 3),\n",
              " (' 12  4 31 ', 3),\n",
              " (' 12  4 36 ', 3),\n",
              " ('16  4 40 ', 3),\n",
              " (' 29  3 31 ', 3),\n",
              " (' 11  25  15 ', 3),\n",
              " (' 16  46 22 ', 3),\n",
              " ('6  32  19 ', 3),\n",
              " ('11  4 39 ', 3),\n",
              " ('1  44 40 ', 3),\n",
              " ('1  49\" 3 ', 3),\n",
              " (' 19  39  32 ', 3),\n",
              " (' 29  39  32 ', 3),\n",
              " ('1  14  8 ', 3),\n",
              " ('10  33  32 ', 3),\n",
              " (' 13  41  38 ', 3),\n",
              " (' 18  36  28 ', 3),\n",
              " ('9  26  15 ', 3),\n",
              " ('11  41  36 ', 3),\n",
              " ('9  36 34 ', 3),\n",
              " ('3  40  18 ', 3),\n",
              " ('1  36  8 ', 3),\n",
              " (' 23  4 44 ', 3),\n",
              " ('10  4 19 ', 3),\n",
              " ('9  49 41 ', 3),\n",
              " (' 40  49 41 ', 3),\n",
              " ('1  22  3 ', 3),\n",
              " (' 14  38 33 ', 3),\n",
              " ('1  42  13 ', 3),\n",
              " ('14  29  26 ', 3),\n",
              " (' 15  3 26 ', 3),\n",
              " ('17  4 26 ', 3),\n",
              " (' 16  31  22 ', 3),\n",
              " ('3  22  16 ', 3),\n",
              " (' 12  4 41 ', 3),\n",
              " ('3  39  26 ', 3),\n",
              " ('7  47 31 ', 3),\n",
              " ('12  18  13 ', 3),\n",
              " ('12  4 38 ', 3),\n",
              " ('18  36  28 ', 3),\n",
              " (' 29  47 31 ', 3),\n",
              " (' 15  24  20 ', 3),\n",
              " ('9  39  29 ', 3),\n",
              " (' 19  4 21 ', 3),\n",
              " (' 18  30  23 ', 3),\n",
              " (' 22  3 25 ', 3),\n",
              " ('23  4 29 ', 3),\n",
              " ('2  9  3 ', 3),\n",
              " (' 40  45 44 ', 3),\n",
              " (' 12  24  13 ', 3),\n",
              " (' 21  30  25 ', 3),\n",
              " (' 18  3 25 ', 3),\n",
              " ('3  29  19 ', 3),\n",
              " ('5  24  12 ', 3),\n",
              " (' 10  44 24 ', 3),\n",
              " (' 10  36  19 ', 3),\n",
              " ('10  23  11 ', 3),\n",
              " ('10  4 11 ', 3),\n",
              " ('1  26  19 ', 3),\n",
              " (' 15  26  19 ', 3),\n",
              " ('2  21  13 ', 3),\n",
              " (' 17  35  34 ', 3),\n",
              " (' 22  49 42 ', 3),\n",
              " ('12  4 25 ', 3),\n",
              " ('16  4 37 ', 3),\n",
              " (' 21  4 31 ', 3),\n",
              " (' 31  4 37 ', 3),\n",
              " (' 37  4 40 ', 3),\n",
              " (' 22  27  25 ', 3),\n",
              " (' 17  4 25 ', 3),\n",
              " (' 25  4 45 ', 3),\n",
              " (' 12  4 14 ', 3),\n",
              " ('1  15  5 ', 3),\n",
              " ('16  4 20 ', 3),\n",
              " ('17  4 39 ', 3),\n",
              " (' 21  28  24 ', 3),\n",
              " ('6  35  10 ', 3),\n",
              " (' 30  35  34 ', 3),\n",
              " ('4  19  12 ', 3),\n",
              " (' 23  38  29 ', 3),\n",
              " ('4  26  22 ', 3),\n",
              " (' 21  26  22 ', 3),\n",
              " ('11  27  17 ', 3),\n",
              " (' 11  4 37 ', 3),\n",
              " (' 16  4 37 ', 3),\n",
              " (' 37  4 44 ', 3),\n",
              " ('10  39  34 ', 3),\n",
              " (' 21  4 29 ', 3),\n",
              " ('13  4 17 ', 3),\n",
              " ('13  4 18 ', 3),\n",
              " (' 17  4 41 ', 3),\n",
              " (' 18  4 31 ', 3),\n",
              " (' 23  40  30 ', 3),\n",
              " (' 24  4 31 ', 3),\n",
              " ('13  4 36 ', 3),\n",
              " (' 27  3 31 ', 3),\n",
              " (' 19  26  21 ', 3),\n",
              " (' 14  3 19 ', 3),\n",
              " (' 14  3 31 ', 3),\n",
              " (' 23  4 38 ', 3),\n",
              " (' 12  3 14 ', 3),\n",
              " (' 14  3 26 ', 3),\n",
              " (' 22  34  28 ', 3),\n",
              " ('23  4 39 ', 3),\n",
              " (' 17  3 31 ', 3),\n",
              " ('9  49 26 ', 3),\n",
              " (' 15  36  24 ', 3),\n",
              " (' 17  4 37 ', 3),\n",
              " (' 25  32  28 ', 3),\n",
              " (' 40  4 47 ', 3),\n",
              " (' 15  4 28 ', 3),\n",
              " ('2  15  9 ', 3),\n",
              " (' 13  4 19 ', 3),\n",
              " ('13  4 45 ', 3),\n",
              " (' 14  4 45 ', 3),\n",
              " (' 36  4 42 ', 3),\n",
              " ('13  23  22 ', 3),\n",
              " (' 11  26  21 ', 3),\n",
              " ('10  16  13 ', 3),\n",
              " (' 13  21  18 ', 3),\n",
              " ('17  4 37 ', 3),\n",
              " (' 10  20  17 ', 3),\n",
              " (' 42  4 47 ', 3),\n",
              " (' 34  4 44 ', 3),\n",
              " (' 14  31  27 ', 3),\n",
              " (' 14  4 30 ', 3),\n",
              " ('12  4 37 ', 3),\n",
              " (' 13  4 25 ', 3),\n",
              " ('01  4 12 ', 3),\n",
              " ('03  3 05 ', 3),\n",
              " ('08  4 20 ', 3),\n",
              " (' 13  4 28 ', 3),\n",
              " ('03  4 12 ', 3),\n",
              " ('03  4 31 ', 3),\n",
              " ('02  4 26 ', 3),\n",
              " ('04  4 28 ', 3),\n",
              " (' 06  4 38 ', 3),\n",
              " ('04  4 07 ', 3),\n",
              " (' 11  4 18 ', 3),\n",
              " ('01  4 10 ', 3),\n",
              " ('02  3 03 ', 3),\n",
              " ('02  33  18 ', 3),\n",
              " (' 08  4 15 ', 3),\n",
              " (' 03  4 33 ', 3),\n",
              " (' 07  4 14 ', 3),\n",
              " ('05  4 27 ', 3),\n",
              " ('02  3 08 ', 3),\n",
              " ('04  4 21 ', 3),\n",
              " ('03  4 06 ', 3),\n",
              " (' 12  4 19 ', 3),\n",
              " ('22  4 30 ', 3),\n",
              " (' 12  3 31 ', 3),\n",
              " ('02  4 29 ', 3),\n",
              " ('06  3 26 ', 3),\n",
              " ('03  4 19 ', 3),\n",
              " ('02  4 04 ', 3),\n",
              " ('02  4 09 ', 3),\n",
              " ('07  4 29 ', 3),\n",
              " (' 12  4 33 ', 3),\n",
              " (' 12  4 42 ', 3),\n",
              " ('02  4 39 ', 3),\n",
              " ('02  4 42 ', 3),\n",
              " (' 05  4 17 ', 3),\n",
              " (' 07  4 17 ', 3),\n",
              " ('13  4 30 ', 3),\n",
              " ('06  4 32 ', 3),\n",
              " (' 10  3 11 ', 3),\n",
              " ('04  3 20 ', 3),\n",
              " (' 26  4 44 ', 3),\n",
              " (' 08  4 09 ', 3),\n",
              " (' 08  4 20 ', 3),\n",
              " (' 10  4 18 ', 3),\n",
              " ('04  4 08 ', 3),\n",
              " ('02  22  14 ', 3),\n",
              " ('09  29  28 ', 3),\n",
              " ('02  3 22 ', 3),\n",
              " (' 14  4 16 ', 3),\n",
              " ('04  4 10 ', 3),\n",
              " (' 10  4 30 ', 3),\n",
              " ('05  4 21 ', 3),\n",
              " (' 08  4 45 ', 3),\n",
              " ('01  3 13 ', 3),\n",
              " ('03  4 10 ', 3),\n",
              " ('01  4 19 ', 3),\n",
              " ('01  39  28 ', 3),\n",
              " ('3  16  14 ', 3),\n",
              " (' 14  27  16 ', 3),\n",
              " (' 11  25  16 ', 3),\n",
              " ('2  30  5 ', 3),\n",
              " ('2  31  14 ', 3),\n",
              " ('3  47 46 ', 3),\n",
              " (' 15  27  16 ', 3),\n",
              " ('5  29  24 ', 3),\n",
              " ('5  45 24 ', 3),\n",
              " ('5  45 41 ', 3),\n",
              " ('11  41  18 ', 3),\n",
              " (' 18  4 30 ', 3),\n",
              " (' 18  41  40 ', 3),\n",
              " ('18  32  29 ', 3),\n",
              " ('2  22  16 ', 3),\n",
              " ('11  3 33 ', 3),\n",
              " ('2  30  13 ', 3),\n",
              " (' 17  35  33 ', 3),\n",
              " (' 28  4 35 ', 3),\n",
              " (' 36  41 38 ', 3),\n",
              " (' 20  4 23 ', 3),\n",
              " ('1  49\" 6 ', 3),\n",
              " (' 38  4 44 ', 3),\n",
              " ('2  27  9 ', 3),\n",
              " ('7  17  13 ', 3),\n",
              " (' 13  16  14 ', 3),\n",
              " (' 13  17  16 ', 3),\n",
              " (' 14  17  16 ', 3),\n",
              " ('1  16  13 ', 3),\n",
              " ('1  19  13 ', 3),\n",
              " ('1  40  37 ', 3),\n",
              " (' 10  47 35 ', 3),\n",
              " (' 17  32  31 ', 3),\n",
              " (' 13  31  27 ', 3),\n",
              " ('12  41  19 ', 3),\n",
              " (' 19  4 35 ', 3),\n",
              " (' 19  4 41 ', 3),\n",
              " (' 21  39  37 ', 3),\n",
              " ('1  32  21 ', 3),\n",
              " (' 21  33  26 ', 3),\n",
              " ('13  28  25 ', 3),\n",
              " ('13  3 28 ', 3),\n",
              " (' 28  3 31 ', 3),\n",
              " ('11  3 14 ', 3),\n",
              " ('3  30  8 ', 3),\n",
              " (' 18  38  27 ', 3),\n",
              " (' 18  4 27 ', 3),\n",
              " (' 16  36  23 ', 3),\n",
              " ('2  25  7 ', 3),\n",
              " ('5  28  9 ', 3),\n",
              " ('8  36  15 ', 3),\n",
              " ('11  4 33 ', 3),\n",
              " ('11  4 45 ', 3),\n",
              " (' 33  4 45 ', 3),\n",
              " ('20  4 24 ', 3),\n",
              " ('2  37\" 22 ', 3),\n",
              " ('2  41 35 ', 3),\n",
              " (' 10  36  35 ', 3),\n",
              " ('3  16  4 ', 3),\n",
              " ('3  16  5 ', 3),\n",
              " ('20  4 41 ', 3),\n",
              " (' 23  4 37 ', 3),\n",
              " (' 30  3 35 ', 3),\n",
              " ('3  25  22 ', 3),\n",
              " (' 10  31  27 ', 3),\n",
              " (' 19  4 45 ', 3),\n",
              " (' 30  4 43 ', 3),\n",
              " (' 43  4 45 ', 3),\n",
              " ('7  15  11 ', 3),\n",
              " ('5  11  8 ', 3),\n",
              " ('5  25  8 ', 3),\n",
              " ('1  7  3 ', 3),\n",
              " ('7  22  16 ', 3),\n",
              " ('14  4 23 ', 3),\n",
              " (' 20  4 21 ', 3),\n",
              " (' 32  4 35 ', 3),\n",
              " (' 33  4 34 ', 3),\n",
              " ('11  3 24 ', 3),\n",
              " (' 24  3 28 ', 3),\n",
              " ('3  7  5 ', 3),\n",
              " ('18  4 34 ', 3),\n",
              " (' 29  38  34 ', 3),\n",
              " (' 32  43  33 ', 3),\n",
              " (' 10  30  23 ', 3),\n",
              " ('1  17  9 ', 3),\n",
              " (' 26  4 45 ', 3),\n",
              " ('6  26  18 ', 3),\n",
              " ('6  41 34 ', 3),\n",
              " ('17  4 38 ', 3),\n",
              " (' 30  40  38 ', 3),\n",
              " ('4  19  16 ', 3),\n",
              " (' 27  36  32 ', 3),\n",
              " ('7  28  12 ', 3),\n",
              " (' 12  28  17 ', 3),\n",
              " (' 16  27  25 ', 3),\n",
              " (' 15  21  16 ', 3),\n",
              " ('19  4 31 ', 3),\n",
              " (' 20  28  26 ', 3),\n",
              " (' 20  4 31 ', 3),\n",
              " ('2  36  18 ', 3),\n",
              " ('1  26  15 ', 3),\n",
              " ('8  11  10 ', 3),\n",
              " (' 10  21  11 ', 3),\n",
              " (' 10  21  19 ', 3),\n",
              " (' 42  4 43 ', 3),\n",
              " ('4  30  21 ', 3),\n",
              " ('4  21  16 ', 3),\n",
              " ('12  3 25 ', 3),\n",
              " (' 13  3 25 ', 3),\n",
              " (' 25  3 30 ', 3),\n",
              " ('4  34 19 ', 3),\n",
              " (' 19  34 26 ', 3),\n",
              " ('1  44  16 ', 3),\n",
              " ('1  46 44 ', 3),\n",
              " ('4  29  19 ', 3),\n",
              " ('4  29  21 ', 3),\n",
              " (' 19  29  21 ', 3),\n",
              " ('7  48 16 ', 3),\n",
              " ('12  4 20 ', 3),\n",
              " ('1  30  26 ', 3),\n",
              " (' 26  39  30 ', 3),\n",
              " ('12  46  26 ', 3),\n",
              " ('16  4 18 ', 3),\n",
              " (' 18  4 39 ', 3),\n",
              " (' 24  32  25 ', 3),\n",
              " (' 24  32  31 ', 3),\n",
              " (' 16  46 45 ', 3),\n",
              " ('6  35  19 ', 3),\n",
              " (' 13  4 40 ', 3),\n",
              " (' 20  27  21 ', 3),\n",
              " ('1  42\" 14 ', 3),\n",
              " ('10  26  13 ', 3),\n",
              " ('1  44 37 ', 3),\n",
              " (' 19  3 31 ', 3),\n",
              " (' 23  34  31 ', 3),\n",
              " (' 11  27  21 ', 3),\n",
              " ('8  37  17 ', 3),\n",
              " ('8  27  18 ', 3),\n",
              " ('3  47\" 18 ', 3),\n",
              " (' 18  47\" 40 ', 3),\n",
              " (' 20  30  25 ', 3),\n",
              " (' 16  3 24 ', 3),\n",
              " ('15  4 34 ', 3),\n",
              " ...]"
            ]
          },
          "metadata": {},
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hEH7bFCL7jYP"
      },
      "source": [
        "# You can find Question-4 Answer Below"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "cFTpX0aTviDj",
        "outputId": "1ea87455-b3e9-4a1f-8c33-f076e0ff2d57"
      },
      "source": [
        "\n",
        "from pyspark import SparkContext\n",
        "sc = SparkContext.getOrCreate()\n",
        "\n",
        "DollarRDD = sc.textFile('dollarnoempty.txt')\n",
        "DollarRDD = DollarRDD.filter(lambda a:  a !='')\n",
        "\n",
        "\n",
        "def splitAndTake(line):\n",
        "  arr = line.split(\"\\t\")\n",
        "  index = int(arr[0])\n",
        "  date = arr[1]\n",
        "  dollar_value1 = arr[2].replace('.','')\n",
        "  dollar_value = float(dollar_value1.replace(',','.'))\n",
        "  #dollar_value =  dollar_value2.replace('','bno')\n",
        "  return date,dollar_value\n",
        "\n",
        "\n",
        "\n",
        "DollarRDD = DollarRDD.map(lambda x : splitAndTake(x) )\n",
        "#DollarRDD = DollarRDD.sortBy(lambda y : y[0], ascending= True)\n",
        "DollarRDD = DollarRDD.zipWithIndex()\n",
        "DollarRDD = DollarRDD.map(lambda x : (x[1],x[0]))\n",
        "\n",
        "\n",
        "\n",
        "DollarRDD2 = DollarRDD\n",
        "DollarRDD2 = DollarRDD2.map(lambda b : (b[0]+1,b[1]))\n",
        "\n",
        "DollarRDD2.take(3)\n",
        "\n",
        "DollarRDD2joined = DollarRDD2.join(DollarRDD)\n",
        "#DollarRDD2joined = DollarRDD2joined.flatMap(lambda c : c)\n",
        "#DollarRDD2joined = DollarRDD2joined.map(lambda c : (c[0][1][1] - c[0][1][0] ))\n",
        "DollarRDD2joined.collect()\n",
        "\n",
        "\n",
        "#DollarRDD = DollarRDD.filter(lambda y: '' not in y )\n",
        "#DollarRDD = DollarRDD.map(lambda z : convertToFloat(z) )\n",
        "\n",
        "#DollarRDD = DollarRDD.flatMap(lambda a : a )\n",
        "\n",
        "#DollarRDD = DollarRDD.filter(lambda z : '2.80' in z )\n",
        "#DollarRDD = DollarRDD.map(lambda d : d.convertToFloat() )\n",
        "\n",
        "\n",
        "#joinedDF = joinedDF.withColumn('oran', (joinedDF[\"fiyat\"]*100/joinedDF[\"fiyat2\"])-100)\n",
        "\n",
        "#joinedDF = joinedDF.sort('oran',ascending=False)\n",
        "\n",
        "\n",
        "\n"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "error",
          "ename": "Py4JJavaError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mPy4JJavaError\u001b[0m                             Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-9-c3de965f0c98>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     33\u001b[0m \u001b[0;31m#DollarRDD2joined = DollarRDD2joined.flatMap(lambda c : c)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     34\u001b[0m \u001b[0mDollarRDD2joined\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mDollarRDD2joined\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmap\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mc\u001b[0m \u001b[0;34m:\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m-\u001b[0m \u001b[0mc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 35\u001b[0;31m \u001b[0mDollarRDD2joined\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     36\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     37\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pyspark/rdd.py\u001b[0m in \u001b[0;36mcollect\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    947\u001b[0m         \"\"\"\n\u001b[1;32m    948\u001b[0m         \u001b[0;32mwith\u001b[0m \u001b[0mSCCallSiteSync\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontext\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mcss\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 949\u001b[0;31m             \u001b[0msock_info\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mctx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jvm\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mPythonRDD\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollectAndServe\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jrdd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrdd\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    950\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_load_from_socket\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msock_info\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jrdd_deserializer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    951\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36m__call__\u001b[0;34m(self, *args)\u001b[0m\n\u001b[1;32m   1303\u001b[0m         \u001b[0manswer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgateway_client\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1304\u001b[0m         return_value = get_return_value(\n\u001b[0;32m-> 1305\u001b[0;31m             answer, self.gateway_client, self.target_id, self.name)\n\u001b[0m\u001b[1;32m   1306\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1307\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mtemp_arg\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mtemp_args\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/protocol.py\u001b[0m in \u001b[0;36mget_return_value\u001b[0;34m(answer, gateway_client, target_id, name)\u001b[0m\n\u001b[1;32m    326\u001b[0m                 raise Py4JJavaError(\n\u001b[1;32m    327\u001b[0m                     \u001b[0;34m\"An error occurred while calling {0}{1}{2}.\\n\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 328\u001b[0;31m                     format(target_id, \".\", name), value)\n\u001b[0m\u001b[1;32m    329\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 raise Py4JError(\n",
            "\u001b[0;31mPy4JJavaError\u001b[0m: An error occurred while calling z:org.apache.spark.api.python.PythonRDD.collectAndServe.\n: org.apache.spark.SparkException: Job aborted due to stage failure: Task 1 in stage 31.0 failed 1 times, most recent failure: Lost task 1.0 in stage 31.0 (TID 76) (45a504a12265 executor driver): org.apache.spark.api.python.PythonException: Traceback (most recent call last):\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 604, in main\n    process()\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 596, in process\n    serializer.dump_stream(out_iter, outfile)\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/serializers.py\", line 259, in dump_stream\n    vs = list(itertools.islice(iterator, batch))\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/util.py\", line 73, in wrapper\n    return f(*args, **kwargs)\n  File \"<ipython-input-9-c3de965f0c98>\", line 34, in <lambda>\nTypeError: 'int' object is not subscriptable\n\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.handlePythonException(PythonRunner.scala:517)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:652)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:635)\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.hasNext(PythonRunner.scala:470)\n\tat org.apache.spark.InterruptibleIterator.hasNext(InterruptibleIterator.scala:37)\n\tat scala.collection.Iterator.foreach(Iterator.scala:941)\n\tat scala.collection.Iterator.foreach$(Iterator.scala:941)\n\tat org.apache.spark.InterruptibleIterator.foreach(InterruptibleIterator.scala:28)\n\tat scala.collection.generic.Growable.$plus$plus$eq(Growable.scala:62)\n\tat scala.collection.generic.Growable.$plus$plus$eq$(Growable.scala:53)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:105)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:49)\n\tat scala.collection.TraversableOnce.to(TraversableOnce.scala:315)\n\tat scala.collection.TraversableOnce.to$(TraversableOnce.scala:313)\n\tat org.apache.spark.InterruptibleIterator.to(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toBuffer(TraversableOnce.scala:307)\n\tat scala.collection.TraversableOnce.toBuffer$(TraversableOnce.scala:307)\n\tat org.apache.spark.InterruptibleIterator.toBuffer(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toArray(TraversableOnce.scala:294)\n\tat scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:288)\n\tat org.apache.spark.InterruptibleIterator.toArray(InterruptibleIterator.scala:28)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$2(RDD.scala:1030)\n\tat org.apache.spark.SparkContext.$anonfun$runJob$5(SparkContext.scala:2236)\n\tat org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)\n\tat org.apache.spark.scheduler.Task.run(Task.scala:131)\n\tat org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)\n\tat org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1439)\n\tat org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n\nDriver stacktrace:\n\tat org.apache.spark.scheduler.DAGScheduler.failJobAndIndependentStages(DAGScheduler.scala:2258)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$abortStage$2(DAGScheduler.scala:2207)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$abortStage$2$adapted(DAGScheduler.scala:2206)\n\tat scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)\n\tat scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)\n\tat scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)\n\tat org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:2206)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$handleTaskSetFailed$1(DAGScheduler.scala:1079)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$handleTaskSetFailed$1$adapted(DAGScheduler.scala:1079)\n\tat scala.Option.foreach(Option.scala:407)\n\tat org.apache.spark.scheduler.DAGScheduler.handleTaskSetFailed(DAGScheduler.scala:1079)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.doOnReceive(DAGScheduler.scala:2445)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.onReceive(DAGScheduler.scala:2387)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.onReceive(DAGScheduler.scala:2376)\n\tat org.apache.spark.util.EventLoop$$anon$1.run(EventLoop.scala:49)\n\tat org.apache.spark.scheduler.DAGScheduler.runJob(DAGScheduler.scala:868)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2196)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2217)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2236)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2261)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$1(RDD.scala:1030)\n\tat org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)\n\tat org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)\n\tat org.apache.spark.rdd.RDD.withScope(RDD.scala:414)\n\tat org.apache.spark.rdd.RDD.collect(RDD.scala:1029)\n\tat org.apache.spark.api.python.PythonRDD$.collectAndServe(PythonRDD.scala:180)\n\tat org.apache.spark.api.python.PythonRDD.collectAndServe(PythonRDD.scala)\n\tat sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)\n\tat py4j.Gateway.invoke(Gateway.java:282)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.GatewayConnection.run(GatewayConnection.java:238)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: org.apache.spark.api.python.PythonException: Traceback (most recent call last):\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 604, in main\n    process()\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 596, in process\n    serializer.dump_stream(out_iter, outfile)\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/serializers.py\", line 259, in dump_stream\n    vs = list(itertools.islice(iterator, batch))\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/util.py\", line 73, in wrapper\n    return f(*args, **kwargs)\n  File \"<ipython-input-9-c3de965f0c98>\", line 34, in <lambda>\nTypeError: 'int' object is not subscriptable\n\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.handlePythonException(PythonRunner.scala:517)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:652)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:635)\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.hasNext(PythonRunner.scala:470)\n\tat org.apache.spark.InterruptibleIterator.hasNext(InterruptibleIterator.scala:37)\n\tat scala.collection.Iterator.foreach(Iterator.scala:941)\n\tat scala.collection.Iterator.foreach$(Iterator.scala:941)\n\tat org.apache.spark.InterruptibleIterator.foreach(InterruptibleIterator.scala:28)\n\tat scala.collection.generic.Growable.$plus$plus$eq(Growable.scala:62)\n\tat scala.collection.generic.Growable.$plus$plus$eq$(Growable.scala:53)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:105)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:49)\n\tat scala.collection.TraversableOnce.to(TraversableOnce.scala:315)\n\tat scala.collection.TraversableOnce.to$(TraversableOnce.scala:313)\n\tat org.apache.spark.InterruptibleIterator.to(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toBuffer(TraversableOnce.scala:307)\n\tat scala.collection.TraversableOnce.toBuffer$(TraversableOnce.scala:307)\n\tat org.apache.spark.InterruptibleIterator.toBuffer(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toArray(TraversableOnce.scala:294)\n\tat scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:288)\n\tat org.apache.spark.InterruptibleIterator.toArray(InterruptibleIterator.scala:28)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$2(RDD.scala:1030)\n\tat org.apache.spark.SparkContext.$anonfun$runJob$5(SparkContext.scala:2236)\n\tat org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)\n\tat org.apache.spark.scheduler.Task.run(Task.scala:131)\n\tat org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)\n\tat org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1439)\n\tat org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\t... 1 more\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "Uk9SdYECahly",
        "outputId": "569649c0-ce5a-4597-fb04-5ddcf8452498"
      },
      "source": [
        "\n",
        "rdd = sc.parallelize([ (\"09-06-2021\",123) ,(\"09-07-2021\",133) ,(\"09-08-2021\",142)])\n",
        "rdd = rdd.zipWithIndex()\n",
        "rdd = rdd.map(lambda x : (x[1],x[0]))\n",
        "rdd2 = rdd\n",
        "rdd.collect()\n",
        "rdd2 = rdd2.map(lambda b : (b[0]+1,b[1]))\n",
        "rdd3 = rdd2.join(rdd)\n",
        "\n",
        "rdd3 = rdd3.map(lambda z : (z[0][1][1][1]-z[0][1][0][1]))\n",
        "rdd3.collect()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "error",
          "ename": "Py4JJavaError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mPy4JJavaError\u001b[0m                             Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-15-e736443455de>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      9\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     10\u001b[0m \u001b[0mrdd3\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mrdd3\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmap\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mz\u001b[0m \u001b[0;34m:\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mz\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0mz\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 11\u001b[0;31m \u001b[0mrdd3\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pyspark/rdd.py\u001b[0m in \u001b[0;36mcollect\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    947\u001b[0m         \"\"\"\n\u001b[1;32m    948\u001b[0m         \u001b[0;32mwith\u001b[0m \u001b[0mSCCallSiteSync\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontext\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mcss\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 949\u001b[0;31m             \u001b[0msock_info\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mctx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jvm\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mPythonRDD\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollectAndServe\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jrdd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrdd\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    950\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_load_from_socket\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msock_info\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jrdd_deserializer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    951\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36m__call__\u001b[0;34m(self, *args)\u001b[0m\n\u001b[1;32m   1303\u001b[0m         \u001b[0manswer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgateway_client\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1304\u001b[0m         return_value = get_return_value(\n\u001b[0;32m-> 1305\u001b[0;31m             answer, self.gateway_client, self.target_id, self.name)\n\u001b[0m\u001b[1;32m   1306\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1307\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mtemp_arg\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mtemp_args\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/py4j/protocol.py\u001b[0m in \u001b[0;36mget_return_value\u001b[0;34m(answer, gateway_client, target_id, name)\u001b[0m\n\u001b[1;32m    326\u001b[0m                 raise Py4JJavaError(\n\u001b[1;32m    327\u001b[0m                     \u001b[0;34m\"An error occurred while calling {0}{1}{2}.\\n\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 328\u001b[0;31m                     format(target_id, \".\", name), value)\n\u001b[0m\u001b[1;32m    329\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 raise Py4JError(\n",
            "\u001b[0;31mPy4JJavaError\u001b[0m: An error occurred while calling z:org.apache.spark.api.python.PythonRDD.collectAndServe.\n: org.apache.spark.SparkException: Job aborted due to stage failure: Task 1 in stage 47.0 failed 1 times, most recent failure: Lost task 1.0 in stage 47.0 (TID 121) (45a504a12265 executor driver): org.apache.spark.api.python.PythonException: Traceback (most recent call last):\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 604, in main\n    process()\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 596, in process\n    serializer.dump_stream(out_iter, outfile)\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/serializers.py\", line 259, in dump_stream\n    vs = list(itertools.islice(iterator, batch))\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/util.py\", line 73, in wrapper\n    return f(*args, **kwargs)\n  File \"<ipython-input-15-e736443455de>\", line 10, in <lambda>\nTypeError: 'int' object is not subscriptable\n\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.handlePythonException(PythonRunner.scala:517)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:652)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:635)\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.hasNext(PythonRunner.scala:470)\n\tat org.apache.spark.InterruptibleIterator.hasNext(InterruptibleIterator.scala:37)\n\tat scala.collection.Iterator.foreach(Iterator.scala:941)\n\tat scala.collection.Iterator.foreach$(Iterator.scala:941)\n\tat org.apache.spark.InterruptibleIterator.foreach(InterruptibleIterator.scala:28)\n\tat scala.collection.generic.Growable.$plus$plus$eq(Growable.scala:62)\n\tat scala.collection.generic.Growable.$plus$plus$eq$(Growable.scala:53)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:105)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:49)\n\tat scala.collection.TraversableOnce.to(TraversableOnce.scala:315)\n\tat scala.collection.TraversableOnce.to$(TraversableOnce.scala:313)\n\tat org.apache.spark.InterruptibleIterator.to(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toBuffer(TraversableOnce.scala:307)\n\tat scala.collection.TraversableOnce.toBuffer$(TraversableOnce.scala:307)\n\tat org.apache.spark.InterruptibleIterator.toBuffer(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toArray(TraversableOnce.scala:294)\n\tat scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:288)\n\tat org.apache.spark.InterruptibleIterator.toArray(InterruptibleIterator.scala:28)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$2(RDD.scala:1030)\n\tat org.apache.spark.SparkContext.$anonfun$runJob$5(SparkContext.scala:2236)\n\tat org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)\n\tat org.apache.spark.scheduler.Task.run(Task.scala:131)\n\tat org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)\n\tat org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1439)\n\tat org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n\nDriver stacktrace:\n\tat org.apache.spark.scheduler.DAGScheduler.failJobAndIndependentStages(DAGScheduler.scala:2258)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$abortStage$2(DAGScheduler.scala:2207)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$abortStage$2$adapted(DAGScheduler.scala:2206)\n\tat scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)\n\tat scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)\n\tat scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)\n\tat org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:2206)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$handleTaskSetFailed$1(DAGScheduler.scala:1079)\n\tat org.apache.spark.scheduler.DAGScheduler.$anonfun$handleTaskSetFailed$1$adapted(DAGScheduler.scala:1079)\n\tat scala.Option.foreach(Option.scala:407)\n\tat org.apache.spark.scheduler.DAGScheduler.handleTaskSetFailed(DAGScheduler.scala:1079)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.doOnReceive(DAGScheduler.scala:2445)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.onReceive(DAGScheduler.scala:2387)\n\tat org.apache.spark.scheduler.DAGSchedulerEventProcessLoop.onReceive(DAGScheduler.scala:2376)\n\tat org.apache.spark.util.EventLoop$$anon$1.run(EventLoop.scala:49)\n\tat org.apache.spark.scheduler.DAGScheduler.runJob(DAGScheduler.scala:868)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2196)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2217)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2236)\n\tat org.apache.spark.SparkContext.runJob(SparkContext.scala:2261)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$1(RDD.scala:1030)\n\tat org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)\n\tat org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)\n\tat org.apache.spark.rdd.RDD.withScope(RDD.scala:414)\n\tat org.apache.spark.rdd.RDD.collect(RDD.scala:1029)\n\tat org.apache.spark.api.python.PythonRDD$.collectAndServe(PythonRDD.scala:180)\n\tat org.apache.spark.api.python.PythonRDD.collectAndServe(PythonRDD.scala)\n\tat sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)\n\tat py4j.Gateway.invoke(Gateway.java:282)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.GatewayConnection.run(GatewayConnection.java:238)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: org.apache.spark.api.python.PythonException: Traceback (most recent call last):\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 604, in main\n    process()\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/worker.py\", line 596, in process\n    serializer.dump_stream(out_iter, outfile)\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/serializers.py\", line 259, in dump_stream\n    vs = list(itertools.islice(iterator, batch))\n  File \"/usr/local/lib/python3.7/dist-packages/pyspark/python/lib/pyspark.zip/pyspark/util.py\", line 73, in wrapper\n    return f(*args, **kwargs)\n  File \"<ipython-input-15-e736443455de>\", line 10, in <lambda>\nTypeError: 'int' object is not subscriptable\n\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.handlePythonException(PythonRunner.scala:517)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:652)\n\tat org.apache.spark.api.python.PythonRunner$$anon$3.read(PythonRunner.scala:635)\n\tat org.apache.spark.api.python.BasePythonRunner$ReaderIterator.hasNext(PythonRunner.scala:470)\n\tat org.apache.spark.InterruptibleIterator.hasNext(InterruptibleIterator.scala:37)\n\tat scala.collection.Iterator.foreach(Iterator.scala:941)\n\tat scala.collection.Iterator.foreach$(Iterator.scala:941)\n\tat org.apache.spark.InterruptibleIterator.foreach(InterruptibleIterator.scala:28)\n\tat scala.collection.generic.Growable.$plus$plus$eq(Growable.scala:62)\n\tat scala.collection.generic.Growable.$plus$plus$eq$(Growable.scala:53)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:105)\n\tat scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:49)\n\tat scala.collection.TraversableOnce.to(TraversableOnce.scala:315)\n\tat scala.collection.TraversableOnce.to$(TraversableOnce.scala:313)\n\tat org.apache.spark.InterruptibleIterator.to(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toBuffer(TraversableOnce.scala:307)\n\tat scala.collection.TraversableOnce.toBuffer$(TraversableOnce.scala:307)\n\tat org.apache.spark.InterruptibleIterator.toBuffer(InterruptibleIterator.scala:28)\n\tat scala.collection.TraversableOnce.toArray(TraversableOnce.scala:294)\n\tat scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:288)\n\tat org.apache.spark.InterruptibleIterator.toArray(InterruptibleIterator.scala:28)\n\tat org.apache.spark.rdd.RDD.$anonfun$collect$2(RDD.scala:1030)\n\tat org.apache.spark.SparkContext.$anonfun$runJob$5(SparkContext.scala:2236)\n\tat org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)\n\tat org.apache.spark.scheduler.Task.run(Task.scala:131)\n\tat org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)\n\tat org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1439)\n\tat org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\t... 1 more\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pwcshJbE2xMN"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mEzOEsrver43"
      },
      "source": [
        "#You can find Question-5 Answer Below"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7oT-ymxTey1E"
      },
      "source": [
        "\n",
        "\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YXjsAumGuyFh"
      },
      "source": [
        "from pyspark import SparkContext\n",
        "from geopy import distance\n",
        "import geopy.distance\n",
        "sc = SparkContext.getOrCreate()\n",
        "CapitalsRDD = sc.textFile('Capitals.txt')\n",
        "#CapitalsRDD.take(4)\n",
        "\n",
        "def splitAndTake(line):\n",
        "  arr = line.split(\"\\t\")\n",
        "  countryCapital = arr[1] + \"-\" + arr[2]\n",
        "  enlem = float(arr[3].replace(\",\",\".\"))\n",
        "  boylam = float(arr[4].replace(\",\",\".\"))\n",
        "\n",
        "  return (countryCapital,enlem,boylam)\n",
        "\n",
        " \n",
        "CapitalsRDD = CapitalsRDD.map(lambda x: splitAndTake(x))\n",
        "#CapitalsRDD = CapitalsRDD.filter(lambda y : 'Saint Martin -Marigot ' in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda y : 'Nauru -Yaren ' not in y)\n",
        "CapitalsRDD = CapitalsRDD.filter(lambda z : 'Tokelau -Nukunonu ' not in z)\n",
        "#CapitalsRDD.collect()\n",
        "\n",
        "\n",
        "\n",
        "CapitalsRDD2 = CapitalsRDD.cartesian(CapitalsRDD)\n",
        "CapitalsRDD2 = CapitalsRDD2.map(lambda a : (a[0][0],a[1][0],geopy.distance.great_circle((a[0][1],a[0][2]),(a[1][1],a[1][2])).km ))\n",
        "CapitalsRDD2 = CapitalsRDD2.filter(lambda b : b[2] > 0.0)\n",
        "CapitalsRDD2 = CapitalsRDD2.sortBy(lambda c : c[2], ascending=False)\n",
        "CapitalsRDD2.collect()"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}