打开Excel表格把里面某一列所有相同的按顺序排列在下面行，不同的用空行隔开

import pandas as pd

def clean_col(df, col_name):
    col = df[col_name]
    col_unique = sorted(df[col_name].unique())
    for item in col_unique:
        item_df = df[col == item]
        if item_df.shape[0] == 1:
            continue
        else:
            for i in item_df.index:
                if i != item_df.index[0]:
                    df.at[i, col_name] = ''
    return df

df = pd.read_excel('xxx.xlsx', sheet_name='Sheet1')
col_name = 'xxx'
clean_col(df, col_name)
df.to_excel('xxx.xlsx', sheet_name='Sheet1', index=False)