想象一下，我有一個(gè)名為“國(guó)家”的數(shù)據(jù)框，其中包含多個(gè)列，包括國(guó)家及其各自的特質(zhì)。Country IdiosyncraciesBrazil We love footballFrance We love loveItaly We love PizzaItaly We love PizzaItaly We love GellatoBrazil We love festivalsItaly We love PizzaFrance We love breadFrance We love breadFrance We love breadItaly We love GellatoItaly We love PizzaBrazil We love football對(duì)于每個(gè)國(guó)家，我想將模式響應(yīng)（特質(zhì)）提取到另一個(gè)數(shù)據(jù)幀中，如下所示Country Top comment Brazil We love football France We love bread Italy We love Pizza 這是我試過(guò)的一段代碼grouped = countries('Country')['Idiosyncracies'].mode()[0])但是，我沒(méi)有得到 (3,2) 數(shù)據(jù)幀，而是收到一條錯(cuò)誤消息TypeError: 'DataFrame' object is not callable
1 回答
交互式愛(ài)情
TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個(gè)贊
使用GroupBy.apply與Series.iat用于選擇第一個(gè)值：
df = (countries.groupby('Country')['Idiosyncracies']
.apply(lambda x: x.mode().iat[0])
.reset_index())
print (df)
Country Idiosyncracies
0 Brazil We love football
1 France We love bread
2 Italy We love Pizza
添加回答
舉報(bào)
0/150
提交
取消