# 读取excel的数据并可视化分析
import pandas as pda
import numpy as npy
import matplotlib.pylab as pyl
data = pda.read_excel(r'D:\news_cloud\test\数据分析与数据挖掘\test.xlsx')
shape = data.shape # 查看表里数据有多少行多少列
# data = data.values # [第几行][第几列] 得到numpy原始的数据
data2 = data.T #转置
#转置后数据
x = data2.values[2]
y = data2.values[3]
# pyl.plot(x,y)
# pyl.show()
x1=data2.values[0]
pyl.plot(x1,y)
pyl.show()
print(x)
