python中多列表的Json处理

Question

我从数据库中获取列表中的多个数据并将其附加到另一个列表中，所以我的数据看起来是这样的

data= [["a","b","c"],["1","2","3"]]

如果我尝试Json转储并加载此数据，则在加载端会出现错误

data2 = str.encode(json.dumps(data))
st = bytes.decode(data2)
msg = json.loads(st)

raise JSONDecodeError("Expecting value", s,err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

但这不会发生在只有一张单子的地方

Answer 1

我不确定您试图通过所有str/字节编码/解码实现什么，但这非常简单

import json

data = [["a", "b", "c"], ["1", "2", "3"]]
json_str = json.dumps(data)
print(json_str)
# '[["a", "b", "c"], ["1", "2", "3"]]' <- a string
python_list = json.loads(json_str)
print(python_list)
# [['a', 'b', 'c'], ['1', '2', '3']] <- back to Python list

Answer 2

您想要像这样的json:{“数据”：[[“a”、“b”、“c”]、[“1”、“2”、“3”]}

对于此输出，这是代码

data= [["a","b","c"],["1","2","3"]]
import json
data_dict = {'data':data}
data2 = json.dumps(data_dict)
print(data2)

Answer 3

下面是一个Json转储和加载数据的解决方案

import json
data= [["a","b","c"],["1","2","3"]]

# print(data)

data2 = json.dumps(data)
print(data2)
msg = json.loads(data2)
print(msg)