对excel两行IP地址重复次数计算的一次算法设计

1.原始数据

 2.算法设计

import csv

def list21csv(csv_l):
    file_path='re.csv'

    try:
        fp = open(file_path, 'w')
        for items in csv_l:
            for i in range(len(items)):
                # 若元素中含有逗号，那么需要加双引号
                if items[i].find(',') != -1:
                    fp.write('\"')
                    fp.write(items[i])
                    fp.write('\"')
                else:
                    fp.write(items[i])
                # 最后一个元素不用加逗号
                if i < len(items) - 1:
                    fp.write(',')
            fp.write('\n')
    except Exception as e:
        print(e)

if __name__ == '__main__':
    file = open("test.csv",encoding="gbk",errors="ignore")
    fileReader = csv.reader(file)
    filedata = list(fileReader)
    #print(filedata[1][1])
    csv_list = [['data']]
    j=0
    c=0
    for i in filedata:
        n=0
        for k in filedata:
            if(filedata[j][1]==k[1] and filedata[j][4]==k[4]):
                #print(filedata[j][1])
                n=n+1
            
            c=c+1
        print(filedata[j][1],n)
        a=str(n)
        csv_list.append([a])
        j=j+1
    #print(j)

    list21csv(csv_list)

 3.算法统计出的结果