import os
import re
import difflib
import pandas as pd
import threading
import numpy as np
#读入数据
data=pd.read_csv(r"C:\Users\Administrator\Desktop\26263.csv",header=0,encoding = 'gb2312')
print(data)
#遍历每行,加1
list_tongji = []
for index, row in data.iterrows():
sjc = row['sjc'] #之前没有这一行时一直说sjc没有定义
list_tongji.append([sjc, 1])
#列表转df定义列名称
df_tongji = pd.DataFrame(list_tongji,columns=['τ/分钟','M(τ)'])
print(df_tongji)
#求和
df_tongji_sum = df_tongji.groupby(['τ/分钟'], as_index=False)['M(τ)'].sum()
print(df_tongji_sum)
#保存
df_tongji_sum.to_csv(r"C:\Users\Administrator\Desktop\26263统计.csv", index=False)
datafrme按某列分类并统计每类数量
最新推荐文章于 2024-07-25 16:09:30 发布