path.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "DB_ULR = \"neo4j://localhost:7687\"\n",
    "DB_USER = \"neo4j\"\n",
    "DB_PASS = \"test1234\"\n",
    "DB_NAME = \"opensanctions\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Create driver\n",
    "Also set the DB_NAME"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "from graphdatascience import GraphDataScience # Python GDS client\n",
    "import numpy as np\n",
    "import threading\n",
    "import multiprocessing\n",
    "\n",
    "# And some cermony to create the driver and gds objects´\n",
    "gds = GraphDataScience(DB_ULR, auth=(DB_USER, DB_PASS))\n",
    "gds.set_database(DB_NAME)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>nodeProjection</th>\n",
       "      <th>relationshipProjection</th>\n",
       "      <th>graphName</th>\n",
       "      <th>nodeCount</th>\n",
       "      <th>relationshipCount</th>\n",
       "      <th>projectMillis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'__ALL__': {'label': '*', 'properties': {}}}</td>\n",
       "      <td>{'HAS_IDENTIFIER': {'orientation': 'UNDIRECTED...</td>\n",
       "      <td>test</td>\n",
       "      <td>2409145</td>\n",
       "      <td>7361736</td>\n",
       "      <td>283</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  nodeProjection  \\\n",
       "0  {'__ALL__': {'label': '*', 'properties': {}}}   \n",
       "\n",
       "                              relationshipProjection graphName  nodeCount  \\\n",
       "0  {'HAS_IDENTIFIER': {'orientation': 'UNDIRECTED...      test    2409145   \n",
       "\n",
       "   relationshipCount  projectMillis  \n",
       "0            7361736            283  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gds.run_cypher(\n",
    "    \"\"\" \n",
    "    CALL gds.graph.project('test','*',\n",
    "        {\n",
    "            HAS_IDENTIFIER: {orientation: 'UNDIRECTED'},\n",
    "            ENTITY: {orientation: 'UNDIRECTED'},\n",
    "            HAS_NAME: {orientation: 'UNDIRECTED'},\n",
    "            ADDRESS_ENTITY: {orientation: 'UNDIRECTED'},\n",
    "            UNKNOWN_LINK: {orientation: 'UNDIRECTED'},\n",
    "            OWNERSHIP: {orientation: 'UNDIRECTED'},\n",
    "            HAS_PHONE: {orientation: 'UNDIRECTED'},\n",
    "            HAS_EMAIL: {orientation: 'UNDIRECTED'},\n",
    "            OWNER: {orientation: 'UNDIRECTED'},\n",
    "            DIRECTORSHIP: {orientation: 'UNDIRECTED'},\n",
    "            REPRESENTATION: {orientation: 'UNDIRECTED'},\n",
    "            HOLDER: {orientation: 'UNDIRECTED'},\n",
    "            MEMBERSHIP: {orientation: 'UNDIRECTED'},\n",
    "            ISSUER: {orientation: 'UNDIRECTED'},\n",
    "            FAMILY: {orientation: 'UNDIRECTED'},\n",
    "            ASSOCIATE: {orientation: 'UNDIRECTED'}\n",
    "        }\n",
    "    )\n",
    "    \"\"\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "G = gds.graph.get('test');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "politicians = gds.run_cypher(\"MATCH (p:Politician) return id(p) as id limit 300000\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3365985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3366214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3366282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3366356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3366460</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        id\n",
       "0  3365985\n",
       "1  3366214\n",
       "2  3366282\n",
       "3  3366356\n",
       "4  3366460"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "politicians.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nthreads = multiprocessing.cpu_count()\n",
    "nthreads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "chunks = np.array_split(politicians, nthreads)\n",
    "all_threads = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "def worker(chunk, result, i):\n",
    "    paths=gds.run_cypher(\n",
    "        \"\"\" \n",
    "        MATCH (p:Politician) where id(p) in $ids\n",
    "        with p\n",
    "        call {\n",
    "            with p\n",
    "            CALL gds.allShortestPaths.dijkstra.stream('test', {\n",
    "            sourceNode: p\n",
    "            })\n",
    "            YIELD index, targetNode, totalCost, path+\n",
    "            with index, totalCost, path, gds.util.asNode(targetNode) as target\n",
    "            where target:SanctionedEntity\n",
    "            RETURN\n",
    "                index,\n",
    "                target,\n",
    "                totalCost,\n",
    "                path\n",
    "            LIMIT 1\n",
    "        }\n",
    "        return index,\n",
    "                target,\n",
    "                totalCost,\n",
    "                nodes(path) as path\n",
    "        \"\"\",\n",
    "        params = { 'ids' : chunk['id'].to_list()  }\n",
    "    )\n",
    "    result[i] = paths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "result = [None] * nthreads\n",
    "for i in range(nthreads):\n",
    "    thread = threading.Thread(target=worker, args=(chunks[i], result, i ))\n",
    "    all_threads.append(thread)\n",
    "    thread.start()\n",
    "\n",
    "for thread in all_threads:\n",
    "    thread.join()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[        index                                             target  totalCost  \\\n",
       " 0           0  (passportNumber, country, dissolutionDate, swi...        0.0   \n",
       " 1           0  (passportNumber, country, dissolutionDate, swi...        0.0   \n",
       " 2           0  (passportNumber, country, dissolutionDate, swi...        0.0   \n",
       " 3           0  (passportNumber, country, dissolutionDate, swi...        0.0   \n",
       " 4           0  (passportNumber, country, dissolutionDate, swi...        0.0   \n",
       " ...       ...                                                ...        ...   \n",
       " 13200    3932  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 13201    3234  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 13202    1588  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 13203  123115  (country, dissolutionDate, swiftBic, previousN...        7.0   \n",
       " 13204     855  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " \n",
       "                                                     path  \n",
       " 0      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4      [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                  ...  \n",
       " 13200  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13201  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13202  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13203  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13204  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [13205 rows x 4 columns],\n",
       "        index                                             target  totalCost  \\\n",
       " 0        364  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 1          5  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 2      17651  (passportNumber, country, dissolutionDate, swi...        8.0   \n",
       " 3       3822  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4       6197  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " ...      ...                                                ...        ...   \n",
       " 13082      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 13083   2744  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 13084   1208  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 13085   6178  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 13086   4984  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " \n",
       "                                                     path  \n",
       " 0      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3      [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4      [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                  ...  \n",
       " 13082  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13083  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13084  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13085  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 13086  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [13087 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      4980  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 1       490  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 2     10154  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 3         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 4        12  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 6490   5087  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6491   2061  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 6492   5814  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6493   5354  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6494   2797  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 6490  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6491  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6492  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6493  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6494  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [6495 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      5021  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 1      5021  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 2      5402  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 3      5084  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4      5170  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 8082      5  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 8083  12925  (passportNumber, country, dissolutionDate, swi...        8.0   \n",
       " 8084   5968  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8085   2216  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8086    220  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 8082  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8083  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8084  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8085  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8086  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [8087 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      2349  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 1      2079  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 2      4554  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 3      2279  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4      2279  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 7606  50373  (passportNumber, country, dissolutionDate, swi...        8.0   \n",
       " 7607      5  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 7608  17860  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 7609   4464  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 7610   4649  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 7606  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 7607  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 7608  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 7609  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 7610  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [7611 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      5826  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 1      4852  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 2      5015  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 3      4852  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4      5826  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 8014    467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8015    467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8016   5697  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8017   5697  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 8018    467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 8014  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8015  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8016  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8017  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 8018  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [8019 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      5697  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 1      5697  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 2       467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 3       467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4       467  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 6539   3936  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6540   2865  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6541   5958  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 6542   1056  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6543   3813  (passportNumber, country, dissolutionDate, swi...       12.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 6539  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6540  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6541  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6542  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6543  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [6544 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      4941  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 1         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 2         5  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 3     12577  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 4      2182  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 6337    779  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 6338   1557  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 6339   1588  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 6340   1586  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 6341   2562  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 6337  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6338  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6339  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6340  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 6341  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [6342 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0      6061  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 1      4142  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 2      6061  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 3      2089  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4     18718  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 5882   3910  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 5883   3865  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 5884      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 5885      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 5886      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 5882  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 5883  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 5884  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 5885  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 5886  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [5887 rows x 4 columns],\n",
       "       index                                             target  totalCost  \\\n",
       " 0         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 1         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 2         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 3         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 4         2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " ...     ...                                                ...        ...   \n",
       " 4312   2441  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 4313    340  (passportNumber, country, dissolutionDate, swi...        6.0   \n",
       " 4314      8  (passportNumber, country, dissolutionDate, swi...        4.0   \n",
       " 4315      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " 4316      2  (passportNumber, country, dissolutionDate, swi...        2.0   \n",
       " \n",
       "                                                    path  \n",
       " 0     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 1     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 2     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 3     [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4     [(passportNumber, country, dissolutionDate, sw...  \n",
       " ...                                                 ...  \n",
       " 4312  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4313  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4314  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4315  [(passportNumber, country, dissolutionDate, sw...  \n",
       " 4316  [(passportNumber, country, dissolutionDate, sw...  \n",
       " \n",
       " [4317 rows x 4 columns]]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 ('notebooks')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.16"
  },
  "vscode": {
   "interpreter": {
    "hash": "c68434ca16130d73e64183f54aeda16ecffce872c062f16976fd0d983519d848"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}