当作为redis sadd插入时，如何生成Python数据帧？

Question

原始数据太大，已拆分并插入Redis sadd

我的目的是将插入的数据打印到DataFrame中

我插入它如下

r = redis.StrictRedis(host='localhost', port=6379, db=0,decode_responses=True)
t1_dic = t1.to_dict()
t1_set = json.dumps(t1_dic,ensure_ascii = False).encode('utf-8')
r.sadd('test_v3',*[t1_set])

t2_dic = t2.to_dict()
t2_set = json.dumps(t2_dic,ensure_ascii = False).encode('utf-8')
r.sadd('test_v3', *[t2_set])

获取

r.smembers('test_v3')

{'{"session_id": {"0": "5fd1e923-d145-40cc-bf38-3b1156af5eb6", "1": "5fd1e923-d145-40cc-bf38-3b1156af5eb6", "2": "5fd1e923-d145-40cc-bf38-3b1156af5eb6"}, "connect_date": {"0": "2020-01-01 00:14:24", "1": "2020-01-01 00:13:13", "2": "2020-01-01 00:13:10"}, "location": {"0": "경기도", "1": "경기도", "2": "경기도"}, "categories": {"0": 4, "1": 4, "2": 4}, "join": {"0": 0, "1": 0, "2": 0}, "page_out": {"0": 1, "1": 0, "2": 0}}', '{"session_id": {"500": "2e91d3c4-1656-4f0b-ab99-7a44ee77216d", "501": "7306cad5-40fe-404d-9c31-4ffaac0f0c61", "502": "7306cad5-40fe-404d-9c31-4ffaac0f0c61", "503": "2e91d3c4-1656-4f0b-ab99-7a44ee77216d", "504": "7306cad5-40fe-404d-9c31-4ffaac0f0c61"}, "connect_date": {"500": "2019-12-31 21:19:29", "501": "2019-12-31 21:19:29", "502": "2019-12-31 21:19:29", "503": "2019-12-31 21:19:29", "504": "2019-12-31 21:19:26"}, "location": {"500": "경기도", "501": "경기도", "502": "경기도", "503": "경기도", "504": "경기도"}, "categories": {"500": 1, "501": 1, "502": 1, "503": 1, "504": 1}, "join": {"500": 0, "501": 0, "502": 0, "503": 0, "504": 0}, "page_out": {"500": 0, "501": 0, "502": 0, "503": 0, "504": 0}}'}

我想制作一个数据帧

1.试试看

pd.DataFrame(get)

                                                  0 
 0    {"session_id": {"0": "5fd1e923-d145-40cc-bf38-... 
 1    {"session_id": {"500": "2e91d3c4-1656-4f0b-ab9...

2.我想要结果

      session_id    connect_date    location    categories  join    page_out
0   5fd1e923-d145-40cc-bf38-3b1156af5eb6    2020-01-01 00:14:24 경기도 4   0   1
1   5fd1e923-d145-40cc-bf38-3b1156af5eb6    2020-01-01 00:13:13 경기도 4   0   0
2   5fd1e923-d145-40cc-bf38-3b1156af5eb6    2020-01-01 00:13:10 경기도 4   0   0
500 2e91d3c4-1656-4f0b-ab99-7a44ee77216d    2019-12-31 21:19:29 경기도 1   0   0
501 7306cad5-40fe-404d-9c31-4ffaac0f0c61    2019-12-31 21:19:29 경기도 1   0   0
502 7306cad5-40fe-404d-9c31-4ffaac0f0c61    2019-12-31 21:19:29 경기도 1   0   0
503 2e91d3c4-1656-4f0b-ab99-7a44ee77216d    2019-12-31 21:19:29 경기도 1   0   0
504 7306cad5-40fe-404d-9c31-4ffaac0f0c61    2019-12-31 21:19:26 경기도 1   0   0

制作上述数据帧的方法是什么

连续添加数据时，是sadd而不是zadd

请帮帮我