pandas

实现没有头的scv重复值相加，第三列写出现次数 

import pandas as pd
import numpy as np
file_name = 'F:\迅雷云盘'
file_path = r"F:\迅雷云盘\test1.csv"
df = pd.read_csv(file_path, header=None)
lis = df.values.tolist()


dic = {}
for i in lis:
    if i[0] in dic:
        dic[i[0]].append(i[1])
    else:
        dic[i[0]] = [i[1]]

lis2 = []
for d in dic:
    data = dic.get(d)
    value = np.sum(data)

    if len(data) > 1:
        lis2.append([d, value, len(data)])
    else:
        lis2.append([d, value])


def insert_csv(datas):
    df = pd.DataFrame(datas)
    path = '{}/生成.csv'.format(file_name)
    print('生成路径：' + path)
    df.to_csv(path, header=None,  index=None, encoding="GBK")

insert_csv(lis2)

生成结果不带头，不带索引