Answers for "count distinct values in excel sheet pandas"

1

get count of unique values in column pandas

df = df.groupby('domain')['ID'].nunique()

print (df)
domain
'facebook.com'    1
'google.com'      1
'twitter.com'     2
'vk.com'          3
Name: ID, dtype: int64
Posted by: Guest on May-28-2020
4

how to count number of unique values in a column python

pd.value_counts(df.Account_Type)

Gold        3
Platinum    1
Name: Account_Type, dtype: int64
Posted by: Guest on June-04-2020
0

how to count unique values in a column dataframe in python

dataframe.column.nunique()
Posted by: Guest on May-30-2020

Code answers related to "count distinct values in excel sheet pandas"

Python Answers by Framework

Browse Popular Code Answers by Language