我一直在研究一個分析 CSV 檔案的 Python 專案，但無法讓輸出顯示我的字串的總和，只是應該求和的數字串列。
我正在使用的代碼：
import pandas as pd
data = pd.read_csv('XML_projectB.csv')
#inserted column headers since the raw data doesn't have any
data.columns = ['name','email','category','amount','date']
data['date'] = pd.to_datetime(data['date'])
#Calculate the total budget by cateogry
category_wise = data.groupby('category').agg({'amount':['sum']})
category_wise.reset_index(inplace=True)
category_wise.columns = ['category','total_budget']
#Determine which budget category people spent the most money in
max_budget = category_wise[category_wise['total_budget']==max(category_wise['total_budget'])]['category'].to_list()
#Tally the total amounts for each year-month (e.g., 2017-05)
months_wise = data.groupby([data.date.dt.year, data.date.dt.month])['amount'].sum()
months_wise = pd.DataFrame(months_wise)
months_wise.index.names = ['year','month']
months_wise.reset_index(inplace=True)
#Determine which person(s) spent the most money on a single item.
person = data[data['amount'] == max(data['amount'])]['name'].to_list()
#Tells user in Shell that text file is ready
print("Check your folder!")
#Get all this info into a text file
tfile = open('output.txt','a')
tfile.write(category_wise.to_string())
tfile.write("\n\n")
tfile.write("The type with most budget is " str(max_budget) " and the value for the same is " str(max(category_wise['total_budget'])))
tfile.write("\n\n")
tfile.write(months_wise.to_string())
tfile.write("\n\n")
tfile.write("The person who spent most on a single item is " str(person) " and he/she spent " str(max(data['amount'])))
tfile.close()
CSV 原始資料如下所示（大約有 1000 行）：
Walker Gore,[email protected],Music,$77.98,2017-08-25
Catriona Driussi,[email protected],Garden,$50.35,2016-12-23
Barbara-anne Cawsey,[email protected],Health,$75.38,2016-10-16
Henryetta Hillett,[email protected],Electronics,$59.52,2017-03-20
Boyce Andreou,[email protected],Jewelery,$60.77,2016-10-19
我在 txt 檔案中的輸出如下所示：
category total_budget
0 Automotive $53.04$91.99$42.66$1.32$35.07$97.91$92.40$21.28$36.41
1 Baby $93.14$46.59$31.50$34.86$30.99$70.55$86.74$56.63$84.65
2 Beauty $28.67$97.95$4.64$5.25$96.53$50.25$85.42$24.77$64.74
3 Books $4.03$17.68$14.21$43.43$98.17$23.96$6.81$58.33$30.80
4 Clothing $64.07$19.29$27.23$19.78$70.50$8.81$39.36$52.80$80.90
year month amount
0 2016 9 $97.95$67.81$80.64
1 2016 10 $93.14$6.08$77.51$58.15$28.31$2.24$12.83$52.22$48.72
2 2016 11 $55.22$95.00$34.86$40.14$70.13$24.82$63.81$56.83
3 2016 12 $13.32$10.93$5.95$12.41$45.65$86.69$31.26$81.53
我希望 total_budget 列是每個類別串列的總和，而不是您在此處看到的各個值。對于months_wise來說，這是同樣的問題，它給了我個人的價值，而不是總和。我在寫行中嘗試了 {} .format、.apply(str)、.format，以及幾乎所有其他 Python 排列從我能想到的串列轉換為字串，但我很難過。
我在這里缺少什么？
uj5u.com熱心網友回復：
正如@Barmar 所說，來源有$XX所以它不被視為數字。您可以嘗試按照這種方法將值決議為整數/浮點數而不是其中的字串$。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/337205.html
上一篇：C 多索引列csv加載