Skip to main content
 首页 » 编程设计

Python 对 CSV 进行排序和求和

2025年04月02日15bluestorm

我有这样的 CSV 文件:

Datetime, Usage1, Project1
Datetime, Usage2, Project1
Datetime, Usage3, Project2
Datetime, Usage4, Project3

目标是汇总每个项目的使用情况并生成如下报告:

Project1: Usage1 Usage2

Project2: Usage3

Project3: Usage4

我从以下 Python 代码开始,但它无法正常工作:

#/usr/bin/python 
 
# obtain all Project values into new list project_tags: 
 
project_tags = [] 
ifile = open("file.csv","r") 
reader = csv.reader(ifile) 
headerline = ifile.next() 
for row in reader: 
    project_tags.append(str(row[2])) 
ifile.close() 
 
# obtain sorted and unique list and put it into a new list project_tags2 
project_tags2 = [] 
for p in list(set(project_tags)): 
    project_tags2.append(p) 
 
 
# open CSV file again and compare it with new unique list 
ifile2 = open("file.csv","r") 
reader2 = csv.reader(ifile2) 
headerline = ifile2.next() 
 
# Loop through both new list and a CSV file, and if they matches sum it: 
 
sum_per_project = sum_per_project + int(row[29]) 
for project in project_tags2: 
    for row in reader2: 
        if row[2] == project: 
            sum_per_project = sum_per_project + int(row[1]) 

欢迎任何意见!

提前致谢。

请您参考如下方法:

尝试以下代码段:

summary = {} 
 
with open("file.csv", "r") as fp: 
    for line in fp: 
        row = line.rstrip().split(',') 
 
        key = row[2] 
        if key in summary: 
            summary[key] += (row[1].strip(),) 
        else: 
            summary[key] = (row[1].strip(),) 
 
for k in summary: 
    print('{0}: {1}'.format(k, ' '.join(summary[k]))) 

根据您在 csv 文件中的示例数据,它将打印:

 Project1: Usage1 Usage2 
 Project2: Usage3 
 Project3: Usage4