問一個python很基礎(chǔ)的問題

cnleon

想用Matplotlib進(jìn)行繪圖，可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

回復(fù) 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))
   

復(fù)制代碼

cnleon

回復(fù)  cnleon
luffy.deng 發(fā)表于 2010-04-19 16:12

這個看明白了，謝謝了