import spacy
import re
from datetime import datetime
# Load the spacy model with GloVe embeddings
nlp = spacy.load("en_core_web_lg")
# Define a function to extract dates from text
def extract_dates(text):
"""
Identify dates both in numeric and free-text from text, using date regex patterns and NER tag
"""
# Define regex patterns for common date formats
# Regular expressions that include the \b word boundary character to ensure that the date pattern only matches if it is not part of a longer pattern that has already been matched
date_patterns = [
r'\b\d{1,2}[-/]\d{1,2}[-/]\d{2,4}\b', # Matches dates like "01/01/22" or "1-1-2022"
r'\b\d{1,2}[-/]\d{1,2}\b(?!\d)', # Matches dates like "01/01" or "1-1"
r'\b[A-Z][a-z]{2,8} \d{1,2},? \d{2,4}\b', # Matches dates like "January 1, 2022" or "Feb 28, 22"
r'\b\d{1,2} [A-Z][a-z]{2,8} \d{2,4}\b', # Matches dates like "1 January 2022" or "28 Feb 22"
r'\b[A-Z][a-z]{2,8} \d{2,4}\b', # Matches dates like "January 2022" or "Feb 22"
r'\d{1,2}[/-]\d{4}|\d{2}\s\d{4}'
# Matches dates like (05/2018, 05-2018, 05 2018, 5/2018, 5-2018, 5 2018, 05/18, 05-18, 05 18, 5/18, 5-18, 5 18) etc.
]
# Find all matches for date patterns in the text
matches = []
for pattern in date_patterns:
for match in re.findall(pattern, text):
# Check if the match is part of a longer date pattern that has already been matched
if all(match not in m for m in matches):
matches.append(match)
# Use SpaCy to extract additional dates
doc = nlp(text)
for ent in doc.ents:
if ent.label_ == 'DATE':
date_str = ent.text
# Checks each SpaCy date reference against the matches list to ensure that it is not already included
if all(date_str not in m for m in matches):
matches.append(date_str)
# Remove duplicates and return the matches
return list(set(matches))
def helper_fix_format_date_sf(input_list):
input_str = input_list[0]
# Split the string into separate key-value pairs
pairs = input_str.split(", ")
pairs_dict = {}
# Convert the key-value pairs into a dictionary
for pair in pairs:
key, value = pair.split(":")
pairs_dict[key] = value
# Create a list of dictionaries, ensuring all keys are present
output_list = {"day": pairs_dict.get("day", 0),
"month": pairs_dict.get("month", 0),
"year": pairs_dict.get("year", 0)}
return [{"date":output_list}]
def convert_dates(date_list):
"""
Assign to the identified formatted dates the proper date format and then, on the formatted dates, assign the relevant date tags (e.g. specify which is the day, the month, etc)
"""
DATE_FORMATS = {
'%B %d, %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%-m-%d-%Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m-%d-%y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d/%m': 'day:{dt.day}, month:{dt.month}',
'%B %d': 'day:{dt.day}, month:{dt.month}',
'%b %d': 'day:{dt.day}, month:{dt.month}',
'%B %Y': 'month:{dt.month}, year:{dt.year}',
'%Y': 'year:{dt.year}',
'%d/%m/%y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%B %d, %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%b %d, %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d-%m-%Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d/%m/%Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d-%m-%y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m/%d/%y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m/%d/%Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m-%d-%Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m-%d-%y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d/%m/%Y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%d/%m/%y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%m/%d/%Y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%m/%d/%y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%Y-%m-%d': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%y-%m-%d': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%m-%d-%Y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%m-%d-%y %H:%M:%S': 'day:{dt.day}, month:{dt.month}, year:{dt.year}, time:{dt.strftime("%H:%M:%S")}',
'%m-%d': 'month:{dt.month}, day:{dt.day}',
'%-m-%-d': 'month:{dt.month}, day:{dt.day}',
'%d %b %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d %B %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%b %Y': 'month:{dt.month}, year:{dt.year}',
'%b %d, %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%d %B %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
# 09 05 2018
'%d %m %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
# 05/2018, 05-2018, 05 2018, 5/2018, 5-2018, 5 2018
'%m %Y': 'month:{dt.month}, year:{dt.year}',
'%m/%Y': 'month:{dt.month}, year:{dt.year}',
'%m-%Y': 'month:{dt.month}, year:{dt.year}',
# 05/18, 05-18, 05 18, 5/18, 5-18, 5 18
'%m/%y': 'month:{dt.month}, year:{dt.year}',
'%m-%y': 'month:{dt.month}, year:{dt.year}',
'%m %y': 'month:{dt.month}, year:{dt.year}',
'%-m/%y': 'month:{dt.month}, year:{dt.year}',
'%-m-%y': 'month:{dt.month}, year:{dt.year}',
'%-m %y': 'month:{dt.month}, year:{dt.year}',
# 9th May 2018 etc
'%dth %B %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%dth %b %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%dst %B %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%dst %b %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%dnd %B %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%dnd %b %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%drd %B %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%drd %b %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
# August 9 2018, August 9 18, Jan 1 23, etc.
'%B %d %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%B %d %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%b %d %y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}',
'%b %d %Y': 'day:{dt.day}, month:{dt.month}, year:{dt.year}'
}
output_list = []
for date_str in date_list:
valid_format = False
for fmt, out_fmt in DATE_FORMATS.items():
try:
dt = datetime.strptime(date_str, fmt)
output_list.append(out_fmt.format(dt=dt))
valid_format = True
break
except ValueError:
pass
if not valid_format:
# Attempt to parse using a custom format
try:
if '-' in date_str:
dt = datetime.strptime(date_str, '%m-%d-%y')
else:
dt = datetime.strptime(date_str, '%d/%m/%y')
output_list.append(f'day:{dt.day}, month:{dt.month}, year:{dt.year}')
except ValueError:
output_list.append(f'INVALID FORMAT: {date_str}')
# return output_list
return helper_fix_format_date_sf(output_list)
def dates_binding(text):
'''
This is a function that binds together all the subcomponents of the dates identification, while also controlling for multiple, or zero date references
'''
try:
# capture the referred dates
ident_dates = extract_dates(text)
# since we now cope for formats like '05 2018' and '09 05 2018', our module would capture them as two seperate cases.
# with this line we check if '05 2018' is contained on '09 05 2018', in which case we delete it
identified_dates = [elem for elem in ident_dates if not any(elem in other_elem for other_elem in ident_dates if elem != other_elem)]
# we only accept for one date reference
if len(identified_dates) == 1:
formatted_dates = convert_dates(identified_dates)
# in case there is a wrong date format then return the appropriate code to prompt back the proper message
if 'INVALID FORMAT' in formatted_dates[0]:
return (0,'DATES','wrong_date_format')
else:
return [formatted_dates, identified_dates]
# in case of zero references return the appropriate code (to aid returning the correct prompt)
elif len(identified_dates) == 0:
return (0,'DATES','no_date')
# in case of more than one references return the appropriate code (to aid returning the correct prompt)
elif len(identified_dates) > 1:
return (0,'DATES','more_dates')
# in case of unexpected error return the appropriate code (to aid returning the correct prompt)
else:
return (0,'DATES','unknown_error')
except:
return (0,'DATES','unknown_error')