docs/notebooks/PlanetSample.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "norman-zoning",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/home/kiran/.miniconda3/envs/dgraphpandas/bin/python\r\n"
     ]
    }
   ],
   "source": [
    "!which python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "confused-threat",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: dgraphpandas in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (0.0.4)\n",
      "Requirement already satisfied: pandas in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from dgraphpandas) (1.1.5)\n",
      "Requirement already satisfied: python-dateutil>=2.7.3 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas->dgraphpandas) (2.8.1)\n",
      "Requirement already satisfied: numpy>=1.15.4 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas->dgraphpandas) (1.19.5)\n",
      "Requirement already satisfied: pytz>=2017.2 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas->dgraphpandas) (2021.1)\n",
      "Requirement already satisfied: six>=1.5 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from python-dateutil>=2.7.3->pandas->dgraphpandas) (1.15.0)\n",
      "Requirement already satisfied: pandas in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (1.1.5)\n",
      "Requirement already satisfied: pytz>=2017.2 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas) (2021.1)\n",
      "Requirement already satisfied: python-dateutil>=2.7.3 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas) (2.8.1)\n",
      "Requirement already satisfied: numpy>=1.15.4 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from pandas) (1.19.5)\n",
      "Requirement already satisfied: six>=1.5 in /home/kiran/.miniconda3/envs/dgraphpandas/lib/python3.6/site-packages (from python-dateutil>=2.7.3->pandas) (1.15.0)\n"
     ]
    }
   ],
   "source": [
    "!python -m pip install dgraphpandas\n",
    "!python -m pip install pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "electrical-socket",
   "metadata": {},
   "outputs": [],
   "source": [
    "from dgraphpandas.strategies.horizontal import horizontal_transform\n",
    "from dgraphpandas.writers.upserts import generate_upserts\n",
    "import pandas as pd\n",
    "\n",
    "pd.set_option('mode.chained_assignment', None)\n",
    "file = '../planets/solar_system.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "appointed-developer",
   "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",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>order_from_sun</th>\n",
       "      <th>diameter_earth_relative</th>\n",
       "      <th>diameter_km</th>\n",
       "      <th>mass_earth_relative</th>\n",
       "      <th>mean_distance_from_sun_au</th>\n",
       "      <th>orbital_period_years</th>\n",
       "      <th>orbital_eccentricity</th>\n",
       "      <th>...</th>\n",
       "      <th>mean_temperature_surface_c</th>\n",
       "      <th>gravity_equator_earth_relative</th>\n",
       "      <th>escape_velocity_km_sec</th>\n",
       "      <th>mean_density</th>\n",
       "      <th>atmospheric_composition</th>\n",
       "      <th>number_moons</th>\n",
       "      <th>rings</th>\n",
       "      <th>parent</th>\n",
       "      <th>image</th>\n",
       "      <th>uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sun</td>\n",
       "      <td>Star</td>\n",
       "      <td>0</td>\n",
       "      <td>109.000</td>\n",
       "      <td>1392000.0</td>\n",
       "      <td>333000.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>...</td>\n",
       "      <td>5600</td>\n",
       "      <td>28.00</td>\n",
       "      <td>617.70</td>\n",
       "      <td>1.40</td>\n",
       "      <td>H2+He</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Images/Sun.jpg</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Sun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Mercury</td>\n",
       "      <td>Terrestrial planet</td>\n",
       "      <td>1</td>\n",
       "      <td>0.382</td>\n",
       "      <td>4878.0</td>\n",
       "      <td>0.055</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.2056</td>\n",
       "      <td>...</td>\n",
       "      <td>125</td>\n",
       "      <td>0.38</td>\n",
       "      <td>4.25</td>\n",
       "      <td>5.43</td>\n",
       "      <td>none</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Images/Mercury.jpg</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Mercury_(planet)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Venus</td>\n",
       "      <td>Terrestrial planet</td>\n",
       "      <td>2</td>\n",
       "      <td>0.949</td>\n",
       "      <td>12104.0</td>\n",
       "      <td>0.815</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.0068</td>\n",
       "      <td>...</td>\n",
       "      <td>465</td>\n",
       "      <td>0.90</td>\n",
       "      <td>10.36</td>\n",
       "      <td>5.25</td>\n",
       "      <td>CO2</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Images/Venus.jpg</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Venus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Earth</td>\n",
       "      <td>Terrestrial planet</td>\n",
       "      <td>3</td>\n",
       "      <td>1.000</td>\n",
       "      <td>12756.0</td>\n",
       "      <td>1.000</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.0167</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>1.00</td>\n",
       "      <td>11.18</td>\n",
       "      <td>5.52</td>\n",
       "      <td>N2+O2</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Images/Earth.jpg</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Earth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Mars</td>\n",
       "      <td>Terrestrial planet</td>\n",
       "      <td>4</td>\n",
       "      <td>0.532</td>\n",
       "      <td>6787.0</td>\n",
       "      <td>0.107</td>\n",
       "      <td>1.52</td>\n",
       "      <td>1.88</td>\n",
       "      <td>0.0934</td>\n",
       "      <td>...</td>\n",
       "      <td>-53</td>\n",
       "      <td>0.38</td>\n",
       "      <td>5.02</td>\n",
       "      <td>3.93</td>\n",
       "      <td>CO2</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Images/Mars.jpg</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Mars</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   id     name                type  order_from_sun  diameter_earth_relative  \\\n",
       "0   0      Sun                Star               0                  109.000   \n",
       "1   1  Mercury  Terrestrial planet               1                    0.382   \n",
       "2   2    Venus  Terrestrial planet               2                    0.949   \n",
       "3   3    Earth  Terrestrial planet               3                    1.000   \n",
       "4   4     Mars  Terrestrial planet               4                    0.532   \n",
       "\n",
       "   diameter_km  mass_earth_relative  mean_distance_from_sun_au  \\\n",
       "0    1392000.0           333000.000                       0.00   \n",
       "1       4878.0                0.055                       0.39   \n",
       "2      12104.0                0.815                       0.72   \n",
       "3      12756.0                1.000                       1.00   \n",
       "4       6787.0                0.107                       1.52   \n",
       "\n",
       "   orbital_period_years  orbital_eccentricity  ...  \\\n",
       "0                  0.00                0.0000  ...   \n",
       "1                  0.24                0.2056  ...   \n",
       "2                  0.62                0.0068  ...   \n",
       "3                  1.00                0.0167  ...   \n",
       "4                  1.88                0.0934  ...   \n",
       "\n",
       "   mean_temperature_surface_c  gravity_equator_earth_relative  \\\n",
       "0                        5600                           28.00   \n",
       "1                         125                            0.38   \n",
       "2                         465                            0.90   \n",
       "3                          15                            1.00   \n",
       "4                         -53                            0.38   \n",
       "\n",
       "   escape_velocity_km_sec  mean_density  atmospheric_composition  \\\n",
       "0                  617.70          1.40                    H2+He   \n",
       "1                    4.25          5.43                     none   \n",
       "2                   10.36          5.25                      CO2   \n",
       "3                   11.18          5.52                    N2+O2   \n",
       "4                    5.02          3.93                      CO2   \n",
       "\n",
       "   number_moons  rings parent               image  \\\n",
       "0             0  False    NaN      Images/Sun.jpg   \n",
       "1             0  False    1.0  Images/Mercury.jpg   \n",
       "2             0  False    1.0    Images/Venus.jpg   \n",
       "3             1  False    1.0    Images/Earth.jpg   \n",
       "4             2  False    1.0     Images/Mars.jpg   \n",
       "\n",
       "                                             uri  \n",
       "0               http://en.wikipedia.org/wiki/Sun  \n",
       "1  http://en.wikipedia.org/wiki/Mercury_(planet)  \n",
       "2             http://en.wikipedia.org/wiki/Venus  \n",
       "3             http://en.wikipedia.org/wiki/Earth  \n",
       "4              http://en.wikipedia.org/wiki/Mars  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# View Source Data\n",
    "pd.read_csv(file).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "representative-treat",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Define Configuration\n",
    "config = {\n",
    "  \"transform\": \"horizontal\",\n",
    "  \"files\": {\n",
    "    \"planet\": {\n",
    "      \"subject_fields\": [\"id\"],\n",
    "      \"edge_fields\": [\"type\"],\n",
    "      \"type_overrides\": {\n",
    "        \"order_from_sun\": \"int32\",\n",
    "        \"diameter_earth_relative\": \"float32\",\n",
    "        \"diameter_km\": \"float32\",\n",
    "        \"mass_earth_relative\": \"float32\",\n",
    "        \"mean_distance_from_sun_au\": \"float32\",\n",
    "        \"orbital_period_years\": \"float32\",\n",
    "        \"orbital_eccentricity\": \"float32\",\n",
    "        \"mean_orbital_velocity_km_sec\": \"float32\",\n",
    "        \"rotation_period_days\": \"float32\",\n",
    "        \"inclination_axis_degrees\": \"float32\",\n",
    "        \"mean_temperature_surface_c\": \"float32\",\n",
    "        \"gravity_equator_earth_relative\": \"float32\",\n",
    "        \"escape_velocity_km_sec\": \"float32\",\n",
    "        \"mean_density\": \"float32\",\n",
    "        \"number_moons\": \"int32\",\n",
    "        \"rings\": \"bool\"\n",
    "      },\n",
    "      \"ignore_fields\": [\"image\", \"parent\"]\n",
    "    }\n",
    "  }\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "primary-timothy",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Perform a Horizontal Transform on the passed file using the config/key\n",
    "intrinsic, edges = horizontal_transform(file, config, \"planet\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "growing-cleanup",
   "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>subject</th>\n",
       "      <th>predicate</th>\n",
       "      <th>object</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>planet_0</td>\n",
       "      <td>name</td>\n",
       "      <td>Sun</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>planet_1</td>\n",
       "      <td>name</td>\n",
       "      <td>Mercury</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>planet_2</td>\n",
       "      <td>name</td>\n",
       "      <td>Venus</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>planet_3</td>\n",
       "      <td>name</td>\n",
       "      <td>Earth</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>planet_4</td>\n",
       "      <td>name</td>\n",
       "      <td>Mars</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>planet_9</td>\n",
       "      <td>dgraph.type</td>\n",
       "      <td>planet</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>planet_10</td>\n",
       "      <td>dgraph.type</td>\n",
       "      <td>planet</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>planet_11</td>\n",
       "      <td>dgraph.type</td>\n",
       "      <td>planet</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>planet_12</td>\n",
       "      <td>dgraph.type</td>\n",
       "      <td>planet</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>planet_13</td>\n",
       "      <td>dgraph.type</td>\n",
       "      <td>planet</td>\n",
       "      <td>&lt;xs:string&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>277 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      subject    predicate   object         type\n",
       "0    planet_0         name      Sun  <xs:string>\n",
       "1    planet_1         name  Mercury  <xs:string>\n",
       "2    planet_2         name    Venus  <xs:string>\n",
       "3    planet_3         name    Earth  <xs:string>\n",
       "4    planet_4         name     Mars  <xs:string>\n",
       "..        ...          ...      ...          ...\n",
       "9    planet_9  dgraph.type   planet  <xs:string>\n",
       "10  planet_10  dgraph.type   planet  <xs:string>\n",
       "11  planet_11  dgraph.type   planet  <xs:string>\n",
       "12  planet_12  dgraph.type   planet  <xs:string>\n",
       "13  planet_13  dgraph.type   planet  <xs:string>\n",
       "\n",
       "[277 rows x 4 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "intrinsic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "complicated-while",
   "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>subject</th>\n",
       "      <th>predicate</th>\n",
       "      <th>object</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>planet_0</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Star</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>planet_1</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Terrestrialplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>planet_2</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Terrestrialplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>planet_3</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Terrestrialplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>planet_4</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Terrestrialplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>planet_5</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Gasgiant</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>planet_6</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Gasgiant</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>planet_7</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Gasgiant</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>planet_8</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Gasgiant</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>planet_9</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Dwarfplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>planet_10</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Dwarfplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>planet_11</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Dwarfplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>planet_12</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Dwarfplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>planet_13</td>\n",
       "      <td>type</td>\n",
       "      <td>type_Dwarfplanet</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      subject predicate                  object  type\n",
       "14   planet_0      type               type_Star  None\n",
       "15   planet_1      type  type_Terrestrialplanet  None\n",
       "16   planet_2      type  type_Terrestrialplanet  None\n",
       "17   planet_3      type  type_Terrestrialplanet  None\n",
       "18   planet_4      type  type_Terrestrialplanet  None\n",
       "19   planet_5      type           type_Gasgiant  None\n",
       "20   planet_6      type           type_Gasgiant  None\n",
       "21   planet_7      type           type_Gasgiant  None\n",
       "22   planet_8      type           type_Gasgiant  None\n",
       "23   planet_9      type        type_Dwarfplanet  None\n",
       "24  planet_10      type        type_Dwarfplanet  None\n",
       "25  planet_11      type        type_Dwarfplanet  None\n",
       "26  planet_12      type        type_Dwarfplanet  None\n",
       "27  planet_13      type        type_Dwarfplanet  None"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "edges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "romance-exchange",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Generate RDF Upsert statements\n",
    "intrinsic_upserts, edges_upserts = generate_upserts(intrinsic, edges)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "modular-michigan",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['<planet_0> <name> \"Sun\"^^<xs:string> .',\n",
       " '<planet_1> <name> \"Mercury\"^^<xs:string> .',\n",
       " '<planet_2> <name> \"Venus\"^^<xs:string> .',\n",
       " '<planet_3> <name> \"Earth\"^^<xs:string> .',\n",
       " '<planet_4> <name> \"Mars\"^^<xs:string> .',\n",
       " '<planet_5> <name> \"Jupiter\"^^<xs:string> .',\n",
       " '<planet_6> <name> \"Saturn\"^^<xs:string> .',\n",
       " '<planet_7> <name> \"Uranus\"^^<xs:string> .',\n",
       " '<planet_8> <name> \"Neptune\"^^<xs:string> .',\n",
       " '<planet_9> <name> \"Ceres\"^^<xs:string> .',\n",
       " '<planet_10> <name> \"Pluto\"^^<xs:string> .',\n",
       " '<planet_11> <name> \"Haumea\"^^<xs:string> .',\n",
       " '<planet_12> <name> \"Makemake\"^^<xs:string> .',\n",
       " '<planet_13> <name> \"Eris\"^^<xs:string> .',\n",
       " '<planet_0> <order_from_sun> \"0\"^^<xs:int> .',\n",
       " '<planet_1> <order_from_sun> \"1\"^^<xs:int> .',\n",
       " '<planet_2> <order_from_sun> \"2\"^^<xs:int> .',\n",
       " '<planet_3> <order_from_sun> \"3\"^^<xs:int> .',\n",
       " '<planet_4> <order_from_sun> \"4\"^^<xs:int> .',\n",
       " '<planet_5> <order_from_sun> \"6\"^^<xs:int> .',\n",
       " '<planet_6> <order_from_sun> \"7\"^^<xs:int> .',\n",
       " '<planet_7> <order_from_sun> \"8\"^^<xs:int> .',\n",
       " '<planet_8> <order_from_sun> \"9\"^^<xs:int> .',\n",
       " '<planet_9> <order_from_sun> \"5\"^^<xs:int> .',\n",
       " '<planet_10> <order_from_sun> \"10\"^^<xs:int> .',\n",
       " '<planet_11> <order_from_sun> \"11\"^^<xs:int> .',\n",
       " '<planet_12> <order_from_sun> \"12\"^^<xs:int> .',\n",
       " '<planet_13> <order_from_sun> \"13\"^^<xs:int> .',\n",
       " '<planet_0> <diameter_earth_relative> \"109.0\"^^<xs:float> .',\n",
       " '<planet_1> <diameter_earth_relative> \"0.38199999928474426\"^^<xs:float> .',\n",
       " '<planet_2> <diameter_earth_relative> \"0.9490000009536743\"^^<xs:float> .',\n",
       " '<planet_3> <diameter_earth_relative> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <diameter_earth_relative> \"0.5320000052452087\"^^<xs:float> .',\n",
       " '<planet_5> <diameter_earth_relative> \"11.208999633789062\"^^<xs:float> .',\n",
       " '<planet_6> <diameter_earth_relative> \"9.4399995803833\"^^<xs:float> .',\n",
       " '<planet_7> <diameter_earth_relative> \"4.006999969482422\"^^<xs:float> .',\n",
       " '<planet_8> <diameter_earth_relative> \"3.882999897003174\"^^<xs:float> .',\n",
       " '<planet_9> <diameter_earth_relative> \"0.07599999755620956\"^^<xs:float> .',\n",
       " '<planet_10> <diameter_earth_relative> \"0.18000000715255737\"^^<xs:float> .',\n",
       " '<planet_11> <diameter_earth_relative> \"0.10999999940395355\"^^<xs:float> .',\n",
       " '<planet_12> <diameter_earth_relative> \"0.12549999356269836\"^^<xs:float> .',\n",
       " '<planet_13> <diameter_earth_relative> \"0.21150000393390656\"^^<xs:float> .',\n",
       " '<planet_0> <diameter_km> \"1392000.0\"^^<xs:float> .',\n",
       " '<planet_1> <diameter_km> \"4878.0\"^^<xs:float> .',\n",
       " '<planet_2> <diameter_km> \"12104.0\"^^<xs:float> .',\n",
       " '<planet_3> <diameter_km> \"12756.0\"^^<xs:float> .',\n",
       " '<planet_4> <diameter_km> \"6787.0\"^^<xs:float> .',\n",
       " '<planet_5> <diameter_km> \"142800.0\"^^<xs:float> .',\n",
       " '<planet_6> <diameter_km> \"120000.0\"^^<xs:float> .',\n",
       " '<planet_7> <diameter_km> \"51118.0\"^^<xs:float> .',\n",
       " '<planet_8> <diameter_km> \"49528.0\"^^<xs:float> .',\n",
       " '<planet_9> <diameter_km> \"974.5999755859375\"^^<xs:float> .',\n",
       " '<planet_10> <diameter_km> \"2300.0\"^^<xs:float> .',\n",
       " '<planet_11> <diameter_km> \"1300.0\"^^<xs:float> .',\n",
       " '<planet_12> <diameter_km> \"1420.0\"^^<xs:float> .',\n",
       " '<planet_13> <diameter_km> \"2326.0\"^^<xs:float> .',\n",
       " '<planet_0> <mass_earth_relative> \"333000.0\"^^<xs:float> .',\n",
       " '<planet_1> <mass_earth_relative> \"0.054999999701976776\"^^<xs:float> .',\n",
       " '<planet_2> <mass_earth_relative> \"0.8149999976158142\"^^<xs:float> .',\n",
       " '<planet_3> <mass_earth_relative> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <mass_earth_relative> \"0.10700000077486038\"^^<xs:float> .',\n",
       " '<planet_5> <mass_earth_relative> \"318.0\"^^<xs:float> .',\n",
       " '<planet_6> <mass_earth_relative> \"95.0\"^^<xs:float> .',\n",
       " '<planet_7> <mass_earth_relative> \"15.0\"^^<xs:float> .',\n",
       " '<planet_8> <mass_earth_relative> \"17.0\"^^<xs:float> .',\n",
       " '<planet_9> <mass_earth_relative> \"0.00015999999595806003\"^^<xs:float> .',\n",
       " '<planet_10> <mass_earth_relative> \"0.0020000000949949026\"^^<xs:float> .',\n",
       " '<planet_11> <mass_earth_relative> \"0.000699999975040555\"^^<xs:float> .',\n",
       " '<planet_12> <mass_earth_relative> \"0.0006699999794363976\"^^<xs:float> .',\n",
       " '<planet_13> <mass_earth_relative> \"0.00279999990016222\"^^<xs:float> .',\n",
       " '<planet_0> <mean_distance_from_sun_au> \"0.0\"^^<xs:float> .',\n",
       " '<planet_1> <mean_distance_from_sun_au> \"0.38999998569488525\"^^<xs:float> .',\n",
       " '<planet_2> <mean_distance_from_sun_au> \"0.7200000286102295\"^^<xs:float> .',\n",
       " '<planet_3> <mean_distance_from_sun_au> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <mean_distance_from_sun_au> \"1.5199999809265137\"^^<xs:float> .',\n",
       " '<planet_5> <mean_distance_from_sun_au> \"5.199999809265137\"^^<xs:float> .',\n",
       " '<planet_6> <mean_distance_from_sun_au> \"9.539999961853027\"^^<xs:float> .',\n",
       " '<planet_7> <mean_distance_from_sun_au> \"19.18000030517578\"^^<xs:float> .',\n",
       " '<planet_8> <mean_distance_from_sun_au> \"30.059999465942383\"^^<xs:float> .',\n",
       " '<planet_9> <mean_distance_from_sun_au> \"2.7659599781036377\"^^<xs:float> .',\n",
       " '<planet_10> <mean_distance_from_sun_au> \"39.439998626708984\"^^<xs:float> .',\n",
       " '<planet_11> <mean_distance_from_sun_au> \"43.334999084472656\"^^<xs:float> .',\n",
       " '<planet_12> <mean_distance_from_sun_au> \"45.79100036621094\"^^<xs:float> .',\n",
       " '<planet_13> <mean_distance_from_sun_au> \"67.66809844970703\"^^<xs:float> .',\n",
       " '<planet_0> <orbital_period_years> \"0.0\"^^<xs:float> .',\n",
       " '<planet_1> <orbital_period_years> \"0.23999999463558197\"^^<xs:float> .',\n",
       " '<planet_2> <orbital_period_years> \"0.6200000047683716\"^^<xs:float> .',\n",
       " '<planet_3> <orbital_period_years> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <orbital_period_years> \"1.8799999952316284\"^^<xs:float> .',\n",
       " '<planet_5> <orbital_period_years> \"11.859999656677246\"^^<xs:float> .',\n",
       " '<planet_6> <orbital_period_years> \"29.459999084472656\"^^<xs:float> .',\n",
       " '<planet_7> <orbital_period_years> \"84.01000213623047\"^^<xs:float> .',\n",
       " '<planet_8> <orbital_period_years> \"164.8000030517578\"^^<xs:float> .',\n",
       " '<planet_9> <orbital_period_years> \"4.598999977111816\"^^<xs:float> .',\n",
       " '<planet_10> <orbital_period_years> \"247.6999969482422\"^^<xs:float> .',\n",
       " '<planet_11> <orbital_period_years> \"285.3999938964844\"^^<xs:float> .',\n",
       " '<planet_12> <orbital_period_years> \"309.8800048828125\"^^<xs:float> .',\n",
       " '<planet_13> <orbital_period_years> \"557.0\"^^<xs:float> .',\n",
       " '<planet_0> <orbital_eccentricity> \"0.0\"^^<xs:float> .',\n",
       " '<planet_1> <orbital_eccentricity> \"0.20559999346733093\"^^<xs:float> .',\n",
       " '<planet_2> <orbital_eccentricity> \"0.006800000090152025\"^^<xs:float> .',\n",
       " '<planet_3> <orbital_eccentricity> \"0.016699999570846558\"^^<xs:float> .',\n",
       " '<planet_4> <orbital_eccentricity> \"0.0934000015258789\"^^<xs:float> .',\n",
       " '<planet_5> <orbital_eccentricity> \"0.04830000177025795\"^^<xs:float> .',\n",
       " '<planet_6> <orbital_eccentricity> \"0.0560000017285347\"^^<xs:float> .',\n",
       " '<planet_7> <orbital_eccentricity> \"0.04610000178217888\"^^<xs:float> .',\n",
       " '<planet_8> <orbital_eccentricity> \"0.009700000286102295\"^^<xs:float> .',\n",
       " '<planet_9> <orbital_eccentricity> \"0.07976000010967255\"^^<xs:float> .',\n",
       " '<planet_10> <orbital_eccentricity> \"0.24819999933242798\"^^<xs:float> .',\n",
       " '<planet_11> <orbital_eccentricity> \"0.18874000012874603\"^^<xs:float> .',\n",
       " '<planet_12> <orbital_eccentricity> \"0.1589999943971634\"^^<xs:float> .',\n",
       " '<planet_13> <orbital_eccentricity> \"0.4417699873447418\"^^<xs:float> .',\n",
       " '<planet_0> <mean_orbital_velocity_km_sec> \"0.0\"^^<xs:float> .',\n",
       " '<planet_1> <mean_orbital_velocity_km_sec> \"47.88999938964844\"^^<xs:float> .',\n",
       " '<planet_2> <mean_orbital_velocity_km_sec> \"35.029998779296875\"^^<xs:float> .',\n",
       " '<planet_3> <mean_orbital_velocity_km_sec> \"29.790000915527344\"^^<xs:float> .',\n",
       " '<planet_4> <mean_orbital_velocity_km_sec> \"24.1299991607666\"^^<xs:float> .',\n",
       " '<planet_5> <mean_orbital_velocity_km_sec> \"13.0600004196167\"^^<xs:float> .',\n",
       " '<planet_6> <mean_orbital_velocity_km_sec> \"9.640000343322754\"^^<xs:float> .',\n",
       " '<planet_7> <mean_orbital_velocity_km_sec> \"6.809999942779541\"^^<xs:float> .',\n",
       " '<planet_8> <mean_orbital_velocity_km_sec> \"5.429999828338623\"^^<xs:float> .',\n",
       " '<planet_9> <mean_orbital_velocity_km_sec> \"17.881999969482422\"^^<xs:float> .',\n",
       " '<planet_10> <mean_orbital_velocity_km_sec> \"4.739999771118164\"^^<xs:float> .',\n",
       " '<planet_11> <mean_orbital_velocity_km_sec> \"4.484000205993652\"^^<xs:float> .',\n",
       " '<planet_12> <mean_orbital_velocity_km_sec> \"4.419000148773193\"^^<xs:float> .',\n",
       " '<planet_13> <mean_orbital_velocity_km_sec> \"3.436000108718872\"^^<xs:float> .',\n",
       " '<planet_0> <rotation_period_days> \"25.049999237060547\"^^<xs:float> .',\n",
       " '<planet_1> <rotation_period_days> \"58.650001525878906\"^^<xs:float> .',\n",
       " '<planet_2> <rotation_period_days> \"-243.0\"^^<xs:float> .',\n",
       " '<planet_3> <rotation_period_days> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <rotation_period_days> \"1.0299999713897705\"^^<xs:float> .',\n",
       " '<planet_5> <rotation_period_days> \"0.4099999964237213\"^^<xs:float> .',\n",
       " '<planet_6> <rotation_period_days> \"0.4399999976158142\"^^<xs:float> .',\n",
       " '<planet_7> <rotation_period_days> \"-0.7200000286102295\"^^<xs:float> .',\n",
       " '<planet_8> <rotation_period_days> \"0.7200000286102295\"^^<xs:float> .',\n",
       " '<planet_9> <rotation_period_days> \"0.3779999911785126\"^^<xs:float> .',\n",
       " '<planet_10> <rotation_period_days> \"-6.380000114440918\"^^<xs:float> .',\n",
       " '<planet_11> <rotation_period_days> \"0.16300000250339508\"^^<xs:float> .',\n",
       " '<planet_12> <rotation_period_days> \"0.3199999928474426\"^^<xs:float> .',\n",
       " '<planet_13> <rotation_period_days> \"1.0\"^^<xs:float> .',\n",
       " '<planet_0> <inclination_axis_degrees> \"7.25\"^^<xs:float> .',\n",
       " '<planet_1> <inclination_axis_degrees> \"0.0\"^^<xs:float> .',\n",
       " '<planet_2> <inclination_axis_degrees> \"177.39999389648438\"^^<xs:float> .',\n",
       " '<planet_3> <inclination_axis_degrees> \"23.450000762939453\"^^<xs:float> .',\n",
       " '<planet_4> <inclination_axis_degrees> \"23.979999542236328\"^^<xs:float> .',\n",
       " '<planet_5> <inclination_axis_degrees> \"3.0799999237060547\"^^<xs:float> .',\n",
       " '<planet_6> <inclination_axis_degrees> \"26.729999542236328\"^^<xs:float> .',\n",
       " '<planet_7> <inclination_axis_degrees> \"97.91999816894531\"^^<xs:float> .',\n",
       " '<planet_8> <inclination_axis_degrees> \"28.799999237060547\"^^<xs:float> .',\n",
       " '<planet_9> <inclination_axis_degrees> \"3.0\"^^<xs:float> .',\n",
       " '<planet_10> <inclination_axis_degrees> \"122.0\"^^<xs:float> .',\n",
       " '<planet_0> <mean_temperature_surface_c> \"5600.0\"^^<xs:float> .',\n",
       " '<planet_1> <mean_temperature_surface_c> \"125.0\"^^<xs:float> .',\n",
       " '<planet_2> <mean_temperature_surface_c> \"465.0\"^^<xs:float> .',\n",
       " '<planet_3> <mean_temperature_surface_c> \"15.0\"^^<xs:float> .',\n",
       " '<planet_4> <mean_temperature_surface_c> \"-53.0\"^^<xs:float> .',\n",
       " '<planet_5> <mean_temperature_surface_c> \"-150.0\"^^<xs:float> .',\n",
       " '<planet_6> <mean_temperature_surface_c> \"-170.0\"^^<xs:float> .',\n",
       " '<planet_7> <mean_temperature_surface_c> \"-200.0\"^^<xs:float> .',\n",
       " '<planet_8> <mean_temperature_surface_c> \"-210.0\"^^<xs:float> .',\n",
       " '<planet_9> <mean_temperature_surface_c> \"-106.0\"^^<xs:float> .',\n",
       " '<planet_10> <mean_temperature_surface_c> \"-220.0\"^^<xs:float> .',\n",
       " '<planet_11> <mean_temperature_surface_c> \"-223.0\"^^<xs:float> .',\n",
       " '<planet_12> <mean_temperature_surface_c> \"-240.0\"^^<xs:float> .',\n",
       " '<planet_13> <mean_temperature_surface_c> \"-230.0\"^^<xs:float> .',\n",
       " '<planet_0> <gravity_equator_earth_relative> \"28.0\"^^<xs:float> .',\n",
       " '<planet_1> <gravity_equator_earth_relative> \"0.3799999952316284\"^^<xs:float> .',\n",
       " '<planet_2> <gravity_equator_earth_relative> \"0.8999999761581421\"^^<xs:float> .',\n",
       " '<planet_3> <gravity_equator_earth_relative> \"1.0\"^^<xs:float> .',\n",
       " '<planet_4> <gravity_equator_earth_relative> \"0.3799999952316284\"^^<xs:float> .',\n",
       " '<planet_5> <gravity_equator_earth_relative> \"2.640000104904175\"^^<xs:float> .',\n",
       " '<planet_6> <gravity_equator_earth_relative> \"0.9300000071525574\"^^<xs:float> .',\n",
       " '<planet_7> <gravity_equator_earth_relative> \"0.8899999856948853\"^^<xs:float> .',\n",
       " '<planet_8> <gravity_equator_earth_relative> \"1.1200000047683716\"^^<xs:float> .',\n",
       " '<planet_9> <gravity_equator_earth_relative> \"0.02800000086426735\"^^<xs:float> .',\n",
       " '<planet_10> <gravity_equator_earth_relative> \"0.05999999865889549\"^^<xs:float> .',\n",
       " '<planet_11> <gravity_equator_earth_relative> \"0.04500000178813934\"^^<xs:float> .',\n",
       " '<planet_12> <gravity_equator_earth_relative> \"0.050999999046325684\"^^<xs:float> .',\n",
       " '<planet_13> <gravity_equator_earth_relative> \"0.0820000022649765\"^^<xs:float> .',\n",
       " '<planet_0> <escape_velocity_km_sec> \"617.7000122070312\"^^<xs:float> .',\n",
       " '<planet_1> <escape_velocity_km_sec> \"4.25\"^^<xs:float> .',\n",
       " '<planet_2> <escape_velocity_km_sec> \"10.359999656677246\"^^<xs:float> .',\n",
       " '<planet_3> <escape_velocity_km_sec> \"11.180000305175781\"^^<xs:float> .',\n",
       " '<planet_4> <escape_velocity_km_sec> \"5.019999980926514\"^^<xs:float> .',\n",
       " '<planet_5> <escape_velocity_km_sec> \"59.540000915527344\"^^<xs:float> .',\n",
       " '<planet_6> <escape_velocity_km_sec> \"35.4900016784668\"^^<xs:float> .',\n",
       " '<planet_7> <escape_velocity_km_sec> \"21.290000915527344\"^^<xs:float> .',\n",
       " '<planet_8> <escape_velocity_km_sec> \"23.709999084472656\"^^<xs:float> .',\n",
       " '<planet_9> <escape_velocity_km_sec> \"0.5099999904632568\"^^<xs:float> .',\n",
       " '<planet_10> <escape_velocity_km_sec> \"1.2699999809265137\"^^<xs:float> .',\n",
       " '<planet_11> <escape_velocity_km_sec> \"0.8399999737739563\"^^<xs:float> .',\n",
       " '<planet_12> <escape_velocity_km_sec> \"0.800000011920929\"^^<xs:float> .',\n",
       " '<planet_13> <escape_velocity_km_sec> \"1.309999942779541\"^^<xs:float> .',\n",
       " '<planet_0> <mean_density> \"1.399999976158142\"^^<xs:float> .',\n",
       " '<planet_1> <mean_density> \"5.429999828338623\"^^<xs:float> .',\n",
       " '<planet_2> <mean_density> \"5.25\"^^<xs:float> .',\n",
       " '<planet_3> <mean_density> \"5.519999980926514\"^^<xs:float> .',\n",
       " '<planet_4> <mean_density> \"3.930000066757202\"^^<xs:float> .',\n",
       " '<planet_5> <mean_density> \"1.3300000429153442\"^^<xs:float> .',\n",
       " '<planet_6> <mean_density> \"0.7099999785423279\"^^<xs:float> .',\n",
       " '<planet_7> <mean_density> \"1.2400000095367432\"^^<xs:float> .',\n",
       " '<planet_8> <mean_density> \"1.6699999570846558\"^^<xs:float> .',\n",
       " '<planet_9> <mean_density> \"2.0769999027252197\"^^<xs:float> .',\n",
       " '<planet_10> <mean_density> \"2.0299999713897705\"^^<xs:float> .',\n",
       " '<planet_11> <mean_density> \"2.950000047683716\"^^<xs:float> .',\n",
       " '<planet_12> <mean_density> \"2.0\"^^<xs:float> .',\n",
       " '<planet_13> <mean_density> \"1.7450000047683716\"^^<xs:float> .',\n",
       " '<planet_0> <atmospheric_composition> \"H2+He\"^^<xs:string> .',\n",
       " '<planet_1> <atmospheric_composition> \"none\"^^<xs:string> .',\n",
       " '<planet_2> <atmospheric_composition> \"CO2\"^^<xs:string> .',\n",
       " '<planet_3> <atmospheric_composition> \"N2+O2\"^^<xs:string> .',\n",
       " '<planet_4> <atmospheric_composition> \"CO2\"^^<xs:string> .',\n",
       " '<planet_5> <atmospheric_composition> \"H2+He\"^^<xs:string> .',\n",
       " '<planet_6> <atmospheric_composition> \"H2+He\"^^<xs:string> .',\n",
       " '<planet_7> <atmospheric_composition> \"H2+He\"^^<xs:string> .',\n",
       " '<planet_8> <atmospheric_composition> \"H2+He\"^^<xs:string> .',\n",
       " '<planet_9> <atmospheric_composition> \"none\"^^<xs:string> .',\n",
       " '<planet_10> <atmospheric_composition> \"CH4\"^^<xs:string> .',\n",
       " '<planet_11> <atmospheric_composition> \"none?\"^^<xs:string> .',\n",
       " '<planet_12> <atmospheric_composition> \"maybe CH4\"^^<xs:string> .',\n",
       " '<planet_13> <atmospheric_composition> \"maybe CH4\"^^<xs:string> .',\n",
       " '<planet_0> <number_moons> \"0\"^^<xs:int> .',\n",
       " '<planet_1> <number_moons> \"0\"^^<xs:int> .',\n",
       " '<planet_2> <number_moons> \"0\"^^<xs:int> .',\n",
       " '<planet_3> <number_moons> \"1\"^^<xs:int> .',\n",
       " '<planet_4> <number_moons> \"2\"^^<xs:int> .',\n",
       " '<planet_5> <number_moons> \"63\"^^<xs:int> .',\n",
       " '<planet_6> <number_moons> \"62\"^^<xs:int> .',\n",
       " '<planet_7> <number_moons> \"27\"^^<xs:int> .',\n",
       " '<planet_8> <number_moons> \"13\"^^<xs:int> .',\n",
       " '<planet_9> <number_moons> \"0\"^^<xs:int> .',\n",
       " '<planet_10> <number_moons> \"3\"^^<xs:int> .',\n",
       " '<planet_11> <number_moons> \"2\"^^<xs:int> .',\n",
       " '<planet_12> <number_moons> \"0\"^^<xs:int> .',\n",
       " '<planet_13> <number_moons> \"1\"^^<xs:int> .',\n",
       " '<planet_0> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_1> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_2> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_3> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_4> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_5> <rings> \"True\"^^<xs:bool> .',\n",
       " '<planet_6> <rings> \"True\"^^<xs:bool> .',\n",
       " '<planet_7> <rings> \"True\"^^<xs:bool> .',\n",
       " '<planet_8> <rings> \"True\"^^<xs:bool> .',\n",
       " '<planet_9> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_10> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_11> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_12> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_13> <rings> \"False\"^^<xs:bool> .',\n",
       " '<planet_0> <uri> \"http://en.wikipedia.org/wiki/Sun\"^^<xs:string> .',\n",
       " '<planet_1> <uri> \"http://en.wikipedia.org/wiki/Mercury_(planet)\"^^<xs:string> .',\n",
       " '<planet_2> <uri> \"http://en.wikipedia.org/wiki/Venus\"^^<xs:string> .',\n",
       " '<planet_3> <uri> \"http://en.wikipedia.org/wiki/Earth\"^^<xs:string> .',\n",
       " '<planet_4> <uri> \"http://en.wikipedia.org/wiki/Mars\"^^<xs:string> .',\n",
       " '<planet_5> <uri> \"http://en.wikipedia.org/wiki/Jupiter\"^^<xs:string> .',\n",
       " '<planet_6> <uri> \"http://en.wikipedia.org/wiki/Saturn\"^^<xs:string> .',\n",
       " '<planet_7> <uri> \"http://en.wikipedia.org/wiki/Uranus\"^^<xs:string> .',\n",
       " '<planet_8> <uri> \"http://en.wikipedia.org/wiki/Neptune\"^^<xs:string> .',\n",
       " '<planet_9> <uri> \"http://en.wikipedia.org/wiki/Ceres_(dwarf_planet)\"^^<xs:string> .',\n",
       " '<planet_10> <uri> \"http://en.wikipedia.org/wiki/Pluto\"^^<xs:string> .',\n",
       " '<planet_11> <uri> \"http://en.wikipedia.org/wiki/Haumea_(dwarf_planet)\"^^<xs:string> .',\n",
       " '<planet_12> <uri> \"http://en.wikipedia.org/wiki/Makemake_(dwarf_planet)\"^^<xs:string> .',\n",
       " '<planet_13> <uri> \"http://en.wikipedia.org/wiki/Eris_(dwarf_planet)\"^^<xs:string> .',\n",
       " '<planet_0> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_1> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_2> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_3> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_4> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_5> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_6> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_7> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_8> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_9> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_10> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_11> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_12> <dgraph.type> \"planet\"^^<xs:string> .',\n",
       " '<planet_13> <dgraph.type> \"planet\"^^<xs:string> .']"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(intrinsic_upserts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "significant-trace",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['<planet_0> <type> <type_Star> .',\n",
       " '<planet_1> <type> <type_Terrestrialplanet> .',\n",
       " '<planet_2> <type> <type_Terrestrialplanet> .',\n",
       " '<planet_3> <type> <type_Terrestrialplanet> .',\n",
       " '<planet_4> <type> <type_Terrestrialplanet> .',\n",
       " '<planet_5> <type> <type_Gasgiant> .',\n",
       " '<planet_6> <type> <type_Gasgiant> .',\n",
       " '<planet_7> <type> <type_Gasgiant> .',\n",
       " '<planet_8> <type> <type_Gasgiant> .',\n",
       " '<planet_9> <type> <type_Dwarfplanet> .',\n",
       " '<planet_10> <type> <type_Dwarfplanet> .',\n",
       " '<planet_11> <type> <type_Dwarfplanet> .',\n",
       " '<planet_12> <type> <type_Dwarfplanet> .',\n",
       " '<planet_13> <type> <type_Dwarfplanet> .']"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(edges_upserts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "anonymous-conspiracy",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Found existing installation: dgraphpandas 0.0.4\r\n",
      "Uninstalling dgraphpandas-0.0.4:\r\n",
      "  Successfully uninstalled dgraphpandas-0.0.4\r\n"
     ]
    }
   ],
   "source": [
    "!python -m pip uninstall dgraphpandas -y"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}