In [57]:
import json
import datetime
import dateutil.parser
def formatTime(isotime):
return dateutil.parser.parse(isotime).yourdate.strftime("%Y-%m-%d %H:%M:%S")
# test data
data = json.load(open('test.json'))['rows']
filteredData = []
for row in data:
if 'timestamp' in row:
filteredData.append(row)
times = [dateutil.parser.parse(row['timestamp']) for row in filteredData]