Python: Format datetime string in a list of dictionaries

Question

I currently have the following where the AllergiesList can be one or more dicts.

{
  "AllergiesList": [
    {
      "Date": "2021-09-03T00:00:00",
      "Description": "string",
      "Source": "string",
      "Severity": "string",
      "Reaction": "string",
      "TypeCode": "string",
      "Notes": "string",
      "Notes1": "string",
      "TenancyDescription": "string"
    }
  ],
  "TotalItemCount": 0
}

My question is how would I format the Date key within all dictionaries to be in a specific format e.g. d/m/Y

I currently have the following to remove dicts that are more than X months old

def is_recent(entry,amount):
    limit_time = pd.Timestamp.today() - relativedelta.relativedelta(months=amount)
    return pd.to_datetime(entry["Date"]) > limit_time

Used as follows:

allergies = session["allergies"] # This is the same as the code snippet above i.e. a list of dictionaries
session["allergies"] = [entry for entry in allergies["AllergiesList"] if is_recent(entry,6)]

Would I need to do another def() or can my current one be amended to do what's needed?

session["allergies"] is a list of dicts like the one you posted? — timgeb
– timgeb, Commented Jun 23, 2022 at 8:15
@I'mahdi because that was the highest upvoted answer given to me previously on another question — pee2pee
– pee2pee, Commented Jun 23, 2022 at 8:16
If you are not otherwise using pandas it's an overkill - just use datetime module — buran
– buran, Commented Jun 23, 2022 at 8:18

Devbrat Shukla · Accepted Answer · 2022-06-24 08:10:24Z

from datetime import datetime

rec_list = {
    "AllergiesList": [
        {
            "Date": "2021-09-03T00:00:00",
            "Description": "string",
            "Source": "string",
            "Severity": "string",
            "Reaction": "string",
            "TypeCode": "string",
            "Notes": "string",
            "Notes1": "string",
            "TenancyDescription": "string"
        },
        {
            "Date": "2021-09-09T00:00:00",
            "Description": "string",
            "Source": "string",
            "Severity": "string",
            "Reaction": "string",
            "TypeCode": "string",
            "Notes": "string",
            "Notes1": "string",
            "TenancyDescription": "string"
        }
    ],
    "TotalItemCount": 0
}

for rec in rec_list["AllergiesList"]:
    rec["Date"] = datetime.strptime(rec["Date"], "%Y-%m-%dT%H:%M:%S").strftime("%d/%m/%Y")

print(rec_list)

Using above code snippet you can convert your all date format records as per your requirment.

Output:-

{
    "AllergiesList": [
        {
            "Date": "03/09/2021",
            "Description": "string",
            "Source": "string",
            "Severity": "string",
            "Reaction": "string",
            "TypeCode": "string",
            "Notes": "string",
            "Notes1": "string",
            "TenancyDescription": "string",
        },
        {
            "Date": "09/09/2021",
            "Description": "string",
            "Source": "string",
            "Severity": "string",
            "Reaction": "string",
            "TypeCode": "string",
            "Notes": "string",
            "Notes1": "string",
            "TenancyDescription": "string",
        },
    ],
    "TotalItemCount": 0,
}

Thanks :)

nilbarde · Accepted Answer · 2022-06-24 07:23:08Z

1

just replace is_recent function with following one

import datetime 

def is_recent(entry, amount):
    limit_time = datetime.datetime.now() - datetime.timedelta(months=amount)
    return datetime.datetime.strptime(entry["Date"], '%Y-%m-%dT%H:%M:%S') > limit_time

answered Jun 24, 2022 at 7:23

nilbarde

4912 silver badges3 bronze badges

Comments

Sidharth Mudgil · Accepted Answer · 2022-06-23 08:48:20Z

0

Try the code below, it will convert the given format to DD/MM/YYYY

from datetime import datetime

date_time_str = entry['Date']
date_time_obj = datetime.strptime(date_time_str, '%Y-%m-%dT%H:%M:%S')
date = date_time_obj.strftime("%d/%m/%Y")
print('Date String:', date)

If you want DD/MM/YY format replace %Y with %y in date_time_obj.strftime("%d/%m/%Y")

answered Jun 23, 2022 at 8:48

Sidharth Mudgil

1,47112 silver badges30 bronze badges

Collectives™ on Stack Overflow

Python: Format datetime string in a list of dictionaries

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related