您好,我有以下數(shù)據(jù)框。 Group Size Short Small Short Small Moderate Medium Moderate Small Tall Large我想計(jì)算同一行出現(xiàn)在數(shù)據(jù)框中的次數(shù)。 Group Size Time Short Small 2 Moderate Medium 1 Moderate Small 1 Tall Large 1
2 回答

達(dá)令說(shuō)
TA貢獻(xiàn)1821條經(jīng)驗(yàn) 獲得超6個(gè)贊
您可以使用groupby的size:
In [11]: df.groupby(["Group", "Size"]).size()
Out[11]:
Group Size
Moderate Medium 1
Small 1
Short Small 2
Tall Large 1
dtype: int64
In [12]: df.groupby(["Group", "Size"]).size().reset_index(name="Time")
Out[12]:
Group Size Time
0 Moderate Medium 1
1 Moderate Small 1
2 Short Small 2
3 Tall Large 1
添加回答
舉報(bào)
0/150
提交
取消