{ "cells": [ { "cell_type": "code", "execution_count": 172, "metadata": {}, "outputs": [], "source": [ "#the tools we need\n", "import requests\n", "import pandas as pd\n", "import numpy as np\n", "import pysal\n", "\n", "pd.set_option('display.max_columns', None)" ] }, { "cell_type": "code", "execution_count": 155, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[{\"group_ak4kk32/Colour\":\"brown\",\"_notes\":[],\"group_mo76v47/Total_bulk_finds\":\"5\",\"_bamboo_dataset_id\":\"\",\"_tags\":[],\"group_ak4kk32/Soil_Composition_Percentage_Clay\":\"20\",\"group_bu1ca84_row_1/group_bu1ca84_row_1_column\":\"Few\",\"group_ye2st39/Filled_out_by\":\"edward_stewart\",\"group_bu1ca84_row_2/group_bu1ca84_row_2_column_1\":\"No Tufo was found\",\"group_bu1ca84_row_2/group_bu1ca84_row_2_column\":\"None\",\"group_mf1hs18/group_qy7um66/Photo_models\":\"no\",\"group_mf1hs18/Position\":\"all around the trench\",\"_xform_id_string\":\"aFQDtwfYLpWjyYb6Uc5nMp\",\"group_ye2st39/SU_Closed\":\"no\",\"group_sb6os40_currentrelate/group_sb6os40_currentrelate_SU2\":\"99999\",\"group_sb6os40_currentrelate/group_sb6os40_currentrelate_SU1\":\"9999\",\"group_mf1hs18/Formation_Process\":\"accumulation\",\"group_ak4kk32/Soil_Composition_Percentage_Silt\":\"40\",\"group_ak4kk32/Matrix\":\"cohesive\",\"group_mf1hs18/Approximate_date_of_SU\":\"21st C AD\",\"end\":\"2019-06-27T04:06:58.479-04:00\",\"group_qu1tl04/Eastern_limit\":\"excavation_lim\",\"group_mf1hs18/g\n" ] } ], "source": [ "#fetch new SU data from kobotoolbox via the old API. Probably this will change when they finish the new API\n", "url = \"https://kc.kobotoolbox.org/api/v1/data/300075\"\n", "\n", "headers = {\n", " 'content-type': \"multipart/form-data\",\n", " 'Authorization': \"Token 0239eed59b53ae940ca8835302b6ad360c8fc540\",\n", " }\n", "\n", "#querystring = {\"group_mf1hs18/Stratigraphic_Reliability\":\"poor\"}\n", "kobo = requests.get(url, headers=headers)\n", "#response_json = response.json()\n", "#print(response.text)\n", "#print first 4000 characters of response\n", "print(kobo.text[:1000])\n", "#print(response_json)" ] }, { "cell_type": "code", "execution_count": 156, "metadata": {}, "outputs": [], "source": [ "#optional step: back up new data to a local file. \n", "new_file=open(\"C:\\\\temp\\\\kobo.json\",mode=\"w\",encoding=\"utf-8\")\n", "new_file.write(kobo.text)\n", "new_file.close()" ] }, { "cell_type": "code", "execution_count": 173, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Area | \n", "Definition | \n", "Excavation_Year | \n", "Formation_Process | \n", "Publishing_Status | \n", "SU_001 | \n", "SU_Type | \n", "Stratigraphic_Reliability | \n", "__version__ | \n", "_attachments | \n", "_bamboo_dataset_id | \n", "_geolocation | \n", "_id | \n", "_notes | \n", "_status | \n", "_submission_time | \n", "_submitted_by | \n", "_tags | \n", "_uuid | \n", "_validation_status | \n", "_xform_id_string | \n", "end | \n", "formhub/uuid | \n", "group_aa6pz93/Alignment | \n", "group_aa6pz93/Binding_Agent | \n", "group_aa6pz93/Building_Technique | \n", "group_aa6pz93/Dimensions | \n", "group_aa6pz93/Floor_Type | \n", "group_aa6pz93/Foundations | \n", "group_aa6pz93/Structure_Description | \n", "group_aa6pz93/Wall_Facing | \n", "group_aa6pz93/Wall_Finishing | \n", "group_ak4kk32/Colour | \n", "group_ak4kk32/Compaction | \n", "group_ak4kk32/Matrix | \n", "group_ak4kk32/Soil_Composition_Percentage_Clay | \n", "group_ak4kk32/Soil_Composition_Percentage_Sand | \n", "group_ak4kk32/Soil_Composition_Percentage_Silt | \n", "group_bu1ca84_row/group_bu1ca84_row_column | \n", "group_bu1ca84_row/group_bu1ca84_row_column_1 | \n", "group_bu1ca84_row_1/group_bu1ca84_row_1_column | \n", "group_bu1ca84_row_1/group_bu1ca84_row_1_column_1 | \n", "group_bu1ca84_row_2/group_bu1ca84_row_2_column | \n", "group_bu1ca84_row_2/group_bu1ca84_row_2_column_1 | \n", "group_cp91a70/Inclusion_Observations | \n", "group_cp91a70/Interface | \n", "group_cp91a70/Surface | \n", "group_cp91a70/Thickness_Observations | \n", "group_dn7bg68 | \n", "group_ey32a12/Observations | \n", "group_ey32a12/Position_001 | \n", "group_ey32a12/Shape | \n", "group_inclusions | \n", "group_iz3xs59 | \n", "group_lg3yr63/Non_Soil_Sampling | \n", "group_lg3yr63/Sieving | \n", "group_lg3yr63/Soil_Sampling | \n", "group_matrix | \n", "group_mf1hs18/Approximate_date_of_SU | \n", "group_mf1hs18/Area | \n", "group_mf1hs18/Chronological_Period | \n", "group_mf1hs18/Date_of_Layer_observations | \n", "group_mf1hs18/Definition | \n", "group_mf1hs18/End_of_Use_Phase | \n", "group_mf1hs18/Excavation_Year | \n", "group_mf1hs18/Formation_Phase | \n", "group_mf1hs18/Formation_Process | \n", "group_mf1hs18/Layer_distinguished_by | \n", "group_mf1hs18/Loss_phase | \n", "group_mf1hs18/Position | \n", "group_mf1hs18/SU_Type | \n", "group_mf1hs18/Stratigraphic_Reliability | \n", "group_mf1hs18/group_qy7um66/Photo_models | \n", "group_mf1hs18/group_qy7um66/Photos | \n", "group_mo76v47/Finds_Observations | \n", "group_mo76v47/Finds_Storage_Notes | \n", "group_mo76v47/Total_bulk_finds | \n", "group_mo76v47/Total_bulk_finds_weight | \n", "group_mo76v47/group_ht7hf81 | \n", "group_mo76v47/group_jr3of51 | \n", "group_mo76v47/group_lq6ss10 | \n", "group_qu1tl04/Depth_Limit | \n", "group_qu1tl04/Eastern_limit | \n", "group_qu1tl04/Northern_Limit | \n", "group_qu1tl04/Southern_Limit | \n", "group_qu1tl04/Unit_Limit_Notes | \n", "group_qu1tl04/Western_Limit | \n", "group_sb6os40_currentrelate/group_sb6os40_currentrelate_Harris_relationship | \n", "group_sb6os40_currentrelate/group_sb6os40_currentrelate_SU1 | \n", "group_sb6os40_currentrelate/group_sb6os40_currentrelate_SU2 | \n", "group_xg9ph94 | \n", "group_ye2st39/Date_of_Finds_Study | \n", "group_ye2st39/Edited_by | \n", "group_ye2st39/Edited_on | \n", "group_ye2st39/Filled_out_by | \n", "group_ye2st39/Filled_out_on | \n", "group_ye2st39/Finds_Studied_by | \n", "group_ye2st39/SU_Closed | \n", "group_yp0fv41/Cut_bottom | \n", "group_yp0fv41/Cut_bottom_edge | \n", "group_yp0fv41/Cut_edges | \n", "group_yp0fv41/Cut_observations | \n", "group_yp0fv41/Cut_sides | \n", "group_yp0fv41/Cut_top_edge | \n", "meta/deprecatedID | \n", "meta/instanceID | \n", "start | \n", "today | \n", "username | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "area_i | \n", "A test SU for the purpose of this form's creat... | \n", "2019.0 | \n", "intentional_de | \n", "beta | \n", "9999 | \n", "anthropogenic | \n", "good | \n", "vASoWNKpGrMiWMYtnspLZ9 | \n", "[] | \n", "\n", " | [None, None] | \n", "30823853 | \n", "[] | \n", "submitted_via_web | \n", "2019-06-23 19:29:45 | \n", "NaN | \n", "[] | \n", "4f0fd312-ecc5-49a5-93a2-fe3a668d3c97 | \n", "{'by_whom': 'eddiecharlesstewart', 'timestamp'... | \n", "aFQDtwfYLpWjyYb6Uc5nMp | \n", "2019-06-27T04:06:58.479-04:00 | \n", "43a407dc130741098c714bd8b8620040 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "brown | \n", "friable | \n", "cohesive | \n", "20.0 | \n", "40.0 | \n", "40.0 | \n", "Many | \n", "many fragments of terra Sigilata were uncovere... | \n", "Few | \n", "A few tile fragments were uncovered | \n", "None | \n", "No Tufo was found | \n", "NaN | \n", "commingled | \n", "grassy | \n", "NaN | \n", "NaN | \n", "it is grassy, excavated with steel toe capped ... | \n", "NaN | \n", "NaN | \n", "[{'group_inclusions/inclusionsfreqency': 'medi... | \n", "NaN | \n", "no | \n", "no | \n", "no | \n", "[{'group_matrix/harrisrelationship': 'covers',... | \n", "21st C AD | \n", "area_i | \n", "modern | \n", "The grass is probably not that old | \n", "Grass | \n", "NaN | \n", "2019.0 | \n", "NaN | \n", "accumulation | \n", "colour composition | \n", "NaN | \n", "all around the trench | \n", "natural | \n", "poor | \n", "no | \n", "no | \n", "Lots of change was found here | \n", "It is now in my pocket | \n", "5.0 | \n", "5.0 | \n", "[{'group_mo76v47/group_ht7hf81/Details': '5x 1... | \n", "[{'group_mo76v47/group_jr3of51/Spot_Dates': '2... | \n", "[{'group_mo76v47/group_lq6ss10/Bases': '1', 'g... | \n", "original | \n", "excavation_lim | \n", "excavation_lim | \n", "excavation_lim | \n", "NaN | \n", "excavation_lim | \n", "covers | \n", "9999.0 | \n", "99999.0 | \n", "[{'group_xg9ph94/Interpretations': 'This SU is... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "edward_stewart | \n", "2019-06-27 | \n", "NaN | \n", "no | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "uuid:3214a397-fc61-4eb7-b9c0-e33931ed6995 | \n", "uuid:4f0fd312-ecc5-49a5-93a2-fe3a668d3c97 | \n", "2019-06-23T20:24:52.369+01:00 | \n", "NaN | \n", "NaN | \n", "
1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "9999 | \n", "NaN | \n", "NaN | \n", "vT5AVpWUbRN4hXkW6KpKek | \n", "[] | \n", "\n", " | [None, None] | \n", "31149181 | \n", "[] | \n", "submitted_via_web | \n", "2019-06-27 08:23:34 | \n", "NaN | \n", "[] | \n", "37aae4fb-30e8-4adb-baff-c4b732fd8d5f | \n", "{'by_whom': 'eddiecharlesstewart', 'timestamp'... | \n", "aFQDtwfYLpWjyYb6Uc5nMp | \n", "2019-06-27T03:53:46.686-04:00 | \n", "43a407dc130741098c714bd8b8620040 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{'group_mo76v47/group_jr3of51/Spot_Dates': '2... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "uuid:37aae4fb-30e8-4adb-baff-c4b732fd8d5f | \n", "2019-06-27T03:52:51.969-04:00 | \n", "NaN | \n", "NaN | \n", "
2 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "beta | \n", "9998 | \n", "NaN | \n", "NaN | \n", "vjuQCNvQx2tVSXENUzPoHx | \n", "[] | \n", "\n", " | [None, None] | \n", "31152598 | \n", "[] | \n", "submitted_via_web | \n", "2019-06-27 09:13:16 | \n", "NaN | \n", "[] | \n", "c77bcd48-d876-4b17-b33e-7f1f9947192b | \n", "{'by_whom': 'eddiecharlesstewart', 'timestamp'... | \n", "aFQDtwfYLpWjyYb6Uc5nMp | \n", "2019-06-27T05:32:53.854-04:00 | \n", "43a407dc130741098c714bd8b8620040 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "grey | \n", "friable | \n", "cohesive | \n", "50.0 | \n", "30.0 | \n", "20.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "lots of broken house things | \n", "sharp | \n", "lumpy | \n", "quite hefty | \n", "[{'group_dn7bg68/Insert_link_to_connected_form... | \n", "Excavated with a toothpick | \n", "centre of house structure | \n", "round in plan | \n", "[{'group_inclusions/inclusionsfreqency': 'freq... | \n", "NaN | \n", "yes | \n", "yes | \n", "yes | \n", "[{'group_matrix/harrisrelationship': 'abuts', ... | \n", "2019 | \n", "area_i | \n", "julio_claudian | \n", "02/12/1997 | \n", "A large deposit of rubble | \n", "phase_a_3 | \n", "2019.0 | \n", "phase_a_1 | \n", "collapse | \n", "compaction composition | \n", "phase_a_4a | \n", "in centre of house structure | \n", "anthropogenic | \n", "fair | \n", "yes | \n", "yes | \n", "lots of broken house stuff | \n", "stored in a garden shed in michigan | \n", "27.0 | \n", "348.0 | \n", "[{'group_mo76v47/group_ht7hf81/Details': 'arch... | \n", "NaN | \n", "[{'group_mo76v47/group_lq6ss10/Maximum_Size_in... | \n", "original | \n", "original | \n", "original | \n", "original | \n", "SU is cut to the west by a quarrying cut | \n", "not_original | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{'group_xg9ph94/Interpretations': 'A layer fo... | \n", "2019-06-19 | \n", "abe_thompson | \n", "2019-06-26 | \n", "abigail_trowbr | \n", "2019-06-03 | \n", "aida_ali | \n", "yes | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "uuid:5bbece0f-a5f5-4998-8ef2-31ec22e99117 | \n", "uuid:c77bcd48-d876-4b17-b33e-7f1f9947192b | \n", "2019-06-27T04:57:19.848-04:00 | \n", "NaN | \n", "NaN | \n", "
3 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "beta | \n", "1314 | \n", "NaN | \n", "NaN | \n", "vjuQCNvQx2tVSXENUzPoHx | \n", "[] | \n", "\n", " | [None, None] | \n", "31154436 | \n", "[] | \n", "submitted_via_web | \n", "2019-06-27 09:52:48 | \n", "NaN | \n", "[] | \n", "56908e9d-bc9f-47f0-989a-d98de51813d0 | \n", "{'by_whom': 'eddiecharlesstewart', 'timestamp'... | \n", "aFQDtwfYLpWjyYb6Uc5nMp | \n", "2019-06-27T05:50:50.334-04:00 | \n", "43a407dc130741098c714bd8b8620040 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "sharp | \n", "NaN | \n", "NaN | \n", "NaN | \n", "There was a strong gale and heavy rain during ... | \n", "Near the large well shaft | \n", "elephant shaped cut | \n", "NaN | \n", "NaN | \n", "no | \n", "no | \n", "no | \n", "[{'group_matrix/harrisrelationship': 'cuts', '... | \n", "1066AD | \n", "area_i | \n", "medieval_perio | \n", "This date is based off of the finding of a spo... | \n", "A spoliation cut | \n", "phase_a_3 | \n", "2018.0 | \n", "phase_a_1 | \n", "cutting | \n", "compaction composition | \n", "phase_a_4c | \n", "Next to a wall in the west of area I | \n", "anthropogenic | \n", "poor | \n", "no | \n", "yes | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{'group_mo76v47/group_jr3of51/Spot_Dates': 'c... | \n", "NaN | \n", "original | \n", "original | \n", "original | \n", "original | \n", "NaN | \n", "original | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{'group_xg9ph94/Interpretations': 'It is a la... | \n", "2019-06-17 | \n", "abigail_trowbr | \n", "2019-06-17 | \n", "david_yelsey | \n", "2019-06-25 | \n", "evelyn_adkins | \n", "no | \n", "concave | \n", "sharp | \n", "rounded | \n", "NaN | \n", "concave | \n", "sharp | \n", "NaN | \n", "uuid:56908e9d-bc9f-47f0-989a-d98de51813d0 | \n", "2019-06-27T05:33:50.763-04:00 | \n", "NaN | \n", "NaN | \n", "
4 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "9999 | \n", "NaN | \n", "NaN | \n", "vPzHY9gqVnLowgERod6kw8 | \n", "[{'mimetype': 'image/jpeg', 'download_url': 'h... | \n", "\n", " | [None, None] | \n", "31482851 | \n", "[] | \n", "submitted_via_web | \n", "2019-07-01 14:09:57 | \n", "NaN | \n", "[] | \n", "b67f09c8-ecaa-42a9-a06b-3ebfb780f760 | \n", "{'by_whom': 'eddiecharlesstewart', 'timestamp'... | \n", "aFQDtwfYLpWjyYb6Uc5nMp | \n", "2019-07-01T15:09:48.963+01:00 | \n", "43a407dc130741098c714bd8b8620040 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{'group_iz3xs59/Insert_a_photo': 'DSC_1141-15... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "uuid:b67f09c8-ecaa-42a9-a06b-3ebfb780f760 | \n", "2019-07-01T15:02:30.493+01:00 | \n", "2019-07-01 | \n", "username not found | \n", "
\n", " | SU_001 | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "9999 | \n", "area_i | \n", "A test SU for the purpose of this form's creat... | \n", "beta | \n", "
1 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "9998 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
3 | \n", "1314 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
4 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 | \n", "7800 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
6 | \n", "9987 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
7 | \n", "7234 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "published | \n", "
\n", " | ID | \n", "EXCAV_AREA | \n", "DEFINITION | \n", "PUB_STATUS | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "A | \n", "NaN | \n", "Published | \n", "
1 | \n", "1 | \n", "A | \n", "Bedrock identified in 2009 | \n", "Beta | \n", "
2 | \n", "3 | \n", "A | \n", "Fill of cut SU4 | \n", "Beta | \n", "
3 | \n", "4 | \n", "A | \n", "Rectangular cut in bedrock | \n", "Beta | \n", "
4 | \n", "5 | \n", "A | \n", "Layer of brown, silty clay | \n", "Beta | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "9999 | \n", "area_i | \n", "A test SU for the purpose of this form's creat... | \n", "beta | \n", "
1 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "9998 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
3 | \n", "1314 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
4 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "A | \n", "NaN | \n", "Published | \n", "
1 | \n", "1 | \n", "A | \n", "Bedrock identified in 2009 | \n", "Beta | \n", "
2 | \n", "3 | \n", "A | \n", "Fill of cut SU4 | \n", "Beta | \n", "
3 | \n", "4 | \n", "A | \n", "Rectangular cut in bedrock | \n", "Beta | \n", "
4 | \n", "5 | \n", "A | \n", "Layer of brown, silty clay | \n", "Beta | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "9999 | \n", "area_i | \n", "A test SU for the purpose of this form's creat... | \n", "beta | \n", "
1 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "9998 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
3 | \n", "1314 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
4 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 | \n", "7800 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
6 | \n", "9987 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
7 | \n", "7234 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "published | \n", "
0 | \n", "0 | \n", "A | \n", "NaN | \n", "Published | \n", "
1 | \n", "1 | \n", "A | \n", "Bedrock identified in 2009 | \n", "Beta | \n", "
2 | \n", "3 | \n", "A | \n", "Fill of cut SU4 | \n", "Beta | \n", "
3 | \n", "4 | \n", "A | \n", "Rectangular cut in bedrock | \n", "Beta | \n", "
4 | \n", "5 | \n", "A | \n", "Layer of brown, silty clay | \n", "Beta | \n", "
5 | \n", "6 | \n", "A | \n", "Cut in bedrock | \n", "Beta | \n", "
6 | \n", "7 | \n", "A | \n", "Layer of rocks mixed with brown clay | \n", "Beta | \n", "
7 | \n", "8 | \n", "A | \n", "Cluster of mortar on Northwest side of cut | \n", "Beta | \n", "
8 | \n", "9 | \n", "A | \n", "Cluster of mortar in SE side of SU4 | \n", "Beta | \n", "
9 | \n", "10 | \n", "A | \n", "Cluster of roof tiles in SW corner of SU4 | \n", "Beta | \n", "
10 | \n", "11 | \n", "A | \n", "Layer of brown sandy clay | \n", "Published | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
8 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "published | \n", "
0 | \n", "0 | \n", "A | \n", "NaN | \n", "Published | \n", "
10 | \n", "11 | \n", "A | \n", "Layer of brown sandy clay | \n", "Published | \n", "
360 | \n", "363 | \n", "A | \n", "N-S wall | \n", "Published | \n", "
457 | \n", "462 | \n", "A | \n", "Oval cut filled by SU451 | \n", "Published | \n", "
617 | \n", "999 | \n", "D | \n", "Beater SU. This SU is a test | \n", "Published | \n", "
634 | \n", "1016 | \n", "B | \n", "Post-abandonment colluvial layer | \n", "Published | \n", "
676 | \n", "1058 | \n", "B | \n", "Wall running N-S in western part of area B - s... | \n", "Published | \n", "
742 | \n", "1124 | \n", "B | \n", "upper fill of cappucina tomb Lordy Gaga | \n", "Published | \n", "
753 | \n", "1135 | \n", "B | \n", "rubble wall - perpendicular to 1058 - west to ... | \n", "Published | \n", "
774 | \n", "1156 | \n", "B | \n", "rubble layer | \n", "Published | \n", "
776 | \n", "1158 | \n", "B | \n", "surface inside 'room' at S edge of excavation ... | \n", "Published | \n", "
780 | \n", "1162 | \n", "B | \n", "perpendicular continuation of rubble wall 1135 | \n", "Published | \n", "
781 | \n", "1163 | \n", "B | \n", "rubble wall continuation of 1135 | \n", "Published | \n", "
783 | \n", "1165 | \n", "B | \n", "yellowish, silty soil south | \n", "Published | \n", "
786 | \n", "1168 | \n", "B | \n", "layer containing soil and gravel | \n", "Published | \n", "
787 | \n", "1169 | \n", "B | \n", "yellowish layer north of wall 1135 | \n", "Published | \n", "
788 | \n", "1170 | \n", "B | \n", "ditch for rubble wall 1135 | \n", "Published | \n", "
789 | \n", "1171 | \n", "B | \n", "cut for trench built wall 1163 | \n", "Published | \n", "
791 | \n", "1173 | \n", "B | \n", "Crushed tufo floor | \n", "Published | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "9999 | \n", "I | \n", "A test SU for the purpose of this form's creat... | \n", "beta | \n", "
1 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "9998 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
3 | \n", "1314 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
4 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
5 | \n", "7800 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
6 | \n", "9987 | \n", "NaN | \n", "NaN | \n", "beta | \n", "
7 | \n", "7234 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8 | \n", "9999 | \n", "NaN | \n", "NaN | \n", "Published | \n", "
0 | \n", "0 | \n", "A | \n", "NaN | \n", "Published | \n", "
1 | \n", "1 | \n", "A | \n", "Bedrock identified in 2009 | \n", "Beta | \n", "
2 | \n", "3 | \n", "A | \n", "Fill of cut SU4 | \n", "Beta | \n", "
3 | \n", "4 | \n", "A | \n", "Rectangular cut in bedrock | \n", "Beta | \n", "
4 | \n", "5 | \n", "A | \n", "Layer of brown, silty clay | \n", "Beta | \n", "
5 | \n", "6 | \n", "A | \n", "Cut in bedrock | \n", "Beta | \n", "
6 | \n", "7 | \n", "A | \n", "Layer of rocks mixed with brown clay | \n", "Beta | \n", "
7 | \n", "8 | \n", "A | \n", "Cluster of mortar on Northwest side of cut | \n", "Beta | \n", "
8 | \n", "9 | \n", "A | \n", "Cluster of mortar in SE side of SU4 | \n", "Beta | \n", "
9 | \n", "10 | \n", "A | \n", "Cluster of roof tiles in SW corner of SU4 | \n", "Beta | \n", "
10 | \n", "11 | \n", "A | \n", "Layer of brown sandy clay | \n", "Published | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "A | \n", "nan | \n", "Published | \n", "
1 | \n", "1 | \n", "A | \n", "Bedrock identified in 2009 | \n", "Beta | \n", "
2 | \n", "3 | \n", "A | \n", "Fill of cut SU4 | \n", "Beta | \n", "
3 | \n", "4 | \n", "A | \n", "Rectangular cut in bedrock | \n", "Beta | \n", "
4 | \n", "5 | \n", "A | \n", "Layer of brown, silty clay | \n", "Beta | \n", "
\n", " | SU | \n", "Area | \n", "Definition | \n", "Publishing_Status | \n", "
---|---|---|---|---|
4581 | \n", "9999 | \n", "I;;nan;;nan;;nan;;H | \n", "A test SU for the purpose of this form's creat... | \n", "beta;;nan;;nan;;Published;;Beta | \n", "