>>> properties_dict = {}
>>> for i, row in enumerate(csv.reader(open("Workbook1.csv", "r"))):
...     if i == 0:
...         continue
...     props = row[17].replace("'", '"')
...     properties_dict[i] = json.loads(props)
...
>>> for k, v in properties_dict.items():
...     print(v["gender"])
...
Male
Female
Male
Male
Male
Male