方廷睿Python套件CSV比較EXCEL 

import csv                   #輸入csv套件comma separated value
file = open('TWSE.CSV','r',encoding='utf-8')  #打開下載的檔案TWSE.CSV,模式是r讀取,
csvreader = csv.reader(file) #將檔案逐列讀入串列變數csvreader
header, rows = [], []        #宣告空白串列(陣列,清單)
header = next(csvreader)     #串列header存放第一列標題
for row in csvreader:        #逐列讀檔案、附加append於rows串列
   rows.append(row)
file.close()                 #關閉檔案
print(header)
for i in range(6): 
   print('輸出第', i,'公司: ',rows[i-1])
print('方廷睿統計', len(rows))

留言

張貼留言

這個網誌中的熱門文章

方廷睿期末考為Python貪吃蛇增加速度

圖片
from tkinter import * import random GAME_WIDTH,GAME_HEIGHT = 1000, 400 SPEED = 800 #時間單位千分之一 SPACE_SIZE, BODY_PARTS= 50, 3 #左邊變數 assigning value SNAKE_COLOR = ["red","orange","yellow","green","blue","indigo", "purple"] FOOD_COLOR = "white" BACKGROUND_COLOR = "black" class Snake: def __init__(self): self.body_size = BODY_PARTS self.coordinates = [] self.squares = [] for i in range(0, BODY_PARTS): self.coordinates.append([0, 0]) for x, y in self.coordinates: i = random.randint(0,6) square = canvas.create_rectangle(x, y, x + SPACE_SIZE, y + SPACE_SIZE, fill=SNAKE_COLOR[i], tag="snake", width=20,outline='blue') self.squares.append(square) class Food: def __init__(self): x = random.randint(0, int(GAME_WIDTH / SPACE_SIZE)-1) * SPACE_SIZE y = random.randint(0, int(GAME_HE...
閱讀完整內容

方廷睿全域變數global和判斷if

圖片
from tkinter import * #或者import tkinter as tk import math #輸入數學math函式庫 tk = Tk() #建構視窗名為tk tk.geometry('1200x400')#視窗 寬1200像素 tk.title("方廷睿python tkinter三角函數") canvas = Canvas(tk, width=1200, height=400, bg='gray') canvas.grid(row=0,column=0,padx=5,pady=5,columnspan=3) delay=1 # milliseconds, 1/1000秒 x1,y1,z1=0,200,10#python特徵,多變數=對等值 h=190 #上下範圍,相當於數學1到-1 def LH(): global x1, y1, z1#global全球,local當地 x2 = x1 + 1 #換到下個+1 y2=200 - h*math.sin(0.02*x2) z2=200 - h*math.cos(0.02*x2) L1=canvas.create_line(x1,y1,x2,y2,fill='blue',width=20) L2=canvas.create_line(x1,z1,x2,z2,fill='yellow',width=20) if (x2
閱讀完整內容

方廷睿python+tkinter輸入方塊的Return事件

圖片
import tkinter #輸入tkinter繪圖模組 #財金程式設計602 #小於大於 也可以使用字碼 62 class Financial: #類別用於建構504道金融常識題目 def __init__(self, number, q, a, b, c, d, ans): self.number, self.q, self.ans = number, q, ans self.a, self.b, self.c, self.d = a, b, c, d def check(choice): choice = reply.get() #以字串存'1'...'4' temp = number.get() - 1 #題號 if choice == '1': LBa.config(bg="#a4abc1") if choice == List[temp].ans: LBa.config(bg='blue',fg='white') if choice == '2': LBb.config(bg="#a4abc1") if choice == List[temp].ans: LBb.config(bg='blue',fg='white') if choice == '3': LBc.config(bg="#a4abc1") if choice == List[temp].ans: LBc.config(bg='blue',fg='white') if choice == '4': LBd.config(bg="#a4abc1") if choice == List[temp].ans:...
閱讀完整內容