按子字符串条件排序数据帧，不包括相似字符串

import pandas as pd

def sort_dataframe_by_substring_condition(dataframe, substring):
    # 筛选包含特定子字符串的字符串
    filtered_dataframe = dataframe[dataframe['column_name'].str.contains(substring)]

    # 对筛选后的字符串进行排序
    sorted_dataframe = filtered_dataframe.sort_values(by='column_name')

    return sorted_dataframe

# 示例数据帧
data = {'column_name': ['apple', 'banana', 'orange', 'grape', 'pineapple']}
df = pd.DataFrame(data)

# 按子字符串条件排序数据帧，不包括相似字符串
substring = 'an'
sorted_df = sort_dataframe_by_substring_condition(df, substring)

print(sorted_df)