删除pandas数据框中列值不连续出现的行

import pandas as pd

# 读取数据框
df = pd.read_csv('data.csv')

column_name = 'column_name'  # 列名

df['count'] = df.groupby(column_name)[column_name].transform('count')

condition = df['count'] > 1  # 出现次数大于1的行
rows_to_delete = df[condition]

df = df.drop(rows_to_delete.index)

df = df.drop('count', axis=1)

import pandas as pd

# 读取数据框
df = pd.read_csv('data.csv')

# 确定需要删除的列和条件
column_name = 'column_name'

# 创建一个新的列，表示每个值在该列中的出现次数
df['count'] = df.groupby(column_name)[column_name].transform('count')

# 根据条件筛选出需要删除的行
condition = df['count'] > 1
rows_to_delete = df[condition]

# 删除选定的行
df = df.drop(rows_to_delete.index)

# 删除添加的计数列
df = df.drop('count', axis=1)

# 打印结果
print(df)