在panda中创建包含基于多个百分位条件的数据的新列

import pandas as pd

# 创建示例DataFrame
data = {
    'value': [10, 20, 30, 40, 50, 60, 70, 80, 90, 100]
}
df = pd.DataFrame(data)

# 计算百分位数
percentiles = [25, 50, 75]
quantiles = df['value'].quantile(percentiles).tolist()

# 创建新列
df['condition'] = ''
for i, q in enumerate(quantiles):
    if i == 0:
        df.loc[df['value'] <= q, 'condition'] = f'<= {q}'
    elif i == len(quantiles) - 1:
        df.loc[df['value'] > q, 'condition'] = f'> {q}'
    else:
        df.loc[(df['value'] > quantiles[i-1]) & (df['value'] <= q), 'condition'] = f'({quantiles[i-1]}, {q}]'

print(df)

   value condition
0     10   <= 25.0
1     20   <= 25.0
2     30  (25.0, 50.0]
3     40  (25.0, 50.0]
4     50     50.0
5     60  (50.0, 75.0]
6     70  (50.0, 75.0]
7     80  (75.0, 100.0]
8     90  (75.0, 100.0]
9    100     > 75.0