数据如下:
DATE | VALUE | |
1987/1/1 | 3.4 | |
1987/2/1 | 3.2 | |
1987/3/1 | 3.1 | |
1987/4/1 | 3.6 | |
1987/5/1 | 3.2 | |
1987/6/1 | 3.1 |
# -*- coding: UTF-8 -*-
import matplotlib.pyplot as plt
import pandas
dt=pandas.read_excel("matplotlibTest.xlsx",delimiter="\t")
dt['DATE']=pandas.to_datetime(dt['DATE'])
print(dt.head(3))
plt.plot(dt['DATE'],dt['VALUE'])
plt.xlabel("Month")
plt.ylabel("Number")
plt.title("aaaa")
plt.xticks(rotation=45)
plt.show()
输出:
D:\python\python.exe D:/warkspace/pythonTest/com/Matplotlib1.py DATE VALUE0 1987-01-01 3.41 1987-02-01 3.22 1987-03-01 3.1