screeps，市场数据可视化

为了知道自己的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