Spaces:
Running
Running
File size: 6,709 Bytes
e91ac58 567930d e91ac58 9d06861 e91ac58 9d06861 e91ac58 9d06861 e91ac58 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 |
import json
def validate_and_align_JSON_keys_with_template(data, JSON_dict_structure):
data = validate_JSON(data)
if data is None:
return None
else:
# Make sure that there are no literal list [] objects in the dict
for key, value in data.items():
if value is None:
data[key] = ''
elif isinstance(value, str):
if value.lower() in ['unknown','not provided', 'missing', 'na', 'none', 'n/a', 'null', 'unspecified',
'TBD',
'not provided in the text', 'not found in the text',
'not in the text', 'not provided', 'not found',
'not provided in the ocr', 'not found in the ocr',
'not in the ocr',
'not provided in the ocr text', 'not found in the ocr text',
"not specified in the given text.",
"not specified in the given text",
"not specified in the text.",
"not specified in the text",
"not specified in text.",
"not specified in text",
"not specified in ocr",
"not specified",
'not in the ocr text',
'Not provided in ocr text',
'not provided in ocr text',
'n/a n/a','n/a, n/a',
'n/a, n/a, n/a','n/a n/a, n/a','n/a, n/a n/a','n/a n/a n/a',
'n/a, n/a, n/a, n/a','n/a n/a n/a n/a','n/a n/a, n/a, n/a','n/a, n/a n/a, n/a','n/a, n/a, n/a n/a',
'n/a n/a n/a, n/a','n/a, n/a n/a n/a',
'n/a n/a, n/a n/a',]:
data[key] = ''
elif isinstance(value, list):
# Join the list elements into a single string
data[key] = ', '.join(str(item) for item in value)
### align the keys with the template
# Create a new dictionary with the same order of keys as JSON_dict_structure
ordered_data = {}
# This will catch cases where the LLM JSON case does not match the required JSON key's case
for key in JSON_dict_structure:
truth_key_lower = key.lower()
llm_value = str(data.get(key, ''))
if not llm_value:
llm_value = str(data.get(truth_key_lower, ''))
# Copy the value from data if it exists, else use an empty string
ordered_data[key] = llm_value
return ordered_data
def validate_JSON(data):
if isinstance(data, dict):
return data
else:
if isinstance(data, list):
data = data[0]
try:
json_candidate = json.loads(data) # decoding the JSON data
if isinstance(json_candidate, list):
json_candidate = json_candidate[0]
if isinstance(json_candidate, dict):
data = json_candidate
return data
else:
return None
except:
return None
#### A manual method for pulling a JSON object out of a verbose LLM response.
#### It's messy butr works well enough. Only use if JSONparsing is not available
def extract_json_dict_manual(text):
text = text.strip().replace("\n", "").replace("\\\\", "")
# Find the first opening curly brace
start_index = text.find('{')
# Find the last closing curly brace
end_index = text.rfind('}') + 1
text = text[start_index:end_index]
# Find the first opening curly brace
start_index = text.find('{')
# Find the last closing curly brace
end_index = text.rfind('}') + 1
# Check and remove backslash immediately after the opening curly brace
if text[start_index + 1] == "\\":
text = text[:start_index + 1] + text[start_index + 2:]
# Find the first opening curly brace
start_index = text.find('{')
# Find the last closing curly brace
end_index = text.rfind('}') + 1
# print(text[end_index-2])
if text[end_index-2] == "\\":
text = text[:end_index-2] + text[end_index-1]
else:
text = text
# Find the first opening curly brace
start_index = text.find('{')
# Find the last closing curly brace
end_index = text.rfind('}') + 1
# print(text[end_index-2])
if text[end_index-2] == "\\":
text = text[:end_index-3] + text[end_index-1]
else:
text = text
# Trim whitespace
json_str = text
# Print the JSON string for inspection
# print("Extracted JSON string:", json_str)
# Convert JSON string to Python dictionary
try:
# If necessary, replace newline characters
# json_str = json_str.replace('\n', '\\n')
json_dict = json.loads(json_str)
return json_dict
except Exception as e:
print("Error parsing JSON:", e)
return None
'''
if __name__ == "__main__":
tex = """Extracted JSON string: {"catalogNumber": "MPU395640",
"order": "Monimizeae",
"family": "Monimiaceae",
"scientificName": "Hedycarya parvifolia",
"scientificNameAuthorship": "Perkins & Schltr.",
"genus": "Hedycarya",
"subgenus": null,
"specificEpithet": "parvifolia",
"infraspecificEpithet": null,
"identifiedBy": null,
"recordedBy": "R. Pouteau & J. Munzinger",
"recordNumber": "RP 1",
"verbatimEventDate": "26-2-2013",
"eventDate": "2013-02-26",
"habitat": "Ultramafique Long. 165 ° 52'21 E, Lat. 21 ° 29'19 S, Maquis",
"occurrenceRemarks": "Fruit Arbuste, Ht. 1,5 mètre (s), Fruits verts (immatures) à noirs (matures), Coll. R. Pouteau & J. Munzinger N° RP 1, Dupl. P - MPU, RECOLNAT, Herbier IRD de Nouvelle - Calédonie Poutan 1, Golden Thread, Alt. 818 mètre, Diam. 2 cm, Date 26-2-2013",
"country": "Nouvelle Calédonie",
"stateProvince": null,
"county": null,
"municipality": null,
"locality": "Antenne du plateau de Bouakaine",
"degreeOfEstablishment": "cultivated",
"decimalLatitude": -21.488611,
"decimalLongitude": 165.8725,
"verbatimCoordinates": "Long. 165 ° 52'21 E, Lat. 21 ° 29'19 S",
"minimumElevationInMeters": 818,
"maximumElevationInMeters": 818
\\}"""
new = extract_json_dict(tex)
'''
|