pandas.query unique values code example

Example 1: pandas unique values in column

#List unique values in the df['name'] column
df.name.unique()

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