如何在列表中计算文件中的费用并将其更改为tuple(python)

def calculate_expenses(filename):
    d= {}
    file_pointer = open(filename, 'r')
    data = file_pointer.readlines()
    for line in data:
        line = line.strip().split(',')
        my_item = line[0].strip()
        my_price = float(line[1].strip())

        if my_item not in my_dictionary:
            d[my_item] =  my_price
        else:
            d[my_item] +=  my_price
    l= []
    my_keys = sorted(d.keys())
    for x in my_keys:
        l.append((x,"${0:.2f}".formatd[x])))
    return l

如果你不反对使用熊猫:

import pandas as pd

df = pd.DataFrame.from_csv('text.csv',index_col=None,header=None)
df[0] = df[0].apply(lambda x:x.strip())
df = df.groupby(0).sum().reset_index()
mylist = zip(df[0],map(lambda x: '${:.2f}'.format(x),df[1]))

def calculate_expenses(filename):
    #your dict of results :
    dres={}
    file_pointer = open(filename, 'r')
    data = file_pointer.readlines()
    f=[]
    f2=[]
    for i in data:
        x=i.split(',')
        a=x[0].strip()
        b=x[1].strip()
        a=a.strip('\n')
        b=b.strip('\n')
        if a not in dres:
            dres[a]=0
        dres[a]+=float(b)
        f2=[]
        #outputting the correct format : as an array of tuples
        for k in dres.keys():
            f2+=[(k,'${:.2f}'.format(dres[k]))]
    return f2
filename='text.CSV'
print(calculate_expenses(filename))