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.
JavaScript
x
2
1
df.a.value_counts().unique()
2
.
JavaScript
1
7
1
array([94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84, 83, 82, 81, 80, 79, 78,
2
77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61,
3
60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 45, 44,
4
43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27,
5
26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10,
6
9, 8, 7, 6, 5, 4])
7
.
JavaScript
1
2
1
df.groupby('a').size()
2
.
JavaScript
1
12
12
1
5faac7 94
2
5faacc 94
3
5faadc 92
4
5faaesc 94
5
5faaxsc 94
6
..
7
e105ba9 94
8
25ded 0 55
9
7d25de 65
10
17d25d9 42
11
ba98dd8 10
12
.
JavaScript
1
2
1
uniques_size_counts= pd.DataFrame( , columns=["Size", "counts"])
2
Goal
JavaScript
1
5
1
size counts
2
94 67
3
93 45
4
..
5
Advertisement
Answer
Apply value_counts
once more:
JavaScript
1
2
1
df.a.value_counts().value_counts()
2