我想绘制在X轴和值在Y轴 日期我能得到它一次一个。 X轴或Y轴。我希望他们在一个图中。
我已经试过这样的事情:
import pandas as pd
from pandas import Series, DataFrame, Panel
from mysql.connector import MySQLConnection, Error
from python_mysql_dbconfig import read_db_config
import matplotlib.pyplot as plt
dbconfig = read_db_config()
conn = MySQLConnection(**dbconfig)
cur = conn.cursor()
df_mysql = pd.read_sql('SELECT PO_Date,PO_Total FROM purchase_order',con=conn)
print df_mysql
po_dates = df_mysql.ix[:,0]
po_total = df_mysql.ix[:,1]
X = Series(po_total,index=po_dates)
X.plot()
plt.show()
conn.close()
如何将这些2列绘制在一起吗?