用python处理excel表格进行分组统计_python中excel数据分组处理

采用pandas包首先进行分组，然后获取具体明细再进行分词处理(分词处理这里就不展开了)，只介绍下python下excel分组，然后对具体明细进行处理。

2.1 完整代码

import pandas as pd

if __name__ == '__main__':

inputfile = '软件老王-source.xlsx'

data = pd.read_excel(inputfile)

grp1 = data.groupby('待分类列')

rcount = 1

for name, group in grp1:

print(group)

name = name.replace('\n', '').replace('/', '')

for i in range(len(group)):

row = group.iloc[i].values  # 返回一个list

cell = row[1]

if cell is None:

continue

if not isinstance(cell, str):

continue

item = cell.strip('\n\r').split('\t')

string = item[0]

if string is None or len(string) == 0:

continue

else:

print('这里获取group后明细值，软件老王可以单独处理，类别：' +name + '具体值：' + string)

转自：https://blog.csdn.net/wjg8209/article/details/104481584?ops_request_misc=%257B%2522request%255Fid%2522%253A%252216003196491972525