计算列的唯一值并存储在新列中

2024-03-29 00:33:39 发布

您现在位置:Python中文网/ 问答频道 /正文

# Dummy df.
data = [
  [11, 'a'],
  [11, 'b'],
  [10, 'c'],
  [9, 'd'],
  [1, 'e'],
  [1, 'f']
]
column_name = ['freq', 'recordings']

df = pd.DataFrame(data, columns=column_name)

打印df

freq     id
  11      a
  11      b
  10      c
  9       d
  1       e
  1       f

我想看看freq的每个值存储了多少次。期望输出:

 df = 

freq     recordings
  11      2
  10      1
   9      1
   1      2

Tags: columnsnameiddataframedfdatacolumndummy
1条回答
网友
1楼 · 发布于 2024-03-29 00:33:39
data = [
    [11, 'a'],
    [11, 'b'],
    [10, 'c'],
    [9, 'd'],
    [1, 'e'],
    [1, 'f']
]
column_name = ['freq', 'recordings']

df = pd.DataFrame(data, columns=column_name)

解决方案:

from collections import Counter
Counter(df.freq)

输出:

Counter({11: 2, 10: 1, 9: 1, 1: 2})

相关问题 更多 >