Find the unique values in a column and then sort them

Question

I have a pandas dataframe. I want to print the unique values of one of its columns in ascending order. This is how I am doing it:

import pandas as pd

df = pd.DataFrame({'A':[1,1,3,2,6,2,8]})

a = df['A'].unique()

print a.sort()

The problem is that I am getting a None for the output.

Answer 1

 You can apply the sorted function which returns a new sorted list from the items in

iterable. Refer the following code:

import pandas as pd

df = pd.DataFrame({'A':[1,1,3,2,6,2,8]})

a = df['A'].unique()

print sorted(a)

OUTPUT

[1, 2, 3, 6, 8]

If you want to learn more about Pandas then visit this Python Course designed by the industrial experts.

 

Answer 2

You can use this one line code also:

print(sorted(df['Column Name'].unique()))