当行之间日期在指定的时间限制内时如何合并行

import pandas as pd

# 示例数据
data = {
    'start_date': ['2023-01-01', '2023-01-05', '2023-01-10', '2023-01-15'],
    'end_date': ['2023-01-04', '2023-01-09', '2023-01-14', '2023-01-20'],
    'value': [10, 20, 30, 40]
}

df = pd.DataFrame(data)
df['start_date'] = pd.to_datetime(df['start_date'])
df['end_date'] = pd.to_datetime(df['end_date'])

# 合并行
merged_df = df.copy()
for i in range(len(df)):
    current_row = df.iloc[i]
    for j in range(i+1, len(df)):
        next_row = df.iloc[j]
        if current_row['end_date'] >= next_row['start_date']:
            merged_df.at[i, 'end_date'] = max(current_row['end_date'], next_row['end_date'])
            merged_df.at[i, 'value'] += next_row['value']
            df = df.drop(j)
            break

print(merged_df)