王怡庭微軟ACCESS查詢SQL語法ASC上升DESC下降

评论

发表评论

此博客中的热门博文

王怡庭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="王怡庭刪除...
阅读全文

王怡庭python陣列array

图片
w3schools陳列截圖 w3schools陳列程式碼 #王怡庭陳列w3schools練習 #for x in 'Takming gold': #迴圈逐字字元 # print("字母: %s" % x) fruits = ['台積電', '鴻海', '聯發科'] for x in fruits: # 迴圈印出元素 print ("當前公司: %s"% x) print ("append") #append在末尾增加 fruits.append("中華電") #append接元素 print(fruits) print("移除所有元素clear") fruits.clear() #Removes all the elements from the list print(fruits) fruits = ['台積電', '鴻海', '聯發科',"中華電"] print(fruits) pig = fruits.copy() print("輸出pig用copy方法" + str(pig)) print("使用copy和直接賦予值 pig = fruits有何不同? ") dog = fruits print("輸出dog直接=" + str(dog)) print("fruits.extend(pig)") fruits.extend(pig) #extend接陣列或清單 print(fruits) fruits.extend(['台塑化','台達電','富邦金']) print(fruits) #print("幾個台積電? " + str(fruits.count("台積電))) print(fruits.index("富邦金")) fruits.insert(10,"國泰金") print(fruits) pr...
阅读全文