问一个python很基础的问题

cnleon

想用Matplotlib进行绘图，可recod我通过print可以展示出来，可为什么画出的图就跟附件那样的呢

db=MySQLdb.connect(host="192.168.2.2",user="root",passwd="abcroot",db="dbt2")
c=db.cursor()
c.execute("""select s_i_id,s_w_id from stock order by s_i_id limit 30;""")
result = c.fetchall()

for record in result:

        print record[0]
        print record[1]
        print '####'
        plot(record[0], record[1], 'r', linestyle='-')
        axis([0, 30, 0, 30])
        title("select")
        savefig('plot.png',dpi = (80))

luffy.deng

回复 1# cnleon

1. result =[[11,15],[12,19],[14,23],[15,26],[20,29]]
   
2. x = [r[0] for r in result]
   
3. y = [r[1] for r in result]
   
4. plot(x,y, color='r', linestyle='-', marker='o', markerfacecolor='blue')
   
5. axis([0, 30, 0, 30])
   
6. title("select")
   
7. savefig('plot.png',dpi = (80))
   

复制代码

cnleon

回复  cnleon
luffy.deng 发表于 2010-04-19 16:12

这个看明白了，谢谢了