原始数据太大,拆分并插入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?
请帮帮我。。。
暂无答案!
目前还没有任何答案,快来回答吧!