Skip to content
Advertisement

Counts for unique values in pandas

I want to find counts for unique values. Goal is to have df having df.a.value_counts().unique() in one column and in next column their counts.

df.a.value_counts().unique()

.

 array([94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84, 83, 82, 81, 80, 79, 78,
           77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61,
           60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 45, 44,
           43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27,
           26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10,
            9,  8,  7,  6,  5,  4])

.

df.groupby('a').size()

.

    5faac7     94
    5faacc     94
    5faadc     92
    5faaesc    94
    5faaxsc    94
        ..
    e105ba9    94
    25ded 0    55
    7d25de     65
    17d25d9    42
    ba98dd8    10

.

uniques_size_counts= pd.DataFrame(       , columns=["Size", "counts"])

Goal

size  counts 
94    67
93    45
.....

Advertisement

Answer

Apply value_counts once more:

df.a.value_counts().value_counts()
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement