Time,Name,State
2011/6/14 22:45,M1,ON
2011/6/15 8:06,M1,OFF
2011/6/15 8:09,M4,ON
2011/6/15 8:09,M4,OFF
2011/6/15 8:14,M4,ON
2011/6/15 8:14,M4,OFF
2011/6/15 8:45,M3,ON
2011/6/15 8:45,M3,OFF
2011/6/15 10:23,M3,ON
2011/6/15 10:23,M3,OFF
2011/6/15 10:24,M2,ON
2011/6/15 11:12,M2,OFF
2011/6/15 13:15,M2,ON
2011/6/15 14:03,M2,OFF
2011/6/15 14:03,M1,ON
2011/6/15 15:21,M1,OFF
2011/6/15 15:23,M2,ON
2011/6/15 15:46,M2,OFF
2011/6/15 15:46,M4,ON
2011/6/15 15:46,M4,OFF
2011/6/15 16:01,M4,ON
2011/6/15 16:01,M4,OFF
2011/6/15 17:05,M2,ON
2011/6/15 18:12,M2,OFF
2011/6/15 19:12,M4,ON
2011/6/15 19:12,M4,OFF
2011/6/15 19:15,M2,ON
2011/6/15 20:54,M2,OFF
2011/6/15 22:35,M1,ON
2011/6/16 8:07,M1,OFF
2011/6/16 8:10,M4,ON
2011/6/16 8:10,M4,OFF
2011/6/16 8:15,M4,ON
2011/6/16 8:16,M4,OFF
2011/6/16 8:47,M3,ON
2011/6/16 8:47,M3,OFF
2011/6/16 10:32,M3,ON
2011/6/16 10:32,M3,OFF
2011/6/16 10:35,M2,ON
2011/6/16 11:18,M2,OFF
2011/6/16 13:17,M2,ON
2011/6/16 14:05,M2,OFF
2011/6/16 14:05,M1,ON
2011/6/16 15:23,M1,OFF
2011/6/16 15:25,M2,ON
2011/6/16 15:49,M2,OFF
2011/6/16 15:47,M4,ON
2011/6/16 15:47,M4,OFF
2011/6/16 16:07,M4,ON
2011/6/16 16:07,M4,OFF
2011/6/16 17:08,M2,ON
2011/6/16 18:21,M2,OFF
2011/6/16 19:18,M4,ON
2011/6/16 19:18,M4,OFF
2011/6/16 19:17,M2,ON
2011/6/16 20:59,M2,OFF
2011/6/16 22:57,M1,ON
2011/6/17 8:15,M1,OFF
数据集是这样的,根据线性时间序列排列的传感器开关,M1-M4为传感器名称,ON/OFF为开/关,现想用python数据可视化展示为如下图所示,无论ON/OFF都标注在上面
请问该如何实现呢
望采纳
import pandas as pd
import matplotlib.pyplot as plt
data = pd.read_excel('传感器.xlsx')
print(data)
x=data['Time']
y=data['Name']
z=data['State']
plt.scatter(x,y,s=10,marker='o',color='r',edgecolors='k')
plt.gcf().autofmt_xdate()
for a,b,c in zip(x,y,z):
plt.text(x=a,y=b,s=c,fontdict={'family':'Kaiti','color':'k','size':'10'})
plt.show()