API-Large_Query_Retrieval_Example-Geochem.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "from tqdm import tqdm\n",
    "\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', 500)\n",
    "pd.set_option('display.max_columns', 500)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "#https://geoscience.data.qld.gov.au/api/action/package_search?q=geochem&rows=1000&start=0\n",
    "#Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36\n",
    "\n",
    "headers = {'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12125\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=0\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=1000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=2000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=3000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=4000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=5000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=6000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=7000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=8000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=9000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=10000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=11000\n",
      "https://geoscience.data.qld.gov.au/api/action/package_search?q=geochemistry&rows=1000&start=12000\n"
     ]
    }
   ],
   "source": [
    "# set the API endpoint\n",
    "api = 'https://geoscience.data.qld.gov.au/api/action/'\n",
    "# construct our query\n",
    "query = api + 'package_search?q=geochemistry&rows=1000'\n",
    "# make the get request and store it in the response object\n",
    "response = requests.get(query, headers=headers)\n",
    "# view the payload as JSON\n",
    "#print(response.text)\n",
    "\n",
    "if 1 == 1:\n",
    "    #json_response = response.json()\n",
    "    json_response = json.loads(response.text)\n",
    "\n",
    "    #and get a count of results we can retrieve\n",
    "    total_results = json_response['result']['count']\n",
    "    print(total_results)\n",
    "    \n",
    "    #print(json_response['result']['results'][0])\n",
    "\n",
    "    #hack without understanding/researching the api too much\n",
    "    getloop = int(total_results/1000) + 1\n",
    "\n",
    "    if getloop > 1:\n",
    "        results_list = []\n",
    "        for i in range(getloop):\n",
    "            loopq = query + \"&start=\" + str(i*1000)\n",
    "            print(loopq)\n",
    "            response = requests.get(loopq, headers=headers)\n",
    "            #json_response = response.json()\n",
    "            json_response = json.loads(response.text)\n",
    "\n",
    "            results_list.append(json_response)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'owner_org': '1461ac2d-f813-4c97-9e3b-3900a23b0ecb',\n",
       " 'maintainer': None,\n",
       " 'creator': 'geological-survey-of-queensland',\n",
       " 'relationships_as_object': [],\n",
       " 'private': False,\n",
       " 'maintainer_email': None,\n",
       " 'num_tags': 1,\n",
       " 'GeoJSONextent': '{\"type\": \"Polygon\", \"coordinates\": [[[147.75108710012444, -21.331793143854668], [147.83441875601932, -21.331793410854686], [147.8344195440194, -21.41512639974968], [147.75108796712448, -21.415126266749667], [147.75108710012444, -21.331793143854668]]]}',\n",
       " 'id': '94a4559c-1191-4e91-898f-756237f27151',\n",
       " 'metadata_created': '2019-06-05T10:05:20.964289',\n",
       " 'metadata_modified': '2020-08-25T10:10:18.367286',\n",
       " 'author': None,\n",
       " 'author_email': None,\n",
       " 'extra:access_rights': 'http://linked.data.gov.au/def/data-access/open',\n",
       " 'state': 'active',\n",
       " 'version': None,\n",
       " 'extra:contact_uri': 'GSQOpenData@dnrme.qld.gov.au',\n",
       " 'spatial': '{\"type\": \"Polygon\", \"coordinates\": [[[147.75108710012444, -21.331793143854668], [147.83441875601932, -21.331793410854686], [147.8344195440194, -21.41512639974968], [147.75108796712448, -21.415126266749667], [147.75108710012444, -21.331793143854668]]]}',\n",
       " 'license_id': 'https://creativecommons.org/licenses/by/4.0/',\n",
       " 'type': 'geochemistry',\n",
       " 'resources': [{'cache_last_updated': None,\n",
       "   'package_id': '94a4559c-1191-4e91-898f-756237f27151',\n",
       "   'resource:format': 'ZIP',\n",
       "   'id': '0ce0b2cc-1ecf-4195-b19e-67cf16523d28',\n",
       "   'size': None,\n",
       "   'resource:size': '4 KB',\n",
       "   'state': 'active',\n",
       "   'hash': '',\n",
       "   'description': '',\n",
       "   'resource:name': 'BLOCK_CLER1198_SHP.ZIP',\n",
       "   'format': 'SHP',\n",
       "   'mimetype_inner': None,\n",
       "   'url_type': 'upload',\n",
       "   'mimetype': None,\n",
       "   'cache_url': None,\n",
       "   'name': 'BLOCK_CLER1198_SHP.ZIP',\n",
       "   'created': '2019-06-05T10:05:20.973207',\n",
       "   'url': 'https://geoscience.data.qld.gov.au/dataset/94a4559c-1191-4e91-898f-756237f27151/resource/0ce0b2cc-1ecf-4195-b19e-67cf16523d28/download/block_cler1198_shp.zip',\n",
       "   'last_modified': None,\n",
       "   'position': 0,\n",
       "   'revision_id': '77237145-3e1b-422b-93be-4530c35aa3f4',\n",
       "   'resource_type': None},\n",
       "  {'cache_last_updated': None,\n",
       "   'package_id': '94a4559c-1191-4e91-898f-756237f27151',\n",
       "   'resource:format': 'ZIP',\n",
       "   'id': 'e584a45a-6c8c-43fe-9981-c8ddc719799f',\n",
       "   'size': None,\n",
       "   'resource:size': '4 KB',\n",
       "   'state': 'active',\n",
       "   'hash': '',\n",
       "   'description': '',\n",
       "   'resource:name': 'BLOCK_CLER1198_TAB.ZIP',\n",
       "   'format': 'TAB',\n",
       "   'mimetype_inner': None,\n",
       "   'url_type': 'upload',\n",
       "   'mimetype': None,\n",
       "   'cache_url': None,\n",
       "   'name': 'BLOCK_CLER1198_TAB.ZIP',\n",
       "   'created': '2019-06-05T10:05:20.973213',\n",
       "   'url': 'https://geoscience.data.qld.gov.au/dataset/94a4559c-1191-4e91-898f-756237f27151/resource/e584a45a-6c8c-43fe-9981-c8ddc719799f/download/block_cler1198_tab.zip',\n",
       "   'last_modified': None,\n",
       "   'position': 1,\n",
       "   'revision_id': '77237145-3e1b-422b-93be-4530c35aa3f4',\n",
       "   'resource_type': None},\n",
       "  {'cache_last_updated': None,\n",
       "   'package_id': '94a4559c-1191-4e91-898f-756237f27151',\n",
       "   'resource:format': 'CSV',\n",
       "   'id': 'f8f81afd-a774-4a5f-927c-531fdad81fb0',\n",
       "   'size': None,\n",
       "   'resource:size': '7 KB',\n",
       "   'state': 'active',\n",
       "   'hash': '',\n",
       "   'description': '',\n",
       "   'resource:name': 's_Seds_CLER1198.csv',\n",
       "   'format': 'CSV',\n",
       "   'mimetype_inner': None,\n",
       "   'url_type': 'upload',\n",
       "   'mimetype': None,\n",
       "   'cache_url': None,\n",
       "   'name': 's_Seds_CLER1198.csv',\n",
       "   'created': '2019-06-05T10:05:20.973216',\n",
       "   'url': 'https://geoscience.data.qld.gov.au/dataset/94a4559c-1191-4e91-898f-756237f27151/resource/f8f81afd-a774-4a5f-927c-531fdad81fb0/download/s_seds_cler1198.csv',\n",
       "   'last_modified': None,\n",
       "   'position': 2,\n",
       "   'revision_id': '77237145-3e1b-422b-93be-4530c35aa3f4',\n",
       "   'resource_type': None},\n",
       "  {'cache_last_updated': None,\n",
       "   'package_id': '94a4559c-1191-4e91-898f-756237f27151',\n",
       "   'resource:format': 'XLSX',\n",
       "   'id': '707a8d6a-9b58-4a13-ac7c-7ae928906602',\n",
       "   'size': None,\n",
       "   'resource:size': '10 KB',\n",
       "   'state': 'active',\n",
       "   'hash': '',\n",
       "   'description': '',\n",
       "   'resource:name': 's_Seds_CLER1198.xlsx',\n",
       "   'format': 'XLSX',\n",
       "   'mimetype_inner': None,\n",
       "   'url_type': 'upload',\n",
       "   'mimetype': None,\n",
       "   'cache_url': None,\n",
       "   'name': 's_Seds_CLER1198.xlsx',\n",
       "   'created': '2019-06-05T10:05:20.973218',\n",
       "   'url': 'https://geoscience.data.qld.gov.au/dataset/94a4559c-1191-4e91-898f-756237f27151/resource/707a8d6a-9b58-4a13-ac7c-7ae928906602/download/s_seds_cler1198.xlsx',\n",
       "   'last_modified': None,\n",
       "   'position': 3,\n",
       "   'revision_id': '77237145-3e1b-422b-93be-4530c35aa3f4',\n",
       "   'resource_type': None}],\n",
       " 'num_resources': 4,\n",
       " 'tags': [{'vocabulary_id': None,\n",
       "   'state': 'active',\n",
       "   'display_name': 'Geochemistry',\n",
       "   'id': 'ca11a838-126e-4317-b8db-ec0b02b1266a',\n",
       "   'name': 'Geochemistry'}],\n",
       " 'title': 'Geochemistry data for Block CLER1198',\n",
       " 'groups': [],\n",
       " 'creator_user_id': '852e3a91-fe29-492e-82dd-3761ebe6e5bf',\n",
       " 'relationships_as_subject': [],\n",
       " 'name': 'cler1198',\n",
       " 'isopen': False,\n",
       " 'url': None,\n",
       " 'notes': 'Surface and drillhole exploration geochemistry for Block: CLER1198. A whole of Queensland geochemistry dataset is available for download at https://geoscience.data.qld.gov.au/dataset/whole-of-queensland-geochemistry-databases. Instructions on how to use and analyse the geochemistry data is available at https://geoscience.data.qld.gov.au/dataset/geochemistry-data-how-to-guide',\n",
       " 'license_title': 'https://creativecommons.org/licenses/by/4.0/',\n",
       " 'extras': [{'value': 'http://linked.data.gov.au/def/gsq-dataset-theme/geochemistry-data',\n",
       "   'key': 'extra:theme'},\n",
       "  {'value': 'Block: CLER1198', 'key': 'feature_of_interest'},\n",
       "  {'value': 'http://linked.data.gov.au/def/geoscience-foi/block',\n",
       "   'key': 'feature_of_interest_type'}],\n",
       " 'organization': {'description': \"GSQ unlocks the value of geoscience data to enable industry success.\\r\\n\\r\\nGSQ plays a key role in improving understanding of Queensland's resource potential and attracting exploration and investment in the resources sector.\\r\\n\\r\\n#Exploration attraction\\r\\nGSQ creates and distributes exploration and resource investment information and presents at national and international events. We also raise awareness of Queensland's prospectivity through new geoscientific information and manage industry exploration grants.\\r\\n\\r\\n#Mineral and energy geoscience\\r\\nGSQ collects and provides geoscience data, information and advice on Queensland’s mineral resources and resource potential through a range of [geoscience projects and initiatives](https://www.business.qld.gov.au/industries/mining-energy-water/resources/geoscience-information/geoscience-projects).\\r\\n\\r\\nWe support the state’s energy industry by collecting and providing geoscience data and advice on coal, coal seam gas, petroleum, including unconventional petroleum, oil shale and geothermal energy.\\r\\n\\r\\n#Geoscience products and services\\r\\nWe make mineral and energy geoscience data and information available to industry and government through our publications, maps and digital data products.\\r\\n\\r\\nThe Exploration Data Centre (EDC) at Brisbane and the John Campbell Miles Drill Core Storage Facility at Mount Isa house geoscience data and information dating back to the mid-1800s. The collections include [drill core and cuttings](https://www.business.qld.gov.au/industries/mining-energy-water/resources/geoscience-information/exploration-incentives/drillcore) from the Department of Natural Resources, Mines and Energy (DNRME) and company exploration programs, and samples from GSQ mapping fieldwork. The EDC also provides [HyLoggerTM scanning services](https://www.business.qld.gov.au/industries/mining-energy-water/resources/geoscience-information/exploration-incentives/drillcore).\\r\\n\\r\\n#Online services\\r\\nOnline access is available for many of our products, through [MinesOnlineMaps](https://www.business.qld.gov.au/industries/mining-energy-water/resources/minerals-coal/online-services/minesonlinemaps), [QDEX Reports](https://www.business.qld.gov.au/industries/mining-energy-water/resources/minerals-coal/online-services/qdex-reports), [QDEX Data](https://www.business.qld.gov.au/industries/mining-energy-water/resources/minerals-coal/online-services/qdex-data) and [QSpatial](https://www.business.qld.gov.au/running-business/support-assistance/mapping-data-imagery/data/qspatial).\",\n",
       "  'title': 'Geological Survey of Queensland',\n",
       "  'created': '2019-05-13T06:53:09.682491',\n",
       "  'approval_status': 'approved',\n",
       "  'is_organization': True,\n",
       "  'state': 'active',\n",
       "  'image_url': '',\n",
       "  'revision_id': 'b9031482-a8a6-4e61-a732-be0c4f4dc8d7',\n",
       "  'type': 'organization',\n",
       "  'id': '1461ac2d-f813-4c97-9e3b-3900a23b0ecb',\n",
       "  'name': 'geological-survey-of-queensland'},\n",
       " 'revision_id': '77237145-3e1b-422b-93be-4530c35aa3f4'}"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#look at a result for the structure\n",
    "results_list[0]['result']['results'][887]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "#each one has organisation - don't really need\n",
    "#id, , author, spatial, type is useful\n",
    "#resources - a list of dicts, \n",
    "#eg resource:description:\n",
    "#resource description dictionary\n",
    "#a resource id, resource:size, resource:, download_url, name, url, resource_type etc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "#will try and make a dataframe\n",
    "#but using the batched results, getting the ids\n",
    "#turning the resource dictionaries into dataframes, concatenating\n",
    "#then concatenating back at the end"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|█████████████████████████████████████████████████████████████████████████████████| 13/13 [40:32<00:00, 187.08s/it]\n"
     ]
    }
   ],
   "source": [
    "result_ids = []\n",
    "for batch in tqdm(results_list, total=len(results_list) ):\n",
    "    results = batch['result']['results']\n",
    "    for r in results:\n",
    "        rid = r['id']\n",
    "        rauthor = r['author']\n",
    "        rspatial = r['spatial']\n",
    "        rtype = r['type']\n",
    "        \n",
    "        if len(r['resources']) > 0:\n",
    "            part_list = []\n",
    "            for part in r['resources']:\n",
    "                #modify the columns here to include what you want\n",
    "                df = pd.DataFrame([part])\n",
    "                df['rid'] = rid\n",
    "                df['rauthor'] = rauthor\n",
    "                df['rspatial'] = rspatial\n",
    "                df['type'] = rtype\n",
    "                part_list.append(df)\n",
    "                allparts = pd.concat(part_list)\n",
    "                \n",
    "            result_ids.append(allparts)\n",
    "\n",
    "dfDatasets = pd.concat(result_ids)            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfDatasets.to_csv(r'H:\\GSQ_Geochemistry_Datasets.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10\n",
      "4267\n",
      "aaa7c8c3-d69b-4ae6-bc4b-2542301b7e6e\n",
      "39bc2c60-d727-4383-b82d-6af7fdf8cf7b\n",
      "2f3d761c-6506-438a-934a-87e48cc8d25e\n",
      "8a1f58c4-2e61-44a5-a573-794396652ea6\n",
      "55a1c3a1-107f-4a65-9bec-bef9e6eb8d6b\n",
      "8157408f-83af-4515-9279-f502ae16c155\n",
      "37a2fb0c-49c5-444a-a7da-4947ae9dad94\n",
      "3897db72-0d38-4f11-aad4-8fa8907d20bb\n",
      "4d5ae331-3cfb-4042-a4b5-1955c135cace\n",
      "30b6b5fc-ba25-4bfe-a76b-c35d72ba07e0\n"
     ]
    }
   ],
   "source": [
    "#this is what a default query would look like\n",
    "query_default = api + 'package_search?q=seismic\n",
    "\n",
    "response = requests.get(query_default)\n",
    "json_response = response.json()\n",
    "\n",
    "print(json_response['result']['count'])\n",
    "print(len(json_response['result']['results']) )\n",
    "for x in json_response['result']['results']:\n",
    "    print(x[\"id\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Check how many are of type seismic, not report"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1290"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDatasets.loc[dfDatasets['type'] == 'seismic']['rid'].unique().size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "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>resource:description</th>\n",
       "      <th>cache_last_updated</th>\n",
       "      <th>package_id</th>\n",
       "      <th>datastore_contains_all_records_of_source_file</th>\n",
       "      <th>datastore_active</th>\n",
       "      <th>id</th>\n",
       "      <th>size</th>\n",
       "      <th>resource:format</th>\n",
       "      <th>resource:size</th>\n",
       "      <th>download_url</th>\n",
       "      <th>...</th>\n",
       "      <th>rid</th>\n",
       "      <th>rauthor</th>\n",
       "      <th>rspatial</th>\n",
       "      <th>type</th>\n",
       "      <th>original_url</th>\n",
       "      <th>resource_id</th>\n",
       "      <th>set_url_type</th>\n",
       "      <th>ignore_hash</th>\n",
       "      <th>ckan_url</th>\n",
       "      <th>task_created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>95332_GEOMETRY_SHP</td>\n",
       "      <td>None</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>geo-spa303286-ss095332</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td></td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/39b...</td>\n",
       "      <td>...</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Data migrated from source</td>\n",
       "      <td>None</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>geo-doc530683-ss095332</td>\n",
       "      <td>None</td>\n",
       "      <td>JSON</td>\n",
       "      <td>1 B</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/39b...</td>\n",
       "      <td>...</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...</td>\n",
       "      <td>None</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>geo-doc1040204-ss095332</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>935.93 MB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...</td>\n",
       "      <td>None</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>geo-doc1040205-ss095332</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>184.41 MB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...</td>\n",
       "      <td>None</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>geo-doc1040206-ss095332</td>\n",
       "      <td>None</td>\n",
       "      <td>SHP</td>\n",
       "      <td>37.59 KB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>39bc2c60-d727-4383-b82d-6af7fdf8cf7b</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Line_96-GYR_SEGD</td>\n",
       "      <td>None</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>geo-doc1302238-ss095054</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>89.84 MB</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/046...</td>\n",
       "      <td>...</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Line_96-GYZ_SEGD</td>\n",
       "      <td>None</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>geo-doc1302239-ss095054</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>499.81 MB</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/046...</td>\n",
       "      <td>...</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Line_96-GZH_SEGD</td>\n",
       "      <td>None</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>geo-doc1302240-ss095054</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>441.86 MB</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/046...</td>\n",
       "      <td>...</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Line_96-GZJ_SEGD</td>\n",
       "      <td>None</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>geo-doc1302241-ss095054</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>443.2 MB</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/046...</td>\n",
       "      <td>...</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Line_96-GZK_SEGD</td>\n",
       "      <td>None</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>geo-doc1302242-ss095054</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIP</td>\n",
       "      <td>440.07 MB</td>\n",
       "      <td>https://geoscience.data.qld.gov.au/dataset/046...</td>\n",
       "      <td>...</td>\n",
       "      <td>046e9982-89ff-4297-ba5b-baca0bceefaf</td>\n",
       "      <td>None</td>\n",
       "      <td>{\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...</td>\n",
       "      <td>seismic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8530 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 resource:description cache_last_updated  \\\n",
       "0                                  95332_GEOMETRY_SHP               None   \n",
       "0                           Data migrated from source               None   \n",
       "0   KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...               None   \n",
       "0   KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...               None   \n",
       "0   KOGAN SEISMIC SURVEY 2012 Seismic Survey: 9533...               None   \n",
       "..                                                ...                ...   \n",
       "0                                    Line_96-GYR_SEGD               None   \n",
       "0                                    Line_96-GYZ_SEGD               None   \n",
       "0                                    Line_96-GZH_SEGD               None   \n",
       "0                                    Line_96-GZJ_SEGD               None   \n",
       "0                                    Line_96-GZK_SEGD               None   \n",
       "\n",
       "                              package_id  \\\n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b   \n",
       "..                                   ...   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf   \n",
       "\n",
       "   datastore_contains_all_records_of_source_file datastore_active  \\\n",
       "0                                            NaN              NaN   \n",
       "0                                            NaN              NaN   \n",
       "0                                            NaN              NaN   \n",
       "0                                            NaN              NaN   \n",
       "0                                            NaN              NaN   \n",
       "..                                           ...              ...   \n",
       "0                                          False            False   \n",
       "0                                          False            False   \n",
       "0                                          False            False   \n",
       "0                                          False            False   \n",
       "0                                          False            False   \n",
       "\n",
       "                         id  size resource:format resource:size  \\\n",
       "0    geo-spa303286-ss095332  None             ZIP                 \n",
       "0    geo-doc530683-ss095332  None            JSON           1 B   \n",
       "0   geo-doc1040204-ss095332  None             ZIP     935.93 MB   \n",
       "0   geo-doc1040205-ss095332  None             ZIP     184.41 MB   \n",
       "0   geo-doc1040206-ss095332  None             SHP      37.59 KB   \n",
       "..                      ...   ...             ...           ...   \n",
       "0   geo-doc1302238-ss095054  None             ZIP      89.84 MB   \n",
       "0   geo-doc1302239-ss095054  None             ZIP     499.81 MB   \n",
       "0   geo-doc1302240-ss095054  None             ZIP     441.86 MB   \n",
       "0   geo-doc1302241-ss095054  None             ZIP      443.2 MB   \n",
       "0   geo-doc1302242-ss095054  None             ZIP     440.07 MB   \n",
       "\n",
       "                                         download_url  ...  \\\n",
       "0   https://geoscience.data.qld.gov.au/dataset/39b...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/39b...  ...   \n",
       "0                                                 NaN  ...   \n",
       "0                                                 NaN  ...   \n",
       "0                                                 NaN  ...   \n",
       "..                                                ...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/046...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/046...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/046...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/046...  ...   \n",
       "0   https://geoscience.data.qld.gov.au/dataset/046...  ...   \n",
       "\n",
       "                                     rid rauthor  \\\n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b    None   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b    None   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b    None   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b    None   \n",
       "0   39bc2c60-d727-4383-b82d-6af7fdf8cf7b    None   \n",
       "..                                   ...     ...   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf    None   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf    None   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf    None   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf    None   \n",
       "0   046e9982-89ff-4297-ba5b-baca0bceefaf    None   \n",
       "\n",
       "                                             rspatial     type original_url  \\\n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[150.3344387...  seismic          NaN   \n",
       "..                                                ...      ...          ...   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...  seismic          NaN   \n",
       "0   {\"type\":\"Polygon\",\"coordinates\":[[[140.9778903...  seismic          NaN   \n",
       "\n",
       "   resource_id set_url_type ignore_hash ckan_url task_created  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "..         ...          ...         ...      ...          ...  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "0          NaN          NaN         NaN      NaN          NaN  \n",
       "\n",
       "[8530 rows x 37 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDatasets.loc[dfDatasets['type'] == 'seismic']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://gsq-prod-ckan-horizon-public.s3.ap-southeast-2.amazonaws.com/Report%2f6342%2fDocument%2f443809%2f6342.zip'"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDatasets['url'].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    https://geoscience.data.qld.gov.au/dataset/39b...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/39b...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/8a1...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/8a1...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/13d...\n",
       "                           ...                        \n",
       "0    https://geoscience.data.qld.gov.au/dataset/046...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/046...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/046...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/046...\n",
       "0    https://geoscience.data.qld.gov.au/dataset/046...\n",
       "Name: download_url, Length: 2423, dtype: object"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDatasets['download_url'].loc[ (dfDatasets['type'] == 'seismic') & (dfDatasets['download_url'].str.contains('geoscience') )  ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://geoscience.data.qld.gov.au/dataset/39bc2c60-d727-4383-b82d-6af7fdf8cf7b/resource/geo-spa303286-ss095332/download/%252FSurvey%25252f95332%25252fGeometry%25252f303286%25252f95332_GEOMETRY_SHP.zip'"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDatasets['download_url'].loc[ (dfDatasets['type'] == 'seismic') & (dfDatasets['download_url'].str.contains('geoscience') )  ].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "download_link = 'https://gsq-horizon.s3-ap-southeast-2.amazonaws.com/SEISMIC/2D_Surveys/2010-2019/95332_KOGAN_SEISMIC_SURVEY_2012/95332_PROCESSED.ZIP'\n",
    "download_response = requests.get(download_link)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "from zipfile import ZipFile\n",
    "\n",
    "def extract_zip(input_zip):\n",
    "    input_zip=ZipFile(input_zip)\n",
    "    return {name: input_zip.read(name) for name in input_zip.namelist()}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "981394400"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(download_response.content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import io, zipfile\n",
    "download_link = 'https://gsq-horizon.s3-ap-southeast-2.amazonaws.com/SEISMIC/2D_Surveys/2010-2019/95332_KOGAN_SEISMIC_SURVEY_2012/95332_PROCESSED.ZIP'\n",
    "download_response = requests.get(download_link)\n",
    "\n",
    "zips = zipfile.ZipFile(io.BytesIO(response.content))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfDatasets.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "tw = pd.read_csv('https://geoscience.data.qld.gov.au/dataset/7c9c524c-7c40-456c-94bc-89b4f83ea240/resource/4e680199-0e38-45e2-b882-e3ec9b4e71c2/download/h_loc_town4.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Unnamed: 0</th>\n",
       "      <th>Prospect_Code</th>\n",
       "      <th>Company</th>\n",
       "      <th>Sheet_Number</th>\n",
       "      <th>Hole_ID</th>\n",
       "      <th>Grid_ID</th>\n",
       "      <th>Country</th>\n",
       "      <th>State</th>\n",
       "      <th>Amg_N</th>\n",
       "      <th>Amg_E</th>\n",
       "      <th>RL_Regional</th>\n",
       "      <th>North</th>\n",
       "      <th>East</th>\n",
       "      <th>RL_Local</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location_Accuracy</th>\n",
       "      <th>Drilling_Type</th>\n",
       "      <th>Program_Type</th>\n",
       "      <th>Commodity_Type</th>\n",
       "      <th>Precollar_Depth</th>\n",
       "      <th>Final_Depth</th>\n",
       "      <th>Cover_Depth</th>\n",
       "      <th>Cover_Status</th>\n",
       "      <th>Cover_Age</th>\n",
       "      <th>BOCO_Depth</th>\n",
       "      <th>BOCO_Status</th>\n",
       "      <th>BOPO_Depth</th>\n",
       "      <th>BOPO_Status</th>\n",
       "      <th>Log_By</th>\n",
       "      <th>Perc_Start</th>\n",
       "      <th>Perc_End</th>\n",
       "      <th>Core_Start</th>\n",
       "      <th>Core_End</th>\n",
       "      <th>P_Drill_Co</th>\n",
       "      <th>D_Drill_Co</th>\n",
       "      <th>P_Drill_Rig</th>\n",
       "      <th>D_Drill_Rig</th>\n",
       "      <th>Completion_Status</th>\n",
       "      <th>Min_Occ</th>\n",
       "      <th>Geological_Unit_Code</th>\n",
       "      <th>Comment</th>\n",
       "      <th>Tenement_Type</th>\n",
       "      <th>Tenement</th>\n",
       "      <th>Report_Type</th>\n",
       "      <th>Report</th>\n",
       "      <th>Open_File</th>\n",
       "      <th>HasTextParams</th>\n",
       "      <th>Collar_ID</th>\n",
       "      <th>Locality</th>\n",
       "      <th>Water_Depth</th>\n",
       "      <th>Water_Table_Status</th>\n",
       "      <th>TagCharacter</th>\n",
       "      <th>Image_ID</th>\n",
       "      <th>Load_Number</th>\n",
       "      <th>Date_Updated</th>\n",
       "      <th>User_Updating</th>\n",
       "      <th>Update_Status</th>\n",
       "      <th>TS_Release</th>\n",
       "      <th>Spatial_Status</th>\n",
       "      <th>geometry</th>\n",
       "      <th>BIMNAME</th>\n",
       "      <th>BIMCODE</th>\n",
       "      <th>BLOCKDESC</th>\n",
       "      <th>BLOCKNO</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>112952</td>\n",
       "      <td>STMAY</td>\n",
       "      <td>STRIKE</td>\n",
       "      <td>7765</td>\n",
       "      <td>MNPRC-01</td>\n",
       "      <td>AMG2</td>\n",
       "      <td>AUS</td>\n",
       "      <td>QLD</td>\n",
       "      <td>8222304.14</td>\n",
       "      <td>213320.93</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-16.062367</td>\n",
       "      <td>144.320555</td>\n",
       "      <td>20.0</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Au</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPM</td>\n",
       "      <td>9444</td>\n",
       "      <td>CR</td>\n",
       "      <td>30632</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5004761</td>\n",
       "      <td>100km W of Peninsula Development Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>MM0003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (144.3216544859121 -16.06085298504066)</td>\n",
       "      <td>Townsville</td>\n",
       "      <td>TOWN</td>\n",
       "      <td>TOWN4</td>\n",
       "      <td>4</td>\n",
       "      <td>0.333331</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>112953</td>\n",
       "      <td>STMAY</td>\n",
       "      <td>STRIKE</td>\n",
       "      <td>7765</td>\n",
       "      <td>MNPRC-02</td>\n",
       "      <td>AMG2</td>\n",
       "      <td>AUS</td>\n",
       "      <td>QLD</td>\n",
       "      <td>8222505.34</td>\n",
       "      <td>213020.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-16.060515</td>\n",
       "      <td>144.317776</td>\n",
       "      <td>20.0</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Au</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPM</td>\n",
       "      <td>9444</td>\n",
       "      <td>CR</td>\n",
       "      <td>30632</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5004762</td>\n",
       "      <td>100km W of Peninsula Development Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>MM0003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (144.3188755080479 -16.05900100594847)</td>\n",
       "      <td>Townsville</td>\n",
       "      <td>TOWN</td>\n",
       "      <td>TOWN4</td>\n",
       "      <td>4</td>\n",
       "      <td>0.333331</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>112954</td>\n",
       "      <td>STMAY</td>\n",
       "      <td>STRIKE</td>\n",
       "      <td>7765</td>\n",
       "      <td>MNPRC-03</td>\n",
       "      <td>AMG2</td>\n",
       "      <td>AUS</td>\n",
       "      <td>QLD</td>\n",
       "      <td>8222844.19</td>\n",
       "      <td>212990.57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-16.057451</td>\n",
       "      <td>144.317535</td>\n",
       "      <td>20.0</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Au</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPM</td>\n",
       "      <td>9444</td>\n",
       "      <td>CR</td>\n",
       "      <td>30632</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5004763</td>\n",
       "      <td>100km W of Peninsula Development Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>MM0003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (144.3186344947746 -16.05593701922389)</td>\n",
       "      <td>Townsville</td>\n",
       "      <td>TOWN</td>\n",
       "      <td>TOWN4</td>\n",
       "      <td>4</td>\n",
       "      <td>0.333331</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0 Prospect_Code Company  Sheet_Number   Hole_ID Grid_ID Country  \\\n",
       "0      112952         STMAY  STRIKE          7765  MNPRC-01    AMG2     AUS   \n",
       "1      112953         STMAY  STRIKE          7765  MNPRC-02    AMG2     AUS   \n",
       "2      112954         STMAY  STRIKE          7765  MNPRC-03    AMG2     AUS   \n",
       "\n",
       "  State       Amg_N      Amg_E  RL_Regional  North  East  RL_Local   Latitude  \\\n",
       "0   QLD  8222304.14  213320.93          NaN    NaN   NaN       NaN -16.062367   \n",
       "1   QLD  8222505.34  213020.80          NaN    NaN   NaN       NaN -16.060515   \n",
       "2   QLD  8222844.19  212990.57          NaN    NaN   NaN       NaN -16.057451   \n",
       "\n",
       "    Longitude  Location_Accuracy Drilling_Type  Program_Type Commodity_Type  \\\n",
       "0  144.320555               20.0          PERC           NaN             Au   \n",
       "1  144.317776               20.0          PERC           NaN             Au   \n",
       "2  144.317535               20.0          PERC           NaN             Au   \n",
       "\n",
       "   Precollar_Depth  Final_Depth  Cover_Depth  Cover_Status  Cover_Age  \\\n",
       "0              NaN        154.0          NaN           NaN        NaN   \n",
       "1              NaN         94.0          NaN           NaN        NaN   \n",
       "2              NaN         42.0          NaN           NaN        NaN   \n",
       "\n",
       "   BOCO_Depth  BOCO_Status  BOPO_Depth  BOPO_Status  Log_By  Perc_Start  \\\n",
       "0         NaN          NaN         NaN          NaN     NaN         NaN   \n",
       "1         NaN          NaN         NaN          NaN     NaN         NaN   \n",
       "2         NaN          NaN         NaN          NaN     NaN         NaN   \n",
       "\n",
       "   Perc_End  Core_Start  Core_End  P_Drill_Co  D_Drill_Co  P_Drill_Rig  \\\n",
       "0       NaN         NaN       NaN         NaN         NaN          NaN   \n",
       "1       NaN         NaN       NaN         NaN         NaN          NaN   \n",
       "2       NaN         NaN       NaN         NaN         NaN          NaN   \n",
       "\n",
       "   D_Drill_Rig Completion_Status  Min_Occ  Geological_Unit_Code  Comment  \\\n",
       "0          NaN                 C      NaN                   NaN      NaN   \n",
       "1          NaN                 C      NaN                   NaN      NaN   \n",
       "2          NaN                 C      NaN                   NaN      NaN   \n",
       "\n",
       "  Tenement_Type  Tenement Report_Type  Report Open_File  HasTextParams  \\\n",
       "0           EPM      9444          CR   30632         Y            NaN   \n",
       "1           EPM      9444          CR   30632         Y            NaN   \n",
       "2           EPM      9444          CR   30632         Y            NaN   \n",
       "\n",
       "   Collar_ID                               Locality  Water_Depth  \\\n",
       "0    5004761  100km W of Peninsula Development Road          NaN   \n",
       "1    5004762  100km W of Peninsula Development Road          NaN   \n",
       "2    5004763  100km W of Peninsula Development Road          NaN   \n",
       "\n",
       "   Water_Table_Status TagCharacter  Image_ID  Load_Number       Date_Updated  \\\n",
       "0                 NaN            M       NaN            0  6/01/2016 0:00:00   \n",
       "1                 NaN            M       NaN            0  6/01/2016 0:00:00   \n",
       "2                 NaN            M       NaN            0  6/01/2016 0:00:00   \n",
       "\n",
       "  User_Updating  Update_Status TS_Release  Spatial_Status  \\\n",
       "0            PA              1     MM0003             NaN   \n",
       "1            PA              1     MM0003             NaN   \n",
       "2            PA              1     MM0003             NaN   \n",
       "\n",
       "                                       geometry     BIMNAME BIMCODE BLOCKDESC  \\\n",
       "0  POINT (144.3216544859121 -16.06085298504066)  Townsville    TOWN     TOWN4   \n",
       "1  POINT (144.3188755080479 -16.05900100594847)  Townsville    TOWN     TOWN4   \n",
       "2  POINT (144.3186344947746 -16.05593701922389)  Townsville    TOWN     TOWN4   \n",
       "\n",
       "   BLOCKNO  SHAPE_Leng  SHAPE_Area  \n",
       "0        4    0.333331    0.006944  \n",
       "1        4    0.333331    0.006944  \n",
       "2        4    0.333331    0.006944  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "br = pd.read_csv('https://geoscience.data.qld.gov.au/dataset/c8510270-dbc6-48f9-95e6-a8936733b583/resource/02d2e353-c3c9-4633-a6c3-61827c793bf7/download/h_survey_bris2820.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>Unnamed: 0</th>\n",
       "      <th>Prospect_Code</th>\n",
       "      <th>Company</th>\n",
       "      <th>Sheet_Number</th>\n",
       "      <th>Hole_ID</th>\n",
       "      <th>Depth_survey</th>\n",
       "      <th>Dip</th>\n",
       "      <th>Magnetic_Az</th>\n",
       "      <th>Regional_Azimuth</th>\n",
       "      <th>Local_Grid_Azimuth</th>\n",
       "      <th>Instrument</th>\n",
       "      <th>TagCharacter</th>\n",
       "      <th>Collar_ID</th>\n",
       "      <th>Survey_ID</th>\n",
       "      <th>HasTextParams</th>\n",
       "      <th>Load_Number</th>\n",
       "      <th>Date_Updated</th>\n",
       "      <th>User_Updating</th>\n",
       "      <th>Update_Status</th>\n",
       "      <th>BIMNAME</th>\n",
       "      <th>BIMCODE</th>\n",
       "      <th>BLOCKDESC</th>\n",
       "      <th>BLOCKNO</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>128469</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005873</td>\n",
       "      <td>5007679</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>128470</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA27</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005874</td>\n",
       "      <td>5007680</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>128471</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005875</td>\n",
       "      <td>5007681</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>128472</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005876</td>\n",
       "      <td>5007682</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>128473</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005877</td>\n",
       "      <td>5007683</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>128474</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005878</td>\n",
       "      <td>5007684</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>128475</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005879</td>\n",
       "      <td>5007685</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>128476</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA33</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005880</td>\n",
       "      <td>5007686</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>128477</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA34</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005881</td>\n",
       "      <td>5007687</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>128478</td>\n",
       "      <td>RGDA</td>\n",
       "      <td>RGC</td>\n",
       "      <td>9043</td>\n",
       "      <td>DA35</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>M</td>\n",
       "      <td>5005882</td>\n",
       "      <td>5007688</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>25/01/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2820</td>\n",
       "      <td>2820</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0 Prospect_Code Company  Sheet_Number Hole_ID  Depth_survey   Dip  \\\n",
       "0      128469          RGDA     RGC          9043    DA26           0.0 -90.0   \n",
       "1      128470          RGDA     RGC          9043    DA27           0.0 -90.0   \n",
       "2      128471          RGDA     RGC          9043    DA28           0.0 -90.0   \n",
       "3      128472          RGDA     RGC          9043    DA29           0.0 -90.0   \n",
       "4      128473          RGDA     RGC          9043    DA30           0.0 -90.0   \n",
       "5      128474          RGDA     RGC          9043    DA31           0.0 -90.0   \n",
       "6      128475          RGDA     RGC          9043    DA32           0.0 -90.0   \n",
       "7      128476          RGDA     RGC          9043    DA33           0.0 -90.0   \n",
       "8      128477          RGDA     RGC          9043    DA34           0.0 -90.0   \n",
       "9      128478          RGDA     RGC          9043    DA35           0.0 -90.0   \n",
       "\n",
       "   Magnetic_Az  Regional_Azimuth  Local_Grid_Azimuth Instrument TagCharacter  \\\n",
       "0          0.0               NaN                 NaN          C            M   \n",
       "1          0.0               NaN                 NaN          C            M   \n",
       "2          0.0               NaN                 NaN          C            M   \n",
       "3          0.0               NaN                 NaN          C            M   \n",
       "4          0.0               NaN                 NaN          C            M   \n",
       "5          0.0               NaN                 NaN          C            M   \n",
       "6          0.0               NaN                 NaN          C            M   \n",
       "7          0.0               NaN                 NaN          C            M   \n",
       "8          0.0               NaN                 NaN          C            M   \n",
       "9          0.0               NaN                 NaN          C            M   \n",
       "\n",
       "   Collar_ID  Survey_ID  HasTextParams  Load_Number        Date_Updated  \\\n",
       "0    5005873    5007679            NaN            0  25/01/2016 0:00:00   \n",
       "1    5005874    5007680            NaN            0  25/01/2016 0:00:00   \n",
       "2    5005875    5007681            NaN            0  25/01/2016 0:00:00   \n",
       "3    5005876    5007682            NaN            0  25/01/2016 0:00:00   \n",
       "4    5005877    5007683            NaN            0  25/01/2016 0:00:00   \n",
       "5    5005878    5007684            NaN            0  25/01/2016 0:00:00   \n",
       "6    5005879    5007685            NaN            0  25/01/2016 0:00:00   \n",
       "7    5005880    5007686            NaN            0  25/01/2016 0:00:00   \n",
       "8    5005881    5007687            NaN            0  25/01/2016 0:00:00   \n",
       "9    5005882    5007688            NaN            0  25/01/2016 0:00:00   \n",
       "\n",
       "  User_Updating  Update_Status   BIMNAME BIMCODE BLOCKDESC  BLOCKNO  \\\n",
       "0            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "1            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "2            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "3            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "4            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "5            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "6            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "7            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "8            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "9            PA              1  Brisbane    BRIS  BRIS2820     2820   \n",
       "\n",
       "   SHAPE_Leng  SHAPE_Area  \n",
       "0     0.33333    0.006944  \n",
       "1     0.33333    0.006944  \n",
       "2     0.33333    0.006944  \n",
       "3     0.33333    0.006944  \n",
       "4     0.33333    0.006944  \n",
       "5     0.33333    0.006944  \n",
       "6     0.33333    0.006944  \n",
       "7     0.33333    0.006944  \n",
       "8     0.33333    0.006944  \n",
       "9     0.33333    0.006944  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "br"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "cl = pd.read_csv('https://geoscience.data.qld.gov.au/dataset/b79c875b-4deb-439b-9e43-8d24eae94906/resource/866c2f3e-bfc4-48d2-9eb5-b95c5516ee57/download/h_sample_clon2040.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>Unnamed: 0</th>\n",
       "      <th>Prospect_Code</th>\n",
       "      <th>Company</th>\n",
       "      <th>Sheet_Number</th>\n",
       "      <th>Hole_ID</th>\n",
       "      <th>Sample</th>\n",
       "      <th>From_Depth</th>\n",
       "      <th>To_Depth</th>\n",
       "      <th>Data_Type</th>\n",
       "      <th>Drilling_Type</th>\n",
       "      <th>North</th>\n",
       "      <th>East</th>\n",
       "      <th>RL</th>\n",
       "      <th>Comment</th>\n",
       "      <th>Au</th>\n",
       "      <th>Au1</th>\n",
       "      <th>Au2</th>\n",
       "      <th>Au3</th>\n",
       "      <th>Au4</th>\n",
       "      <th>Cu</th>\n",
       "      <th>Pb</th>\n",
       "      <th>Zn</th>\n",
       "      <th>Ag</th>\n",
       "      <th>As</th>\n",
       "      <th>Bi</th>\n",
       "      <th>Mo</th>\n",
       "      <th>Mn</th>\n",
       "      <th>Fe</th>\n",
       "      <th>Ni</th>\n",
       "      <th>Co</th>\n",
       "      <th>Cr</th>\n",
       "      <th>V</th>\n",
       "      <th>Ba</th>\n",
       "      <th>Cd</th>\n",
       "      <th>Sn</th>\n",
       "      <th>Sb</th>\n",
       "      <th>Hg</th>\n",
       "      <th>Te</th>\n",
       "      <th>P</th>\n",
       "      <th>W</th>\n",
       "      <th>Zr</th>\n",
       "      <th>Ti</th>\n",
       "      <th>Mg</th>\n",
       "      <th>Th</th>\n",
       "      <th>U</th>\n",
       "      <th>Pt</th>\n",
       "      <th>Pd</th>\n",
       "      <th>S</th>\n",
       "      <th>F</th>\n",
       "      <th>Job_No</th>\n",
       "      <th>HasParam</th>\n",
       "      <th>HasTextParams</th>\n",
       "      <th>Duplicate_Flag</th>\n",
       "      <th>Preferred_Interval</th>\n",
       "      <th>Associated_Sample_Number</th>\n",
       "      <th>Pref_Au_Assay_Field</th>\n",
       "      <th>Wet_Dry_Flag</th>\n",
       "      <th>TagCharacter</th>\n",
       "      <th>Collar_ID</th>\n",
       "      <th>Sample_ID</th>\n",
       "      <th>Load_Number</th>\n",
       "      <th>Date_Updated</th>\n",
       "      <th>User_Updating</th>\n",
       "      <th>Update_Status</th>\n",
       "      <th>Old_Job</th>\n",
       "      <th>Lab_Code</th>\n",
       "      <th>Job_Date</th>\n",
       "      <th>Alias_Job</th>\n",
       "      <th>Dispatch_No</th>\n",
       "      <th>Location_Code</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_From</th>\n",
       "      <th>Date_To</th>\n",
       "      <th>BIMNAME</th>\n",
       "      <th>BIMCODE</th>\n",
       "      <th>BLOCKDESC</th>\n",
       "      <th>BLOCKNO</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1382848</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130016</td>\n",
       "      <td>78.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81055</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806994</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0827</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1382849</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81060</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806995</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0832</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1382850</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130018</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81058</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806996</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1382851</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130019</td>\n",
       "      <td>84.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81062</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806997</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0834</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1382852</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130020</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81049</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806998</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1382853</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130021</td>\n",
       "      <td>88.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81052</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>806999</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1382854</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130022</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81058</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>807000</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1382855</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1318</td>\n",
       "      <td>130023</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81058</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77811</td>\n",
       "      <td>807001</td>\n",
       "      <td>11548</td>\n",
       "      <td>1/04/2010 9:07:52</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1382856</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4180</td>\n",
       "      <td>60.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81088</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807002</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0856</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1382857</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4181</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81089</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807003</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1382858</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4182</td>\n",
       "      <td>64.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81080</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807004</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0848</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1382859</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4183</td>\n",
       "      <td>66.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81088</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807005</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0856</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1382860</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4184</td>\n",
       "      <td>68.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81085</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807006</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1382861</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4185</td>\n",
       "      <td>70.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81093</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807007</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1382862</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4186</td>\n",
       "      <td>72.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81078</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807008</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1382863</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4187</td>\n",
       "      <td>74.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81079</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807009</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:53</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0847</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1382864</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4188</td>\n",
       "      <td>76.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81086</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807010</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0854</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1382865</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4189</td>\n",
       "      <td>78.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81073</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807011</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1382866</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4190</td>\n",
       "      <td>80.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81085</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807012</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1382867</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1401</td>\n",
       "      <td>4191</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81078</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77812</td>\n",
       "      <td>807013</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1382868</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1402</td>\n",
       "      <td>4192</td>\n",
       "      <td>56.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81088</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77813</td>\n",
       "      <td>807014</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0856</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1382869</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1402</td>\n",
       "      <td>4193</td>\n",
       "      <td>58.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81091</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77813</td>\n",
       "      <td>807015</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0859</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1382870</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1402</td>\n",
       "      <td>4194</td>\n",
       "      <td>60.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81067</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77813</td>\n",
       "      <td>807016</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1382871</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1402</td>\n",
       "      <td>4195</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81072</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77813</td>\n",
       "      <td>807017</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0840</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1382872</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1402</td>\n",
       "      <td>4196</td>\n",
       "      <td>64.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81065</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77813</td>\n",
       "      <td>807018</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0822</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1382873</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4197</td>\n",
       "      <td>60.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81088</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807019</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0856</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1382874</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4198</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81091</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807020</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:54</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0859</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1382875</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4199</td>\n",
       "      <td>64.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81091</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807021</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:55</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0859</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1382876</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4200</td>\n",
       "      <td>66.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81088</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807022</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:55</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0856</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1382877</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4201</td>\n",
       "      <td>68.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81077</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807023</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:55</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1382878</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>1403</td>\n",
       "      <td>4202</td>\n",
       "      <td>70.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Geology given but not entered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK81083</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77814</td>\n",
       "      <td>807024</td>\n",
       "      <td>11582</td>\n",
       "      <td>1/04/2010 9:07:55</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSUNK0851</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1382879</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1049</td>\n",
       "      <td>60.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82031</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807156</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0519</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1382880</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1050</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82028</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807157</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1382881</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1051</td>\n",
       "      <td>64.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82031</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807158</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0519</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1382882</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1052</td>\n",
       "      <td>66.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82028</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807159</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1382883</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1053</td>\n",
       "      <td>68.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82027</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807160</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0515</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1382884</td>\n",
       "      <td>TSPEBR</td>\n",
       "      <td>PNC</td>\n",
       "      <td>6853</td>\n",
       "      <td>BR24</td>\n",
       "      <td>1054</td>\n",
       "      <td>70.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>INT</td>\n",
       "      <td>PERC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD82023</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>77832</td>\n",
       "      <td>807161</td>\n",
       "      <td>11638</td>\n",
       "      <td>1/04/2010 9:08:06</td>\n",
       "      <td>dba</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TSAMD0511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cloncurry</td>\n",
       "      <td>CLON</td>\n",
       "      <td>CLON2040</td>\n",
       "      <td>2040</td>\n",
       "      <td>0.333326</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0 Prospect_Code Company  Sheet_Number Hole_ID  Sample  \\\n",
       "0      1382848        TSPEBR     PNC          6853    1318  130016   \n",
       "1      1382849        TSPEBR     PNC          6853    1318  130017   \n",
       "2      1382850        TSPEBR     PNC          6853    1318  130018   \n",
       "3      1382851        TSPEBR     PNC          6853    1318  130019   \n",
       "4      1382852        TSPEBR     PNC          6853    1318  130020   \n",
       "5      1382853        TSPEBR     PNC          6853    1318  130021   \n",
       "6      1382854        TSPEBR     PNC          6853    1318  130022   \n",
       "7      1382855        TSPEBR     PNC          6853    1318  130023   \n",
       "8      1382856        TSPEBR     PNC          6853    1401    4180   \n",
       "9      1382857        TSPEBR     PNC          6853    1401    4181   \n",
       "10     1382858        TSPEBR     PNC          6853    1401    4182   \n",
       "11     1382859        TSPEBR     PNC          6853    1401    4183   \n",
       "12     1382860        TSPEBR     PNC          6853    1401    4184   \n",
       "13     1382861        TSPEBR     PNC          6853    1401    4185   \n",
       "14     1382862        TSPEBR     PNC          6853    1401    4186   \n",
       "15     1382863        TSPEBR     PNC          6853    1401    4187   \n",
       "16     1382864        TSPEBR     PNC          6853    1401    4188   \n",
       "17     1382865        TSPEBR     PNC          6853    1401    4189   \n",
       "18     1382866        TSPEBR     PNC          6853    1401    4190   \n",
       "19     1382867        TSPEBR     PNC          6853    1401    4191   \n",
       "20     1382868        TSPEBR     PNC          6853    1402    4192   \n",
       "21     1382869        TSPEBR     PNC          6853    1402    4193   \n",
       "22     1382870        TSPEBR     PNC          6853    1402    4194   \n",
       "23     1382871        TSPEBR     PNC          6853    1402    4195   \n",
       "24     1382872        TSPEBR     PNC          6853    1402    4196   \n",
       "25     1382873        TSPEBR     PNC          6853    1403    4197   \n",
       "26     1382874        TSPEBR     PNC          6853    1403    4198   \n",
       "27     1382875        TSPEBR     PNC          6853    1403    4199   \n",
       "28     1382876        TSPEBR     PNC          6853    1403    4200   \n",
       "29     1382877        TSPEBR     PNC          6853    1403    4201   \n",
       "30     1382878        TSPEBR     PNC          6853    1403    4202   \n",
       "31     1382879        TSPEBR     PNC          6853    BR24    1049   \n",
       "32     1382880        TSPEBR     PNC          6853    BR24    1050   \n",
       "33     1382881        TSPEBR     PNC          6853    BR24    1051   \n",
       "34     1382882        TSPEBR     PNC          6853    BR24    1052   \n",
       "35     1382883        TSPEBR     PNC          6853    BR24    1053   \n",
       "36     1382884        TSPEBR     PNC          6853    BR24    1054   \n",
       "\n",
       "    From_Depth  To_Depth Data_Type Drilling_Type  North  East  RL  \\\n",
       "0         78.0      80.0       INT          PERC    NaN   NaN NaN   \n",
       "1         80.0      82.0       INT          PERC    NaN   NaN NaN   \n",
       "2         82.0      84.0       INT          PERC    NaN   NaN NaN   \n",
       "3         84.0      86.0       INT          PERC    NaN   NaN NaN   \n",
       "4         86.0      88.0       INT          PERC    NaN   NaN NaN   \n",
       "5         88.0      90.0       INT          PERC    NaN   NaN NaN   \n",
       "6         90.0      92.0       INT          PERC    NaN   NaN NaN   \n",
       "7         92.0      94.0       INT          PERC    NaN   NaN NaN   \n",
       "8         60.0      62.0       INT          PERC    NaN   NaN NaN   \n",
       "9         62.0      64.0       INT          PERC    NaN   NaN NaN   \n",
       "10        64.0      66.0       INT          PERC    NaN   NaN NaN   \n",
       "11        66.0      68.0       INT          PERC    NaN   NaN NaN   \n",
       "12        68.0      70.0       INT          PERC    NaN   NaN NaN   \n",
       "13        70.0      72.0       INT          PERC    NaN   NaN NaN   \n",
       "14        72.0      74.0       INT          PERC    NaN   NaN NaN   \n",
       "15        74.0      76.0       INT          PERC    NaN   NaN NaN   \n",
       "16        76.0      78.0       INT          PERC    NaN   NaN NaN   \n",
       "17        78.0      80.0       INT          PERC    NaN   NaN NaN   \n",
       "18        80.0      82.0       INT          PERC    NaN   NaN NaN   \n",
       "19        82.0      84.0       INT          PERC    NaN   NaN NaN   \n",
       "20        56.0      58.0       INT          PERC    NaN   NaN NaN   \n",
       "21        58.0      60.0       INT          PERC    NaN   NaN NaN   \n",
       "22        60.0      62.0       INT          PERC    NaN   NaN NaN   \n",
       "23        62.0      64.0       INT          PERC    NaN   NaN NaN   \n",
       "24        64.0      66.0       INT          PERC    NaN   NaN NaN   \n",
       "25        60.0      62.0       INT          PERC    NaN   NaN NaN   \n",
       "26        62.0      64.0       INT          PERC    NaN   NaN NaN   \n",
       "27        64.0      66.0       INT          PERC    NaN   NaN NaN   \n",
       "28        66.0      68.0       INT          PERC    NaN   NaN NaN   \n",
       "29        68.0      70.0       INT          PERC    NaN   NaN NaN   \n",
       "30        70.0      72.0       INT          PERC    NaN   NaN NaN   \n",
       "31        60.0      62.0       INT          PERC    NaN   NaN NaN   \n",
       "32        62.0      64.0       INT          PERC    NaN   NaN NaN   \n",
       "33        64.0      66.0       INT          PERC    NaN   NaN NaN   \n",
       "34        66.0      68.0       INT          PERC    NaN   NaN NaN   \n",
       "35        68.0      70.0       INT          PERC    NaN   NaN NaN   \n",
       "36        70.0      72.0       INT          PERC    NaN   NaN NaN   \n",
       "\n",
       "                          Comment  Au  Au1  Au2  Au3  Au4  Cu  Pb  Zn  Ag  \\\n",
       "0                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "1                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "2                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "3                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "4                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "5                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "6                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "7                             NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "8   Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "9   Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "10  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "11  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "12  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "13  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "14  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "15  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "16  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "17  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "18  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "19  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "20  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "21  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "22  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "23  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "24  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "25  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "26  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "27  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "28  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "29  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "30  Geology given but not entered NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "31                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "32                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "33                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "34                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "35                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "36                            NaN NaN  NaN  NaN  NaN  NaN NaN NaN NaN NaN   \n",
       "\n",
       "      As  Bi   Mo  Mn  Fe  Ni  Co  Cr      V  Ba  Cd  Sn  Sb  Hg  Te   P   W  \\\n",
       "0    9.0 NaN  NaN NaN NaN NaN NaN NaN   60.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "1    7.0 NaN  NaN NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "2    9.0 NaN  NaN NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "3   15.0 NaN  3.0 NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "4    NaN NaN  NaN NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "5    3.0 NaN  NaN NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "6    9.0 NaN  NaN NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "7    8.0 NaN  NaN NaN NaN NaN NaN NaN   60.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "8    5.0 NaN  NaN NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "9    9.0 NaN  NaN NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "10   8.0 NaN  NaN NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "11   3.0 NaN  NaN NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "12   6.0 NaN  3.0 NaN NaN NaN NaN NaN   60.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "13   7.0 NaN  3.0 NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "14   2.0 NaN  NaN NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "15   3.0 NaN  3.0 NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "16   5.0 NaN  NaN NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "17   NaN NaN  NaN NaN NaN NaN NaN NaN   30.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "18   3.0 NaN  6.0 NaN NaN NaN NaN NaN   60.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "19   2.0 NaN  NaN NaN NaN NaN NaN NaN   30.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "20   5.0 NaN  NaN NaN NaN NaN NaN NaN  300.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "21  10.0 NaN  NaN NaN NaN NaN NaN NaN  300.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "22   5.0 NaN  NaN NaN NaN NaN NaN NaN   80.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "23   7.0 NaN  NaN NaN NaN NaN NaN NaN   80.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "24   NaN NaN  NaN NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "25   5.0 NaN  NaN NaN NaN NaN NaN NaN  200.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "26   6.0 NaN  NaN NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "27   4.0 NaN  NaN NaN NaN NaN NaN NaN  150.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "28   8.0 NaN  NaN NaN NaN NaN NaN NaN  100.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "29   NaN NaN  3.0 NaN NaN NaN NaN NaN   80.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "30   NaN NaN  3.0 NaN NaN NaN NaN NaN   40.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "31   6.0 NaN  NaN NaN NaN NaN NaN NaN   90.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "32   7.0 NaN  NaN NaN NaN NaN NaN NaN  110.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "33   5.0 NaN  NaN NaN NaN NaN NaN NaN   60.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "34   3.0 NaN  NaN NaN NaN NaN NaN NaN   30.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "35   7.0 NaN  NaN NaN NaN NaN NaN NaN   20.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "36   2.0 NaN  NaN NaN NaN NaN NaN NaN   20.0 NaN NaN NaN NaN NaN NaN NaN NaN   \n",
       "\n",
       "    Zr  Ti  Mg    Th     U  Pt  Pd   S   F      Job_No HasParam HasTextParams  \\\n",
       "0  NaN NaN NaN  12.0   NaN NaN NaN NaN NaN  TSUNK81055        Y             N   \n",
       "1  NaN NaN NaN  12.0   4.0 NaN NaN NaN NaN  TSUNK81060        Y             N   \n",
       "2  NaN NaN NaN  14.0  20.0 NaN NaN NaN NaN  TSUNK81058        Y             N   \n",
       "3  NaN NaN NaN   6.0  14.0 NaN NaN NaN NaN  TSUNK81062        Y             N   \n",
       "4  NaN NaN NaN   8.0   NaN NaN NaN NaN NaN  TSUNK81049        N             N   \n",
       "5  NaN NaN NaN  10.0  20.0 NaN NaN NaN NaN  TSUNK81052        N             N   \n",
       "6  NaN NaN NaN  10.0  22.0 NaN NaN NaN NaN  TSUNK81058        Y             N   \n",
       "7  NaN NaN NaN   4.0   4.0 NaN NaN NaN NaN  TSUNK81058        Y             N   \n",
       "8  NaN NaN NaN  16.0   4.0 NaN NaN NaN NaN  TSUNK81088        Y             N   \n",
       "9  NaN NaN NaN  16.0   NaN NaN NaN NaN NaN  TSUNK81089        Y             N   \n",
       "10 NaN NaN NaN  22.0   NaN NaN NaN NaN NaN  TSUNK81080        Y             N   \n",
       "11 NaN NaN NaN  16.0   6.0 NaN NaN NaN NaN  TSUNK81088        Y             N   \n",
       "12 NaN NaN NaN  12.0   8.0 NaN NaN NaN NaN  TSUNK81085        Y             N   \n",
       "13 NaN NaN NaN  14.0   4.0 NaN NaN NaN NaN  TSUNK81093        Y             N   \n",
       "14 NaN NaN NaN  14.0   4.0 NaN NaN NaN NaN  TSUNK81078        Y             N   \n",
       "15 NaN NaN NaN  14.0   NaN NaN NaN NaN NaN  TSUNK81079        Y             N   \n",
       "16 NaN NaN NaN  14.0   8.0 NaN NaN NaN NaN  TSUNK81086        Y             N   \n",
       "17 NaN NaN NaN  12.0   6.0 NaN NaN NaN NaN  TSUNK81073        Y             N   \n",
       "18 NaN NaN NaN   8.0   4.0 NaN NaN NaN NaN  TSUNK81085        Y             N   \n",
       "19 NaN NaN NaN  10.0   4.0 NaN NaN NaN NaN  TSUNK81078        Y             N   \n",
       "20 NaN NaN NaN  16.0   4.0 NaN NaN NaN NaN  TSUNK81088        Y             N   \n",
       "21 NaN NaN NaN  20.0  12.0 NaN NaN NaN NaN  TSUNK81091        Y             N   \n",
       "22 NaN NaN NaN  12.0   6.0 NaN NaN NaN NaN  TSUNK81067        N             N   \n",
       "23 NaN NaN NaN  26.0  95.0 NaN NaN NaN NaN  TSUNK81072        Y             N   \n",
       "24 NaN NaN NaN  20.0   8.0 NaN NaN NaN NaN  TSUNK81065        N             N   \n",
       "25 NaN NaN NaN  16.0   4.0 NaN NaN NaN NaN  TSUNK81088        Y             N   \n",
       "26 NaN NaN NaN  16.0   4.0 NaN NaN NaN NaN  TSUNK81091        Y             N   \n",
       "27 NaN NaN NaN  14.0   8.0 NaN NaN NaN NaN  TSUNK81091        Y             N   \n",
       "28 NaN NaN NaN  14.0  10.0 NaN NaN NaN NaN  TSUNK81088        Y             N   \n",
       "29 NaN NaN NaN  12.0   NaN NaN NaN NaN NaN  TSUNK81077        Y             N   \n",
       "30 NaN NaN NaN  10.0   NaN NaN NaN NaN NaN  TSUNK81083        Y             N   \n",
       "31 NaN NaN NaN  14.0   4.0 NaN NaN NaN NaN  TSAMD82031        Y             N   \n",
       "32 NaN NaN NaN  16.0   4.0 NaN NaN NaN NaN  TSAMD82028        N             N   \n",
       "33 NaN NaN NaN  12.0   8.0 NaN NaN NaN NaN  TSAMD82031        Y             N   \n",
       "34 NaN NaN NaN  12.0   4.0 NaN NaN NaN NaN  TSAMD82028        N             N   \n",
       "35 NaN NaN NaN   6.0   NaN NaN NaN NaN NaN  TSAMD82027        Y             N   \n",
       "36 NaN NaN NaN   4.0   NaN NaN NaN NaN NaN  TSAMD82023        N             N   \n",
       "\n",
       "    Duplicate_Flag  Preferred_Interval  Associated_Sample_Number  \\\n",
       "0              NaN                 NaN                       NaN   \n",
       "1              NaN                 NaN                       NaN   \n",
       "2              NaN                 NaN                       NaN   \n",
       "3              NaN                 NaN                       NaN   \n",
       "4              NaN                 NaN                       NaN   \n",
       "5              NaN                 NaN                       NaN   \n",
       "6              NaN                 NaN                       NaN   \n",
       "7              NaN                 NaN                       NaN   \n",
       "8              NaN                 NaN                       NaN   \n",
       "9              NaN                 NaN                       NaN   \n",
       "10             NaN                 NaN                       NaN   \n",
       "11             NaN                 NaN                       NaN   \n",
       "12             NaN                 NaN                       NaN   \n",
       "13             NaN                 NaN                       NaN   \n",
       "14             NaN                 NaN                       NaN   \n",
       "15             NaN                 NaN                       NaN   \n",
       "16             NaN                 NaN                       NaN   \n",
       "17             NaN                 NaN                       NaN   \n",
       "18             NaN                 NaN                       NaN   \n",
       "19             NaN                 NaN                       NaN   \n",
       "20             NaN                 NaN                       NaN   \n",
       "21             NaN                 NaN                       NaN   \n",
       "22             NaN                 NaN                       NaN   \n",
       "23             NaN                 NaN                       NaN   \n",
       "24             NaN                 NaN                       NaN   \n",
       "25             NaN                 NaN                       NaN   \n",
       "26             NaN                 NaN                       NaN   \n",
       "27             NaN                 NaN                       NaN   \n",
       "28             NaN                 NaN                       NaN   \n",
       "29             NaN                 NaN                       NaN   \n",
       "30             NaN                 NaN                       NaN   \n",
       "31             NaN                 NaN                       NaN   \n",
       "32             NaN                 NaN                       NaN   \n",
       "33             NaN                 NaN                       NaN   \n",
       "34             NaN                 NaN                       NaN   \n",
       "35             NaN                 NaN                       NaN   \n",
       "36             NaN                 NaN                       NaN   \n",
       "\n",
       "    Pref_Au_Assay_Field  Wet_Dry_Flag TagCharacter  Collar_ID  Sample_ID  \\\n",
       "0                   NaN           NaN            T      77811     806994   \n",
       "1                   NaN           NaN            T      77811     806995   \n",
       "2                   NaN           NaN            T      77811     806996   \n",
       "3                   NaN           NaN            T      77811     806997   \n",
       "4                   NaN           NaN            T      77811     806998   \n",
       "5                   NaN           NaN            T      77811     806999   \n",
       "6                   NaN           NaN            T      77811     807000   \n",
       "7                   NaN           NaN            T      77811     807001   \n",
       "8                   NaN           NaN            T      77812     807002   \n",
       "9                   NaN           NaN            T      77812     807003   \n",
       "10                  NaN           NaN            T      77812     807004   \n",
       "11                  NaN           NaN            T      77812     807005   \n",
       "12                  NaN           NaN            T      77812     807006   \n",
       "13                  NaN           NaN            T      77812     807007   \n",
       "14                  NaN           NaN            T      77812     807008   \n",
       "15                  NaN           NaN            T      77812     807009   \n",
       "16                  NaN           NaN            T      77812     807010   \n",
       "17                  NaN           NaN            T      77812     807011   \n",
       "18                  NaN           NaN            T      77812     807012   \n",
       "19                  NaN           NaN            T      77812     807013   \n",
       "20                  NaN           NaN            T      77813     807014   \n",
       "21                  NaN           NaN            T      77813     807015   \n",
       "22                  NaN           NaN            T      77813     807016   \n",
       "23                  NaN           NaN            T      77813     807017   \n",
       "24                  NaN           NaN            T      77813     807018   \n",
       "25                  NaN           NaN            T      77814     807019   \n",
       "26                  NaN           NaN            T      77814     807020   \n",
       "27                  NaN           NaN            T      77814     807021   \n",
       "28                  NaN           NaN            T      77814     807022   \n",
       "29                  NaN           NaN            T      77814     807023   \n",
       "30                  NaN           NaN            T      77814     807024   \n",
       "31                  NaN           NaN            T      77832     807156   \n",
       "32                  NaN           NaN            T      77832     807157   \n",
       "33                  NaN           NaN            T      77832     807158   \n",
       "34                  NaN           NaN            T      77832     807159   \n",
       "35                  NaN           NaN            T      77832     807160   \n",
       "36                  NaN           NaN            T      77832     807161   \n",
       "\n",
       "    Load_Number       Date_Updated User_Updating  Update_Status  Old_Job  \\\n",
       "0         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "1         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "2         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "3         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "4         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "5         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "6         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "7         11548  1/04/2010 9:07:52           dba              1      NaN   \n",
       "8         11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "9         11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "10        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "11        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "12        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "13        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "14        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "15        11582  1/04/2010 9:07:53           dba              1      NaN   \n",
       "16        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "17        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "18        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "19        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "20        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "21        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "22        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "23        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "24        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "25        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "26        11582  1/04/2010 9:07:54           dba              1      NaN   \n",
       "27        11582  1/04/2010 9:07:55           dba              1      NaN   \n",
       "28        11582  1/04/2010 9:07:55           dba              1      NaN   \n",
       "29        11582  1/04/2010 9:07:55           dba              1      NaN   \n",
       "30        11582  1/04/2010 9:07:55           dba              1      NaN   \n",
       "31        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "32        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "33        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "34        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "35        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "36        11638  1/04/2010 9:08:06           dba              1      NaN   \n",
       "\n",
       "   Lab_Code  Job_Date  Alias_Job  Dispatch_No Location_Code  Description  \\\n",
       "0       UNK       NaN  TSUNK0827          NaN           UNK          NaN   \n",
       "1       UNK       NaN  TSUNK0832          NaN           UNK          NaN   \n",
       "2       UNK       NaN  TSUNK0830          NaN           UNK          NaN   \n",
       "3       UNK       NaN  TSUNK0834          NaN           UNK          NaN   \n",
       "4       UNK       NaN  TSUNK0821          NaN           UNK          NaN   \n",
       "5       UNK       NaN  TSUNK0824          NaN           UNK          NaN   \n",
       "6       UNK       NaN  TSUNK0830          NaN           UNK          NaN   \n",
       "7       UNK       NaN  TSUNK0830          NaN           UNK          NaN   \n",
       "8       UNK       NaN  TSUNK0856          NaN           UNK          NaN   \n",
       "9       UNK       NaN  TSUNK0857          NaN           UNK          NaN   \n",
       "10      UNK       NaN  TSUNK0848          NaN           UNK          NaN   \n",
       "11      UNK       NaN  TSUNK0856          NaN           UNK          NaN   \n",
       "12      UNK       NaN  TSUNK0853          NaN           UNK          NaN   \n",
       "13      UNK       NaN  TSUNK0861          NaN           UNK          NaN   \n",
       "14      UNK       NaN  TSUNK0846          NaN           UNK          NaN   \n",
       "15      UNK       NaN  TSUNK0847          NaN           UNK          NaN   \n",
       "16      UNK       NaN  TSUNK0854          NaN           UNK          NaN   \n",
       "17      UNK       NaN  TSUNK0841          NaN           UNK          NaN   \n",
       "18      UNK       NaN  TSUNK0853          NaN           UNK          NaN   \n",
       "19      UNK       NaN  TSUNK0846          NaN           UNK          NaN   \n",
       "20      UNK       NaN  TSUNK0856          NaN           UNK          NaN   \n",
       "21      UNK       NaN  TSUNK0859          NaN           UNK          NaN   \n",
       "22      UNK       NaN  TSUNK0824          NaN           UNK          NaN   \n",
       "23      UNK       NaN  TSUNK0840          NaN           UNK          NaN   \n",
       "24      UNK       NaN  TSUNK0822          NaN           UNK          NaN   \n",
       "25      UNK       NaN  TSUNK0856          NaN           UNK          NaN   \n",
       "26      UNK       NaN  TSUNK0859          NaN           UNK          NaN   \n",
       "27      UNK       NaN  TSUNK0859          NaN           UNK          NaN   \n",
       "28      UNK       NaN  TSUNK0856          NaN           UNK          NaN   \n",
       "29      UNK       NaN  TSUNK0845          NaN           UNK          NaN   \n",
       "30      UNK       NaN  TSUNK0851          NaN           UNK          NaN   \n",
       "31      AMD       NaN  TSAMD0519          NaN           UNK          NaN   \n",
       "32      AMD       NaN  TSAMD0516          NaN           UNK          NaN   \n",
       "33      AMD       NaN  TSAMD0519          NaN           UNK          NaN   \n",
       "34      AMD       NaN  TSAMD0516          NaN           UNK          NaN   \n",
       "35      AMD       NaN  TSAMD0515          NaN           UNK          NaN   \n",
       "36      AMD       NaN  TSAMD0511          NaN           UNK          NaN   \n",
       "\n",
       "    Date_From  Date_To    BIMNAME BIMCODE BLOCKDESC  BLOCKNO  SHAPE_Leng  \\\n",
       "0         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "1         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "2         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "3         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "4         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "5         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "6         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "7         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "8         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "9         NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "10        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "11        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "12        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "13        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "14        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "15        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "16        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "17        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "18        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "19        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "20        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "21        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "22        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "23        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "24        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "25        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "26        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "27        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "28        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "29        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "30        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "31        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "32        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "33        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "34        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "35        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "36        NaN      NaN  Cloncurry    CLON  CLON2040     2040    0.333326   \n",
       "\n",
       "    SHAPE_Area  \n",
       "0     0.006944  \n",
       "1     0.006944  \n",
       "2     0.006944  \n",
       "3     0.006944  \n",
       "4     0.006944  \n",
       "5     0.006944  \n",
       "6     0.006944  \n",
       "7     0.006944  \n",
       "8     0.006944  \n",
       "9     0.006944  \n",
       "10    0.006944  \n",
       "11    0.006944  \n",
       "12    0.006944  \n",
       "13    0.006944  \n",
       "14    0.006944  \n",
       "15    0.006944  \n",
       "16    0.006944  \n",
       "17    0.006944  \n",
       "18    0.006944  \n",
       "19    0.006944  \n",
       "20    0.006944  \n",
       "21    0.006944  \n",
       "22    0.006944  \n",
       "23    0.006944  \n",
       "24    0.006944  \n",
       "25    0.006944  \n",
       "26    0.006944  \n",
       "27    0.006944  \n",
       "28    0.006944  \n",
       "29    0.006944  \n",
       "30    0.006944  \n",
       "31    0.006944  \n",
       "32    0.006944  \n",
       "33    0.006944  \n",
       "34    0.006944  \n",
       "35    0.006944  \n",
       "36    0.006944  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "brwr = pd.read_csv('https://geoscience.data.qld.gov.au/dataset/88e09172-c2a6-4006-93e1-51d022662265/resource/c7d1bd02-1618-4969-811e-febc57c50f6c/download/s_wholerock_bris2038.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Unnamed: 0</th>\n",
       "      <th>Prospect_Code</th>\n",
       "      <th>Company</th>\n",
       "      <th>Sheet_Number</th>\n",
       "      <th>Sample</th>\n",
       "      <th>Data_Type</th>\n",
       "      <th>Hole_ID</th>\n",
       "      <th>From_Depth</th>\n",
       "      <th>To_Depth</th>\n",
       "      <th>Grid_ID</th>\n",
       "      <th>Locality</th>\n",
       "      <th>AMG_N</th>\n",
       "      <th>AMG_E</th>\n",
       "      <th>North</th>\n",
       "      <th>East</th>\n",
       "      <th>RL_Regional</th>\n",
       "      <th>RL_Local</th>\n",
       "      <th>Location_Accuracy</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Country</th>\n",
       "      <th>State</th>\n",
       "      <th>Sampler</th>\n",
       "      <th>Sample_Date</th>\n",
       "      <th>Geological_Unit_Code</th>\n",
       "      <th>Regolith_Landform_Code</th>\n",
       "      <th>Lith1</th>\n",
       "      <th>Desc11</th>\n",
       "      <th>Desc12</th>\n",
       "      <th>Desc13</th>\n",
       "      <th>Desc14</th>\n",
       "      <th>AltQual11</th>\n",
       "      <th>AltQual12</th>\n",
       "      <th>AltQual13</th>\n",
       "      <th>AltType11</th>\n",
       "      <th>AltType12</th>\n",
       "      <th>AltType13</th>\n",
       "      <th>AltInt11</th>\n",
       "      <th>AltInt12</th>\n",
       "      <th>AltInt13</th>\n",
       "      <th>Min_Style11</th>\n",
       "      <th>Min_Style12</th>\n",
       "      <th>Min_Style13</th>\n",
       "      <th>Min_Style14</th>\n",
       "      <th>Min_Amount11</th>\n",
       "      <th>Min_Amount12</th>\n",
       "      <th>Min_Amount13</th>\n",
       "      <th>Min_Amount14</th>\n",
       "      <th>Min_Min11</th>\n",
       "      <th>Min_Min12</th>\n",
       "      <th>Min_Min13</th>\n",
       "      <th>Min_Min14</th>\n",
       "      <th>Lith2</th>\n",
       "      <th>Desc21</th>\n",
       "      <th>Desc22</th>\n",
       "      <th>Desc23</th>\n",
       "      <th>Lith_Desc</th>\n",
       "      <th>Age_No</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Weathering_Code</th>\n",
       "      <th>Length</th>\n",
       "      <th>Width</th>\n",
       "      <th>Strike</th>\n",
       "      <th>Dip</th>\n",
       "      <th>Dip_Quadrant</th>\n",
       "      <th>Dip_Dir_Az</th>\n",
       "      <th>Vegetation</th>\n",
       "      <th>Ph_Ref</th>\n",
       "      <th>Ph_Run</th>\n",
       "      <th>Ph_Num</th>\n",
       "      <th>Min_Occurrence</th>\n",
       "      <th>Comment</th>\n",
       "      <th>SiO2</th>\n",
       "      <th>TiO2</th>\n",
       "      <th>Al2O3</th>\n",
       "      <th>FeOx_Total</th>\n",
       "      <th>Fe2O3</th>\n",
       "      <th>FeO</th>\n",
       "      <th>MnO</th>\n",
       "      <th>MgO</th>\n",
       "      <th>CaO</th>\n",
       "      <th>Na2O</th>\n",
       "      <th>K2O</th>\n",
       "      <th>P2O5</th>\n",
       "      <th>H20_plus</th>\n",
       "      <th>H2O_minus</th>\n",
       "      <th>CO2</th>\n",
       "      <th>LOI</th>\n",
       "      <th>Rest</th>\n",
       "      <th>Total</th>\n",
       "      <th>Job_no</th>\n",
       "      <th>Sample_ID</th>\n",
       "      <th>HasAssayParam</th>\n",
       "      <th>HasLithParam</th>\n",
       "      <th>Duplicate</th>\n",
       "      <th>Associated_Sample_No</th>\n",
       "      <th>Tenement_Type</th>\n",
       "      <th>Tenement</th>\n",
       "      <th>Report_Type</th>\n",
       "      <th>Report</th>\n",
       "      <th>Open_File</th>\n",
       "      <th>TagCharacter</th>\n",
       "      <th>Image_ID</th>\n",
       "      <th>Load_Number</th>\n",
       "      <th>Date_Updated</th>\n",
       "      <th>User_Updating</th>\n",
       "      <th>Update_Status</th>\n",
       "      <th>TS_Release</th>\n",
       "      <th>Spatial_Status</th>\n",
       "      <th>Old_Job</th>\n",
       "      <th>Lab_Code</th>\n",
       "      <th>Job_Date</th>\n",
       "      <th>Alias_Job</th>\n",
       "      <th>Dispatch_No</th>\n",
       "      <th>Location_Code</th>\n",
       "      <th>Description</th>\n",
       "      <th>Date_From</th>\n",
       "      <th>Date_To</th>\n",
       "      <th>geometry</th>\n",
       "      <th>BIMNAME</th>\n",
       "      <th>BIMCODE</th>\n",
       "      <th>BLOCKDESC</th>\n",
       "      <th>BLOCKNO</th>\n",
       "      <th>SHAPE_Leng</th>\n",
       "      <th>SHAPE_Area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>732</td>\n",
       "      <td>CPKY</td>\n",
       "      <td>CAP</td>\n",
       "      <td>9245</td>\n",
       "      <td>K-18</td>\n",
       "      <td>RC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AMG2</td>\n",
       "      <td>170km NW of Brisbane</td>\n",
       "      <td>7082570.0</td>\n",
       "      <td>380700.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>-26.371867</td>\n",
       "      <td>151.804193</td>\n",
       "      <td>AUS</td>\n",
       "      <td>QLD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.77</td>\n",
       "      <td>2.27</td>\n",
       "      <td>25.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ST39773</td>\n",
       "      <td>5000010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPM</td>\n",
       "      <td>14639</td>\n",
       "      <td>CR</td>\n",
       "      <td>39053</td>\n",
       "      <td>Y</td>\n",
       "      <td>M</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4/07/2016 0:00:00</td>\n",
       "      <td>PA</td>\n",
       "      <td>1</td>\n",
       "      <td>MM0007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALS</td>\n",
       "      <td>23/04/2004</td>\n",
       "      <td>MMALS4206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (151.8052631310128 -26.37028038554192)</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>BRIS</td>\n",
       "      <td>BRIS2038</td>\n",
       "      <td>2038</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>0.006944</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0 Prospect_Code Company  Sheet_Number Sample Data_Type  Hole_ID  \\\n",
       "0         732          CPKY     CAP          9245   K-18        RC      NaN   \n",
       "\n",
       "   From_Depth  To_Depth Grid_ID              Locality      AMG_N     AMG_E  \\\n",
       "0         NaN       NaN    AMG2  170km NW of Brisbane  7082570.0  380700.0   \n",
       "\n",
       "   North  East  RL_Regional  RL_Local  Location_Accuracy   Latitude  \\\n",
       "0    NaN   NaN          NaN       NaN                 25 -26.371867   \n",
       "\n",
       "    Longitude Country State  Sampler  Sample_Date  Geological_Unit_Code  \\\n",
       "0  151.804193     AUS   QLD      NaN          NaN                   NaN   \n",
       "\n",
       "   Regolith_Landform_Code  Lith1  Desc11  Desc12  Desc13  Desc14  AltQual11  \\\n",
       "0                     NaN    NaN     NaN     NaN     NaN     NaN        NaN   \n",
       "\n",
       "   AltQual12  AltQual13  AltType11  AltType12  AltType13  AltInt11  AltInt12  \\\n",
       "0        NaN        NaN        NaN        NaN        NaN       NaN       NaN   \n",
       "\n",
       "   AltInt13  Min_Style11  Min_Style12  Min_Style13  Min_Style14  Min_Amount11  \\\n",
       "0       NaN          NaN          NaN          NaN          NaN           NaN   \n",
       "\n",
       "   Min_Amount12  Min_Amount13  Min_Amount14  Min_Min11  Min_Min12  Min_Min13  \\\n",
       "0           NaN           NaN           NaN        NaN        NaN        NaN   \n",
       "\n",
       "   Min_Min14  Lith2  Desc21  Desc22  Desc23  Lith_Desc  Age_No Occurrence  \\\n",
       "0        NaN    NaN     NaN     NaN     NaN        NaN     NaN         SC   \n",
       "\n",
       "   Weathering_Code  Length  Width  Strike  Dip  Dip_Quadrant  Dip_Dir_Az  \\\n",
       "0              NaN     NaN    NaN     NaN  NaN           NaN         NaN   \n",
       "\n",
       "   Vegetation  Ph_Ref  Ph_Run  Ph_Num  Min_Occurrence  Comment   SiO2  TiO2  \\\n",
       "0         NaN     NaN     NaN     NaN             NaN      NaN  41.77  2.27   \n",
       "\n",
       "   Al2O3  FeOx_Total  Fe2O3  FeO  MnO  MgO  CaO  Na2O  K2O  P2O5  H20_plus  \\\n",
       "0   25.6         NaN  18.71  NaN  NaN  NaN  NaN   NaN  NaN   NaN       NaN   \n",
       "\n",
       "   H2O_minus  CO2    LOI  Rest  Total   Job_no  Sample_ID  HasAssayParam  \\\n",
       "0        NaN  NaN  11.11   NaN    NaN  ST39773    5000010            NaN   \n",
       "\n",
       "   HasLithParam  Duplicate  Associated_Sample_No Tenement_Type  Tenement  \\\n",
       "0           NaN        NaN                   NaN           EPM     14639   \n",
       "\n",
       "  Report_Type  Report Open_File TagCharacter  Image_ID  Load_Number  \\\n",
       "0          CR   39053         Y            M       NaN            0   \n",
       "\n",
       "        Date_Updated User_Updating  Update_Status TS_Release  Spatial_Status  \\\n",
       "0  4/07/2016 0:00:00            PA              1     MM0007             NaN   \n",
       "\n",
       "   Old_Job Lab_Code    Job_Date  Alias_Job  Dispatch_No Location_Code  \\\n",
       "0      NaN      ALS  23/04/2004  MMALS4206          NaN           BNE   \n",
       "\n",
       "   Description  Date_From  Date_To  \\\n",
       "0          NaN        NaN      NaN   \n",
       "\n",
       "                                       geometry   BIMNAME BIMCODE BLOCKDESC  \\\n",
       "0  POINT (151.8052631310128 -26.37028038554192)  Brisbane    BRIS  BRIS2038   \n",
       "\n",
       "   BLOCKNO  SHAPE_Leng  SHAPE_Area  \n",
       "0     2038     0.33333    0.006944  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "brwr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:gempy2021]",
   "language": "python",
   "name": "conda-env-gempy2021-py"
  },
  "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}