我正在尝试制作一个数据集文档的透视表,该表对'DocuNum‘的数量进行计数,如果只有'DaysBetween’列小于30,则进行计数。我的数据透视表应该有两列。“DocNum”计数和“Days Between”计数小于30。
DocsPivot = pd.pivot_table(Docs, index = ['Study'], values = ['DocNum',
'DaysBetween'],
aggfunc ={'DocNum':len, 'DaysBetween':lambda x: x<30})
预期结果
TEST DocNum DaysBetween
101 4158 365
203 1958 325
105 1019 243
201 11922 1045
204 1067 56
301 2690 265
发布于 2019-04-25 03:37:02
我想你可以把x<30
改成(x<30).sum()
DocsPivot = pd.pivot_table(Docs, index = ['Test'], values = ['DocNum',
'DaysBetween'],
aggfunc ={'DocNum':len, 'DaysBetween':lambda x: (x<30).sum()})
https://stackoverflow.com/questions/55836338
复制相似问题