劉于萱pandas describe.excel.percentrank.percentile
import pandas
rows = pandas.read_csv('TWSE.csv',encoding = 'utf-8')
print(rows.head(4))
print(rows['會計師事務所'].describe())
print(rows['員工人數-母公司'].describe())
劉于萱w3school的EXCEL函數
https://www.w3schools.com/excel/excel_functions.php Function Description =AND Returns TRUE or FALSE based on two or more conditions =AVERAGE Calculates the average (arithmetic mean) =AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition =AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditions =CONCAT Links together the content of multiple cells =COUNT Counts cells with numbers in a range =COUNTA Counts all cells in a range that has values, both numbers and letters =COUNTBLANK Counts blank cells in a range =COUNTIF Counts cells as specified =COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition =IF Returns values based on a TRUE or FALSE condition =IFS Returns values based on one or more TRUE or FALSE conditions =LEFT Returns values from the left side of a cell =LOWER Reformats content to lowercase =MAX Returns the highest value in a range =MEDIAN Returns the middle value in the data =MIN Returns the lowe...
可以google到這個網頁,你的截圖太大,會導致看不出重點.https://liuyuhsuan0.blogspot.com/2026/03/excel.html
回覆刪除317.這個截圖必須使用 原始大小 呈現,其他人才可以 查案 到https://liuyuhsuan0.blogspot.com/2026/03/blog-post_16.html