Check if string has date, any format

by

The parse function in dateutils.parser is capable of parsing many date string formats to a datetime object.

If you simply want to know whether a particular string could represent or contain a valid date, you could try the following simple function:

from dateutil.parser import parse

def is_date(string, fuzzy=False):
    """
    Return whether the string can be interpreted as a date.

    :param string: str, string to check for date
    :param fuzzy: bool, ignore unknown tokens in string if True
    """
    try: 
        parse(string, fuzzy=fuzzy)
        return True

    except ValueError:
        return False

Then you have:

>>> is_date("1990-12-1")
True
>>> is_date("2005/3")
True
>>> is_date("Jan 19, 1990")
True
>>> is_date("today is 2019-03-27")
False
>>> is_date("today is 2019-03-27", fuzzy=True)
True
>>> is_date("Monday at 12:01am")
True
>>> is_date("xyz_not_a_date")
False
>>> is_date("yesterday")
False

Custom parsing

parse might recognise some strings as dates which you don’t want to treat as dates. For example:

  • Parsing "12" and "1999" will return a datetime object representing the current date with the day and year substituted for the number in the string

  • "23, 4" and "23 4" will be parsed as datetime.datetime(2023, 4, 16, 0, 0).

  • "Friday" will return the date of the nearest Friday in the future.
  • Similarly "August" corresponds to the current date with the month changed to August.

Also parse is not locale aware, so does not recognise months or days of the week in languages other than English.

Both of these issues can be addressed to some extent by using a custom parserinfo class, which defines how month and day names are recognised:

from dateutil.parser import parserinfo

class CustomParserInfo(parserinfo):

    # three months in Spanish for illustration
    MONTHS = [("Enero", "Enero"), ("Feb", "Febrero"), ("Marzo", "Marzo")]

An instance of this class can then be used with parse:

>>> parse("Enero 1990")
# ValueError: Unknown string format
>>> parse("Enero 1990", parserinfo=CustomParserInfo())
datetime.datetime(1990, 1, 27, 0, 0)

More Related Contents:

  1. Format timedelta to string
  2. How to change the datetime format in Pandas
  3. How to print a date in a regular format?
  4. How to calculate number of days between two given dates
  5. Iterating through a range of dates in Python
  6. How do I get the day of week given a date?
  7. How to subtract a day from a date?
  8. Creating a range of dates in Python
  9. Adding days to a date in Python
  10. Convert Excel style date with pandas
  11. How do I get a value of datetime.today() in Python that is “timezone aware”?
  12. Get month name from number
  13. Extracting date from a string in Python
  14. Find the end of the month of a Pandas DataFrame Series
  15. How to format date string via multiple formats in python
  16. In Python, how do you convert seconds since epoch to a `datetime` object?
  17. Find the closest date to a given date
  18. Generate a list of datetimes between an interval
  19. Splitting timestamp column into separate date and time columns
  20. Extract day of year and Julian day from a string date
  21. Convert numpy.datetime64 to string object in python
  22. Comparing two date strings in Python
  23. Convert date to datetime in Python
  24. Which is the fastest way to extract day, month and year from a given date?
  25. Formatting “yesterday’s” date in python
  26. Convert string into Date type on Python [duplicate]
  27. Clean way to convert quarterly periods to datetime in pandas
  28. How to combine year, month, and day columns to single datetime column?
  29. How do I convert timestamp to datetime.date in pandas dataframe?
  30. Convert dates to pd.to_datetime where month could be either a number or month name

Leave a Comment