import csv #德明科大洪志坤修改11與16列
f = open('00960.csv','r',encoding='utf-8')
csv_reader = csv.reader(f)
header, rows = [], [] #宣告空白串列(陣列,清單)
header = next(csv_reader) #串列header存放第一列標題
for row in csv_reader: #逐列讀檔案、附加append於rows串列
rows.append(row)
f.close()
idSet = set()
component = dict()
#zeros = [0 for i in range(21)]
for row in rows:
for j in range(0, 21):
idSet.add(row[j*4])
for id in idSet:
component[id] = [0 for i in range(21)] #取代原來的zeros
for row in rows:
for j in range(0, 21):
if row[j*4+3] != '':
component[row[j*4]][j] = row[j*4 + 3]
print(row[j*4+1],component[row[j*4]])
for id in idSet:
print(id, component[id])
STYLE樣式BORDER邊界SOLID實心DASHED虛線DOTTED點線 import csv #輸入import輸出export,輸入csv套件 import math #輸入math套件 from tkinter import * #或者import tkinter as tk Dim = 10 def draw_circle(x, y, label): canvas.create_oval(100+x-5, 700-y-5, 100+x+5, 700-y+5, fill="black") canvas.create_text(100+x+20, 700-y, text = label, anchor='w', font=('微軟正黑體',20)) file = open('台灣.csv','r',encoding='utf-8') read = csv.reader(file) header, rows = [], [] header = next(read) for item in read: rows.append(item) file.close() num = len(rows) #資料表長度 #print(header) mean = [0 for i in range(Dim)]; mean50 = 0; vari50=0 meanTemp = [0 for i in range(Dim)] vari = [[0 for i in range(Dim)] for j in range(Dim)] for k in range(num): for i in range(Dim): meanTemp[i]=float(rows[k][i+1])/100 #轉換為小數 mean[i] += meanTemp[i] for j in range(i+1): vari[i][j] += meanTemp[i]*meanTemp[j] mea...
留言
張貼留言