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]