python字符串出现次数最多的_python – Pandas：获取组中出现次数最多的字符串值...

使用

value_counts并返回第一个索引值：

df["responseCount"] = (df.groupby("item")["response"]

.transform(lambda x: x.value_counts().index[0]))

print (df)

item response responseCount

0 1 A A

1 1 A A

2 1 B A

3 2 C C

4 2 C C

from collections import Counter

df["responseCount"] = (df.groupby("item")["response"]

.transform(lambda x: Counter(x).most_common(1)[0][0]))

print (df)

item response responseCount

0 1 A A

1 1 A A

2 1 B A

3 2 C C

4 2 C C

编辑：

问题是只有一个或多个NaN组,解决方案是使用if-else过滤：

print (df)

item response

0 1 A

1 1 A

2 2 NaN

3 2 NaN

4 3 NaN

def f(x):

s = x.value_counts()

print (s)

A 2

Name: 1, dtype: int64

Series([], Name: 2, dtype: int64)

Series([], Name: 3, dtype: int64)

#return np.nan if s.empty else s.index[0]

return np.nan if len(s) == 0 else s.index[0]

df["responseCount"] = df.groupby("item")["response"].transform(f)

print (df)

item response responseCount

0 1 A A

1 1 A A

2 2 NaN NaN

3 2 NaN NaN

4 3 NaN NaN