Count number of unique values for multiple columns in Python [duplicate]

Question

How to count a number of unique values in multiple columns in Python, pandas etc. I can do for one column using "nunique" function. I need something like:

print("Number of unique values in Var1", DF.var1.nunique(),sep="= ").

For all the variables in the dataset. Something like a loop or apply function maybe. I tried a lot of things failed to get what I desired.

Thanks for the help!

@Dark, yeah, I didn't notice - it was added in Pandas 0.20.0 — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Jan 8, 2018 at 15:31

halfer · Accepted Answer · 2018-05-18 07:37:12Z

5

You want to print number of unique values per column, so use:

for k, v in df.nunique().to_dict().items():
    print('{}={}'.format(k,v))

edited May 18, 2018 at 7:37

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jan 8, 2018 at 15:29

zipa

28k6 gold badges45 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Count number of unique values for multiple columns in Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related