程式交易期末考104繳交作業
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]) 
 修改前
修改後
網址 https://www.youtube.com/watch?v=G5hdGlCkDhM

留言

  1. George2026年7月2日 晚上8:06

    0703.https://526917698.blogspot.com/2026/07/import-csv-1116-f-open00960.html?lr=1783047958342

    回覆刪除

張貼留言

這個網誌中的熱門文章

圖片
  https://youtu.be/4YC6eDymx9Q?si=YFKwNGiXc5UR9nCC 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]*mea...
閱讀完整內容