具有
datar
,一个重新设计熊猫API的熊猫包装器,我们可以用python翻译您的R代码:
>>> from datar.all import c, f, tibble, select, group_by, summarize, arrange, desc, n
>>>
>>> data = tibble(Item=c("I1", "I2", "I1", "I2", "I2"), Year=c(2015, 2016, 2017, 2014, 2014))
>>> data
Item Year
<object> <int64>
0 I1 2015
1 I2 2016
2 I1 2017
3 I2 2014
4 I2 2014 # add one more item to see if it pops up at the top
>>> top_items = (
... data
... >> select(f.Item, f.Year)
... >> group_by(f.Year, f.Item)
... >> summarize(sales_trend=n())
... >> arrange(desc(f.sales_trend))
... )
[2022-03-17 10:15:54][datar][ INFO] `summarise()` has grouped output by ['Year'] (override with `_groups` argu
ment)
>>> top_items
Year Item sales_trend
<int64> <object> <int64>
0 2014 I2 2
1 2015 I1 1
2 2016 I2 1
3 2017 I1 1
[TibbleGrouped: Year (n=4)]
