Skip to content

Instantly share code, notes, and snippets.

@AFutureD
Last active January 16, 2020 03:39
Show Gist options
  • Save AFutureD/a46549047c43ab22a0770288001a472c to your computer and use it in GitHub Desktop.
Save AFutureD/a46549047c43ab22a0770288001a472c to your computer and use it in GitHub Desktop.
pandas sort within DFgroupby
JPEG_INFO.groupby(['plant','classes']).count()
path. id
plant classes
小麦 小麦_叶锈病 94 94
小麦_壳针孢叶斑病 47. 47
小麦_散黑穗病 492. 492
小麦_条锈病 1837. 1837
小麦_白粉病 1071. 1071
小麦_纹枯病 398. 398
小麦_赤霉病 305. 305
小麦_除草剂药害 436. 436
小麦_黄斑叶枯病 118. 118
JPEG_INFO.groupby(['plant']).apply(lambda x: (x.groupby('classes')
.agg({'id':len})
.sort_values('id', ascending=False)))
id
plant classes
小麦 小麦_条锈病 1837
小麦_白粉病 1071
小麦_散黑穗病 492
小麦_除草剂药害 436
小麦_纹枯病 398
小麦_赤霉病 305
小麦_黄斑叶枯病 118
小麦_叶锈病 94
小麦_壳针孢叶斑病 47
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment