/Python/Pandas count distinct values in column

Pandas count distinct values in column

Return count of unique values pandas

#TO count repetition of each unique values(to find How many times the same-
# unique value is appearing in the data)

item_counts = df["Your_Column"].value_counts()
#Returns Dictionary => {"Value_name" : number_of_appearences}

How to get distinct value in a column dataframe in python

df.column.unique()

Source: chrisalbon.com

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

Source: stackoverflow.com

Values of unique from dataframe with count

data = df.groupby('ColumnName')['IDColumnName'].nunique()
print(data)

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

Source: stackoverflow.com

Pandas count distinct values in column

#column name ISSDTM
pd.to_datetime(df.ISSDTM, errors='coerce').dt.year

#result
0    2013
1    2013
2    2009
3    2009
Name: ISSDTM, dtype: int64

-1

Source: stackoverflow.com

Similar codes

0 vote206 views1 answer
Python getpass save file
Python
1 vote211 views2 answers
AttributeError: module 'yaml' has no attribute 'load_all'
Python
3 votes241 views1 answer
Django admin prefetch_related
Python Django
0 vote196 views1 answer
Python Remove Character from String using replace()
Python
0 vote196 views1 answer
Python set remove if exists
Python
57 votes202 views6 answers
Print current date and time in python
Python
10 votes195 views3 answers
Replace nan with mean
Python
109 votes204 views6 answers
Python string contains substring
Python
0 vote202 views1 answer
Print numbers from 1 to 100 in python
Python
0 vote214 views1 answer
Robinhood python api
Python