unique values with count of each value for each column in Pandas dataframe

Question

How can I get unique values with count of each value for each column in a pandas dataframe using for loop:

Following code gives me count of each unique value for each column but I want the values as well.

import pprint

col_uni_val={}
for i in data.columns:
    col_uni_val[i] = len(data[i].unique())

pprint.pprint(col_uni_val)

For example:

I want my output as :

A:
1 - 2
2 - 3
3 - 1

B:
4 - 2
6 - 4

Also since my number of columns is huge can i do this using indexed loop.

MaxU - stand with Ukraine · Accepted Answer · 2018-02-15T14:24:44.537

2

Demo:

In [351]: d
Out[351]:
   A  B
0  1  4
1  1  4
2  2  6
3  2  6
4  2  6
5  3  6

In [352]: res = {col:d[col].value_counts() for col in d.columns}

In [353]: res['A']
Out[353]:
2    3
1    2
3    1
Name: A, dtype: int64

In [354]: res['B']
Out[354]:
6    4
4    2
Name: B, dtype: int64

edited Feb 15 '18 at 14:24

answered Feb 15 '18 at 14:11

MaxU - stand with Ukraine

205,989
36
386
419

Thanks for the answer but this gives me the same result as above. – Coder Feb 15 '18 at 14:16
@Coder, please provide a small sample data set and your desired data set – MaxU - stand with Ukraine Feb 15 '18 at 14:17
I want my result to be like: a: 2-6, 1-2, 4-1, 0-1 (count of each value in column) – Coder Feb 15 '18 at 14:18
@Coder, please put a sample input and desired data sets into your question... – MaxU - stand with Ukraine Feb 15 '18 at 14:19
@MaxU perhaps it is applying value_counts over columns, if it isn't what OP wanted please reopen the question. – Bharath M Shetty Feb 15 '18 at 14:20
@MaxU Thanks above code works fine for me :) – Coder Feb 15 '18 at 14:28

unique values with count of each value for each column in Pandas dataframe

1 Answers1