/Python/How to Find Unique Values in a Column in Pandas

How to Find Unique Values in a Column in Pandas

Dataframe unique values in each column

for col in df:
    print(df[col].unique())

Source: stackoverflow.com

How to Find Unique Values in a Column in Pandas

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'fruits': ['orange', 'mango', 'apple', 'grapes', 'orange', 'mango'],
                   'price': ['40', '80', '30', '40', '30', '80'],
                   'quantity': ['200', '300', '300', '400', '200', '800']
                   })

# get the unique value of column fruits
print(df.fruits.unique())

Source: itsmycode.com

Get list of unique values in pandas column

a = df['column name'].unique() #returns a list of unique values

Find and count unique values of a single column in Pandas DataFrame

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'fruits': ['orange', 'mango', 'apple', 'grapes', 'orange', 'mango'],
                   'price': ['40', '80', '30', '40', '30', '80'],
                   'quantity': ['200', '300', '300', '400', '200', '800']
                   })

# get the count unique values of column fruits
print(df.fruits.value_counts())

Source: itsmycode.com

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

Find unique values in all columns in Pandas DataFrame

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'fruits': ['orange', 'mango', 'apple', 'grapes', 'orange', 'mango'],
                   'price': ['40', '80', '30', '40', '30', '80'],
                   'quantity': ['200', '300', '300', '400', '200', '800']
                   })

# get the unique value of all columns
for col in df:
  print(df			
							
		.unique())

Source: itsmycode.com

Similar codes

3 votes329 views1 answer
Create virtual env pyhton3
Python
0 vote319 views2 answers
Generate random string with special characters and numbers in python
Python
12 votes335 views6 answers
Print variable python
Python
0 vote422 views1 answer
Can a function output be save as a variable python
Python
1 vote339 views1 answer
How to set gui position tkinter python
Python
6 votes333 views3 answers
Python list add first
Python
0 vote347 views1 answer
"PyGTK" python setup.py egg_info Check the logs for full command output.
Python
1 vote419 views1 answer
Django class based views ListView
Python Django
-1 vote334 views3 answers
Sum of multiples of 3 or 5 python
Python
0 vote362 views1 answer
How to earn money as a python developer
Python