当作为redis sadd插入时,如何生成pythonDataframe?

wi3ka0sx  于 2021-06-09  发布在  Redis
关注(0)|答案(0)|浏览(230)

原始数据太大,拆分并插入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\u id”:{“0”:“5fd1e923-d145-40cc-bf38-3b1156af5eb6”,“1”:“5fd1e923-d145-40cc-bf38-3b1156af5eb6”,“2”:“5fd1e923-d145-40cc-bf38-3b1156af5eb6”},“连接日期”:{“0”:“2020-01-01 00:14:24”,“1”:“2020-01-01 00:13:13”,“2”:“2020-01-01 00:13:10”},“位置”:{“0”:경기도", "1": "경기도", "2": "경기도"}, "类别“{”0“:4”,1“:4”,2“:4}”,连接“{”0“:0”,1“:0”,2“:0}”,页面“{”0“:1”,1“:0”,2“:0}”,“{”会话id“:{”500“:”2e91d3c4-1656-4f0b-ab99-7a44ee77216d”,“501”:“7306cad5-40fe-404d-9c31-4FFAAC0C61”,“502”:“7306cad5-40fe-404d-9c31-4FFAAC0C61”,“503”:“2E91D356-4f0b-ab99-7a44ee77216d”,“504”:“7306cad5-40fe-404d-9c31-4ffaac0f0c61”},“连接日期”:{“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”},“位置”:{“500”:경기도", "501": "경기도", "502": "경기도", "503": "경기도", "504": "경기도"}, "类别:“{”500“:1”,501“:1”,502“:1”,503“:1”,504“:1}”,连接:“{”500“:0”,501“:0”,502“:0”,503“:0”,504“:0}”,page\ U out:“{”500“:0”,501“:0”,502“:0”,503“:0”,504“:0}”

我想做一个Dataframe

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

如何制作如上所述的Dataframe?
连续添加数据时,是sadd而不是zadd?
请帮帮我。。。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题