我有下面的json数据
col = {"00:00:00:00": {"NAME":"aaa","ID":"111","DEPT":"8888","JOIN":"666","DL":333,"SNAME":"John","UPLOAD":"600","RETRY":"3","IP":"111.222.333.444"},
"11:11:11:11:11": {"NAME":"bbb","ID":"222","DEPT":"9999","JOIN":"777","DL":222,"SNAME":"Mary","UPLOAD":"200","RETRY":"2","IP":"122.133.144.155"},
"22:22:22:22": {"NAME":"ccc","ID":"333","DEPT":"6666","JOIN":"111","DL":333,"SNAME":"Stuart","UPLOAD":"500","RETRY":"4","IP":"199.188.177.166"}}
如何使用 ZIP 并在 web2py 中放入行和列列表？ 我尝试使用
rows = zip(*col[c] for c in columns)
但我没有得到正确的输出。 列应该是
columns = ["NAME", "ID", "DEPT", "JOIN", "DL", "SNAME", "UPLOAD", "RETRY", "IP"]
行是json中的关联值。
我希望有以下格式的表格
NAME, ID, DEPT, JOIN, DL, SNAME, UPLOAD, RETRY, IP
aaa 111 888 666 333 John 600 3 111.222.333.444
....类似地，与键关联的所有其他值。
请您参考如下方法:
你可能是这个意思？
columns = col.values()[0].keys()
zip(columns, zip(*(v.values() for v in col.values())))
其中 col 引用您的字典，columns 是根据嵌套字典中的一个键生成的列表。
从嵌套字典中生成列很重要，否则您将无法以相同的顺序获取键和值。
演示:
>>> col = {"00:00:00:00":{"NAME":"aaa","ID":"111","DEPT":"8888","JOIN":"666","DL":333,"SNAME":"John","ULOAD":"600","RETRY":"3","IP":"111.222.333.444"},
... "11:11:11:11:11":{"NAME":"bbb","ID":"222","DEPT":"9999","JOIN":"777","DL":222,"SNAME":"Mary","UPLOAD":"200","RETRY":"2","IP":"122.133.144.155"},
... "22:22:22:22":{"NAME":"ccc","ID":"333","DEPT":"6666","JOIN":"111","DL":333,"SNAME":"Stuart","UPLOAD":"500","RETRY":"4","IP":"199.188.177.166"}}
>>> columns = col.values()[0].keys()
>>> zip(columns, zip(*(v.values() for v in col.values())))
[('DEPT', ('9999', '8888', '6666')), ('DL', (222, 333, 333)), ('SNAME', ('Mary', 'John', 'Stuart')), ('JOIN', ('777', '666', '111')), ('NAME', ('bbb', 'aaa', 'ccc')), ('IP', ('122.133.144.155', '600', '199.188.177.166')), ('RETRY', ('2', '111.222.333.444', '4')), ('ID', ('222', '3', '333')), ('UPLOAD', ('200', '111', '500'))]
>>> pprint(zip(columns, zip(*(v.values() for v in col.values()))))
[('DEPT', ('9999', '8888', '6666')),
('DL', (222, 333, 333)),
('SNAME', ('Mary', 'John', 'Stuart')),
('JOIN', ('777', '666', '111')),
('NAME', ('bbb', 'aaa', 'ccc')),
('IP', ('122.133.144.155', '600', '199.188.177.166')),
('RETRY', ('2', '111.222.333.444', '4')),
('ID', ('222', '3', '333')),
('UPLOAD', ('200', '111', '500'))]
