pandas get all unique rows code example

Example 1: get list of unique values in pandas column

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

Example 2: unique rows in dataframe

In [33]: df[df.columns[df.apply(lambda s: len(s.unique()) > 1)]]
Out[33]: 
   A  B
0  0  a
1  1  b
2  2  c
3  3  d
4  4  e