林姵語python讀取CSV檔案SPDR標普500ETF在1993/1/29至2025/3/20 

#林姵語python程式碼分析spy:標準500ETF
import csv #輸入套件csv=comma seperated value                     #輸入csv套件comma separated value
file = open('SPY.CSV','r')     #打開下載的檔案SPY.CSV,模式是r讀取,
csvreader = csv.DictReader(file) #將檔案讀入變數csvreader
for row in csvreader:       #檔案接續逐列附加append於rows串列
#    print(row)
    print(row['日']+' 當天收盤價 '+row['收'])
file.close()            #關閉檔案
#上一個作業讀近來放成串列list,直接讀成字典

留言

  1. George2025年6月30日 清晨5:53

    確實執行python.https://linpeiyud11117127.blogspot.com/2025/06/pythoncsvtkintermarkowitz.html
    https://linpeiyud11117127.blogspot.com/2025/06/listdictrandom.html
    沒有影片！https://linpeiyud11117127.blogspot.com/2025/05/2025power.html
    https://linpeiyud11117127.blogspot.com/2025/05/powerpoint1mp41mp4.html
    https://linpeiyud11117127.blogspot.com/2025/05/csv.html
    https://linpeiyud11117127.blogspot.com/2025/04/pythoncsv.html
    https://linpeiyud11117127.blogspot.com/2025/04/500spy.html
    https://linpeiyud11117127.blogspot.com/2025/03/pythoncsvspdr500etf19931292025320.html

    回覆刪除

張貼留言

這個網誌中的熱門文章

林姵語python運算CSV輸出TKINTER投資風險與報酬Markowitz

圖片
關鍵程式碼 def draw():#按下按鈕button1執行draw canvas.create_line(0,500,700,500,width=3,fill='black',arrow='last') canvas.create_line(10,600,10,5,width=3,fill='black',arrow='last') for firm in firms: t=(firm, year.get()) x = 10+20*stdev[t]*2*3**0.5 #放大20 y = 500 - 10*mean[t]*12 #放大10 dot=canvas.create_oval(x-5,y-5,x+5,y+5,fill='blue') lab=canvas.create_text(x+10,y,text=firm[4:7],anchor=W,font=('微軟中黑體', 16)) def delete():#按下按鈕button2執行delete canvas.delete('all') years=[x for x in range(2007, 2025)] year=IntVar(tk) year.set(years[0]) label = Label(tk, text="年度",font=('Arial',30,'bold'),).pack(side=LEFT) #距離左側 option1 = OptionMenu(tk, year, *years).pack(side=LEFT) button1 = Button(tk, text="林姵語繪圖 ",font=('Arial',30,'bold'), command = draw, bg='black',fg='white').pack(side=LEFT) button2 = Button(tk, text="林姵語刪除...
閱讀完整內容