a function that prints out information on duplicate rows in a pandas DataFrame

find_duplicated.py

import pandas as pd

def find_duplicated(dataframe, show=True, sort=False):
    """
    prints out information on duplicate rows
    :param dataframe: a pandas DataFrame
    :param show: boolean; if True, the duplicated rows (if any) are shown
    :param sort: boolean; if True, the duplicated rows are sorted by each column
                 of the dataframe
    """
    n_duplicates = dataframe.duplicated().sum()
    print('Number of duplicated rows: {}'.format(n_duplicates))
    if show and n_duplicates > 0:
        print()
        duplicated_df = dataframe[dataframe.duplicated(keep=False)]
        if sort:
            print(duplicated_df.sort_values(list(duplicated_df.columns)))
        else:
            print(duplicated_df)