#範例11-6：讀取cost.csv，計算總共花費多少錢
import pandas as pd
#df = pd.read_csv('cost.csv',encoding='utf-8-sig')
df = pd.read_csv('cost2.csv',encoding='utf-8')

#印出：說明，支出金額，兩個欄位
print('印出：說明，支出金額，兩個欄位=\n',df[['說明','支出金額']].head(5))
print('印出：說明個欄位=\n',df['說明'].head(5))

#計算總金額
print('花費總金額=', df.sum()['支出金額'])
print('花費總金額=', df['支出金額'].sum())
#依照金額排序
print('依照金額排序=\n',df['支出金額'].sort_values().head(5))
print('依照金額排序=\n',df.sort_values(by='支出金額').head(5))