完全なるGarbage-in, Garbage-out。。。
python
1
2from ast import literal_eval
3from operator import itemgetter
4
5
6test_txt = (
7 "[{u'faceId': u'8445cf3e-9aea-4d32-9613-c1365ae5de0c', "
8 "u'faceAttributes': {u'gender': u'male', u'age': 22.7}}]"
9)
10data = literal_eval(test_txt)
11
12header = [
13 next(filter(lambda s: "id" in s.lower(), data[0].keys()))[:-1] + "D",
14] + sorted(data[0]["faceAttributes"], reverse=True)
15print(*header, sep=",")
16
17for attr in (itemgetter("faceAttributes")(r) for r in data):
18 row = [
19 next(filter(lambda s: s != "age", attr.keys())),
20 "age",
21 attr["age"],
22 ]
23 print(*row, sep=",")