提供在df外操作的解法
df =pd.read_excel("C:\\Users\\Administrator\\Downloads\\1604632491_331249.xlsx")
ls = list(df['金额'].loc[df['标识'] == 1])
dic = {}
intervals = {'0-5':0,'5-20':0,'20-50':0,'50-{}'.format(max(ls)):0}
for _ in ls:
for i in intervals:
star,end = tuple(i.split('-'))
if int(star) < _ <= int(end) :
intervals[i] += 1
print(intervals)
