pandas find duplicate values in column code example

Example 1: pandas display all text in column

pd.set_option('display.max_colwidth', -1)

Example 2: find duplicated rows with respect to multiple columns pandas

df = df[df.duplicated(subset=['val1','val2'], keep=False)]
print (df)
   id  val1  val2
0   1   1.1   2.2
1   1   1.1   2.2
3   3   8.8   6.2
4   4   1.1   2.2
5   5   8.8   6.2

Example 3: print duplicates elements in column pandas

mask = df.columnname.duplicated(keep=False)
print (df[mask])

Example 4: python - show repeted values in a column

df = df[df.duplicated(subset=['val1','val2'], keep=False)]

Example 5: how to check for duplicates in a column in python

boolean = df['Student'].duplicated().any() # True

Example 6: pandas count unique values in column

df.nunique()