林品萱Python_HTML_CSS

import pandas rows = pandas.read_csv('TWSE.csv',encoding = 'utf-8') print(rows.head(4)) print(rows['會計師事務所'].describe()) print(rows['員工人數-母公司'].describe()) print(rows['實收資本額(元)'].describe())

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) n= len(rows) print('上市公司數目', n) for i in range(n): print(i+1,'家公司',rows[i][6]) accountant=set() for i in range(n):accountant.add(rows[i][6]) print('林品萱使用集合set統計會計師',len(accountant))