如何从CSV文件中每行值数目可变的列中提取数据？

Question

基本上，我尝试将csv文件中同名项列的count列值相加。然后我需要按项目列值按字母升序对结果进行排序。例如：

Leading Cause, Deaths
Diabetes Mellitus, 123
Influenza and Pneumonia, 325
Diabetes Mellitus, 100

我需要将值123和100相加，得到糖尿病的新行。你知道吗

应该是这样的：
Diabetes Mellitus, 223。你知道吗

这是我目前掌握的代码：

import csv
import sys

with open(sys.argv[1], 'r') as File:
    reader = csv.reader(File)
    itemindex = sys.argv[2]
    countindex = sys.argv[3]
    item column = 0
    count column = 0
    first row = True
    dictionary = {}

    for row in reader:
       if firstrow == True:
          firstrow = False
          itemcolumn = row.index(itemindex)
          countcolumn = row.index(countindex)
       else:
           if item column in dictionary:
               # Add the item at the row's count column (converted to an int) to the
               # prexisting entry with that item column.
           else:
               #create a new entry in the dictionary

       print(itemindex + "," + countindex)

for key, value in sorted(dictionary)
    print(key + "," + value)

评论的部分就是我一直坚持的部分。你知道吗

Answer 1

您可以尝试不使用提供的库，而只是将数据作为文本进行循环。分析文本。你知道吗