screeps，市场数据可视化
2022-09-17 本文已影响0人
6g3y
为了知道自己的cr都花在什么地方，赚了多少，亏了多少
将历史的全部数据全部爬下来后进行可视化：
输入:["维度（房间/日期）","资源类型"，"cr变化"]
输出：
第1列：卖出取的东西
第2列：卖出去房间的情况
第3列：买入的房间的情况（红色盈利，蓝色亏损）
第4列：买入取的东西
dff = df
dff["shard_roomName"] = dff["shard"]+"_"+dff["roomName"]
dff["shard_targetRoomName"] = dff["shard"]+"_"+dff["targetRoomName"]
dff["shard_my_roomName"] = np.where(dff["dealer"]!=dff["user"],dff["shard_roomName"],dff["shard_targetRoomName"])
data = np.array(dff[["shard_my_roomName","resourceType","change"]]).tolist()
show(data)
image.png
data = np.array(dff[["day","resourceType","change"]]).tolist()
show(data)
image.png
data = np.array(dff[["shard","resourceType","change"]]).tolist()
show(data)
image.png
dff = df[df["resourceType"]=="energy"]
dff["shard_roomName"] = dff["shard"]+"_"+dff["roomName"]
dff["shard_targetRoomName"] = dff["shard"]+"_"+dff["targetRoomName"]
dff["deal_target"] = np.where(dff["dealer"]!=dff["user"],dff["dealer"],dff["owner"])
dff["deal_target_name"]=dff["deal_target"].map(lambda x:"NPC" if x is None else getUserName(x))
data = np.array(dff[["deal_target_name","shard","change"]]).tolist()
show(data,3*1e6,1.5)
image.png
dff = df[(df["resourceType"]!="energy")&(df["change"]<0)]
dff["shard_roomName"] = dff["shard"]+"_"+dff["roomName"]
dff["shard_targetRoomName"] = dff["shard"]+"_"+dff["targetRoomName"]
dff["deal_target"] = np.where(dff["dealer"]!=dff["user"],dff["dealer"],dff["owner"])
dff["deal_target_name"]=dff["deal_target"].map(lambda x:"NPC" if x is None else getUserName(x))
data = np.array(dff[["deal_target_name","resourceType","change"]]).tolist()
show(data,3*1e6,1.5)
image.png
