Explore Courses Blog Tutorials Interview Questions
0 votes
in Data Science by (17.6k points)

I have a JSON date data set and trying to calculate the time difference between two different JSON DateTime.

For example :

'2015-01-28T21:41:38.508275' - '2015-01-28T21:41:34.921589'

Please look at the python code below:

#let's say 'time' is my data frame and JSON formatted time values are under the 'due_date' column

time_spent = time.iloc[2]['due_date'] - time.iloc[10]['due_date']

This doesn't work. I also tried to cast each operand to int, but it also didn't help. What are the different ways to perform this calculation?

1 Answer

0 votes
by (41.4k points)

Use parser from dateutil.


from dateutil.parser import parse

first_date_obj = parse("2015-01-28T21:41:38.508275")

second_date_obj = parse("2015-02-28T21:41:38.508275")

print(second_date_obj - first_date_obj)

Related questions

0 votes
1 answer
asked Jul 19, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 10, 2020 in Python by laddulakshana (16.4k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.4k questions

32.5k answers


108k users

Browse Categories