How to deserialize the datetime in a json object in python?

Question

My original dictionary is

A = {                                                                                                  
    'date': datetime.date(2013, 1, 1),
    'price': 100
}

Since datetime.date is not serializable, I add a default function to deal with that:

B = json.dumps(A, default=lambda obj:obj.isoformat() if hasattr(obj, 'isoformat') else obj)

My question is, how can I deserialize the 'date' field while I use json.loads to convert it back to the original dictionary?

root · Accepted Answer · 2013-02-21 06:46:49Z

11

from datetime import datetime

def load_with_datetime(pairs, format='%Y-%m-%d'):
    """Load with dates"""
    d = {}
    for k, v in pairs:
        if isinstance(v, basestring):
            try:
                d[k] = datetime.strptime(v, format).date()
            except ValueError:
                d[k] = v
        else:
            d[k] = v             
    return d

dump = json.dumps(A, default = f)
json.loads(dump, object_pairs_hook=load_with_datetime)

# {u'date': datetime.date(2013, 1, 1), u'price': 100}

edited Feb 21, 2013 at 6:46

answered Feb 21, 2013 at 6:37

root

81.1k25 gold badges111 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonathan Vanasco Over a year ago

as a personal preference, i check for a regex instead of the try/except block. but i have object_pairs_hooks that handle multiple formats and require that.

root Over a year ago

@JonathanVanasco -- Yup, if you have multiple formats, then using a regex could be an alternative, also I would look at the dateutil parser...

Chunliang Lyu · Accepted Answer · 2013-02-21 06:30:08Z

3

continue to your example code,

C = json.loads(B)
C['date'] = datetime.datetime.strptime(C['date'], '%Y-%m-%d')
print C
# {u'date': datetime.datetime(2013, 1, 1, 0, 0), u'price': 100}

answered Feb 21, 2013 at 6:30

Chunliang Lyu

1,7701 gold badge20 silver badges35 bronze badges

2 Comments

waitingkuo Over a year ago

Is it possible to convert it when doing the json.loads command? I have not only one date information. Thanks!

Chunliang Lyu Over a year ago

you may refer to @root's answer, or a more complete solution here

vaibhav1312 · Accepted Answer · 2013-02-21 06:39:48Z

0

Use pickle module

    import pickle
    fileop = open("timeformat.txt","wb")
    pickle.dump(A,fileop)
    fileop.close()
    print pickle.load(open("timeformat.txt","rb"))
    print A['Date']


    >>>{'date': datetime.date(2013, 1, 1), 'price': 100}
    >>>2013-01-01

edited Feb 21, 2013 at 6:39

answered Feb 21, 2013 at 6:28

vaibhav1312

8935 gold badges13 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to deserialize the datetime in a json object in python?

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related