【对比python】对分组结果排序 | 润乾 -欧洲杯在线开户
任务：找出人数最多和最少的两个部门
python
| 1 | import pandas as pd |
| 2 | emp_file = 'e:\\txt\\employee.txt' |
| 3 | emp_info = pd.read_csv(emp_file,sep='\t') |
| 4 | emp_g = emp_info.groupby(by='dept') |
| 5 | size = emp_g.size().sort_values() |
| 6 | sorted_dept = size.index.values |
| 7 | print(sorted_dept[[0,-1]]) |
集算器
|
|
a |
|
|
1 |
e:\\txt\\employee.txt |
|
|
2 |
=file(a1).import@t() |
|
|
3 |
=a2.group(dept).sort(~.len()).m([1,-1]).(~.dept) |
|
集算器分组排序筛选一行搞定