我有一个白天在应用程序中包含错误的数据帧:
date code server type
2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
2017-06-20 ADFC-64002 nexteesadf_server1 WARNING
2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
2017-06-20 ADFC-64002 nexteesadf_server1 WARNING
2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
现在,我想将每天发生的每个错误的次数绘制为折线图。因此,在一段时间内,将有1条线路用于ADFC-64001,1条线路用于ADFC-64002,依此类推。
做这件事最好的方法是什么?
提前谢谢。
发布于 2017-07-11 09:36:07
df['date'] = pd.to_datetime(df['date'])
df = df.set_index('date')
print(df.groupby('code').resample('D').count().type.unstack('date').fillna(0))
date 2017-06-20 2017-06-21 2017-06-22 2017-06-23 2017-06-25
code
ADFC-64001 4.0 1.0 0.0 0.0 1.0
ADFC-64002 2.0 0.0 0.0 1.0 0.0
ADFC-64003 3.0 2.0 1.0 0.0 0.0数据
date code server type
0 2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
1 2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
2 2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
3 2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
4 2017-06-20 ADFC-64002 nexteesadf_server1 WARNING
5 2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
6 2017-06-20 ADFC-64003 nexteesadf_server1 WARNING
7 2017-06-21 ADFC-64003 nexteesadf_server1 WARNING
8 2017-06-20 ADFC-64002 nexteesadf_server1 WARNING
9 2017-06-20 ADFC-64001 nexteesadf_server1 WARNING
10 2017-06-21 ADFC-64001 nexteesadf_server1 WARNING
11 2017-06-21 ADFC-64003 nexteesadf_server1 WARNING
12 2017-06-22 ADFC-64003 nexteesadf_server1 WARNING
13 2017-06-23 ADFC-64002 nexteesadf_server1 WARNING
14 2017-06-25 ADFC-64001 nexteesadf_server1 WARNING绘图
import matplotlib.pyplot as plt
plt.style.use('ggplot')
df.groupby('code').resample('D').count().type.unstack('date').fillna(0).T.plot()
plt.show()

https://stackoverflow.com/questions/45023889
复制相似问题